Datediff question. (2)

[Romeu Sciotta <tb09@PETROBRAS.COM.BR>]

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

Hi Raj,
datediff is a SQR function only in version 4.

Anthony,
I tried to use an alphanumeric variable and it didn't work.

Thank you for your tips.

If anyone have a new tip, I'll be grateful.


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

>Return-Path: owner-sqr-users@list.iex.net
>Received: by c6000g.serinf.petrobras.com.br (UCX V4.1-12E, OpenVMS
V6.2-1H3 Alpha);
>       Tue, 17 Nov 1998 17:26:27 -0300
>Received: by harpia; (5.65v3.2/1.3/10May95) id AA04943; Tue, 17 Nov 1998
17:18:43 -0300
>Received: from list.iex.net by harpia (smtpxd); id XA05866
>Received: from list.iex.net (list.iex.net [192.156.196.15]) by
list.iex.net (8.8.5/8.8.5) with SMTP id LAA29385; Tue, 17 Nov 1998
11:58:15 -0700 (MST)
>Received: from LIST.IEX.NET by LIST.IEX.NET (LISTSERV-TCP/IP release
1.8b) with
>          spool id 5534968 for SQR-USERS@LIST.IEX.NET; Tue, 17 Nov 1998
>          11:57:26 -0700
>Received: from mail.iex.net (mail [192.156.196.5]) by list.iex.net
>          (8.8.5/8.8.5) with ESMTP id LAA29293 for
<sqr-users@list.iex.net>;
>          Tue, 17 Nov 1998 11:57:20 -0700 (MST)
>Received: from mx05.netaddress.usa.net (mx05.netaddress.usa.net
>          [204.68.24.170]) by mail.iex.net (8.8.5/8.7.5) with SMTP id
LAA19000
>          for <sqr-users@mail.iex.net>; Tue, 17 Nov 1998 11:52:50 -0700
(MST)
>Received: (qmail 27298 invoked by uid 0); 17 Nov 1998 18:57:17 -0000
>Received: from wfdutilgw.ml.com [206.3.74.31] by mx05 via mtad (2.6) with
ESMTP
>          id 700ckqs6N0037M05; Tue, 17 Nov 1998 18:57:13 GMT
>Received: from mail1.ml.com ([199.201.57.137]) by wfdutilgw.ml.com
>          (8.9.1/8.9.1/MLgwo-4.02) with ESMTP id NAA02224 for
>          <SQR-USERS@USA.NET>; Tue, 17 Nov 1998 13:56:48 -0500 (EST)
>Received: from ewfd12.exchange.ml.com (ewfd12.exchange.ml.com
[146.125.111.6])
>          by mail1.ml.com (8.9.1/8.9.1/MLml5-4.03) with ESMTP id NAA12855
for
>          <SQR-USERS@USA.NET>; Tue, 17 Nov 1998 13:56:47 -0500 (EST)
>Received: by EWFD12 with Internet Mail Service (5.5.2232.9) id
<WWV4VCMF>; Tue,
>          17 Nov 1998 13:56:48 -0500
>Mime-Version: 1.0
>X-Mailer: Internet Mail Service (5.5.2232.9)
>Content-Type: text/plain
>Message-Id:  <A450BC87BF2ED2118DDD0001FA7EC48C17F046@EWFD07>
>Date:         Tue, 17 Nov 1998 13:56:45 -0500
>Reply-To: SQR-USERS@USA.NET
>Sender: "Discussion of SQR,
>              SQRIBE Technologies's database reporting language"
>              <SQR-USERS@list.iex.net>
>From: "Singh, Rajvirendra NY ESA" <RajvirendraSingh@EXCHANGE.ML.COM>
>Subject:      Re: Datediff question.
>X-To:         "SQR-USERS@USA.NET" <SQR-USERS@USA.NET>
>To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
>X-Original-From: SMTP%"SQR-USERS@usa.net"
>
>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