>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

Can you be more specific please? How much records are you retreiving? What is the DB?