Hello,

Im having troubles to make a table1.locate('codigocliente',myvariable,[]);
This do not work with TADOTable connected to an SQL SERVER 2000 with the
options:

CursorLocation = clUseServer
CursorType = Dynamic

I need to open a  table with more than 1.000.000 records, so i use this
options to open it faster, with the lack of locate or any other search
method to easly find data and move cursor to any row.

Any body knows how can i do to handle such volume of records from server
side and use locate, filters or any other faster method to find data ?????

Thanks!!! and merry christmas for all comunity!!!.

--
German Casais
Desarrollo de Software
gcas...@dpsautomation.com

DPS
Tel: (54-11) 4521-6402 Ext. 111
www.dpsautomation.com
Dr. Pedro Ignacio Rivera 4919
(C1431BVI) Buenos Aires - Argentina

Do not open the table with 1,000,000 records, open a query instead with
something like:

SELECT * FROM orders
WHERE orderNo = 9000

--
Mike
http://www.adoanywhere.com
m...@adoanywhere.com
Developers of ADO Support Tools and
Remote Data Access Systems