Hi Mike:

I see that ODBC does not support explict tans, only implicit. Thats why in manual mode trans is always auto started and you have to commit or rollback.

So adding an explicit transaction to the new case id stored procedure when it is already engaged in an implicit transaction because I have VFP set to manual is redundant? I'll propabaly switch this to automatic so and I can use explicit trans and take advantage of SQL's highest isolation level.

I like the manual setting for my data classes bcause they are designed to save in an all or nothing fashion and the error testing and subsequent commit or rollback code is already buit in to the class.

Thanx,
Charlie