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

 

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

如有问题,请联系我!

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

 

CR:172394
CR Number:   172394
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 95
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: DataWindow Painter Group Band Object definition needs Reset Page Number on Group Break to be DISABLED until the New Page on Group Break is checked. Right now you can check either one, and if you only check Reset Page Number on Group Break, it does not reset which it shouldn't anyways.



CR:172428
CR Number:   172428
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 11 Jan 1999 Fixed
Description
A single character command line argument separated from the exe path by a single space is ignored by the CommandParm() function and the Application Open event commandline argument.
Workaround Description
 Use multi-character command line arguments.



CR:172470
CR Number:   172470
Product Name:   PB Enterprise
Product Component:   Help
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0 Beta 2 10 Aug 2000 Fixed
Description
Documentation Enhancement: In DataWindow Painter, if you define a group on the datawindow and want the page numbers reset, you must select New Page on Group Break also.



CR:172481
CR Number:   172481
Product Name:   PB Enterprise
Product Component:   Language - 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 475 25 Nov 1998 Fixed
Description
PB 6.5 REGRESSION. Works ok in 6.0. Converting string to double or real cuts off the digits after the decimal separator, e.g. "3,5" is returned as 3(,00). Only occurs when Regional Settings are set to a country which uses the comma as decimal separator.



CR:172493
CR Number:   172493
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 EBF1 7014 27 Dec 2000 Fixed
Description
Opensheet/Close with a menu in a tight loop never releases menu memory on Win95



CR:172534
CR Number:   172534
Product Name:   PB Enterprise
Product Component:   DW Graph
Status:   Closed
OS:   Solaris 2.5.1
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
Cannot change the background color of legend,category and value



CR:172547
CR Number:   172547
Product Name:   PB Enterprise
Product Component:   Structure Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Nov 1998 Presently Not Targeted For Any Future Release Of This Product
Description
ENHANCEMENT REQUEST to allow protected access to an instance of a structure.
The structure definition should be visible for descendants, so that it is possible to define an ancestor method which returns the whole structure.
Workaround Description
 move the declaration of the structure to the globals



CR:172580
CR Number:   172580
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 204 25 Sep 1998 Fixed
Description
Trying to modify the Table.Select of a datawindow with a string that is built in code from user selections. When a specific string is
used, the Modify causes a GPF.
Requirements to reproduce:
1. datawindow/datastore object must have a dataobject assigned - does not occur if no dataobject has been assigned
2. string must be assigned as in the code from the PBL submitted with this issue. The string is 448 characters long and
includes an embedded ~' sequence.
If the string length is changed - e.g., by adding a space character at the end - the problem does not occur.
If the ~' is replaced by some two other characters, the problem does not occur.
If the ~' is moved to some other part of the string AND the length remains 448, the problem WILL occur.
The problem does not occur if we use dot notation to assign the new select statement - this is customer's work around.
Workaround Description
 Use dot notation instead of Modify.



CR:172631
CR Number:   172631
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Oct 1998 Not a Bug
Description
When a CRLF (~r~n) was placed in a Select statement used to create a dynamic datawindow in 32 bit PB 4.0 through 4.0.07 it produced a CRLF in the dw. IN PB 5.0 through 6.5 the CRLF is ignored. If the character equivalent ( '\x0d\x0a') is placed in the Select statement the behavior is the same as in PB 4.0.07.

Workaround: Replace '~r~n' with char(10), the ascii equivalent , and it works as before.
Example: "SELECT emp_id, emp_fname +char(10) + emp_lname FROM employee". Tested in both SQL ANywhere and Sybase SQL Server. Concatenation characters may be different depending on database.

From Development: The change in the DataWindow engine was intentional in Release 5.0. Thus this is not a bug and will not be changed.
Workaround Description
 Replace '~r~n' with char(10), the ascii equivalent , and it works as before.



CR:172663
CR Number:   172663
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)
15 May 2000 Not reproducible with latest version of the product available as of Resolution Date
Description
The default background color for a datawindow column changes after clicking on the font tab. This can be seen if you examine
the exported dw code. There is no visible difference when previewing the datawindow.



CR:172695
CR Number:   172695
Product Name:   PB Enterprise
Product Component:   Machine Code Exe Creation
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
If you use the MID() powerscript function with a NULL argument, you will get a gpf when it is run from a machine code executable.
Workaround Description
 Check for the NULL condition before you use the Mid() function.



CR:172698
CR Number:   172698
Product Name:   PB Enterprise
Product Component:   Cgen
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   7.0.00 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Sep 1998 Not reproducible with latest version of the product available as of Resolution Date
Description
If you attempt to create a machine code executable, you get error :Could not create or open file 'C:\PWRS7\BUILD196\cgen\EN32T.h'
Create of executable file failed
Workaround Description
 Use PBD's



CR:172701
CR Number:   172701
Product Name:   PB Enterprise
Product Component:   Migration
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   7.0.00 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Sep 1998 Not reproducible with latest version of the product available as of Resolution Date
Description
Migrating a PBL from PB 6 to PB 7 causes a GPF in PBVM70.DLL. The PBL seems to migrate OK and can be used after restaring PowerBuilder.
Workaround Description
 After the crash. Restart PowerBuilder and the PBL should be OK.



CR:172745
CR Number:   172745
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
Customer would like to be able to specify the nolock db option for SQL Server directly through the datawindow painter.



CR:172787
CR Number:   172787
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 1998 Duplicate
Description
The pictureheight property of a picturelistbox control is not recognized for the display.The pictures show up scrambled in height. Works in 5.0.04.



