Mike
I haven't had a lot of experience with this command yet,
but do see something quite different about your statements.
The first statement you have does not use any indicator variable
where your second one that fails does. Could this be the problem?
Jim Limburg
--- Ramsour Mike <[EMAIL PROTECTED]> wrote:
> 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/
__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.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/
