I have a question related to connection to SQL server.
I have a code which is as follows :
strsql = "UPDATE file1 SET field1='888'"
strsql = "UPDATE file1 SET field1='777'"
I did not run the above logic as it returns error :
"Only one transaction can be active"
Does this kind of nested transaction in VB possible ?