Thanks Bill, I see the direction you are going. I'll try that ----- Original Message ----- From: "Bill Downall" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, September 18, 2003 9:11 PM Subject: [RBASE-L] - Re: Record destruction
> Ron, > > Do you have a single table, with all those columns in it? If so, it would be > something like this, to get a list of the files to be saved from boxes to be > destroyed today: > > SET VAR vDestroyDate DATE = .#DATE > > SELECT f1.ssn, f1.client_id, f1.box_no + > FROM file_information f1 > WHERE (box_destruct_date = .vDestroyDate) + > and exists + > (SELECT ssn FROM file_information f2 + > WHERE (f2.box_destruct_date > f1.box_destructdate) + > AND (f2.ssn = f1.ssn)) > > Bill > > On Thu, 18 Sep 2003 20:56:09 -0600, Plateautel.net 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. >
