远程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:209458
CR Number:   209458
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
Profiling trace output differs between pcode and machine code.
Making a trace file of an application using TraceBegin function. The profiling tool shows different trace information between profiles made with p-code or run and machine code. For instance, when done with p-code, clicked event of a window is shown as clicked event. However, clicked event on the same window is shown as created when the profile was made by machine code exe.



CR:209460
CR Number:   209460
Product Name:   PB Enterprise
Product Component:   DB Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jan 2000 Presently Not Targeted For Any Future Release Of This Product
Description
If you have the Database painter open and looking at a database, there is no refresh button.
If changes are made to the database, you cannot simply refresh the view. You must
disconect, reconnect and then reposition to whatever it was you were looking
Workaround Description
 RMB on "Tables" and use the table refresh menuitem to refresh all the table definitions. No need to reconnect to the database.



CR:209463
CR Number:   209463
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jun 2000 Not a Bug
Description
the Preview option is under View and also under File. Developers are used to it being under file, but choosing this then requires you to choose the object you wish to preview. In the DW painter, this should of course be the datawindow currently open. The Preview under the View menu is to open the Preview View which most people don't want on the screen as there is a real-estate shortage.



CR:209465
CR Number:   209465
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2004 EOL'd version. Not to be Fixed.
Description
Jaguar Component Wizard should allow selection of existing PBL.
Choose File New, then Start Wizards. Select Jaguar Component and when asked for the library where components will be housed, specify an existing library. It will tell you that this library already exists and will not allow you to proceed any further.



CR:209490
CR Number:   209490
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 28 Mar 2000 Fixed
Description
6.5 ebf Regression (build 1117). When a row is inserted at the bottom of a datawindow, it no longer displays at all. The buffer contains the row but no row is displayed in the datawindow control. As a side effect, horizontal and vertical scrollbars that are normally drawn - caused by the inserted row - are not drawn at all.

This worked fine in build 1112.

Fixed around 6.5 build 1127 and 7.0 build 7022
Workaround Description
 Issuing a Filter() directive twiddles the buffer and redraws the scrollbar but doesn't solve the problem.



CR:209491
CR Number:   209491
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jul 2000 Fixed
Description
Aligment problem on edit mask control (stringmask!)
Steps to reproduce :
1. Create a new window
2. Add an editmask field (Mask = xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx and Mask Type = StringMask!)
3. Click on the editmask and set its value to 0, click on alignment combo box and set alignment to left, reclick on alignment combo box and set alignment to right ==> 0 is not aligned to the right
4. Save the window and run the application that opens this window ==> 0 is not aligned to the right



CR:209492
CR Number:   209492
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
PB 6.5 SYC Error with UNION SELECT and ORDER BY
UNION SELECT with ORDER BY causes error: Incorrect syntax near the keyword 'union'



CR:209525
CR Number:   209525
Product Name:   PB Enterprise
Product Component:   DB Oracle
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 1129 08 Aug 2000 Fixed
Description
If DisableBind DBParm is set to 1 and you are using a PowerBuilder Oracle native driver, dates passed to non-English Oracle databases will be formatted incorrectly. They will always contain the English abbreviation for the month.



CR:209556
CR Number:   209556
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
identity column refresh issue in dw when issuing simultaneous updates



CR:209583
CR Number:   209583
Product Name:   PB Enterprise
Product Component:   DW Printing
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 a nested report is placed in the detail band has data beyond 32" (say 50") in the x direction, the nested data no longer prints out. Data for normal columns in the parent report at, say 50" print fine (although it takes 8 horizontal pages to print them).

If the nested report and the data contained in it is less than 32k units (32.765 inches), it prints fine.
Workaround Description
 Keep objects under 32" inches in the X direction inside nested report objects.



CR:209632
CR Number:   209632
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Mar 2000 Fixed
Description
7.0 Regression. GPF in PBVM70.DLL or MSVCRT.DLL in datawindow painter changing edit styles from anything (but usually the default "edit") to dropdowndatawindow and back and saving. The GPF can happen while assigning the dataobject to the dddw column or saving the object and sometimes when switching property sheets after you've made the dddw association to the parent datawindow column. Most often it's related to having a long name in a column used for either the display or data value column of the dddw (19-20 characters or more)

Other related problems:
- the list of columns produced when assigning the "Display" or "Data" columns are duplicates
- if the column name is > 20 characters, garbage characters appear after the name in the "Display value" or "Data value" column list.



CR:209635
CR Number:   209635
Product Name:   PB Enterprise
Product Component:   System Runtime Functions
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
PB Function IsDate() fails when evaluation of year portion with zeros in position thousandth, hundredth, tenth e.g. 0###, 00##, 000# ;

If year is specified without preceding zeros e.g. '999-mm-dd', then IsDate() evaluates correctly that this year value 999 is out of bounds.
Workaround Description
 Method 1: Use Mid() to get year portion of the string value '0999-12-25'; Convert year portion to integer.Verify if year portion is >=1000. Method 2:For year portion, check for zeros '0' in position thousandth, hundredth, tenth e.g. 0###, 00##, 000# ;



CR:209659
CR Number:   209659
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.x Catalina 8007 23 Nov 1999 Fixed
Description
Performance of iterative PB database connects/disconnects through ODBC much slower than Visual Basic for various databases. The query of the PBODB70.ini file causes a lot of the slowdown.

