Watch, Follow, &
Connect with Us

Please visit our new home
community.embarcadero.com.


Welcome, Guest
Guest Settings
Help

Thread: TADOTable connected to Sql Server doesn't recognize IndexName


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 0 Threads: [ Previous | Next ]
charles leggette

Posts: 43
Registered: 7/17/00
TADOTable connected to Sql Server doesn't recognize IndexName  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 17, 2017 4:23 AM
I originally posted this to C++ BLDR IDE forum but received to answer.

I dropped a TADOTable control on form to access a MS SQL SVR table and in control, as well as in code, set IndexName='PlanName'...but when active tPlans[the table] does not honor the index.See partial list below. I verified Index definition and its correct.

1025,ALABAMA ORTHO CLINIC Retirement Plan Analysis,2017-10-15
1025,Drisko, Fee and Parkins Retirement Plan,2012-09-25
1025,Morton Manufacturing Retirement System,2016-12-13
1025,Pension Solutions Corp,LLC Retirement Plan Analysis,2012-11-20
1025,USPIZZA Retirement Plan,2012-09-21
1025,DePalma & Associates,2013-03-06
1172,Robert C Rosenberg,PC,2015-03-03
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02