远程Sybase数据库技术支持,联系手机:13811580958,QQ:289965371!

 

随着Sybase被完全整合到SAP下,Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
考虑到Sybase数据库的初学者或者没有购买原厂服务的Sybase客户情况,现提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息。
在SAP Support Portal网站或者google上搜索Targeted CR List for ASE,可以看到针对不同版本的CR(CR表示Change Request)简单描述信息列表。
需要注意的是:Targeted CR List for ASE列出的CR虽然绝大多数是BUG,但有一些是更改需求。
以下提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息!

如有问题,请联系我!

QQ :289965371 点击这里给我发消息
Email:
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

 

CR:329541
CR Number:   329541
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Aug 2005 Third Party Problem
Description
Cannot create Powerbuilder Catalog tables with DBASE.



CR:329579
CR Number:   329579
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Oct 2003 Not a Bug
Description
On OCX that captures keystokes captures the tab key in PB 5.0 and 6.0, but doesn't capture the tab key in7.0 and 8.0.3.



PB Engineering investigated this issue and has determined it is not a bug. The tab is the character that PB uses to change the focus for controls on a window. Tab to move forward in the tab order, shift tab to move in reverse order. PB is trapping the tab and shift tab for that purpose and the ocx doesn't get them. It was actuallly a bug in 5.0 and 6.0 that there was no keyboard way to navigate to other controls in a window. And it was fixed. The behavior now in 8.0.3 is correct.



CR:329580
CR Number:   329580
Product Name:   PocketBuilder
Product Component:   DW - Runtime
Status:   Open
OS:   Pocket PC 2002
Original Version:   1.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Fixed
Description
When using a DW Expression to set the "Visible" property of an object (column, Text or Button, etc), the DW does not repaint the screen properly.



CR:329590
CR Number:   329590
Product Name:   PocketBuilder
Product Component:   DW - Runtime
Status:   Closed
OS:   Pocket PC 2002
Original Version:   1.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Nov 2003 Fixed
Description
When date or time editmask column has modified background color, the data shows as zeroes when the column gets focus. Occurs on desktop as well as device.



CR:329625
CR Number:   329625
Product Name:   PocketBuilder
Product Component:   DW - Runtime
Status:   Closed
OS:   Pocket PC 2002
Original Version:   1.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jun 2005 Fixed
Description
DW checkbox does not refresh display properly when checkbox is deselected.

The checkbox display is "shadowed" when deselected.



CR:329630
CR Number:   329630
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 11 Nov 2003 Fixed
Description
Loading a jpeg file into a picture control hangs PowerBuilder.



CR:329725
CR Number:   329725
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.0 28 Mar 2005 Fixed
Description
When setting up a dual monitor configuration and having an application spanning over the two screens, dragging and drop is not working when moving from one monitor to the other.



CR:329734
CR Number:   329734
Product Name:   PB Enterprise
Product Component:   DW Expression
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jun 2006 Fixed
Description
the protect attribute is not set for a Checkbox field for the first row
Workaround Description
 add in the open event : dw_1.setrow(1)



CR:329738
CR Number:   329738
Product Name:   PocketBuilder
Product Component:   DW - Runtime
Status:   Closed
OS:   Pocket PC 2002
Original Version:   1.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Aug 2003 Fixed
Description
Calling the datawindow SaveAs method on a datawindow with more than 3 columns will cause the device to hang. There's no problem on the emulators and IDE.



Steps to reproduce error:

1. Create a new datawindow using the product table (you can use any other table as well).

2. Select any four columns from the table.

3. Insert the datawindow control on a window and call the datawindow SaveAs method from a commandbutton.

4. Deploy the application to the device.

5. On the device, retrieve the datawindow data and then click on the commandbutton triggering the SaveAs method.

6. Give the filename as "prodtxt" and filetype as the default "Text with headers". You can also try saving as text or other formats. Click "OK". The device will show an hourglass pointer that turns non-stop. The saved file is created but there's no content in it. Calling the SaveAs method a second time will cause a return code of -1.



CR:329745
CR Number:   329745
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Oct 2003 Fixed
Description
When entering in data that has a editmask of !!-!!-!!-!!-!!,

the cursor will skip.



For example, after inserting a new row and enter in the following:

B -AB-AB-AB-AB



The cursor will skip to where the y is instead of in the x position:

B -AB-xy-xy-xy-xy



CR:329746
CR Number:   329746
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
PB90 Source Control Enhancement Request: Would like to see dialog window giving an option to select a different PBL when checking out objects.



CR:329762
CR Number:   329762
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 20 Oct 2003 Fixed
Description
When printing a composite datawindow that has

nested reports, some of the data is not printing on the report. There is

no indication or message that this data is missing.



The data does appear from print preview.



The composite datawindow (d_po_hardcopy_internal_main) has the following nested reports:

d_po_hardcopy_internal

d_po_hardcopy_items

d_po_hardcopy_items_not_s

d_po_hardcopy_inv_fwd_int

d_po_hardcopy_terms_and_conds

d_po_hardcopy_terms_and_conds_2

d_po_hardcopy_terms_and_conds_3

d_po_hardcopy_spec_mar_cons_ship

d_po_hardcopy_mar

d_po_hardcopy_acknow



The problem is in the d_po_hardcopy_internal dw. If you call up this dw and print it,

than all the data is showing ok. If you create a new composite dw and place this dw on it,the print problem happens.



CR:329768
CR Number:   329768
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jul 2004 Fixed
Description
The PowerBuilder Help definition of Polymorphism is incorrect.



CR:329869
CR Number:   329869
Product Name:   PB Enterprise
Product Component:   BAM Deployment
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
New Feature Request to add some algorithm to encode/decode at deployment and runtime.
Workaround Description
 Nil