You can improve the performance 50-60% by cutting down on the size of the pbodb70.ini.

Some suggestions:
- Cut down the size of the INI file. Only include the section(s) for the driver you are using.

There are some fixes in 7.0 build 8006 and above to improve performance in reading the .ini file.
Workaround Description
 Before 11/29/99, you can greatly improve performance by customizing your PBODBC70.INI file.
Strip out all the sections that do not apply to your env. New PBODB70.DLL eliminates need for
custom ini file.



CR:209713
CR Number:   209713
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
SetFullState copies the blob correctly to the datastore/datawindow.
However if the dataobject property of the target datastore/datawindow is verified, the value is incorrect.

The workaround is to assign the dataobject property to the datastore/datawindow before calling SetFullState.
Workaround Description
 Assign the dataobject property to the datastore/datawindow before calling SetFullState.
Script:
ids_test.GetFullState(lblb_test) // for ds
dw_test.Dataobject = ids_test.dataobject // for dw on window
dw_test.SetFullState(lblb_test)



CR:209714
CR Number:   209714
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 9006 10 Aug 2000 Fixed
Description
6.5 ebf/7.0 ebf Regression. Calling setdetailheight() to change the height of the datawindow detail band from one that would show 5 lines of data per detail row in a large text field to one that shows 1 line of data per detail row causes a blank, white, area to appear at the bottom of the datawindow display.

6.5 build 444 and 6.5.1 build 620 work OK as does 7.0 GA but not 7.0.1 6012 and above. Resizing the datawindow control somewhat seems to fix the redraw issue but this was not necessary in earlier builds and is not a workaround if the window or datawindow control is not resizable by the user..



CR:209719
CR Number:   209719
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Mar 2000 Presently Not Targeted For Any Future Release Of This Product
Description
Change for DataWindow Case property cannot be saved when edit style is DropDownDataWindow



CR:209751
CR Number:   209751
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Mar 2000 Fixed
Description
7.0 Regression. Retrieve() issued on a datawindow with 'Retrieve As Needed'=Yes uses up new connections each time. (Property Retrieve.AsNeeded). Each time you perform a retrieve on the 7.0 datawindow, more connections will be used up and won't be released when the window containing the datawindow is closed but only when the application is closed. (if it's a global transaction object)

Disconnecting the transaction object (disconnect using sqlca;) will not free the connections unless the transaction object is destroyed.

Workaround:
// Shut off retrieve as needed and turn it back on before calling Retrieve()
// This frees the connection
dw_test.object.datawindow.retrieve.AsNeeded='No'
dw_test.object.datawindow.retrieve.AsNeeded='Yes'
dw_test.retrieve()

If you're using a class library, query the value first:

if string(dw_test.object.datawindow.retrieve.AsNeeded)='yes'
// Shut off retrieve as needed and turn it back on before calling Retrieve()
// This frees the connection
dw_test.object.datawindow.retrieve.AsNeeded='No'
dw_test.object.datawindow.retrieve.AsNeeded='Yes'
dw_test.retrieve()
end if
Workaround Description
 // Shut off retrieve as needed and turn it back on before calling Retrieve()
// This frees the connection
dw_test.object.datawindow.retrieve.AsNeeded='No'
dw_test.object.datawindow.retrieve.AsNeeded='Yes'
dw_test.retrieve()



CR:209865
CR Number:   209865
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ISUG Enhancement Request e15_043:



Window functions for scrolling a window vertical and horizontal. The functions should make it possible to ensure that the user is at the upper left corner of the window.
Review Status
 Reviewed by PB Engineering - ISUG Rating:

"U" Under consideration.



CR:209866
CR Number:   209866
Product Name:   PB Enterprise
Product Component:   Library Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Aug 2003 Presently Not Targeted For Any Future Release Of This Product
Description
ISUG Enhancement Request e15_036:



Add to the Global Search, ability to replace text and compile.
Review Status
 Reviewed by PB Engineering - ISUG Rating:

"N" No plans.



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



There is no way to use the PB structure painters (local or global) to add comments about each element in a structure. Having comments would in many cases be used to provide embedded documentation (like we can with most other things in PB) for users of the structure. Note: Comments can actually be in the source files for structures and the compiler handles them properly but the structure painters do not allow them.
Review Status
 Reviewed by PB Engineering - ISUG Rating:

"U" Under consideration.



CR:209868
CR Number:   209868
Product Name:   PB Enterprise
Product Component:   Application Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 May 2000 Presently Not Targeted For Any Future Release Of This Product
Description
ISUG Enhancement Request e15_029:



Add a 'Default Checkout PBL' property to the application object. When the Library:Source:Checkout dialogue box opens, that library would be the one selected. This will save programmers many minutes navigating to a directory and library, which, for each application, is ALWAYS the same.
Review Status
 Reviewed by PB Engineering - ISUG Rating:

"N" No plans.

This enhancement is redundant due to the fact that in PB 8 there is no longer a concept of public libraries and work PBLs. Not an issue with current version.



CR:209869
CR Number:   209869
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ISUG Enhancement Request e15_027:



Support ByReference Variables in OCX Controls. Currently, you can call OCX functions and reference OCX Attributes when the OCX is placed on a window. However, PowerBuilder does not support OCX variables by reference. You can declare them to be ByRef, but they are in fact ByValue. You can prove this by calling a function in the OCX which updates a variable -- you can see the updated value in MS Access, for example, but not in PowerBuilder.
Review Status
 Reviewed by PB Engineering - ISUG Rating:

