Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
NewID function under a transaction
I'm using a standard NewID function (pulled from "1001 Things/VFP") in my stored procedures. I've recently built a form that inserts a record into a table, and updates values in another table. I've enclosed these inserts/updates in a transaction. The newid function causes an error by opening the autoid table, and tries to force buffering on the table to 1. This creates an error. I've temporarily bypassed the error by placing an IF !(TXNLEVEL()>0) around the setbuffer command, but I don't think this is the best way to handle this problem.
Should I explicitly open the autoid table and set my buffering off before starting my transaction? Is there another way around this, or is this the best answer?
Thanks,
Bryan
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement