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/
