ok i know there is a huge debate about currentdb and dbengine and frankly i don't have the bandwidth to go through it now though i really, really, really need to.
question here is that let's say i've got 2 code blocks
Code Block 1:
Code Block 2:
set db = currentdb
when i rollback for Code Block 1, will it only roll back the last execute statement cause the currentdb is a new instance? i think Code Block 2 is the safe way to do it right?
i would do some testing myself to find this out but i don't have the knowledge right now to understand the results of the testing comprehensively - rather i would be forming personal theories about this without reading through the whole currentdb vs dbengine debate, so apologies guys i'm asking this question here - and also i think yall have a lot more experience in this and surely able to point out blindspots i'd have missed. thanks guys!! = ))