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. >
