I am using the SQLEXEC() to select all records from a Btrieve table
into a cursor. The speed at which it runs is not acceptable. 45sec -
1.5 min. to load the cursor over a Novell 3.12 network. The syntax
used is:
lnHandle =SQLSTRINGCONNECT('DRIVER={Pervasive Software ODBC-32};
DDFPATH=G:\Macola\data;')
lnResults=SQLEXEC(lnHandle, SELECT
FROM
ARVENFIL','vendors')
Any ideas on who to speed this up or a faster approach.
Thanks
Andy Roth
Neyenesch Printers
619 297 2281
andyroth@electriciti.com