提供7*24专业Sybase数据库远程及现场技术支持,Sybase ASE及Sybase SQL Anywhere数据库修复服务,
请联系电话: (微信),QQ: 289965371!
We supply technical support for Sybase ASE and Sybase SQL Anywhere, also have many years of experience in recovering data from damanged Sybase devices.
Please contact us:
Phone:
Wechat: 13811580958
QQ: 289965371 联系我们获取数据库技术支持!
Email: 289965371@qq.com
扫描下方微信,联系我们:
扫描雨翰数据恢复官方微信获取专业数据库恢复服务

 

随着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:264002
CR Number:   264002
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
When deploying a pb component that has a datastore control, the following error is generated:

Generation Messages:
Deployment Error Adding Component IDL For Package 'test' EAServer error code: SystemException: com.sybase.CORBA.idl.SyntaxError: file 'test::u_test `datastore_1', line 1: '`': expected '{'
Workaround Description
 Dynamically create a datastore.



CR:264023
CR Number:   264023
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
Bug or documentation error ?

If you try to suppress repeating values on multiple columns, the suppression fails on the second column unless the data is repeated on both of the selected columns.



04/25/2005:

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



CR:264037
CR Number:   264037
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
In PB8.0 DW painter send a "database error" when modify a dw that have in the FROM a temporary table. Temp is created before modify. New dw have not the problem, only at modify. The SQL session has not changed so the table should still exist.



04/25/2005:

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



CR:264134
CR Number:   264134
Product Name:   PB Enterprise
Product Component:   Library Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0 GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Apr 2002 Fixed
Description
Memory leak in Library painter on Windows 2000. Leak is more obvious if using source control (MSVSS, PVCS, PBNative) Most library operations show a steady memory consumption not just those related to source control.



CR:264256
CR Number:   264256
Product Name:   PB Enterprise
Product Component:   DB OLE DB
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Nov 2001 Fixed
Description
Saving and retrieving to OLE Database Blob Column in DW PB8, MSS, Image datatype is broken and causes PB to hang.



CR:264258
CR Number:   264258
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Dec 2001 Fixed
Description
Crash on inserting nvo that does not exist through menu item



CR:264287
CR Number:   264287
Product Name:   PB Enterprise
Product Component:   DB Painter
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Mar 2004 Third Party Problem
Description
The problem is that 'Foreign Key' information when the setting in pbodb70.ini is PBTableOwner='NO' with database DB2/AS400 is missing

- on the table information(e.g. use 'Export syntax' operation)

and

- on the "Object Layout" view/pane



Result of investigation is 'Not a Powerbuilder bug'.

There is a limitation with DB2/AS400 handling an ODBC API call for Foreign Key info. Suggest that customer escalate this defect to IBM vendor.



The problem is no longer reproducible with the latest driver provided in IBM AS400 Client access v5 r1 s101907 (version 8.0.2).



CR:264338
CR Number:   264338
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Mar 2002 Fixed
Description
Using NT Authentication, declaring a public synonym is not working correctly. It is necessary to prefix the stored procedure with the owner name.

WORKAROUND: Call the stored procedure as a remote procedure call.



CR:264423
CR Number:   264423
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Nov 2002 Fixed
Description
GIF Transparency not displayed in Menu, Tabpage, TreeView and ListView - extension to CR 189973



CR:264425
CR Number:   264425
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Feb 2002 Presently Not Targeted For Any Future Release Of This Product
Description
PBL migration from 5.0.02 to 7.0.3_10108 truncates nested report areas near to right margin in all composite datawindow

Per PB Engineering, not to be fixed (see 3 workarounds below):
1. There are some feature difference between PB5 and PB7.
2. In PB whenever you insert a nested DW, it will automatically calculate the size of the DW and put the nested DW accordingly.
3. In PB5, you can reduce the width of the nested DW up to some extent and the full DW will be shown at Run / Preview. This is a PB5 feature.
4. In PB7, if you reduce the width of the nested DW, the reduced nested DW will be shown at Run / Preview. This is a PB7 feature.
5. In this CR, the original application in PB5 contains nested DW with reduced width. In PB5 it is showing properly (point 3). But after migration to PB7, the nested DW are clipped (point 4).

We know the root cause, but cannot do any change in source code because of these feature differences. We suggest to use one of the following work arounds

1) In PB5 before migration, increase the width of the nested DW. Then migrate to PB7.
2) In PB5 before migration, delete the nested DW and insert again. Without changing the width migrate to PB7.
3) In PB7 after migration, delete the nested DW and insert again.
Workaround Description
 See customer Visible description for workarounds.



CR:264505
CR Number:   264505
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Composite DW with no rows returned and trailer property unchecked throws an exception.



CR:264617
CR Number:   264617
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jan 2002 Fixed
1055 10 Jul 2002 Fixed
Description
After modifying a dw and returning the from sqlpainter,
the following error message appears:
Database error: Error parsing command: Unexpected token in FROM clause,
could not create table list

The datawindow was created using the following select:
select 1 from (select 1, 2 from dual)

Once the datawindow is created and you go back and modify the sql to:
select 1 from (select 1,2,3 from dual)

While returning back to the sqlpainter, you will see the error messages.



CR:264727
CR Number:   264727
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Feb 2004 Fixed
Description
spaces disappear in dw editmask type upper (!!!!!!!) after tabbing out

workaround:

long ll_row
ll_row = dw_1.GetRow()
string ls_string, ls_upper
ls_string = dw_1.GetitemString(ll_row,"dept_name")
ls_upper = Upper(ls_string)
dw_1.SetItem(ll_row, "dept_name",ls_upper)
Workaround Description
 long ll_row
ll_row = dw_1.GetRow()
string ls_string, ls_upper
ls_string = dw_1.GetitemString(ll_row,"dept_name")
ls_upper = Upper(ls_string)
dw_1.SetItem(ll_row, "dept_name",ls_upper)



