ApplyUpdate: Command out of sync.

[Chris]

Hi,

I just try to build an application to use dbexpress to access mysql by C++
builder 6 professional. I used TSQLConnection, TSQLTable, TDataSetProvider,
TClientDataSet, TDBGrid and TDBNavigator. at first when I delete or modify
some records in the DBGrid, it didn't update the real data in the database.
so I use the function "ApplyUpdates" of TClientDataSet, but it always throw
a exception as following,

"Commands out of sync, you can't run this command now."

Does anyone know the reason? Thanks.

chris

[Ross Davis]

There is a serious bug in the mysql dbexpress driver. We didn't run into
until we had a project half completed. It started to show up when we had
about 4 or 5 nested tables.

We finally had to purchase the odbc driver from easysoft to solve the
problem. This isn't the solution that I want, but borland has got us by the
balls by not releasing the source for that driver. This is serious bug that
can be duplicated on more than one machine.

I would like to get this problem resolved and go back to the dbexpress
driver, but until the bug is fixed and we get the source I can't use it
because we can't be held ransom.

Ross

"Chris" <chri...@hotmail.com> wrote in message news:3d0f5647$1_2@dnews...