Information générale
Catégorie:
Gestionnaire d'écran & Écrans
Titre:
SQL statement if Form.Load won't update grid
Established a View in a DBC, which I am then using as the source for a grid. Put the following SQL statement in the load event of the form and put a "refresh()" in the .init of the grid:
crea sql view rostcursql AS SELECT * FROM rostcur WHERE ssn LIKE;
oRegParm.cssn NOFILTER (all one line in the form)
Worked OK last night, but I CAN'T get it to put anything in the "rostcursql" view today! The view was created as updateable.
I am going to want to add and/or delete records from the underlying table after I get this to work. Should I do the Select-SQL to a cursor instead of a view and then do a "use again", as I have seen mentioned on UT, or is the view in the DBC the better approach? Any ideas on how to get this to work, and what the best approach is?
TIA. This is drivin' me up a wall.
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