CR:329896
CR Number:   329896
Product Name:   PocketBuilder
Product Component:   PB GUI
Status:   Closed
OS:   Windows 2000
Original Version:   1.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.5 328 26 Nov 2003 Fixed
Description
For PPB 1.0.1, please add the DW Syntax Utility.



CR:329898
CR Number:   329898
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 26 Feb 2004 Fixed
Description
OCX inside dw does not scroll together with rest of datawindow control. Tested and reproduced in PB 8.0.3_10002, 9.0_6121 and 9.0.1_6531.



CR:329915
CR Number:   329915
Product Name:   PocketBuilder
Product Component:   Window - Runtime
Status:   Open
OS:   Pocket PC 2002
Original Version:   1.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Fixed
Description
Listview control: In reportview, the rows are only partially highlighted when they are selected, if the 1st column is under a certain width.



CR:329932
CR Number:   329932
Product Name:   PB Enterprise
Product Component:   DW Printing
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
Italic font on nested text display cuts off last line of text



CR:329955
CR Number:   329955
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
A large autosized text column in a nested report overlays header information on 2nd page.



CR:330036
CR Number:   330036
Product Name:   PB Enterprise
Product Component:   Debugger
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.3 26 Jul 2006 Fixed
Description
In PowerBuilder 8 and 9 a crash can occur in the debugger when expanding

the properties of a dynamically created control through the create statement.





When defining a standard visible user object and dynamically creating it using

the OpenUserObject function, then there is no such crash.



CR:330043
CR Number:   330043
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 May 2004 Fixed
Description
When changing at the same time both visible and width DW column properties using modify the result in PB 9.0 is not correct.
Workaround Description
 Set the column that has been made invisible previously again invisible in code eg.

String ls_ret



//ls_ret = dw_1.Modify("a.Width = ~"0~"" ) // WORKAROUND

//ls_ret = dw_1.Modify("a.Visible = ~"0~"" ) // WORKAROUND

//ls_ret = dw_1.Modify(



CR:330056
CR Number:   330056
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 06 Apr 2004 Fixed
Description
User Icons not displayed with LargeFonts.



3/2004 Per PB Engineering, this is not a bug.

The application should prepare several images for one icon, including different sizes, 16x16, 32x32, 48x48 etc, for the supplied .ico file. Refer to MSDN on icon usage.



Note: The issue that PB Engineering did fix, was for a "side issue".



CR:330059
CR Number:   330059
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Oct 2003 Presently Not Targeted For Any Future Release Of This Product
Description
The last line of a large nested text column gets clipped off in a datawindow report.



CR:330063
CR Number:   330063
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 03 Dec 2003 Fixed
Description
When printing a datawindow that has a large amount of

data, the same data near the middle of the report keeps repeating.



The datawindow is a nested report (d_po_hardcopy_terms_and_conds_main2) but the problem can be reproduce by just calling up the nested report (d_po_hardcopy_terms_and_conds2) and printing that.



CR:330109
CR Number:   330109
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 28 Sep 2003 Fixed
Description
WebDW container deploys with debug flag set to true.



CR:330116
CR Number:   330116
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jun 2005 Fixed
Description
The title of the script painter pane changed in 8.0, 9.0 and it makes no sense.



CR:330174
CR Number:   330174
Product Name:   PocketBuilder
Product Component:   DW Painter
Status:   Open
OS:   Windows 2000
Original Version:   1.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
On Windows PocketPB IDE, open an existing External Datawindow object and append or insert column will eventually cause it mess up. Problem occurs when all column is string but with different length. It is observed that the data lenght of those columns be wrongly changed.
Workaround Description
 manually edit the exported DW syntax and reimport.



CR:330176
CR Number:   330176
Product Name:   PB Enterprise
Product Component:   Install
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Path values being lost, when PB9 is installed and path variable is long.



CR:330200
CR Number:   330200
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Sep 2004 Fixed
24 Oct 2003 Duplicate
20 Sep 2004 Fixed
Description
Some instabilities issues were discovered in testing a

PowerBuilder/EAServer application with a modified heapmanager for CR327180\320515.

These instabilities are related to threading (also SharedObjectRegister) and can

occur in particular with multi CPU PC's or under higher load conditions.



CR:330217
CR Number:   330217
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Update properties are changed if you want to delete a column and the datawindow contains three tables.

Similar to CR 183985, but this is an extension to it. The Allow updates checkbox is unselected and all other properties as well when having three tables in the select, whereas in 183985 only one table is reffered to.



CR:330276
CR Number:   330276
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 08 Oct 2003 Fixed
Description
With an editmask of ###.00 when the current value is selected and one inputs a '1' the result is 100.00 when it should be 1.00. This regression appears to be a result of a fix for a similar editmask regression ( CR 327915).



CR:330359
CR Number:   330359
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 18 Sep 2003 Fixed
Description
This is a request to remove the following statement from the connection

routine deferring it to be executed when acutally needed:



"SELECT * FROM SYS.SESSION_ROLES WHERE ROLE = 'DBA'"



CR:330384
CR Number:   330384
Product Name:   PB Enterprise
Product Component:   Debugger
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jun 2005 Presently Not Targeted For Any Future Release Of This Product
Description
With remote debugging it is not possible to inspect long string values

within the debugger nor can you save them to the EAServer logile.



Work-around is to write a function to write it to a custom file

or a loop to write it in parts to the log file.
Review Status
 [*** Tuesday, June 21, 2005 11:50:44 ***]

This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release".



CR:330389
CR Number:   330389
Product Name:   PocketBuilder
Product Component:   DB Painter
Status:   Open
OS:   Windows 2000
Original Version:   1.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
If you select "Show system procedures" on popup menu of a connected ODBC database's folder, it marks it checked but the stored procedure list does not change. ODBC does not support this, so the menu option should be greyed out.



