[RBG7-L] - Re: correcting data where there is a primary &foreign keys

[Chris Szeto]

 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