远程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:158312
CR Number:   158312
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Problem with Excel embedded in an Ole object. The save event in the OLE control never fires if using Excel--Office 97. This works with earlier versions of excel.



This works in 5.0.04_76 & 6.0



CR:158316
CR Number:   158316
Product Name:   PB Enterprise
Product Component:   Edit Mask
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
In the Hebrew 32-bit version, running under Hebrew enabled Win95, Alt+Shift and Ctrl+Shift work to change the keboard and orientation in an EditMask on a window. Running Arabic 32-bit under Arabic enabled, it only works to change from Arabic to English. If you are in English it will not change to Arabic.



CR:158321
CR Number:   158321
Product Name:   PB Enterprise
Product Component:   ORCA
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Orca problem with Import directive contained in a PB Comment. When he has the following in script, he gets compiler errors. Recreate in any application script:

/*

//*

*/



This is a problem for the customer because of Orca. The Orca import //*, when enclosed in a comment block, causes the compile entry import function to hang.



Errors:

C0035 Unclosed Comment and C0031 Syntax Error.



Workaround: Go through the file and globally replace any '//*' with, '// *'.



CR:158329
CR Number:   158329
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 5010 01 Feb 1999 Fixed
Description
Problem: Export to Syntax for MS SQL server does not separate multiple constraints with commas. This causes an error when export file is executed.



CR:158332
CR Number:   158332
Product Name:   PB Enterprise
Product Component:   DW - Runtime
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
Unable to use the Primary key word when referencing the Selected property of a datawindow object.



Error: "Error accessing external property selected at line 'x' in 'y' event of object 'z' "



Workaround:

Since the dot notation defaults to the Primary buffer, the workaround is to omit the keyword:



i.e.

DO NOT use dw_1.object.columnname.primary.selected, but



dw_1.object.columnname.selected

or

dw_1.object.columnname.current.selected



CR:158335
CR Number:   158335
Product Name:   PB Enterprise
Product Component:   DPB
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
When opening named pipes over network limit is 17.





PER DEVELOPMENT:

This is not a bug.

The limitation is established by a configurable registry parameter which defaults to 17.

The Registry value is as follows:

HKEY_LOCAL_MACHINE

\SYSTEM\CurrentControlSet\Services\Lanmanworkstation\parametersMaxThreads

Add this parameter in the registry and set = to desired limitation.

Tested this on 2 client machines and it fixed it on both.



CR:158341
CR Number:   158341
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Script painter "paste" dropdowns (for Select Event, Paste Global, Paste Instance, Paste Argument, Paste Object..). There is no horizontal scrollbar in any of the "Paste...." dropdowns making it difficult to work with PFC and it's long names in, for instance, the "Paste Instance" dropdown.





PER DEVELOPMENT: No plans to address this issue. Future releases may make this obsolete.



CR:158357
CR Number:   158357
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ISUG Enhancement Request e15_053:



Allow AutoSize on bands other than detail. Often it is desirable to use the detail band only for summarizing data and it is never displayed. The actual data is displayed in group footers with totals. If the data is a large variable text, there is no way to adjust the height of that band.
Review Status
 Reviewed by PB Engineering - ISUG Rating:

"U" Under consideration.



CR:158360
CR Number:   158360
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
The dbparm dbtextlimit cannot have single quotes around the value to make a successful connection. This is contrary to documentation.



CR:158366
CR Number:   158366
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)
17 Apr 1998 Fixed
Description
*** 5.0.03 Regression *** R0039 error. Error accessing external object property object at line xx in function xxxx of object xxxxx. Cannot access a column name (or an attribute like HTMLTable) in a nested DataWindow via dot notation.



CR:158380
CR Number:   158380
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
5.0.04 PBEOL050 CheckIn for Object Cycle interface allows optional version label assignment. If label is already associated with a previous revision of the object, SMS_CheckIn returns FAILURE. However, object really was checked in successfully. This puts PB and ObjectCycle statuses out of sync.



CR:158383
CR Number:   158383
Product Name:   PB Enterprise
Product Component:   Edit Mask
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
Window editmask control modified events. If you programmatically change an editmask,



em_1.text = "0"



the modified event doesn't fire until you put focus on an editmask then force a losefocus by way of clicking or tabbing.



The documentation states:



Modified event doc:

When a control has been changed AND loses focus (becomes inactive).



This makes it harder to change data in a window editmask programmatically since the modified event will fire sometimes when you don't expect.



CR:158388
CR Number:   158388
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
When you go into the properties of a response window and check maximize, minimize, resize and control menu. These properties are not used in runtime.



CR:158392
CR Number:   158392
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Win 3.11 only

16 bit only {pb 5.0, 5.0.02_11,pb 5.0.03_35, pb 5.0.03_41}



