Thanks to all. That took care of it
----- Original Message -----
From: "A. Razzak Memon" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[EMAIL PROTECTED]>
Sent: Thursday, August 26, 2004 12:59 PM
Subject: [RBG7-L] - Re: Check Box
> At 12:43 PM 8/26/2004 -0400, Joel Solomon wrote:
>
> >Razzak,
> >
> >The tables are the same and the form has the ID's.
> >
> >When I use the command EDIT USING formname WHERE
> >colname IN &varname, I get an error "parenthesis
> >are required around the list for the in clause".
> >When I change the code to EDIT USING formname
> >WHERE colname IN (&varname), I get the error that
> >"no data is found".
>
>
> Now you're cooking <g>.
>
> Here's what you need to do:
>
> After the CHOOSE and before the EDIT USING commands,
> convert the values to add left and right parenthesis
> required when using the IN clause option:
>
> Example:
>
> SET VAR varname = ('('+.varname+')')
>
> EDIT USING formname WHERE colname IN &varname
>
> That should take care of that!
>
> Very Best R:egards,
>
> Razzak.
>
>
>
> >----- Original Message -----
> >From: "A. Razzak Memon" <[EMAIL PROTECTED]>
> >To: "RBG7-L Mailing List" <[EMAIL PROTECTED]>
> >Sent: Thursday, August 26, 2004 12:23 PM
> >Subject: [RBG7-L] - Re: Check Box
> >
> >
> > >
> > > At 11:55 AM 8/26/2004 -0400, Joe Solomon wrote:
> > >
> > > >Razzak,
> > > >
> > > >Thanks for the code, but when I use EDIT USING formname
> > > >WHERE colname IN (&varname)
> > > >I get an error "No rows exist for the specified clause".
> > > >When I replace &varname with the actual list of names,
> > > >it works fine.
> > >
> > >
> > > Joel,
> > >
> > > 01. Is the table used in the CHOOSE command the same for
> > > the primary table in the form?
> > >
> > > 02. You are collecting the IDs in the CHOOSE command
> > > variable. Does the form's *primary* table has those
> > > IDs?
> > >
> > > That should give you a few clues!
> > >
> > > Very Best R:egards,
> > >
> > > Razzak.
> > >
>