CR:172818
CR Number:   172818
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Nov 1998 Not reproducible with latest version of the product available as of Resolution Date
Description
GetFullState() causes a memory error if the datawindow is crosstab and was previous populated by a SetFullState().



CR:172875
CR Number:   172875
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Oct 1998 Presently Not Targeted For Any Future Release Of This Product
Description
GetFullState fails in 16-bit PB.



CR:172879
CR Number:   172879
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 12 Mar 1999 Fixed
Description
If you create a linked list of user objects and you are using a 16 bit executable, you will "lose" some of the entries if the number of members in the list becomes too large.

Workaround: Turn garbage collection off using GCTimeoutLimit



CR:172953
CR Number:   172953
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
Make default background color for dw columns 553648127 and not 536870912.

This would help ct's dws print correctly and avoid an inconsistent dw behaviour (see below)

Current dw column default background color is 536870912 - transparent. But ct has problems printing this value on some printers. However 553648127 (also transparent) prints correctly.

Also if we change the column foreground color (from black to navy for example) then the background color for same dw column is changed from 536870912 to 553648127 (both appear as transparent in dw painter)

Therefore ct would like the default color to be 553648127 given that this is what the background is changed to when the foreground color is changed. This would make the datawindow painter behaviour more consistant and resolve the ct's printing problem.
Workaround Description
 - Modify dws at runtime
- Describe(), edit syntax, LibraryImport()
- LibrayExport() edit syntax and LibraryImport()
- Do above manually in the painter.



CR:172968
CR Number:   172968
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 465 16 Dec 1998 Fixed
Description
<dw>.Filter() causes a GPF if the datawindow contains groups and the current row has scrolled out of view.
Workaround Description
 None.



CR:172973
CR Number:   172973
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
When exporting a Crosstab DW to Excel using the SaveAs Excel! function the resulting file does not retain the coulmn headers or any of the computed fields. Using a workaround of SaveAs HTMLTable! does not work if the size of the HTMLTable is > 2 meg. When the file is attempted to be opened in Excel an error message is received stating that Excel cannot convert/open an HTML file >2 meg.
Workaround Description
 Use SaveAs HTMLTable! if report is not too large (>2 meg)



CR:172981
CR Number:   172981
Product Name:   PB Enterprise
Product Component:   Font
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 1998 Presently Not Targeted For Any Future Release Of This Product
7.0.00 RC1 04 Mar 1999 Fixed
Description
For a tab control using Vertical tabs,, non-TrueType fonts do not appear on the tab, probably still being displayed horizontally.
There is no problem for TrueType fonts.



CR:173018
CR Number:   173018
Product Name:   PB Enterprise
Product Component:   DW DDDW
Status:   Closed
OS:   Microsoft Windows 95
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
Feature Request: dddw programming
No more call to getchild to get a new handle after retrieving data into the dwchild. After Changing the appeareance of the dddw and hence after the change one needs to call getchild to get a new handle.



CR:173055
CR Number:   173055
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Dec 1998 Not a Bug
Description
Placing parenthesis around the select clause for a crosstab datawindow with a union alters the datawindow in such a way that if you click in the SQL toolbar icon, you will see the Crosstab definition window, not your select statement.
Workaround Description
 Export the datawindow to an SRD file and replace procedure with retrieve



CR:173061
CR Number:   173061
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
SetItem for a ListView returns 1 even when passed a NULL value for the index. It should either return an error, or we should document what the behaviour will be when passed a NULL.

WORKAROUND: Check for NULL in code.



CR:173075
CR Number:   173075
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
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 following sequence of datawindow events cause a page fault:

1) connect to database

2) Retrive to datastore

3) Getfullstate()

4) SetChanges()

5) Update()

6) Disconnect

7) Retrieve()
Workaround Description
 make sure you are connected when you attempt a retrieve().



CR:173144
CR Number:   173144
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 469 31 Oct 2002 Fixed
Description
Displaying multiple datawindow plugins cause Browsers(IE 4.0,NS 4.04) to crash after exiting. On Win NT 4.0 machines, exiting NS Communicator 4.04 would receive DDE server Window error: The instruction at 0x77b45a1 reference memory at 0x11667db0. The memory could not be "read". On Win 95, IE 4.0 3110.8 it would gpf with error message ole32.dll



CR:173161
CR Number:   173161
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.x Catalina 1002 08 Apr 1999 Fixed
Description
When column visibility is toggled in script, horizontal scrolling is affected. The horizontal scrollbar continues to scroll beyond the width of the visible columns if the arrow on the scrollbar is used. When the thumbwheel is dragged to the end it 'pops' back to the center but the edge of the dw is still visible. Sample is a grid style dw.



CR:173173
CR Number:   173173
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   7.0.00 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Apr 2001 Fixed
Description
New datawindow wizard, on the "Select Color and Border Settings" page, the icons in the dropdown selection boxes are distorted on Win98 and Win95. Display is okay on NT and Win2000.



CR:173204
CR Number:   173204
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Printing a document containing a BMP with the FaxMan OCX results in a GPF

PowerBuilder will GPF at the PrintStart event if the document contains a BMP image. If the BMP is removed, then there are no problems.

I get the same GPF with every version of PB I use: Kernel32.dll at 0137 : bff72978



CR:173229
CR Number:   173229
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)
7.0.00 2223 27 Oct 1998 Fixed
Description
MS Internet Explorer 4.72.2106.8 and 4.72.3110.8. Several events with input args are never triggered (expl. "DocumentComplete").The same control works with Visual C++ and VB.



