远程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:344493
CR Number:   344493
Product Name:   PB Enterprise
Product Component:   Menus - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 May 2005 Workaround
Description
Menuitem that has no submenu items stays highlighted.



If you have a menuitem which has no submenues in a MDI application, that menu item will continue to have a focus rectangle after the focus is lost. This makes it very ugly on XP display schemes. This is also a problem on Win 2000.



Workaround: Please the following code in activate event of the window which is being called from the menuitem:



//m_main.item[1].visible = false

//m_main.item[1].visible = true
Workaround Description
 Please the following code in activate event of the window which is being called from the menuitem:



m_main.item[1].visible = false

m_main.item[1].visible = true



CR:344499
CR Number:   344499
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Feb 2004 Fixed
Description
In On-line help, select "NumericFormat DBParm parameter" from the Index tab.

Click the Examples button and notice the extra bolding and the inclusion of the Example 2 line in the stream of text.



CR:344518
CR Number:   344518
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Sep 2005 Fixed
Description
No rollback on a transactional EAS PB component on an Application Execution Error.



CR:344536
CR Number:   344536
Product Name:   PB Enterprise
Product Component:   Pipeline - Runtime
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
In Data Pipeline object, cannot insert a Null value into a DateTime columns. Even if column alllows Nulls. Error: "Restricted data type attribute violation" and same query works in in isql or query analyzer.
Review Status
 04/23/2005:

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



CR:344543
CR Number:   344543
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.0 beta3 15 Apr 2004 Fixed
Description
10.0 must have SYC driver support for new ASE date and time datatypes. (And maybe SYJ support too).



CR:344581
CR Number:   344581
Product Name:   PB Enterprise
Product Component:   System Runtime Functions
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Wants the ability to choose the folder of temporary file used by saveAS.



CR:344648
CR Number:   344648
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Solaris 2.8
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 07 Mar 2008 Insufficient priority to fix
Description
ProfileInt not reading the ini file. Using truss

to capture output and no entries show up in log file for ProfileInt.



Works ok using ProfileString



CR:344651
CR Number:   344651
Product Name:   PB Enterprise
Product Component:   DB Other
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
PowerBuilder binds numeric retrieval arguments to float values in most cases. When using a decimal retrieval argument this can cause full table scans because the datatype does not match that of the primary key. Add support of decimal retrieval arguments.



CR:344679
CR Number:   344679
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.2.1 08 Jun 2007 Fixed
Description
Oracle 9 has a new syntax feature in creating char and varchar columns.

You can use the CHAR qualifier, for example VARCHAR2(10 CHAR), to give the maximum length in characters instead of bytes. A character is technically a codepoint of the database character set. CHAR and BYTE qualifiers override the setting of the NLS_LENGTH_SEMANTICS parameter, which has a default of bytes. The maximum length of VARCHAR2 data is 4000 bytes. Oracle compares VARCHAR2 values using nonpadded comparison semantics...



CREATE TABLE new_table (

COL_ID VARCHAR2(10 CHAR) NOT NULL,

COL_01 VARCHAR2(30 CHAR) NULL,

PRIMARY KEY (COL_ID) );



When this syntax is used connecting with O90 or ODBC the column sizes are multiplied by 3 or 4 depending on the NLS_CHARACTERSET when viewed in the database painter or in SQL select in the DataWindow Painter.



Currently as a trade-off the DATA_LENGTH for char and varchar2 columns

and the CHAR_LENGTH for the nchar and nvarchar2 datatype is shown.

With the Or9 interface also a connection to an Oracle 8 database can be made and this version does not have the qualifier construct. The painter therefor shows the number of butes for the char and varchar2 column and not the

number of chars as for nchar and nvarchar2 columns.



CR:344717
CR Number:   344717
Product Name:   PB Enterprise
Product Component:   DB OLE DB
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Feb 2004 Fixed
Description
PB 10 Beta: Using OLE DB to connect to MS SQL Server. When connecting to a newly created database that has no PB Cat tables, PB is unable to create the Cat tables and gives the error: "Catalog tables could not be created and are not available for use". PB 9 works fine.



CR:344735
CR Number:   344735
Product Name:   PB Enterprise
Product Component:   Installation
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Mar 2004 Fixed
Description
PB10Beta: Install/unistall DW.Net causes error if .Net Framework is not installed:

when (un)installing: Severe: .Net framework is not found, ADO .Net DB driver cannot be (un)registered.



CR:344738
CR Number:   344738
Product Name:   PB Enterprise
Product Component:   DB Other
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Mar 2004 Fixed
Description
PB 10 crashing when trying to connect to a SQL Server 2000 db via ADO.Net



CR:344753
CR Number:   344753
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 May 2007 Presently Not Targeted For Any Future Release Of This Product
Description
Requesting CR 309764 fix be applied to the PB 9.0.1 pbo7390.dll



CR:344791
CR Number:   344791
Product Name:   PB Enterprise
Product Component:   DW Expression
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 07 Feb 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
When a computed field in a DW has the expression eg. relativetime(compute_1, 360) and the computed field is accessed via eg.

