| Subject | RE: [IBO] Ordering problem |
|---|---|
| Author | Riho-Rene Ellermaa |
| Post date | 2003-09-22T10:38:37Z |
That's the obvious workaround now - did it this way.
IBO probably generates this SQL for RefreshKeys function or something like that, but is the ordering by caluse really necessary there (maybe IBO should strip not included columns from there)
Riho-Rene Ellermaa
senior programmer
-----Original Message-----
From: Lester Caine [mailto:lester@...]
Sent: Monday, September 22, 2003 1:07 PM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Ordering problem
looks fine, but your select SHOULD have all the fields you
ask for so perhaps we need Jason to fill in what we are both
missing :)
In the meantime what happens if you move the accountno field
to be the first one so you are using ORDER BY 1 ? ( move ID
to the end of the list so the select has to have the other
fields first )
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/M=194081.3897168.5135684.1261774/D=egroupweb/S=1705007183:HM/A=1706996/R=0/SIG=11p5b9ris/*http://www.ediets.com/start.cfm?code=30509&media=atkins> click here
<http://us.adserver.yahoo.com/l?M=194081.3897168.5135684.1261774/D=egroupmail/S=:HM/A=1706996/rand=344125488>
___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
IBO probably generates this SQL for RefreshKeys function or something like that, but is the ordering by caluse really necessary there (maybe IBO should strip not included columns from there)
Riho-Rene Ellermaa
senior programmer
-----Original Message-----
From: Lester Caine [mailto:lester@...]
Sent: Monday, September 22, 2003 1:07 PM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Ordering problem
> Traced it in monitor and found out that IBO sends into server the SQL where only message.ID is askedI've played with a couple of tables here and everything
>
> SELECT messages.ID from....
>
> Thats why the ORDER BY 3 gives error, other columns have fieldnames and ORDER BY DOCNO workes OK.
> Further experimenting showed that this SQL contains fields in KeyLinks.
>
> Does this mean that I have to add 2 dummy keylinks entries?
>
> IMVHO this can be considered as a tiny bug.
looks fine, but your select SHOULD have all the fields you
ask for so perhaps we need Jason to fill in what we are both
missing :)
In the meantime what happens if you move the accountno field
to be the first one so you are using ORDER BY 1 ? ( move ID
to the end of the list so the select has to have the other
fields first )
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/M=194081.3897168.5135684.1261774/D=egroupweb/S=1705007183:HM/A=1706996/R=0/SIG=11p5b9ris/*http://www.ediets.com/start.cfm?code=30509&media=atkins> click here
<http://us.adserver.yahoo.com/l?M=194081.3897168.5135684.1261774/D=egroupmail/S=:HM/A=1706996/rand=344125488>
___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]