Our original product used PowerBuilder 9.0.3. We are now required to use SQL Server Native Client 11.0.
For now, we are testing with the PowerBuilder 2019 (trial version) for our application; while we wait on the final purchase of PowerBuilder 2019. We are having the issue described in this link.
We have made the StaticBind=0 change. Should we need to make more changes than just setting the StaticBind=0?
We see other datawindow errors, but not sure if we are now required to make additional datawindow changes.
I run further in the application, but when processing the following statement, a (-1) is still being returned.
iRows = i_dsFaciName.Retrieve(p_sFaciType, p_iFaciCode))
I checked the SELECT statement for this datastore, and SELECT statement is correct. (I can query it in MS SQL server).
Any more ideas for me? Thanks so much.
I think you have to keep playing with StaticBind=1 and StaticBind=0 because my little experience tell me no other way except to do the following
The datawindow that fail to retrieve. Before the retrive function call, set a local string variable with sqlca.dbparm value and then change the DBparm as following
SQLCA.Dbparm += ",StaticBind=1"
let the retrieve function run and right after retrieve() set the orignal DBparm value back to SQLCA.
Most probably StaticBind attribute will be set twice in DBparm but that does not matter because last occurance is considered. Anyway, you are setting back the original stored in local variable.
That dirty trick works for me !!! :)