Keywords:: Rich text edit control,, bad display text format, copyRTF



Problem description::



This is win 3.11 only. both 16 and 32 bit PB on win 95 or win nt 4.0 have no problems.



Customer is using a RTE control. He retrieves a column from the database that has all of the rich text formatting codes. A single quote or ** appear in the display of the RTE . If you check the text right after retrieving, there is no single quote or **.



It is only when you issue a copyRTF that the problem occurs.



Happens in development and in run time also.



CR:158398
CR Number:   158398
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Solaris 2.5.1
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Oct 1998 Not a Bug
Description
Problem Description: When migrating from pb 4.0 to 5.0 a wrapping effect is caused from printpreview to the next page



It appears that PB 5 calculates the 1/1000th inch differently than version 4. Creating a dw on version 4 and migrating to 5, the paper size goes from 8.5" wide to only 8". This is causing pages to wrap.



CR:158402
CR Number:   158402
Product Name:   PB Enterprise
Product Component:   P-Code Deployment
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
***** 5.0.03 Regression ****** 16 & 32bit PowerBuilder

There seems to be a difference in PBRTE050.DLL in the deployment kit vs. \sys32 or \sys (dev) directory. The dll in \pb5i32\dk in some cases will cause a page fault in PBSHR050.DLL@0173:1111198e.



PER DEVELOPMENT:

New deployment kits available on ftp site.

Files: 503dk16.zip and 503dk32.zip.



CR:158409
CR Number:   158409
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 11 Nov 1998 Not reproducible with latest version of the product available as of Resolution Date
Description
Using SetSeriesStyle syntax 3 (to specify the properties for data markers in a series) on the second embedded graph control in a data window cause a gpf in pbrte050.dll at 0137:10b35074. The setseriesstyle is called in the pbm_dwngraphcreate just as the documentation for setseriesstyle() mentions.



Moving the code out of the pbm_dwngraphcreate event gets rid of the GPF.



6.0.00 and 6.0.01 work fine.



CR:158411
CR Number:   158411
Product Name:   PB Enterprise
Product Component:   Language - Compiler
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Dec 2000 Fixed
Description
Function Painter Does not compile on save or exit when a function argument of a user defined object type (structure, window) is not in the library search path. Access violation.



CR:158415
CR Number:   158415
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2000 Not reproducible with latest version of the product available as of Resolution Date
Description
Regression - Importfile and ImportString functions have a memory leak. PB5.0.0 and 5.0.01 worked fine



CR:158418
CR Number:   158418
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)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
The coltype property on a numeric column in a crosstab datawindow returns character when accessed from the RetrieveRow event. It is correct from the RetrieveStart and RetrieveEnd events.



CR:158423
CR Number:   158423
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Solaris 2.5
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 RC 4000 31 Oct 2002 Fixed
Description
Solaris web.pb and distributed PowerBuilder - calling a server print function from a distributed client does not work. Either gets a segmentation fault or just doesn't create anything. If you call the print function on the server, it works.



Customer has coded some print functions on the Server app. When called from the Server, these print functions work fine. However, when these Server print functions are called from the Client, they fail.



CR:158425
CR Number:   158425
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 212 16 Dec 1998 Fixed
Description
In powerscript, if you use describe() together with evaluate pagecount, you'll get a GPF if a group is defined, and the property 'reset page number on group break' is set to true.



CR:158443
CR Number:   158443
Product Name:   PB Enterprise
Product Component:   Machine Code Deployment
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
**** 5.0.03 Regression ****

Using "ShowHelp ("help file",Topic!,topicnum)" fired from command button. Works in development and p-code but not in machine code executable...Error displayed:

"Topic does not exist, contact your application vendor for an updated help file (129)"



CR:158445
CR Number:   158445
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Dec 1998 Not a Bug
Description
A CrossTab datawindow - at run time calls CrossTabDialog() function, brings up CrossTab Definition window, click OK. It brings up the datawindow, but there is no data in it.

(This worked in PB 4.0.0x)



Workaround: Retrieve data first using Retrieve(), then call CrossTabDialog() function.



CR:158448
CR Number:   158448
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 EBF1 6007 27 May 1999 Fixed
6.5.00 620 05 Aug 1999 Fixed
Description
MS SQL Server 6.5. Customer has a text field in database. If data in field is more than 4K, error msg: "Data conversion resulted in overflow." textsize on the database is large over 32k, and they are using the dbtextlimit dbparm. I checked the db @@textsize value and it is > 32k



CR:158449
CR Number:   158449
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)
7.0.00 15 Apr 1999 Fixed
Description
RButtonDown event of datawindow control - xpos, ypos arguments are in pixels although they are documented as returning PBUs.