CR:264732
CR Number:   264732
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jun 2005 Fixed
Description
elated to CR 147252 Changing the visible property of a column does not affect label style dw's document that the visible property is not usable for Label Style datawindow. See below.



CR:264734
CR Number:   264734
Product Name:   PB Enterprise
Product Component:   SQL Painter
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   8.0 GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
This is an enhancement request for PowerBuilder datawindow sql painter to convert Adaptive Server Enterprise release 11.x outer join syntax to 12.x ANSI outer join syntax.
Regarding interpretation of 'Adaptive Server Enterprise proprietary outer join syntax' to 'ANSI outer join' to determine the inner table 'constant' criteria and move it to the 'ON' clause. This would then produce the identical
resultset which customer gets from ASE 11.x server.
Workaround Description
 Alter the datawindow sql statement in the development environment or dynamically at application runtime.



CR:264735
CR Number:   264735
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
If a dw is built with many columns that extend several pages across, then columns were destroyed dynamically to less than a page wide, it prints the same number of pages as before the destroy.
The pages where the columns were destroyed are blank.



CR:264766
CR Number:   264766
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0 GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.1 9050 09 Jan 2002 Fixed
05 Jul 2002 Fixed
Description
Function list and event list would be easier to use, especially in applications using a lot of inherited methods, if there were an option to either
a) toggle on and off a 'show inherited functions/events' context menu option or
b) an option to order event / function list so that inherited methods appear last in the list in these cases



CR:264782
CR Number:   264782
Product Name:   PB Enterprise
Product Component:   DW Plugin
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 May 2002 Fixed
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
DataWindow plugin scroll bars are not created properly & the Browser will GPF when exiting the page



CR:264813
CR Number:   264813
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Dec 2001 Fixed
Description
While the GetLatestVersion process is being done in PB, if I open notepad or any other application I might have running on my taskbar and minimize it again, PB is showing repaint problems. Everything is white except the output view, because we are sending info to this view about the object hence it gets refreshed.



CR:264894
CR Number:   264894
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
Retrieve does not work if retrieval arg is based on a decimal and disablebind=0 . Happens for Decimal data whose first number is a 0 and last number is an odd number (1,3,5,7,9)
Workaround Description
 1. Either set disablebind=1 with the native interface (this is it at the cost of performance) or use the Merant ODBC driver.



CR:264895
CR Number:   264895
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jun 2005 Presently Not Targeted For Any Future Release Of This Product
Description
While searching for menu object functions in the system tree, double click on a line in the output window, the menu painter opens but doesn't go to the right function.
Review Status
 This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release".



CR:264900
CR Number:   264900
Product Name:   PB Enterprise
Product Component:   DB Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0 GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Aug 2002 Fixed
Description
Psr(nested or composite) created in a previous version and then opened in PB 8 will give error



CR:264969
CR Number:   264969
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 17 Dec 2001 Fixed
11 Jul 2002 Fixed
Description
When virtual scrolling was introduced in PB 6.0 there were complaints from customer that the group headers were repeating when they scrolled with the thumbnail. A gray line was introduced to indicate to the customers that they had crossed a fixed page.



Customer would like to have the option to disable this gray line. The repeated group headers cannot be removed and they would need to understand that.



Submitted to development for scoping of including an option to disable the gray line.



Update from Engineering:

For PB 9.0, a new UI datawindow attribute has been introduced to control this.



FOR PB 7.0.3 build 10140 and PB 8.0.1 build 9048 and above, users need to use a new undocumented dot notation to eliminate the gray line:



To disable the gray line add this line of code "dw_1.object.datawindow.hidegrayline=true" usually at the end of the code for the window open event.
Workaround Description
 New undocumented dot notation to eliminate the gray line FOR PB 7.0.3 build 10140 and PB 8.0.1 build 9048 and above:



To disable the gray line add this line of code "dw_1.object.datawindow.hidegrayline=true" usually at the end of the code for the window



CR:265072
CR Number:   265072
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
In the expression dialogs of the datawindow painter, errornously retrieval
argument array types are listed in the column list.
They cannot be used in expressions since datawindow expressions do not include the notion of an array.



CR:265073
CR Number:   265073
Product Name:   PB Enterprise
Product Component:   Menu Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Dec 2001 Fixed
Description
GPF in the menu painter when setting the toolbarItemBarIndex of a menu item to a value greater than 100.
Workaround Description
 non



CR:265077
CR Number:   265077
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Feb 2002 Not a Bug
Description
Scrolling horizontally with right, center justify in decimal column doesn't work with edit mask control or in the dw.

Per PB Engineering, this is not a PB bug, it is a Microsoft issue:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnwui/html/msdn_editctls.asp

Workaround:
For the dw control, can they try using an approach similar to:

Add to the editchanged event:
choose case ls_column_name
case "testleft"
if len(data) > 7 then
dw_1.object.testleft.width = 700
end if
case "testright"
if len(data) > 7 then
dw_1.object.testright.width = 700
end if
case "testcenter"
if len(data) > 7 then
dw_1.object.testcenter.width = 700
end if
caseif len(data) > 7 then
dw_1.object.testjustify.width = 700
end if
end choose

In the sle, can they try adding the user event with the id of pbm_enchange with the following code:
if len(em_1.text) > 6 then
em_1.width = 600
end if
return 1



CR:265087
CR Number:   265087
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 20 Nov 2002 Fixed
Description
Show difference seems to add a blank line if Delete PB Generated Object file is not checked.



CR:265211
CR Number:   265211
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
If you set the Editmask and edit format to "!!! !!! !!! !!! !!!!" (stringmask!), you position after the 4th character and hit backspace two times the cursor gets stuck - you cannot type anymore (beep sound). Only moving the cursor with the arrow keys is possible. That seems to be old behavior (checked back to PB 5) but the cursor should be moved to the next group, like it is happening when using the mouse.



