远程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:212568
CR Number:   212568
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Open
OS:   Microsoft Windows 98
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement request:-
The datawindow object has a column object. This enhancement request is for the datawindow column object to have an 'IgnoreDefaultButton' property. With respect to the column object, <CTRL><ENTER> needs to be pressed for specifying new line.
If press <ENTER> on the column object, the dw control loses focus and a window control receives focus e.g. cmdbtn.

This property exists for window multi-line edit control (mle).
Workaround Description
 Partial solution/workaround which needs refining for the customer's exact needs.
There will be screen flickering because the key toggles focus for the default cmdbtn and the dw control.



CR:212571
CR Number:   212571
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.x Catalina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2004 EOL'd version. Not to be Fixed.
Description
Background color is not set for a web datawindow in
internet explorer 5.0. For netscape 4.5 and 4.7, background color shows
as a border around columns and text fields.

Background color is ok with internet explorer 4.0.



CR:212574
CR Number:   212574
Product Name:   PB Enterprise
Product Component:   Debugger
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Sep 2000 Not reproducible with latest version of the product available as of Resolution Date
Description
Setting a watch on a variable that is a member of an object that is instantiated in script causes a GPF in the debugger when the debugger starts.



CR:212576
CR Number:   212576
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)
13 Apr 2000 Fixed
Description
Inconsistent editmask behavior with ####0
Verified fixed in 7.0.2 build 8024.



CR:212608
CR Number:   212608
Product Name:   PB Enterprise
Product Component:   P-Code Deployment
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.0.04 18 Apr 2000 Fixed
Description
Running a pb 6.5.1 app exe and a pb 5.0.04
app exe will crash the pb 5.0.04 app. Getting error of:

Application Error
PBstb050 caused a general protection fault in
module pbrtf050.dll at 0020:2d21

Problems happens when creating a transaction object in pb 5.0.04 app. Gpf
happens randomly. Crash will happen after creating 10 transactionsobjects or
14. Crashes in same place. Also doesn't matter the order that the apps run in.
For example, running the pb 6.5.1 app first and then the pb 5.0.04 app will still
crash and vice versa.
Workaround Description
 Works ok with pb 7.0 and pb 5.0.04 app. Migrate pb 6.5.1 app to 7.0 and run.



CR:212617
CR Number:   212617
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.0.00 8015 07 Mar 2000 Fixed
Description
When PowerBuilder connects to Oracle using an Oracle 7 native driver, it attempts to open a cursor immediately after the successful connection. If this cursor open fails, the error is not handled porperly, causing a GPF as soon as the Oracle Cursor Data Area (CDA) is referenced.

This had not been a problem until the Oracle 7 drivers were used with the Oracle 8 client. If you install Oracle 8.1.5 after having installed an earlier Oracle 8 client, there may be residual references to the earlier Oracle client release in the registry that caused the cursor open failure.
Workaround Description
 If you have Oracle 8.1.5 installed and you previously had an earlier version of Oracle 8 client installed, search the registry for all Oracle references and remove/fix those references that still point to the old release.



CR:212655
CR Number:   212655
Product Name:   PB Enterprise
Product Component:   DB OLE DB
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.x Catalina 16 May 2001 Fixed
Description
OLE-DB. An UpdateBlob request causes OLE-DB driver to hang and CPU resources to soar to 100%.



CR:212764
CR Number:   212764
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
Two differents components with a function named "getname". When deployed to Jaguar server the function
name are changed to getname__SS and getname__SL. Even they are no inheritance link between them. When deployed using seperate project it's ok.
Workaround Description
 Always use different project



CR:212772
CR Number:   212772
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2004 EOL'd version. Not to be Fixed.
Description
PB Version and Build: WDK 1.1.0 and PB 7.02 Build 8009

If the shift key is pressed after sending WM_SYSCOMMAND with SC_MOVE parameter, the shift key is not detected on the client.

For example, with WDK, if user clicks RMB on the title bar of a window and selects MOVE from the pop menu the SHIFT key is not detected if used afterwards.

In a non-WDK environment the SHIFT key is detected and any move of the mouse after SHIFT has been pressed results in the window moving (mouse click to quit this mode)

If we code the equivalent in PB...

Send(HANDLE(parent), 274, 61456, "")

Then hit the shift key, a move of the mouse will move the window/control.
The same example when run remotely using the WDK does nothing. Sending a SHIFT message - with
Send(HANDLE(parent), 256, 16, 0)
will not help.
Workaround Description
 Press any ARROW key once. Same result as wanted from the SHIFT key.



CR:212776
CR Number:   212776
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 8026 01 Aug 2000 Fixed
Description
The Master/Detail linkage for 2 web datawindow on the same page failed to link when any buttons on the html dw is clicked. This work in EAS 3.01



CR:212780
CR Number:   212780
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
Each of the columns in the DW are protected using the following syntax:
dw_1.Modify("id.Protect = '1~tIF(IsRowNew(),0,1)'")
If a new row is inserted into the DW and if the focus changes to a row which is currentrow - x, the getrow() function returns currentrow instead of currentrow - x.



CR:212782
CR Number:   212782
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
Columns on a datawindow have a transparent background so it will display whatever color is set for the background. This is fine until you modify the background color of the datawindow. The column will display the new color only to the size of the text in the column. So if you have the column size larger than the text size, whatever is 'extra' for the size of the column still displays the original datawindow background color.

An easy workaround is to change the background color of the column.



CR:212795
CR Number:   212795
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Apr 2000 Fixed
Description
When a datastore is the source for a share with a datawindow control, a GPF may occur if there is code in the RowFocusChanging() event that alternates whether a row will change or not AND code in the RowFocusChanged() event that protects a column. This may occur during an InsertRow() function is called and a ScrollToRow() is issued after.

If the above conditions are not met, then a GPF will not occur.

Crash occurs after approximately 150 rows entered into the datastore.



