Hi,
I use MyDAC 3.30.1.13 with Borland C++ 6 and MySQL 4.1.7. When I edit MyTable and then call connection's ApplyUpdates (or table's Post() when cache is disabled), I get "You have an error in your SQL syntax" error. The query is, for example:
UPDATE project SET Archived=:8 WHERE :8(Boolean,IN)=True
The server seems to reject the ":8 WHERE :8(Boolean,IN)=True" part of the query. What's the problem? Is the MySQL server misconfigured or is it MyDAC bug?
Thank you, regards
Pawel Sobocinski
SQL syntax error on ApplyUpdates()
Re: SQL syntax error on ApplyUpdates()
Post please script to create table.
To create table, I use TMyQuery and following SQL statement:
Regards,
Pawel
Code: Select all
CREATE TABLE `tpm`.`project` (
`IntID` FLOAT UNSIGNED NOT NULL AUTO_INCREMENT,
`ID` VARCHAR(20) NOT NULL,
`Name` VARCHAR(50) NOT NULL,
`Description` VARCHAR(200) NOT NULL,
`DirName` VARCHAR(200) NOT NULL,
`Suspended` BOOLEAN NOT NULL,
`Closed` BOOLEAN NOT NULL,
`Archived` BOOLEAN NOT NULL,
`CustomerIntID` FLOAT UNSIGNED NOT NULL,
`CustomerName` VARCHAR(150) NOT NULL,
PRIMARY KEY(`IntID`),
INDEX `CustomerIntIDIndex`(`CustomerIntID`)
) TYPE = InnoDB COLLATE Default;
Pawel