Issue with datawindow retrieval in PB9.0.1
Posted on 2004-09-17
We are having some issues while trying to upgrade from PB 6.5 to PB 9.0.1 The database is Sybase.
There is a window w_child inherited from w_parent.The datasource of this dw_1 is a Stored Procedure that runs in Sybase ASE 12.5 In ue_1 of w_parent there is a dw_1.retrieve(arg1,arg2). ue_1 of w_child extends ue_1 of w_parent. In ue_1 of w_child the code checks the condition dw_1.rowcount() >0 based on which it decides on the execution flow.
While running the application, no rows are getting retrived.The same happens in debug mode too. But when we have "dw_1.retrieve(arg1,arg2)" as a watch variable
in the debug mode the row is currectly getting retrieved.
The dw_1.retrieve returns 0 and the sqlcode & sqldbcode for the transaction is 0.
Also,the preview of DataWindow retrieves the row in PB 9.0.1.
In PB6.5 everything was working fine.