dbnavigator
lazarus / 16-Databases

----------------------------------------------------------------------
Hansvb · 2015-09-11 19:41

With the dbnavigator i want to delete the active record in a dbgrid.
The buttons first next prior and last work without any code behind it.
to insert a record i had to add the next lines:

Code: [Select]  case Button of
  nbPost   : begin
               SQLQuery1.Upda]"]>Blockedde:=UpWhereChanged;
               SQLQuery1.ApplyUpdates;
             
 DataModule_Oracle_Connection.OracleConnection1.Transaction.Commit;// 
CommitRetaining
             end;


i hoped that the same code would work when i want to delete a record
but then i get the warning:

SQLQUERY1: No delete query specified and failed to generate one.

Must i write a delete query?

----------------------------------------------------------------------
LacaK · 2015-09-13 07:01

Quote from: Hansvb on September 11, 2015, 09:41:39 pmSQLQUERY1: No
delete query specified and failed to generate one.

Must i write a delete query?
Did you have written SQLQUERY1.UpdateSQL also ?
What is your SQLQUERY1.SQL.Text (is there single table in select or
multiple tables joined) ?

----------------------------------------------------------------------
Hansvb · 2015-09-13 10:43

It is a single table with one column as a test.  Now i have made my
own insert, delete, commit and rollback button. I skipped the
dbnavigator.

----------------------------------------------------------------------
LacaK · 2015-09-14 06:10

probably SQLQuery can't determine key field. Is this one field
declared also as primary key on table ?