Could not directly access MySQL
lazarus / 16-Databases

----------------------------------------------------------------------
andieyudha · 2008-01-22 11:53

Hi, i'm a newbie on Lazarus... I've tried to made some simply
application on it using MySQL as a Database. I have ;

1. TMySQLConnection
2. TSQLTransaction
3. TSQLQuery
4. TDataSource
5. TDBGrid

Everything is connected, and I've seen all rows on my TDBGrid, I tried
to INSERTED, DELETED rows directly from TDBGrid and seems OK, but when
i checked it from MySQL, that's nothing happened with my rows...
There's no new rows..., Rows that i deleted is still there. I could
figured it out. Somebody gimme your hand please... Thank's.

----------------------------------------------------------------------
ssamayoa · 2008-01-22 22:08

Did you commit?

----------------------------------------------------------------------
andieyudha · 2008-01-23 01:56

Quote from: "ssamayoa"Did you commit?

Thank's for your respons "ssamayoa". I don't understand
with your statement "did you commit". If you mean COMMIT
is the choice of TSQLQuery.Transaction.Action = 'caCommit'
my answer is yes. And i also tried with another option of
choices... caCommitRetaining, caNone,caRollback, and
caRollbackRetaining.
The result is same... there's no change on my rows.

Shoud i send my project to you ???

Thank's GBU