CR:330390
CR Number:   330390
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 09 Nov 2003 Fixed
Description
When a exception happens in a pb web service called

from a pb client, that exception is not properly returned back to the client.



The error message returned to the client is:

Error: Soap Fault: Soap Server Error



If logging is turned on, the full exception message is in the log file but not

returned using soapexception, runtimeerror or pbxruntimeerror.



The message in the log file is:

<message>

Invocation Target Error:

"Divide by zero at line 3 in function add of object n_calc.;1;3;n_calc;n_calc;add;"

</message>



The message that is appearing back to the client is from the following:

<faultstring>SOAP Server Error</faultstring>



CR:330405
CR Number:   330405
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
PowerBuilder needs a project deployment location environmental variable or a profile that deployment projects can share, making changing deployment to a different application server easy in one step, rather than having to edit multiple deployment projects.



CR:330412
CR Number:   330412
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 14 Oct 2003 Fixed
Description
Running application will crash in PB 8.0.3 and 9.0.1.



The following is the results of the crash handler:

Exception code: C0000005 ACCESS_VIOLATION

File Name: E:\pb80\Shared\PowerBuilder\PBDWE80.dll

File Version: 8.0.3.10002

Fault address=1162FCED Section:Offset=01:0012ECED



Registers:

EAX:0000B250

EBX:021EE300

ECX:00000001

EDX:0000164A

ESI:00000000

EDI:0000076E

CS:EIP:001B:1162FCED

SS:ESP:0023:0012EE6C EBP:0012EED0

DS:0023 ES:0023 FS:0038 GS:0000

Flags:00010212



Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

1162FCED 0012EED0 07E30A70 00000113 000007D2 00000000 dwWinProc+76D

77E72CED 0012EEEC 1162F580 07E30A70 00000113 000007D2 CallWindowProcA+11

77E72D0B 0012EF0C 1162F580 07E30A70 00000113 000007D2 WaitMessage+12

10B70996 0012EF44 07E30A70 00000113 000007D2 00000000 PBC_NormalProc3D+76

77E72CED 000007D2 00000000 00000000 00000000 00000000 CallWindowProcA+11



OS version:

Windows NT 4.0, Build Number: 1381, Service Pack 6



Memory Status:

Total physical memory: 196024K

Available physical memory: 54988K

Total virtual memory usage: 299416K / 415332K

PowerBuilder virtual memory usage: 97540K / 2097024K





If the uo_button\constructor event is commented out then the app works ok. If the uo_dw_updateable\losefocus event is commented out then the app also works ok.



CR:330529
CR Number:   330529
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 08 Oct 2003 Fixed
Description
PowerBuilder 9 Build 6140 has editmask regressions on

editmasks like:

#,###.00

#.00

#.0000



When selecting the entire column and entering 1.5

The columns will not show the expected values.



CR:330554
CR Number:   330554
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jun 2005 Fixed
Description
PB 8 and 9 : When PB and .NET is installed on the same machine the following error appears: - open Object Browser -> OLE > doubleclick on programmable objects crashes PB



Update: Works fine in PB10.2 build 8045
Review Status
 This CR was reviewed and closed as part of the PB10 CR Review process. It is fixed in PB10.
Workaround Description
 problem seems to be due to vsaenv.exe - eg. renaming of vsaenv.exe to vsaenv.ex_ solves the problem.

(is located in eg. C:\Program Files\Common Files\Microsoft Shared\VSA\7.1\VsaEnv)



CR:330595
CR Number:   330595
Product Name:   PocketBuilder
Product Component:   System Runtime Functions
Status:   Closed
OS:   Pocket PC 2002
Original Version:   1.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
319 27 Oct 2003 Fixed
Description
Dayname() function returns an empty string upon a valid date.



WA: Daynumber() function works ok.
Workaround Description
 Daynumber() function works ok.



CR:330659
CR Number:   330659
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
Can't change the selection of a RadioButton column while it has focus, after a backcolor modify on that same column.



CR:330745
CR Number:   330745
Product Name:   PB Enterprise
Product Component:   WT - Object Model
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 27 Sep 2003 Fixed
Description
Image not displayed in a JSP generated by PB9



CR:330756
CR Number:   330756
Product Name:   PB Enterprise
Product Component:   DW Printing
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 21 Mar 2004 Fixed
Description
When printing a nested report or saving to a pdf file,

the nested report changes appearance in the dw control and the pdf and print

out shows a large white space between the numbers.



When printing or saving to pdf the d_test2, it will generate many unnecessary

pages of output.



CR:330762
CR Number:   330762
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jun 2004 Not a Bug
Description
Line control not displaying in Nested report.



When displaying the nested dw by itself, the line control appears ok. When viewing

as a nested report, the vertical line does not appear. Works ok in PB 9.0 (build 5507).



CR:330788
CR Number:   330788
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Error Message "Invalid DataWindow Row/Column" does not identify the

DataWindow, nor what the real problem is. Please change this to indicate

which DataWindow has the problem, and whether the column specified does

not exist, or whether you're referencing a row that doesn't exist.



CR:330793
CR Number:   330793
Product Name:   PB Enterprise
Product Component:   Debugger
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Please add an enhancement for the debugging of DataWindows. What would be really useful would be the following.When I am stepping through code and the code is accessing a DataWindow in some way (getting data, setting data etc), it would be EXTREMELY useful if one of the Debugger Panes could actually show the

DataWindow Object, even if you were really accessing a DataStore.



CR:330798
CR Number:   330798
Product Name:   PB Enterprise
Product Component:   JSP Web Services
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 23 Oct 2003 Fixed
Description
Using the WebSphere Application Developer 5.0 tutorial and PowerBuilder 9, am not able to invoke the web service. Receive an error message of "Unknown error, problem with soap client".



