Program freezes on 'ORDER BY'

[nayamda]

Hi,

we use the zeos library V6.5.1 and FireBird V1.5.
In order to sort a Query in a german format, so that ä comes after a and not after z, I set the charset of the db to ISO8859_1.

In IBExpert the Query 'SELECT NAME FROM TABLE ORDER BY NAME' returns the values in the correct order.
But if I try to open a TZQuery with this SQL statement my program freezes.

the debug mode stops first in file ZDbcInterbase6Utils, procedure TZParamsSQLDA.UpdateBoolean(const Index: Integer; Value: boolean);
Line 1856

...
raise EZIBConvertError.Create(SUnsupportedParameterType);
end;
if (sqlind <> nil) then sqlind^ := 0; // not null
end;

After that it ends at the end of the function TZInterbase6DatabaseMetadata.GetColumns in file ZDbcInterbase6Metadata.

No errormessage occures, nothing happens -> the program freezes


Is this any known bug? or a setting problem?
How can I solve this problem?

[cipto_kh]

The latest version of Zeos is 6.6.2-rc, you can try with the latest version. If the problem still exists then I think you should make a sample program with database sample to reproduce that error, then we can help you. As I try with Zeos 6.6.2-rc with Firebird 2.0.3 there is no problem in the order by statement.

[nayamda]

Hi there,

unfortunately my problem still exists.
I've tried it with version 6.6.2-RC and FireBird 2.0.
The problem occurs only with the embedded version of FireBird, the server works fine. To demonstrate the problem I've created a simple Demo to reproduce my problem.
It's to big to attach, so you can download it from here:
http://www.mpsoft4u-server.de/FireBirdP ... r_Prob.rar

Please help me.

[mdaems]

Would have been nice to include DB file and necessary dll's. Just drop everything ready-to-go in one zipped folder, please.

Maybe the bugtracker would be the right place. There you should also be able to upload some more data. http://zeosbugs.firmos.at/ (Please register using the same username.)

Mark

[nayamda]

Oops, sorry.
I thought I did it so...

BUT you solved my problem

I've tried my Demo in a VM to check which dlls you need and realized that i've been using still the embedded Version of FireBird 1.5.

With FB20 embedded it works as expected. So it wasn't a ZEOS prob.