CR:212802
CR Number:   212802
Product Name:   PB Enterprise
Product Component:   GenApp
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Pb crashes on a file/close of a sheet in the genapp (application template).

On win95 or 98 the error message is:
PB60 casued an invalid page fault in pbvm60.dll at 0137:112dd03a

Problem happens for a pcode executable. Works ok for a machine code exe
and in PB 7.0.
Workaround Description
 From FBashaw, in the of_enableprint in the w_genapp_frame change the following:

this.post event ue_EnablePrint (ab_enable) // change this line from:
this.trigger event ue_EnablePrint(ab_enable) // change to this



CR:212809
CR Number:   212809
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0 Beta 3 3120 19 Jan 2001 Fixed
Description
Drawing objects: dropdown color wells seemed to be reversed when changing colors.



CR:212810
CR Number:   212810
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)
16 Mar 2004 EOL'd version. Not to be Fixed.
Description
Drawing Objects: Design control & Preview pane not always in sync



CR:212811
CR Number:   212811
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
A dw.reset() does not free up all memory used in the datawindow
Workaround Description
 Re-assigning the dataobject recaptures all the memory.



CR:212813
CR Number:   212813
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Aug 2000 Presently Not Targeted For Any Future Release Of This Product
Description
Oracle allows column names with non-standard characters as long as they are enclosed in double-quotes when they are used in SQL statements. When I try to create a datawindow with such a column, I get errors as follows:

O73 -> ORA-00904 Invalid column name
O84-> ORA-00911 invalid character



CR:212851
CR Number:   212851
Product Name:   PB Enterprise
Product Component:   DW Plugin
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Fixed
Description
Regarding downward compatibility for viewing PB v5 PSR reports in a PB v6.5.x plugin :-
PowerBuilder DataWindow Plug-in npdwexx.dll for v651.x loads the v5.x psr however the display shows the column widths as wider.

Also for large and complicated reports, there is truncation, overlapping, shifting of data
on PB v5 PSR reports when viewed in PBv6.5.1.x plugin. Customer has provided
sample psr reports.
Workaround Description
 Partial solution/workaround:
In PB6.5.x, load the v5 PSR into a datastore. Use the SaveAs function to save it to PSReport! format and this will save a v6.x psr version.



CR:212856
CR Number:   212856
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jun 2000 Fixed
Description
A dw editmask of #,###.00 does not restrict the number
of decimal places if the number is less than zero.

Using a edit mask of #,###.00 when entering .666666666 doesn't restrict
you from entering the number. When you tab off the column, the value
becomes .67. When using a editmask of #,##0.00, the editmask does
restrict you from entering the number and it doesn't round up. It leaves the
column value at .66.

Entering a value of 5.66 does restrict the number after the decimal using
#,###.00 in PB 6.5.1.

Editmask works ok in PB 7.0 (build 8011). When entering a value in a
editmask of #,###.00, it only allows you to enter .66. When you tab off, value
stays at .66.
Workaround Description
 If possible, use the editmask of #,##0.00. In this case,
the customer has a data entry application and the #,##0.00
has limitations because if you enter 1 and tab off, you get
10.00.



CR:212863
CR Number:   212863
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
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 column is not wide enough to contain all of an
editmask and the column is not justified or left justified, the number of digits entered
is not restricted. You can enter more digits than the editmask allows.
Workaround Description
 Use column property of justify or left justified.



CR:212890
CR Number:   212890
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
The HTML Datawindow 'HTMLGenerator' component does not handle inserting a new row well when a query returns no rows. Most applications will insert a new blank row in this condition for user input. (like an InfoMaker form) You have to modify the component to get it to insert a row in the "0" retrieve case which defeats the purpose of using the "gold" component.

In the general case, this would be required only if an INSERT button (with insert action) and an UPDATE button was in the datawindow. In the case of a reporting application or an application that just does updates, you would not want a row inserted on a retrieve that returned 0 rows.



CR:212895
CR Number:   212895
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 8046 27 Jun 2000 Fixed
Description
6.5 EBF/7.0.2 Regression. Group headers scrolling up in non-print preview mode. Data or text objects in the group header should remain stationary when the datawindow is NOT in print preview (but in just preview mode) and the user scrolls using the arrows at the top/bottom of the scrollbar.

Regression started around 6.5 build 1131 or November 16th, 1999 builds. This affects 7.0x and 8.x builds of the same date. 7.0.2 8003 works.



CR:212907
CR Number:   212907
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 1159 25 Feb 2004 Fixed
Description
Oracle with EBCDIC data format, Datawindow may display erroneous data or identify NUMBER(x,x) columns incorrectly.



CR:212918
CR Number:   212918
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Feb 2000 Fixed
Description
Pb crashes on scrolltorow function in pbdwexx.dll when
a column object of type radio button or ddlb has the lowest tab sequence
number in the dw.

Happens on the following code:

datawindowchild dwc_termido
dw_1.getchild("column",dwc_termido)
dw_1.insertrow(0)
dwc_termido.scrolltorow(0)

Pb crashes on the dwc_termido.scrolltorow(0). If you change the tab sequence to something other than
the lowest, than no crash.

Worked ok in PB 6.5.1 (build 620,1094,1097,1102,1107 and 1117). Crash
begins in 1127. Works ok in pb 8.0 (build 1233).
Workaround Description
 Change the tab sequence of the radio button to something
other than the lowest sequence number. After the scrolltorow
function, use settaborder to change it back to the lowest number
if you need to.



CR:212980
CR Number:   212980
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)
30 Jan 2001 Fixed
Description
Computed fields containing Retrieval Arguments as expression do not show values eg. in the Header band when no rows are retrieved. This could be caused by the change of behavior from PB 6 to PB 7 of not showing null values in computed fields in a datawindow when no rows are retrieved.



