Re: Datediff question.

["Singh, Rajvirendra NY ESA" <RajvirendraSingh@EXCHANGE.ML.COM>]

Hi Romeu,

Datediff is SQR function not a database function. You can use it in your
LET, IF, WHILE command. You can not this function as part of select column
list.

Raj

        -----Original Message-----
        From:   Romeu Sciotta [SMTP:tb09@PETROBRAS.COM.BR]
        Sent:   Tuesday, November 17, 1998 2:25 PM
        To:     Multiple recipients of list SQR-USERS
        Subject:        Datediff question.

        From:   NAME: Romeu Finoti Sciotta
                FUNC: DTSE/SUPER/DITEP/SETEC <TB09@A1@C60000>
        To:     NAME: SQR UserGroup <SMTP%"SQR-USERS@usa.net"@mrgate>

        Hello to all.

        When I try to put a variable into datediff command on begin-select
        paragraph, I receive the following message:

        (SQR 1303) Error in SQL (perhaps missing &name after expression):
        select DATEDIFF(day, WO.REPORTDATE, ?)  From WORKORDER WO Where
WO.WONUM =
        '15485'
        (SQR 1304) Check SELECT columns, expressions and 'where' clause for
        syntax.

        Where is "?" I'm using a variable (ex: &dateinit)
        My question is: Doesn't SQR support variables into DATEDIFF command?
        Obs.: I've tried to use this command directly on SQL and it worked.

        Any help would be appreciate.
        Thank's in advance.

        Romeu F. Sciotta
        MIPS Sistemas (PSDI var in Brazil)

        Inf: SQR v3 for ODBC