TDBNavigator and delete
lazarus / 16-Databases

----------------------------------------------------------------------
Fabio · 2012-04-14 14:29

Hi all, I've searched in the forum and with Google with no result.

I'm new on Lazarus and I'm trying to use SQLite with
TSQLQuery/TDBGrid/TDBNavigator.

I've problem when I try to delete a record with the button "minus" of
navigator.
The record in grid is deleted but when I call the ApplyUpdates I get
the error: "no delete query specified and failed to generate one".

How can I delete a record?
I must use the AfterDelete event of navigator?

Thanks (sorry for my poor english).

----------------------------------------------------------------------
xinyiman · 2012-04-16 09:39

Here's an example that reproduces the error. If anyone would know how
to fix a favor to me! thanks


http://www.lazaruspascal.it/esempi/Sqlite.zip

----------------------------------------------------------------------
ludob · 2012-04-16 10:19

SQlQuery1 has Upda]"]>Blockedde set to upWhereKeyOnly but you do a
'select Nome FROM T_Prova;' which does not contain a key. Change SQL
to 'select * FROM T_Prova;' or change Upda]"]>Blockedde to
upWhereChanged or upWhereAll.

----------------------------------------------------------------------
Fabio · 2012-04-16 11:45

Good, I've changed my SQL from "SELECT ... FROM ..." to "SELECT * FROM
..." and deletion done.

Thanks.