I have my application i created for a client. Now my client needs the invoices created in my app to be uploaded into there accounting package called Pastel ver 5. Now this all cool and i can do the above no problem. The problem i have is that pastel does not warn the user if they import the same delimitted file that an invoice number already exists. Pastel justs autoincrements to the next invoice number. So i need ideas on a way around this. The client will import the file from inside Pastel. It has an import feature which the user will select the specific delimitted file and press import. I hope this makes sense. Anyway i was thinking is there anyway i can delete the contents of the delimitted file once a process or thread has opened the file for read. So if the user goes in the next day and tries to import the same file it will not allow them to.
thanx in advance