CR:330816
CR Number:   330816
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Mar 2005 Fixed
Description
Isvalid on a scriptdefinition returntype returns true when it should be false.



CR:330832
CR Number:   330832
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 14 Oct 2003 Fixed
Description
When a column has a editmask of !!-!!-!!-!!-!!-!!, the

field values are no longer held if they are left blank.





For example, in PB 8.0.3 and 9.0 a column will appear as:

B -A -AA-AA--



In PB 7.0.3, the same column will appear as:

B -A -AA-AA- -



CR:330953
CR Number:   330953
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 19 Feb 2004 Fixed
Description
On French keyboards or keyboards where the numbers are located in

the shift position, a date datewindow editmask doesn't advances the

cursor location when inputting <shift> <1> etc.

When the Caps Lock key is used instead, dates can be entered normally.



CR:331121
CR Number:   331121
Product Name:   PB Enterprise
Product Component:   AutoScript
Status:   Open
OS:   Microsoft Windows NT
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When you enter an object name followed by a period, the autoscript does a good job of detecting what operations and attributes are available except for when you enter dw.object.....



It would be fantastic if the autoscript would, at this point, list the columns in the DataWindow, and/or some of the other object types such as column, etc and then allow for further drill down.



It would also be nice if PB could validate the entries made in a DataWindow get or set operation before runtime.



CR:331122
CR Number:   331122
Product Name:   PB Enterprise
Product Component:   DW Expression
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 15 Oct 2003 Fixed
Description
When an expression is set for the x property of a

nested report, the expression of the property is not working consistently.



The final outcome of the report should be that the nested report is staggered as follows:

(where as X represents the nested report position on the datawindow)

X

X

X

X

X

X



That affect is not being achieved. The appearance is:

X

X

X

X

X

X



The first row is always taking the value or the position of the last row in the report.



The expression of the X property is location_1 * 3. The value(s) of location_1 are: 100,200,300.

The first row of the report should have the nested report staggered as:

(location_1 * 3 where location_1 is 100)



X



The next row has the following value (location_1 * 3 where location_1 is 200)

X



The last row should be (location_1 * 3 where location_1 is 300).



When the location_1 value is 100, it is always placing the nested report in the

position for whatever the last value for location_1 would be in the report. In this

test case, it is 300.



CR:331123
CR Number:   331123
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 17 Feb 2004 Fixed
Description
Memory leaks when using the Evaluate function in script to evaluate datawindow expressions, and a datawindow visible expression leaks when mousing over the column.



CR:331174
CR Number:   331174
Product Name:   PB Enterprise
Product Component:   DB JDBC
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Nov 2003 DEFER
Description
When trying to compile and save a script where the stored

procedure has 11 or more parameters, receiving the following error message:

(0031): Database C0038 name11 is not a parameter for procedure country_sel



Not able to reproduce the problem here using two different stored procedures for testing--getuid2 and country_sel. Customer is only able to reproduce the

error using the Informix jdbc driver. Works ok using the IN7 and odbc.



The following is the customer's jdbc log:

DriverManager.initialize: jdbc.drivers = null

JDBC DriverManager initialized

registerDriver: driver[className=com.informix.jdbc.IfxDriver,com.informix.jdbc.IfxDriver@8e9b3b17]

DriverManager.getConnection("jdbc:informix-sqli://tsts03:2034/dev_100_pct:informixserver=d100srvnet")

trying driver[className=com.informix.jdbc.IfxDriver,com.informix.jdbc.IfxDriver@8e9b3b17]

SQLWarning: reason(Database has transactions) SQLState(01I01)

SQLWarning: reason(Informix Dynamic Server database selected) SQLState(01I04)

SQLWarning: reason(Informix extension to an ANSI-compliant standard syntax) SQLState(01I06)

getConnection returning driver[className=com.informix.jdbc.IfxDriver,com.informix.jdbc.IfxDriver@8e9b3b17]

SQLWarning: reason(Informix extension to an ANSI-compliant standard syntax) SQLState(01I06)

SQLWarning: reason(Informix extension to an ANSI-compliant standard syntax) SQLState(01I06)

SQLWarning: reason(Informix extension to an ANSI-compliant standard syntax) SQLState(01I06)

SQLWarning: reason(Informix extension to an ANSI-compliant standard syntax) SQLState(01I06)







The customer provided the following logs:

pbtrace.log

listdlls.txt

protocolfile.log (Generated using the informix debug jdbc file and setting PROTOCOLTRACE=3)

informixjdbc.log (Generated using the informix debug jdbc file and setting TRACE=3)

pathandclasspath.txt



CR:331260
CR Number:   331260
Product Name:   PB Enterprise
Product Component:   DW Plugin
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   5.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Sep 2003 Not a Bug
Description
*** Tuesday, September 09, 2003 16:23:18 *** sghayal ***

After reproing the issue locally it seems the issue is either with JConnect or Power builder (most probably Power Builder).



I am seeing the query being executed properly for the connection and appropriate results being got. But it seems Power builder is not able to handle the results got back.



This is not an EAServer Bug. As EAServer is only resposible for providing valid connection to the component, which EAServer did provide it.



This might be critical bug at PB level.



CR:331270
CR Number:   331270
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Aug 2007 Fixed
Description
In N_up datawindows the autosizeheight feature of text columns do not autosize.
Review Status
 [*** Tuesday, June 21, 2005 14:24:02 ***]

This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release".



CR:331274
CR Number:   331274
Product Name:   PocketBuilder
Product Component:   DW Display
Status:   Open
OS:   Pocket PC 2002
Original Version:   1.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
some color cannot be displayed correctly on PocketBuilder Datawindows e.g. ToolsTip
Workaround Description
 No Workaround



