[Firebird-net-provider] Update with Store Procedure

[Mauricio M. <moe...@ho...>]

Hello

I'm trying to implement updates with optimistic concurrency, in order to
reach this goal, I've added a time stamp column in the table and written a
store procedure. This SP updates the data on the table and returns the new
timestamp. I want the SP returns the new timestamp in order the dataAdapter
reflects this change in cached data.

Now, I need to know if the store procedure effectively has updated the
record. I've tried to use e.RecordsAffected==0 in DataAdapter.RowUpdated
event but e.RecodsAffected always returns 0.

Could anybody point me in the right direction to solve this issue?

I'm using firebird net provider v 1.7 rc2 and Firebird 1.5.2.4731
superserver on a Windows 2000 workstation.

Thanks in advance.

Mauricio Magni.