Jim:
Yes. Although the example I enclosed did not have the indicator variable I
have tried it with the variable and got the same results.
Thanks -- Mike
> -----Original Message-----
> From: Jim Limburg [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, February 01, 2002 8:03 AM
> To: [EMAIL PROTECTED]
> Subject: Re: LISTOF problem
>
>
>
>
>
> 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/
>
================================================
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/
