Devart Forums

Hello,

Create tables:

CREATE TABLE `table1` (
`Code` tinyint(4) NOT NULL default '0',
`Description` char(50) default NULL,
PRIMARY KEY (`Code`)
) ;

INSERT INTO `table1` (`Code`, `Description`) VALUES
(1,'Desc 1');

CREATE TABLE `table2` (
`Code` tinyint(4) NOT NULL default '0',
`Description` char(50) default NULL,
PRIMARY KEY (`Code`)
);

INSERT INTO `table2` (`Code`, `Description`) VALUES
(1,'Desc 2');


Put as SQL in Myquery:
SELECT t2.Description FROM table1 t1
LEFT JOIN table2 AS t2 ON t1.Code=t2.Code

Opening MyQuery work.
Put MyQuery.Options.DefaultValues:=True
After opening you get error :
#4202S Table 'test.t2' doesn't exists.

Regards,
Pedja

I can not reproduce the problem.
Please, try to download the latest MyDAC build (5.80.0.47) and check if this problem still exists.

I already using the latest MyDac.
Try with Mysql server 4.1.22

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

Hi Dimon,

when you expect to have next build ready for download?

Regards
Pedja

The MyDAC build will be released by the end of the next week.