提供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:207311
CR Number:   207311
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 13 Apr 2000 Fixed
Description
PB6.5.1, PB7.0 RPC call to MS SQLServer 6.5
When an empty string is passed to a MSS database and used to insert into a column, then
an ASCII character 0 instead of a space gets inserted into the column.
This happens with an RPC call, not with Embedded SQL.

Work-arounds :
- Call the RPC function with a string with a space in it instead of an empty string
- Check the argument within the stored procedure and modify the argument



CR:207313
CR Number:   207313
Product Name:   PB Enterprise
Product Component:   DPB
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 May 2001 Presently Not Targeted For Any Future Release Of This Product
Description
When selecting one or more rows in a DataWindow control, the customer would like to include these with the getfullstate/setfullstate powerscript functions, so that on doing a setfullstate he sees the selected rows from which he highlighted previously.
Workaround Description
 The workaround is to use a variable for storing the information.



CR:207348
CR Number:   207348
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Apr 2001 Not a Bug
Description
Dot notating to load a specific buffer datasource overwrites other datasources.
11/9/99 Development: This behaviour is as designed. When an assignment is made to the "current" buffer, the semantics are to delete all existing data and "insert" all the new rows. These rows then have a status of New, so there are NO original values maintained.



CR:207354
CR Number:   207354
Product Name:   PB Enterprise
Product Component:   DW 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
Using a stored procedure as a datasource, the following error message occurs when trying to create a crosstab datawindow:
"cannot recreate base environment. Please verify your database connection". The same stored procedure can be used for a tabular datawindow source. The problem involves something specific to this customer's stored procedures. Other stored procedures could be used for a crosstab datawindow source without any problems.



CR:207357
CR Number:   207357
Product Name:   PB Enterprise
Product Component:   DW Graph
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
Graphs Enhancement Request: Customer would like the order of the colors in the legend to match the order that they display in the graph.



CR:207360
CR Number:   207360
Product Name:   PB Enterprise
Product Component:   DW HTML
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 html dw preview mode, tabbing thru a dw will
change the value of the column when it is listed more than once on the same line.

Happens when tab order is greater than 0. Happens with n-up datawindows.
Happens under ie 4.0 and 5.0.



CR:207415
CR Number:   207415
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 98
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
If an sql statement, a newly defined database table is specified in lowercase, then PB7 will cause a GPF.
For an existing database table which also has tablename specified in lowercase, PB7 will not GPF but produce an error 'possible invalid table format'.
Workaround Description
 Export the datawindow to file.
Change the tablename from lowercase to all uppercase.
Export the datawindow.
Open the datawindow object.
Click SQL Data source button.
Result: OK



CR:207421
CR Number:   207421
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
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
PowerBuilder Jaguar Integration and Remote Debugging
When a variable is set to NULL either through SetNull or through a function like GetItemString,
the Remote Debugger gets a System Error.

This happens when the Watch view is open in the debugger.

In the serv.log there is an Fatal Exception on GetRemoteVars of the component PBDebugger/PBDebugBroker



CR:207422
CR Number:   207422
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Apr 2000 Not a Bug
Description
PB 7.0/7.01 Performance Degradation with OpenSheet especially over a LAN. (PFC most likely)

Development: No change to PB is required for this issue. A 7.0 enhancement caused a change in PATH requirements for PB to perform properly.



With PB7, we introduced a new feature that allowed users to associate BMPs and ICOs to their TOOLBAR items. With the addition of this feature,
at runtime we added the lookup and resolving of these BMP file. When BMP files are referenced but not found, PB does a search for them and it's often worse on a network. This happens every time a sheet is opened that contains a menu with a BMP (missing or not)


When the application is loaded, PB tries to locate each of the missing BMP files in the search path and in the EXE. This takes time and this occurs each time you call OpenSheet. PB goes out and looks for the same BMP files each time OpenSheet is called since the runtime has no way of knowing the BMP, ICO files will be there or not.


Resolution:

Adding the BMP files necessary to the PATH or as a resource to an application EXE file will cause a 7.0 application to perform the same as PB6 does without the BMP files available. This is because PB6 doesn't attempt to load these BMP files and when they are not found, it simply set them to the NotFound! stock icon.


For PFC users:
The typical missing icons are in m_master under View and Help. Most of the icons/bitmaps used are stock icons and are not a problem. If you deploy a PFC app and either forget to create a .pbr file or deploy these icons, PB will search for them (and fail) an sheet open performance will be worse if on the network or with a large path or multiple network drives in the path.

Large icons - largeico.bmp
Small Icons - smallico.bmp
List - listv.bmp
Details - detailv.bmp
Help Topics - helptop.bmp

The other option is to go to stock icons.



CR:207499
CR Number:   207499
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)
06 Jun 2000 Fixed
Description
In a group datawindow, if the name of a computed field in group trailer is changed and that computed field is referenced in a group sort expression PB gives the following crash...

Build 7.0.1.7017 -> 0x010697a4c at 0x04dc06b8 memory could not be read (pbdwe70.dll)
Workaround Description
 Update name which appears in group sort expression
With existing corrupt dws, export, edit .srd file and remove offending line
eg sort="sum(compute_field for group 1) A "



