Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.

Welcome, Guest
Guest Settings

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
charles leggette

Posts: 45
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
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02