Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Issuing A SQL Statement in a form
When a SQL statement is issued and the results directed into a table, what happens when the statement is run more than once? I have a grid which uses as its source a table generated by a SQL statement. When a record within the grid is selected, another form is launched which works with the data generated by the SQL statement. Upon returning to the initial form, I run the SQL statement again so the grid will reflect the changes made to the data. When I do this however, the grid is blank and nothing is displayed. Have I somehow created a second table when the SQL statement is run again?
Thanks in advance,
Carmen
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