提供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:222790
CR Number:   222790
Product Name:   PB Enterprise
Product Component:   System Runtime Functions
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.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 problem is with RowsMove method (DataWindow, datastore, dwc);

Memory is allocated and never released during a batch process which utilises this method.
Could not see a problem with the RowsCopy method because when isolated, the memory is allocated and deallocated in a consistent manner. Whereas with the RowsCopy method, memory is incrementally allocated and never released. For example in a batch process, this will mean the computer will eventually run "out of memory" if the method is used.
Workaround Description
 The memory is freed if datastore is destroyed and then recreated.



CR:222837
CR Number:   222837
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0 Beta 3 16 Oct 2000 Fixed
Description
There should be a note on crosstabs in the doc when values are blank. A crosstab by it's very definition can have most grids return nothing (null).

Since the output shows some numbers and some (maybe most) nulls, it could be confusing.
Most users want either a number shown or zero for a null (no records).
The default crosstab behavior is to have "blank" for no "val" return from the crosstab query.

(take the simple crosstab from imtutor.pbl and you'll see the blank areas - emp_count_by_salary_and_dept - it's a salary crosstab that shows that many ranges of salaries have no employees at that range)

The easiest way to put a zero in these null fields is to add a FORMAT to the "val" field.
- Click on the Val field. Look at it's properties.
- Pull the format tab forward in the property sheet
- Change [General] to something like ###0;###0;0;0

<positive>;<negative>;<zero>;<null>


is the format of the FORMAT expression. Since we tell it to represent nulls as "0" (the 4th expression), it fills in the nulls (blanks) with zeros.



CR:222838
CR Number:   222838
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 9026 06 Feb 2001 Fixed
Description
6.5EBF/7.0.2 8046 C3 Regression. Grid lines in Grid DW paint problems (disappear, missing) after insertrow().

What you see is the RIGHTMOST vertical grid line describing the outer boundary of the grid datawindow disappears and reappears at different times while scrolling with holding the thumb. As soon as the insertrow() is invoked, you can see the grid line disappear in the visible screen. Internal grid lines between the columns also are gone. The printout seems fine in 6.5 EBF and 7.0.2 C3 even when the screen display is bad so this is a display problem only.

(6.5.1 and 7.0.2 8003-8045 worked fine)

Workaround: Setredraw(true) doesn't seem to work. Filter() works but won't work in all cases depending on program logic flow.

A better workaround is:
dw_1.object.datawindow.print.preview='no'

Place this after the insertrow(n) statement. It does the job and doesn't influence the display (it's not in print preview anyway if you're doing inserts).



CR:222840
CR Number:   222840
Product Name:   PB Enterprise
Product Component:   Workspace and Targets
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Sep 2000 Fixed
Description
Library filter fails after copying an object to a new pbl



CR:222859
CR Number:   222859
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Apr 2001 Fixed
Description
Select statements that contain computed columns without aliases may cause select errors with Oracle 8
Workaround Description
 Use aliases in select statements to substitute for computed columns.



CR:222869
CR Number:   222869
Product Name:   PB Enterprise
Product Component:   Workspace and Targets
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Sep 2000 Fixed
Description
PB8 Beta1: WorkSpace unusable after deleting a datawindow.



CR:222870
CR Number:   222870
Product Name:   PB Enterprise
Product Component:   Workspace and Targets
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Sep 2000 Fixed
Description
PB8 Beta1: You can edit objects during a Full or Incremental Rebuild, causing crashes



CR:222889
CR Number:   222889
Product Name:   PB Enterprise
Product Component:   DW Expression
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0 Beta 4 5017 06 Jul 2004 Fixed
Description
If you modify the expression of Columns, Rows or Values while creating a crosstab DW, PowerBuilder will give you an application error.

This is only a problem if more than one table is involved. The expression generated by PowerBuilder is invalid, after you correct the expression and try to create the DW, PowerBuilder will give you an application error.
Workaround Description
 Customer actually wanted to change the "Values" expression from sum to count. This is ignored in PowerBuilder 6.x. Workaround - is to change the values while in design mode, rather than from the wizard.



CR:222891
CR Number:   222891
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)
15 Aug 2000 Not reproducible with latest version of the product available as of Resolution Date
Description
PowerBuilder 7.0. If you create a SQL select datawindow and complete the wizard, under the Window menu item, you'll see item 1 is disabled and empty and item 2 is (untitled) correct.

There should not be an empty item 1. Works fine in 7.0.2 8046 C3.