CR:213029
CR Number:   213029
Product Name:   PB Enterprise
Product Component:   UO Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2004 EOL'd version. Not to be Fixed.
Description
The following instance variable declarations causes PB version 7.x to GPF after a full rebuild:

constant integer ii_one = 1
constant integer ii_two = 2

constant integer ii_divide = ii_two / ii_one //Causes GPF
constant integer ii_multiply = ii_one * ii_two //Causes GPF



CR:213030
CR Number:   213030
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)
25 Feb 2004 Fixed
Description
If you have many objects (50 plus) in your PBL and in the library painter if you scroll down to the last object in the listview and perform a regenerate on that particular object. The scroll position resets itself to the top of the listview. The object will still be highlighted if you scroll back down to it using the vertical scroll bar.
Workaround Description
 Regenerate using the left viewing pain.



CR:213060
CR Number:   213060
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Garbage values appear in static crosstab datawindow for Values section.
Problem appears for 'display numeric' values and 'display numeric as string' values.
Workaround Description
 None.



CR:213071
CR Number:   213071
Product Name:   PB Enterprise
Product Component:   Application Painter
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
It is possible to specify a command line arg for a WDK PB app in the launch file. It would be useful to have an option to permit the Username and Domain (supplied for WDK client login) to be passed in the commandline arg for the PB app to use.



CR:213122
CR Number:   213122
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jun 2008 Fixed
Description
computed fields shouldn't round decimal values.

Problem: computed fiels are rounding decimal values (18 digits) becuase computed fields using double values (15 digits).



Workaround: calculate decimal values in PowerScript and not with computed fields.
Workaround Description
 calculate decimal values in PowerScript and not with computed fields.



CR:213126
CR Number:   213126
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)
8.0 Beta 1 29 Mar 2000 Not reproducible with latest version of the product available as of Resolution Date
Description
PB 7 GetFullState fails when a stored procedure update capability with expression has been declared.
Also fails when a computed field is declared.
Datawindow Error: Line: x Column:xx



CR:213151
CR Number:   213151
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Feb 2000 Third Party Problem
Description
Customer has MIcrosoft Pen Drivers installed on a WIN95 machines and when running in the PB development environment they appear to function as they function within other programs. When functioning properly they show a capital A at the beginning of each editable field that indicates that if the A is clicked a virtual keyboard will come up that can be used to enter data.

However when running a PB application with either the running man or an executable the icon indicating the pen drivers being enabled is usually not present. In most cases right mouse clicking in the field will bring up an option that allows the user to bring up the virtual keyboard but this workaround is unacceptable to the customer.

These drivers are WIN95 specific and do not function under NT 4.0.



CR:213152
CR Number:   213152
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 May 2000 Fixed
Description
PB crashes in the dw painter when selecting the
nested report. When the two dw's are linked together by a retrieval argument
and you go back in and add a retrieval argument to the dw that is the
nested report and then try selecting that nested report, pb crashes
in the pbvm70.dll.

If the two dw's are not linked with a retrieval argument and then you go back in
and add a retrieval argument than no crash.
Workaround Description
 If the two dw's are not linked with a retrieval argument and then you go back in
and add a retrieval argument than no crash.



CR:213180
CR Number:   213180
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 8046 15 Nov 2000 Fixed
Description
Straight retrieve of 1 table in db painter (or preview of a datawindow in datawindow painter) is significantly slower in the following builds and later:
6.5.1112 - >
7.01.7017 ->
Also observed in 7.02 and 8.0

For example, a preview of sales_order_items table in easdemo db now takes around 10 seconds compared to around 1 second with earlier builds (6.5.1 1112 / 7.01.7017 and earlier).
Using 550 MHz PC with 256 MB RAM, on a smaller 233 Mhz + 64MB this took over 30 secs

Not dbms dependent, get the same behaviour with ODBC, OLEDB, Oracle 8.04, SYC...
Performance problem only happens in datawindow or database painters in PB development env, a dw retrieve at runtime takes around 1 sec



CR:213214
CR Number:   213214
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8021 18 Apr 2000 Fixed
Description
Using a Geomedia ocx in a pb app shows a cursor
of "resize" in the legend instead of an "arrow". In the ocx it shows a arrow but once you move
the cursor to the legend it shows the "resize".

This is now fixed in pb 6.5.1 build 1169 and 7.0.2 build 8021.



CR:213229
CR Number:   213229
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jul 2000 Fixed
Description
PB does not use the digit grouping specified in the Regional Settings. Only 3 digit grouping appears to be supported.

Fixed in 7.0.2 EBF.

Development: Before the fix was implemented, PowerBuilder ALWAYS assumed a digit grouping of 3 for both currency and numeric. In Windows, you could have different digit groupings for either one. In PB, numeric and currency editmask display are tightly coupled so they must have the same grouping values in the control panel.

India and Pakistan use a mix of grouping for numbers, ie. ##,##,##0.00. Windows does not support a mix of groupings. So to get this to work, there are two places in the control panel/regional settings where you must change the grouping value; both the Numeric and Currency settings must match. If you do not change both to match, this fix will not work properly.



CR:213233
CR Number:   213233
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Apr 2000 Fixed
Description
Editmask control with a datemask (mm/dd/yyyy) has a inconsistent
validation.
For example, enter in 12/31/1999 and then go back and change the month
to 01. Now change the month to 02 and it lets you enter it in. So you have a
date of 02/31/1999. Same happens for 11/31/1999.



CR:213246
CR Number:   213246
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Dec 2000 Not a Bug
Description
Rightclicked event does no longer select the rightclicked treeviewItem
Workaround Description
 Use the following in the rightclicked event

this.selectitem (handle)
return 0



CR:213261
CR Number:   213261
Product Name:   PB Enterprise
Product Component:   DB Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Feb 2000 Duplicate
Description
When choosing the Edit Data option in the DB painter the retrieval of the rows is significantly slower than in past builds of both PB 6.5.1 and PB 7.0.