CR:265212
CR Number:   265212
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2004 EOL'd version. Not to be Fixed.
Description
If you set the Editmask "!!! !!! !!! !!! !!!!" (stringmask!), you highlight the 4th character and hit backspace you'll get a square. (looks like a regression of CR 218342).



CR:265213
CR Number:   265213
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 May 2005 Fixed
Description
If you set the Editmask "!!! !!! !!! !!! !!!!" (stringmask!), you highlight the 4th character and hit backspace you'll see that the character is deleted, but after the deletion, when typing new characters the mask is lost !
Review Status
 *** Tuesday, May 10, 2005 14:44:19 ***

FOR INTERNAL USE ONLY

This CR was reviewed as part of the Quarterly Review of New Non-Escalated CRs project. It can be closed because it is fixed in PB10.2 build 8011.



CR:265224
CR Number:   265224
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
The restart function does not disconnect from the database currently as documented.

Work-around:
Add disconnect statements in the scriptline before restart.



CR:265337
CR Number:   265337
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   8.0 GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jan 2002 Fixed
Description
FLT_DIVIDE_BY_ZERO CPU glitch against PB Graph DW gets GPF in PBDWE80.DLL

Problem does not occur on Windows 2000, only Windows 98 and Windows 95 (not certified for PB 8.0)



CR:265361
CR Number:   265361
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
The problem appears for a populated datawindow which is in print preview mode. When the Reset() function is called, this causes the vertical scrollbar to halt/ freeze.
This breakage does matter when:
-the vertical scrollbar is in ANY position other than the starting position (top of vertical scrollbar).
AND
-it is no longer possible to vertical scroll up and down (even on a blank print preview page) whereas the horizontal scroll bar (hscrollbar) is working correctly/ operational.



CR:265375
CR Number:   265375
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Status refresh rate should show new objects in the repository but not in the local target



CR:265392
CR Number:   265392
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 02 Dec 2002 Fixed
26 Jan 2003 Fixed
Description
The SetLibraryList function should not be used to set the library list of a component running in EAServer on any platform.



Workaround:

To modify the library list after deploying the component, specify the library list in the com.sybase.jaguar.component.pb.librarylist property in the component's properties file or in Jaguar Manager.



CR:265451
CR Number:   265451
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   8.0 GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
It would be SO useful if the ToDo List could be tied into the debugger. In other words, in the debugger, selecting a "Create ToDo List Item" would automatically link into the object, method that is currently in the debugger. You could then easily add tasks that need to be done to your code while debugging, when so many of the tasks you will need to do will come up.



CR:265473
CR Number:   265473
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
Customer is trying to use the SEND function in his application to arrange his icons in different ways. One of the parameters for the send function is the "lowword" which tells the function which way it wants the contents of the handle (of a object which is also passed as a parameter. this object is mostly a window) to be arranged. In Powerbuilder 6.5 this function works perfectly but in 8 it does not.



NOTE: This is most likely a difference between the Sybase implementation of the Listview control which was used in PowerBuilder 6/6.5 and the Microsoft implementation of the Listview control which has been used in PowerBuilder starting with version 7, so it is possible that this behavior will be outside of the control of PowerBuilder in version 7 and later.



04/25/2005:

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



CR:265506
CR Number:   265506
Product Name:   PB Enterprise
Product Component:   DW Expression
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jan 2002 Not a Bug
Description
Format expression on a dw column displays incorrect data. This turned out to not be a bug. The user was using the display format expression incorrectly.



CR:265555
CR Number:   265555
Product Name:   PB Enterprise
Product Component:   WT - Web DataWindow DTC
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0 GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 May 2003 Not a Bug
Description
Web DW generated HTML code gives an error if a PSPARAMS is used with the new web DW container object



CR:265566
CR Number:   265566
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Dec 2001 Fixed
Description
This is probably a dupe of cr 261356 with a different application causing the crash
Using the Advance Powerbuilder Utilities application I can get PB 8.0 build 9017 to crash if I do a GetLatestVersion on the target and select mulitple file, do a select all. If I select individual pbls it is fine. I have reproduced the crash using PBNative and VSS. Full rebuild of the target/workspace is also successful.



CR:265570
CR Number:   265570
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
The geturl function not returning entire html page
being accessed.



CR:265601
CR Number:   265601
Product Name:   PB Enterprise
Product Component:   Workspace and Targets
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
Cannot reopen a workspace when the extension

has been renamed from .pbw to .pbw.



Getting error of:

d:\pse-80\testextension.PBW is not a workspace
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:265711
CR Number:   265711
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.1 9107 29 Apr 2002 Fixed
07 Aug 2002 Fixed
Description
DW column with propertie "REQUIRED" checked.
Inserting a new row triggers a Message Error "Value required for this item"
Workaround Description
 disable "required" propertie before insert a row and
enable "required" propertie directly after the insert



CR:265736
CR Number:   265736
Product Name:   PB Enterprise
Product Component:   Library Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jan 2002 Presently Not Targeted For Any Future Release Of This Product
Description
PB8.0.1 crashes after exporting and importing objects from one pbl which replace existing objects on another pbl. The crash happens when you double click on the imported window. The full application runs in development.

PER DEVELOPMENT:
Nothing can be done about this. This is a user created problem, which is equivalent to corrupting any pbl manually. Even the crash is outside of PowerBuilder's control at this point.

