Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Getting data from another datasession
Hello all,
I have a datasession delima. I have a cursor that I create from SPT to an Oracle table that has a listing of about 27000 codes. It takes approximately 3 to 4 seconds on my slowest PC to select the records. I wish to use these codes in a lookup. Here is the delima.
My lookup form uses a Private Datasession. I do not want to have to query this table via SPT every time the form is loaded. I would prefer to query the Oracle table once and then query the VFP cursor when the form is loaded. Quering the VFP cursor takes less than a second.
Here is what I wish to do.
1. Select the Data from the oracle table via SPT once when the application starts and place the Cursor in the default datasession (1).
2. When the lookup form is displayed (private datasession) Select the data from the VFP Cursor in the Public datasession into a cursor in my lookup form's private datasession.
How can I do this?
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