?
Solved

PB, an Updateable Stored Proc, and a Timestamp

Posted on 1998-12-28
3
Medium Priority
?
739 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 200 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

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

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

While opting for any web-to-print solution, you need to discuss with your team and some of your end users and know their opinions about your decisions. In this article we list down some questions you need to ask yourself.
On September 18, Experts Exchange launched the first installment of the Help Bell, a new feature for Premium Members, Team Accounts, and Qualified Experts. The Help Bell will serve as an additional tool to help teams increase question visibility.
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses

719 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