Page 1 of 1

Program freezes on 'ORDER BY'

Posted: 18.01.2008, 14:27
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?

Posted: 19.01.2008, 02:39
by 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.

Posted: 20.05.2008, 07:56
by 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. :?

Posted: 21.05.2008, 09:14
by 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

Posted: 21.05.2008, 10:14
by 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.