AnsweredAssumed Answered

Append Problems

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

Title

Append Problems

Post

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. 

Outcomes