Clarification :
This window has a olecustomcontrol on it. Every olecontrol has got binary data (contains information about the olecontrol) associated with it.
For example, you can see the export file of the window (see at the bottom of the file)
1. export of window from new.pbl
Start of PowerBuilder Binary Data Section : Do NOT Edit
08w_dbxfer.bin 2027 (2027 is length of data)
200705004000000000060d00000000010007050040000001000705000 ..........
18w_dbxfer.bin 2027
End of PowerBuilder Binary Data Section : No Source Expected After This Point
2. export of window from dbxfer.pbl
Start of PowerBuilder Binary Data Section : Do NOT Edit
08w_dbxfer.bin 4612
2000001200e011cfd0e11ab1a1000000000000000000000000000000000003003e0009fffe..........
18w_dbxfer.bin 4612
End of PowerBuilder Binary Data Section : No Source Expected After This Point
3. export of window from new.pbl after removing compilation error.
Start of PowerBuilder Binary Data Section : Do NOT Edit
08w_dbxfer.bin 3076
2000000c00e011cfd0e11ab1a1000000000000000000000000000000000003003e0009fffe..........
18w_dbxfer.bin 3076
End of PowerBuilder Binary Data Section : No Source Expected After This Point

Giving this introduction, let me clarify some points
1. Window in the new.pbl refers to member variable 'integer_option1' of str_options. str_options of dbxfer.pbl does not have this variable. This is the reason we get compilation/regeneration error when we put new.pbl in the bottom of the library list (this time it picks up str_options from dbxfer.pbl, as this comes first in the list) and do not get any error when we put new.pbl in the top of the library list(this time it picks up str_options from new.pbl, as this comes first in the list).
If we export 'str_options' from new.pbl and import it into dbxfer.pbl, we will not get any compilation error.

2. When we unzip the pbls from the uploaded test case we can successfully open 'w_dbxfer' from new.pbl without crashing. While opening the window, it tries to put the olecustomcontrol(ole_zip) in the window. In this process it reads the binary data (example 2) from dbxfer.pbl instead of new.pbl. To pickup the data, it searches the library and get first occurrence of 'w_dbxfer.bin' in dbxfer.lib. Since these data are OK, pb can open the window.

3. When we unzip the pbls from the uploaded test and change the libpath to put new.pbl at the front and try to open the window it crashes. While opening the window, it tries to put the olecustomcontrol(ole_zip) in the window. In this process it reads the binary data (example 1) from new.pbl. Since these data are corrupted, pb crashes.

Note: steps to make the window import successfully
i) Unzip the pbls from the uploaded test case and open the target in PB.
ii) Export 'str_options' from new.pbl and import it into dbxfer.pbl
iii) open the Window from new.pbl and save the window forcefully (typing a character and deleting the same will enable the save button) to generate the correct binary data for the olecustomcontrol in the window.
iv) Export the window from new.pbl and import it into dbxfer.pbl



CR:265748
CR Number:   265748
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0 GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.1 9123 13 May 2002 Fixed
07 Aug 2002 Fixed
Description
Datawindow with AutoSizeHeight enabled for detail band gives the following behaviour when clicking on dw vertical scroll arrow.



With 1st row at top of page click once on down arrow

Once again on up arrow -> instead of scrolling back to the top it scrolls to the last row in dw

The cursor remains on the first row .



Workaround:

In ScrollVertical event of dw



This.SetRedraw(False)

This.Post event ue_PostVScroll()



And in the user event ue_PostVScroll()

This.SetRedraw(True)
Workaround Description
 In ScrollVertical event of dw



This.SetRedraw(False)

This.Post event ue_PostVScroll()



And in the user event ue_PostVScroll()

This.SetRedraw(True)



CR:265767
CR Number:   265767
Product Name:   PB Enterprise
Product Component:   System Runtime Functions
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement Request: Extend all internal PB functions to throw exceptions when returning a -1 (error condition) return code.

Example: SetTransObject, Retrieve, Update, etc.
Business Reason:
Use Try, Catch, Finally techniques to perform complete error processing rather than Try Catch AND return code check.



CR:265838
CR Number:   265838
Product Name:   PB Enterprise
Product Component:   System Runtime Functions
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Nov 2001 Not reproducible with latest version of the product available as of Resolution Date
Description
Customer wants to know conditions in which AddPicture would return a -1



CR:265856
CR Number:   265856
Product Name:   PB Enterprise
Product Component:   UO - Runtime
Status:   Closed
OS:   NT4
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
PB issuing a "use " command even when the database name was not specified on the transaction object.
This issue relates to Jaguar deployment using Jar file. Since production database name is different from development, customer has to change the code in the transaction object to be able to deploy using "Jar" file.



CR:265876
CR Number:   265876
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0 GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jan 2004 Workaround
Description
dw numeric format #,###,##0.00 with currency is not displayed as the data(value) is.

under conditions of having done this cr's workaround : "Symbol" + String(col, "#,##0.00")

i.g ) input 3,000,000 with currency("⊥") then displayed like as "⊥3,300,000.00 .



Solution:

The Customer was able to use ORCA to modify their DataWindow source code, and no PB code change was required.
Workaround Description
 [New Workaround : "'"+ curr + "'" + "##,##0.00" ]



CR:265917
CR Number:   265917
Product Name:   PB Enterprise
Product Component:   DW ActiveX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 May 2005 Presently Not Targeted For Any Future Release Of This Product
Description
Web Targets in PB8, the code developed for embedding PSR in Datawindow ActiveX is incorrect. The psr location is put in the "SourceFileName" tag instead of the "DataWindowObject" tag.
Workaround: Move the location of the psr from the SourceFileName TAG to the DataWindowObject tag
BEFORE :
<PARAM NAME="SourceFileName" VALUE="X:\PB8\deptlist.psr"></PARAM>
<PARAM NAME="DataWindowObject" VALUE=""></PARAM>

AFTER :
<PARAM NAME="SourceFileName" VALUE=""></PARAM>
<PARAM NAME="DataWindowObject" VALUE="X:\PB8\deptlist.psr"></PARAM>
Workaround Description
 Workaround:
Move the location of the psr from the SourceFileName TAG to the DataWindowObject tag



