Browse all for column_ID from TABLE_NAME where column_ID in (sel column_ID from WHAT_EVER_TABLE where column_ID = colum_ID and conan_date > WHAT_EVER_DATE)
Touch more info about the structure and I reckon we can nail this one for you pretty quick....
At 08:56 PM 2003-09-18 -0600, you wrote:
Yes, it's me, and thanks to all. It is good to be back.
I track the clients by name, ssn, client_id, box_no, box_destruct_date
When the destruction date has arrived for the box, I need to look at all the other boxes to see if any of the clients in the box have volume files in any other box. If not, I can destroy the file. If there is a later file, I need to remove the file from the box to be destroyed and put that file with the more recent file. I hope this helps.
----- Original Message ----- From: "Bill Downall" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, September 18, 2003 4:40 PM Subject: [RBASE-L] - Re: Record destruction
> Is that you, Ron? Long time no see! > > uhm, rather than boxes and subsequent boxes, can you describe this in > terms of tables and their columns? > > Bill > > On Thu, 18 Sep 2003 16:34:18 -0600, gries wrote: > > >I've been out of Rbase for a little while and have gotten rusty. > > >Please help! > > >After 6 years, we destroy medical records if the person has not been > >a client during that six year period. > > >I need to know if any ssn that is in the box to be destroyed is > >located in any other subsequent box in storage. If it is, I would > >need to remove the file and place it in the more recent storage box. > > >Would anyone have a example of the command to do this? thanks, and > >it is good to be back with all of you! >
Tony Luck
Brisbane Australia
