hi all,
i'm working with vfp7. I'm using a view that is bufferd (set to 3). This view is referring to sqltable on my sqlserver. The keyfield is set to identity with identity seed.

I'm appending a record to my view and with tableupdat() i send the information to my sqltable. This is done in a transaction.

Afther an tableupdate i try With SELECT IDENT_CURRENT 'user_main_view' as 'keyfield' to get the new value for this identityfield via vfp using sql passthrough.

The problem is that i don't get a value back for this keyfield.

can somebody tell me what's wrong ? (Is this due to may transaction that's still open ?)

Thnx