1. Russell Harvey
  2. PowerBuilder
  3. Wednesday, 29 August 2018

Hi,

Recently switched from native Sybase driver to ODBC. When a stored procedure is executed, sqlPreview in SQLCA shows "?" (question marks) in place of variable values. (I am connecting to database with DisableBind=1,StaticBind=0 in dbParm.)

Declaration/execution is as follows (all variables have non-null values):

declare updateThis procedure for update_this
@suser_id = :ll_sUserID,
@spid = :ll_spid,
@history_date = :adt_historyDate ;

execute updateThis ;

SQL generated is:

execute update_this @suser_id =? , @spid =? , @history_date =?

This worked perfectly under native driver.

Thanks,

Russell Harvey

 

Russell Harvey Accepted Answer Pending Moderation
1
Votes
Undo

Resolved this by adding PBNewSPInvocation='Yes' to dbparm connection parameter. 

"Thanks" for your "help". ;>

Comment
There are no comments made yet.
  1. Thursday, 30 August 2018
  2. PowerBuilder
  3. # 1
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.