neither will work.... Once you put the Parans around the cols, the parser expects an expression, so you have to put in + or & as appropriate along with any type conversions required by the expression...
If you omit the Parens, you can't designate a Return Column value... ----- Original Message ----- From: "Alastair Burr" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Wednesday, December 22, 2004 7:26 PM Subject: [RBG7-L] - Re: correcting data where there is a primary &foreign keys > It looks like your CHOOSE syntax is confusing R:Base: > > Presumably, you are trying to display the 3 values in your menu but you > appear to be telling R:Base that the value after the comma is what you want > returned - and you've got two commas. > > Try it this way: > > CHOOSE vCID FROM #VALUES FOR DISTINCT + > (CID,SSN,(LJS(FullName,35)) ) + > FROM PEOPLELIST + > WHERE SSN like .vSSN + > ORDER BY Debtor > > or > > CHOOSE vCID FROM #VALUES FOR DISTINCT + > (CID,SSN,(LJS(FullName,35)) ), RetCol + > FROM PEOPLELIST + > WHERE SSN like .vSSN + > ORDER BY Debtor > > if you want to return RetCol to your result. > > If neither of those work try replacing the two commas within the brackets > with ampersands. > > Regards, > Alastair. > > ----- Original Message ----- > From: "Chris Szeto" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[email protected]> > Sent: Wednesday, December 22, 2004 11:11 PM > Subject: [RBG7-L] - Re: correcting data where there is a primary &foreign > keys > > > > The only difference is instead of the Choose command it starts with > > select. > > > > CHOOSE vCID FROM #VALUES FOR DISTINCT + > > CID,SSN,(LJS(FullName,35)) + > > FROM PEOPLELIST + > > WHERE SSN like .vSSN + > > ORDER BY Debtor > > > > SELECT + > > CID,SSN,(LJS(FullName,35)) + > > FROM PEOPLELIST + > > WHERE SSN like .vSSN + > > ORDER BY Debtor > > > > BTW, thanks for all the assistance with this. > > -----Original Message----- > > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence > > Lustig > > Sent: Tuesday, December 21, 2004 11:21 PM > > To: RBG7-L Mailing List > > Subject: [RBG7-L] - Re: correcting data where there is a primary > > &foreign keys > > > > > I have tried this way and it still does not work. I'm using 7.1 > > though > > > so I'm not sure if that has anything to do with it. The single wild > > > cards did not work either unfortunately. > > > > Chris, could you post the SELECT statement that DOES work for the > > purpose of > > comparison? > > -- > > Larry > > >
