I have a simple script that deletes all records (in a data filed called AllRecords), then appends all records from four different external data files. In all, there should be 2,269 records.
The problem is that I don't always end up with the expected number of records. The number that I'm short is not consistent.
The only time that I can get consistent results is if I close FM, then open AllRecords and run the script then.
I have tried things like flushing the cache before running the script, but that does not work.
Any ideas/suggestions are appreciated.