Grid Refresh after delete

[StephanM1]

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

[anniel]

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...

[StephanM1]

I used:
DataEnvironment1.rsCommand1.Requery

to refresh my recordset

regards
Stephan