CR:222892
CR Number:   222892
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Oct 2000 Fixed
Description
The BorderStyle StyleBox! (Box) does not work for groupboxes on windows in the painter or at runtime. It does work on datawindows in both the painter and runtime (where supported).
(hasn't worked back to 5.0.04)



CR:222922
CR Number:   222922
Product Name:   PB Enterprise
Product Component:   UO Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Oct 2000 Duplicate
Description
There is about a 30k to 50k process memory leak in the window or user object painter ever time you open an object or save. The PB70.exe process memory increases by that much.



CR:222940
CR Number:   222940
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
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 10035 11 Jan 2001 Fixed
Description
Ole Automation fails. PB can't access functions and properties.
Accessing properties and functions of the OLE Automation server for GeoPres2.MapController fails

code in VB works fine
Private mc As New GeoPres2.MapController
Private Sub Form_Load()
Set mc.Map = Map1
mc.ShowMap mc.MapGroup.DefaultMap, Nothing, Nothing
End Sub



CR:222945
CR Number:   222945
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 10049 12 Mar 2001 Fixed
Description
Scrolling a dw with large number of rows is not as smooth as it was in PB 6.
The behavior seen is :
- clicking on the thumb-button, or dragging the thumb-button, in a regular display,

sometimes causes it to jump up from under the mouse
- large blank areas appearing when dragging slowly back-and-forth across PrintPreview page

breaks



CR:222946
CR Number:   222946
Product Name:   PB Enterprise
Product Component:   DW Graph
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.1 1231 01 Nov 2000 Fixed
Description
REGRESSION: 6.5.1 Graphs with ranges that include negative numbers.



CR:222951
CR Number:   222951
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2000 Not a Bug
Description
GetItemDecimal is adding some precision value at the end.
The value being returned into a decimal variable using GetIemDecimal is showing the value to be as 229.1700000000000256 instead of 229.1700000000000000, that is why when you do a setitem the value being inserted is the the same. If you run the app in debugger it shows the wrong value in ldc_temp which is a decimal variable and if you put it into a dw column using Setitem or just display it in a SLE the value is wrong.

workaround is to use variable datatype decimal{4} instead of decimal for info for GetItemDecimal
Workaround Description
 use decimal{4} as a variable for the getitemdecimal and it will return the correct value for the sum when you do the setitem in dw_2



CR:222956
CR Number:   222956
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0 Beta 3 08 Jan 2001 Fixed
Description
According to the online help there should be a menu item Design-Migrate in the library painter but is not present.
The only way I know how to migrate older version pbls is by creating a Target based on a Existing Application. I think it is a documentation error or a feature that has not been implemented yet.



CR:222961
CR Number:   222961
Product Name:   PB Enterprise
Product Component:   Library Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Nov 2011 Fixed
Description
When in the library painter and you want to add a pbl

to your existing target, the browse button on the "set library search path"

is not easy to find or see.



CR:222993
CR Number:   222993
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.1 1231 18 Dec 2000 Fixed
Description
6.5.1 620 Regression. Editmask regression using percent symbol (##0%) in window and datawindow editmask. Using this with a numeric or Decimal(2 or 4) column, you type in a whole number like 5 or 23 and get a large number when you tab off. What should be stored in the buffer is .05 or .23. (See CR150201 for how it's supposed to work).

Related problem in 6.5 EBF/7.0 5031/6012 - Typing "23" shows 2%3. You should never be able to type past the percent sign.

Works OK in 5.0.04, 6.5 444, build 1253 and 7.0.2 8003, 8046 C3.



CR:222999
CR Number:   222999
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
3024 25 Jan 2001 Fixed
Description
Short Desc:
If the original password for JAGADMIN is changed from blank, pb proxy object does not like it. You get a Corba exception error on deploying the the object.
Error: EAServer repository not available. EAServer Host = localhost, Port Number = 9000, Logon ID = jagadmin. EAServer error code: SystemException: CORBA::NO_PERMISSION, exception code: 23
Generation Errors:
Deployment Error Accessing Host 'localhost' At Port 9000 EAServer error code: SystemException: CORBA::NO_PERMISSION, exception code: 23

Workaround : After creating the project object , open the properties dialog within the project painter and re-type the password. Build the project and this time it will be successfull.
Workaround Description
 Workaround : After creating the project object , open the properties dialog within the project painter and re-type the password. Build the project and this time it will be successfull.



CR:223009
CR Number:   223009
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 10035 25 Feb 2004 Fixed
Description
If a system error or GPF occurs in a PowerBuilder component deployed to Jaguar, the database updates done up to the point of the error are not rolled back. Jaguar thinks that the component call succeeded because it receives no SetAbort().
Workaround Description
 None



CR:223030
CR Number:   223030
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.1 1231 31 Oct 2002 Fixed
Description
6.5.1/7.0 Regression. Rowscopy() causes 'out of memory' before the system pagefile is exhausted when copying large blocks of rows.



CR:223031
CR Number:   223031
Product Name:   PB Enterprise
Product Component:   Installation
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Feb 2001 Fixed
Description
PB 8.0 Beta1- install on NT 4.0 ignores file locale chosen by user



CR:223084
CR Number:   223084
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Sep 2000 Fixed
Description
In the script painter, copying a function using Control-A and then cutting the text out using Control-C/Control-X and switching to an event script causes function deletion/GPF in PBVM70.DLL. The function script doesn't show any compilation errors.

There are 2 side effects that can be seen.
1. If you SelectAll/Cut and save the function, the function is deleted.
2. If you SelectAll/Cut and switch to the event tab and select an event of_exporttostring(), you'll get a GPF in PBVM70.DLL and it appears it dies trying to delete the function you came from when switching to the event tab..



CR:223093
CR Number:   223093
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Nov 2000 Third Party Problem
Description
When connecting to Microsoft SQL Server 7.0 with the native driver (PBMSS), if the "Client for Microsoft Networks" is NOT installed on the Win95/Win98 machine, you will not be able to connect. You will get one of the following errors. "SQL Server does not exist" OR "SQLServer request resulted in bad return code or status but no error message was returned"

If you connect to SQL Server 6.5, everything works fine. ODBC will work fine without the network client installed.

Resolution: Third Party Problem (Microsoft)
Refer to the following Microsoft article which specifically mentions PB and includes a workaround:
PRB: Legacy DB-Library Application May Fail to Connect After You Install SQL Server Client Tools
http://support.microsoft.com/support/kb/articles/Q254/3/41.ASP
NOTE: The information from this Microsoft article is intentionally not being copied and pasted here just in case MS makes any changes to it. Please use the URL above to see the actual article.



CR:223094
CR Number:   223094
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Mar 2004 Not a Bug
13 Mar 2001 Not a Bug
Description
Calling a stored procedure with parameters fails using Oracle with ODBC driver pbodb70.dll from PowerBuilder 7.02



RESOLUTION: Not a bug but a syntax error in testcase. Executing Oracle stored procedures are different from executing ASE stored procedures. Refer to PB HELP / Declare Procedure/ORACLE Declare and Execute.
Workaround Description
 Use pbodb70.dll prior to 7.02 build



CR:223096
CR Number:   223096
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2000 Not a Bug
Description
HL 9/6/2000
OS : Windows NT
PB Version and Build : PB 6.5 Build 1216, PB 8.0 build 1313 ,Different behavior in PB 7.0.2 build 8046

Customer sample shows where he is sharing a datastore with datawindow and then retrieving, when he resets datawindow, rowfocuschanged does not get fired.

Question was asked of development to determine the correct behavior and it is as follows and is now consistent in all current builds of PB 6.5.1( build 1219),
PB 7.0.2 ( build 9023) and PB 8.0 beta (build 1313)

Per Development - This is not a bug and is this is the expected behavior.

Click normal retrieve of DW - Rowfocuschanged fires and the current row is 1
Click Reset CB - RowFocuschanged fires and the current row is 0
Click Sharedata and then retrieve CB - Rowfocuschanged fires and the current row is 1
Click Reset CB - RowFocuschanged does not fire

Explanation for this behavior is that when DataWindows are shared, ALL activity is routed through the Primary, Parent DW. For example if you do an
insert row on a shared DW, we take the message and reroute it to the parent for actual processing, when it is processed, we will then synchronize
ALL the shared children to the state of the parent.

When a dw_x.reset is done and dw_x has some shared DW children, sharing is turned off so we can cleanly release dw_x's storage.
When the reset is complete for dw_x, sharing is reinstated for all the shared DW children. The effect is the same as if sharing is not turned off, the
parent DW and all the shared children turn up empty.

The reason you do not see a RowFocusChanged when you reset when the share is in effect is because you are sharing a DataStore to the DW
and (momentarily) the DW is not shared during the reset.



CR:223098
CR Number:   223098
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 9026 15 Nov 2000 Fixed
Description
GPF when using RetrieveAsNeeded, RetrieveRow event, and Async=1. Problem w/ several drivers.
Verified fixed in 7.0.3 build 10003



CR:223125
CR Number:   223125
Product Name:   PB Enterprise
Product Component:   Printing
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 10032 25 Feb 2004 EOL'd version. Not to be Fixed.
Description
For composite report with few horizontal page (e.g 5 vertical pg. & each vertical pg. with 10 horizontal pg.), the print out report will be blank after EACH 3th horizontal page.
Workaround Description
 Nil



CR:223138
CR Number:   223138
Product Name:   PB Enterprise
Product Component:   Environment Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Sep 2000 Fixed
Description
System treeview does not refresh with F5 or View/Refresh.



CR:223149
CR Number:   223149
Product Name:   PB Enterprise
Product Component:   Help
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Aug 2000 Duplicate
Description
PB8 Beta1: Out of date links in on-line help.



CR:223151
CR Number:   223151
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Solaris 2.6
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 Fixed
Description
A pb component calls a java component. The java component
creates a datastore and does a setfullstate. The setfullstate says it succeeded
but the rowcount returns 0.

Works ok on nt using jaguar 3.5 (build 35042) and pb 7.0.2 (build 8046).

The srv.log shows the following:
/export/home/duquette/jaguar35/bin/jagsrv: fatal: relocation error:
file /export/home/duquette/jaguar35/jdk/jdk1.1.8/lib/sparc/native_threads/libawt.so:
symbol NameAndTypeToHash: referenced symbol not found (libawt.so)

Aug 18 13:23:35 2000: DWObject Error: load: invalid number of columns: got 50331647 instead of 2



CR:223178
CR Number:   223178
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Mar 2004 EOL'd version. Not to be Fixed.
Description
The datawindow validation messagebox is not tied to the parent window (sheet) on which the datawindow resides.
This causes an infinite loop when you use the default error message (and default messagebox to display it) and you code an Accepttext() in an event posted from the losefocus event of the datawindow control. (as documented).

You can see the behavior clearly by watching the taskbar in Wintel systems. The validation messagebox should not appear on the taskbar - it should be tied to the parent sheet.

Workaround: Use a response window instead of the system messagebox in the ItemError event.
- Make sure the response window Open() call specifies a parent window.
- Return 1 in the ItemError to suppress the system messagebox.

// Simple case - datawindow on a window
Open(w_resp, parent)
Return 1



CR:223179
CR Number:   223179
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
The problem is with PB native connection using 'Open Client' v11.1.1, v12.x Adaptive Server Enterprise database v12.



When the checkbox "Prompt for database information" option is selected on "Connection" tab. In Powerbuilder 7.x, the result is a gpf when attempting to connect to db.
Workaround Description
 PB DB Profile functionality (checkbox) is not so important because Open client login window will display for default connections.



CR:223180
CR Number:   223180
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Sep 2000 Fixed
Description
Follow-on to CR214754. It is possible to get duplicate entries in the MRU (Most Recently Used) list of objects - File/Recent Objects list. In the general case, CR214754 addressed this problem with applications but it's a more wide-spread problem where the entire string is case-sensitive for objects.

If a user picks a library from the Select Application [Browse...] dialog, you will always get the drive letter case (upper) and path F:\CRs\cr200000\test.pbl; pasted EXACTLY as it shows in Explorer. If the user TYPES IN the library list (or part of the library list) such as f:\crs\cr200000\test.pbl, the same object will show up TWICE on the recent objects list (you must exit PB, etc first)..



CR:223194
CR Number:   223194
Product Name:   PB Enterprise
Product Component:   Printing
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
The problem is with PB (at runtime) sending a print to an EPSON Stylus Scan 2500 (Multi-Function Product)
This is a 'Combination' product that integrates Printing, Copying, Faxing*, document e-Mail*, and Scanning in to one simple-to-use device...

The dwcontrol.print function does not print the contents of a DataWindow control or DataStore as a print job. The return value for this function is +1 (successful). However, the print job:
-does not print preview(option set ON the actual printer properties)
-does not appear in the printer queue
-does not display any errors

However a possible workaround is to use the PrintDataWindow() function to send data to the printer (though this method is normally used for printing multiple datawindows to send as one print job rather than printing 1 dw).



CR:223196
CR Number:   223196
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 10030 31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
PowerBuilder activates a invisible custom control on window loading which is not the case in VB, this

causes appearance of a white box at the corner of the desktop.



CR:223200
CR Number:   223200
Product Name:   PB Enterprise
Product Component:   Project Wizards
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Sep 2000 Fixed
Description
Desc : PB8Beta 1 : Default EXE name created using the wizard and not the wizard is different
If the application object name is different than the pbl name and if you create a project object using the Application wizard then the exe name will default to the pbl name.exe, whereas if you use just the Application icon in the Project folder and create the exe and click on the browse button then the exe name will default to the app_object.exe. This is the same in pb 7 as well. This inconsistency should not exist, both the exe names should either depend on the app object or on the pbl name.



CR:223226
CR Number:   223226
Product Name:   PB Enterprise
Product Component:   DPB
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 10043 25 Feb 2004 Fixed
Description
Observed a memory leak of between 4K - 26K in the PB 7.02 Server application when connecting and disconnecting a PB client application. The amount of memory lost was about 360K after 20 successive connect and disconnect by the same Client.
Workaround Description
 None available



CR:223231
CR Number:   223231
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)
15 Jun 2004 EOL'd version. Not to be Fixed.
Description
Enhancement. No ability to force case on DDDW (dropdowndatawindow) edit style with "Allow Editing" OFF. It's set to ANY by default and the field is not editable when "Allow Editing" is unchecked.. The current behavior is to allow the choice of the CASE of the text field only when "Allow Editing" is ON.

The DDLB, a similar edit style allows case selection even if the field is read only (Allow Editing OFF)



CR:223232
CR Number:   223232
Product Name:   PB Enterprise
Product Component:   Printing
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Sep 2000 Not a Bug
Description
7.0 Regression. Select File/Print to print the script from a global function in the development environment sends nothing to the printer.



CR:223234
CR Number:   223234
Product Name:   PB Enterprise
Product Component:   DW Display
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
PowerBuilder 6, 6.5 only problem with Date editmask MM/DD/YYYY and Null values

When you click on a column with this editmask and format value null,
the displayed value changes from 'null' to' 00/00/0000'.
However when you click on the same column in a different row the displayed value
stays '00/00/0000' and does not revert back to 'null' as it should.
The problem does not occur when tabbing to a different column.

Workaround: post an event in the rowchanging event and then set the
focus to a different column and back in the posted event.



CR:223236
CR Number:   223236
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Sep 2000 Fixed
Description
7.0 Regression. 'Search Selection Only' in conjunction with "Replace All" in Edit/Replace dialog in the script painter doesn't work correctly. Instead of replacing the From (Replace:) with the To (With:) for all occurances in the selected text, it deletes the entire selected text and replaces it with the string in the "With:" edit field.



CR:223241
CR Number:   223241
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Oct 2001 Duplicate
Description
Modifying Word documents via ole automation decrease memory until Word had no memory left. Word aborts with the message: "Out of memory ".
This happens if modifying around 500 documents.
Workaround is to split it in 2x250 and reconnect to the word ole server again to avoid that word is running into the low memory problem.
Workaround Description
 split the automation in several smal parts and reconnect to the Word ole automation. That avoids that word is running into low memory problem.



CR:223244
CR Number:   223244
Product Name:   PB Enterprise
Product Component:   UO Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Sep 2000 Fixed
Description
7.0 Regression. UO function with 2500 character prototype causes GPF in PBUDO70.DLL/MSVCRT.DLL in painter..



CR:223247
CR Number:   223247
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Sep 2000 Fixed
Description
PB8.0 Beta1:
Color palette in Window and DW painter. Tooltips are behind palette. And you only really see the ones furtherst to the right, ie the color purple in first row, last box.



CR:223251
CR Number:   223251
Product Name:   PB Enterprise
Product Component:   SQL Painter
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
SQL Painter. When you join a table to itself (select it twice) and in the WHERE tab of the SQL Painter, right mouse and pick "value.." menu pick, you will receive various errors depending on what database you're connected to. It seems to be using the correlation name (alias) and not the real name to query the table. For instance, if you join the employee table to itself, you'll see employee_a, employee_b in the SQL painter. The 'Value..." menu pick on the right mouse seems to be using the alias "employee_a" instead of the real name "employee" to query the table for values.

Typical errors you get:
SQL Anywhere - S1002 [Sybase][ODBC Driver][Adaptive Server Anywhere]Table or view not found: table 'department_a' not found
Sybase SQL Server - Select Error: dialog that is empty.
Oracle (native) - Select Error: ORA-00942 Table or view does not exist.
Informix - SQL error -206: The specified table (department_a) is not in the database. ISAM error -111 error, no record found
MS SQL Server - Select Error: invalid object name "department_a"



CR:223264
CR Number:   223264
Product Name:   PB Enterprise
Product Component:   DB JDBC
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Nov 2000 Fixed
Description
Connecting to JDBC. If the SYSTEM CLASSPATH is greater than 512 characters and the user tries to connect with JDBC, you will get an error in PowerBuilder as if the "Classes.zip" path was missing off your CLASSPATH environment variable.


Java Exception: Unable to find java PbjdbcSession class. Check CLASSPATH.



CR:223266
CR Number:   223266
Product Name:   PB Enterprise
Product Component:   Library Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Oct 2000 Not reproducible with latest version of the product available as of Resolution Date
Description
Customer has a pbl with approximately 950 datawindows in it. In PB 6.5.1, all versions tested, it takes approximately 6 seconds to open in the Library Painter. In PB 7.0.2 C3 build 8046 it takes over 20 seconds to open in the library painter. Customer understands that there are additional views in PB 7 but thinks this is a bug/regression to have increased the open time in the library painter by a factor of 3. Is this increase expected with the new PB 7 view technology? Can the open time be decreased?



CR:223301
CR Number:   223301
Product Name:   PB Enterprise
Product Component:   Installation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2000 Not a Bug
Description
JDBC Database Connect (JDS,JDM) gives "Java Exception: Unable to find java PbjdbcSession class Check CLASSPATH"

If you're using JDK 122 on your CLASSPATH, JDK122 doesn't have the javai.dll in it and that is what we use for the JDS driver.

Workaround: Switch CLASSPATH to use JDK117 or JDK118.



CR:223302
CR Number:   223302
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Mar 2004 EOL'd version. Not to be Fixed.
Description
Response window opened in ItemError event of datawindow does not prevent execution of script after the response window Open(). It should suspend script execution in the itemerror event until AFTER the user closes the response window. This works OK (somewhat) with the system messagebox.

The response window works correctly in the clicked event, for example - not allowing any script execution after the Open() until the user closes the response window.

This has been the behavior back through 5.0.04.



CR:223305
CR Number:   223305
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 Fixed
Description
When connecting using ODBC within an MTS environment, you may experience an invalid handle error on a call to ODBC API function SQLDriverConnect(). The handle passed is valid, indicating a problem on the ODBC side.
Workaround Description
 None



CR:223313
CR Number:   223313
Product Name:   PB Enterprise
Product Component:   Debugger
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Nov 2000 Fixed
Description
If you set breakpoints in an object and then open the debugger without closing the object script, clearing all of the breakpoints apparently clears them in the object script, but they return if you open a different script and then go back to the script that had the breakpoints. Also after clearing the breakpoints in the debugger, the 'add breakpoint' option is disabled in the object:
Workaround Description
 CLose object painters before using debugger.



CR:223315
CR Number:   223315
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 26 Sep 2000 Fixed
Description
7.0.2C3 Regression. Script painter crashes switch between event/functions and saving script in-between.

Edit a script (but don't save)
Switch to functions or declare (tear off tab) without doing anything.
Switch back to script you were editing and save script.
Switch to (functions) using the script pane dropdown list which contains (Functions),(Declares), etc
GPF in PBVM70.DLL



CR:223316
CR Number:   223316
Product Name:   PB Enterprise
Product Component:   DW Display
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 problem is with PB DW function SetDataStyle(). If the graph object layer is set to "Background" - problems with scrolling, paint and colour switching for the column data display.
On a tabular dw which has a graph object, calling this function will make tabular columns appear blank.
Click on the column lname, some data displays.
Click in a blank column, some more data displays.
Click and drag the dw vscrollbar, data is displayed when "dragged". However when the scrollbar is released, the columns display blank till one or more column items receive focus.
Workaround Description
 Set the graph object, Position TAB, layer properties to "Foreground". Note that if you have multiple graph objects
on the datawindow, these need to also be set otherwise the erroneous behaviour will occur.



CR:223317
CR Number:   223317
Product Name:   PB Enterprise
Product Component:   Install
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2000 Not a Bug
Description
When installing pb (from internal location - iad_drops), the
following error appears during the install:

Install crashes
Copying Powersite client program files
75%
ComponentMoveData Error Information
Setup encountered the following error:
MediaName: data
Component Client Install (Powersite)\Program Files
File Group DLLs (ps)
File:
Error Number: -145



CR:223319
CR Number:   223319
Product Name:   PB Enterprise
Product Component:   Installation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Sep 2000 Fixed
Description
After installing pb 8.0 (from internal location), two keyhh.exe
files are installed on the machine in:

c:\winnt keyHH.exe 7/17/00
c:\winnt\system32 KeyHH.exe 1/6/99



CR:223321
CR Number:   223321
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Sep 2000 Not a Bug
Description
It's too easy override a SYSTEM FUNCTION and create an object level function (user object, menu object or window object) that has the SAME NAME as a SYSTEM function using the function tear off tabs in the script painter.

We should issue a warning (Example ClassName()):
You are overriding a PowerBuilder SYSTEM FUNCTION "Classname()" . If you choose to continue, the object level function you're creating will run instead of the SYSTEM FUNCTION and you will not be able to execute the system level function. Do you want to continue? <YES><NO><Cancel>



CR:223323
CR Number:   223323
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Nov 2000 Fixed
Description
(i)There are documentation errors in the PB 7.x help file and manual. The correct number of arguments required for function GetItemStatus is 3.
(ii)Note that the Java example code {specified after the PB code} also requires the SAME modification to call the function AND the java storage variable remains as status(datatype short);
Workaround Description
 Ignore the examples till they are remedied. Rely on the function syntax description of
DWItemStatus dwcontrol.GetItemStatus ( long row, integer column, DWBuffer dwbuffer ).



CR:223334
CR Number:   223334
Product Name:   PB Enterprise
Product Component:   Library Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Sep 2000 Not a Bug
Description
Build time has increased by more than 40% after migrating an application from PB 5 to 7
Full rebuild of the pfc app :
PB 5.04.76 - 11 min
PB 6.5.1219 migrated from pb 5.04 - 13 min
PB 7.02.8046 migrated from pb 5.04 - 17 min
PB 7.02.8046 migrated from pb 6.5.1219 - 17 min.

As per Development this is not a bug :
"The reason there is an increase in time for a full rebuild to complete is a result of many changes that were put in over a 3 to 4 year period. Features have been added to increase functionality, along with fixes to reach the goal of accuracy which all combine to make PB a more robust tool. The cost of this unfortunately is that things will take longer.

You will notice the performance increase between 5 and 6 was not far from the increase between 6 and 7. The total increase from 5 to 7 does appear to be large, however, it has been done over time. Hence this is not considered to be a bug and does not cause a Full Rebuild or something else to fail in PB."



CR:223341
CR Number:   223341
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
Using OLE to spellcheck text in Excel is limited in Office2000



CR:223383
CR Number:   223383
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
custom HTML DW based on a stored procedure in a ASE Server. retrieveex() gets a -1 in 20%. 80% of the retrieves are ok. This happens if using a connection cash in the connection string of the settrans() function.

Workaround:
Using a odbc connection to the ASE Server.
Example:
jagObject.settrans("ODBC", "ConnectString='DSN=ASEODBC;UID=sa;PWD='", "", "", "", "", "");
Workaround Description
 use a direct ODBC connection to the ASE instead of a connection cash.



CR:223386
CR Number:   223386
Product Name:   PB Enterprise
Product Component:   Install
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Sep 2000 Fixed
Description
Powersite client files get installed irrespective of your choice, it should get installed only when PB is chosen not when other components are chosen.



CR:223387
CR Number:   223387
Product Name:   PB Enterprise
Product Component:   Install
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Feb 2001 Fixed
Description
Eventhough the path to Powerdynamo directory exists in the autoexec.bat, the install program does not recognize it.



CR:223388
CR Number:   223388
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2004 EOL'd version. Not to be Fixed.
Description
This is a duplicate of CR 192831 which has been fixed in PB 8.0 but not in PB 7.0.2.
When there is a computed field on an External Datawindow it does not display when either previewed or run unless there are rows in that are rows in the datawindow.

Workarounds include doing a dw_1.insertrow(0) in the open script to insert a row into the datawindow or saving the datawindow with a dummy row.



CR:223401
CR Number:   223401
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Mar 2001 Not a Bug
Description
The Word OLEControl Activate Inplace! behavior is causing failures based on context. Seems to be working when script on different CB's but not when on same button.

Update from Development: Not a bug. This turned out to be user scripting errors when using OLE functionality.



CR:223428
CR Number:   223428
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement request:
The Datawindow in PowerBuilder/PowerJ should be possible to handle a return code from a stored procedure, direct. An easy way to have access to the return code of a SP.
Not the way over the dberror event from which you could pick up the return code.



CR:223429
CR Number:   223429
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 10009 18 Dec 2000 Fixed
Description
PB6.5 build 1195 and later Builds and 7.0.2 C3 8046 Regression. You only get white space displayed with a N-Up nested datawindow except for the last of the N-Ups.



CR:223471
CR Number:   223471
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ENHANCEMENT REQUEST
for CR# 210557 - Tag values are missing for columns when crosstab datawindows are switched to staticmode. Enhancement should enable to switch to static mode without running into the tag value problem.



CR:223486
CR Number:   223486
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.1 1244 29 Jan 2001 Fixed
Description
PB allowing to enter an invalid date in a date field, when using a date mask of yyyymmdd
When we have a editmask of type YYYYMMDD on a date field the month and date validations are not working appropriately.
When you have a year field like 2222 and date says 31 then pb allows user to enter 02 for month.



CR:223498
CR Number:   223498
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Memory Leak when opening and closing window instance
Workaround Description
 Associate an app icon with the application.



CR:223513
CR Number:   223513
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Feb 2001 Fixed
Description
EAServer supports proxy connections to database caches in two ways: 1) proxying to the Jaguar client id (e.g., Jagadmin) and 2) proxying to a database user id provided at runtime.
Method 1 is accomplished by EAServer solely through the inclusion of a props file entry. Method 2 requires that entry along with a coding change. Specifically, the JagCMGetConnection routine that is now used to get a cached connection needs to be changed to JagCMGetProxyConnection. The latter call also requires an input value of the userid to be proxied to, so a new DBParm (or some other device) would be required to feed that function call inside of the PB code.
The affected drivers here are ODB, JDB (and JDS/JDM, although since deprecated we could leave those out), and SYJ (SYC). Although Oracle caches are supported in EAServer, Oracle does not support the SET SESSION AUTHORIZATION statement that EAServer uses to implement the proxy connections; therefore; setting this up for ORacle connections would be a wasted effort UNLESS theres' some indication that support for that ANSI SQL statement will be included in an upcoming Oracle release.



