tjonas
asked on
PB, an Updateable Stored Proc, and a Timestamp
I am building an application with PB V6.5 and Sybase V11.5. I a using the PFC and supplying all of the IUD logic to the SQL Preview event via the Stored Procedure Utility. I need to compare timestamps in my update procedures; however, PowerBuilder has no concept of Varbinary. I can pass the timestamp down as a string but when it comes time to pass the timestamp back up to the update proc I'm at a loss as to how to get it back to its original varbinary format. Converting it on the client and passing it back is not an option. Any ideas?
ASKER
Could you be more specific. What should my variable declaration be in the stored procedure that accepts the value back from Powerbuilder? What should the string size be in the datasource declaration of the Powerbuilder datawindow. I've tried several permutations of your suggestion but the tsequal function still does not recognize the converted value as the same timestamp as the record's timestamp.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Regards Ajith