CREATE PROCEDURE Attribute_InsProc ( @Description NVARCHAR(30), @id int Output ) AS BEGIN BEGIN TRAN INSERT INTO Attribute ( Description ) VALUES ( @Description ) Select @id = SCOPE_IDENTITY( ) IF (@@error!=0) BEGIN RAISERROR 20000 'Attribute_InsProc: Cannot insert because primary key value not found in Attribute' ROLLBACK TRAN RETURN(1) END COMMIT TRAN ENDHere is the CursorAdapter InsertCmd value:
Exec Attribute_InsProc @Description=?ca_Attribute.Description,@id=?ca_Attribute.kAttributeIt is my understandig that the new ID value should be placed in kAttribute. I append a record and TableUpdate(.T.). TableUpdate executes OK but the new ID value is not in the cursor. Any ideas? Did I go wrong somewhere?