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
>
