Title: | *OLD* ALL-IN-1 (tm) Support Conference |
Notice: | Closed - See Note 4331.l to move to IOSG::ALL-IN-1 |
Moderator: | IOSG::PYE |
Created: | Thu Jan 30 1992 |
Last Modified: | Tue Jan 23 1996 |
Last Successful Update: | Fri Jun 06 1997 |
Number of topics: | 4343 |
Total number of notes: | 18308 |
I am trying to set up a simple archiving system for one of my customers. The customer has a number of related indexed files. Each of the files has many fields. I want to allow the user to select a record, have it appear in the current item block and then type a menu choice allowing him to archive the selected record (and all related records on the other files) to be archived to archive files. A script would be executed to do a WRITE DELETE on all affected indexed files, and then a WRITE ADD to add the records to the appropriate archive files. Sounds simple, but I don't want to have to do a WRITE ADD KEY = #KEY, - FIELD1 = #FIELD1 ,- . . FIELDZILLION = #FIELDZILLION for EVERY one of the 8 files. Is there any way I can write a whole record to another file without having to deal with each of its fields? Eileen
T.R | Title | User | Personal Name | Date | Lines |
---|---|---|---|---|---|
606.1 | Could merge be of use? | CESARE::EIJS | All in 1 Piece | Thu Apr 30 1992 09:34 | 11 |
Eileen, If the fields in the 8 different data sets have the same name, why not write the record selected to a dummy data set, merge the record from this data set into the other data sets via OA$CNV_MERGE and then delete the dummy data set (or the record from the dummy data set). Just an idea. Simon | |||||
606.2 | DATA_FILE - another possibility? | SIOG::T_REDMOND | Thoughts of an Idle Mind | Thu Apr 30 1992 09:53 | 3 |
Or use the DATA_FILE function? Tony |