"P" Planned for a next release - 10/10+.



CR:209870
CR Number:   209870
Product Name:   PB Enterprise
Product Component:   ORCA
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.2 17 Jul 2003 Fixed
Description
ISUG Enhancement Request e15_025:



Need to have the pborca.lib and pborca.h files distributed for PowerBuilder 7.0.
Review Status
 PB Orca files are now available on the SDN PB CodeXchange site (in the General folder):

http://powerbuilder.codexchange.sybase.com/



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



Create a new SaveAs option called ExcelFormatted! This will save the report to Excel *and* format the spreadsheet to really look like the report.
Target Version
 10.0
Review Status
 Reviewed by PB Engineering - ISUG Rating:

"U" Under consideration.



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



In the Datawindows, text object have a transparent property, but static text has not got that property at window painter. Also you can not draw a line on the pictures , it always goes behind the objects. It is not like that at datawindows also... And Group box objects are not containers of the objects which are in the group boxes. They are only for radio buttons, or check boxes.They should be a container also.
Review Status
 Reviewed by PB Engineering - ISUG Rating:

"U" Under consideration.



CR:209873
CR Number:   209873
Product Name:   PB Enterprise
Product Component:   DW DDDW
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0 Beta 1 04 May 2000 Fixed
Description
ISUG Enhancement Request e15_008:



PB should allow auto-retrive of DDDW selectability (on/off).
Review Status
 Reviewed by PB Engineering - ISUG Rating:

"C" in Current products.



CR:209874
CR Number:   209874
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Aug 2003 Presently Not Targeted For Any Future Release Of This Product
Description
ISUG Enhancement Request e15_001:



PB should allow for better drag and drop support in PB painters including: a) move/copy functions + events between objects b) expendable ancestor code window c) ancestry drill through when selecting scripts for debugging.
Review Status
 Reviewed by PB Engineering - ISUG Rating:

"N" No Plans.



CR:209877
CR Number:   209877
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 Fixed
Description
PFC Documentation on listviews u_lvs
Due to complying to Microsoft listviews, the RButtonUp event does no longer fire when
a user rightclicks on an item in a listview.



CR:209921
CR Number:   209921
Product Name:   PB Enterprise
Product Component:   Machine Code Deployment
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 the Datatype Double is being used without the exponential notation and used in a relational operation to compare "decimal like numbers", the compiled machine code executable behaves differently than in development environment (or in pbd's).

Workarounds:
Obviously a PBD application works ok.
Furthermore:
1.) For relational operations there is no type promotions ie. datatypeconversions (page 79. Powerscript Reference 1) Hence if you would convert both values to Double using Double() and than compare works fine.
2.) If there should be decimals compared, use the datatype of Decimal ie. Decimal cd_small = 0.005
Comparing the decimals also works fine.
3.) Double values are Numeric literals with a decimal point and explicit exponent ie. double cd_small = 5.0E-4 (see page 79 table).



CR:209938
CR Number:   209938
Product Name:   PB Enterprise
Product Component:   SQL Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Mar 2000 Fixed
Description
The SQL Painter always terminates the generated SQL with ';' without regard to the designated SQL teminator.



CR:209939
CR Number:   209939
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Enhancement. CR165824 added a visible horizontal line that appears after each page (a page being described as the height of the datawindow control). This was a change in behavior in 6.5.1 and above.



CR:209942
CR Number:   209942
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Auto-horizontal scroll property does not work with column objects of numeric datatypes (number or decimal)



CR:209943
CR Number:   209943
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 Fixed
Description
The HTML Datawindow does not show the sort button when previewed in the datawindow painter or when deployed. (This assumes you "Check" the HTML DW attribute before rendering the output and when saving the datawindow)



CR:209952
CR Number:   209952
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Dec 1999 Not a Bug
Description
Customer has code to continually populate a treeview, adding on children as the user expands items. It worked using 6.5, but migrated to 7.0, the code does not populate the treeview. It *appears* that the value of children = true is ignored. When the treeview comes up in 6.5, there are pluses next to the items to indicate that they can be expanded. Using 7.0, this is not the case.



CR:209955
CR Number:   209955
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Aug 2000 Fixed
Description
Saving a datawindow to Excel 5 format using the SaveAs() function. When used in Excel, unable to copy the contents of the spreadsheet to a new workbook; Excel '97 will crash. Copying into the existing workbook appears to be fine.



CR:209959
CR Number:   209959
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 10087 24 Aug 2001 Fixed
24 Aug 2001 Fixed
Description
Calling a pb com object from c++ causes
error. C++ can't find the pb com object.

Customer says it worked ok in pb 5.0.04.
Workaround Description
 Use the "generated COM object" technology rather than the
old style "OLE Automation" technology.



CR:209977
CR Number:   209977
Product Name:   PB Enterprise
Product Component:   DW DDDW
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
When a nested datawindow contains a dddw, using getfullstate()/setFullState() failed to display the 'display
column' of the dddw, it only showed the 'data column'



