Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PB 10 and RPCFunc not working

Status
Not open for further replies.

viking09

Programmer
Oct 2, 2006
1
US
We are migrating a PowerBuilder 7 application to PowerBuilder 10.

We have an RPCFunc defined that should return a non-zero value as well as an output parameter that should return a non-zero value.
Query Analyzer proves this to be true. In the Powerbuilder application at runtime, the value returned as well as the output parameter are always zero.

Other RPCFunc’s do work correctly.

What would be the difference that would allow one RPCFunc to work and another to not work?

Is there a SQLServer setting or property that could be different? (Stored procedures have been recompiled in the database.)
Is there something with OLEDB that needs to be looked at?

Any feedback is appreciated!
 
My opinion is to forget the output parameter and return whatever you need within the result set.

Matt

"Nature forges everything on the anvil of time
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top