We are facing one problem with Powerbuilder in Windows XP operating system. We are on client-server setup with Powerbuilder 10.2.1 and ASE 12.5.2.
We have a party ageing report and the grand totals are not displayed in case of Windows XP(when user goes to other programs when data is retrieving). But we don’t face this problem in operating systems below Windows XP. We have migrated to Powerbuilder 10.2.1 Build 9004 from Powerbuilder 7.0. We faced the same problem in PB 7.0 and Windows XP.
THIS PROBLEM IS FACED IN CASE OF WINDOWS XP OPERATING SYSTEM [CHECKED IN HOME AND PROFESSTIONAL EDITIONS] ONLY IF USER GOES TO OTHER PROGRAMS WHEN THE DATA IS IN RETRIEVAL PROCESS AND THIS PROBLEM IS IRRESPECTIVE OF POWERBUILDER VERSIONS.
PARTY AGEING PROCESS IS AS FOLLOWS
1. There is main datawindow which selects the parties for ageing on the basis of criterias like date criterias, date range etc.
The datasoure(select sql) for this datawindow is set in the script of the window which calls this datawindow.
2. In main datawindow, there is a nested datawindow in detail band and some computed fields in its summary band. This nested datawindow is having stored
procedure as its datasource, executes it for each party sent by main datawindow and retrieves nine columns(two text and seven amount columns).
3 Once the data is retrieved(above two steps), retrieveend event of the datawindow triggers explicitly a user defined event(ue_retrieveend) through postevent method.
4. In this userdefined event, there is a loop(FOR statement) which scrolls through the retrieved rows(by nested datawindow) and adds each amount columns for each row in its local variables. The amount column values are taken using the dot object notation(e.g ldwo_current.Object.age_break1 -- whereby
ldwo_current is the reference to nested datawindow for the row in the FOR loop and age_break is the amount column ].
5. After the loop[step 4], the local variables values are set in main datawindow's computed fields(grand total) in the summary band.
In case of Windows 2000 and below, this works properly even if the user goes to some other application or clicks anywhere else. But in case of Windows XP, if the data is retrieving and user shuffles to other programs, grand total is not set and it is blank. Whereas if user does not go to any other program, the grand totals are displayed(set).
During debugging found that the amount values are retrieved blank from nested datawindow(step 4), and hence the local variables which are set as grand totals remain as nil. So concluded that dot object notation is creating some problem.
Hopefully, we find the solution to this issue soon.
Awaiting your prompt response. Thanks in advance.
Thanks & Regards,
Gulf Agency Company
Email : email@example.com