CR:331304
CR Number:   331304
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Application icon is lost when reconstituting an application object with version control or export/import.



CR:331316
CR Number:   331316
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 14 Oct 2003 Fixed
Description
A problem with datawindow group boxes not displaying in the XP Operating System when running an exe built using the New Visual Style Controls.



CR:331395
CR Number:   331395
Product Name:   PocketBuilder
Product Component:   DW Display
Status:   Open
OS:   Pocket PC 2002
Original Version:   1.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When customer used Radio Button as the styletype for a colume within a

datawindow, the circle should be displayed as a normal circle. However,

when customer checked for "Scale Circles", the circle will be displayed

as a "Star-like" image within the datawindow, during run-time, when running

on a Pocket PC.
Workaround Description
 No Workaround



CR:331475
CR Number:   331475
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Sep 2003 Fixed
Description
Create a workspace for the PowerBuilder 8.0 Examples application.

Add the examples target to this workspace.

Right click the target and do a search on "if"

You should get a GPF or PowerBuilder will disappear.



CR:331523
CR Number:   331523
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Oct 2003 Not a Bug
Description
Oracle syntax error when retrieving SP datawindow via ODBC connection.



There is a new DBParm available that solves this problem:

StripParmNames='Yes'

This DBParm is available from PB 7.0.3 onwards.



CR:331592
CR Number:   331592
Product Name:   PB Enterprise
Product Component:   DB JDBC
Status:   Closed
OS:   Solaris 2.6
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 May 2007 Presently Not Targeted For Any Future Release Of This Product
Description
Cannot get Turkish characters in a DW with JDBC on Solaris.



Workaround:

Use an ODBC connection instead of JDBC.
Target Version
 



CR:331609
CR Number:   331609
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 22 Oct 2003 Fixed
Description
Can enter alphabetic characters into a numeric editmask.
Target Version
 



CR:331635
CR Number:   331635
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jul 2004 Fixed
Description
PBv9.0.1. is supposed to support the XP features. However, running a generated EXE, the DataWindow columns that have the 3D lowered border style do not take the XP look.



CR:331663
CR Number:   331663
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 08 Oct 2003 Fixed
Description
Copy/Paste to an editmask column seems to work, but tab off the field then old value returns. Regression in 9.0.



CR:331687
CR Number:   331687
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
Getting error "image is too wide for this implementation" when attempting to load a jpeg file into a picture control.



CR:331708
CR Number:   331708
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 22 Dec 2003 Fixed
9.0.1 25 Nov 2003 Fixed
10.0 25 Nov 2003 Fixed
Description
They have a currency column with a format of $###,###,##0 specified. In 7.0.2 with regional settings of English UK they were seeing displays like $124, with no leading zeros. Now in 8.0.3 they are seeing leading zeros: $000,000,124.



CR:331811
CR Number:   331811
Product Name:   PB Enterprise
Product Component:   Menus - Runtime
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 09 Nov 2003 Fixed
Description
In PB 9.0.1, popup menus display oddly - sometimes showing items disable, sometimes showing a separator line instead of the menu item. Appears to occur only in MDI sheets and is related to the MDI window menu's configuration.



Apparently occurs when 1) the list of open sheets is displayed under the first menu item, and 2) there is only one submenu item underneath the first menu item. May not be limited to these circumstances but as yet we have not found others.



Workaround: Either display the list of open sheets under a different menu item, or, if possible, add another submenu item to the first menu item.



CR:331820
CR Number:   331820
Product Name:   PB Enterprise
Product Component:   DB JDBC
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 13 Nov 2003 Fixed
Description
The JDBC interface in PowerBuilder does not handle the lack of a 'schema' within the backend database. See CR 299101 for one example that was partially fixed. The problem manifests itself when issuing metadata queries to bring up table lists, build a datawindow, etc.



CR:331822
CR Number:   331822
Product Name:   PB Enterprise
Product Component:   DB OLE DB
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 19 Feb 2004 Fixed
Description
A regression from 9.0 build 5507. With an OLE DB connection to MS SQL Server, and a datawindow that is in syntax mode (as opposed to graphic mode), when you click the SQL icon to go to the SQL Painter there is a very long delay before the SQL syntax appears in the SQL painter.



CR:331824
CR Number:   331824
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
When data in a column has carriage returns, that column appears to overlap with other rows in a web datawindow.



There are two datawindows, d_prod1 and d_prod2 (updatable). Both datawindows are defined with the following columns:

id integer

description char(30)



When d_prod2 description column is updated with the following data:

This

is

a

test



The appearance in page10 (d_prod1) description field overlaps with the rows below.







page10 (d_prod1 - before update)

<SPAN CLASS=dw-1B7 STYLE="position:absolute; left:0.551in; top:0.021in; width:2.958in" onClick="{return dw_1.itemClicked(0,-1,'description');}" >Tank Top </SPAN>



page20 (d_prod2 - before update)

<TEXTAREA NAME="description_0" ROWS=5 WRAP="off" CLASS=dw-1EE TABINDEX=2 STYLE="position:absolute; left:0.499in; top:0.010in; width:3.792in" onFocus="{dw_1.itemGainFocus(0,2,this,dw_1.gobs.description); dw_1.selectControlContent(this);}" onClick="{var ret; ret= dw_1.itemClicked(0,2,'description'); return ret;}" onChange="{this.bChanged = true;}" onkeypress="DW_EditKeyPressed(-1)" onBlur="{dw_1.itemLoseFocus (this);}">Tank Top </TEXTAREA>



page10 (d_prod1 - after update)

<SPAN CLASS=dw-12E0 STYLE="position:absolute; left:0.551in; top:0.021in; width:2.958in" onClick="{return dw_1.itemClicked(0,-1,'description');}" >This<BR>is<BR>a<BR>test</SPAN>
Review Status
 4/22/2005

