Try getting rid of the semi colon at the end of the entries in the
OrderingItems property.
You only need a single semicolon to separate the asc and desc entries.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Luiz Alves" <cprmlao@...>
To: <ibobjects@yahoogroups.com>
Sent: Sunday, November 11, 2001 8:31 AM
Subject: [IBO] Field not found error and IBO4


> List,
>
> I have a simple query as ' Select Pront, Nome,...(other fields) from
> Clientes' with FB 1.0 Beta 2 Dialect 3
>
> Ordering Items:
> prontuario=PRONT;PRONT desc;
> paciente=NOME;NOME desc;
>
> Ordering Links
> PRONT=ITEM=1;POS=0
> NOME=ITEM=2;POS=0
>
> OrderingItemNo=1
>
>
> I have asc and desc indexes on 'PRONT' and 'NOME' fields
>
> I done some tests and I can see that all times I have this query ordered
by
> 'PRONT desc' and I click on title of 'NOME' Column to order by 'NOME', I
get
> 'Field NOME not found'' error.
>
> I am inclined to think that is a Bug.
>
> Does someone have similar problems?
>
> (IBO 4(latest) win 2000 and D6)
>
> Regards,
>
> Luiz.