At 08:45 PM 28/03/2007, you wrote:

>Hi! is there any restriction in InterBase 7.5 regarding the
><select_expr> of an INSERT statement?
> I get an error in the ORDER BY part of the <select_expr>
> I've read the specifications here (they are about 6.0 version)
> and says nothing about the ORDER BY of the SELECT
>
>http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_download_documentation
>
> Here's the query, if I run the SELECT part without INSERT it
> works fine, but when I run this query I get the error:
> Invalid token.
>Dynamic SQL Error.
>SQL error code = -104.
>Token unknown - line 16, char -1.
>ORDER
>
> If I delete the ORDER BY part it also works fine and inserts it unordered
>
> INSERT INTO TEMPORALPRUEBA1
>(TEMPORALPRUEBA1.CLIENTID, TEMPORALPRUEBA1.DATE2, TEMPORALPRUEBA1.DATE1)
>SELECT
> TRACTAMENTS.C_HISTORIA,
> TRACTAMENTS.DATA_INGRES,
> TRACTAMENTS.DATA_ALTA
>FROM
> TRACTAMENTS
>WHERE
> (TRACTAMENTS.C_HISTORIA >= 5000 And TRACTAMENTS.C_HISTORIA <= 5044)
> AND
> ((TRACTAMENTS.C_PRESTACIO = 1004 AND
> TRACTAMENTS.C_MOTIU = "2" )OR
> (TRACTAMENTS.C_PRESTACIO = 2014 AND
> TRACTAMENTS.C_MOTIU = "8"))
>ORDER BY
> TRACTAMENTS.C_HISTORIA

The double quotes in the search clause are illegal syntax. Replace
them with single quotes.

./heLen