At 10:56 PM 19-08-01 +0200, you wrote:

>I have a table TEST with two columns
>PK Integer
>Order Varchar(100)
>
>when I use in a IB_query 'select * from test' the result shows PK and
>Order. Now I use 'select PK, Order from test', then comes the message
>'Column unknow: Order'.
>Any ideas ?

ORDER is a reserved word. I assume you are using dialect 3 and declared it inside double quotes, otherwise you wouldn't have been allowed to create a column named Order.

Put double quotes around it, making sure it is correct for case.

H.


All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________