Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 774
  • Last Modified:

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?
0
tjonas
Asked:
tjonas
  • 2
1 Solution
 
ajith_29Commented:
Try the option of converting as string to input to the client end and then pass back from the client side to the sever using convert function as string giving max as varchar(255).Then when passed back it can covert to the required varbinary.The reason is varbinary max can only be 255.This will solve your problem.
Regards Ajith
0
 
tjonasAuthor Commented:
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.
0
 
ajith_29Commented:
Try to use  variable any while trying to pass from PB.Then it can converted into sybase.This will solve your problem.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now