CR:209980
CR Number:   209980
Product Name:   PB Enterprise
Product Component:   DB Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2004 EOL'd version. Not to be Fixed.
Description
In the database painter, when trying to create a new column copying the
attributes of an existing one, doesn't copy the extended attributes and the
source column loses their attributes too.
Workaround Description
 change the extendet attributes manual of the copied column in the db painter.



CR:209985
CR Number:   209985
Product Name:   PB Enterprise
Product Component:   DW Printing
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jan 2000 Fixed
Description
When using the print services of pfc and you change
the printer from default, the copies will still print to the default printer even
though you changed the printer in the print dialog box.



CR:209989
CR Number:   209989
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7040 16 Aug 2001 Fixed
Description
7.0 Regression. Migrated datawindows with column names > 40 characters hang in PB 7.0 when opening in the datawindow painter. The painter limited you somewhat in 6.5 but the painter itself sometimes creates JOIN names that could exceed 40 characters which migrate to 7.0 but cause the painter to hang.



CR:210031
CR Number:   210031
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
After depolying a component from PB, then try to modify the UO, PB will crash, if the uo is calling the external function "JagGetUserName" from Jaguar.
workaround: Restart PB before opening the UO after deploying.
Workaround Description
 restart PB before you if you like to edit UO after delploying



CR:210036
CR Number:   210036
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
In the DataWindow painter, if you specify an ObjectName (HTML Generation Tab) for HTML Datawindow generation, save it, and then delete the name again, the HTML generated is invalid.
Workaround Description
 Export the datawindow and delete the ObjectName="" property from the .srd file and reimport, you get the default behavior of using htmldw as the object name



CR:210038
CR Number:   210038
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.x Catalina 7023 04 Jan 2000 Fixed
Description
Oracle 8.0.x does not support NON-Blocking mode so the Async DBPArm was removed from the PB 7.0 interface for Oracle 8. Powerbuilder actually had ASYNC for the PB Oracle 8.x driver for PB 7.0 but the support had to be taken it out due to Oracle's API not supporting it.

The Oracle 8.1.5 now supports NON-Blocking mode so the support can be re-added to the PB 7.x codeline.

The support for ASYNC using the PBO84 driver is already implemented in Powerbuilder 8.0.



CR:210073
CR Number:   210073
Product Name:   PB Enterprise
Product Component:   Function Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 EBF1 12 Jul 2000 Fixed
Description
Global function with 16 string array arguments and an additional string argument created. If you try to open it after doing the initial save, PowerBuilder will crash. Probable duplicate of bug 193870.



CR:210097
CR Number:   210097
Product Name:   PB Enterprise
Product Component:   DW 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 Apr 2000 Fixed
Description
DataWindow date EditMask shows keyboard entered NULL date (e.g. 00.00.00) incorrectly. The NULL date is shown in the Editmask as a date (e.g. 01.01.00) for datetime column - related to 201595 and 208484, but here with datetime column instead of date column.



CR:210105
CR Number:   210105
Product Name:   PB Enterprise
Product Component:   DW Printing
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Oct 2000 Not reproducible with latest version of the product available as of Resolution Date
Description
The New PFC DLL PFCCOM32.DLL which includes re-written routines for calling print functionality. With HP 4 drivers, this seems to work correctly in most cases. Using specifically the HP 4050 driver, invoking the function call to the DLL (used by PFC) causes a GPF "The instruction at "0x77c0dd0e" referenced memory at "0x00160000". The memory could not be read.
Workaround Description
 Use a different printer driver/printer. Not using the PFC dialog works OK too.
(use dw_1.print() without invoking the dialog)



CR:210126
CR Number:   210126
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
Setting the return code to 1 in the itemchanged event
does not appear to affect the outcome of the event in a grid dw. Once
you enter data in a cell and then click to a cell that is text or a computed field,
focus changes to that cell. With a return code of 1 focus should not be allowed
to changed.



CR:210144
CR Number:   210144
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jun 2000 Duplicate
Description
Powerbuilder 7 against ASA .The predefined edit-styles of type date are not always available in the datawindow painter for a date column. Only every second column in a sequence shows the right available edit styles.

Workaround:
Use the Style Type "Editmask" instead of the default value "Edit" and select the date mask from the selections which comes up when pressing the > button to the right of the MASK field.



CR:210152
CR Number:   210152
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2000 Fixed
Description
Problems with datawindow 3 state checkbox : checkbox locks up if two data values have the same value

Workaround: Use diffent datavalues or use a 2 state checkbox to save wo different states.



CR:210172
CR Number:   210172
Product Name:   PB Enterprise
Product Component:   SQL Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Mar 2000 Fixed
Description
7.0 Regression. Creating a datawindow in syntax mode with a SQL statement going against SQL Server 7.0 or Sybase 11.5 (could be others) causes a GPF in PBSQL70.DLL or KERNEL32.DLL when you go from design mode to SQL painter after the datawindow is created when logged on as a non-dbo user and you are using a table alias.

Microsoft SQL Server 7.0
select a.au_lname from authors as a <- GPFs
select a.au_lname from dbo.authors as a <- works OK.

Sybase SQL Server 11.5
select a.au_lname from authors a <- GPFs
select a.au_lname from dbo.authors a <- OK

Since these datawindows are normally migrated, it's unreasonable to work around this by stripping off the dbo.
Workaround Description
 select a.au_lname from dbo.authors as a