CR:207520
CR Number:   207520
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Nov 1999 Third Party Problem
Description
MS SQL Server 6.5 & 7.0
DataWindow w/RetrieveAsNeeded. During Update() process the application hangs.
This will happen under the following scenarios:
1). If RetrieveAsNeeded is on AND
2). Column contained in where clause is of type decimal 1,0 (sometimes column's w/datatype of decimal 12,0 also) AND this column is part of an index on the db.

11/8/99 -Develop'ers comments:
=========================
Tested here with service pack 3 on server. The update works with retrieve as needed on. So apparently
somewhere in between 6.50 and service pack 3 a locking bug was fixed. Then the bug was reintroduced in 7.0 and it is not known at this time if there has been a service pack for 7.0 with this fix in it or not.
Need to follow-up with Microsoft for server fix.



CR:207526
CR Number:   207526
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Aug 2000 Fixed
Description
In the window painter switching to edit an event script in one control after editing a USER EVENT in a DIFFERENT control will cause a gpf if both these controls are created on an inherited window .

Also reproduced error in custom visual classes and in menus
Workaround Description
 Click on a different standard PB event on the same object or the window before trying to edit event code on the other object.



CR:207609
CR Number:   207609
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)
04 Dec 2000 Fixed
Description
Memory leak when using CTRL+C key to copy script in clipboard



CR:207619
CR Number:   207619
Product Name:   PB Enterprise
Product Component:   Language - Compiler
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Aug 2001 Fixed
Description
To reproduce make a nonvisual userobject uo_test, with one userevent (ue_test) with no return type and one argument (long, al_array).
In the ue code the following:
long ll_Array[]
ll_Array[] = al_Array[]

This will give a error:
Warning C0014 : Undefined variable: al_array
Error C0070 : Mixing array and non-array in assignment statement

Workaround:
1. save the empty event
2. add
long ll_array[]
3. save uo
4. add ll_array[] = al_array[]
5. save uo
close uo
Problem if you open the uo and compile the script two times the error comes up again.



CR:207624
CR Number:   207624
Product Name:   PB Enterprise
Product Component:   Help
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 Fixed
Description
Example in help file for of_isvalid function is incorrect -it will always return a valid date because example uses date function to convert variable to a date datatype. Date function returns 1900-01-01 for an invalid date. Of_isvalid returns this as valid



CR:207649
CR Number:   207649
Product Name:   PB Enterprise
Product Component:   Menu Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 9017 16 Aug 2000 Fixed
Description
When a shortcut key is assigned to a sub-menu item (The lock name check box has to be unchecked). The first 3 or 4 characters after m_ are displayed as garbage.



CR:207714
CR Number:   207714
Product Name:   PB Enterprise
Product Component:   Migration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Oct 2000 Duplicate
Description
With the migration of a PB 5.0.04 to PB 7.01 the override edit propeties of a datawindow will be disabled.

Workaround:
If you've enabled the override edit propeties of a column in a PB 5 0.04 and you migrate the datawindow to PB 7.01
you have to enable the propeties again.



CR:207716
CR Number:   207716
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Apr 2000 Fixed
Description
Migrated PB 5.0.04 to PB 7.01 Application.
Setting the override property of a column in the dw painter change the fontsize of the column. If you reopen the dw the "Equality Required" property of the column is enabled.

Workaround:
Set resize the font and the disable the "Equality Required" property and then save the dw.



CR:207733
CR Number:   207733
Product Name:   PB Enterprise
Product Component:   Debugger
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
With remote debugging, there's an arrow on the left
hand side that shows what line the debugger is on. If you hit "step over",
it skips the next line. It's misleading because the line that was skip does get
process, it just confusing. Problem only happens in remote debugging.

Problem also happens with no breakpoints and you hit step in and then hit
step over. The arrow skips a line but that line does get process at the next line.



CR:207744
CR Number:   207744
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jan 2000 Fixed
Description
7.0 Regression. Creating a crosstab connected using native or ODBC drivers (Informix 7.3.2 -PBIN770.DLL,Sybase - PBSYC70.DLL, etc, ODBC - PBODB70.DLL), causes a GPF/crash just prior to completing the datawindow in the painter when hitting the FINISH button. This only happens when the user that creates the crosstab is not the owner of the table.

On WIN95 received the following:, "n70 caused an invalid page fault in module pbdwe70.dll at 015f:105bf8f6"
On NT 4.0 received: "The instruction at 0x105c0936 referenced memory at 0x00000008. The memory could not be read."

(Fixed in 7.0.02 build 8011 and above PBDWE70.DLL)



CR:207745
CR Number:   207745
Product Name:   PB Enterprise
Product Component:   Web 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
When saving a webpb project, it
doesn't same the html title, anchor link text or the function selected.

The html page gets created, but it is missing the title and the anchor link text so
that when it is viewed, the page is blank. Workaround is to add the html title
and anchor link text directly to the html file that got created.

Workaround is to add the html title and anchor link text directly to the html file that got created.

Another workaround is just to export the project object and add in the fields that are missing (that get stripped out). This seems to be the function, link text and page title.
$PBExportHeader$p_webpb.srj
GeneratorID:{DA7487C2-3843-11D2-B30F-00600825A521}GENBC00000073
L c:\test.pbl
O u_globals
FUNC:of_sendtext <-- ** This gets stripped out unless you add it manually
FILENAME:c:\inetpub\wwwroot\test.htm
PAGETITLE:Here is a Page Title <-- ** This gets stripped out unless you add it manually
PAGESTYLE:
METHOD:Post
LINKTEXT:Here is the Link Text <-- ** This gets stripped out unless you add it manually
INTERFACE:CGI
URLPATH:/cgi-shl
INIFILE:C:\WINNT\pbweb.ini
SECTION:10017



