I am, thanks alot. I do have another question that hopefully you can shed some light on or lead me in the right direction.
I notice that the FIRST time I do a SELECT from the foxpro command window using either a remote view, ADO or DSN connection that it appears foxpro sequentially goes through the entire remote SQL database. I say this because the FIRST select on the database is slower and I can see the counter in the status bar iterate through the entire table. After the first select, subsequent selects are fast and I do not see the counter.
If I quit foxpro, the process starts over, that is, the initial select does the above. I checked my index on the SQL side and they are their. Even the most simple select does this.
Any insight?
Thanks,
bob
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