CR:223517
CR Number:   223517
Product Name:   PB Enterprise
Product Component:   Migration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Nov 2000 Not a Bug
Description
When creating a new target one of the wizards is to migrate an "existing application". Once the application object is selected it should look into the old pb.ini file at this point to see if the application is listed there and if it does, automatically add the library search path.



CR:223544
CR Number:   223544
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 10003 21 Nov 2000 Fixed
Description
7.0 Regression. Oracle 8 ODBC drivers from Oracle (8.0.5), Intersolv (3.11) and Microsoft 2.573.3711 return the wrong SQLCODE on INSERT into a table with a duplicate primary key. They return 100 when the SQLCODE should be -1. The ODBC driver from SQL Anywhere 6.0 works fine.



CR:223548
CR Number:   223548
Product Name:   PB Enterprise
Product Component:   Function Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 10030 14 Nov 2000 Fixed
Description
In PB 7.0.2 if you repeatedly save your script when in the function painter eventually you will crash and all script will be lost. When the function is reopened all the script is lost.



CR:223554
CR Number:   223554
Product Name:   PB Enterprise
Product Component:   Install
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 May 2004 Fixed
Description
When doing a compact install of PB8, you get a list of components to be installed and that list includes the Informix driver, Oracle driver, MS SQLServer Driver, Direct Connect driver, and the JDBC driver, but it does not include the ODBC driver.