CR:173233
CR Number:   173233
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 523 03 Feb 1999 Fixed
Description
Describes do not work using PB Oracle native drivers when a table is accessed using a fully qualified private synonym and the user is not the owner of the private synonym. This makes it impossible to create datawinows or accessdata in the DB painter.
Workaround Description
 Using public synonyms avoids this problem but this is not a viable solution for the customer that opened the original case.



CR:173238
CR Number:   173238
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
When changing focus from dw editfield to treeview the losefocus() and the userevent with the accepttext() is triggerd after the selectionchanging() and selectionchanged() event of the treeview where the update and retrieve for the the dw is done. This causes a datalost in the datawindow. when you have a dw and you are in editfield and do modifications and then when the you click with a mouse to a other control you have to use the accepttext function
in a posted user event which you call from the losefocus event.
when you have a treeview control and click with the mouse on it first the selectioncanging() and then the selechtionchanged() event is triggered of the treeview,
after this the losefocus() event of the dw is triggered and then the getfocus() of the treeview is triggered.
BUT the order should be losefocus() of the dw then the getfocus() , selectionchanging() and selectionchanged() event of the treeview should be trggered.
When you like to retrieve data in a datawindow by clicking on a treeview item you'll loose data when the order of the events is mixed.


Workaround:
in the selectioncanging() event of the treeview you can specify:

if dw_1.accepttext()=-1 then
dw_1.setfocus ()
return 1 //to prevent the selection for changing
end if
Workaround Description
 in the selectioncanging() event of the treeview you can specify:

if dw_1.accepttext()=-1 then
dw_1.setfocus ()
return 1 //to prevent the selection for changing
end if



CR:173363
CR Number:   173363
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.00 08 Apr 1999 Presently Not Targeted For Any Future Release Of This Product
Description
MSS SQL Server native driver. If you have a datwindow wiuth retrieveasneeded turned on, a number of iterations of retrieveing teh datawindow will cause a retrieve error.
Workaround Description
 Upgrade to PB 6 or turn off retrieveasneeded.



CR:173374
CR Number:   173374
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 471 16 Dec 1998 Fixed
Description
RetrieveRow event occasionally returns 0 in the row argument while retrieving. This does not seem to be a regression although it's a very bad behavior. This makes it unreliable in calculations, etc in that event.



CR:173378
CR Number:   173378
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 15 Dec 1998 Not reproducible with latest version of the product available as of Resolution Date
Description
UseFormat vs Editmask not painting properly when col loses focus via click: tabbing through the column works okay, but there are other problems as described below.
An edit style of 'Editmask' will (should) take precedence over a specified 'format'. In PB 6.0 an option on an 'editmask' is 'UseFormat'. This is supposed to allow the specified format (on the format tab) to be used when an item is not being edited while still using the specified editmask when actually editing.

The problem is that the format is not always taking effect. If you 'tab' from one field to the other, the format will be used by the item that just lost focus, but if you press the down or up arrow to go to the row below or above you, the editmask stays in effect.

Also, if you scroll the datawindow and it is redrawn, all of the formats take effect as needed, except in the column that has current focus. If this column has the same 'useformat' specified, the entire column will change to look like the editmask.


Workaround: In the customers application the editmask and the format only differed for NULL values. To workaround the problem we added an expression to the 'color' attribute of the column as follows. "if (isnull( clock_in_1 ) and (getrow() <> currentrow()), rgb(255,255,255), 0)"
Since the formats seem to work correctly when going along the same row we only needed to check when the row changed.



CR:173380
CR Number:   173380
Product Name:   PB Enterprise
Product Component:   Inheritance
Status:   Closed
OS:   Microsoft Windows 95
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
- declare a global structure class s_struct
- create uo function which is passed an argument of type s_struct
- override this function in a uo descendant,
If you declare the function arguments (in ancestor and descendant) to be of type s_struct, at runtime the
ancestor function is called, and it is not overridden. If you use powerobject as the datatype for the function arguments instead, then
the function is correctly overridden and the descendant function is called at runtime.

WORKAROUND: Use Powerobject as the function argument datatype



CR:173381
CR Number:   173381
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 16 Dec 1998 Fixed
Description
ResetUpdate() does not reset the delete flag for a secondary ds or dw using Sharedata. This resulting DeletedCount() is incorrect on secondary dw or ds when using ShareData() and ResetUpdate() is explicitly used to clear the flags. The delete buffer itself is cleared but the flag is not. This has been reported as a problem in the past with PFC applications as the PFC Save process manages reseting it's own flags in the Save process using ResetUpdate().
Workaround Description
 Test the DeletedCount() on the primary dw or ds only.



CR:173390
CR Number:   173390
Product Name:   PB Enterprise
Product Component:   UO - Runtime
Status:   Closed
OS:   Solaris 2.5.1
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
When using the start function to fire the timer object, it doesn't fire the first time. Return code is -1. If the same code is added the return code is successful.

uo_timer mytimer
mytimer = create uo_timer
mytimer.start(1.5) (return code is -1)
mytimer.start(1.5) (return code is 1)

Only happens on Sun Solaris. Works on hpux on pb6.5.



CR:173395
CR Number:   173395
Product Name:   PB Enterprise
Product Component:   DW Expression
Status:   Closed
OS:   Microsoft Windows 95
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
Retrieving a composite datawindow which displays a datawindow with a computed field causes a gpf.