CR:207752
CR Number:   207752
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 26 Feb 2009 Presently Not Targeted For Any Future Release Of This Product
Description
Edit style upper/lower case does not work with HTML Datawindow.



Per Development:

This is working correctly in PowerBuilder8. (tested build 8002) The edit style of the column should be an editmask with a mask defined as !!!!!!!!!!!!!!!!!!!!!! (all upper case) or ^^^^^^^^^^^^^^^^^^^^^^ (all lower case) and the Client Formatting property for the datawindow (on the HTML Generation tab of the datawindow painter) should be checked. If these things are done the upper/lower case mask will work.
Workaround Description
 None that I am aware of



CR:207764
CR Number:   207764
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)
7.0.00 7022 25 Feb 2004 Fixed
Description
Memory leak in a PB Jag component if no PB service component is running.
Fixed in 7.0.1 build 7023 and after.
Workaround Description
 Have any PB service component running on the server.
Using instance pooling will eliminate the leak as well. (This should be done in a production environment in any case)



CR:207771
CR Number:   207771
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)
19 Nov 1999 Fixed
Description
In an external datawindow, the changes are not saved when
changing the "case" property of a column.

For example, if the case property is "upper" and you change it to "Any" and save
the dw. Open the dw again and the property for that column still says "upper".

Workaround: Export the dw and modify the column property in the *.srd file.



CR:207779
CR Number:   207779
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)
7.0.00 12 Apr 2000 Fixed
Description
If you have an extremely large number of datawindows included in the application library path, you will crash if you try to create a composite datawindow.

WORKAROUND:
In order to create a new composite datawindow, you would have to reduce the number of datawindows included on the library path. For example, you could create a PBL with nothing but an application object. Select that as your current application. Then copy whichever datawindows you wish to reference in the composite datawindow into that PBL temporarily. Create the composite datawindow, and then you can copy it back into your large application.



CR:207822
CR Number:   207822
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2000 Not a Bug
Description
Enhance source control interface implemented in PB 7, like the fact that there is no 'Yes to all' button when confirming deletes.

1. If a developer wants to use a new project, there is no way of connecting to a
project, and building the .pbl files with the correct objects, without creating
the .pbl files first, and then adding the objects manually (which could be
several hundred within many pbl files).
2. there is no way of synchronising all pbl files and adding new objects,
without manually selecting objects in each .pbl file, then manually adding new
objects into many different .pbl files.
3. Also suprising, when an object is deleted, a synchronise shows an error,
instead of removing the object from the .pbl.



CR:207827
CR Number:   207827
Product Name:   PB Enterprise
Product Component:   Project Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
Generate a java proxy for an nvo which accepts a structure (containing a char array and a blob)
as an argument, causes java compiling errors.
PB created following invalid Syntax:

for (idx0=0 ; idx0 < 50 ; idx0++ ) {
fixed_doc_desc[idx0] = new Character( ); <------######INCORRECT SYNTAX#####
}
doc_fmt = new Character[5];
for (idx0=0 ; idx0 < 5 ; idx0++ ) {
doc_fmt[idx0] = new Character( ); <------#####INCORRECT SYNTAX#####
}
doc_content = new Blob( ); <------ #####INCORRECTSYNTAX#####
}



CR:207842
CR Number:   207842
Product Name:   PB Enterprise
Product Component:   DW Expression
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
With IF statement in protect property -when ALL other columns are protected - or the taborder is set to zero -
DataWindow scroll functions like dw_1.scrollnextrow() don't work correctly



CR:207850
CR Number:   207850
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)
07 Aug 2000 Duplicate
Description
Memory leak repeatedly opening and closing the datawindow painter. Other more severe memory leaks have been fixed, but this leak remains testing in the 7017 ebf.



CR:207951
CR Number:   207951
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 98
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
Function ReselectRow() broken for PB7 when using OLE DB database interface.
PowerBuilder incorrectly strips the database table columns names in the sql statement sent to the database.

The datawindow SqlPreview event will show the sqlsyntax string to be empty values for column specifications e.g. :
SELECT , , FROM WHERE = '163'



CR:207959
CR Number:   207959
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Feb 2000 Duplicate
Description
PB 7.0 /7.0.1 results in an Illegal Page Fault in PBRTC70.dlll if you simply try to place a Richtextedit control on a window. This happens only on Win 98 machines. It will work fine using PB 6.0 on Win 98 machines or PB 7.0 on either WIN95 or NT 4.0.



CR:207999
CR Number:   207999
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
If a string expression is entered into any of the three DW bands for color property. It passes validation test.
If you preview the DW, the value is ignored and if you regenerate the DW, the string in the expression vanishes.

For example type in "255" for the Color property expression of any dw band. It is ignored and disappears on regenerating the datawindow.
The same value for other properties such as Pen.color, text.color etc - passes validation and is ignored but not lost on regenerating the dw

Cust would like a more consistant behaviour.
Should either give a validation error or work as a string. If it passes validation it should not disappear on regenerating
Workaround Description
 Don't use quotes or use Long("255")