CR:265932
CR Number:   265932
Product Name:   PB Enterprise
Product Component:   DW Wizards
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2004 EOL'd version. Not to be Fixed.
Description
The problem is for Microsoft SQL Server (MSS) master database system stored procedures are invisible/ not-displayed in the Powerbuilder 8x development environment.
E.g.
In datawindow creation wizard, select checkbox 'system procedure'.
Notice the master database system stored procedures are missing in the selection
(object beginning with sp_XXX e.g. sp_pkeys, sp_addtype ) are not displayed in the
DW creation wizard
Workaround Description
 System procedures do exist on the master database so therfore can be utilised. Powerbuilder front-end tool visibility is just impacted by this breakage.



CR:266054
CR Number:   266054
Product Name:   PB Enterprise
Product Component:   DW Wizards
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.x Catalina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
The problem is affecting datawindow creation using the wizard when the data source is Microsoft SQL Server (MSS) database system stored procedures.
Some system stored procedures fail when chosen as the data source.
E.g.
For stored procedure sp_pkeys, DB error info is:
"The database name component of the object qualifier must be the name of the current database"
and the DW creation fails.
For stored procedure sp_fkeys, DB error info is:
"Could not find server '0' in sysservers. Execute sp_addlinkedserver to add the server
to sysservers.
For stored procedure sp_depends, DB error info is:
"The object '0' does not exist in the database 'pubs'.
Workaround Description
 Create dw on demand/ dynamically, use syntaxFromSQL function. sql_syntax = "execute sp_pkeys t20243766"
dwsyntax_str = sqlca.syntaxFromSQL(sql_syntax, presentation_str, errors)



CR:266055
CR Number:   266055
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jan 2002 Fixed
11 Jul 2002 Fixed
Description
Native driver pbmss80.dll truncates decimal part of numeric(5,1) db column
This error happens when declaring a cursor and fetching data via PowerScript and when db column datatype is numeric(x,x) -in my case it is numeric(5,1). With float db datatype column it works fine.
Workaround Description
 Use datastore and GetItemNumber, instead. See repro application



CR:266091
CR Number:   266091
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   8.0 GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In the datawindow painter, when you lasso fields and exit, you get the "Do you want to save changes?" But no changes have been made and this prompt should not occur.



CR:266168
CR Number:   266168
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ENHANCEMENT REQUEST
when you create a datawindow based on a store procedure on SQLServer 7.x in the preview pane of the procedure from the creation wizard you can visualize only few lines of the procedure.
Workaround Description
 non



CR:266189
CR Number:   266189
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Feb 2002 Not a Bug
01 Feb 2002 Not a Bug
Description
Connecting to Oracle Connection Cache in PB 7 when jaguar is running as a service fails .

Per PB Engineering:
This is NOT a bug.
Need to set JAGUAR_JAVAVM environment variable pointing to the jdk being used on the server machine, remove and create the service again.
Workaround Description
 Start Jaguar manually not as a service.



CR:266280
CR Number:   266280
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jan 2002 Fixed
1046 08 Jul 2002 Fixed
Description
If the dw is switched the second time into querymode PB cause GPF ( 0xC0000005 0x106AD53C ) with PFC query mode and pbm_dwnkey event is used.

Workaround:
reassign the dataobject of the datawindow before switching into querymode.
Workaround Description
 Workaround:
reassign the dataobject of the datawindow before switching into querymode.



CR:266284
CR Number:   266284
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
Long fieldnames (columnnames) (that can occur when using eg. nested Oracle objects) are truncated and when trying to set them updatable in the painter gives error "<Field Name> is not in table <Table Name>"

Workaround:
Edit the exported syntax to reflect the correct column names.
Workaround Description
 Edit the exported syntax to reflect the correct column names.



CR:266321
CR Number:   266321
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jun 2005 Presently Not Targeted For Any Future Release Of This Product
Description
Setting SQLCA.lock for PowerBuilder 8 components using JDBC connections has no effect.



Work-around: set the property com.sybase.jaguar.component.iso_level for the component.
Review Status
 [*** Tuesday, June 21, 2005 12:00:34 ***]

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



CR:266323
CR Number:   266323
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Would like the ability to edit the proxy object in PB 8



CR:266326
CR Number:   266326
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jun 2002 Fixed
Description
An edit field (not edit MASK) with format of @@@-@@-@@@@ displays the format string itself when a WebDW column value with that format receives focus. (This applies to any format mask.)



CR:266329
CR Number:   266329
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 May 2002 Fixed
Description
Using the Web Datawindow, an edit field (not edit MASK) with format of MM/DD/YYYY does not retain the 4-digit year if you enter a 2-digit year when modifying the field. In very recent builds (8004 and 9017) a two-digit year entry would cause validation to fail. That no longer happens; however, the format remains with the 2-digit year versus being changed to 4-digit upon the field losing focus.



CR:266342
CR Number:   266342
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Aug 2002 Fixed
Description
The format routines in the javascript caching files generated for string, dates and number handling make reference to an htmldw object that is not defined.

When using PB8 to generate the JavaScript files for enabling caching for the WebDW functionality (specifically the files for handling strings, dates, and numbers), a couple of lines of script reference an object named htmldw. That object will only exist (as a global variable) if the datawindow object has the ObjectName property (on the Javascript Generation tab) set to 'htmldw' or blank (default is 'htmldw').



CR:266345
CR Number:   266345
Product Name:   PB Enterprise
Product Component:   DB OLE DB
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2001 Fixed
Description
Pb 8 crashes when trying to connect via SybaseASEOleDB(2.50.33)



CR:266346
CR Number:   266346
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Mar 2004 Not reproducible with latest version of the product available as of Resolution Date
Description
8.0 Regression, unprotected column in first row of dw doesn't get focus when clicked on but does when tabbed to. The column has a protect expression which sets protect to 0 (should allow focus).



03/05/2004: This issue no longer reproduces in 8.0.4 build 10616, and appears to be working correctly.