CR:173435
CR Number:   173435
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   7.0.00 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 21 Oct 1998 Fixed
Description
Edit mask xx-xx does not show minus sign in control. Also, if you erase data already entered, you will only be able to enter the first two characters.



CR:173447
CR Number:   173447
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Feb 1999 Not a Bug
Description
The TableCriteria dbparm does not require (and in fact does not work) when quotes, either single, double, or two subsequent
single quotes are used. This probably varies from one back end to another. Verified that the quotes do not work using System 10
and SQL Anywhere. I wanted to show only tables starting with emp. So first I tried ''emp%'' (two single quotes on each side) and
got no tables in the list. Then I tried just 'emp%' and I got all of the tables, regardless of how they started. Then I just entered emp%
and then I got only the tables starting with emp.



CR:173462
CR Number:   173462
Product Name:   PB Enterprise
Product Component:   DB Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 RC 4002 16 Dec 1998 Fixed
Description
From the database administrator, type in a sql statement. Execute it. Change printer settings to Landscape. Print the result set. It will print Portrait regardless of the Printsetup change you did.

WORKAROUND: Use a datawindow or report for the result set instead, and that will print fine.



CR:173467
CR Number:   173467
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 474 16 Dec 1998 Fixed
Description
SaveAs using the WMF! (Windows Metafile format) is truncating a long character column unless there are embedded crlf's. After saving in PB trying to insert into Word or VB column is truncated.

Customer has been given a working workaround that does the following:
1 - Copies entire dw column text to a MLE.
2 - Inserts CR/LF at the end of each line.
3 - MLE copied back to DW. Now the WMF file works correctly when inserted into Word.



CR:173476
CR Number:   173476
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
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
Create a group using a column of type time does not group properly in a Powerbuilder datawindow.

WORKAROUND: Add a column which converts the time to string, and group by that column instead.



CR:173508
CR Number:   173508
Product Name:   PB Enterprise
Product Component:   System Runtime Functions
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Mar 1999 Duplicate
Description
The function Double() does not return the correct value when Windows is set to use a comma for decimals in the control panel -> International settings.

For example
Double("1,555")
returns 1 with the above numeric settings in Windows
Double("0,777")
returns 0

No acceptable w/a for this other than use an external dll to perform these conversions



CR:173610
CR Number:   173610
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Mar 2001 Not a Bug
Description
Using dot notation to change a column's value in the filter buffer also changes the original value. This resultsare that the row and columns status flags for the filter buffer are NotModified when it should be DataModified. Similar changes to the Primary Buffer are processed correctly.



CR:173633
CR Number:   173633
Product Name:   PB Enterprise
Product Component:   Printing
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 RC1 5005 02 Feb 1999 Fixed
Description
PrintSetup changes are documented to change the printer for the duration of the session, but when you change to a different
network printer, the change stays in effect after the application (and Powerbuilder) are closed. Note: this may just be a
documentation error.



CR:173640
CR Number:   173640
Product Name:   PB Enterprise
Product Component:   ORCA
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 17 Dec 1998 Fixed
7.0.00 18 Jan 1999 Fixed
Description
Binary information from OLE objects on windows are not being exported when using ORCA and therefore not imported properly. The export and import of windows with OLE Objects work fine from within the Library Painter Export/Import from within Powerbuilder.



CR:173646
CR Number:   173646
Product Name:   PB Enterprise
Product Component:   DW Plugin
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 470 23 Nov 1998 Fixed
Description
Datawindow Plugin GPFs exiting browser after changing print orientation and printing. IE 3.0, 4.0. Netscape 3.0, 4.0.



CR:173665
CR Number:   173665
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 18 Nov 1998 Not reproducible with latest version of the product available as of Resolution Date
Description
In group dw the last page sometimes haven't got a group header or the last row is shown twice on a seperate page.
This causes a page confution and when you scroll up it didn't scroll by page and a group header can shown twice.



CR:173672
CR Number:   173672
Product Name:   PB Enterprise
Product Component:   Rich Text
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Sep 2004 Fixed
Description
Pasting a multiline field with ~n (eg where an address block has been concatenated together) into an RTE control results in only the first line of field appearing - sometimes first two lines appear - very erratic.



An address block which is concatenated together and seperated by carriage return and new line characters. When this is displayed in a datawindow it displays fine, when this is pasted using (PasteRTF) into an RTF control, only the first line of the multiline field is displayed.



The problem is related to string concatenating using carriage return and new line (~r~n). The new line character was tripping up the display in the RTE control, once ~n was removed the datawindow copied across correctly.



CR:173715
CR Number:   173715
Product Name:   PB Enterprise
Product Component:   PB GUI
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
cut & paste don't work when you edit the label of tree or Listview, when menu has ctrl+v /x /c shortcuts.
When you run the MS Explorer you can do that.



CR:173731
CR Number:   173731
Product Name:   PB Enterprise
Product Component:   ORCA
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 11 Jan 1999 Not a Bug
Description
Differences in the size of an object, along with differences in the resulting SQL Update generated in the PBD with an object that has embedded SQL and has been regenerated using ORCA as compared to the object being regenerated within the library painter.



CR:173744
CR Number:   173744
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 Jun 1999 Not a Bug
Description
Customer would like GetFullState / SetFullState to handle dw.zoom in addition to buffer settings.
Workaround Description
 Use a function call to apply the zoom setting



CR:173751
CR Number:   173751
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Dec 2000 Fixed
Description
Performing Enable() on a menu item that is already enabled will return a value of zero. If the item is disabled, the function will return a 1.
The function should be returning either a -1 or a 1. Disable is also not working as documented, although the behavior is slightly different: Disable returns a zero
when successful, or a 1 when the menu item is already disabled, the opposite of Enable, but still not as documented.



