TDBNavigator and delete

[Fabio]

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]

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]

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]

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

Thanks.