CR:210175
CR Number:   210175
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Mar 2000 Fixed
Description
7.0 Regression. Edit Styles of type date not shown in property sheets for date columns if the columns in the select statement are in an EVEN position. For example:

If you build a datawindow with the following select statement:

Select start_date, end_date, termination_date from employee

Only the 1st and 3rd columns will show all the edit styles of type "date". The second column "end_date" will not show any date edit styles the user has defined in the database.



CR:210176
CR Number:   210176
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)
18 Apr 2000 Fixed
Description
When a column has a edit style of type edit mask (for example, ###-###-####)
and you delete the data in the column the edit mask does not format properly.
It will show (-- ) instead of ( - - ). Happens with a editmask of type string.

When you first insert a row to a table, the editmask appears properly ( - - ). Problem
only happens if you delete the data in the column, than editmask doesn't function
properly.

Works ok in PB 6.5.1 (build 1127). Does not appear to be db specific.



CR:210180
CR Number:   210180
Product Name:   PB Enterprise
Product Component:   DW Synchronization
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Dec 2001 Fixed
Description
GetChanges/SetChanges after update of server ds, corrupts client dw.
Workaround Description
 Use resetupdate() on the client datawindow after a successful update rather than GetChanges/SetChanges.



CR:210211
CR Number:   210211
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Aug 2000 Fixed
Description
Cosmetic Problem : Displays incorrect icon to indicate dw Format property has an expression.
---------------
If a valid expression is in the Format property, the green equal sign/ symbol/ icon is not displayed. The red equal sign with slash through it is displayed instead.
Workaround Description
 Problem is purely cosmetic because the icon switching display is helpful to a PB developer.



CR:210212
CR Number:   210212
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Aug 2000 Fixed
Description
PB7.x datawindow PREVIEW tab : Computed field displays expression contained in the Format property.
In PB7.x computed field should display as blank values or best-fit format values(as expected from PB6.x behaviour) when there exists a Format property expression for this object.

Instead the Format expression for this computed field is visible in the datawindow preview section.



CR:210216
CR Number:   210216
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Aug 2000 Duplicate
Description
Problem synchronizing modification of expression when brand new expression entered

PB7.x datawindow saves Format property expression when in expression dialog window. However expression is displayed in the dw painter entry after the object has lost focus.
Workaround Description
 In dw painter, change the focus to a different object, return focus to the computed object. The expression will be displayed in format entry field.



CR:210218
CR Number:   210218
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Aug 2000 Duplicate
Description
Problem synchronizing modification of expression for pre-existed expression
PB7.x datawindow saves Format property expression when in expression dialog window.

However if expression is modified then this is saved but not displayed in the dw painter entry.

However expression is not displayed in the dw painter entry till the object has lost focus to a different object and then focus returned to the computed object.
Workaround Description
 In dw painter, change the focus to a different object, return focus to the computed object. The expression will be displayed in format entry field.



CR:210223
CR Number:   210223
Product Name:   PB Enterprise
Product Component:   Generators
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Sep 2000 Fixed
Description
String arguments and return values from PB-generated COM objects are incorrect when they include german, hebrew, or french characters > Ascii 127.



CR:210226
CR Number:   210226
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2004 EOL'd version. Not to be Fixed.
Description
Enhancement. Update Characteristics dialog. Confusing GUI.

Confusing area of the Rows/Update screen of the datawindow. Unfortunately, due to the placement of the "Key and Modified" in the "Where Clause for Update/Delete" groupbox, developers assume there is a linkage between this 'Key and Modified" selection and the "Updateable Columns" listbox below it since this is indeed the case for the "Key Columns" and "Key and Updateable Columns" radio button selections.



We should NOT leave this listbox selectable in this case.



NOTE: If the user does select "Key and Modified", they must realize this is an advanced feature of the datawindow and they must control item statuses of modified columns in script (setitemstatus) in order to keep them from showing up in the WHERE clause if they should not be included.



CR:210240
CR Number:   210240
Product Name:   PB Enterprise
Product Component:   DW Graph
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 26 Apr 2000 Fixed
Description
When creating a series graph and changing the font size (autosize unchecked) PB crashes when right clicking on the design view. 4/27/2000: Verified fixed in 7.0.02 build 8026 and after.



CR:210245
CR Number:   210245
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 29 Mar 2000 Fixed
Description
run this app, it will display a window with a button entitled 'Go'. Press Go. The counter will go up to 8190 and then you will get the 'Out of memory' error. Essentially what the code is doing is executing a
datastore.Describe(Evaluate) within a loop and updating the counter each time through. After 8190 iterations, it gives the error.



CR:210251
CR Number:   210251
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)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
There is a 12K to 18K memory leak each time the Powerscript Run function is called on NT 4.0.
Workaround Description
 Workaround is to use the WinExec API call:
Function ulong WinExec(ref string str, uint num) Library "KERNEL32.DLL"



CR:210256
CR Number:   210256
Product Name:   PB Enterprise
Product Component:   DW ActiveX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
DropDowns on ActiveX datawindow may appear behind browser if browser is moved downwards, minimized and then restored.
- DropDowns may appear to be inactive



CR:210267
CR Number:   210267
Product Name:   PB Enterprise
Product Component:   DW Printing
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
include A1 or A2 paper size in the properties of the dw (in the painter) or by using modify for a dw object. At the moment the propertie <DW Control Name>.Object.DataWindow.Print.Paper.Size does not include this.



