"Helen Borrie" <helebor@...> skrev i melding
news:5.1.0.14.2.20030213122739.05957eb8@......

> At 02:19 AM 13/02/2003 +0100, you wrote:
> >""Bj=F8rge S=E6ther"" <bjorge@...> skrev i melding
> >Now, even more problems:
> >
> >SELECT
> > *
> >FROM
> > INVOICE
> >ORDER BY 1
> >
> >...also generates an error...
>
> What kind of error?

Invalid command
Invalid ORDER BY clause

> >Why does this not work with IBO, while e.g. BDE handles it ?
>
> Not enough info here to guess.

SELECT
INVOICE_NO,
INVOICE_DATE
FROM
INVOICE
ORDER BY 1

...is perfectly fine.
--
Bj�rge S�ther
bjorge@hahaha_itte.no