This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release".



CR:331844
CR Number:   331844
Product Name:   PB Enterprise
Product Component:   Menus - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Mar 2009 Insufficient info provided
Description
Menus appear to be drawn in a single color and when using an XP theme like Forever Blue, they do not look like other application's menus which are shown in gradated color.



CR:331996
CR Number:   331996
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Sep 2004 Fixed
Description
PB 9.0 components deployed to EAServer - functions overloading ancestor functions are not generating correct name mangled IDL. Unable to call these functions.



CR:332150
CR Number:   332150
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 22 Oct 2003 Fixed
Description
Customer has a report that displays a datawindow nested in the report header, and another in the Summary band.. After moving to build 10011, the full dw does not display in the header, and the dw nested in the Summary band is also missing a row.



CR:332198
CR Number:   332198
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jun 2005 Fixed
Description
Errant characters appear at right of properties pane when resizing.



CR:332270
CR Number:   332270
Product Name:   PocketBuilder
Product Component:   DW - Runtime
Status:   Open
OS:   Pocket PC 2002
Original Version:   1.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When running from IDE, windows CheckBox is TICK, and Datawindow CheckBox is also TICK.

However, when running on Emulator 2002 and PPC2003, windows CheckBox is TICK, but Datawindow CheckBox is CROSS.
Workaround Description
 No workaround



CR:332295
CR Number:   332295
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When viewing a web datawindow, columns with a datatype of long,

char, or varchar display as textareas in the browser. The side effect is that scrollbars

are displaying when they don't need to.



In PB 7.0.3 (build 10047):

<SPAN CLASS=4 STYLE="position:absolute; left:0.875in; top:0.031in; width:0.907in" onClick="{return .itemClicked(2,-1,'code_code_desc_1');}" >Student Transfer</SPAN>



In PB 9.0.1 (build 7006):

<TEXTAREA NAME="code_code_desc_1_0" ROWS=5 WRAP CLASS=htmldw5 TABINDEX=-32766 STYLE="position:absolute; left:0.875in; top:0.031in; width:0.907in" onFocus="{htmldw.itemGainFocus(0,22,this,htmldw.gobs.code_code_desc_1); htmldw.selectControlContent(this);}" onClick="{var ret; ret= htmldw.itemClicked(0,22,'code_code_desc_1'); return ret;}" onChange="{this.bChanged = true;}" onkeypress="DW_EditKeyPressed(-1)" onBlur="{htmldw.itemLoseFocus (this);}">Student Transfer</TEXTAREA>



CR:332305
CR Number:   332305
Product Name:   PB Enterprise
Product Component:   DB Painter
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.2.1 08 Jun 2007 Fixed
Description
If you select "Show system procedures" on popup menu of a connected ODBC database's folder, it marks it checked but doesn't appear to work for PB 8 or 9. In PB 7.0.3 the option is greyed out as it looks as though it should be in both PB 8 and 9 as checking it has no effect.



CR:332348
CR Number:   332348
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Nov 2003 Not a Bug
Description
Customer needs to implement failover support in PB 9 application connecting to Oracle 9i RAC (Real Application Cluster). He has specific questions relating to implementation of the OCI's callback routines in the O90 driver. As we do not document our support for this Oracle feature we are requesting some confirmation/information from development on this.



Answers from development on customer's specific questions regarding PB 9 support of Oracle 9i RAC:



====Question #1

I'm爈ooking燼t爐his燼rticle爎elating爐o燨racle燭AF燼nd燫AC.

http://otn.oracle.com/oramag/oracle/02-may/o32clusters.html



In爐he燼rticle,爐hey爉ake爐his爏tatement:

"For燼n燼pplication爐o爑se燭AF,爄t爉ust爑se爁ailover-aware燗PI燾alls爁rom爐he燨racle燙all營nterface





(OCI).營nside燨CI燼re燭AF燾allback爎outines爐hat燾an燽e爑sed爐o爉ake燼ny

application爁ailover-aware."

I爏till爓ould爈ike爐o爇now爀xactly爓hat燩B爊atively爏upports爁or燾allback爎outines.





Ans ==> PB natively suuports OCI calls only .OCI calls takes

care of the TAF ( Transaction Application Failover ).



=====Question #2



The燼rticle燼lso爏ays爐his:

"Currently,燭AF爓ill爁ail爋ver爏tandard燬QL燬ELECT

statements爐hathave燽een燾aught燿uring燼爊ode燾rash爄n燼n爄n-flight爐ransaction爁ailure.





In爐he燾urrent爎elease爋f燭AF,爃owever,燭AF爉ust爎estart爏ome爐ypes爋f爐ransactions爁rom爐he燽eginning爋f爐he爐ransaction.





Transactions爄nvolving營NSERT,燯PDATE,爋r燚ELETE爏tatements燼re爊ot爏upported燽y燭AF."





Could爕ou爃elp爉e爎elate爐his爐o爉y燩B燼pplication爄f爄t爓as爑sing燭AF燼nd燾onnecting爐o燼燫AC?







Ans ==> We normally make API calls which in turn may call TAF aware API

calls . Through PB we are able to connect to Oracle Failover servers.

"......Oracle OCI client applications can take advantage of automatic

reconnection after failover, replay of interrupted SELECT statements, and

callback functions that help to automate state recovery....." ( from the

sites reffered above)





========Question #3



I'm爐hinking爐hat燼ny燬ELECT爏tatement爓ould爁ailover爐ransparently燼nd燾omplete爓ithout爐he爑ser爀ver爇nowing爄t爋ccurred.





