MyDac 5.0.4 and Delphi 7 - Get error in myClasses.pas - line 2547

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
pjungersen
Posts: 6
Joined: Mon 11 Dec 2006 17:39

MyDac 5.0.4 and Delphi 7 - Get error in myClasses.pas - line 2547

Post by pjungersen » Mon 09 Apr 2007 16:04

I get the following error(see below) - when try to access a small query from the buildin editor.
If i just select active = true in at the propertie window - is works.
If i make small changes to the SQL, ex write a X in the sql - execute, get an error , remove the X then it works, but if i leave the build in editor, the i have to do the X trick again.

This is the error message i get - i have tried to remove every think from my 4.40 verision - as descript at this forum.
Error

Assertion failure (D:\Project\Delphi\MyDac\Source\MyClasses.pas, line 2547

My version of MyDac are 5.0.4
My delphi i 7.0
Runing Windows XP - sp2
MySql server running 5.0.24 runing on Linux

At current i working on small sample to see if i can reproduce the problem

/Per

Jackson
Posts: 512
Joined: Thu 26 Jan 2006 10:06

Post by Jackson » Tue 10 Apr 2007 13:26

Please specify the SQL statement that you use.

pjungersen
Posts: 6
Joined: Mon 11 Dec 2006 17:39

Post by pjungersen » Wed 11 Apr 2007 05:40

EvgeniyM wrote:Please specify the SQL statement that you use.
simple

----------
select * from table
where
field = :var
----------

What i do - is make a myQuery1 there

select distinct afield from table.

and then i make an other myQuery2 there

select * from table
where afield = :afield

In parameter : Set afield to be String and select a value ex. "07111"

Then i make a myDatasource1 to myQuery1 and set masterdatasource at myQuery2 to myDatasource1, and masterfield to afield

Then dobbelt click at myQuery2 - and select Execute or Data Editor, then the errors showsup

- then at a char after select in myQuery2, click execute again - you will get an error - remove the char after select - and then click data editor - and now you get the rigth answer.

I have this in a small sample code i send to you (6kb) in a zip file
this code has been sent to support email address

/Per

Jackson
Posts: 512
Joined: Thu 26 Jan 2006 10:06

Post by Jackson » Thu 12 Apr 2007 09:46

Thank you for your sample. It did help us very much.
We have reproduced the problem and fixed it.
This fix will be included in the next build of MYDAC 5.

Post Reply