"Gerard J.M.Houtenbos" wrote:

>
> Raymond,
>
> I took a look at your file and I noticed:
> 1. You're using a Select-column in the query, but a lookupfield
> in the grid. Is that why you needed the 'strange'
> ordering-settings?

No. FB/IB doesn't allow specifying an aliased fieldname in the ORDER BY clause.

> 2. You use a Connection in stead of a Databasecomponent. Why is
> that?

The Connection was already there and so I just tried it and it worked. I wanted
the same transaction, but it's possible that it can be done through IBODatabase
too -- don't know.

Perhaps Helen could help us with this.

>
> I uploaded my version of this problem. Maybe you can take a look
> at it.
>
> tia,
>
> Gerard
>
> On Sun, 29 Dec 2002 07:47:34 +1030, you wrote:
>
> >"Gerard J.M.Houtenbos" wrote:
> >>
> >> Raymond,
> >>
> >> I find nothing attached .....
> >>
> >> Gerard
> >
> >I have now updloaded it to the Files section of the Yahoo Groups IBObjects
> >group.

--
Raymond Kennington
Programming Solutions
W2W Team B