Hi Bob,
I will try to give you more information. I have a table on the server with about 50,000 records. In my local DBC, I have a remote view on the table (NOTE: I also have tried the following example using a connection and by going to the ODBC driver directly).
The table name is ptmast. It has a field called name. When I fire up foxpro, open the dbc, and execute:
SELECT * FROM ptmast WHERE name LIKE "S%" (or any character), the first time this is executed I get a wait window which says "Executing remote..." and at the bottom of the VFP window in the status bar I see a record counter which counts through ALL RECORDS (ALL 50,000). The next time I execute this query, EVEN IF I CHANGE THE WHERE CLAUSE, i.e.
SELECT * FROM ptmast WHERE id = 1234234
SELECT * FROM PTMAST WHERE dob = {10/15/2000}
SELECT * FROM PTMAST WHERE name LIKE "C%"
they all execute immediately (I do not see the "executing remote" nor to I see a counter in the status bar.
The question is what in the hell is foxpro doing the first time I execute a query on the table?
Also, I was incorrect in saying that it only did it once per foxpro session. If I close all tables and rexecute the query, the first time I query the table it counts. It is almost like it is building a local index or something along those lines.
Thanks for the info
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement