Thanks to both respoders. I did have to use an autonumber field to force the order of the output. The field had to be removed to produce the correct record length in the output file. The reason for the reset of the autonumber is the volume of records input over time.
Thanks again.
The input text file is in a specific order and needs to be exported in the same order. Business rule.
I know that some are not at the end by looking at the resulting exported text file.
I will try adding an autonumber field to the table used for the import. I delete all records from this...
The table has no autonumber field and none of the fields are indexed.
I have changed the code to try a query to append the BZC records to the TIR_IN table. Do not get 100% of the files built correctly. Append is defined as adding records to the end of the file. I think that somehow the eof...
I have an app that takes multiple text files, imports to a table, modifies data in the records, exports back to a text file. Problem is in the order of the records after a particlar process.
The process deletes certain records, puts them in a new table, modifies them and then puts them back...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.