getitemtime() or dot notation the result is always: 00:00:00
Workaround Description
 Enter in the expression for the computed field :

Time(String(RelativeTime( col_time , 360)))



CR:344797
CR Number:   344797
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 25 Mar 2004 Fixed
Description
Numeric or Decimal editmask get regression after PB9.0.1 build 6533.

The problem occur when try to modify the value after highlight the previous value.

When type "123.45", it become "001.23".



CR:344801
CR Number:   344801
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   Windows XP
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.2 01 Aug 2006 Fixed
13 Jun 2006 Presently Not Targeted For Any Future Release Of This Product
21 Sep 2006 Fixed
Description
PowerBuilder 9 executables that have been compiled with the option "New Visual Style

Controls" don't show the background colors of datawindow buttons and groupboxes when

run on XP.

This happens when XP uses a Theme and not when the display is set to Windows Classic in the control panel.



CR:344806
CR Number:   344806
Product Name:   PB Enterprise
Product Component:   Debugger
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 May 2005 Fixed
Description
Remote debugging of components in EAServer 4.2.2. Values set to null show values as set to zero or empty string.



CR:344811
CR Number:   344811
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.2.1 08 Jun 2007 Fixed
Description
The dbname generated by the DW painter is wrong when using a sql syntax and when the connected user is not the table owner.



CR:344819
CR Number:   344819
Product Name:   PB Enterprise
Product Component:   DW XML
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Mar 2008 Insufficient priority to fix
Description
If the columns appear in the wrong order in the imported XML file. The datawindow creates 2 or more rows for one row of the xml file, If the order is for instance like: col3 col1 col2





no workaround
Workaround Description
 non



CR:344831
CR Number:   344831
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Ability to convert Keycode to a string without using

a Choose case statement.



The keycode is a enumerated type for the keydown(), systemkey, key, pbm_dwnkey,pbm_lvnkeydown,pbm_renkey,pbm_tcnkeydown,pbm_tvnkeydown, keyevent ()

and now it must be converted and each keystroke checked.



CHOOSE CASE a_key // for a..z, we convert to lower case at the end of the function.

CASE keyA! ls_Key = 'A'

CASE keyB! ls_Key = 'B' //and so on for every character that there is on the keyboard.



CR:344832
CR Number:   344832
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement request for DW.NET. The Sybase.DataWindow.Blob object could include additional methods, notably a RowCount and perhaps a subdivision of how many inserts, deletes, and updates are individually included in the blob.



CR:344856
CR Number:   344856
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Apr 2004 Fixed
Description
After installing the PB10, the SoapConnection object in PB 90 fails.



CR:344860
CR Number:   344860
Product Name:   PB Enterprise
Product Component:   Language - Compiler
Status:   Open
OS:   Microsoft Windows NT
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement: Add an optional argument to the FileDelete function that would allow the user to empty the Recycle Bin.



CR:344864
CR Number:   344864
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.2.1 02 May 2007 Duplicate
Description
The Source Control context menuitems are hidden during SCC whenever a secondary thread is launched to refresh the SCC status cache. SCC requests are not allowed while the 2nd thread is running - however, you can continue to edit checked-out objects and perform other operations in the IDE. You will also see the word (Initialization) in the Library Painter title bar during this time.

10.2.1 EBFs and 10.5 EBFs built after 11/1/2006 contains fixes to prevent the system tree and library painter treeview from collapsing and scrolling unexpectedly after SCC refresh completes.



CR:344922
CR Number:   344922
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 11 Oct 2004 Fixed
Description
EditMask controls on windows. You cannot use the "." on the numeric keypad to enter decimal numbers in a editmask ###,###.00 if reginal settings are set to Spanish (Spain).



workaround: use the DW Edit Mask.
Workaround Description
 1. change the regional setting: Regional settings (Spanish), comma for the decimal symbol, dot for the digit grouping symbol

2. open PB and create a window with a numericmask! Edit Maks and the mask ###,###.00

3. start the window and try to enter to 4



CR:344973
CR Number:   344973
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 05 Apr 2004 Fixed
Description
When a ole control on a mdi sheet and several

sheets are opened and the ole controls are activated, switching between the sheets

shows inconsistent behavior that are listed below:



Once you open a sheet and activate the ole control, the mdi toolbar does not display.



After both sheets are opened and both controls are activated, once you switch back and set focus to the first sheet, it appears that the ole control is still activated but the original mdi menu shows (instead of the ole control menu and mdi menu merged together) with the toolbar from the ole control.



Now switch back and set focus on the second sheet, the original mdi menu appears but

the ole control still appears to be activated (you can still use the paint brush in the control.)



Now switch back to the first sheet again, the mdi menu appears and the ole control appears

to be deactivated. But if you switch back to the second sheet again, the ole control appears to still be activated. You cannot deactivate it.



