programming question

[Richard Kreiss]

I am writing a routine which will delete records.  However prior to deletion the record will be copied to a qualifier with the addition of the date and who deleted the record.

I have added 2 fields to each of the files(records) which will be deleted. Date-deleted and by-whom.  The issue is that there are a different number of fields in each file and I therefore can't hard code the field numbers.

I can set up an array mapped to either the qualifier of the primary file.  Am I better off posting the 2 new field information to the primary file record and then use the  copy to function and then delete the primary record. Or do I do the copy to and then post the values to the qualifier record?

I can use fieldnum() to get the field number for the file in question and use that value as in index value for the array.  The field names are the same in each file to be deleted just the field numbers are different.

I  have not checked this, but when the file name used by the array changes, is the array cleared and if so will that blank the current record in the primary file?


Richard Kreiss
GCC Consulting






-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 16069 bytes
Desc: not available
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20180904/0b31f780/attachment.bin>