when creating invoices, i use the next value from a sequence to create a filename, which is then used with the os-copy comand to create an invoice from a template. If the invoice creation fails for any reason, the program deletes the invoice it has created and releases the handles to excel. Is there any way that i can alter the sequence number to the previous number to ensure that the invoice numbers are continuous?
"Emma" wrote:
>
>when creating invoices, i use the next value from a sequence
>to create a filename, which is then used with the os-copy
>comand to create an invoice from a template. If the invoice
>creation fails for any reason, the program deletes the
>invoice it has created and releases the handles to excel.
>Is there any way that i can alter the sequence number
>to the previous number to ensure that the invoice numbers
>are continuous?
ASSIGN CURRENT-VALUE(file-num) = what_you_took_out.