Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
I have a table that contains data for several customers. I want to display this data on a form "B" only customer the selected customer on form "A". I thought I could create a cursor to do this in form "B" based on a customer number sent to form "B" from form "A". This is from the init of form "B":
PARAMETERS currentcustno
SELE * from cashtemp INTO CURSOR curCustWithCash where custno = currentcustno
The grid on form "B" that used to directly read the table cashtemp has been changed to read the cursor. The RecordSource of the grid is now set to curCustWithCash instead of cashtemp. I have checked and the cursor is populated with the correct number of records, but for some reason the data is not getting to the grid. In the dataenvironment, the cashtemp is there, but I think I am missing something with the cursor.
Any ideas?
Randy Wessels
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