Can anyone tell me how to use timestamps in a stored procedure based datawindow when connecting to SQLServer 2008 using ODBC.
Creating the datawindow using a seect storedprocedure with timestamp (rowversion) went well. Retrieves perfectly the timestamps, but when using insert and update stored procedures I keep on having castproblems. What datatype do I have to use in my stored procedure?
In Powrbuilder 6.0 Unleashed under the heading timestamp they mention that Powerbuilder itself handles the timestamp, so I left out the timestamp in my update and insertstored procedures. The result was, that concurrent users can update both their updates to the same row, so I think thats only of use when using embedded SQL.
