[SOLVED] update sqlite record in dbgrid

[koloth]

Helloi all,
I'm building a small db app using sqlite to familiarize myself with lazarus db components, being a delphi developer for some years before.
I've ran into to the following issue:
In order to replicate the ttable control, i'm using a tquery containing a select * of the table in question.
However although  the dbgrid displays the data correctly, every change i make is not submitted to the DB after closing the app.
autoedit is enabled on  the dataset, i've tried committing the transaction and applyupdates from the query.
Can someone point me to the proper way of updating a table using the dbgrid?

thank you

[LacaK]

Try read for example: http://wiki.freepascal.org/SqlDBHowto and related tutorials ...

[koloth]

Try read for example: http://wiki.freepascal.org/SqlDBHowto and related tutorials ...

Thanks for the reply, I had already read that but i'm glad i was on the right track...
If my understanding is correct i have to create a custom update script for the query, is there a guideline for that too?

tx a lot

[mangakissa]

No, that's not true. Only if you using joins in your table it's necessary using updateSQL.
The most important thing is the following procedures:
- post
- applyupdate
- commit(retaining)

[koloth]

No, that's not true. Only if you using joins in your table it's necessary using updateSQL.
The most important thing is the following procedures:
- post
- applyupdate
- commit(retaining)

On which dbgrid event should the procedure be applied to?

thank you..

[LacaK]

On which dbgrid event should the procedure be applied to?

I would use TDataSet.AfterPost event. Not any TDBGrid event!

[koloth]

I would use TDataSet.AfterPost event. Not any TDBGrid event!
[/quote]
In't it a bit weird to run :

Code: [Select]

- post
- applyupdate
- commit(retaining)
in the afterpost event? will it ever run?

[LacaK]

Of course not "Post" in "AfterPost" event handler.

DB-aware controls like DBGrid or DBNavigator are calling Post.
Which is okay.

But I would use remaining 2 calls "ApplyUpdates" and "Commit" in AfterPost (best in DataModule)

So you will have isolated "presentation of data" (forms) and "background data manipulation/interaction with database")

[koloth]

thanks for your help guys, finally nailed it!

moving on to updating joined queries...