CR:173766
CR Number:   173766
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.0.04 13 Nov 1998 Fixed
Description
The European comma decimal separator disappears if backspace is used in an editmask.
This can only be reproduced with a 'foreign' keyboard layout e.g. German, French, Spanish etc.
This can be demonstrated with the following editmask on a window or a DataWindow:

###,##0.00

Populate the editmask with the following value

123.456,78

Place the cursor between 6 and the comma (i.e. 123.456|.78)

If you type in any other number the comma will disappear.

Reproduced with the following versions of PowerBuilder:

PB Version and Build: 5.0.04.76 -----> Fail

6.5.454 --------> Fail

7.0.211 --------> Fail
Workaround Description
 Make sure that the editmask field is NOT filled up.



CR:173768
CR Number:   173768
Product Name:   PB Enterprise
Product Component:   Debugger
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jan 1999 Not reproducible with latest version of the product available as of Resolution Date
Description
If you "clear all" breakpoints in the PB 6.5 debugger, PB will produce an access violation 0xc0000005 0x003e5ef0.

PB Version: 6.0.251 GA -----> OK
6.5.444 ----------> FAIL
6.5.454 ----------> FAIL
7.0.211 ----------> OK
Workaround Description
 As soon as you clear all breakpoints and you see the mouse pointer change to a 'no entry' symbol, left click on the mouse and you are all set.



CR:173780
CR Number:   173780
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.x Catalina 30 Mar 2000 Fixed
Description
Customer has a nested datawindow that retrieves 32768 rows. Powerbuilder gpfs after retrieving the rows in their application. They
sent a test case which gpfs in Powerbuilder, after previewing the datawindow, when the preview view is closed.



CR:173783
CR Number:   173783
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   Microsoft Windows 95
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
Handle(datastorename) returned a valid long as the Windows' handle in 5.0.04. Starting with 6.0.0 (and after) it returns a 0.



CR:173791
CR Number:   173791
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.x Catalina 1025 09 Apr 1999 Fixed
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
Connections to Sybase (SYC) cause memory loss on successive disconnect / connects within the same application.



Per Development:

There is a viable workaround for PB 6.5 and 7.0 (see below), and a new DBParm will be created for PB 7.x (i.e., post PB 7.0) that keeps the database interface DLL mapped into your address space for the duration of the application.



PB 6.5/7.0 workaround:

Reducing Memory Leakage & Improving Performance in PowerBuilder Database Applications



This information documents a powerful PowerBuilder coding technique that can improve performance and reduce the amount of memory leakage that can occur in database applications that connect and disconnect frequently.



Background Information



PowerBuilder苨 database interface DLLs are not loaded automatically when PowerBuilder or a PowerBuilder application is started. Rather, the DBI layer in PBVM60 issues LoadLibraryA("PBSYC60.DLL") each time a CONNECT statement is issued, and a FreeLibrary(hLib) for each DISCONNECT.



LoadLibrary maps the database interface DLL into PowerBuilder's address space and increments its reference count to 1. Because each PowerBuilder's native database interface DLL is linked with the database vendor's client software, often many DLLs get loaded initially. For example, loading PBSYC60.DLL also causes LIBCT.DLL, LIBINTL.DLL, LIBCOMN.DLL, LIBTCL.DLL, LIBCS.DLL, and

NLWNSCK.DLL to be loaded.



If the PowerBuilder application requests a second SYC connection using a second transaction object, another LoadLibrary() call is made. This time, the operating system simply increases the PBSYC60.DLL reference count to 2 because the DLL is already mapped into the application's address space.



DISCONNECT statements in the application cause a FreeLibrary() call to the operating system. FreeLibrary decrements the reference count in PBSYC60.DLL and all of the Open Client DLLs

that SYC is linked with. When the reference count gets to zero, the operating system unmaps PBSYC60 and all of the Open Client DLLs from the application address space.



We have determined that unmapping PBSYC60 and PBDIR60 from the address space cause memory leaks. This is currently under investigation. Meanwhile, a simple Powerscript coding technique will prevent PBSYC60 and the Open Client DLLs from being continually mapped out of the address space. This can be done two ways:

1) Make a call to LoadLibraryA("PBSYC60.DLL") directly from the application.

2) Open a PBSYC60 connection and keep it open for the duration of the application



Implementing Solution One



1) Declare two Local External Functions somewhere:

Function ulong LoadLibraryA(string dllname) Library "kernel32.dll"

Function boolean FreeLibrary(ulong hLibrary) Library "kernel32.dll"

2) Invoke LoadLibraryA when the application opens and FreeLibrary when the application ends

Solution One Example



ulong hLib

long i

long numconnects = 100

boolean bFree

hLib = LoadLibraryA("PBSYC60.DLL")

if NOT IsNull(hLib) then

FOR i = 1 TO numconnects

CONNECT using SQLCA;

...

DISCONNECT using SQLCA;

NEXT

bFree = FreeLibrary(hLib)

end if



Implementing Solution Two



Keeping a second database connection active throughout the duration of the

application also works to limit memory leakage, but solution 1 is far better.



transaction loadtrans // extra connection to keep PBSYC loaded

long i

long numconnects = 100

sqlca.dbms="SYC"

...

loadtrans = CREATE transaction

loadtrans.dbms = sqlca.dbms

loadtrans.dbparm = sqlca.dbparm

...

CONNECT using loadtrans;

