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/
