Problem with sorting...

FireBlade · Post by **FireBlade** » 17.02.2006, 00:43

First - I'm sorry if I'm asking a stupid question...

I have Delphi 7 + Zeos 6.1.5 patch2 + Firebird 1.5.2.

I made a procedure that sort the column when
user clicks on DBGrid's title.
So when user goes click, app does something like this:
TZQuery.SortedFields:=FieldName;

More precisely, it actually works at start,
but when I keep clicking for several times
at various columns, in one moment my app
gets frozen, and there's nothing I can do
except to kill it from Task Manager.

I didn't even notice this, my client did.
Geez, why he had to click so much?!

Should I better sort from SQL
or there is another alternative?

Anyone familiar with this "freezing" problem?

zippo · Post by **zippo** » 17.02.2006, 20:44

I also use this technique and I never had this problem. Could be that the user clicks too fast (while the previous sorting is still busy)?

FireBlade · Post by **FireBlade** » 17.02.2006, 22:37

zippo wrote:I also use this technique and I never had this problem. Could be that the user clicks too fast (while the previous sorting is still busy)?

I got the same conclusion at first, but I'm not so sure anymore...
I'm making a test app that should give me more info...
It would be so much easier if some error message appeared,
but it just freezes, no warning... even with all debug
options turned on. Now I also suspect at my Firebird installation.

zippo · Post by **zippo** » 18.02.2006, 23:42

The only anomaly I ecountered with Zeos is that the application takes a long to close on some computers (Zeos6.5.1+MySQL). This can take up to 30 seconds before the application button disappear from the taskbar. No errors, just needs more time. Boh..?