Link to home
Start Free TrialLog in
Avatar of ryan_sabarre
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?
Avatar of ryan_sabarre
ryan_sabarre

ASKER

Thanks in advance.
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
I am using mySQL engine "innoDB".
By the way, how will i know if my connection from the mySQL server was lost?
ASKER CERTIFIED SOLUTION
Avatar of kretzschmar
kretzschmar
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial