Subject | [IBO] Problems with "order by" in TIBOTable |
---|---|
Author | Jan Turner |
Post date | 2002-09-03T09:46:57Z |
I have a quite strange problem. I have an TIBOTable component and try to do
a statement like this:
select * from contacts where status=0 order by recipient
In my IBExpert this works perfectly. In the TIBOTable it refuses to order
the received datasets but doesn't give an error message. The CharacterSet of
my TIBODatabase is ISO8859_1 and the field "recipient" has the charset
iso8859_1 too and collation DE_DE
Thanks in Advance
Jan Turner
----------------------------------------------------------------------------
www.getgo.de - Ihr Full-Service-Ticketprovider
getgo.de
Jan Turner
Albert-Einstein-Ring 10
D-22761 Hamburg
Fon: +49 40 41 911 310
Fax: +49 40 41 911 111
Mobil: +49 177 9395729
jan.turner@...
----------------------------------------------------------------------------
a statement like this:
select * from contacts where status=0 order by recipient
In my IBExpert this works perfectly. In the TIBOTable it refuses to order
the received datasets but doesn't give an error message. The CharacterSet of
my TIBODatabase is ISO8859_1 and the field "recipient" has the charset
iso8859_1 too and collation DE_DE
Thanks in Advance
Jan Turner
----------------------------------------------------------------------------
www.getgo.de - Ihr Full-Service-Ticketprovider
getgo.de
Jan Turner
Albert-Einstein-Ring 10
D-22761 Hamburg
Fon: +49 40 41 911 310
Fax: +49 40 41 911 111
Mobil: +49 177 9395729
jan.turner@...
----------------------------------------------------------------------------