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