CR:158451
CR Number:   158451
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Dec 1998 Presently Not Targeted For Any Future Release Of This Product
Description
If you call an Informix stored procedure using an RPC call. Error 0232 will occur if there are character arguments.



CR:158458
CR Number:   158458
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)
17 Apr 1998 Fixed
Description
displaying a computed field on a label-style DataWindow, causes a GPF



CR:158480
CR Number:   158480
Product Name:   PB Enterprise
Product Component:   Debugger
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
ISUG Enhancement Request e15_055:



Back in version 5 you were able to run your app with the Debugger and utilize Ctrl-S to step through each line. Now you have to use the mouse to click on a toolbar icon. I know it can't be that hard to bring back this nice time-saving feature.
Review Status
 Reviewed by PB Engineering - ISUG Rating:

"C" in Current products.



CR:158485
CR Number:   158485
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
When a treeview has a horizontal scroll bar; when you move the scroll the bar so that the squares that expand and collapse the treeview are hidden and double click a level item to collapse it, the scroll bar disappears but the the treeview does not shift to the right and the squares remain hidden. (5.0 only)



CR:158486
CR Number:   158486
Product Name:   PB Enterprise
Product Component:   DPB
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description



CR:158491
CR Number:   158491
Product Name:   PB Enterprise
Product Component:   DW - Runtime
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
In a dw which uses HorizontalScrollSplit to split the screen in two, wants ability to set focus on a column in the right-hand side of the dw.



CR:158495
CR Number:   158495
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Solaris 2.5.1
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Nov 1998 Not a Bug
Description
The ALT key is ignored if held down when choosing menu items.



CR:158496
CR Number:   158496
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)
17 Apr 1998 Fixed
Description
The api function globalMemoryStatus doesn't work well with NT 4



PER DEVELOPMENT: If you try calling this from a C program you get the same results. This is not a PowerBuilder bug.



CR:158503
CR Number:   158503
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Metafile in inverse mode bleeds beyond the borders of the picture control on a datawindow object. Inverts fine in Paintshop pro.



CR:158522
CR Number:   158522
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.00 31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Unable to nest transaction in a SQL Anywhere database with database chained mode OFF and Powerbuilder AutoCommit set to true. However this works properly with the Sybase Adaptive Server ODBC Driver



Workaround:

Create a separate transaction object with AutoCommit=OFF and use this one to handle transaction processing.



CR:158523
CR Number:   158523
Product Name:   PB Enterprise
Product Component:   Library Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Source Control --> ObjectCycle 2.0

User has been set up as with the Role of a user and can clear the registration of an object even though a message is given stating that 'User does not have permission to invoke function cDeleteObject'



CR:158526
CR Number:   158526
Product Name:   PB Enterprise
Product Component:   UO - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
PB 504 when a userobject is opened on a window using the OpenUserObject() Function, the constructor event does not fire.



Developer: Already fixed earlier in 6.0



CR:158555
CR Number:   158555
Product Name:   PB Enterprise
Product Component:   DW Painter
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 17 Apr 1998 Fixed
Description
DataWindow numeric EditMask issue; the cursor goes one position too far after hitting the decimal point.



971104 SLIE - Not reproducible with US settings. Can use Norwegian, Swedish or German settings to reproduce, where comma is used as decimal separator.



CR:158570
CR Number:   158570
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)
17 Apr 1998 Fixed
Description
Clear() function does not clear out the oleobject from an OLE control

- does not occur under 5.0.04_71, 6.0.01_339



CR:158595
CR Number:   158595
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Aug 2004 Not reproducible with latest version of the product available as of Resolution Date
Description
For Oracle stored procedure with date parameter PB uses default date format 'DD-MON-YYYY' - When NLS_LANG set it causes error ORA-01843 not a valid month (month abbreviations are different in other languages).



CR:158597
CR Number:   158597
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 17 Apr 1998 Fixed
Description
Problem with datawindow columns with an editstyle of editmask [currency(xx)]. If you enter some digits and the tab off (or click elswhere), the column loses the leading digit. Problem happens in German(standard) and French(standard) Regional Settings.



CR:158620
CR Number:   158620
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)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
GPF when using Disconnect in DBERROR event of the datawindow and there is a database error such as "invalid column".



In 16 bit, the GPF is in PBSYC050.DLL @ 0003:39ce (5.0.03) and in 0003:3a9e (5.0.04.70) and PBVM60W.DLL @ 001B:17ae in 6.0.01 build 314.



Workaround: Use Postevent from the DBerror to do the disconnect.



CR:158628
CR Number:   158628
Product Name:   PB Enterprise
Product Component:   DB DB2
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
16 and 32 bit Net Gateway gives 'Data Conversion Resulted in Overflow' when building a datawindow from a view and returning to design mode from the SQL Painter.