CR:344974
CR Number:   344974
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 24 Jan 2008 Workaround
Description
Source Control Enhancement: Would like Powerbuilder to manage libraries automatically.
Workaround Description
 The workaround is to rebuild the project PBLs from scratch using Orcascript or PowerGen. Save all of your work_in_progress to a work PBL before using this technique.

start session

; Delete all pbls in target library list except the work.pbl

file delete "pbl1\mytargetpbl1.pbl" CLOBBER

file delete "pbl2\mytargetpbl2.pbl" CLOBBER

scc get connect properties "myworkspace.pbw"

scc connect

scc set target "mytarget.pbt" "refresh_all"

scc refresh target "full"

scc close

end session



CR:344977
CR Number:   344977
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer would like to see a NoMerge option listed

under the MergeOption on a menus property page.



The reason is the customer is using a mdi application a sheet contains a ole control.

When they use activate(inplace!), the customer does not want to see Ole control menu.

They only want to see the mdi applications menu.



CR:344979
CR Number:   344979
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Feb 2004 Fixed
Description
Although the PBVM readme.txt includes the following statement:



PowerBuilder components deployed to EAServer on a UNIX platform can have neither graphical dependencies nor dependencies on the Windows application programming interface.



It may not be obvious for some of the saveas filetypes (SYLK! or DIF!), which ones are not supported on unix. The documentation and online help should make this clearer.





I sent an email to engineering to verify what filestypes are supported on unix and here's

what I got:

PBVM Saveas Types Supported on Unix

Text!

CSV!

SQLInsert!

HTMLTable!

XML!

PSReport!

XSLFO!

PDF!



PBVM Not Supported on Unix

Excel!

Excel5!

SYLK!

WKS!

WK1!

DIF!

dBase2!

dBase3!

Clipboard!

WMF!



CR:345048
CR Number:   345048
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 22 Feb 2004 Fixed
Description
IF IsNull(double(the_structure.the_element))then ... //the_element is of type any



Regression: The above powerscript construction may cause crashes or painter hangs in

PowerBuilder 8 Build 10538 or later and in PowerBuilder 9 Build 7031 or later.





Additional fix info from PB Engineering:

The object which contains calls to system function IsNull() need to be rebuilt.



CR:345052
CR Number:   345052
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Feb 2004 Duplicate
Description
The following code causes PowerBuilder 10 to crash:

String err, s

SQLCa.DBMS="ODBC"

SQLCa.DBParm="ConnectString='DSN=EAS Demo DB V10'"

connect using SQLCA;

s = SQLCA.SyntaxFromSQL('select 1 as a from sys.systable', "", Err)



CR:345059
CR Number:   345059
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Open
OS:   Microsoft Windows NT
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Datawindow .Net: Enhancement Request for new overload(s) of GetItem/SetItem to accept array arguments, thus mimicing dot notation in PowerBuilder.



CR:345098
CR Number:   345098
Product Name:   PB Enterprise
Product Component:   Printing
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 26 Feb 2004 Fixed
Description
Consult: Printsend fails to print barcodes and icons properly in PB 9.x



CR:345102
CR Number:   345102
Product Name:   PB Enterprise
Product Component:   Install
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Mar 2004 Fixed
Description
PB10 Beta: Identification issue in Add/Remove Programs: Common Installer and Sybase Datawindow.Net do not have obvious version information displayed. You must click on the Support Information link to find it. This might be overlooked by some customers. It would be more consistent with other products and versions, and would not cause confusion to add the version in the title, such as "Sybase Common Installer 10.0" instead of "Sybase Common Installer".



CR:345104
CR Number:   345104
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 09 Mar 2004 Fixed
05 Sep 2004 Fixed
Description
Regression in 9.0: ScrollToRow fires rowfocuschanged before scrolling to the row.



3/1/2004 Fixed by PB Engineering:

Changed the dw.scrollrow function behavior:

Before: rowfocuschanging event and rowfocuschanged event were trigered before the scrolling action.

Now: rowfocuschanging event was trigered before scrolling action and rowfocuschanged event was trigered after the scrolling action.



CR:345181
CR Number:   345181
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.0 beta2 24 May 2004 Fixed
Description
Beta 10 issue: LibraryExport generating incorrect source code.



CR:345183
CR Number:   345183
Product Name:   PB Enterprise
Product Component:   DB Profile
Status:   Open
OS:   Microsoft Windows NT
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Deleting a utility in DB Profile painter does not prompt for delete confirmation.



CR:345189
CR Number:   345189
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.2 25 Feb 2004 Fixed
Description
SaveAsAscii("C:\TEMP\customers.txt","","","") creates a file with no data, instead of a file with no character separators, no quotes, and no line ending character.



CR:345198
CR Number:   345198
Product Name:   PB Enterprise
Product Component:   DW ActiveX
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Nov 2007 Presently Not Targeted For Any Future Release Of This Product
Description
When deploying a Datawindow ActiveX with a jdbc connection,

the pbvm90.dll and pbjvm90.dll are required whereas in pb80 you didn't have to