CR:210268
CR Number:   210268
Product Name:   PB Enterprise
Product Component:   Menu Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Aug 2000 Presently Not Targeted For Any Future Release Of This Product
Description
PB 7 Print item disabled in the menu painter. Not able to print menu definition.
This was possible in prior releases.



CR:210270
CR Number:   210270
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Html dw doesn't support differnt background colors in the differnt bands.
Workaround Description
 Use generateHTML and modify the HTML



CR:210273
CR Number:   210273
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Sep 2000 Fixed
Description
PB Version and Build: PB 7.0, 7.01
DB/DLL: Docs (CD, Sybooks, printed manual)

Comments: Powerbuilder User Guide wrongly describes date editmask behaviour (it is actually describing the date EDIT edit style behaviour)

The manual says the following for the date edit mask behaviour:
<< A nonzero number in the first position of dd, mm, hh, ss, or mm (minutes) followed by the delimiter character, will cause the typed digit to be preceded by 0.
For example, typing 1/1/97 results in 01/01/97. >>

Actual behaviour in PB 7 is
Typing a '/' jumps to next section of date (from dd to mm or from mm to yy) leaving whatever is in the second digit untouched (0 or non-zero)

For example, typing 1/1/97 results in 10/10/97.
Being an EDITMASK you should not need to type in the '/'

The description in the manual is actually describing the behaviour of a date EDIT edit style and not the date EDITMASK edit style.



CR:210277
CR Number:   210277
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 Fixed
Description
When setting a display format with a european date format eg. German dd.mm.yyyy in a HTML datawindow the wrong datesequence in the HTML gets generated.

Workaround:
-for the Usage in a Browser-Jaguar environment is as follows:
The generate() method in the server component(HTMLGenerator) of the DataWindow packeage needs to be modified. Clearly if an already customized version is being used the cust. version needs modification.
Basically the wrong variable values for the date sequence need to be replaced by the ones for the intended date sequence.
As an example the values for the German sequence is
var DW_PARSEDT_monseq = 1;
var DW_PARSEDT_dayseq = 0;
var DW_PARSEDT_yearseq = 2;
so the code for the generate method would look like this:

string ls_result

if ib_trace then of_log_enter("Generate()")

ls_result = ids_datastore.Describe("DataWindow.Data.HTML")
//
// This is the date order without modification
//
//var DW_PARSEDT_monseq = 0;
//var DW_PARSEDT_dayseq = 1;
//var DW_PARSEDT_yearseq = 2;
//
// This should be the date order for German date sequence dd.mm.yyyy
//
//var DW_PARSEDT_monseq = 1;
//var DW_PARSEDT_dayseq = 0;
//var DW_PARSEDT_yearseq = 2;
string DW_PARSEDT_monseq ="DW_PARSEDT_monseq = 0" //Month-String to be found
string DW_PARSEDT_dayseq ="DW_PARSEDT_dayseq = 1" //Day-string to be found
string DW_PARSEDT_monseq_new ="DW_PARSEDT_monseq = 1" //Replacement for default month
string DW_PARSEDT_dayseq_new ="DW_PARSEDT_dayseq = 0" //Replacement for default day settings

long position

position = pos(ls_result, DW_PARSEDT_monseq ) //Gets the variable position in the html code

ls_result = Replace ( ls_result, position, 21, DW_PARSEDT_monseq_new )

position = pos(ls_result, DW_PARSEDT_dayseq ) //Gets the variable position in the html code

ls_result = Replace ( ls_result, position, 21, DW_PARSEDT_dayseq_new )

if ib_trace then of_log_exit("Generate(), length = " + String(Len(ls_result)))

of_completeWork()

return ls_result



CR:210278
CR Number:   210278
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Mar 2000 Fixed
1210 14 Sep 2000 Fixed
Description
Decimal digits (scale) are truncated for numeric argument of a DataWindow Update Stored Procedure



CR:210279
CR Number:   210279
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jun 2000 Duplicate
Description
When creating a new composite DW with PowerBuilder 7 you will get an application error if the total number of characters in the list of available DWs is greater than 4000.
Workaround Description
 Make sure the total number of characters for all DWs add up to less than 4000 characters.



CR:210303
CR Number:   210303
Product Name:   PB Enterprise
Product Component:   Shared Objects
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Using an NVO that contains a PUBLIC structure. If you use CREATE to create the instance of the user object, you can modify the structure members from outside the object. However, if you use SharedObjectRegister() / SharedObjectGet(), you cannot modify the structure members from outside the object. In both cases, you can modify non-structure variables from outside the NVO.



CR:210334
CR Number:   210334
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Dec 2000 Not reproducible with latest version of the product available as of Resolution Date
Description
The profiler exe GPFs in PBVM60.DLL in all views (Trace, Class, Routine) in 6.5 (with a built EXE using w_starttrace from profiler.pbl) and in 7.0 in PBVM70.DLL in the development environment reading certain .pbp files.
(7.0 integrates all profiling in the development environment where 6.5 uses a separate profiler.exe tool)

In 6.5, you can see specific views crash in different places (Constructing Display) but always in PBVM60.DLL though. In 7.0, no UI is shown so after choosing a type of Profiling, it GPFs in a few seconds.