CR:266435
CR Number:   266435
Product Name:   PB Enterprise
Product Component:   Machine Code Exe Creation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.2 19 Aug 2002 Fixed
Description
IsValid() with datatype of ANY causes machine code

compile to fail when used within an IF statement.



ANY l_var1

if isvalid(l_var1) then

end if



CR:266458
CR Number:   266458
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   8.0 GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.1 9054 08 Jan 2002 Fixed
17 Jul 2002 Fixed
Description
The problem is affecting datawindow SaveAs type 'PSR' functionality when
- a filter has been applied to the datawindow rows.
- datawindow contains a base and one nested report.
Perform the save datawindow to PSR format. Load the PSR report in datawindow control or Windows Netscape browser plugin. Notice the base report displays however the nested report is blank/ has no data.
Workaround Description
 Permanently remove the filtered rows from the datawindow buffer. Then define and apply a blank filter e.g. dw_source.SetFilter(''). Then save the dw to psr.



CR:266477
CR Number:   266477
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.1 9085 03 Mar 2002 Fixed
03 Jul 2002 Fixed
Description
Truncated foldernames and .prp names getting created in archive folder
If location of workspace is different than the target and pbls then in the archives has a folder for each object and
the corresponding .prp name truncated.



CR:266486
CR Number:   266486
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Solaris 2.6
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 Fixed
Description
Jag_logfile not working on unix.



CR:266553
CR Number:   266553
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
Icons created outside of PB (other than Watcom Image Editor) that are associated to 'DragIcon' cannot be displayed as expected if its resolution's different from 32x32 and 2 or 16 colors.
Using eg. 16x16x16 or other resolution and color settings yield in garbage display or GPF.

WA:
resolution that works are icons created with Watcom Image Editor: 32x32x16 color
Workaround Description
 resolution that works are icons created with Watcom Image Editor: 32x32x16 color



CR:266576
CR Number:   266576
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 2002 Fixed
Description
System procedures box on Stored Procedure dialog in dw painter disabled



The System Procedure checkbox is disabled in the datawindow stored procedure wizard.

Its disabled for SYC, O84, MSS, in7. Works ok for odbc.



CR:266589
CR Number:   266589
Product Name:   PB Enterprise
Product Component:   DPB
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
Distributed Powerbuilder application. Whenever a second instance of a client tries to connect to the server applicationl, PB crashes with R20445 error. The first instance does not seem to throw this error. The problem occurs in Machine Code only.

Possible dupe of CR 232181.

WORKAROUND: use p-code. The problem does not occur if you use PBDs instead of DLLs.



CR:266593
CR Number:   266593
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Dec 2001 Fixed
Description
When using Ctrl-C/ Ctrl-V to cut and paste a visual object on a tab page from one tab to another CPU usage spikes to 100 % and one is forced to shut down PB. If one right clicks and uses cut and paste from within PB then there is not a problem.



CR:266600
CR Number:   266600
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jan 2002 Fixed
11 Jul 2002 Fixed
Description
8.0 Regression, after dw modify, can't click on unprotected fields



CR:266601
CR Number:   266601
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Dec 2002 Duplicate
Description
When saving a dw that has a column with a edit
style of checkbox and you select the property 3 state, after saving the dw
and calling it back up again the 3 state property remains unchecked.

If you supply a value for "Data value for On" and "Data value for OFF", then
then the 3 state property will remain checked. There is no edits when
you save the datawindow and require this.
Workaround Description
 If you supply a value for "Data value for On" and "Data value for OFF", then
then the 3 state property will remain checked. There is no edits when
you save the datawindow and require this.



CR:266671
CR Number:   266671
Product Name:   PB Enterprise
Product Component:   Automation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2004 EOL'd version. Not to be Fixed.
Description
After the declaration of an Array as an instance variable in a nvo used for Automation, the instance variables after the array cannot be accessed properly anymore. The contents are scrambled values.
Regression starting in PB 7.03 build 10089. Works ok in earlier builds.



CR:266729
CR Number:   266729
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.1 9098 15 Mar 2002 Fixed
04 Jul 2002 Fixed
Description
If you advance through the fields in the datawindow causing it to scroll and
then press <Enter> in a field to advance to the next one, using <Shift-Tab>
to move to the previous field causes the datawindow to repaint incorrectly.



CR:266745
CR Number:   266745
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.1 9098 15 Mar 2002 Fixed
Description
In a freeform dw that you press enter to advance to
the next field, causes the dw to scroll incorrectly and the field that you just
entered data into to be cleared out.



CR:266758
CR Number:   266758
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
Garbage Collection of datastore causes PB to crash.



CR:266839
CR Number:   266839
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
GetItemString, GetItemAny and GetItemNumber gives application execution error R0006 invalid datawindow row/column specified when columnname is longer than 49 characters.

Workaround:
If possible, use dot notation to access the value of a long columnname column.
Workaround Description
 If possible, use dot notation to access the value of a long columnname column.



CR:266888
CR Number:   266888
Product Name:   PB Enterprise
Product Component:   ORCA
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 May 2002 Fixed
07 Aug 2002 Fixed
Description
When trying to regenerate datawindow through ORCA you will see a crash but the same datawindow can be regenerated without a problem through PB.



CR:266919
CR Number:   266919
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Aug 2004 Duplicate
Description
A grouped datawindow does not scroll properly with the down arrow key.



CR:266986
CR Number:   266986
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jan 2002 Fixed
9.0 1057 06 Aug 2002 Fixed
Description
Description of Problem: PB7.0.3 get exception when using DW Graph or Win. Graph object with OLD HP Printer driver.
Problematic Driver and related library module :
LaserJet 5000 & 4000 PCL6 -
HPBXLB.DRV.
HPBXLB1.DLL
HPBXLB2.DLL
HPBXLB3.DLL
HPDCMON.DLL

