Delete a row in a table and simultaneously delete it in the database

[gonzamax]

Hello,

I have a table which is filled in by a database and I want to delete data in the database, after I have selected a row in the table.

I give you the code of my SQL request

Con.New1
Cmd.New1("",con.Value)
Con.Open("Data Source = " & AppPath & "\relevegeneraux.sl3")
cmd.CommandText = "DELETE from gaz WHERE ROWID = idrow1"
Cmd.ExecuteNonQuery
Con.Close

I don't know how to make idrow1 appear as a variable in the request.

Thank You

 

[Erel]

CommandText is just a string, so you should use '&' to insert a variable inside:

 cmd.CommandText = "DELETE from gaz WHERE ROWID = " & idrow1

 

[gonzamax]

Thank you very much