To see this problem simply connect to a database and choose a table. Choose to edit the data in either a freeform or grid and watch how slow the data is retrieved. Try this in an earlier build of PB 6.5.1 - anything prior to build 1137 and 7.0.1 and the retrieval is significantly faster.



CR:213263
CR Number:   213263
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.1 1187 11 May 2000 Fixed
Description
Moving the mouse pointer in a datawindow with computed field, leaks memory.
Verified fixed in 6.5 build 1187, and 7.0.2 build 8033.



CR:213275
CR Number:   213275
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Using a geomedia ocx in an olecontrol will not fire the following events
in that control.

In pb 6.5.1 events that don't get fired are:
clicked
doubleclicked
rbuttondown
ue_mousemove (mapped to pbm_mousemove)
propertychanged
propertyrequestedit

In pb 7.0.2 events not firing are:
ue_mousemove (mapped to pbm_mousemove)
propertychanged
propertyrequestedit

Events that are firing in pb 6.5.1 are:
constructor
destructor
getfocus
losefocus
other

Events firing in Pb 7.0.2 are:
constructor
destructor
getfocus
losefocus
other
clicked
doubleclicked
rbuttondown

In pb 6.5.1, the other event is firing when you click, doubleclicked, rbuttondown on the
ole control.



CR:213287
CR Number:   213287
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 8022 09 Mar 2000 Fixed
Description
Oracle o84 driver some select from dual statements with concatenation cause access violation



CR:213332
CR Number:   213332
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   4.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Fixed
Description
Unlike a PowerScript expression, a computed field or datawindow Evaluate expression "not (A) and (B)" is evaluated as "not ((A) and (B))" instead of "(not (A)) and (B)".

The brackets must be explictly included in the expression to evaluate it in the second way.



CR:213333
CR Number:   213333
Product Name:   PB Enterprise
Product Component:   Machine Code Deployment
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 registering userobjects using SharedObjectRegister() and you call a function upon the second created userobject the call fails with an R0035 Runtime Error. Cannot call external function <unknown>, then gpfs.
Additionally this only happens when the function contains a CREATE USING syntax inside of the function
Mind: No problem in development or pbds.

WORKAROUND:
=============
For the sharedobject you need to create a variable of the shared object and then do a create on the shared object.

uo_sharedobject iuo_sharedobject
iuo_sharedobject = create uo_sharedobject

This then creates a reference to the shared object in the machine code dll.
Workaround Description
 Use PBD's instead of machine code.



CR:213334
CR Number:   213334
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
If a datawindow is based on a select statement that contains a decimal constant, the datawindow retrieve will produce error: "Decimal conversion error. PowerBuilder only supports 18 decimal digits."
Workaround Description
 If you want a decimal constant, do not uses 0. For example, if you include 1.1111 in the select statement it will work.



CR:213368
CR Number:   213368
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2000 Third Party Problem
Description
If you leave a web page with an HTML datawindow on it by entering another URL or clicking a link and then return to the original page by clicking the 'Back' browser control, data entered into new rows in the HTML datawindow may disappear when you click on them.

----------------------------------------------------------------------------
This is a browser problem (See Workaround below) :
The generated JavaScript has a datastructure which corresponds to the the
various fields in the form. This keeps the datastructure in sync with what
is on the form. When you change the data and tab out the underlying
datastructure gets updated (after a data validation etc)... Now when you go
to another page and press the back button the underlying datastructure is
REINITIALIZED because we have lost the state... However the browser caches
the values on the form and you see the new values (these are OUT OF SYNC
with the underlying datastructure)... Now when you click on a field (and you
have client scripting on) then the value on the field is refreshed/replaced
with the one in the datastructure (which is essentially the old value)...
Therefore you lose your changes...

However point to be noted...
Even when you see the new values when the back button is pressed (and you
don't have client side events turned on) and you update the DataWindow, you
will see that the updated data in the db is still containing the old values
and not the ones that you saw on the page.

The only work around I can think of is refresh the page so that the data on
the form is in sync with the underlying datastructure (ofcourse you will
lose the changes but at least you will not be out of sync...)

Another simple workaround can be
- Create a javascript function :
function validateChanges() {
htmlDW.AcceptText();
if ((htmlDW.modifiedCount > 0) && (confirm ("Save Changes" ) == 1)) htmlDW.Update();
}
- add the event onunload : <BODY onunload="validateChanges();"
//-------------------------------------------------------------------------------------------------------



CR:213397
CR Number:   213397
Product Name:   PB Enterprise
Product Component:   UO Painter
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 Not a Bug
Description
User objects of type "tab" (inherited or not) that contain window controls will GPF when the user uses Control-C and Control-V to Copy/Paste an object such as an SLE or static text onto a tab control tabpage (example). It only takes one object (no inheritance) but PFC users often complain about this problem too.

The tab is especially susceptible since it's the only STANDARD VISUAL USER OBJECT that allows other controls to be nested in it. A CUSTOM VISUAL USER OBJECT does not have the same problem - even if it's composed of a tab control with embedded controls.

5.0.04 GPFs in PBRTE050.DLL
6.0, 6.5 GPFs in PBVM60.DLL
7.0 GPFs in PBUDO70.DLL

Workaround: Use "Duplicate" or "Copy/Paste" from the menu instead of the clipboard Copy/Paste.



CR:213401
CR Number:   213401
Product Name:   PB Enterprise
Product Component:   DB OLE DB
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Sep 2002 Fixed
06 Sep 2001 Fixed
Description
DW stored procedure updates using update, delete or insert procedures always fail with the message
"Row changed between retrieve an update" when using OLEDB interface.

The same dw & procedures work correctly with ODBC/native drivers
Same procedures work correctly with oledb when executed from script
Get exactly the same error if the stored procedure called in the dw update doesn't even exist

Some differences observed:
MS SQL Server 7.0 (dbms used in the original case) always gives the above error and never updates
ASA 6.0 - always gives the same error but successfully updates the first modified row of any pending updates



CR:213406
CR Number:   213406
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
IN7, IN9 driver when using Informix database with normal LOG mode or BUFFERED LOG mode Extended Attributes cannot be saved in DB Painter



CR:213442
CR Number:   213442
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)
16 May 2001 Not a Bug
Description
Deficiency/Enhancement. The File/Select Application "Browse" tabpage does not have a 'Network Neighborhood' icon which means you can't open a PBL on a network unless you map a drive.

