Searching for records in a TADOTable table

From: Brian Wheatley (brianpw_at_bscales.com)
Date: 07/06/04 

Date: Tue, 6 Jul 2004 11:44:05 -0400

Hello,

With a TTable component I can call MyTable.FindKey([]) or MyTable.EditKey /
MyTable.GotoKey to locate a specific record using the selected index.

Is there any way to do this using the TADOTable component? I found a Seek
method, but there was a note in the Delphi documentation:

"Note: The VCL Seek method is a direct implementation of the Seek method for
the ADO Recordset object. At the time of this writing, this method is only
supported for use with Microsoft Access2000 and the Jet 4 provider."

In some cases we may be connecting to an Access 2000 database, but more
often than not we'll connect to MS SQL Server, and on a rare occassion
Oracle.

I need to be able to see if the record exists, then either append or update
the record.

Any help would be greatly appreciated.

Sincerely,
Brian Wheatley