If爄t爓as1/2燿one爐hen爐he爏econd1/2爓ould燽e燾ompleted爋n爐he爊ew爏erver,爀tc...燼nd爐here爓ould燽e爊o



coding爊ecessary爋n爌art爋f爐he燩B爌rogrammer爐o爂et爐his爁unctionality.

(just爉aking爏ure爐he爐snames.ora爄s燾orrect)



For燼n營NSERT,燯PDATE,爋r燚ELETE爏tatement爐hat爓as爄ssued爁rom燼燩B燼pp,爓hat爓ould爃appen?





would燩B爇eep爐rack爋f爐he爏tatements爐hat爓ere爄ssued燼nd爎e-issue爐hem燼gainst爐he爊ew燾onnection?







Ans ====> In Oracle documentation I also found the following statements .

"Database Manipulation Language Clients



Database Manipulation Language (DML) database clients perform INSERT,

UPDATE, and DELETE operations. Oracle handles certain errors and performs a

reconnect when those errors occur.



Without this application code, INSERT, UPDATE, and DELETE operations on the

failed instance return an un-handled Oracle error code. Upon re-submission,

Oracle routes the client connections to a surviving instance. The client

transaction then stops only momentarily until server-side recovery

completes."



====Question #4



What燼bout爄f爉ore爐han爋ne營NSERT爓as爌art爋f燼爈arger爐ransaction,爋r爏ome爋ther燾omplicated燾ombination,爓hat爓ould爃appen?



again爓ould燩B爇eep爐rack爋f爓hat爃as爋ccurred燼nd爎e-issue爐he燬QL燼gainst燼爊ew燾onnection?





Ans ===> Answer to this directly relates to the answer to question 3 above.



CR:332365
CR Number:   332365
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
PDF file from datawindow SaveAs, can't be searched in Acrobat Reader



CR:332435
CR Number:   332435
Product Name:   PB Enterprise
Product Component:   Debugger
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 May 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
During remote debugging choosing "Edit Variable" causes PB to GPF.



CR:332439
CR Number:   332439
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
This is an enhancement request on datawindow HSplitScroll

to allow scrolling in script of the right pane when the

HScrollbar is not enabled.



CR:332446
CR Number:   332446
Product Name:   PB Enterprise
Product Component:   Printing
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 13 Nov 2003 Fixed
Description
When using the printdefinefont with the HP LaserJet 4100

PCL driver, it will default to the WingDings font even though Arial is specified

in the printdefinefont function.



job = PrintOpen("Jim")

lr = PrintDefineFont( job, 2 , "Arial", -10, 400, Variable!, Swiss! , FALSE, FALSE )

IF lr = 1 then

PrintText(job, "This is a test", 2000, 2000, 2)

ELSE

MessageBox("Error", "Print Define Font failed")

END IF

PrintClose(job)



Using the filemon utility, you can see that PB is querying the wingdings.ttf file

instead of the arial.ttf.



CR:332467
CR Number:   332467
Product Name:   PocketBuilder
Product Component:   DB SQLAnywhere
Status:   Open
OS:   Pocket PC 2002
Original Version:   1.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Not reproducible with latest version of the product available as of Resolution Date
Description
Calling DW-Retrieve directly from ItemChanged event will sometimes make the application look busy forever.

If I post it, I get a general failure system error, Exception: oxc00000005,

Address:01fb8860, then the application is forced to be closed.



CR:332489
CR Number:   332489
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement Request: When a value assigned to a variable is larger than the datatype of the variable, raised an exception rather than overflowing.



CR:332516
CR Number:   332516
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Append HTML Syntax is not working for picture controls in a datawindow



CR:332517
CR Number:   332517
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Solaris 2.8
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Sep 2003 Not a Bug
26 Sep 2003 Not a Bug
Description
Createinstance is failing with a distributed service error message.



The same app works ok on the same machine in PB 7.0.3 and 8.0.3 but fails in the createinstance in PB 9.0 (build 5507).



The Jaguar.log shows the following:

Sep 17 16:30:10 2003: Library: 'libpbjag90x.so' for component type 'pb90'

Sep 17 16:30:10 2003: AFLIB Message: 18011/11/0: DLL lookup for 'libpbjag90x.so' failed, OS Message: 'ld.so.1: /../duquette/EAServer/bin/jagsrv: fatal: libCstd.so.1: open failed: No such file or directory'



Sep 17 16:30:10 2003: AFLIB Message: 18011/11/0: DLL lookup for 'libpbjag90x.so' failed, OS Message: 'ld.so.1: /../duquette/EAServer/bin/jagsrv: fatal: libCstd.so.1: open failed: No such file or directory'



Sep 17 16:30:10 2003: DynamicLibrary::lookup: af_dll_lookup (libpbjag90x.so, new_JagComponent) failed

Sep 17 16:30:10 2003: CTS_JagComponent::load: failed to load component model library

Sep 17 16:30:10 2003: CTS_Component::load: failed for component 'sedcsm_pkg/n_sedcsm'

Sep 17 16:30:10 2003: SystemException: OBJECT_NOT_EXIST (sedcsm_pkg/n_sedcsm:Home/create - @199.93.182.34)



CR:332563
CR Number:   332563
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Oct 2004 Fixed
Description
When Jaguar will be restarted during a PB remote debug session Jaguar will crash after Restart and continuing the debugging.



workaround: shutdown and restart Jaguar with Jaguar Manager
Workaround Description
 shutdown and restart Jaguar with Jaguar Manager



CR:332572
CR Number:   332572
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
possible to scroll with DDDW columns in readonly mode



Tabular DW with a DDDW column. DW is read-only.

cannot use the Up or Down Arrow keys if the DDDW has the focus.



CR:332598
CR Number:   332598
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Aug 2004 Fixed
Description
Adding several rows to displaydata on editmask spin control causes GPF in window Painter. Works fine in PB8 or with PB9 and stringmask!



