General information
Category:
Forms & Form designer
Title:
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only