Cancel Form does not delete identity insert [MSSQL C8EE ABC NTWS 5.32]

[nevy]

Add a record to a table that has an identity field on the backend, When the form is cancelled it does not roll back the record just inserted. Using emulateautonumkey to retrieve value of record inserted.How does one get around this. Any suggestions

[Bruce]

I'll test a bit here - there may be a specific configuration which can be improved. However read the answer to your other question here;

http://www.nettalkcentral.com/index.php?option=com_smf&Itemid=36&topic=2234.0

Cheers
Bruce