The "Name" field at the bottom of the browse tabpage (File/Select Application) also does not support UNC mapping such as \\<yourComputer>\<your drive>\<some pbl>.pbl



CR:213449
CR Number:   213449
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jun 2000 Fixed
Description
The problem appears where the day part(dd) of the editmask(e.g. mm/dd/yy) has been typed as 00 OR ommitted by the user.

When the column object loses focus, PB replaces the date part from 00 to 01.
Please read technical document Content ID: 1016400



CR:213452
CR Number:   213452
Product Name:   PB Enterprise
Product Component:   DW DDDW
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 10032 01 Feb 2001 Fixed
Description
6.5EBF/7.0.2 Regression. DDDW (dropdowndatawindow) selection (focus) is incorrect when typing first character to use internal search. It scrolls to and highlights the SECOND entry instead of the first matching entry.



CR:213456
CR Number:   213456
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Apr 2000 Fixed
Description
PB hangs when retrieving from ASE when lock is set to
"3" (serializable transactions) and another session is connected to ASE. The
sqlpreview and retrievestart events fire. DBerror event doesn't fire.

The same app when used with embedded sql returns "Lock Timeout Error"
12205: The table is locked by a different user. Please try again later. Could
not acquire a lock within the specified wait period.

PB should indicate that the table is locked and is the case when used with
embedded sql. Also happens with mss and odbc connected to mss.



CR:213493
CR Number:   213493
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 8019 23 Jun 2000 Fixed
Description
Creating a new Jag component with the wizard always stores the generated objects in the PBL with the application object, not in the specified pbl at the beginning.
Workaround Description
 Manually copy the objects from the library with the application object to the one actually specified.



CR:213498
CR Number:   213498
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 1167 30 Mar 2000 Fixed
Description
If you make a syntax error when creating/modifying a datawindow, instead of getting a warning of a the error ( "A syntax error etc...Would you like to correct errors Yes/No ") all the columns are lost from the dw.

This only happens with OR8 and O84 drivers and also ODBC when used with an Oracle 8.x datasource
Not been able to reproduce with other datasources eg ODBC (non-Oracle 8.x), Informix, ASA, OLEDB etc...



CR:213499
CR Number:   213499
Product Name:   PB Enterprise
Product Component:   DB Oracle
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
PB 7 error Oracle driver o84 and o73 DataWindow error "Select error: ORA-00979: not a GROUP BY expression" when using binding and Oracle functions that use DW retrieval arguments as their arguments in a group by expression

Workaround:
Instead of declaring the group by in the datawindow create a stored procedure for the select statement and from that sp create a sp source datawindow.

This is an example:

Declare and define a PAckage:
CREATE OR REPLACE PACKAGE klaus_pack1
IS TYPE rctl IS REF CURSOR;
RETURN TEST_20194771%ROWTYPE;
PROCEDURE proc1(rc1 IN OUT rctl); END;:

Create the stored procedure and define the retrieval argument:
CREATE or REPLACE PROCEDURE spm_proc1k(rc1 IN OUT klaus_pack1.rctl, TEST IN number)
as
Begin
Open rc1 FOR SELECT DECODE(TEST,1,C2)
FROM
TEST_20194771
GROUP BY DECODE(TEST,1,C2); END;:

Then create an datawindow based on spm_proc1k and use it like you would use any other datawindow.
Works in PB 6.5, 7 and 8 beta.
Workaround Description
 I created a workaround for this issue: Instead of declaring the group by in the datawindow create a stored procedure for the select statement and from that sp create a sp source datawindow.
see description for wa:



CR:213506
CR Number:   213506
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)
06 Apr 2000 Fixed
Description
PB 7 DW SELECT binding depends on case of FROM keyword



CR:213551
CR Number:   213551
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Apr 2000 Not a Bug
Description
Inserting rows in a datastore causes RowFocusChange events to fire on shared dw.
Per development: This is not a bug. RFC has to fire in the InsertRow() circumstance. All actions in the shared DataWindow environment take place on the parent DataWindow and the shared children are sync'd to the parent. The process of sync'ing to the parent sets the current row to 1 and current column to 1 and this will fire the RFC events. It is always necessary to sync to the parent and it is always necessary to set the current row and column.
Workaround Description
 A workaround is to define an instance variable that tells the RFC event to ignore it. Scripted actions in the shared DWs which would generate the RFC's to be ignored could set the instance variable ON, process the action and turn it back off.



CR:213594
CR Number:   213594
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
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
7.0 Regression. Running an identical cursor (DECLARE, OPEN, FETCH, CLOSE) in Powerscript runs much slower in 7.0 than it did in 4.0-6.5.

The databases tested are Microsoft SQL Server and Sybase SQL Server.
Using ODBC - Performance is about 20 times slower than Powerbuilder 4.0-6.5.
Using MSS (native driver) - Performance is about 4 times slower than Powerbuilder 4.0-6.5.

In tests using PB 4.0 exclusively, ODBC was always faster than the native driver by a factor of 7 or 8.



CR:213601
CR Number:   213601
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Apr 2000 Duplicate
Description
In a numeric Editmask like #0, get wrong values if column is selected (highlighted). For example if you type 4 you get 40.



CR:213630
CR Number:   213630
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.2 8025 29 Dec 2000 Fixed
Description
7.0 Regression. The Farpoint Technologies Listpro ADO GPFs when you close the window the OCX is placed on. This worked fine in 6.5. (GPF in FPFLP20.OCX)