CR:208003
CR Number:   208003
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 RC2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
Setting dynamically the sort order in HTML DWs.Set the sort order in a HTML DW using the following code:
<FORM name="Sort_by_name">
<INPUT value=Sort onclick="{htmlDW.SetSort('task_name'); htmlDW.Sort();}" type=button> </FORM>
The page is reloaded with the right sort order. But when a ScrollNextPage is called through a standard DW button the sort order is lost.



CR:208020
CR Number:   208020
Product Name:   PB Enterprise
Product Component:   DW DDDW
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.x Catalina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Oct 1999 Presently Not Targeted For Any Future Release Of This Product
Description
Modifying background property of a dddw causes a retrieve when transobject is set on datawindow control
WORKAROUND: do the modify before the transobject is set



CR:208032
CR Number:   208032
Product Name:   PB Enterprise
Product Component:   DW Synchronization
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 02 Jan 2001 Fixed
7.0.00 02 Jan 2001 Fixed
Description
When there are nulls in the data, do update using getfullstate/setfullstate to get original values, the first null value can get correct original value, but all other original data will change to what was typed into the DW .



CR:208038
CR Number:   208038
Product Name:   PB Enterprise
Product Component:   DDE
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
Using DDE and the client and server are on the
same machine, will return a -1 for a second openchannel call.

Problem only happens if the client and server are on the same machine.
Works ok remotely and if you wait for a undetermine amount of time.



CR:208059
CR Number:   208059
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)
04 Dec 2000 Not a Bug
Description
When using the Replace dialog, the Tab key no longer works, and neither do hotkeys such as Ctrl-A (Replace All). Just beeps and does nothing. Must use the mouse to switch fields and make selections. Did not happen in prior versions.



CR:208069
CR Number:   208069
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)
8.0 Beta 4 5017 25 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
5.0 Regression. (GPFs in PowerBuilder 6.0-7.0.2 C3 as well) When you have 2 or more columns selected for either the Rows and Columns settings in the Crosstab dialog, you will get a GPF in PBDWE70.DLL moving any of the bands or changing an attribute of an object when the datawindow painter is showing the "preview" view AND the datawindow is retrieved into the preview view.. (PB 7.0). Prior versions required you change the band height or object attribute at runtime with Modify() to get the GPF. (PB5.0-6.5)





More visible in PowerBuilder 7.0 since the views allow the developer to resize the design and have it immediately reflected in the preview "view" in the development environment. This could only be achieved during runtime prior to 7.0.



WORKAROUND: WHEN WORKING ON A CROSSTAB REPORT IN THE DW PAINTER, DO NOT VIEW A LIVE PREVIEW OF THE REPORT IN ANOTHER PANEL OF THE PAINTER. Wait to preview the datawindow until after changes have been saved to the datawindow object and then INSTEAD of using the preview panel, click the Run/Preview Object button in the ToolBar to open and view the report.



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:208090
CR Number:   208090
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)
22 Oct 1999 Not a Bug
Description
Unable to print a mle in PB 6.5.1. Problem is in the following line:
send(handle(mle),1035,linenum,0)

Returning 0 in PB 6.5.1 (32bit), PB 7.0 and PB 4.0.07. Worked ok in 16 bit pb 4.0.07. The message
number of 1035 should be sending the windows message em_lineindex.
Workaround Description
 long ll_rc
integer pagenum

ll_rc = printopen()
mle_1.border = false
print(ll_rc,"Page " + string(pagenum) + "~r~n" )
print(ll_rc,"~r~n")

mle_1.print(ll_rc,500,1000)


mle_1.border = true

printclose(ll_rc)



CR:208114
CR Number:   208114
Product Name:   PB Enterprise
Product Component:   SQL Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2004 EOL'd version. Not to be Fixed.
Description
SELECT statmente has computed columns. After converting from syntax to graphic in the SQL painter it could cause incorrect syntax if you switch several times between SQL Painter and Datawindow Painter because computed columns are deleted.

WORKAROUND:
If you switch from SQL Painter to the DW Painter and you got the message that the SELECT has been changed but you didn't changed it
then check in the SQL painter if computed columns are lost. If yes add the comupted columns again and save the dw.



CR:208123
CR Number:   208123
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
/= result in GPF when using the division operator shortcut for a null variable.
1. The script below works fine :
decimal{2} ldc_Result
SetNull( ldc_Result )
ldc_Result = ldc_Result / 1.00

2. The script below GPF :
decimal{2} ldc_Result
SetNull( ldc_Result )
ldc_Result /= 1.00



CR:208126
CR Number:   208126
Product Name:   PB Enterprise
Product Component:   DB Oracle
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
Oracle o84 incorrect SQL syntax does not return parse error on compile



CR:208133
CR Number:   208133
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)
02 Jan 2001 Fixed
Description
Documentation Error :
You can't use GetChild to get the reference to a report in a composite Datawindow, if the report itself is a composite or nested DataWindow. GetChild will return -1



CR:208134
CR Number:   208134
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)
20 Feb 2004 Not a Bug
Description
The DW query Mode doesnt accept any criteria if AccepText() is not called.





Per PB Engineering:

This is not a bug, it is how query mode works now. CR 169396 was a change to require the AcceptText or tab off the column to cause an acceptance of the string. This fixed a loop which could occur when we "automatically" accepted the text when switching modes (to query mode or from query mode).