LaserJet 5000 & 4000 PCL 5e -
HPBPCLA.DRV
HPBPCLA1.DLL
HPBPCLA2.DLL
HPBPCLA3.DLL
HPBPCLA4.DLL
HPBPCLA5.DLL
HPDCMON.DLL
HPTABS16.DLL

Tracing on the sequence of DLL loading , some information may help to explain the error. By default on Win95 / 98 the printer driver will only be loaded as need and removeed after use. Our PB graph / dw graph control will load and use the default printer driver to render the Graph. It seem that PB 7.0.3 datawindow engine will occpy the same memory space the Printer driver asking for. Thus it seem that when dw engine load first, the printer driver will not use an alternative memory space.
Workaround Description
 use new driver : HP LaserJet 4000 PCL 6 driver(American English) http://www.hp.com/cposupport/printers/software/lj308en.exe.html



CR:267046
CR Number:   267046
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Oct 2002 Fixed
Description
Web datawindow which has a string column. The data in the string coulmn has double quotes. When running the web datawindow and viewing the column the string column displays a backslash instead of the string with double quotes. If you click on the column you get the correct data.



CR:267096
CR Number:   267096
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 10 Jul 2002 Fixed
07 Aug 2002 Fixed
Description
Following Syntax Using the datawindow Painter (Convert to Syntax):

Select c.a, c.b

From (Select 'A' a,

'B' b

from Dual) c



The datawindow will Build, and if you do a retrieve in the Preview Pane, Data is returned. Next Go back to the data Source (SQL Button on the tool Bar) and then Add a space in in the SQL Statement. Ie.

Select c.a, c.b

From (Select ' A' a, //Put a space in front of the A

'B' b

from Dual) c



When you return to the Datawindow you will get the following Datawindow Error

DataWindow

DataBase Error:

Error parsing command: Unexpected token in FROM clause, could not create table list.



CR:267270
CR Number:   267270
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Even when the status refresh interval expires, the status of the object is not automatically updated on the screen, it requires a refresh of the pane (or expansion of a node that has not previously been expanded)



CR:267294
CR Number:   267294
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jan 2002 Fixed
16 Jul 2002 Fixed
Description
When a psr report is saved from the powerbar or in script and
there's a dddw, pb will crash when trying to view the psr in pb or thru a browser.

If the psr report is saved thru the datawindow painter, than it works ok. You can
view the psr thru pb.
Workaround Description
 Save psr file from the datawindow painter instead of invoking it from the powerbar(File/Run..Preview).



CR:267308
CR Number:   267308
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Feb 2002 Fixed
Description
When a dw has a dddw and its saved to a psr report
in the dw painter, when viewed thru a pb application or browser the data value
shows instead of the display value.



CR:267315
CR Number:   267315
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 26 Jul 2004 Fixed
Description
Edit properties for a column in a datawindow are not saved correctly.



CR:267431
CR Number:   267431
Product Name:   PB Enterprise
Product Component:   Pipeline Painter
Status:   Closed
OS:   NT4
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Request that 'InsertBlock' feature visibility is removed from PB development and documentation.
This feature is no longer available in Powerbuilder.
Workaround Description
 Request that 'InsertBlock' feature visibility is removed from PB development and documentation.
This feature is no longer available in Powerbuilder.



CR:267438
CR Number:   267438
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
When in the control panel, international settings, the currency symbol is defined as a space, then
the datawindow hangs. A window with a datawindow on it never gets opened.

It fails on Windows98 and it is also reproducible on Windows95.
The problem is not reproducible on Windows NT4.0.



CR:267467
CR Number:   267467
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Apr 2005 EOL'd version. Not to be Fixed.
Description
Not able to pass an Array argument to an Oracle System Procedure.



CR:267472
CR Number:   267472
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Sep 2003 Not a Bug
Description
When connected to ms sql7 and you select a table
that has a column name over 30 characters, when you try to make the table updateable
in the dw painter, the following error will appear:

Column is not in table



CR:267516
CR Number:   267516
Product Name:   PB Enterprise
Product Component:   DW ActiveX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
When a child window reference is made in a PowerBuilder ActiveX, it causes the open event to refire and all previous information is lost.



CR:267522
CR Number:   267522
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Aug 2003 Presently Not Targeted For Any Future Release Of This Product
Description
Enhancement for PowerBuilder 9.0:



In later versions of PB 7.0 and the GA release of PB 8.0, PSRs are saved in an OLE Storage format. PowerBuilder used to store the PSR in a "PowerBuilder Format", however this was changed to a more "vanilla OLE" approach to improve performance. The java DataWindow in PowerJ cannot read PSRs stored in OLE format. PowerJ development has stated that supporting the new OLE Storage format would not be possibility due to cross-platform issues and other complexities involving access to the OLE source. PowerBuilder 9.0 should include an option to either save a PSR with the "OLE Storage Format" or the "PowerBuilder Format". This would ensure compatibility between the two products.



CR:267641
CR Number:   267641
Product Name:   PB Enterprise
Product Component:   Workspace and Targets
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Apr 2005 Fixed
Description
PB 8.0 crashes when opening a Target with a long library list



CR:267656
CR Number:   267656
Product Name:   PB Enterprise
Product Component:   P-Code Exe Creation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Dec 2001 Not a Bug
Description
GPF and Out of Memory errors when generating p-code executable in PB 7.0.3

This is not a bug. There was a corrupt object inside pbl. When this object was fixed, then EXE generation could be done successfully.
Workaround Description
 N/A



CR:267668
CR Number:   267668
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 20 May 2003 Fixed
Description
Setting a filter on a datawindow between the calls for setredraw(FALSE) and setredraw(TRUE) generates a GPF in PB 8.0.



Workaround:

Either comment out BOTH setredraw functions, or post them.



CR:267846
CR Number:   267846
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Feb 2004 Fixed
Description
*** UPDATE 02/2004