CR:213650
CR Number:   213650
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
The PowerBuilder 7 window Painter does not compensate for the titlebar height.
When a control is positioned at the bottom of a new window, it may have dropped of the page when
re-opening it or running it.



CR:213723
CR Number:   213723
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)
26 Feb 2003 Not a Bug
Description
Setting a DATE val to null in an date editmask (happens with both editmask controls or dw editmask) places the cursor just after the first digit on the left instead of just in front of the first digit when called from a user event mapped to pbm_dwnkey (dw) or pbm_keydown (em).

If called from another event/object there is no problem.
If the code is POSTed there is no problem.
Works fine in PB 6.x and PB 8.x
Workaround Description
 Datawindow:
Instead of calling dw_1.SetItem (null_date_var) post the function call
dw_1.Post SetItem (null_date_var)

EM Control:
Put code which assigns null string to text property of em in user event and post the user event



CR:213725
CR Number:   213725
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement Request: ODBC - Informix serial value should show without re-retrieve after DataWindow update() with ODBC driver



CR:213752
CR Number:   213752
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 8039 26 Jun 2000 Fixed
Description
Memory leaks in 3.5 EAS with PB components calling other PB components.



CR:213784
CR Number:   213784
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jul 2000 Fixed
Description
7.0 Regression. This is a small bug. You can't use File/Inherit from the toolbar to inherit from objects in a PBD file (when you rename it to a PBL and place it in your library list). Often, 3rd party developers only give users a PBD and not source. This was supported in previous versions and the painter(s) could open objects and you could inherit from them.

In 7.0, the library painter (right mouse) will allow you to inherit from a PBD (renamed to a PBL). (The source is not seen but this is OK). Using File/Inherit, if you point to the PBD, you will not see any objects (though you can TYPE in the object name and it will work.). Occasionally, you get a BAD_MEM_POINTER.



CR:213795
CR Number:   213795
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)
7.0.3 18 Dec 2000 Fixed
Description
7.0 Regression.

If another script is selected by clicking it in the event list view or the event dropdown or if the object is saved or compiled (via CTRL + L or compile menu option ) then there is no problem.

Also, once the override ancestor setting has been 'accepted' there is no longer a danger of it being reset unless the setting is changed back to 'extend ancestor script' and again to 'override...'



CR:213842
CR Number:   213842
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
PowerBuilder 6 and 7.0
When a datawindow is in querymode and a column has both an editable dddw and format defined,
then the column can show a strange value (large number) after typing a value that is not one of the datavalues
of the dddw.

Work-around:
Modify the format to '[General]' when in querymode.



CR:213858
CR Number:   213858
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)
7.0.2 9026 09 May 2001 Fixed
Description
ODBC to MS SQLServer second outer join on the same table creates self-join in ANSI syntax returns error SQLSTATE = 37000
[Microsoft][ODBC SQL Server Driver][SQL Server]Tables 't' and 't' have the same exposed names. Use correlation names to distinguish them



CR:213867
CR Number:   213867
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. This is a pseudo regression since the view technology wasn't available in 5.0 and 6.0 datawindow painters. In 7.0, if you have Retrieve on Preview ON in a grid datawindow and use the default layout, when you use SHIFT-RIGHT Arrow, SHIFT-LEFT arrow to resize a column, it no longer works. It worked fine in 5.0 and 6.x.

Workaround: Make sure the preview view isn't showing or doesn't have any rows (Retrieve On Preview set to OFF in Design/Options/ General Tab.)



CR:213979
CR Number:   213979
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement/Deficiency. Web Datawindow needs ScrollToPage or JumpToPage type of method to mimick other search engines (alta vista allows you to jump to any page in the result set rather than scroll page by page).



CR:214003
CR Number:   214003
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
Define an expression to convert a date column to a string value within a crosstab datawindow. This expression will convert the date value to a string format however the sort order is incorrect.
E.g.
1.13.98 10.12.97 10.17.99 {e.g. String order(months) 1,10,11,12,2,3,4 ...}

The correct sequence for ascending Date order is:-

10.12.97 1.13.98 10.17.99

Other datawindow styles e.g. tabular, freeform ; the functionality is correct and working.
Workaround Description
 At least 3 workarounds. See description section.



CR:214007
CR Number:   214007
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 8022 13 Dec 2000 Fixed
Description
Stock icons missing from PBVM70.dll in build 8014.
Fixed in 7.0.2 build 8023 and after.



CR:214020
CR Number:   214020
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Oct 2000 Third Party Problem
Description
PowerBuilder 6.5,7.0 and up using Oracle 8.1.5 (Oracle 8i) client GPFs in Oracles OCI layer when a second attempt is made to connect to the database using the PowerBuilder Oracle native driver PBO8460.DLL or PBO8470.DLL drivers.

We know this is an Oracle Client issue (The DLL unloading problem) but we're documenting this and the workaround until Oracle comes out with a fix.