CR:208205
CR Number:   208205
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)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
Painting problem when using dragdrop with a treeview control. When you select an item from the bottom of a branch of the treeview, if you drag it upwards over the text of the other branches of the treeview, they are highlighted. As you drag, they become partially highlighted, and several can paint this way at the same time

Workaround:
Put at the end of the BeginDrag event setredraw(false)
Put at the end of the DragDrop event setredraw(true)
This prevents PB drawing in the meantime of the drag process.
Workaround Description
 **** Tue Apr 04 15:46:42 GMT+02:00 2000 *** kirchner ****

found some sort of acceptable workaround:
Put at the end of the BeginDrag event setredraw(false)
Put at the end of the DragDrop event setredraw(true)



CR:208213
CR Number:   208213
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)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
Online help for GetChild states: "You can't use GetChild to get a reference to a report in a compoiste DataWindow when the data source of the nested report is external. ". I seem to be able to use GetChild with an external datawindow within a composite report. Is this sentence incorrect or is there a good reason not to do this?



CR:208225
CR Number:   208225
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)
7.0.00 EBF1 30 Mar 2000 Fixed
Description
PB crashes or does an immediate close/exit after all
columns are deleted in a grid dw. The dw had two tables that were joined and
all columns were selected.

Problem happens when connected to syc,o73,or8,o84,mss.

When connected to SYC and after all columns are deleted, if you close pb the following error
message appears:

Smart Heap Library
MEM_BAD_MEM_POOL



CR:208314
CR Number:   208314
Product Name:   PB Enterprise
Product Component:   Edit Mask
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 1197 01 Sep 2000 Fixed
Description
PB6.5 and PB7 Control Panel issue with Decimal Separator Comma
The edit mask control function GetData copies only the fractional part of a number into a double variable,
em_1.GetData(<double Variable>)

Work-around :
- em_1.GetData(<decimal Variable>)
- <double Variable> = double(em_1.text) (PB6.5.1 onwards)



CR:208315
CR Number:   208315
Product Name:   PB Enterprise
Product Component:   DW ActiveX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 7022 28 Mar 2000 Fixed
Description
TIBCO activex control to receive messages generated by a TIBCO daemon which
is spawned by a Java component running in Jaguar. Everything is fine and
dandy until the user clicks in several fields within a datawindow ( dw is
not on the same window as the activex ). After enough clicks, PB GPFs every
time. Removing the TIBCO activex control makes the problem go away
immediately.

Running this resulted in the following error "The instruction at '0x00000000f' referenced memory at '0x00000000f' The memory could not be read. Another time PB itself shut down without an error message.

Need to determine if this is a PB problem or a problem with the activex.

Per Development, this wasn't related to the TIBCO ActiveX:
This is a problem with the clicked event not cleaning up an object reference and a subsequent event is causing a crash.
Workaround Description
 Scripting the Clicked (and maybe the DoubleClicked) events on the DW control should clean up the garbage that is causing this problem



CR:208383
CR Number:   208383
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Oct 1999 Fixed
Description
Application migrated from 6.5 to 6.5.1 or 7.0.1. Now a datawindow with both a horizontal and vertical scrollbar has the vertical scrollbar paint on top of the far right column/label of the datawindow. There was no platform change.



CR:208384
CR Number:   208384
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 9001 01 Sep 2000 Fixed
Description
Using a spin control editmask and migrated to 7.0. In 7.0 the size of the spin arrows is different than in 6.5, causing the arrows to sometimes paint on top of the data when the field has focus. The display is okay when the field does not have focus.



CR:208386
CR Number:   208386
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
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
Cannot change the concurrency property of a
component after it is deployed to Jaguar.

When a component is deployed to jaguar, the following the property of
com.sybase.jaguar.component.thread.safe
is missing from the all properties tab.

You cannot change the concurrency property unless this property is out there.
Workaround Description
 Add the following property to the allproperties tab of the component:
com.sybase.jaguar.component.thread.safe



CR:208396
CR Number:   208396
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
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
When creating a new jaguar component, you are asked if you want to create a project for the component - This will not allow you to add to an existing jaguar project meaning that you have to either have multiple jaguar projects, or must manually adjsut the project you have afterwards.



CR:208403
CR Number:   208403
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
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 Jaguar under the instances tab, it shows
that bind, pooling, sharing and concurrency are checked for a
shared component deployed from Powerbuilder with the bind thread
option checked.

In the Jaguar CTS Programmer's Guide on page 81, if sharing and bind
thread options are selected, the concurrency option is implicity disabled.
Workaround Description
 Add com.sybase.jaguar.component.thread.safe = false to the component properties
from the all properties tab.



CR:208461
CR Number:   208461
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.x Catalina 28 Mar 2000 Fixed
Description
pb 7 causes gpf when moving the mouse over a datawindow if the dw has no script in the doubleclicked event.
If dw was double clicked and you click on a button on a window. And this button has focus for some seconds after it was clicked. And if you move the mouse back to the datawindow -> Pb causes a gpf.

Workaround. Put a comment in the double clicked event of the datawindow



CR:208484
CR Number:   208484
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.0.04 13 Apr 2000 Fixed
Description
DataWindow EditMask shows keyboard entered NULL date (e.g. 00.00.00) incorrectly. The NULL date is shown in the Editmask as a date (e.g. 01.01.00) - related to 201595, but here with dot date separator.



