ryan_sabarre
asked on
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?
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?
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.
I am using zeos components and I do not use FlushBuffer also, but some times I use refresh after post
ASKER
I am using mySQL engine "innoDB".
ASKER
By the way, how will i know if my connection from the mySQL server was lost?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER