Problem in Saving MySQL table records using POST

I tried the ff codes
  myTtable.Post;
  myTtable.Flushbuffers;
It failed in myTtable.Flushbuffers, is this not supported with mySQL?

Is there any other way Saving/POSTing records permanently in the Table?
ryan_sabarreAsked:
Who is Participating?
 
kretzschmarCommented:
>It failed in myTtable.Flushbuffers, is this not supported with mySQL?

>Is there any other way Saving/POSTing records permanently in the Table?

Flushbuffers is meant for desktop-databases, specially paradox and dbase,
mySQL is a serverbased SQL-Database and cannot handled like a desktop-database

to keep your inserts permanent into the table the easiest would be to set the autocommit-feature set to on
--------------------------------------------------
14.2.10.2. InnoDB and AUTOCOMMIT
In InnoDB, all user activity occurs inside a transaction. If the autocommit mode is enabled, each SQL statement forms a single transaction on its own. By default, MySQL starts new connections with autocommit enabled.

If the autocommit mode is switched off with SET AUTOCOMMIT = 0, then we can consider that a user always has a transaction open. A SQL COMMIT or ROLLBACK statement ends the current transaction and a new one starts. A COMMIT means that the changes made in the current transaction are made permanent and become visible to other users. A ROLLBACK statement, on the other hand, cancels all modifications made by the current transaction. Both statements release all InnoDB locks that were set during the current transaction.

If the connection has autocommit enabled, the user can still perform a multiple-statement transaction by starting it with an explicit START TRANSACTION or BEGIN statement and ending it with COMMIT or ROLLBACK.

--------------------------------------------------

additional i would advice you to learn SQL, so that you will become experience with using of queries
(which is rather recommended to use instead of TTable by SQL-Databases)

meikl ;-)
0
 
ryan_sabarreAuthor Commented:
Thanks in advance.
0
 
Graham9295Commented:
How are you connecting to your MySQL table ? For example as you using an ODBC connection or a component ? I am using MyDAC with Delphi 2006 and whilst I have never tried to use the Flushbuffers procedure I have never had any problems with posting records to a MySQL table.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
tammozCommented:
I am using zeos components and I do not use FlushBuffer also, but some times I use refresh after post
0
 
ryan_sabarreAuthor Commented:
I am using mySQL engine "innoDB".
0
 
ryan_sabarreAuthor Commented:
By the way, how will i know if my connection from the mySQL server was lost?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.