PBODB80.DLL is actually installed though, so it's not a big deal, but the list of drivers in the summary (Direct Connect? but not ODBC) doesn't seem logical for a COMPACT install.



CR:223555
CR Number:   223555
Product Name:   PB Enterprise
Product Component:   Install
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Feb 2001 Not a Bug
Description
One of the questions was whether the Web Target functionality should be a module that customers can select to install or not. If it were to be a module, I'd suggest that compact installs not include it...
The compact install as is seems to go quickly up until the 85% mark or so when a boatload of GIF and HTM files are installed under the WebTargets directory - pehaps that could be skinnied up even if we do not provide a way to bypass installation of the webtarget capability.



CR:223556
CR Number:   223556
Product Name:   PB Enterprise
Product Component:   Install
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Aug 2000 Not a Bug
Description
In general, we should not see the word Powersite in PB8 (except for the context of migrating old PowerSite 7 projects)..

suggest doing a global search in the Install scripts, etc. to see that we caught all these.



CR:223558
CR Number:   223558
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2000 Not a Bug
Description
Performance problem calling MS SQLServer stored procedures from PB.
Not a bug. The sp has DDL statements which in SQL Server are not transactional. An sp with DDL must be called with autocommit = true.



CR:223564
CR Number:   223564
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Aug 2000 Not a Bug
Description
The GetFolder function has a second argument indicating (by reference) the path of the selected directory... it's not clear from the doc, but you can set that BEFORE the call to have the dialog open the desired folder - can we make that more explicit
The examples actually shows doing just this! but is not mentioned in the doc.
What's missing is explicitly saying that you can set the value BEFORE the call so that the dialog will open to a specific folder.



