
Counter Fields - value assigned on Addnew not Update?
VB4 Pro/32bit/Win95.
Can someone confirm the following:
When using a counter field the value is calculated
(and lost forever)
when the Addnew method is invoked -NOT- when
the Update method is invoked (contrary to what is
stated in the help files ).
For example, say you have 3 records in a table
and you do the following:
Begintrans
table.addnew
table.field="something"
Rollback }include these to force
exit sub }exit/simulate error
table.update
Committrans
Then, remove the 2 lines (Rollback & exit sub) and repeat.
The next record has a value in the counter field of 5,
not 4 as I would expect!!
Any comments?
--
frank bainbridge
eds ltd