Devart Forums

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

Please specify the SQL statement that you use.

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

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.