AnsweredAssumed Answered

Append Problems

Question asked by DrDave on Dec 3, 2008
Latest reply on Dec 4, 2008 by DrDave


Append Problems


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.