deploy pbvm.



CR:345199
CR Number:   345199
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Mar 2004 Not a Bug
Description
DataWindow.NET IsItemNull() returns true for a date column with the default initial value of 01/01/1900.



Update:

This turned out to be the same behavior as PB and so was deemed not a bug.



CR:345281
CR Number:   345281
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 08 Mar 2004 Fixed
Description
No input arguments are listed after generating

web services proxy with wsdl file.



The web services functions updatecircuitsummary, updateticketsummary and updateequipmentsummary have not input arguments listed after proxy is generated.



CR:345286
CR Number:   345286
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Oct 2007 Not reproducible with latest version of the product available as of Resolution Date
Description
The Power Tip text of an invisible Tab Page still displays in place of a visible tab page's Power Tip.



CR:345311
CR Number:   345311
Product Name:   PB Enterprise
Product Component:   Menu Painter
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 15 Mar 2004 Fixed
Description
In menu preview (WYSIWYG View) pane, menu items at the very right, and/or submenu items that are either long or sub-sub-sub...menu items, are truncated, even when the horizontal scrollbar is present, it does not allow scrolling to the very end.



CR:345382
CR Number:   345382
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 May 2004 Fixed
Description
Open an empty script window, enter the following text: int a[9, compile it, correct the error by closing bracket and deleting the '9', recompile a couple of times. PB crashes
Workaround Description
 non



CR:345429
CR Number:   345429
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Open
OS:   Microsoft Windows NT
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement Request: When in a script painter users should be allowed to open other classes and functions by performing a certain action (e.g. right click) on a class.function_Name



CR:345430
CR Number:   345430
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 29 Mar 2004 Fixed
Description
With an ODBC connection to Oracle something is limiting the number of characters to 1000 for a bind variable parameter.



CR:345435
CR Number:   345435
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Apr 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
PowerBuilder crashes when altering the SQL of a datawindow with Oracle native connection via O84 driver.



CR:345533
CR Number:   345533
Product Name:   PB Enterprise
Product Component:   Rich Text
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 02 Mar 2004 Fixed
Description
Under Native Traditoinal / Simplified chinese Windows 2000, the Richtext Edit Control does not show Truetype Fonts in the drop down listbox on the toolbar. Only fixed size fonts available.



Can manually type the Fonts Name at the RTE dropdown listbox. But not possible if try to use Double Byte Character Fonts.





Workaround:

Install a default printer.



CR:345547
CR Number:   345547
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.2 15 Jun 2004 Fixed
10.0 04 Jul 2005 Fixed
Description
Background threads for status updates are started if you double-click on PBL or by clicking on the + icon to the left of the PBL name, but not just by single clicking on the PBL itself -> Library Painter.



CR:345554
CR Number:   345554
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   Windows XP
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jun 2004 Fixed
04 Jul 2004 Fixed
Description
Group box control on a dw with a text colour set eg. to windows text shows up as black when run via exe when exe is created with XP style visual controls.

The default should be blue in XP default style.

The groupbox window control behaves as expected, it will show the text in blue.



CR:345563
CR Number:   345563
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.2 14 Sep 2004 Fixed
Description
When expanding a pbl in the library painter, causes

a lag time before the expanded pbl appears in the listview. Cpu usage can reach

up to 100% and the hourglass appears.



CR:345581
CR Number:   345581
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11.0 Beta2 29 Nov 2006 Fixed
Description
When status refresh is performed on an individual object,

the position of the selected object is changed once the refresh completes.





Problem was reported for the system tree and library painter



CR:345593
CR Number:   345593
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jul 2004 Fixed
11 Aug 2004 Fixed
Description
User has objects with 40 character names. SccDiff (quiet mode) fails with log message:

DIFF2002 SccDiff error. Unable to read PBL source for (f_add67890123456789012345678901234567890.srf).



CR:345597
CR Number:   345597
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement Req: Source control window that shows up on "Add to Source control" action or "Get Latest Version" action should have diagonal marks at the bottom to indicate that it is resizable. Also, it should remember it's previous size.



CR:345727
CR Number:   345727
Product Name:   PB Enterprise
Product Component:   PD Integration
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
There are inconsistencies in the IDE behavior between PB and PD that should be resolved.



CR:345735
CR Number:   345735
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 22 Mar 2004 Fixed
Description
SyntaxFromSQL is generating incorrect syntax. Before the syntaxfromsql is called, several functions are called. They call the sp_helprole(),sp_helprolemember() and sp_helpsrvrolemember(). If the datawindows are commented out that execute these sp, than syntaxfromsql works ok.



The sql that is generated is:

column=(type=char(20) updatewhereclause = yes name=uf_contr_glbuh_name dbname="DocALF_摒桎梓羼觐錩腓鲱__single_1_0001.uf_contr_glbuh_name")

column=(type=char(43) updatewhereclause = yes name=uf_contr_nabor_razd_buh dbname="DocALF_摒桎梓羼觐錩腓鲱__single_1_0001.uf_contr_nabor_razd_buh")

column=(type=char(43) updatewhereclause = yes name=uf_contr_nabor_razd_fin dbname="DocALF_摒桎梓羼觐錩腓鲱__single_1_0001.uf_contr_nabor_razd_fin")

column=(type=char(43) updatewhereclause = yes name=uf_contr_razdel dbname="DocALF_摒桎梓羼觐錩腓鲱__single_1_0001.uf_contr_razdel")

column=(type=char(43) updatewhereclause = yes name=uf_contr_glbuh_name_1 dbname="DocALF_摒桎梓羼觐錩腓鲱__single_1_0001.uf_contr_glbuh_name")

column=(type=long updatewhereclause = yes name=uf_doc_id dbname="uf_doc_id")

column=(type=char(20) updatewhereclause = yes name=uf_contr_acc_section dbname="uf_contr_acc_section")

column=(type=char(20) updatewhereclause = yes name=uf_contr_buh_section dbname="uf_contr_buh_section")

column=(type=char(20) updatewhereclause = yes name=uf_contr_glbuh_name_2 dbname="uf_contr_glbuh_name")

column=(type=char(50) updatewhereclause = yes name=uf_contr_nabor_razd_buh_1 dbname="uf_contr_nabor_razd_buh")

column=(type=char(50) updatewhereclause = yes name=uf_contr_nabor_razd_fin_1 dbname="uf_contr_nabor_razd_fin")

column=(type=char(30) updatewhereclause = yes name=uf_contr_razdel_1 dbname="uf_contr_razdel")



Instead of:

table(column=(type=char(20) updatewhereclause=yes name=uf_contr_glbuh_name dbname="DocALF_摒桎梓羼觐錩腓鲱__single_1_0001.uf_contr_glbuh_name" )

column=(type=long updatewhereclause=yes name=uf_doc_id dbname="DocALF_摒桎梓羼觐錩腓鲱__single_1_0001.uf_doc_id" )

column=(type=long updatewhereclause=yes name=uf_doc_id dbname="DocALF_摒桎梓羼觐錩腓鲱__single_1_0001.uf_doc_id" )

column=(type=long updatewhereclause=yes name=uf_doc_id dbname="DocALF_摒桎梓羼觐錩腓鲱__single_1_0001.uf_doc_id" )

column=(type=long updatewhereclause=yes name=uf_doc_id dbname="DocALF_摒桎梓羼觐錩腓鲱__single_1_0001.uf_doc_id" )

column=(type=long updatewhereclause=yes name=uf_doc_id dbname="DocALF_摒桎梓羼觐錩腓鲱__single_1_0001.uf_doc_id" )

column=(type=char(20) updatewhereclause=yes name=uf_contr_acc_section dbname="DocALF_摒桎梓羼觐錩腓鲱__single_1_0001.uf_contr_acc_section" )

column=(type=char(20) updatewhereclause=yes name=uf_contr_buh_section dbname="DocALF_摒桎梓羼觐錩腓鲱__single_1_0001.uf_contr_buh_section" )

column=(type=char(20) updatewhereclause=yes name=uf_contr_glbuh_name dbname="DocALF_摒桎梓羼觐錩腓鲱__single_1_0001.uf_contr_glbuh_name" )

column=(type=char(50) updatewhereclause=yes name=uf_contr_nabor_razd_buh dbname="DocALF_摒桎梓羼觐錩腓鲱__single_1_0001.uf_contr_nabor_razd_buh" )

column=(type=char(50) updatewhereclause=yes name=uf_contr_nabor_razd_fin dbname="DocALF_摒桎梓羼觐錩腓鲱__single_1_0001.uf_contr_nabor_razd_fin" )

column=(type=char(30) updatewhereclause=yes name=uf_contr_razdel dbname="DocALF_摒桎梓羼觐錩腓鲱__single_1_0001.uf_contr_razdel" )



In the w_err_debug/cb2, the f_set_alefuserrole is called. That calls the f_check_alefuserrole and f_check_user_admin, f_check_db_role.



CR:345738
CR Number:   345738
Product Name:   PB Enterprise
Product Component:   Install
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Feb 2004 Fixed
Description
PB 10 Beta ( build 3007): DW.Net install creates incorrect registry entry: HKEY_LOCAL_MACHINE\SOFTWARE\SOFTWARE\Sybase\DataWindow.Net

instead of: HKEY_LOCAL_MACHINE\SOFTWARE\Sybase\DataWindow.Net



CR:345763
CR Number:   345763
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Mar 2004 Fixed
Description
DLL version information obtained through Win APIs calls GetFileVersionInfoSize, and GetFileVersionInfo on PowerBuilder dlls such as pbvm100.dll, do not contain build version information in 10.0. This is a regression from 9.0 PB dlls which do return build information.



CR:345904
CR Number:   345904
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Apr 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
OLE - Microsoft Web Browser does not resize in PowerBuilder Build 7066 and higher when changes are made to the width and height properties using UnitsToPixels.



CR:345980
CR Number:   345980
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 29 Apr 2004 Fixed
Description
PB8 regression (works correctly using PB 9.0.1): QueryMode doesn't work edit mask columns on a PB/EAS application. Follow up on CR 300746.



Workaround:

Use PB9.

IN PB8: Use a Dw column that has no edit mask defined.



CR:346011
CR Number:   346011
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
Numerous processes are lefting hanging on the Oracle server

machine, Powerbuilder does not close a connection to the Oracle TNS listener.
Review Status
 4/22/2005

09/15/2003:

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



CR:346025
CR Number:   346025
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 24 Feb 2004 Fixed
Description
Hebrew not rendered in OLE call from a PB component.



CR:346028
CR Number:   346028
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
When connected via OLE DB to MS SQL Server, PB crashes trying to add a retrieval argument to a DataWindow where clause.



CR:346046
CR Number:   346046
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In the Examples, the icon that means "enhanced since 5.0" is a bulldozer and that can be mistaken to mean "under construction".



CR:346055
CR Number:   346055
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Mar 2004 Fixed
Description
A regression in PB 10.0. Command buttons with the default and cancel properties checked are not working.



CR:346057
CR Number:   346057
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Feb 2004 Fixed
Description
GetItemTime and GetItemDateTime functions throws exception in Datawindow.Net when a datetime column has a non zero value in the millisecond part.



Exception information is:

An unhandled exception of type 'System.ArgumentOutOfRangeException' occurred in mscorlib.dll



Additional information: Valid values are between 0 and 999, inclusive.



CR:346058
CR Number:   346058
Product Name:   PB Enterprise
Product Component:   DB OLE DB
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Feb 2004 Fixed
Description
When executing stored procedure using OLEDB driver on Microsoft SQl Server 2000 , a 5 character input parameter is returned as an output parameter. It is returned as 4 characters.



CR:346124
CR Number:   346124
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement request to increase the allowable length of identfier names.



The current limit is 40 characters (see on-line help on identifiers).



CR:346131
CR Number:   346131
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 17 May 2005 Fixed
07 Oct 2004 Fixed
Description
New Feature Request: When EAServer is using FOP generator to produce the PDFs, it spews out a lot of unwanted information in the Jaguar.Log. Customer needs a switch from PB to turn off these messages to be written in Jaguar.log.



PB Engineering:

We introduced an environment variable called as PB_FOP_SUPPRESSLOG. When it is set to 0 (or not set), PB will default to the normal behavior and continue to log into the jaguar.log. If it is set to 1, PB will not not log into into the jaguar.log.



CR:346138
CR Number:   346138
Product Name:   PB Enterprise
Product Component:   DB Profile
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Support the AppName and Host dbparms for all databases

and include them on the database profile setup.



Currently AppName is supported with SYC, DIR and MSS and Host is supported with MSS and

SYC.



CR:346159
CR Number:   346159
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 20 Nov 2005 Fixed
Description
Resizing a dw control on a tabpage is resizing the entire user object tab control.



CR:346230
CR Number:   346230
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 03 Jul 2005 Fixed
Description
A validation rule is set on a column having a dropdowndatawindow.

When the value is changed to NULL using the dddw then the validation

rule and validation message may fire, but still the focus is allowed to change.



To disallow it enable the required property of the column.



CR:346258
CR Number:   346258
Product Name:   PB Enterprise
Product Component:   DB Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Feb 2004 Fixed
Description
When trying to create a new table in the DB Painter there is only one choice for a datatype and that is 'char'. All other datatypes are missing.



CR:346261
CR Number:   346261
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Open
OS:   Microsoft Windows NT
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement Request: Add support for the PNG (Portable Network Graphics) image file format. See details about PNG image file at: http://www.w3.org/Graphics/PNG/



CR:346264
CR Number:   346264
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Mar 2004 Not reproducible with latest version of the product available as of Resolution Date
Description
Column names are missing when creating a datawindow with a 'where' clause.



CR:346270
CR Number:   346270
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 29 Mar 2004 Fixed
Description
Entering a value after highlighting a numeric column having editmask , ignores the 1st keystroke. For example if you try to enter a number say 25 , it will enter just 5.



CR:346271
CR Number:   346271
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jul 2005 Not a Bug
01 Mar 2006 Not a Bug
Description
Changing the Format to Configure property on the Data Export tab to PDF from XML does not display properly in the painter but is changed correctly in the source code.



CR:346339
CR Number:   346339
Product Name:   PB Enterprise
Product Component:   DB DB2
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.2 12 Apr 2004 Fixed
Description
DB2 8.1.

selectblob does not work when using the IBM ODBC driver 4.1.

Works with DataDirect 4.2 driver.



CR:346366
CR Number:   346366
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.0 beta2 3026 25 Feb 2004 Fixed
Description
In 10.0 a number of SaveAs enumerated types have been removed from the product. However in the PB Code examples for the WebDW we supply a pbl (Pbdwrmt.pbl) that still references the old enumerated types, and thus does not compile any more.



CR:346389
CR Number:   346389
Product Name:   PB Enterprise
Product Component:   DB Trace
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When tracing between different PB versions, the formatting is different in the log file. For example, if you generate a pbtrace.log for PB 9 and then switch to PB 10 (or vice versa) and use the same pbtrace.log file, the pbtrace.log will show:



(124dd08): ROLLBACK: (0 MilliSeconds)

(124dd08): DISCONNECT: (20 MilliSeconds)

(124dd08): SHUTDOWN DATABASE INTERFACE: (0 MilliSeconds)



/ * - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - * /



/ * 0 2 / 1 3 / 0 4 1 3 : 3 3 * /



/ * - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - * /



( 1 1 7 6 5 d 4 ) : D I A L O G C O N N E C T T O T R A C E O D B C :



( 1 1 7 6 5 d 4 ) : D B P A R M = C o n n e c t S t r i n g = ' D S N = E A S D e m o D B V 1 0 ; U I D = d b a ; P W D = s q l ' ( 3 7 5 5 M i l l i S e c o n d s )



( 1 1 7 6 5 d 4 ) : T A B L E L I S T : ( 1 7 0 M i l l i S e c o n d s )



( 1 1 7 6 5 d 4 ) : C O L U M N S I N F O R M A T I O N : T A B L E = d e p a r t m e n t O W N E R = d b a



It doesn't matter if you start with PB 10 and then switch to PB 8 or 9 or vice versa,

the log file will show a different format.



CR:346415
CR Number:   346415
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement: The SaveAs method for DataWindows has a Clipboard! option (SaveAsType enumerated value), but the "Save Rows As..." -> options ('Save as type') in the DataWindow painter doesn't. That would be nice to have there too.



CR:346417
CR Number:   346417
Product Name:   PB Enterprise
Product Component:   DW XML
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.0 4043 08 Jun 2004 Fixed
Description
Retrieved data for Web XML Datawindow is not displaying

in a Netscape browser. The trace file shows that it retrieved the data ok and shows:



Entering SetBrowser('Mozilla/5.0 (Windows; U; WinNT4.0; en-US; rv:0.9.4.1) Gecko/20020508 Netscape6/6.2.3') .



However, instead of the retrieved data the following appears:

DataWindow output goes here



When I highlighted this text and selected View Frame Source, the following appears:

xml = loadDocumentIE(xmlfile);

xsl = loadDocumentIE(xslfile);

doTransform();



function loadDocumentIE(filename) {

var document = new ActiveXObject("MSXML.FreeThreadedDOMDocument");

document.async = false;

document.load(filename);

return document;

}



function doTransform() {

var xslTemplate = new ActiveXObject("MSXML2.XSLTemplate");

xslTemplate.stylesheet = xsl;

var processor = xslTemplate.createProcessor();

processor.input = xml;

processor.transform();

document.getElementById("webDW").innerHTML = processor.output;

}



CR:346478
CR Number:   346478
Product Name:   PB Enterprise
Product Component:   System Runtime Functions
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jun 2005 Fixed
Description
Idle function does not work when Windows taskbar is auto hide and the taskmanager is minimized.
Workaround Description
 workaround : using FindWindowA and PostMessageA

APIs to close the task manager before the Idle function call



CR:346526
CR Number:   346526
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jun 2004 Not a Bug
Description
When trying to update a datawindow, getting the error

message of "Row changed between retrieve and update". The column that is generating

the error is of type number and in mss sql server that column is defined as a float.



According to engineering, a number has a 15 digit precision. If the column has 14 digits of precision, the update works ok but 15 or more, the value does not show up properly and

when trying to update, getting the row changed between retrieve and update.



31.60000000000005 (14 digits of precisions, update works ok)

31.600000000000005 (15 digits of precision, update fails)



CR:346570
CR Number:   346570
Product Name:   PocketBuilder
Product Component:   DW - Runtime
Status:   Closed
OS:   Pocket PC 2003
Original Version:   1.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
378 14 Mar 2004 Fixed
Description
PocketPC-2003 only. PocketPB 1.5.1 beta only (ok in 1.5)

Switching between different graph legend location (top, bottom, left, right) or between graph types (bar, pie, line etc).

The moment I change the graph legend location or graph type, the graph application will exit.



CR:346571
CR Number:   346571
Product Name:   PB Enterprise
Product Component:   Debugger
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Add an option that enables / disables debugger behaviour when an exception occurs.



enables - always jump into debugger if exception occurs (behaviour in PB9)



disables - no debugger jump back to the debugger - code will be continued - display the PB Application Error messagebox and exit to the debugger only if an uncaught runtimeerror was encountered.



CR:346742
CR Number:   346742
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 23 Mar 2004 Fixed
Description
Using a SelectBlob in embeded SQL causes a memory leak when connected using the IN9 driver for Informix.



CR:346760
CR Number:   346760
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Dec 2004 Fixed
Description
The Profiler is crashing when viewing a pbp file. A pbp file opened with Profiling Routine View gets "Array boundry exceeded at line 22 in function of_displaysource of object k70_base" error after clicking on rows in the Called By pane.



CR:346830
CR Number:   346830
Product Name:   PB Enterprise
Product Component:   Cgen
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Feb 2004 Not a Bug
Description
Cannot regenerate an application when external functions are defined with character @.



Per PB Engineering, this is not a bug:

From the PowerBuilder Help (pbhlp90.hlp) in PB9 directory. Open it, and select "Index", enter "identifier names", then we will find the following documentation:

Rules for identifiers:



Must start with a letter or an _ (underscore)

Cannot be reserved words (see "Reserved words ")

Can have up to 40 characters but no spaces

Are case insensitive (PART, Part, and part are identical)

Can include any combination of letters, numbers, and these special characters:



- Dash

_ Underscore

$ Dollar sign

# Number sign

% Percent sign



Sample Solution:

Change the external function call from:

FUNCTION int _b_actfil@4 (ref string nk) LIBRARY "simplebd.dll"

to:

FUNCTION int _b_actfil( ref string nk ) LIBRARY "simplebd.dll"



CR:346838
CR Number:   346838
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Apr 2004 Third Party Problem
Description
E:

Application designed using Sybase PowerBuilder (PB)V9.0.1 accesses DB2 UDB Binary Large Object (BLOB) data - all on Windows 2000



B:

PB application works correctly with IBM DB2 V7.1 Client and IBM DB2 V7.1 Server.



However, it encounters ODBC Function Sequence error when accessing IBM DB2 V8.1 using IBM DB2 V8.1 Client, PB's UPDATEBLOB receives the following ODBC error:



>[S1010] [Microsoft][ODBC Driver Manager] Function sequence error



NOTE

The PB Application receives the above error whenever it attempts to execute UPDATEBLOB to modify a BLOB column in a database on the DB2 UDB V8.1 Server

Switching from the IBM DB2 Connect V8.1 Client to DataDirect DB2 UDB Driver V4.2 allows the UPDATEBLOB procedure to execute successfully



Notes Apr 7, 2004 - The above is not a Sybase PB product issue!

IBM (through TSANet call) has diagnosed a defect in DB2 Connect Client software - see IBM APAR JR19872 (see URL below):

http://www-306.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/aparlib.d2w/display_apar_details?aparno=JR19872
Workaround Description
 Use the DataDirect 4.2 Wire Protocol ODBC Driver 4.20.00.25 to access DB2 UDB V8.1



CR:346849
CR Number:   346849
Product Name:   PB Enterprise
Product Component:   DW Expression
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Mar 2009 DEFER
Description
Wrong computation in an expression on W2000 Arabic



CR:346850
CR Number:   346850
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Apr 2004 Fixed
Description
A datawindow with validation criteria is failing validation when it shouldn't. Working fine in PowerBuilder 10.



CR:346883
CR Number:   346883
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Apr 2004 Fixed
Description
Using the Oracle O84 interface, varchar2 fields show garbage characters in the database painter via Edit Data, and in the datawindow painter in the Preveiw View.



CR:346900
CR Number:   346900
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Mar 2004 Fixed
Description
IsItemNull is returning false when it should be returning true.



CR:346977
CR Number:   346977
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 15 Mar 2004 Fixed
Description
datawindows where the rows are separated by lines. When previewed these lines are absent and printed erratically. When the dw is sent to the printer, the gap between the columns increases by centimetres



no workaround



CR:347013
CR Number:   347013
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Open
OS:   Windows XP
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When you run an application that includes the new visual controls, the radiobutton and checkbox controls display differently whether they are on a window or displayed within a datawindow control. When the object gets focus the behavior in Windows 2000 was that the text of the control gets a border outline rectangle which shows that the object has focus.



On Windows XP the objects on the radiobutton and checkbox controls placed on the window do not show this focus rectangle but they do within the datawindow control. They should follow the XP standard behavior and should be consistent whether on a window or within a datawindow control.



CR:347017
CR Number:   347017
Product Name:   PB Enterprise
Product Component:   Language - Compiler
Status:   Open
OS:   Microsoft Windows NT
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer requests that all functions that return a numeric index for items in a LISTBOX control have a return type of LONG. Currently the return type is INTEGER. However, a directory can contain > 32768 entries invalidating any index returned if populated with DIRLIST. To accomodate this, these functions to return LONG. (Examples: AddItem, SelectedIndex, etc.)



CR:347069
CR Number:   347069
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement: Allow multi-select of columns to make their edit styles the same.



CR:347071
CR Number:   347071
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enh: Provide a function that would return the SCC status of an object.



CR:347073
CR Number:   347073
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
When users double click an editable col in a DW (editmask [currency(14)]), the value in the col is highlighted. When type a new value the 1st number typed clears the value instead of inputting the value. This has changed since PB 8.0.3.





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