';BEGIN' error

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for MySQL in Delphi and C++Builder
Post Reply
weichaoyang
Posts: 7
Joined: Fri 11 Jul 2008 04:40

';BEGIN' error

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
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

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
Posts: 7
Joined: Fri 11 Jul 2008 04:40

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
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

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
Posts: 7
Joined: Fri 11 Jul 2008 04:40

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
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Mon 14 Jul 2008 06:22

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

fritsr
Posts: 22
Joined: Tue 30 Oct 2007 03:49

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
Posts: 1
Joined: Thu 18 Sep 2008 21:20

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
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

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.

Post Reply