';BEGIN' error

weichaoyang · Post by **weichaoyang** » Fri 11 Jul 2008 06:03

hi,
database: mysql 4.018
delphi7, kylix
When i execute then command ApplyUpdates on ClientDataSet. It show me with
You have an error in your SQL syntax. Check the manual that corresponds to you MySQL server version for the right syntax to use near '; BEGIN' at line 1.
but, I use delphi7 owner dbexpress, no error.
how can i do.
developer license number is CRDBM-01127.
thanks.

Antaeus · Post by **Antaeus** » Fri 11 Jul 2008 08:33

I could not reproduce the problem.
Please send me a complete small sample at dbxmda*crlab*com to demonstrate it, including script to create and fill table.
Also specify the exact version of DbxMda.

weichaoyang · Post by **weichaoyang** » Fri 11 Jul 2008 09:35

Hi,
Delphi 7/ Kylix 3
mysql 4.0.18
MDA 4.20.8
I use the demo program provided by yours. connect to mysql , OK, open table , OK, but when i change field's value, execute applyupdates(-1), error.
thanks.

Antaeus · Post by **Antaeus** » Fri 11 Jul 2008 12:31

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next build of DbxMda.

weichaoyang · Post by **weichaoyang** » Sat 12 Jul 2008 00:50

what time is the next build of DbxMda?
i buy your product, but i can't use it. how can i do?

Antaeus · Post by **Antaeus** » Mon 14 Jul 2008 06:22

We are going to release the new DbxMda build during this week.

fritsr · Post by **fritsr** » Thu 07 Aug 2008 21:44

I have seen the same error in my ASP.NET application. Just logging in with a wrong password gives me the same error.
I have now replaced version 4.20.0.8 of dbexpmda40.dll with the previous 4.20.0.7 version. This seems to work better.

trashbox · Post by **trashbox** » Thu 18 Sep 2008 21:26

Please, this support really works?
I've just downloaded the trial version and I have the same problem related in Jul 11, 2008 ('; Begin' error).

As I can see in the history page, there's no update for this.
I was about to buy the product, but...

I'm using Turbo Professional with trial dbexpmda30.dll.

Thanks...

Dimon · Post by **Dimon** » Fri 19 Sep 2008 08:09

This fix will be included in the next build of DbxMda, that will be released at the beginning of the next week.