VVVV
VV
SELECT (listof(intcoil)) INTO vcoil_list I1 FROM tnslview +
Add the indicator variable and see if that works better.
Fred
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Ramsour Mike
Sent: Thursday, January 31, 2002 2:13 PM
To: '[EMAIL PROTECTED]'
Subject: RE: LISTOF problem
No I just enclosed my entire WHERE clause in parens. The parens are
balanced.
Mike
-----Original Message-----
From: William Cook [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 4:59 PM
To: [EMAIL PROTECTED]
Subject: Re: LISTOF problem
I assume the ( in front of CAUSE is a typo?
----- Original Message -----
From: "Ramsour Mike" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 31, 2002 12:41 PM
Subject: LISTOF problem
> I am having some difficulty getting the LISTOF command to work
consistently.
>
> I have one command that works very well:
>
> ===========================================
> SET VAR vcoil_list TEXT
> --
> SELECT (listof(intcoil)) INTO vcoil_list FROM tnslview +
> WHERE (run_date BETWEEN .vmindate AND .vmaxdate +
> AND ((recipe IS NULL) +
> OR (gradtype='AUST' AND recipe='REG-400') +
> OR (gradtype <> 'AUST' AND recipe='REG-300')))
> ===========================================
>
> (Incidentally this is great because from this list I construct a
command
> that then uses the SET CLIPBOARD command so that I can easily paste
it into
> a VAX Datatrieve session. Saves so much typing!!)
>
> The following code, however, does not work for me:
>
> ===========================================
> SET VAR VLIST TEXT
> --
> SELECT (LISTOF(SRC_CC)) INTO VLIST IND VIND FROM REJECT WHERE (CAUSE
IN
> ('325','731') +
> AND GRADE IN ('1223','1233','1238','1239'))
> ===========================================
>
> If I simply do a SELECT command I get the desired results. The
LISTOF does
> not work though. There is nothing special or exotic about any of
the data.
> The SRC_CC field is just a TEXT 6 data type. The reject table has
about
> 70,000 records in it. I've checked and double-checked the syntax at
> RSYNTAX.COM and I can't see where I'm doing anything wrong.
>
> So far my results have been spotty with LISTOF. When it works it
works
> great but other times I just can't come up with a good reason for it
not to
> work.
>
> Any help is appreciated.
>
> Thanks -- Mike Ramsour
> ================================================
> TO SEE MESSAGE POSTING GUIDELINES:
> Send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: INTRO rbase-l
> ================================================
> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: UNSUBSCRIBE rbase-l
> ================================================
> TO SEARCH ARCHIVES:
> http://www.mail-archive.com/rbase-l%40sonetmail.com/
>
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