CR:208533
CR Number:   208533
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
In the dwpainter when a db blob column is defined with a
ole class desc of Paint.Picture: Bitmap Image and you try to either insert
a new row or update a row, the db blob column is not saved to the table.

When you update or insert in the dw painter and you double click on the
db blob column, mspaint will appear. Once you add or change the image
and then select file/update id in mspaint and then select save in the dw and
re-retrieve, the image is not saved to the table.



CR:208556
CR Number:   208556
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   Microsoft Windows 98
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
MS Access has linked tables which are not viewable in PB ODBC database connection Objects tab.
PB is aware of the linked tables though they are not viewable for the user to handpick with other regular Access db tables.Possible to query linked tables using dynamic sql or dynamic datawindow object creation.
Workaround Description
 Create dummy dw datasource SQL Select from Access table (not a linked table).Convert to syntax. Alter statement to query columns from linked table. OR Create runtime dynamic dw or if dw object is simple(i.e. format of dw is not important) then alter SQL.



CR:208565
CR Number:   208565
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jan 2001 Not reproducible with latest version of the product available as of Resolution Date
Description
When using the Geomedia OCX, the map legend child window does not open when the map is displayed. Also, a GPF occurs when you close a PowerBuidler application with an active Geomedia control on it



CR:208615
CR Number:   208615
Product Name:   PB Enterprise
Product Component:   System Runtime Functions
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   7.x Catalina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When the error message "Library Manager Fatal Disk Error" is displayed, the customer would like that PB
display also the OS system return code and the OS message that leaded to the error.



CR:208619
CR Number:   208619
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
When more than 1 row is to be deleted in a DW, and in SQlpreview Event is coded a sql Statement (insert or select) an DB error appears "a invalid handle was passed in a call to the Database driver" appears if Bindselect and Bindupdate are set to "Yes" in the PBODBxx.INI file.

Workaround:
Set Bindupdate and Bindselect to "NO"



CR:208654
CR Number:   208654
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)
06 Dec 1999 Fixed
Description
PB crashes on a setfullstate call with the following error
message when a column has null values:

"Out of memory"
PB 70.exe - Fatal Application
Insufficient memory to continue



CR:208703
CR Number:   208703
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 7024 25 Feb 2004 Fixed
Description
If a row is inserted into a Sybase database using the SYJ driver, the datastore update may indicate success, even if the row contained NULL values in columns that do not allow NULL values. Subsequent retrieves indicate that the rows were not inserted.



CR:208707
CR Number:   208707
Product Name:   PB Enterprise
Product Component:   DW DDDW
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 28 Apr 2000 Fixed
Description
Allow Editing on DDDW/DDLB has changed looks since 6.5. It does not let the datawindow colour
come through between the edit and the arrow and looks bad if background colour of text is
not the same as the datawindow colour



CR:208721
CR Number:   208721
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Nov 1999 Not reproducible with latest version of the product available as of Resolution Date
Description
Modifications to datetime column are not being propagated to a Sybase back-end when getchanges() and Setchanges() ared used. Driver was SYJ.



CR:208775
CR Number:   208775
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)
21 Mar 2000 Fixed
Description
Create a datawindow that access a column which generates a column name of greater than 40 characters. Do not save the datawindow yet. Click on one of the long-named columns. Sporadically this will cause a GPF. If the datawindow has been saved before you attempt to make any column property changes, then this problem does not occur.

WORKAOURND: If you save the datawindow before making any changes the problem does not occur.
Workaround Description
 If you save the datawindow before making any changes then the GPF does not occur.



CR:208832
CR Number:   208832
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Solaris 2.6
Original Version:   7.0.00 RC2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 Fixed
Description
EAS 3.01 running on Solaris 2.6 using Oracle 8i as database and OCI for connection, htmldw failed to generate
EAS 3.01 running on Solaris 2.6 using Oracle 8i as database and ODBC for connection, htmldw can be generated
successfully



CR:208886
CR Number:   208886
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Apr 2000 Fixed
Description
On a char field in a dw, if the default editmask is set and if you do a gettext() what you get is the actual string along with blank spaces. For example, if you have an editmask 20 chars long and the field has 10 chars. doing a gettext() gives you the 10 chars and 10 spaces. Getting the Len() of this always yields the length of the editmask regardless of what is in the column. Additionally if the cursor is placed in the column and the "End" keyboard key is pressed the cursor jumps to the end of the editmask.

In PB 6.5.1 the correct length is returned and the column is not padded with spaces.



CR:208917
CR Number:   208917
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Mar 2000 Fixed
Description
date column with editmask dd.mm.yyyy. If date column is NULL (00.00.0000) -> gettext()
returns empty string in PB 6.5.x code line. Returns 1900-01-01 in PB7 codeline.Should there be a default behaviour?

Workaround:
Problem is that you are not able to check with gettext() if a column is null or not. You have to use isnull(dw_1.object.<columname>[row]) to check if a column is NULL or not.



CR:208928
CR Number:   208928
Product Name:   PB Enterprise
Product Component:   DB Oracle
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
Regression in PB6.5.1 and post builds.
PB6.5.1 and post build behave incorrectly when synonyms for Oracle tablenames are referenced.
Workaround Description
 -Use PB6.5.x with ODBC to connect to Oracle8.x instead of Oracle native drivers.
-Refer to the actual object name e.g. tablename instead of synonym
-Connect as table owner and use Embedded or dynamic SQL in script.



