programming question

[Richard D. Williams]

Richard,

If you have created a qualifier in the filepro file from which you are 
going to delete the records, it is impossible that the non-qualifed key 
and the qualified key have different number of fields.
By design any key under that filepro file uses a single data map.

Am I missing something in your description?

Richard D. Williams


On 9/4/2018 12:12 PM, Richard Kreiss via Filepro-list wrote:
> 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>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
>
>
> ---
> This email has been checked for viruses by AVG.
> https://www.avg.com
>
>