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

[Chris Crowe]

Thanks Nevan,      I have basically just created a new component called TAdrockCCTable which works great no code changes, except for the FindKey, and I was I suppose being lazy. I can use locate with just a bit of extra code.   Chris    -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Neven MacEwan Sent: Friday, 4 January 1980 17:29 To: Multiple recipients of list delphi Subject: Re: [DUG]: ADO Express Table - FindKey not supported 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