Copying a record and paste it using the same table

I'm working on an invoicing system on Delphi5.
the invoice consist of mastertable and detailtable according to the law i can't delete an invoice.But deleting an invoice it means that i insert the same invoice under another invoice number. for example if i have an invoice with invoice nr. 5 if i delete it. it will remain under number 5 and it will take the invoice number 6 with negative amount so when i do vat statement they can see both one with positive amount and the other with negative one.
sivatagihercegAsked:
Who is Participating?
 
geobulConnect With a Mentor Commented:
Hi,

Read values from current record like this:

FirstField := Table1.FieldByName('First').AsString;
.....

and then add a new record:

Table1.AppendRecord([FirstField,SecondField...]);

Note that the new record becomes current.

Regards, Geo
0
 
JaymolCommented:
There's no question there mate!

John.
0
All Courses

From novice to tech pro — start learning today.