CR:223568
CR Number:   223568
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Sep 2000 Presently Not Targeted For Any Future Release Of This Product
Description
If you have the Text File Editor opened when you close the workspace (or open a different one) the File Editor window is forced to close as well and asks if you want to save - why can't it remain open?



CR:223571
CR Number:   223571
Product Name:   PB Enterprise
Product Component:   Library Painter
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
If you look in the system tree under the list of functions, what you'd want to see in the method signature is the
fact that this exception is raised. I suspect they'll consider it an enhancement, but the browser/system tree is only 50% functional if that information is not there, after all it's just as important as the arguments and return value at this point.



CR:223574
CR Number:   223574
Product Name:   PB Enterprise
Product Component:   Workspace and Targets
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Sep 2000 Not a Bug
Description
PB8.0 Beta1:
Options under menu items Tools -> System Options -> Workspaces, the second checkbox option takes precendence over the first. It probably should be an either/or choice.

"Show start dialog at startup with no workspace" | If both are checked then
"Reopen Workspace on Startup" | this one is the one that is executed.



CR:223591
CR Number:   223591
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Insufficient priority to fix
Description
PB 8.0 Beta: Would like to be able to scroll through output DURING migration.



CR:223597
CR Number:   223597
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0 RC 5006 12 Mar 2001 Fixed
Description
PB8.0 Beta1: 2 problems with LibraryDirectoryEx function