CR:158640
CR Number:   158640
Product Name:   PB Enterprise
Product Component:   DW - Runtime
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
Customer gets back ' garbage ' data when previewing a datawindow in a certain column only. If you only include one column in the columns definition of the crosstab, then this error will occur.
Workaround Description
 Use more than one column in the column definition of the crosstab ( see page 728 of Powerbuilder users guide ) for an example. Or, per Development, make the cross-tab dynamic or ensure that the data doesn't change out from under us.



CR:158642
CR Number:   158642
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Win 95, Win NT 4.0

32 bit only {pb 5.0, 5.0.02_11, 5.0.03_35, 5.0.04_41}



Keywords:: NVO , bad resource performance, create,destroy



Problem description::



Customer creates and destroys a matrix of NVO's and the performance is effected as a result. I tried this out using 2 NVO's. I found the following result as the customer and the TSE



# of nvuo CREATE (sec) DESTROY (sec)

1 1 1

2 3 4



You cannot run this app in 16 bit mode on any platform as you will result in a gpf in pbshr050.dll.



Checked with resource monitor on NT 4.0 , and there is no major memory loss. All memory is freed up when you stop the application.



In powerbuilder 4.0.07 there is no memory loss.



SOLUTION:

This is as designed in all PB versions 5.0 and later. When you declare a static array we must initialize all elements of the array. In 4.0 the initialization would be done the first time you access each element of the array. Therefore in 4.0 you pay the price throughout your app where in 5.0 you pay for it up front. Use dynamic arrays to get around this.



CR:158649
CR Number:   158649
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
The editmask autoskip feature works incorreclty when the last character entered in to the editmask is upper case. It should tab to the next control, but instead, it tabs to the previous control.



CR:158651
CR Number:   158651
Product Name:   PB Enterprise
Product Component:   System Runtime Functions
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Dec 2000 Fixed
Description
Isdate() returns true with some strange combinations of slashes.



1997/////-...8///-13



CR:158655
CR Number:   158655
Product Name:   PB Enterprise
Product Component:   SQL Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Deficiency. SQL Painter for Script - INSERT, UPDATE icons for adding embedded SQL. SQL Painter allows you to paste columns into script that won't satisfy "not null" field requirements (ie required fields).



CR:158660
CR Number:   158660
Product Name:   PB Enterprise
Product Component:   Profile Painter
Status:   Closed
OS:   Solaris 2.5.1
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Security Enhancement for InfoMaker/Powerbuilder. The pb.ini or im.ini file (.pb.ini file in Solaris) stores the username/password to connect to the database. This can potentially create a security risk.

Possible workarounds:
Don't create the profile with username/password. Users must log in each time. You can set the pb.ini to read-only but this causes other problems (better with InfoMaker).



CR:158676
CR Number:   158676
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Rich Text Datawinw (RTF DW) Importing a file into RTF apostrophies

are lost. Copying and pasting in and out of RTF, fonts and styles are also lost or do not appear.



CR:158679
CR Number:   158679
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Problem description:: Datastore issue. When assigning a dw object to datastore, if dw object has edit styles on columns, gets gpf. Pbshr050.dll at 0009:000024fb.



This issue has beentested in both win 95 and win nt 4.0 . Pb 5.0.04 build 54 fixes this problem.



Note when running the debugger you will see the dataobject been assigned to the datastore but will result in a gpf in pbrte050.dll. If you apply the above dlls the problem will not occur.



CR:158683
CR Number:   158683
Product Name:   PB Enterprise
Product Component:   DB Sybase System
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
R1039 type mismatch accessing external object property "data" if a timestamp column is being copied using



dw_1.object.data=dw_2.object.data



CR:158691
CR Number:   158691
Product Name:   PB Enterprise
Product Component:   Debugger
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 17 Apr 1998 Fixed
Description
In the Debugger, using PFC as an example, if you expand the user objects list, find pfc_n_cst_tvsrv_datasource and expand it. Then, select the of_setleveldata function (3rd from bottom of overloaded functions, the one with all the arguments). Doubleclick on it to open it in the source code window and get a GPF. The user cannot set a breakpoint.



Development: Fixed around 6.0.01 build 360 with other debugger fixes.



CR:158693
CR Number:   158693
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
ODBC leak in runtime executables with connect/disconnect. Worst with server executables (either Web.pb or distributed).



CR:158697
CR Number:   158697
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)
17 Apr 1998 Fixed
Description
*** 5.0.02 Regression *** Still broken in 5.0.4_67

Footer band of composite report overlays the trailer band of a child report if it's at the bottom of a page.



CR:158702
CR Number:   158702
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)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Enhancement Request: Correct GUI for Checkboxes and radiobuttons in DW