CR:209001
CR Number:   209001
Product Name:   PB Enterprise
Product Component:   DW Plugin
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 1155 31 Oct 2002 Fixed
Description
Datawindow and datawindow plugin not displaying vertical scrollbars correctly after printing. If the datawindow contains a group that has 10 pages, after printing, the scrollbar thumb changes size and the datawindow shows only 1/2 of a page even though there is 10 pages of data. If the datawindow contains NO group, after printing the vertical scrollbar completely disappears.

Workaround: RELOAD the psr after printing.



CR:209023
CR Number:   209023
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 28 Mar 2000 Fixed
Description
6.5.1 Regression. Related to CR200800. A datawindow with retrieval argument of type NUMBER ARRAY when retrieved generates SQL that has float numbers. For example, an array with integer elements 1 and 2 causes 1.000000000 and 2.000000000 to be generated (actually 18 zeros after the decimal point).

This can cause enormous performance problems on retrievals. This is not database specific and was found in ODBC, SYC and MSS drivers.

CR200800 was fixed for single numeric (INTEGER) retrieval arguments but not for NUMBER ARRAYS.

Fixed in 6.5 1127 and above.



CR:209035
CR Number:   209035
Product Name:   PB Enterprise
Product Component:   DW DDDW
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 10021 28 Apr 2000 Not a Bug
Description
Customer has a dddw column.
For each row, he wants only rows in the dddw where (dddw_column.status = dw_current_row.status ) to be available to pick from.
He cannot filter the dddw to include only the rows for the current status because then all other rows in the parent dw lose the display value. He has code which keeps the user from being able to select a non-matching status when it runs. This works great except when the
user uses the up or down arrow keys. Then the value displayed for the column itself shows the row with the invalid status, but the selection in the dropdown is a different row.



CR:209066
CR Number:   209066
Product Name:   PB Enterprise
Product Component:   Function 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 Presently Not Targeted For Any Future Release Of This Product
Description
7.0 Function painter missing Control-S for "Save"



CR:209069
CR Number:   209069
Product Name:   PB Enterprise
Product Component:   Library Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Dec 2000 Third Party Problem
Description
Using large fonts causes problems when using source control. None of the icons will display
next to the object like the barrel representing the object is registered. Or the lock icon representing the object is checked out.

Workaround: Set Display to Small Fonts.



CR:209089
CR Number:   209089
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Dec 1999 Not a Bug
Description
When connected to either in7 or in9 and inserting, updating
or deleting data in the database painter, pb will either crash or get the smartheap
library error: Mem_bad_pointer.
Workaround Description
 Modify data in dw painter



CR:209096
CR Number:   209096
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 8026 20 Apr 2000 Not reproducible with latest version of the product available as of Resolution Date
Description
Memory leak using PB and Jaguar, with a component that uses instance pooling, and does a create datastore.



CR:209136
CR Number:   209136
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Aug 2000 Fixed
Description
Edit mask - ####/####/#####/##### Different behavior from PB 6.5 to 7
if typing "/" key cursor does not jump to the next #### insert part.



CR:209155
CR Number:   209155
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 7022 25 Feb 2004 Fixed
Description
Customer has dw she is using to generate HTML. When generated and displayed using PB 7.0 build 6012, the dw displayed neatly aligned, very similar to it's appearance in PowerBuilder. When the HTML is generated using PB 7.0 build 7017, the display in the browser is very messy. Occurs for both IE 4 and Netscape 4.5.



CR:209169
CR Number:   209169
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
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
Enhancement request description:
Re:Editmask control
____________________
Would like a new mask character to be supported in PB for masking alphabet letters only
e.g. re: English language alphabet - chars A-Z(upper or lowercase) only to be allowed.

For example in PB, '#' mask character signifies character can only be numeric values [0-9]
Workaround Description
 Use an external datawindow which has one column object with edit mask defined.
This dw control object will be used for data-entry. Create a window function that will validate for the alpha/letter positions upon the EditChanged event firing.



CR:209170
CR Number:   209170
Product Name:   PB Enterprise
Product Component:   Library Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8004 28 Jan 2000 Fixed
Description
Library Painter: Search fails on scripts where first line is blank



CR:209179
CR Number:   209179
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)
29 Nov 1999 Fixed
Description
PB crashes on a registryget function with the wrong datatype.

The registryget function is trying to retrieve a reg_dword using a valuetype of regstring!
and a valuevariable of string.

On win95 machine, the following error occurs:
pb70 caused an invalud page fault in pbvm70.dll at 0137:1133dc6e

On nt, app crashes. PB doesn't crash when using a valuetype of regstring!
and a valuevariable of ulong. (See testcase).



CR:209202
CR Number:   209202
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   Microsoft Windows 98
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
Enhancement request description:
Would like Autosize Height feature for datawindow SUMMARY band.

These bands exist in a datawindow:
Header
Detail
Summary
Footer

At this time only the Detail band has the Autosize Height feature.
____________________
Workaround Description
 1)Put object in Detail (not Summary band) 2)Set object Autosize property to TRUE 3)Set expression for object's Visible property IF(getrow()=rowcount(),1,0) {Object shown after last detail row and Autosize of the object is accounted for in Detail band.}



CR:209266
CR Number:   209266
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)
19 May 2000 Fixed
Description
Modifying Y2 line object expression in a DW sets X1 expression