if loadtrans.sqlcode = 0 then

FOR i = 1 TO numconnects

CONNECT using SQLCA;

...

DISCONNECT using SQLCA;

NEXT

DISCONNECT using loadtrans;

end if

DESTROY loadtrans



Implications for Other Database Interfaces



Even if the database interface that your application uses does not leak memory, mapping and unmapping the DLLs takes time for each connect and disconnect. If your PowerBuilder application makes repeated connections using the same database interface DLL, you should consider experimenting with technique number one to improve performance.



CR:173810
CR Number:   173810
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 18 Nov 1998 Not a Bug
Description
Using Print Preview, or printing a datawindow which has 2 or more newspaper columns across, as defined under Properties... Print Specifications, the first column ignores the "new page on group break". If a group ends in the first column, a page break does not occur. Instead, the next group is started in the second column of the same page.

PER DEVELOPMENT:
within the DW Engine, newspaper columns are treated as multiple "logical" pages within a "physical" page; the "PageBreak" for groups translates to "logical" pages within a Newspaper environment -- it always has, and until more options and properties are added to the Group Band in some future release, this will not be changed;



CR:173855
CR Number:   173855
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)
6.5.00 31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
A PB OLE automation server with a simple function leaks on Windows NT 4.0



CR:173875
CR Number:   173875
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 95
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
Create crosstab datawindow. Change text of heading of a column, save and close the datawindow. Open datawindow, right click on datawindow, choose Crosstab, then click Okay. The heading text you changed reverts to the old default value rather than the
new text you entered.



CR:173968
CR Number:   173968
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 06 Jan 1999 Fixed
Description
Clicked event of grid datawindow in PB 6.5 does not return the proper row number when one column has autosize height and you click in the white space below the data. PB 6.0 GA always returns the proper row. Clicking on the actual data in the column returns correct row number. Right Clicked event always returns correct row number.



CR:173978
CR Number:   173978
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 533 14 Jan 1999 Fixed
Description
Opening a table in the Database Painter while connected with IN7 Informix driver and Informix client 9.15 2.02.TC2.



CR:174007
CR Number:   174007
Product Name:   PB Enterprise
Product Component:   Menus - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 519 07 Jan 1999 Fixed
Description
NT 4.0 specific problem this works fine on WIN95.

Similar behavior as CR 161807 but this is related to the sheet menu and that CR dealt with the frame menu.

A large menu on a sheet contains many menu options that are visible and invisible. In the example some menu options are made visible at program execution time based on the number of menus requested from the user. The menu options are made visible using a FOR NEXT loop. When the count of options made visible is fairly large(seems to happen in test case around 50), the displayed sheet menu is corrupted, that is, the menu does not display all the normally visible options and/or options made visible at execution time. SOmetimes the menu disappears entirely. In the actual application , when this problem occurs, the menu that are displayed are usually inoperative. By that, I mean that if you click on a menu option, the clicked event programming is not executed. This is not included in the sample as once the menu is painted correctly everything else works fine.
Workaround Description
 Sometimes putting a Yield() before changes corrected the problem.



CR:174011
CR Number:   174011
Product Name:   PB Enterprise
Product Component:   Windu/U
Status:   Closed
OS:   HP-UX 10.20
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
Windu daemons on solaris don't shut down and memory usage goes up for the windu_registry and windu_scm.



CR:174035
CR Number:   174035
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 26 Apr 1999 Fixed
Description
Changes to object functions, cause runtime errors when running in dev mode



CR:174040
CR Number:   174040
Product Name:   PB Enterprise
Product Component:   ORCA
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 11 Jan 1999 Fixed
Description
ORCA does not import or regenerate a proxy object even though the return code indicates that the operation was successful.



CR:174072
CR Number:   174072
Product Name:   PB Enterprise
Product Component:   Generators
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 remote object nvo opens a file in stream mode, reads the file contents into a string and passes the string back. There are 4 test files of varying sizes. There are no problems with this when using a PowerBuilder client. And using a Java client there are no problems when the client running on Windows 95. When the java client is running on NT4.0 SP3, then OutofMemory errors occur on some of the test files.



CR:174100
CR Number:   174100
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   Solaris 2.5.1
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jan 1999 Not a Bug
Description
When updating a blob in informix using odbc on solaris, update will
fail with an error of -458 sqlstate 60 long transaction aborted listed in the pbtrace.log file.
Update blob works with the same bitmap on wintel using the native informix 7 driver.

Client software on solaris is 7.2.4



CR:182102
CR Number:   182102
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 06 Jan 1999 Fixed
Description
In PB 6.5 on a Grid datawindow when a column is made invisible clicking on grid lines or in invisible column results in a Powerbuilder Application Execution Error R0060. Error: Invalid row range at line 3 of clicked event of object....... when trying to return row number clicked on through dot notation.

Right clicking works fine in PB 6.0 GA through build 467 returning correct row number.



CR:182103
CR Number:   182103
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
If you have a DataWindow which has a column that contains the same data values, if you do a sort against this column. You get some unexpected behaviour. The first row becomes the last row, which is the same for windows explorer. If you sort again, the last row becomes the second to last row and the first row becomes the last row, etc. Basically every time you do a sort under these circumstances all rows are being pushed up by one. Windows explorer swaps between the last and first rows.



CR:182178
CR Number:   182178
Product Name:   PB Enterprise
Product Component:   Rich Text
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
Enhancement Request: An RTE control which is set to DisplayOnly should allow the user to select text (to e.g. copy it to the clipboard) like in an multiline edit control