No workaround.



CR:332638
CR Number:   332638
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 23 Oct 2003 Fixed
Description
When saving a datawindow with a column of more than 255 charcters to excel8, will result in that column being truncated to 255 characters

in excel.



The problem happens using the Save Rows As from the IDE or using the saveas().



From the excel online help, the column width limit is 255 but the length of cell

context (text) is 32,767. Only 1,024 display in a cell; all 32,767 display in the formula bar. Having wrap text turn on will result in a column having 32,767 instead

of 255.



CR:332787
CR Number:   332787
Product Name:   PB Enterprise
Product Component:   UO Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Apr 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
press backspace twice then enter in the script painter => GPF
Workaround Description
 non



CR:332788
CR Number:   332788
Product Name:   PB Enterprise
Product Component:   DW Expression
Status:   Open
OS:   Microsoft Windows NT
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement Request: Add function that returns group # for band that the expression is in. Instead of sum(col_x for group 1) sum(col_x for group 2) We could do: sum(col_x for group getbandgroupnumber())



CR:332795
CR Number:   332795
Product Name:   PB Enterprise
Product Component:   DB Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jan 2005 Duplicate
Description
execute a double query in the DB-Painter ISQL session, and do a "save row as ..." results in a PB crash. Datas are saved fine.
Workaround Description
 non



CR:332817
CR Number:   332817
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jun 2004 Duplicate
Description
Displaying a ActiveX Datawindow in IE and once you

select File/New/Window, the ActiveX Datawindow will display but the javascript

events will stop working on the new window.



When using IIS, the error in the log file shows a 304: Using the following code:

META http-equiv="Expires" content=-1

SCRIPT language=javascript event="MouseDown(Button, Shift, XPos, YPos, Row, Name)" for="mydw2" alert("MouseDown");

OBJECT id=mydw2 codebase=psdwc80.cab height="100%" width="100%" classid=88881503-8888-1000-8000-080009AC61A9 name=mydw2



CR:332821
CR Number:   332821
Product Name:   PB Enterprise
Product Component:   WT - Web DataWindow DTC
Status:   Closed
OS:   Solaris 2.8
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Mar 2004 Not a Bug
Description
Buttons on a WebDatawindow are not working. The

WebDw was created thru the Web/JSP Datawindow Page wizard and deployed to a

existing ASA dynamo web site on solaris.



When com.sybase.datawindow.trace is turned on, the trace shows that the

Update, Delete or Insert are not even being called.



CR:332825
CR Number:   332825
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 29 Sep 2003 Fixed
8.0.4 13 Oct 2003 Fixed
Description
If you add additional layouts to an object painter, PB starts leaking handles badly. Every keystroke in a script painter leaks one or two handles.



CR:332828
CR Number:   332828
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Open
OS:   Microsoft Windows NT
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement Request: In the RMB menu in computed columns in the DataWindow painter, add remote stored procedures (i.e., functions).



CR:332835
CR Number:   332835
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement request for virtual/continuous scrolling of freeform datawindows. Currently if the scrollbar is clicked and the actual datawindow fits into the control the click brings the next row into the datawindow control and using the up/down arrow keys does the same. If the actual datawindow row is too large for the datawindow control clicking on the up/down arrow keys brings the next row into the control but clicking on the control itself scrolls within the row.



Customer would like the ability when the actual datawindow row is too large for the datawindow control to specify some sort of virtual/continuous scrolling so that when the up/down arrows are clicked the action initially lets one see the remainder of the current row but then with an additional click brings up the next row.





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具:ReadASADB。
此工具支持ASA v5.0,v6.0,v7.0,v8.0,v9.0,v10.0,v11.0,v12.0等版本。
恢复Sybase SQL Anywhere的工具在国内应该算首创。

ReadASADB功能
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具

  1. 适用于所有的SQL Anywhere版本    包括:5.x,6.x,7.x,8.x,9.x,10.x,11.x,12.x
  2. 适用于所有的UltraLite版本
  3. 能够恢复出来表结构和数据
  4. 能够恢复自定义数据类型
  5. 能够恢复存储过程等对象的语法
  6. 能够导出到目标数据库
  7. 能够导出到SQL文件并生成导入脚本
  8. 支持多种字符集  包括:cp850、cp936、gb18030、utf8等
  9. 能够恢复未加密或者简单加密类型的数据
  10. 简单易用
  11. 限制:不支持AES加密的数据文件
请参考:研发成功了从Sybase SQL Anywhere的DB文件上恢复数据的工具
            SQL Anywhere数据库非常规恢复工具ReadASADB使用介绍

ReadASADB适用场景

各种误操作:

  1. 误截断表(truncate table)
  2. 误删除表(drop table)
  3. 错误的where条件误删数据
  4. 误删除db或log文件
  5. 误删除表中的字段

本工具的应用场景:

1.因为物理磁盘故障、操作系统、系统软件方面或者掉电等等原因导致的Sybase SQL Anywhere数据库无法打开的情况;
2.误操作,包括truncate table,drop table,不正确的where条件导致的误删除等;
Sybase SQL Anywhere无法打开时,比较常见的错误是:Assertion failed。
如:
1、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Checkpoint log: invalid bitmap page -- transaction rolled back
2、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Page number on page does not match page requested -- transaction rolled back
3、Internal database error *** ERROR *** Assertion failed:200502 (9.0.2.2451) Checksum failure on page 23 -- transaction rolled back
4、File is shorter than expected
5、Internal database error *** ERROR *** Assertion failed: 201116 Invalid free list index page found while processing checkpoint log -- transaction rolled back
6、*** ERROR *** Assertion failed: 51901 Page for requested record not a table page or record not present on page等等。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------