At 04:34 PM 9/18/2003 -0600, Ron 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!
Ron,
Welcome Back!
If the Storage Box ID, for example StorageBoxID is the PRIMARY KEY and is REFERENCED to StorageBoxID as FOREIGN KEY in Slave Tables, you can use the DECLARE CURSOR command for any given SSN to move the records accordingly.
Basically, you have to know the structure to completely automate the task.
If you would like to post the table/column names, we can come up with a routine.
Very Best R:egards,
Razzak.