CR:223632
CR Number:   223632
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)
09 Oct 2000 Fixed
Description
PB Version and Build: PB 7 -> 7.0.2.9010, PB 8.0 build 1290. OK in PB 6.5
DB/DLL: PBDWP70.DLL

Creating a column in an external dw which contains a blank space in the name will crash PB as soon as you click the finish button.
With 7.0.2 build 9010 - Gives error in pbdwp70.dll - Instruction @ 0x10847f96 referenced memory @ "0x00000000" - memory could not be read
In PB 6.5 and earlier an error message appeared and user was forced to change the name
Workaround Description
 Leave out the space in the column name (a space in the col name has never been allowed in PB)



CR:223640
CR Number:   223640
Product Name:   PB Enterprise
Product Component:   ORCA
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 May 2004 Fixed
Description
PB8 Beta1: PBORCA_LibraryEntryInformation returns too large an ObjectSize for project objects.



CR:223646
CR Number:   223646
Product Name:   PB Enterprise
Product Component:   DW Synchronization
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.1 1234 19 Jan 2001 Fixed
Description
PowerBuilder Crashes on the SetFullState( ) function for composite datawindows.



CR:223674
CR Number:   223674
Product Name:   PB Enterprise
Product Component:   DW Printing
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2004 EOL'd version. Not to be Fixed.
Description
A simple newspaper dw with two columns in a composite dw causes printing problems.
The first row of the second column is printed over the first row of the first column.
Printpreview looks fine but the printout is not ok.
No possible workaround available.