Workaround: You must avoid unloading the DLLs (don't disconnect from the database until the application is closing). Anytime you connect a second time (even using a separate transaction object), you will GPF.

Local or Global External Function declaration:
function ulong LoadLibraryA(string filename) library 'kernel32.dll'

uLong PBOr8Handle
PBOr8Handle=LoadLibraryA("pbo8470.dll")
..
Connect using sqlca;

// DO NOT SCRIPT A DISCONNECT or ANOTHER CONNECT - STAY CONNECTED.

NOTE: Fixed in 6.5 1191 and 7.0.2 8036.



CR:214027
CR Number:   214027
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.Column Edit "Case" property on a string column can't be changed from Upper(1). Once a change is made to the case of a column (to upper), you can't change it back.

Also with a migrated application from 5.0 or 6.x, if the case is set to Lower, it will show up Lower at first in the Properties dialog but the UI will only let you change it to Upper and not to Any. Once it's Upper, you're stuck again.

Workaround: Export the datawindow and in the find the syntax edit.case=upper for the specified column and change it to edit.case=any (or lower)



CR:214054
CR Number:   214054
Product Name:   PB Enterprise
Product Component:   Project Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 8039 29 Dec 2000 Fixed
Description
COM project painter Component Server File Name and idl file name are not displayed when decimal separator regionnal setting is different from "."
Workaround Description
 One or the other . 1- Export the project , change the decimal separator of the GENVERSION banner so that it matches the one in the regionnal settings & reimport the project. 2 -decimal symbol set to "." before starting powerbuilder all will work fine.



CR:214098
CR Number:   214098
Product Name:   PB Enterprise
Product Component:   Machine Code Exe Creation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2004 EOL'd version. Not to be Fixed.
Description
Ancestor event that returns an object and a descendant that extends the event, will not compile to Machine Code. P-Code if fine.
Workaround Description
 Instead of extending the ancestor script, override it and call the event manually right at the beginning:
i.e. SUPER::EVENT ue_myevent()

This should give the behaviour that the customer is looking for.



CR:214121
CR Number:   214121
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement Request:
An EditMask for a field of type Date eg. with Mask 'dd.mm.yyyy' should be enhanced as follows:
1. When the user leaves the year empty the current year should be added;
2. When the user only has entered only 2 digits for the year it should place a 4 digit year automatically similar
to the functionality to normal edit fields.



CR:214124
CR Number:   214124
Product Name:   PB Enterprise
Product Component:   System Runtime Functions
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Enhancement request for higher precision for numeric literals with explicit exponent without decimal point.
Without decimal point after first digit a numeric literal only shows precision of 8 digits.
Numeric literals with a decimal point and explicit exponent have a precision of double.



CR:214126
CR Number:   214126
Product Name:   PB Enterprise
Product Component:   Debugger
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 Fixed
Description
Debugging the constructor event of an autoinstantiated userobject will crash PB if the object was declared as an Instance variable. Verified fixed in PB 7.02 build 8046.



CR:214138
CR Number:   214138
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)
20 Nov 2000 Presently Not Targeted For Any Future Release Of This Product
Description
PowerBuilder 7.0. The new Find/Replace dialog available in the "Preview" view in the datawindow painter from the right mouse selection does not work correctly. The FIND portion seems to work correctly and brings up the find dialog (not made to work with nested reports). The REPLACE menu pick on this same popup menu is always disabled, however.



CR:214143
CR Number:   214143
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)
10 May 2001 Fixed
Description
Datawindow stored procedure Update to Oracle 8 fails when the column value passed
in the stored procedure is NULL.
The error message is : ORA-00932: Inconsistent datatypes



CR:214179
CR Number:   214179
Product Name:   PB Enterprise
Product Component:   Pipeline - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Aug 2000 Fixed
Description
PowerBuilder crashes when pipeling Sybase TEXT columns to an Oracle CLOB column.
Workaround Description
 Associate the Sybase TEXT field with the database CLOB column through DB Blob. May have to do the association twice if the datatype for the CLOB changes to a LONG. Make sure that you Commit after every 1 row.



CR:214193
CR Number:   214193
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 Fixed
Description
The online help and user manual entry for SetFullState() were incorrectly changed in PB 7.02 (see 191945) and now give wrong information for the Return Value

In 7.02 it states the following:

Returns -1 if an error occurs and one of the following values if it succeeds:

1 DataWindow objects match; old data and state overwritten
2 DataWindow objects do not match; old object, data, and state replaced

Null No DataWindow object associated with DataWindow control or DataStore; new one
assigned from DataWindow blob

It should read:

Returns -1 if an error occurs and one of the following values if it succeeds:

1 DataWindow objects match; old data and state overwritten
2 DataWindow objects do not match; old object, data, and state replaced
3 No DataWindow object associated with DataWindow control or DataStore;
the DataWindow object associated with the blob is used. The value of the DataObject property
remains an empty string.

NULL If any argument's value is NULL, in PowerBuilder and JavaScript the method returns
NULL, and in Java a NullPointerException is thrown

I tested each of the possible scenarios and confirm this is the behaviour.



CR:214219
CR Number:   214219
Product Name:   PB Enterprise
Product Component:   DW ActiveX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
OLE Datawindow with ASE SP source fails with > 50 columns targeted.



CR:214246
CR Number:   214246
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
The problem appears when large populated column objects are displayed in nested report objects. In this example, columns of varchar(1000,2000,3000) have been defined and used. The error are blank page(s), pagination and summary band cut-offs.

Per Development, this is not a bug:
This is yet another case of breaking the DW design rule of creating a data row greater than the size of the target page. The blank pages are basically one blank page for each nesting level, as the DW Engine bumps the start of each nest to the next page in an attempt to find a page where the first row of that nest will fit on the page. It gets to the lowest level and the data row still does not fit, and the Engine gives-up. It is the responsibility of the application programmer to design DWs with data rows that do not exceed page sizes.

The proper way to deal with huge text-string columns, is to break the large string into a series of small strings. The smaller strings are used to populate individual data rows within a nested DW -- instead of an AutoSizeHeight text column. This can be accomplished with the sample WordWrap DLL (see PSE for distribution).



CR:214254
CR Number:   214254
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Nov 2001 Not a Bug
Description
f you have two HTML DW (ie. master detail), if you move from first frame to second one,
the data entred in first frame is lost. The field is reset to its original value.
The onblur event is triggered twice when it's triggered once if you stay inside the frame.
This happens only on IE4 and it works fine on Netscape.



CR:214290
CR Number:   214290
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 25 Feb 2004 Fixed
25 Feb 2004 Fixed
Description
The EAS 3.5 upgrade causes some OLE registry settings to be lost. This results in PowerBuilder's OLE interface to fail. The workaround is to download CR214290.zip and execute the included .REG file which restores the missing registry settings:

ftp://psaftp.sybase.com/pub/private/pbpatch/cr214290.zip

Once the bug fix is incorporated into the next maintenance or major release, this file will be deleted.
Workaround Description
 Customer needs to execute the new Reg file, cr214290.reg, in order to restore the missing registry entries:

ftp://psaftp.sybase.com/pub/private/pbpatch/cr214290.zip

Do this AFTER you install EAS 3.5 upgrade.



CR:214305
CR Number:   214305
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
PB 6, 7, 8
Using European keyboard settings ie a comma for a decimal separator
(Windows control panel -> regional settings -> regional settings tab -> select any Spanish/French/German
from the list).
If you have a datawindow user event declared which is mapped to pbm_dwnkey this will not fire when you hit the decimal point/delete key on the numeric keypad.
Workaround Description
 Workaround would be to use Editchanged event



CR:214313
CR Number:   214313
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.2 19 Dec 2000 Fixed
Description
6.x Regression. A radio button in a groupbox is not getting checked (and the clicked event isn't being triggered) if the user issues a Setfocus() to the radio button in the open event of a window AFTER the toolbar has been set to floating. The sequence for the open event would be:

settoolbar(1,true,floating!,"Floating Toolbar")
rb_1.setfocus()

For radio button "rb_1", with the automatic property ON, when the user clicks or sets focus through a function call, 2 things should happen.
1. The radio button should become checked.
2. The clicked event should fire.
#1 isn't happening and once this happens, you can't check the radio button through any method (clicking, etc) - it seems like the messages aren't going to the radio button.

Workaround:
1. Put the code for floating the toolbar in an event Posted from the Open event of the window.
2. Put the rb_1.setfocus() BEFORE the calls to set the toolbar floating.



CR:214334
CR Number:   214334
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)
6.5.2 31 Oct 2002 Fixed
Description
Assume FOCUS is on the datawindow DATE column object which has an Edit style property of editmask. When a property on this DATE column object is modified/ changed in the script(e.g. background colour), the date is nullified i.e. the text in the edit control displays as e.g. 00/00/00;

After the current column has lost focus, the original value from the dw primary buffer is restored irrespective of definition as null/non-null column.
Workaround Description
 Restore data from primary buffer OR change object property when focus is NOT on the DATE column object property which has Edit style of 'editmask'.



CR:214367
CR Number:   214367
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Broken in 6.5 Build 454 and later. Also in all 7.0 and 8.0 builds

Assigning data to DW/DS fields using dot notation is much slower in builds 6.5.00.454 onwards, especially using datastores. SetItem performance is hardly affected.
No computed fields, sums etc used in the dw.
Looping + inserting empty rows alone is not affected between above builds, neither is looping and reading data using dot notation.

- Dot notation with a Datastore -> 400 - 450% slower

- Dot notation with a Datawindow
(NOT using SetRedraw ) -> 300 - 350% slower

- Dot notation with a Datawindow
(using SetRedraw FALSE) -> 30 - 40% slower
Workaround Description
 Use SetItem
Write to a structure array and assign directly to data property of dw/ds



CR:214417
CR Number:   214417
Product Name:   PB Enterprise
Product Component:   GenApp
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 memory leak with Format 4 Dynamic SQL's function GetDynamicString().
The leak happens when the retrieved value in output parameter is NULL instead of a non-NULL string.
Workaround Description
 Use a datastore mechanism to access the table for null columns does not memory leak. (See description for sample script)



CR:214421
CR Number:   214421
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2004 EOL'd version. Not to be Fixed.
Description
If you have a cross tab DW which has mouse selection enabled. If you tried to retrieve the data while a field is highlighted, you will get an application error.



CR:214434
CR Number:   214434
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Mar 2000 Not a Bug
Description
If a datastore object goes out of scope because the datastore variable is assigned a new object via a CREATE statement, the out-of-scope object may not be immediately garbage-collected.
Workaround Description
 Destroy datastores before they go out of scope so their destruction is not dependent on the garbage collector.



CR:214438
CR Number:   214438
Product Name:   PB Enterprise
Product Component:   Machine Code Exe Creation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0 Beta 4 4017 10 Oct 2004 Not reproducible with latest version of the product available as of Resolution Date
Description
Creating a machine code executable may cause the folowing error:
C:\WINNT\TEMP\cgfqpdyh.c(2567) symbol 'PBDevDbgTraceActive' has not been declared
Workaround Description
 none



CR:214444
CR Number:   214444
Product Name:   PB Enterprise
Product Component:   Machine Code Exe Creation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
When you use the build Runtime library option on a PBL to create a DLL, all PBLs in the path are regenerated, not just the PBL that is the source ofr the DLL.
Workaround Description
 Create a dummy PBL and add the PBL to be rebuilt to the library path. You can now create the DLL without having to wait for the rest of the PBLs to be rebuilt.



CR:214445
CR Number:   214445
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.2 8026 04 Aug 2000 Fixed
Description
RowFocusChanging/Changed fires incorrectly with Sharedata on secondary dws.
The sort part is fixed, but the firing on the sharing of an empty primary to a secondary can't be fixed.
Workaround Description
 The workaround is to add logic to the RowFocusChange events to test for currentrow = 0 and do nothing if it's a sharedata condition.



CR:214455
CR Number:   214455
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)
24 Mar 2000 Third Party Problem
Description
ActiveX's with an Expired License will FORCE PowerBuilder to die.

Per Development, this is not a PB bug, it's a Third Party Vendor issue:
No Fix Possible.
****Description****
Some ActiveX's have date sensitive licenses. If the license has expired, the control terminates the entire process. To a user, it appears that PowerBuilder just evaporates.
****Status:
This has no fix and no workaround (other than keeping your license up-to-date).
Workaround Description
 This has no fix and no workaround (other than keeping your license up-to-date).





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