CR:210354
CR Number:   210354
Product Name:   PB Enterprise
Product Component:   DB JDBC
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Mar 2000 Fixed
Description
Powerbuilder crashes in the dw painter after you connect
to informix 7 thru jds and you select a stored procedure.



CR:210375
CR Number:   210375
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
When using the "commit using transactionobject;" statement in a script a small memory leak can be observed in the task manager. Problem occurs in the informix native driver IN7. Calling the statement in a loop can cause a gpf when reaching the memory limit.

Workaround:
No workaround - suggestions:
-Use Informix ODBC driver instead, if possible.
-Do not commit in a long running loop, ie. don't commit too often, eg commit after every 100 iterations.



CR:210385
CR Number:   210385
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)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
PowerBuilder is not releasing memory from datastore during aplication execution when connected
to Informix db.
This is a problem in both PB development and runtime environments with Informix db only.
Testing indicates that PB datastores and Informix db (with ODBC or native drivers) are
the drawbacks.
Workaround Description
 GarbageCollect() function called at end of script in cmdbtn 'Retrieve' helps in circumstances.



CR:210402
CR Number:   210402
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 Aug 2000 Not a Bug
Description
PB Version and Build: Builds 6.5.1042 onwards. Same behaviour in PB 7.0 GA onwards
DB/DLL: PBDWE60.DLL

Datawindow which uses ShareData with a datastore/datawindow fires RowFocusChanged event when:

1) ShareDataOff() is called
2) Whenever a row is deleted (regardless of the current row ie even if it is row 1 - see below)
3) If DeleteRow() is called and there are NO rows in the dw

Above behaviour is only true for DW using ShareData with dw/ds
Above behaviour changed in PB 6.5 build 1042 onwards. Did not happen with earlier builds



CR:210408
CR Number:   210408
Product Name:   PB Enterprise
Product Component:   DW Expression
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.x Catalina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 30 Jan 2001 Fixed
Description
First occurrence of problem in PB701_7021 EBF (EA Studio 3.0.1 Maintenance release)
Crosstab datawindow is unstable when expressions are defined for the properties AND
if there has only been one crosstab build for it.
Once the crosstab dw is rebuilt after the initial creation, then the problem goes away.

(A rebuild is only possible by modifying the SQL statement e.g. adding another column,
changing the WHERE clause.) PB issues a message after SQL painter modification :
'The action just taken has forced the preview view to be rebuilt. You may need to re-retrieve
your data.'
Workaround Description
 Rebuild crosstab dw after the initial creation. Remove the duplicate expressions from
the other columns. Save the dw. However if the dw is rebuilt, this duplication will re-occur (until EBF made.)



CR:210427
CR Number:   210427
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
There is a PB memory leak for datastore after disconnect from an Informix db.
Workaround Description
 GarbageCollect() function called at end of script in cmdbtn 'Retrieve' helps in circumstances.



CR:210430
CR Number:   210430
Product Name:   PB Enterprise
Product Component:   DW DDDW
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.x Catalina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jan 2001 Not a Bug
Description
DDDW property change causes problems with filter buffers
Workaround 1 - reretrieve before setting second filter
Workaround 2 - take filter off before setting color
Workaround Description
 Workaround 1 - reretrieve before setting second filter
Workaround 2 - take filter off before setting color



CR:210433
CR Number:   210433
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 06 Mar 2000 Fixed
Description
When decimal separator is comma embedded SQL select MSS driver conversion from float to Powerscript decimal causes error:
float conversion attempt failed, the source is invalid - selecting into double works fine
Workaround Description
 select into double



CR:210436
CR Number:   210436
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jan 2000 Fixed
Description
When decimal separator is comma embedded SQL select MSS driver conversion from real to PowerScript decimal does not show decimal separator



CR:210437
CR Number:   210437
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.x Catalina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jan 2000 Third Party Problem
Description
When decimal separator is comma embedded SQL select SYC driver conversion from decimal to PowerScript double cuts off the digits after the comma



CR:210439
CR Number:   210439
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.x Catalina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jan 2000 Third Party Problem
Description
When decimal separator is comma embedded SQL select SYC driver conversion from decimal to PowerScript real; cuts off the digits after the comma



CR:210440
CR Number:   210440
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.x Catalina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jan 2000 Third Party Problem
Description
When decimal separator is comma embedded SQL select SYC driver conversion from numeric to PowerScript double cuts off the digits after the comma



CR:210442
CR Number:   210442
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jan 2000 Third Party Problem
Description
When decimal separator is comma embedded SQL select SYC driver conversion from numeric to PowerScript real cuts off the digits after the comma



CR:210443
CR Number:   210443
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.x Catalina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jan 2000 Third Party Problem
Description
When decimal separator is comma embedded SQL select SYC driver conversion from float to PowerScript decimal sets decimal separator incorrectly



CR:210445
CR Number:   210445
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.x Catalina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jan 2000 Third Party Problem
Description
When decimal separator is comma embedded SQL select SYC driver conversion from real to PowerScript decimal sets decimal separator incorrectly



CR:210446
CR Number:   210446
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Wants to be able to copy dw_2.object.data = dw_1.object.data even when the source datawindow includes a timestamp column. If you use this syntax with most datawindow objects, it works perfectly well. If you do it with a datawindow which includes a timestamp column, you get an error message that there is a type mismatch.

Originally called in as a bug, but here is the evaluation from development:

