Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLEXEC
Message
From
24/10/1997 15:00:33
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
SQLEXEC
Miscellaneous
Thread ID:
00056591
Message ID:
00056591
Views:
67
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
Next
Reply
Map
View

Click here to load this message in the networking platform