Information générale
Titre:
VFP5 OLE DLL - Selects into cursor
In VFP5.0a, I compiled an OLE DLL with 2 selects. The first selects from an indexed table of 300,000 records into a cursor. The select is fast. I then need to select from the cursor. I get an error saying the cursor I am selecting from must be created with "SELECT... INTO TABLE". This is good and everything, but selecting from the original table into a file, greatly decreases the speed because now it has to write the resulting file physically to a table where before it was just a subset of the larger table. Has anyone been able to get around this and not lose any speed?
TIA,
Garritt
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