sorry but how about using substitution ....
where = [$text_where]
-----Original Message-----
From: Debra Benton [mailto:debra.benton@NPAC.COM]
Sent: Thursday, July 08, 1999 12:05 PM
To: Multiple recipients of list SQR-USERS
Subject: Re: Syntax question - how do you continue to the next line on a
l oad lookup where clause?
Thank you for the suggestion. Unfortunately, I still receive the following
errors:
Error in include file "C:\debbie\invoices\bifulp03.sqc" on line 2757:
(SQR 3501) Did not find end of literal.
'EFFDT = (SELECT MAX(A_ED.EFFDT) -
Error in include file "C:\debbie\invoices\bifulp03.sqc" on line 2758:
(SQR 4115) Unknown command or extra parameters found (missing quotes?).
FROM PS_BI_TYPE A_ED WHERE SETID = A_ED.SETID AND BILL_TYPE_ID =
A_ED.BILL_TYPE_ID AND A_ED.EFFDT <= SYSDATE) AND SETID = ''CIS00'''
Errors were found in the program file.
SQR: Program Aborting.
Thanks again,
Debbie
-----Original Message-----
From: Pankaj Bedekar [mailto:BedekarP@ALCONEMARKETING.COM]
Sent: Thursday, July 08, 1999 2:31 PM
To: Multiple recipients of list SQR-USERS
Subject: Re: Syntax question - how do you continue to the next line on a l
oad lookup where clause?
how about using - at end of line and starting at next line ...
'-' is use as continuation
-----Original Message-----
From: Debra Benton [ mailto:debra.benton@NPAC.COM
<mailto:debra.benton@NPAC.COM> ]
Sent: Thursday, July 08, 1999 10:44 AM
To: Multiple recipients of list SQR-USERS
Subject: Syntax question - how do you continue to the next line on a
load lookup where clause?
Hopefully this is an easy syntax question:
My load-lookup has a lengthy where clause that I would like to put on
several lines to make it easier to read in the future. How can I continue
on the next line? I've tried the underscore at the end of the line with no
success.
Thanks,
Debbie
load-lookup
name=RGN-DESCR
table=PS_SUBCUST_Q1_TBL
key=SUBCUST_QUAL1
return_value=DESCR
where='EFFDT = (SELECT MAX(A_ED.EFFDT) FROM PS_SUBCUST_Q1_TBL A_ED WHERE
SETID = A_ED.SETID AND SUBCUST_QUAL1 = A_ED.SUBCUST_QUAL1 AND A_ED.EFFDT <=
SYSDATE) AND SETID = ''CIS00'''