Can we PLEASE have a property to control the background colour of 3D checkbox and radiobutton edit styles in datawindows so we can provide the user with the proper visual cues when columns of this type are readonly or disabled. (see checkbox and radiobutton window controls.) If the datawindow is the preferred interface control then we should have at least the same functionality as the window control provides by version 6.

This behavior would have to include the protect = 1 or taborder = 0 attribute effectively showing the "disabled" look as well.



CR:158703
CR Number:   158703
Product Name:   PB Enterprise
Product Component:   DW Expression
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
Crosstabsum() or crosstabavg() in a crosstab datawindow GPFs when building the crosstab. Although the documentation shows a correct format with one column:



CrosstabSum(1, 2, "@year")



the customer is using several columns but it shouldn't GPF



CR:158725
CR Number:   158725
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 22 Jun 1999 Fixed
Description
PFC sorting on column headers using of_setcolumnnamesource(2) doesn't seem to work on columns added after the datawindow was originally saved. Clicking on the headers - inserted by the user - associated with the new column(s) don't work.



This is not a bug..



With any newly added columns to a tabular or grid datawindow, you should place a static text above the column in the header band. The problem is: this static text representing the header has NO "name" attribute and that's what makes the sorting on headers work.



When a datawindow is newly created, any columns automatically get headers (grid, tabular) with the name <columnname>_t as their "name" attribute.



Ex:



1. "dept_head_id" column is added after the datawindow was originally created.

2. A static text placed above "dept_head_id" was typed in as "Department Head ID".



This static text has no "name" attribute - it's NULL - and that's what the of_setcolumnnamesource(2) uses. The naming convention would be:



<columnname>_t



Name attribute: dept_head_id_t << name of the static text in header associated with dept_head_id



Text attribute: "Department Head ID" or anything you want



CR:158727
CR Number:   158727
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)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Enhancement. GenerateHTMLForm function should process columns with DDDW edit style



CR:158729
CR Number:   158729
Product Name:   PB Enterprise
Product Component:   Printing
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Oct 1998 Presently Not Targeted For Any Future Release Of This Product
Description
Windows 3.11. dw_1.print() to show the cancel dialog doesn't work with 16 bit under WFW 3.11. dw_.1.print() should default to "TRUE".



ex: dw_1.print(true)



Workaround: Use dw_1.print(true). You must explicity set the flag to get the cancel dialog. OK on other platforms.



CR:158731
CR Number:   158731
Product Name:   PB Enterprise
Product Component:   Library Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
16 bit PB. GPF in pblib050.dll when doing an export and then an import of certain objects (from 3rd party vendor, FileMark) in the library painter. These gpfs did not occur when using PB 5.0 or 5.0.01.



GPF in pblib050.dll when you try to import the exported file.



5.0.02 - pblib050.dll @ 0000058c

5.0.03 - pblib050.dll @ 00000416

5.0.04_48 pblib050.dll @ 0000058c



CR:158736
CR Number:   158736
Product Name:   PB Enterprise
Product Component:   Table Painter
Status:   Closed
OS:   Solaris 2.5.1
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
PBMotif 6.0 build 189: Foreign Key name assigned by user is not

preserved, PB always reverts foreign key name to '[foreign key 1]'. This system generated name is invalid and subsequently causes errors

when user attempts to modify foreign key definition.

THIS IS AFFECTING TEST AUTOMATION SCRIPTS...





PER DEVELOPMENT: This is not a bug. Syb 4.0x did not support foreign key (or primary keys for that matter) assigned key names. Please bug number 44811's description for more information on syb 4.0x's support of foreign and primary keys. (This information is also available in the MSDN.)



This behaviour is the same in 4.0x, 5.0x and 6.0x. Since the database didn't provide/save a foreign key name, the PBSYB*.dll driver was coded (and only this driver, I double checked), to give a default foreign key name of '[foreign key 1]'. The driver was also coded to give a default primary key name of 'primary'. This is true only for this dialog and only for the SYB driver 4.0x.



CR:158737
CR Number:   158737
Product Name:   PB Enterprise
Product Component:   Installation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jul 1998 Presently Not Targeted For Any Future Release Of This Product
Description
Problem: Informix 7 native driver does not appear as an option when installing the deployment kit from the PB 5.0.03 maintenance CD. It does appear with native drivers when installing the PB development environment



CR:158750
CR Number:   158750
Product Name:   PB Enterprise
Product Component:   Language - Compiler
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
Private instance variables having the same name in ancestor and descendant is not allowed eventhough the scope should be limited to the object itself and hence there should be no conflict.



CR:158751
CR Number:   158751
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Datawindow date Editmask should beep (and not allow entry of data) when validating certain dates rather than skipping onto the next portion of the date. US or European format has the same problem.