CR:182189
CR Number:   182189
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 483 16 Dec 1998 Fixed
Description
6.5 Regression - DataWindow has nested report with a retrieval argument. When previewing the datawindow, the first row in the datawindow displays fine along with the set of rows in the nested report associated with the retrieval arg, in this case cust_id. The remaining set of rows in the nested report display no data for 2 out of 3 columns in 6.5 (build 444). In 6.5 build 454 & 467 there is garbage in 2 out of the 3 columns.



CR:182203
CR Number:   182203
Product Name:   PB Enterprise
Product Component:   Automation
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 489 04 Dec 1998 Fixed
Description
Using OLE automation to Word 7 & 8 with word.basic syntax and not VBA.

When running with WORD 8:
Sample works in PB 5.0.03 with this syntax.
In PB 5.0.04 on second iteration receive a -2 return code from PB ConnectToNewObject.
In PB 6.0/6.5 sample appears to work for two iterations but on the third it generates an invalid page fault in PBVM60.dll at 0137:112a234b.

When running with Word 95:
Sample runs successfully with both PB 5.0.03 and 5.0.04.
In PB 6.0/6.5 the line of code ole1.FileClose( 2, AsStatement! ) results in an Error: Invalid Parameter type calling external object function fileclose, PB window ot menu w_ole_sample, object-cb_1, Script -clicked, Errorline -70. It proceeds and does not page fault as long as you close out of Word 95 manually.



CR:182204
CR Number:   182204
Product Name:   PB Enterprise
Product Component:   Project Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   7.0.00 Beta 2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 1998 Fixed
Description
You cannot toggle the machine code check box off and on in the Project Painter.



CR:182205
CR Number:   182205
Product Name:   PB Enterprise
Product Component:   Project Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   7.0.00 Beta 2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 1998 Fixed
Description
The application Painter still shows an entry for 16 bit in the Executable format dropdown list even though 16 bit is no longer supported.



CR:182363
CR Number:   182363
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)
15 Dec 1998 Duplicate
Description
Executing datawindow setsort function result in a memory leak
Workaround Description
 string ls
setnull (ls)
dw_1.Object.DataWindow.Table.Sort=ls
ls = "col_1 A"
dw.setsort (ls)



CR:182376
CR Number:   182376
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 18 Nov 1998 Not a Bug
Description
If you have a groupbox in a datawindow with it's layered position property set to foreground or background, then only one groupbox will be displayed in preview mode or at runtime. If the layered position property is set to band, then there are no problems.

Reproduced with 32 bit PB:

6.0
6.5
6.5 EBF01
6.5 EBF02 pre-release build 477
7.0 EA Studio Build 900
7.0 build 2221
Workaround Description
 Set layer propery to "band" instead of foreground or background.



CR:182424
CR Number:   182424
Product Name:   PB Enterprise
Product Component:   Toolbar
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 RC0 5010 01 Feb 1999 Fixed
Description
Toolbar icons do NOT redraw if mouse pointer is placed on the icon. If you have an MDI application which has two sheets, and both sheets have toolbar icons associated with them. If you switch between the sheets by CTRL & Tabbing, if your mouse pointer was on a sheet icon, then it would not be redrawn. The icon will stay under the mouse pointer unless you switched to the same sheet twice.

This problem can be demonstrated with all builds of PowerBuilder 6.0 including the latest build I have access to PB 6.5 EBF02 477, this problem cannot be reproduced with PowerBuilder 7.0



CR:182527
CR Number:   182527
Product Name:   PB Enterprise
Product Component:   DB Other
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   7.0.00 Beta 2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 5007 15 Dec 2000 Presently Not Targeted For Any Future Release Of This Product
Description
ISUG Enhancement Request e15_067:



Enhancement Request to allow PB to connect to Adaptive Server Anywhere using the SYC native driver (or introduce a new native driver for ASA) instead of using ODBC.



Per PB Product Management, this is not to be fixed:

PB Product Management has confirmed that there are no plans to do this now or in the future.

See Tech Doc 1011154 "Notice From Sybase: PowerBuilder Connectivity to Adaptive Server Anywhere" in the Technical Documents section of Support on MySybase.
Review Status
 Reviewed by PB Engineering - ISUG Rating:

"N" No Plans.



CR:182535
CR Number:   182535
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 13 Nov 1998 Fixed
Description
An edit mask with the format "dd-mmm-yyyy" does not allow you to enter 31-jul-1998. It only accept JAN as the month.



CR:182537
CR Number:   182537
Product Name:   PB Enterprise
Product Component:   DB Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 448 09 Nov 1998 Fixed
Description
In the BD Admin painter, a Commit statement must have a space preceding the trailing semi-colon.



CR:182539
CR Number:   182539
Product Name:   PB Enterprise
Product Component:   DW DDDW
Status:   Closed
OS:   Microsoft Windows 95
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
Scrolling thru a dddw and then hitting the Enter Key does not select the correct value.
If the mouse is used or the Tab key is used after scrolling, the correct value is selected.

WORKAROUND: In the sample taken from the PB Examples there was script in events that was firing when the Enter key was pressed that was re-retrieving when the rowfocuschanged. I was able to take the sample submitted and prevent this re-retrieval from occurring and thus have it behaves similar to when the mouse was used by creating a user event mapped to pbm_dwnkey. If it was the enter key that was pressed then to set a flag and then test the flag prior to having the re-retrieval take place.
Workaround Description
 Use mouse to select from the DDDW.



