General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only