Grid Refresh after delete
Hi there,
after I delete a row in my table I want my DataGrit to be refreshed.
The deleting works fine in db, but the old record is still in the DataGrid:
DataEnvironment1.Connection1.Execute (sql_string)
DataEnvironment1.Connection1.Execute ("commit")
DataEnvironment1.rsCommand1.Requery
DataGrid1.Refresh
What is the mistage ???
regards
Stephan
Re: Grid Refresh after delete
What kind of recordset you use?
I think though your db has updated, but because you use connection to do the update, recordset has not be updated. And your grid is related to recordset, so...
Re: Grid Refresh after delete
I used:
DataEnvironment1.rsCommand1.Requery
to refresh my recordset
regards
Stephan