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

gonzamax

New Member
Licensed User
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

Administrator
Staff member
Licensed User
CommandText is just a string, so you should use '&' to insert a variable inside:
B4X:
 cmd.CommandText = "DELETE from gaz WHERE ROWID = " & idrow1
 
Top