CR:209270
CR Number:   209270
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jan 2001 Presently Not Targeted For Any Future Release Of This Product
Description
Treeview control on window object GPF's if the control has not been populated(i.e. state is empty) and a <BACKSPACE> key is pressed when the control has focus.

This GPF occurs only for Pb6.x versions and not for PB7.x.
Workaround Description
 No crash if the treeview control is populated and then <BACKSPACE> key is pressed.



CR:209275
CR Number:   209275
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
An Excel spreadsheet created from a template should include basic styles so such toolbar buttons as the $ button and the % button work. A new sheet from the default template in Excel includes this. Customer would like PowerBuilder to incorporate Excel styles into the spreadsheet created by SaveAs or Save Rows As... to an Excel or Excel5 format.

Workaround is to set up a new toolbar item that executes Format->Cells->Currency, which does work.
Workaround Description
 Workaround is to set up a new toolbar item that executes Format->Cells->Currency, which does work.



CR:209277
CR Number:   209277
Product Name:   PB Enterprise
Product Component:   DW SaveAs
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
When a result set is saved to Excel or Excel5 format, no default styles are included. This is logged as enhancement request 209275. However, even if there are no styles present, you should be able to merge styles from another existing spreadsheet. You can do this with "regular" .xls files, but if you try to do this with a .xls file created by Save Rows As... Excel5 in PowerBuilder 7.0, Excel will crash when you try to merge the styles. There seems to be a problem with the format created.

Workaround: Manually create styles instead of merging them from another spreadsheet.
Workaround Description
 You would have to manually create styles rather than merging them.



CR:209300
CR Number:   209300
Product Name:   PB Enterprise
Product Component:   DW Synchronization
Status:   Closed
OS:   Solaris 2.6
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
Using dw synchronization doesn't update to db when
used in a distributed application where the client and server apps are on
different platforms. The update works ok if the client and server pbls are on
the same machine.

Problem happens when the server pbl is on unix and the client on nt AND
when the client is on unix and the server is on nt.

Problem happens using the o84 and syd driver so it doesn't appear to be
db specific.



CR:209329
CR Number:   209329
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jun 2000 Duplicate
Description
The errors on a DB connection from component in Jaguar are not raised to PB



CR:209334
CR Number:   209334
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)
30 Nov 2000 Duplicate
Description
PB 7 Switching the scripts between functions and main object (using the dropdownlistbox) causes
a memory leak.
On on Win 98 and 95 this can cause an invalid page fault in user.exe at 0003:00008290



CR:209335
CR Number:   209335
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 EBF1 14 Jun 2000 Fixed
Description
7.0 EBF Regression (Build 7017). When editing a nested report in the datawindow painter and adding or deleting columns from design mode and saving, the retrieval arguments and their associated expression linking to the parent report are deleted.

The symptom would be later in preview of the parent report or in the application, the user would be prompted for retrieval arguments (from the nested report) since the nested reports retrieval argument is no longer tied to the parent.



CR:209345
CR Number:   209345
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)
15 Jun 2004 EOL'd version. Not to be Fixed.
Description
Customer declares an instance variable of a structure in a non-visual user object. The compiler issues a warning, but the declaration has disappeared when they re-open the user object. Compiler should issue an error instead of a warning to make it more clear that this is not allowed.



CR:209378
CR Number:   209378
Product Name:   PB Enterprise
Product Component:   DW - 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
Portions of detail in a composite datawindow may be cut off if the entire DW cannot be printed on the current page.



CR:209384
CR Number:   209384
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.2 1157 15 Nov 2000 Fixed
Description
Regression: Tables are being prefixed with their ownder names with aliases for those owners are being used.



CR:209387
CR Number:   209387
Product Name:   PB Enterprise
Product Component:   Function Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Dec 2000 Fixed
Description
File...Print in the function painter does nothing. Nothing prints.



CR:209388
CR Number:   209388
Product Name:   PB Enterprise
Product Component:   Language - Compiler
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
Create a visual uo with a command button called cb_ok and place that on a window. Then try to add a command button called cb_ok to the window. You get an error message that the name is duplicate. The problem did not occur using 6.5. This is being evaluated to determine whether it is a bug, or a function of a less tolerant compiler.



CR:209390
CR Number:   209390
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)
15 Nov 2000 Fixed
Description
When you sort a datawindow on a specified column, if the data is NULL it remains at the top, regardless of whether you chose Ascending or Descending for your sort. This is correct behavior, since NULL is an unknown value, so it is not possible to determine where it should fall in a sort. But it would be nice to add an brief explanation of this behavior to the documentation.



CR:209407
CR Number:   209407
Product Name:   PB Enterprise
Product Component:   Generators
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 May 2003 Presently Not Targeted For Any Future Release Of This Product
Description
ole automation project does not compile (dlls) and gpfs if the uo has an instance variable or a simple comment in declare instance variable

Workaround:
a) use the "COM Generator" rather than the old style "OLE automation" style of project.
All development efforts are in the "COM Generator".
b) use PBDs instead of DLLs



CR:209411
CR Number:   209411
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)
12 Nov 2000 Not a Bug
Description
a column which has many lines is displayed partially



CR:209455
CR Number:   209455
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 10075 27 Jun 2001 Fixed
Description
SaveAsAscii() is dropping columns in the text file after the import into MS Excel in 7.0 build 7017 and higher





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

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