Re: [DUG]: ADO Express Table - FindKey not supported

[Neven MacEwan]

Chris   ADO is a pure SQL implementation - so the concept of opening a table with an explicit Key doesn't apply It's great that Locate works - (which never worked in a TQuery though exposed ... a great frustration)   I suppose to replicate findkey you'd have to extract the ordering fields and use locate - but remember that TADOTable (and TADOQuery and TADOStoredProc only exist to give familiar components (and make porting "easier") but they all derive from TADOCustomDataSet so you are probably all better to port to a single derivative of this and go thru the pain once rather continually discover these subtle and not so subtle probs - I would not expect it to be a simple component renaming exercise   I'm in holiday so the a above comp names may not be correct   Regards Neven   ----- Original Message ----- From: Chris Crowe To: Multiple recipients of list delphi Sent: Monday, January 10, 2000 3:46 PM Subject: [DUG]: ADO Express Table - FindKey not supported I have used FindKey in my database applications, and have noticed that the TADO Table does not support findkey. it does however support Locate, but locate requires the actual fields to search for the values in.   What can I do simulate the FindKey method of the TTABLE component? and keep the same syntax as FindKey?   Chris