Solved

PB, an Updateable Stored Proc, and a Timestamp

Posted on 1998-12-28
3
666 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
Comment Utility
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
Comment Utility
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
Comment Utility
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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
SYBASE Query combine date spans 7 635
Sybase ASE 15.7 do not know datepart function 2 1,185
SQL Substring Extraction 4 538
SSIS - Update a Sybase Table 33 138
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

772 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

11 Experts available now in Live!

Get 1:1 Help Now