CR:158752
CR Number:   158752
Product Name:   PB Enterprise
Product Component:   Plug-ins
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
Datawindow plugin to look at psr file. Can print report once but after saving the psr (Right-mouse on plug-in and Save Rows As...Powersoft Report) and reloading the newly saved PSR, printing this new report is truncating information instead of saving exactly as shown.



NOTE: The display of the new report is fine. It's the printing that's truncating the data - so you must printout the psr.



Computed fields are moved. Numbers are cut off as are characters.



Using the report painter in Powerbuilder and the "Save Rows As..." Powersoft Report using a PSR EXACTLY duplicates the PSR for viewing and printing.



CR:158755
CR Number:   158755
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
User events mapped to pbm_command do not have wparam and lparam as arguments like

every other windows event does.



Workaround: Use message.longparm/wordparm.



CR:158757
CR Number:   158757
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Unable to position a control within a tabpage via the position property sheet. The x,y fields are disabled.



CR:158761
CR Number:   158761
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 22 Jun 1999 Fixed
Description
Description of of_SetColumnNameSource(2) in both sort and filter services needs more information to clearly show when this works (only with simple and extended filter dialogs - not with the default filter or sort dialogs) and that you need to use "of_setdefaultheadersuffix" as well. Users expected the default filter dialog to work with option 2 of of_setcolumnnamesource(2) to use "headers" in the default filter dialog.



ex:



dw_1.of_Setfilter(TRUE)

ii_rc = dw_1.inv_filter.of_SetColumnNameSource(2)

dw_1.inv_filter.of_setstyle(1) // Can't use "0" for default dialog, this won't work.

dw_1.inv_filter.of_setdefaultheadersuffix("_t") // need this too.

dw_1.inv_filter.of_SetFilter(ls_null)

dw_1.inv_filter.of_filter()



of_setdefaultheadersuffix() function call must be used to tag what it should look for as a header. If you use of_setdefaultheadersuffix() and you've change what the header is called. For instance:



'dept_id' will have a default header name text object called "dept_id_t"



If you modify any of the text field "names" in the header on the window (or it doesn't find one for the corresponding column), it won't work. If you keep all the defaults, in the example shown above "dept_id", if you use the extended filter dialog, the column in the "columns" tab will be referred to as "Department ID" - ie what is called the "label" in the extended attributes or the "text" attribute of the header "dept_id_t".



Basically, internally a mapping table is built that carries all the information so of_setcolumnnamesource() works correctly.



Datawindow column database column header

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

dept_id department.dept_id Department ID







PER DEVELOPMENT: NOT A BUG: DOCUMENTATION ERROR.



CR:158772
CR Number:   158772
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)
26 Feb 2009 Presently Not Targeted For Any Future Release Of This Product
Description
OCX controls and OLE style datawindows, do not appear in Composite datawindows when they are located within the nested reports



CR:158778
CR Number:   158778
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jan 2002 Fixed
02 Jan 2002 Not a Bug
05 Jul 2002 Fixed
Description
Performing an UPDATEBLOB statement before an ESQL SELECT statement against a text field in a different Sybase table results in text being truncated



Workaround:

==========

Instead of an embedded SQL SELECT statement after the UPDATEBLOB, perform a SELECTBLOB instead and use the string() function to convert the results



CR:158780
CR Number:   158780
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   MS Windows 3.1
Original Version:   4.0.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 09 Nov 1998 Fixed
Description
4.0.07 (released version) and the date 02/29/2001 was accepted as input.. dd/mm/yyyy or mm/dd/yyyy. It does give you an error when you try to tab off but 5.0.04 and 6.0 don't even let you enter the "1" of "2001"



CR:158782
CR Number:   158782
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Problem: Numeric display format shows truncation/rounding if number contains more than 15 significant digits.



CR:158805
CR Number:   158805
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Nov 1998 Fixed
Description
Changing the font properties of a static text object on a datawindow results in the size of the static text object changing from what the user specified. This does not occur for a static text object on a window.



WORKAROUND: Whenever font properties are modified the user has to resize the object to be the size they want.



CR:158826
CR Number:   158826
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 EBF1 7003 07 Jul 1999 Fixed
Description
Grid dw, H Split Scroll, clicking on split bar of scrollbar brings scrollbar thumb to the far right under certain circumstances, leading user to think they are viewing the right-most column, even when they are not.



CR:158844
CR Number:   158844
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 3.51
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
Changing datawindow column attribute Focusrectangle with modify() on a column with existing edit style of radio button causes the data value to be displayed. PB seems to convert the edit style to one that does support the focusrectangle attribute ie edit style "edit" (radio button does not support focusrectangle), then applies the value to the attribute.



