Solved

PB, an Updateable Stored Proc, and a Timestamp

Posted on 1998-12-28
3
687 Views
Last Modified: 2012-05-05
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
Comment
Question by:tjonas
  • 2
3 Comments
 
LVL 2

Expert Comment

by:ajith_29
ID: 1098533
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
 

Author Comment

by:tjonas
ID: 1098534
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
 
LVL 2

Accepted Solution

by:
ajith_29 earned 100 total points
ID: 1098535
Try to use  variable any while trying to pass from PB.Then it can converted into sybase.This will solve your problem.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to query constraints in Sybase 3 1,588
Work with Sybase data using SQL Server 2008 7 416
Sybase conversion 2 63
restore master and user database in sybase ase 2 34
Note: This is the third blog post in a series on email clearinghouses (https://www.xmatters.com/alert-management/blog-email-has-failed-us?utm_campaign=70138000000ydLoAAI&utm_source=exex&utm_medium=article&utm_content=blog-post).   We’ve been talki…
In 2017, ransomware will become so virulent and widespread that if you aren’t a victim yourself, you will know someone who is.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

27 Experts available now in Live!

Get 1:1 Help Now