CR:223677
CR Number:   223677
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 10004 28 Mar 2001 Fixed
Description
Regression: Informix 7 DB Driver : Adding decimal values in an embedded SELECT returns rounded values when the hostvariable is a decimal.
Workaround Description
 1. Change host variable datatype to either real or Double
2. Use Datawindow object having the expression as a sql select statement and utilize this to get the desired result
into eg. datastore or datawindow
3. Use ODBC driver



CR:223698
CR Number:   223698
Product Name:   PB Enterprise
Product Component:   System Runtime Functions
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Oct 2001 Fixed
01 Oct 2001 Fixed
Description
PB8Beta1: Problem with implementation of LastPos () in PFC



CR:223701
CR Number:   223701
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0 Beta 2 29 Sep 2000 Fixed
Description
PB8 Beta 1:You can close a workspace even if there are errors in a script you are working on, the object
painter stays open, but the system tree shows the workspace closed



CR:223738
CR Number:   223738
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   3.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
The problem is in Powerdynamo where the Powerbuilder HTML DataWindow generator translates Powerbuilder system function RelativeDate() incorrectly.
Follow the steps in the CR repro tab -
In "Output of EuropeAssistance.html" window, search for javascript function description DW_RelativeDate.
Notice that in the FOR LOOP, the error is with the increment variable "i++".
This should be "month++".
Possible error message "waiting for an object" when trying to update date field.
Workaround Description
 In html script file, change increment i++ to month++ :
