Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can i make speed to capture data from tables
Message
From
15/11/2003 05:26:07
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00848051
Message ID:
00850207
Views:
21
Hi William,

thank you very much for your help but i found the way, your idea to make index i did it but it was not work will.

but i made PRG file to make a connection with another database system and after that create a remote view and the result was WOW unbeleivable just write which value you need it to search then Ooops less than 1 second for a remote view table contains 157000 records

and these are the statements if you need it:

lcconnstr="driver=;server=;uid=;pwd=;DSN=" && you will find it from ODBC
lnrc=SQLSTRINGCONNECT(lcconnstr)

CREATE CONNECTION name of the connection DATASOURCE lcconnstr

CREATE SQL VIEW name REMOTE CONNECTION name of the connection as SELECT TableConnection.field;...;....;....

and thank you again
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform