General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Nadya
I have done just that and it has worked fine, thank you. So I guess I don't have to set up a View. Should this code be run before every update to the query cursor, it seems like it should.
Regards,
Carmen
>>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
>
>In order to avoid this problem you have to do:
>
>this.grid.RecordSource="
>select ... into myTable
>this.grid.RecordSource = 'myTable'
Previous
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