for (month=0; month< 12 && day >= DW_cumDayTable[aleap][month]; month++);



CR:223739
CR Number:   223739
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   3.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
The problem is in Powerdynamo where the Powerbuilder HTML DataWindow generator incorrectly references
a variable :-
var DW_dayTable = new Array(); {Note: uppercase "T"}
However this variable referenced later (one occurrence) in the code as DW_daytable {Note: lowercase "t"}

Possible error message "waiting for an object" when trying to update date field.
Workaround Description
 Change all the references from DW_daytable to DW_dayTable.



CR:223741
CR Number:   223741
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   3.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jun 2005 Presently Not Targeted For Any Future Release Of This Product
Description
The problem is in Powerdynamo where the Powerbuilder HTML DataWindow generator incorrectly references

a function :-

DW_dayOfYear() does exist in the script file.

However function day_of_year() does not exist and is referenced in DW_dayOfCentury() ;

The correct function call should be made to DW_dayOfYear() ;



Possible error message "waiting for an object" when trying to update date field.
Review Status
 13.06.2005

This CR was reviewed and closed as part of the PB10 CR Review process. It is "Not targeted for any future release".
Workaround Description
 Create a new function which maps to the correct function call (see CR desc section).



CR:223742
CR Number:   223742
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2004 EOL'd version. Not to be Fixed.
Description
If the sort order is set on any column and a row was deleted from the DataWindow control then is you scrolled to the last row, you will notice that the last row was blank. If you were to scroll back up from the last row, then you will notice that all objects have vanished, apart from column objects.



CR:223759
CR Number:   223759
Product Name:   PB Enterprise
Product Component:   Migration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jun 2005 Presently Not Targeted For Any Future Release Of This Product
Description
06/14/2005:

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



PB8 Beta1: Migration of large app from 6.5 to 8.0 completes successfully, but GPFs when run in development mode. 6.5 to 7 migration runs OK. 7.0 to 8.0 migrations fails in the same way.



CR:223806
CR Number:   223806
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
In a dw containing a left outer join and having subselect statements in the query, columns move (disappear from other bands) to the detail band when changing the sql in the sql painter. This happens while changing back to the design painter.
Workaround Description
 Two ways are possible:
1.Export the syntax and add columns in textmode and reimport.
2. Change the outer join to be a normal (equi) join and add columns to the select statment as wanted, then afterwards change the join back.



CR:223812
CR Number:   223812
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 9028 04 Jan 2001 Fixed
Description
7.0.02 regression: Validation rule executed for a numeric field without any Valid. rule



CR:223817
CR Number:   223817
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 9022 14 Sep 2000 Fixed
Description
PB 7.0.2.8046 C3 Regression. PB Crashes in PBVM70.DLL on selecting 'FUNCTION' item from the drop down list after a File/Save As.. to save a new object like a Window or custom VISUAL user object.



CR:223819
CR Number:   223819
Product Name:   PB Enterprise
Product Component:   Migration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Feb 2001 Fixed
Description
If you take the following dpb test case (cr223819.zip) and migrate it to PB 8.0,
it migrates without any errors.

From the PB 7.0 release notes, version 7.0 will be the final
release of Powerbiulder which will incorporate Distributed Powerbuilder functionality.

DPB app should return errors during migration. You should not be allowed to migrate it.





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

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。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------