[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] SQR Help
- Subject: [sqr-users] SQR Help
- From: "Nehal H. Patel" <nehal_h_patel@yahoo.com>
- Date: Sat, 26 Oct 2002 17:11:01 -0700 (PDT)
- List-id: This list is for discussion about the SQR database reporting language from Brio Software. <sqr-users.sqrug.org>
I'm not sure if this is the appropriate place to ask
for SQR assistnace... but here goes.
I'm trying to check/trap for February 29 date. If the
value being checked is 02/29 i want to change it to
02/28.
What wrong with this code?
if &date = '20000229'
let &date = '20000228'
end-if
I get the following errors:
Error on line 450:
(SQR 3744) &pseudonym =type must be 'char',
'number', or 'date'.
if &date = '20000229'
Error on line 450:
(SQR 3719) Columns names and expressions must be
unique or be given unique pseudonyms (&name).
if &date = '20000229'
Error on line 450:
(SQR 3701) Invalid command.
if &date = '20000229'
Error on line 451:
(SQR 4000) Result #variable or $variable or '='
missing in expression.
let &date = '20000228'
Thank you.
-np
__________________________________________________
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
http://webhosting.yahoo.com/
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users