CR:158860
CR Number:   158860
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jan 1999 Fixed
Description
Datawindow Print Paper Size using the Print Specifications property dialog shows (using HP IV) the following values at the bottom: UNKNOWN - 44 thru UNKNOWN 67.



This seems to be a development environment issue only. This dialog is available by using Right-Mouse on a blank area of the datawindow in design mode and choosing Properties/Print Specifications and selecting the "size" field in the "Paper" groupbox.



CR:158869
CR Number:   158869
Product Name:   PB Enterprise
Product Component:   Library Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 Beta 3 3234 16 Nov 1998 Not reproducible with latest version of the product available as of Resolution Date
Description
Painting/Display Bug. Exporting objects from Library Painter.

When Exporting object from the library painter, the "Export Library Entry" MODAL NON-RESIZEABLE response window height is based on the size of the PB application window. You can shrink the PB application so that the response window becomes unusable since its height it too small to see all the controls on the window. The only work around is to return to the library painter, resize the PB application so the response window height will resize so you can see all of the dialog box.



CR:158872
CR Number:   158872
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jun 2004 Fixed
Description
Dot notation for datawindow computed fields on the secondary datawindow not accessable when using shardata. They return null. Getitemstring() does work against the secondary datawindow computed field, though.



CR:158879
CR Number:   158879
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Exporting sql to log from a SYC data source to an ODBC datasource produces an activity log with ??? characters for some of the data types.



Solution: Added support for special datatype support from the pbodbxx.ini when we export syntax.



CR:158901
CR Number:   158901
Product Name:   PB Enterprise
Product Component:   DB Painter
Status:   Closed
OS:   Solaris 2.5.1
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
PB 6.0 build 203v4, Unix



The Browse button on the Database Preferences window crashes PB.



1) Enter the database painter

2) Open the Database Preferences window (Design>Options)

3) Click Browse



You get the following error:



Can't access this folder.

Path is too long.



Then PB crashes or hangs.



CR:158937
CR Number:   158937
Product Name:   PB Enterprise
Product Component:   Machine Code Deployment
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Initializing a numeric array using certain expressions works in pcode but causes a gpf in a machine code application. Using division and modulo fail. Addition, subtraction and multiplication work okay.



The uploaded test case has buttons to click which demonstrate the behavior. Each button has the same basic script except for how the initialization is done.



//////////

int li_Index, li_Count

string ls_Out

int li_Elements[]



// division and modulo fail

// addition, subtraction, multiplication succeed

li_Elements = {1 + 2}

li_Count = UpperBound (li_Elements)

for li_Index = 1 to li_Count

ls_Out += String (li_Elements [li_Index])



if (li_Index < li_Count - 1) then

ls_Out += ", "

end if

next

mle_1.Text = ls_Out

/////////
Workaround Description
 Use P-code



CR:158944
CR Number:   158944
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
**** 5.0.03 Regression ****

Composite dw with one report object. Criteria property for the report object does not get recognized, if one is specified in the dw painter. It will retrieve all rows in the table.



CR:158947
CR Number:   158947
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)
7.0.3 31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Modify Crosstab statictext results in GPF in PBDWE when the crosstab displays sum() for group in trailer band. Works fine if there you delete the sum() from the group trailer. Similar to bug 43743 which has been fixed.



CR:158963
CR Number:   158963
Product Name:   PB Enterprise
Product Component:   Library Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
GPF when attempting to import certain .srw files in the Library Painter into a pbl when in the 16 bit development environment on a Win 3.1 machine. The actual error message is: pb050 caused a gpf in module pblib050.dll @ 0006:2548.





Solution: Not an issue in 6.0 since there is no 16 bit dev env anymore. This will not be addressed in 5.0.



CR:158969
CR Number:   158969
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
When Clicking on a PictureButton, a shadow dotted line is drawn on the right and bottom side of the button. When the control looses focus these shadow lines remain.



CR:158974
CR Number:   158974
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Dec 1998 Fixed
Description
In the DataWindow painter, setting a column's property in Properties/ Edit/ EditMask: check Spincontrol, Read Only checkbox becomes enabled. Check this, click OK. When you return to the same properties Read Only checkbox is unchecked.



CR:158994
CR Number:   158994
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jan 1999 Duplicate
Description
Datawindow filter problem in runtime. Named computed fields are not available in filter dialog at runtime even though they are available in the datawindow painter Rows/Filter dialog.



CR:159003
CR Number:   159003
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 11 Nov 1998 Duplicate
Description
A datawindow containing group headers and set up for newspaper columns - when, say you have 2 columns as in a phone list - not always previewing or printing if a particular group overflows from column 1 to column 2 when in a COMPOSITE datawindow. It works fine when previewed outside the composite.



