I want to delete a row in the base according from the data in the column.... when i use this code
it works ok, it deletes only one row.... but when i use
and in edit1 are written value from column1 by click in edit1 is written value by column2 by click.... if in the grid i have 6 rows and i select the first row and then delete it it works, but when i select the last row and I delete, then the whole table is deleted... where is the problem here ?
Code:
DELETE FROM Table WHERE Column1=1 AND Column2=1
Code:
DELETE FROM Table WHERE Column1 LIKE '%" + Edit->Text + "%' AND Column2 LIKE '%" + Edit1->Text + "%'";