This problem no longer appaers in PB 8.0.4 and 9.0.1



==========================================



When using a dw that has no columns and doing a dot notation (object.data) to share with another datawindow or datastore a gpf occurs. This did not happen in PB 6, 7.x



=========

Workaround:

Initialize the datawindow/datastore that is supposed to be shared with insertrow(1).
Workaround Description
 Initialize the datawindow/datastore that is supposed to be shared with insertrow(1).



CR:267878
CR Number:   267878
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
When the TabOrder of a DW is changed in the ItemChanged event when Column A changes, you cannot tab to Column B immediately. It will tab through with the previous tab order but the second time through the new tab order will be in effect.





--------------------------------------华丽的分割线-------------------------------------------------------------------------

Sybase SQL Anywhere数据库恢复工具ReadASADB:

之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具: ReadASADB。
此工具支持ASA v5.0, v6.0, v7.0, v8.0, v9.0, v10.0, v11.0, v12.0, v16.0, v17.0等版本。
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具。
恢复Sybase SQL Anywhere的工具在国内处于领先水平。

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,16.x,17.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使用介绍

Sybase SQL Anywhere数据库恢复工具ReadASADB适用场景

各种误操作:

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

Sybase SQL Anywhere数据库恢复工具ReadASADB的应用场景:

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
7、*** ERROR *** Assertion failed: 201417 (7.0.4.3541) Invalid count or free space offset detected on a table page
8、Internal database error *** ERROR *** Assertion failed: 201425 (8.0.3.5594) Invalid count or free space offset detected on a free list page -- transaction rolled back.
9、Internal database error *** ERROR *** Assertion failed: 100702 (8.0.1.2600) Unable to modify indexes for a row referenced in rollback log -- transaction rolled back


-------------------------------------------------------------------------------------------

Sybase ASE数据库恢复工具READSYBDEVICE:

一个不依赖数据库管理系统、直接从Sybase数据库设备文件上提取数据的业内领先的恢复工具!
能够从损坏的Sybase ASE设备文件(.dat)上提取数据的非常规恢复工具。

Sybase ASE数据库恢复工具READSYBDEVICE的主要功能:

  1. 被勒索病毒加密数据文件及备份文件情况下的恢复;
  2. 系统崩溃只剩下数据文件的情况下的恢复,甚至数据库文件不存在而只有损坏的备份文件情况下的恢复;
  3. 因断电、硬盘坏道等造成数据库文件损坏情况下的恢复;
  4. delete数据恢复、误update数据恢复、误删除表(drop)恢复、误truncate表恢复 等;
  5. 各种Sybase内部系统表损坏、索引错误的修复;
  6. master数据库损坏而无法正常运行情况下的恢复;
  7. Sybase数据库被标记为可疑,不可用等情况的恢复;
  8. Sybase数据库中数据文件内部出现坏块情况下的恢复;
  9. Sybase数据库无数据文件但有日志文件的情况下的恢复;
  10. Sybase数据库只有数据文件无任何日志文件的情况下的恢复;
  11. Sybase数据文件被误删除情况下的碎片提取恢复;
  12. 磁盘阵列上的Sybase数据库被误格式化情况下的数据库恢复;
  13. 数据库sysobjects等系统表损坏无法正常应用情况下的恢复;
  14. Sybase数据库还原数据库出现失败情况下的恢复;
  15. Sybase数据库只剩下损坏的备份文件情况下的恢复。

Sybase ASE数据库恢复工具READSYBDEVICE支持的版本:

Sybase ASE 11.0.x,11.5.x,11.9.x,12.0.x,12.5.x,15.0.x,15.5.x,15.7.x,16.0.x


-------------------------------------------------------------------------------------------

SQL Server数据库恢复工具SQLRescue:

一个不依赖数据库管理系统、直接从SQL Server数据库文件上提取数据的业内领先的恢复工具!
能够从损坏的SQL Server数据库文件(.mdf)上提取数据的非常规恢复工具。

SQL Server数据库恢复工具SQLRescue的主要功能:

  1. 系统崩溃只剩下数据文件的情况下的恢复,即无日志文件或者日志文件损坏情况下的恢复;
  2. 断电导致数据库文件损坏情况下的恢复;
  3. 硬盘坏道造成数据库损坏情况下的恢复;
  4. 数据文件内部存在坏页情况下的恢复;
  5. 企业管理器误删除数据表记录,管理软件误删除数据表记录的恢复;
  6. 并闩锁错误、格式化、误删除后导致软件不能使用的情况;
  7. 无法读取并闩锁页sysindexes失败情况下的修复;
  8. 数据文件被误删除情况下的碎片提取恢复;
  9. 系统表损坏、索引错误、误删除数据库表、删除记录的数据找回;
  10. master数据库损坏而无法正常运行情况下的恢复;
  11. 数据文件无法附加情况下的数据恢复;
  12. 数据库被标记为可疑,质疑,不可用等情况的恢复;
  13. 数据库sysobjects等系统表损坏情况下的恢复;
  14. 数据被误(drop、delete、truncate)删除表数据的恢复,误update后的数据恢复等;
  15. 还原时报一致性错误,错误823等情况下的数据恢复,各种错误提示的数据库文件修复;
  16. 数据库被误格式化等情况下的数据库恢复;
  17. 日志收缩造成数据库损坏情况下的恢复;
  18. 仅剩损坏的备份文件情况下的恢复。

SQL Server数据库恢复工具SQLRescue技术特点:

只要SQL Server数据库的数据文件存在,我们就有办法帮您从数据文件中找回重要数据。
  1. 从数据文件中直接恢复数据
  2. 不能附加时直接恢复数据并生成新的数据库
  3. 系统表损坏的数据库修复
  4. 快速修复SQL 823错误、连接中断错误

SQL Server数据库恢复工具SQLRescue支持的版本:

Microsoft SQL Server 7.0, 2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017,2019。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------