CR:159013
CR Number:   159013
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)
22 Feb 1999 Not a Bug
Description
Summary band total in a group presentation style report only sums the first section of the group. This computed field was created by modifying the expression and clicking on the field. So the field is available on the list, but it is calculation is not summing the entire field.


This is NOT bug 45421. It's just not calculating the sorts at the correct time.

Workaround: Invoke either Sort() or Filter() and possibly GroupCalc() at runtime (or in painter) to repaint the computed fields. Use whichever one is less destructive.

Per Development:
This is not a bug. This is a case of an aggregate-of-an-aggregate, which has always been 'unsupported' in DataWindows.

The group 1 computed field is the sum of a computed field in the detail band.
The computed field in the detail band is a calculation using another computed field in the detail band.
The other computed field in the detail band calls the function CumulativeSum on a third computed field in the detail band.
This boils down to a Sum of a CumulativeSum -- an aggregate of an aggregate.
The DataWindow Engine does not guarantee the computation order of computed fields, and therefore aggregates of aggregates is still unsupported.

However, I did find a work-around for the test case. The work-around might work for the customer and other aggregate issues.
I built a test window for the issue. In the Open Event I entered:

dw.SetRedraw (false)
dw.SetTransObject (SQLCA)
dw.Retrieve ()
PostEvent ("group_calc")

I created a user-defined event called "group_calc", in the window. I gave it the script:

dw.GroupCalc ()
dw.SetRedraw (true)

When I ran the application, the totals displayed correctly because of the double calculations.

I turn Redraw off to avoid a "display blink".
I post the group_calc event to allow the DW to complete its setup.
The group_calc event calls GroupCalc to recalculate group aggregates.
This works like a second-pass over the data.
I then turn Redraw back on and the computed fields display correctly.



CR:159015
CR Number:   159015
Product Name:   PB Enterprise
Product Component:   Profile Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 17 Apr 1998 Fixed
Description
Database Profile - ODBC: In database profile, Deleting PB Catalog Table Owner causes application error oxc0000005 0x1057c1d8 (NT4.0), page fault pbdts60.dll@0137:1057c1d8 (WIN95).



CR:159049
CR Number:   159049
Product Name:   PB Enterprise
Product Component:   System Runtime Functions
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Dec 2000 Not reproducible with latest version of the product available as of Resolution Date
Description
DBHandle() can return a negative number. There are PFC functions that call dbhandle(), but cannot handle a negative return code. Whenever there is not enough memory to connect to the db a random negative number gets returned.



CR:159051
CR Number:   159051
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows 3.1
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
Memory leak assigning a string after some string manipulations.



CR:159052
CR Number:   159052
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)
17 Apr 1998 Fixed
Description
Scripting in the datawindow editchanged event when using ResetUpdate() causes a GPF in PBDWE050.DLL 0021:1188 (win 3.11) when trying to type a character. The datawindow contains an expression for the protect attribute of if (isrownew(), 0,1). Even a comment in the editchanged event can cause this problem.



Cannot recreate in 5.0.04.55 or 6.0. Possibly related to bug 43735.



CR:159053
CR Number:   159053
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
If you assign a TrigEvent datatype to an any datatype, you cannot assign the Any datatype back to a TrigEvent Datatype



CR:159058
CR Number:   159058
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 17 Apr 1998 Fixed
Description
Assertion failure error when creating a tabcontrol with more than 5 tab pages and properties of Perpendicular Text, Bold Selected Text, and Left and Right tab positions in build 244.



This problem does not occur in builds 247 (6.0) or 301 (6.1).



CR:159106
CR Number:   159106
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
If you instantiate PowerBuilder Secure Window control (pbrxs60.ocx) on window, click on it and delete it via delete key - toolbar icons, window outline goes away and PowerBuilder closes with no message.



Only happens if both nonsecure and secure versions are present on the same window. Does not happen if you rightmouse click and cut. Does not happen if only one control is instantiated and deleted.



CR:159108
CR Number:   159108
Product Name:   PB Enterprise
Product Component:   Pipeline - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 RC1 5011 03 Feb 1999 Fixed
Description
Trying to run Pipeline painter from Powerbuilder command Line. Can open Painter but the Library and New Parameters does not seem to work.



pb050.exe /p datapipeline /l c:\cir\print_50.pbl /N



PB60.EXE /P datapipeline c:\cir\print_50.pbl /o test



CR:159110
CR Number:   159110
Product Name:   PB Enterprise
Product Component:   Application Painter
Status:   Closed
OS:   MS Windows NT 4.0
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
ENHANCEMENT. Properties toolbar (right mouse click) for the application in the application painter. The 'General Tab' does not permit entry or modification of the comment. It's greyed out.

Workaround: Use Library Painter

entry -. properties (Right mouse button) does allow entry or modification of application comments.





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从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等等。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------