CR:182546
CR Number:   182546
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 1998 Not reproducible with latest version of the product available as of Resolution Date
Description
ListView with View property set to ListViewList! and with the item label text so long that it does not fit in the listview causes a horizontal scrollbar to appear. If you click on one of the truncated item labels it causes the listview to scroll to the right so nothing is visible in the treeview.

Doubleclicking on such an item with its label is truncated provokes a doubleclicked event with an argument index -1.
See workaround tab for w/a
Workaround Description
 Declare user event "Ue_postclick" in ListView
ListView Clicked event

this.SetRedraw(false)
This.view = ListViewReport!
this.PostEvent("ue_postclick")

in the user event code...

This.view = ListViewlist!
this.SetRedraw(true)



CR:182566
CR Number:   182566
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.x Catalina 1142 30 Dec 1999 Fixed
Description
In PB 6.5 and 7.0 build 216 select statements on Informix tables with SERIAL data types fail when using ODBC driver.
Workaround Description
 Use native Informix driver or change the SPECIALDATATYPES section in the PBODB60.ini file as follows:

[INFORMIX_SPECIALDATATYPES]
SpecialDataTypes='MONEY=DBI_TYPEMONEY=100,SERIAL=DBI_LONG=101'



CR:182618
CR Number:   182618
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Dec 1998 Fixed
Description
The SLE to specify a mask for an edit mask in a DW is missing.

Reproduced with PowerBuilder 7.0 Build 900 (EA Studio Beta 1), this is fine with Builds 211 and 2221 of PowerBuilder 7.0



CR:182630
CR Number:   182630
Product Name:   PB Enterprise
Product Component:   DB Informix
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 506 03 Dec 1998 Not reproducible with latest version of the product available as of Resolution Date
Description
'Select error' if a join is made between an Informix serial column and a non-serial column and neither of these 2 columns are included in the Select clause.
If we include either of the 2 join columns in the select clause it works fine.

For example this gives a Select Error ...
SELECT systables.tabname,
syscolumns.colname
FROM syscolumns,
systables
WHERE ( syscolumns.tabid = systables.tabid ) ;

and this does not (serial col is included in Select)...

SELECT systables.tabname,
syscolumns.colname
systables.tabid
FROM syscolumns,
systables
WHERE ( syscolumns.tabid = systables.tabid ) ;

See workaround tab for a simple workaround
Workaround Description
 Include the serial column in any such embedded SQL or datawindows but do not use it (in dw make the col invisible)



CR:182635
CR Number:   182635
Product Name:   PB Enterprise
Product Component:   MAPI
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 512 11 Jan 1999 Fixed
Description
Making repetative calls to MailLogon() and MailLogoff() within the same mail session with maildownload! option results in GPF after running out of virtual memory.



CR:182663
CR Number:   182663
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   7.0.00 Beta 2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 Beta 3 3234 04 Nov 1998 Fixed
Description
You cannot use the arrow keys to move command buttons in the Window Painter
Workaround Description
 Use the mouse to move objects in the window painter.



CR:182757
CR Number:   182757
Product Name:   PB Enterprise
Product Component:   Menus - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Dec 1998 Not a Bug
Description
PB 6.X regression

Clicked event for menu is firing although the mouse has not been clicked. This is happening when the cursor has been moved over the icon.



CR:182773
CR Number:   182773
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   7.0.00 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Dec 1998 Fixed
Description
Using the SetPicture() on a Picture Control to display a GIF file fails with a -1 return code. Works on BMPs.

According to PB 7.0 documentation:
PowerBuilder 7 adds support for GIF or JPEG images in all controls that support bitmaps. Picture and PictureButton controls also support animated GIF images.



CR:182812
CR Number:   182812
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 520 30 Dec 1998 Fixed
Description
PBIN7050.dll Informix Server side Memory Leak.

When executing a stored procedure that returns a result set the memory being used by the cursor on the server side is not being released. The only way the memory is released is if a disconnect is done.



CR:182835
CR Number:   182835
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Feb 2004 Presently Not Targeted For Any Future Release Of This Product
Description
The dw.Find() function doesn't work with comma as decimal separator.

for example dw_1.Find ("salary = 48023,69") gives "Invalid expression".





Workaround:

use dw.Find ("string (salary) = ' 48023,69' ")



CR:182837
CR Number:   182837
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)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
ENHANCEMENT: SYC driver should allow connect with SYC when default database is unavailable.



CR:182838
CR Number:   182838
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)
7.0.00 RC2 5020 19 Feb 1999 Fixed
Description
If you have a composite datawindow and you try to assign the data values dynamically to a datastore using dot notation. This will fail with PowerBuilder 6.5 and 7.0, you will get the following error message.

PowerBuilder Application Runtime Error (R0039)
Application terminated
Error: Error accessing external object property object at line xx in clicked event of object xxx of xxx.

The following line of script causes the problem:

lds_mydatastore.object.department1.object.data = dw_1.object.data

The script above works fine with PowerBuilder 6.0 GA build 251.



CR:182841
CR Number:   182841
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 Beta 3 3257 08 Dec 1998 Not reproducible with latest version of the product available as of Resolution Date
Description
Selecting Items in a listview with CTL + LeftShift + LeftMouse click doesn't work. It deselects previous selection.
It should work as the MS listview in the Explorer.



CR:182915
CR Number:   182915
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 19 Mar 1999 Not a Bug
Description
Regression. Cannot Tab inside MLE control when MLE control is in a sheet and cannot Set Tabstops in an MLE control at runtime





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

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

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

ReadASADB适用场景

各种误操作:

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

本工具的应用场景:

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