This is a behavior. We do not support timestamp columns for this operation. Why?
The reason we do not support it is when we are setting the target data we are setting DW column data types from PB data types ... or at least types known to the object manager.

In the statement:
lds_2.dataobject = lds_1.dataobject
we do not really copy the dataobject as a block but as parts (objects) the object manager can recognize. Each row/column in turn is copied from one to the other in object manager representation to data window representation and there is no corresponding obj_mgr timestamp type.

Likewise; obj_mgr types of data of; bool, binary and char are unsupported as are obj class values and any obj_mgr data which is more than a single value.



CR:210489
CR Number:   210489
Product Name:   PB Enterprise
Product Component:   DW Synchronization
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
The CreateFrom function crashes on

numeric and decimal columns passed in an ADOResultset

from a VB COM server.



Workaround :

select the column as a string, for example:

select convert(varchar(23), salary)

instead of select salary



CR:210511
CR Number:   210511
Product Name:   PB Enterprise
Product Component:   ORCA
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 8020 25 Feb 2004 Fixed
Description
ORCA regenerated Pcode EXE will experience run-time errors and machine code exe will not build correctly if they contain an UPDATE/DELETE WHERE CURRENT OF CURSOR clause. This was because ORCA
applications do not have a database connection and the powerscript compiler would only generate the correct
PCODE if the database you are currently connected to indicates support for updatable cursors.

The pcode exe appears to build fine but causes a runtime error at the update where current of cursor statement: " The instruction at '0x112db729' referenced memory at '0x00000038'. The memory could not be read."

There is no such problem in the development environment if you regenerate the application while connected to a database server that supports updatable cursors.
Workaround Description
 Replace updateable cursors with datastores. They are much faster and more database independent.



CR:210556
CR Number:   210556
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 1166 27 Mar 2000 Fixed
Description
6.5 EBF Regression. The page() function returns incorrect page # in a tabular or group datawindow that contains a nested report in the detail band. The page() function returns only ODD page numbers, so it would number page 1,2,3,4,5,6,7 as page 1,3,5,7,7,7,7.

Broken around 6.5 build 1112.

A partial fix went into 6.5 1155 and 7.0.2 8014 for print preview but the printed output still has the problem.



CR:210557
CR Number:   210557
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Aug 2000 Not a Bug
Description
Tag values are missing for columns when crosstab datawindows are switched to staticmode.



CR:210578
CR Number:   210578
Product Name:   PB Enterprise
Product Component:   Table Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
The table painter does not display the next level of the treeview for table "Users". Instead, it shows "<empty>".



CR:210585
CR Number:   210585
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   3.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Dec 1999 Duplicate
Description
Datawindow/HTMLGenerator component in Jaguar constructs updates differently for radio buttons from a Netscape browser. When using Netscape 4.x browser and making a change to either a radio button or check box, the update is not being propogated correctly to the database. If the datawindow is redisplayed, it does not retain the change. Radio buttons work correctly from an IE browser but checkboxes do not work from this browser either.
Workaround Description
 None found



CR:210596
CR Number:   210596
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 Not reproducible with latest version of the product available as of Resolution Date
Description
7.0 Regression. GPF when doubleclicking on a datawindow column and slowly moving cursor (but not clicking) outside same column to the border after waiting for the timer event to fire at least once.

This only happens if there is a timer event on the window.



CR:210601
CR Number:   210601
Product Name:   PB Enterprise
Product Component:   Debugger
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Aug 2001 Fixed
Description
Just in time debugging will give an application error if the script contains a null object reference.
Workaround Description
 1) Stop the debugger, then exit the debugger.

2) Open the window object before running the application.



CR:210621
CR Number:   210621
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jun 2000 Not a Bug
Description
PB crashes on a disconnect from WordPerfect Oleobject.
Problem happens after the second or third time running app (without closing pb down).
Happens in development and runtime. Using WordPerfect 8.0. WordPerfect document
opens successfully first and second time until PB crashes.

Crashes with the following error:
An application error has occurred and an application error log is being generated
for pb70.exe
Exception Access Violation (0xc0000005) address 0x78001628

Using the following code:
oleobject lole_document
lole_document = create oleobject
lole_document.ConnectToNewObject('WordPerfect.PerfectScript')
lole_document.FileOpen(ls_path_wpd,4)
lole_document.DisConnectObject()
destroy lole_document



CR:210625
CR Number:   210625
Product Name:   PB Enterprise
Product Component:   DW Graph
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 9021 06 Sep 2000 Fixed
Description
Line graph starting from a point not suported by data points.
Verified fixed in 6.5 1229, 7.0.2 9023, and 8.0 2036



CR:210643
CR Number:   210643
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
ODBC: If you have multiple foreign keys (e.g, 12) from child table to the parent - In database painter
only the first six foreign keys show up. The sixth foreign key contains the remaining 6 keys that did not show.



CR:210649
CR Number:   210649
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.x Catalina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
When creating a dw object in the dw painter using the
JDS driver, pb gives the following error when the data source is a stored procedure:

Cannot create DataWindow
'Internal Error: No ResultSet. The command did not produce any Resultset.
1 execute dbo.getTCWUsersSPHtml;1'

Using ASE 11.9.2 as a the sqlserver.
Workaround Description
 From development:
There maybe a problem with jConnect and return values which we will have to investigate...





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