提供7*24专业Sybase数据库远程及现场技术支持,Sybase ASE及Sybase SQL Anywhere数据库修复服务,
请联系电话: (微信),QQ: 289965371!
We supply technical support for Sybase ASE and Sybase SQL Anywhere, also have many years of experience in recovering data from damanged Sybase devices.
Please contact us:
Phone:
Wechat: 13811580958
QQ: 289965371 联系我们获取数据库技术支持!
Email: 289965371@qq.com
扫描下方微信,联系我们:
扫描雨翰数据恢复官方微信获取专业数据库恢复服务

 

随着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:155129
CR Number:   155129
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
PB5 allows you to call protected and private functions in another object class if the DYNAMIC keyword is used in the function call.



Cannot recreate during 6.0 beta



CR:155134
CR Number:   155134
Product Name:   PB Enterprise
Product Component:   Business Graphics
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 21 Oct 1998 Not reproducible with latest version of the product available as of Resolution Date
Description
Customer is trying to modify the escapement of the value label and it is not working.



Customer is using:

gr_1.values.labeldispattr.escapement=some value (0,450,900,1800,3600)

gr_1.category.labeldispattr.escapement=some value (0,450,900,1800,3600)

Reproduced using 4.0.06 (16 and 32) and 4.0.07. This does not occur in 5.0.



CR:155137
CR Number:   155137
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jan 1999 Not reproducible with latest version of the product available as of Resolution Date
Description
If Allow Edit property for dropdownlistbox is true, the backcolor property does not take effect, whether altered in the painter properties dialog, or at runtime.



Cannot recreate this using 6.0 final



CR:155143
CR Number:   155143
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
GPF in pbshr040.dll when you retrieve a nested child dw (in composite dw) a second time:

datawindowchild dwc

dw_1.getchild('nested_rpt_name',dwc)

dwc.settransobject(sqlca)

dwc.retrieve(61)



5.0 works fine.



CR:155144
CR Number:   155144
Product Name:   PB Enterprise
Product Component:   System Runtime Functions
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Application object's open script calls a function that is designed to check to see if the user has the .ini file in their path. If they do, it will be refreshed to be current and if they don't, it will be created for them.





PER DEVELOPMENT:

Win95 File caching issue. See bug number 43135 for more details.



CR:155146
CR Number:   155146
Product Name:   PB Enterprise
Product Component:   Menu Painter
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
On Win3.11, problem occurs in menu painter when you try to access the Pictures property sheet for a menu item which points to a D drive and there is no disk mounted in the drive.



CR:155147
CR Number:   155147
Product Name:   PB Enterprise
Product Component:   Rich Text
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
The RTE Font DDLB lists printer fonts, where other Font DDLB's in other areas of PowerBuilder, don't.



CR:155148
CR Number:   155148
Product Name:   PB Enterprise
Product Component:   Rich Text
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
If you have an RTF document that contains text that has been added to the document using Insert/Symbol (from the WFW menu), no matter what character set was selected, when the document is put into the RichTextEdit Control using the InsertDocument function, those characters that were inserted using Insert/Symbol do NOT appear.



Those same characters, if typed into the document after changing the font name from the WFW font DDLB, are fine.



Also, the single quote/apostrophe (') and the double quote (") don't appear, either.



CR:155153
CR Number:   155153
Product Name:   PB Enterprise
Product Component:   Menu Painter
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
If a menu function is deleted in the menu function dialogbox and the menu is closed without saving the menu function is not removed.



Cannot recreate with 5.0.04.61 and 6.0 build 233



CR:155154
CR Number:   155154
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Can't resize response window at runtime. Resizable attribute can be set in the painter for a response window. It doesn't take effect at runtime.



Solution:In 6.0 213, the resizeable checkbox is no longer checkable in the Window painter.



CR:155158
CR Number:   155158
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.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
Oracle 7. "Select error: column lists do not match" with numeric retrieval argument in select statement. Worked in 4.0.



Workaround: Staticbind=1



CR:155159
CR Number:   155159
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows 3.1
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
If you select Code Table and then de-select Spin Control (without de-selecting CodeTable), you can still modify the CodeTable entries. This is true although the CodeTable checkbox has been disabled. The entries are not saved and are lost. Either the CodeTable enable/disable needs to be independent of SpinControl or the controls for entering/modifying CodeTable entries should not be displayed when the CodeTable check box is disabled.



CR:155161
CR Number:   155161
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.x Catalina 18 Aug 1999 Fixed
Description
A column on an external datawindow (or any datawindow) with datatype 'date', editstyle 'editmask', justification: 'center' or 'right' causes PB to GPF when the cell loses focus if the cell is not big enough to hold the entire date. It looks as if PB goes into an endless loop trying to center the data. This also happens on a Window Editmask Control with the same characteristics.

This is not fixed until PB 8.0.

Workaround: Turn off alignment "Center" or "Right" and use Left or Resize the control or column.



CR:155163
CR Number:   155163
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Using Constant instance variables in user object which is used for OLE automation causes a GPF in PBROI50.DLL. If you do not use the constant keyword, but just instance variables which are initialized in the constructor event of the userobject, you do not get the gpf.



CR:155174
CR Number:   155174
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
The listview scrolling system does not behave in a desire manner. As you pull the bar of the scroll bar down with the mouse, there is a point when it will begin displaying the first items and when the mouse button is released, it will spring up to the top. To scroll to the bottom, the arrow keys have to be used. Takes about 2000 items in the listview to see this behavior.



Developer: Fixed in 32 bit. This could not be fixed in 5.0. Unfortunately there is a limitation under Windows 3.x (16-bit) for the amount of objects in the common controls. The implementation is based on the usage of standard windows API rectangle structures that use integer members internally. The integer data type range under 16-bit is -32,768 to 32,767. If, for instance, a list-view holds 1840 rows and each row has a 16x16 pixel image and a 2 pixel margin the overall amount of pixels computes to 1840 * (16 + 2) = 33120 => Overflow!



You will always have this limit of about 1800-2000 "viewable" items in 16 bit. Perhaps restructuring the listview to contain fewer items would help.



CR:155175
CR Number:   155175
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Customer has a REAL datatype column on his database. When he goes into the database painter and does data manipulation or creates a new datawindow that uses this column, the column displays extra precision. For example if 1.22 is typed into the column and then you tab away, it displays 1.2200002829.



CR:155177
CR Number:   155177
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.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
Ole control wizard mechanism for telling the control container that needs to save which is the dirty flag does not seem to be used by PB implementation of Ole control container. In the customers control whenever they change the internal property, the dirty flag is set.



CR:155180
CR Number:   155180
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
OLE container with Excel spreadsheet. When spreadsheet is inserted with InsertFile, the fonts are compressed to the point that they are unreadable. Expanding the spreadsheet does not help. Using the same code in Visual Basic 4.0: the fonts are not compressed.





Solution Per Development:



When you use VB 4 or 5 and set up a similar test case you get the following results:

1) If you set the SizeMode property to the "Clip" option the fonts look okay, but some of the data is not visible because it does get "clipped.

2) If you set the SizeMode property to the "Stretch" option (which is what PB does), then you get the same results in VB (4 or 5) that you get in PB, the fonts get "scrunched" up so that they're barely legible.



In both scenarios, it's MS Excel that handles the behavior of the fonts.



Development was able to put a "kludge" into the code in order for PB to handle this, but if the "kludge" causes any problems for other customers, the code change will have to be backed out.



CR:155185
CR Number:   155185
Product Name:   PB Enterprise
Product Component:   Structure - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Blob variable not saved correctly in structure painter. Blob{20} becomes blob



CR:155188
CR Number:   155188
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Enhancement: The only way to scroll the dates of a calendar OCX control is to click on the control itself. Tabbing onto it or using Setfocus() to the control will not allow the user to use the arrow keys to scroll the dates.



PER DEVELOPMENT:

This is not a bug. The reason you can't use the arrow keys on the ActiveX control is because you are tabbing to the ole control container and not the ActiveX. The functionality to be able to tab directly to the ActiveX is an enhancement.



CR:155191
CR Number:   155191
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Modifying header.height in the DataWindow PrintPage event causes printing to either 1) print out each first row column on a separate piece of paper, or 2) always repeat printing the first page.



NOTE: Need property on the header and footer band to print only on the FIRST page. This would keep customers from having to do this programmatically.



CR:155193
CR Number:   155193
Product Name:   PB Enterprise
Product Component:   DW Rich Text
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 May 1999 Fixed
Description
GPF in PBRTC050.DLL in RTF style dw when clicking on inputfield in header in painter after this field has been pasted from the detail band..



CR:155195
CR Number:   155195
Product Name:   PB Enterprise
Product Component:   System Runtime Functions
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Oct 2004 Not reproducible with latest version of the product available as of Resolution Date
Description
5.0 REGRESSION. FileRead having a buffering problem with lines of 1023 characters. 1022 and 1024 read in OK. This worked OK in 4.0. Workaround: If line has 1023 characters, add a space at the end. FileRead seems to have a buffer of 1024 characters.
11/25/98 Fbashaw: Verified a problem in 5.0.04, 6.0.0, and 6.5. But in 6.5 build 502 and it did not fail.



CR:155199
CR Number:   155199
Product Name:   PB Enterprise
Product Component:   Library Painter
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Library Painter, Design, Options. Check and uncheck various options in the display groupbox on general tab, Apply or OK. They don't all take effect, and if you go back into properties they won't be what you set.



CR:155209
CR Number:   155209
Product Name:   PB Enterprise
Product Component:   Machine Code Exe Creation
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Machine code exe compile gives error "number of arguments to function is incorrect " for the generated c file. They have a real_variable = 1.17e-38 hardcoded in application - somewhat obscure



PER DEVELOPMENT:

This is because 1.17e-38 is not a valid float although the documentation says it is. This is a dup issue of several others. The docs for 6.0 have been changed to reflect this incorrect range.



CR:155210
CR Number:   155210
Product Name:   PB Enterprise
Product Component:   Printing
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
LastRowOnPage property is not returning the correct values when it's used in the PrintPage event of a DataWindow control. It returns 1, 1, 2, 3, 4,... instead of 1, 2, 3, 4, 5,... This behavior is true in both 5.0 and 4.0.



PER DEVELOPMENT:

Works as designed. Fundamental to the DW design is the "Row must fit on one page" rule



CR:155234
CR Number:   155234
Product Name:   PB Enterprise
Product Component:   Machine Code Deployment
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Comparison for equality of structure values without references to the fields of the structures fails in machine code executable even if the data is the same. Not sure whether this is a bug. Example: declare two struct variables struct1, struct2. They have a field/element s_test which is a string. Set struct1.s_test = "foo" and struct2.s_test = "foo". Then do a comparison if struct1 = struct 2 then... which is true in pcode but false in a machine code executable. If the comparison references the s_test field, as in: if struct1.s_test = struct2.s_test then... that works just fine in a machine code executable.



CR:155241
CR Number:   155241
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Help topics > 32767 give "Help Topic Does not exist" using ShowHelp(). Ex:

ShowHelp("test.hlp", Topic!, various #'s). 32768 bad, 32767 works.



Solution:

The fix to this bug (changing the definition of ShowHelp( ) in PBTYPDEF would require a migration, so it cannot be introduced in a Maintenance Release. It will be addressed in our next major release, 6.0.



CR:155245
CR Number:   155245
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.x Catalina 1048 06 May 1999 Fixed
6.5.00 615 06 May 1999 Fixed
7.0.00 EBF1 6005? 06 May 1999 Fixed
Description
System11 bit datatype not painted correctly for RPC. Paints as string, should be boolean.



CR:155248
CR Number:   155248
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Solaris 2.5.1
Original Version:   5.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
No focus indicators for ddplb and ddlb

PB 5.03_13 - Focus indicators are leaving dots at its last location when the control is moved + indicators do not go away when another control is selected.

Note: Solaris Only



CR:155249
CR Number:   155249
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Trying to access a Word document via ole automation. In single-user mode this works however in multiuser mode - if another user has the same .doc file open - the applications crashes with error "R0035 application error accessing external function" at the FileOpen statement.





oleobject oleobj

oleobj = create oleobject

oleobj.ConnectToNewObject("word.basic")

oleobj.FileOpen("c:\test.doc")



CR:155250
CR Number:   155250
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows 3.1
Original Version:   4.0.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Apr 1999 Not reproducible with latest version of the product available as of Resolution Date
Description
Using dw_1.print() from a window without first putting the DataWindow into print preview, the dw prints one column per page. This also happens from the DataWindow painter if you do not go into print preview first, one column prints per page.





WORKAROUND: Either have two DataWindow controls where one can be hidden for printing purposes (using dw_1.modify('DataWindow.print.preview=yes')) and the other for viewing OR before issuing the print for the DataWindow set print preview on and then off after printing. OR modify the size of the columns from the dw painter so all the columns still fit on one page, but large enough to hold all the text.



CR:155258
CR Number:   155258
Product Name:   PB Enterprise
Product Component:   DPB
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Error message: "function typeof() differs from ancestor only by return type"- cannot create proxy object when modifying existing objects. Will be fixed in 5.03.01 build.



CR:155264
CR Number:   155264
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jan 2000 Not reproducible with latest version of the product available as of Resolution Date
Description
Several datatypes selected in the datawindow painter give "columns datatype not supported" when the datatype might be a BLOB column and is supported but not for a SQL Select statement for a datawindow.. A better message has been requested.



CR:155265
CR Number:   155265
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Assigning a row of a dw object to a structure using structureName.Object.Data. If a column by column assignment is done, a null call be assigned for a column. If a row assignment is done and a column is NULL, the following error occurs: "PBRTE050.DLL @ 0137:10B2F3B3"



PER DEVELOPMENT:

Cannot reproduce in 6.0 beta.



CR:155266
CR Number:   155266
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Where the first column in the tabular dw is protected,When they reverse tab into the dw from another control on the window, focus is placed on the last column of the second to last row and not the last row. When they are in row one of the dw and reverse tabbing out to another control on the window, focus refuses to leave column two on row one, the cursor is stuck.



CR:155272
CR Number:   155272
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
When following a specific sequence of events, the edit mask ####0.000### gives strange results. TO REPRODUCE: Using a datawindow with that editmask defined, in data preview follow these steps: 1. Insert new row.

2. In decimal col enter 111111.1111.

3. Place insertion point to left of decimal point, Highlight the digit to left, press delete key.

4. Repeat several times (should be 2 times)

5. the edit control displays "-(null).000" in 4.0

Under 5.0.01 32 bit I get: -28127225430599912.000



PER DEVELOPMENT:

Cannot reproduce behavior in 6.0_203



CR:155274
CR Number:   155274
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 09 Apr 1999 Fixed
Description
Datawindow with computed field using truncate function.



truncate( salary ,2) on the employee table in the Powersoft Demo DB - salary column might show something like:



Salary Truncate

0.29 0.28 // this is incorrect

2.07 2.06 // this is incorrect

0.05 0.05 // this is correct

0.57 0.56 // this is incorrect

2.08 2.08 // this is correct



Workaround: Use a global function.



gf_trucate(salary,<precision>) /* global function */



/* gf_truncate script */



choose case precision



case 2



decimal {2} dec2

dec2= valuepassedin

return dec2



case 3



decimal{3} dec3

dec3=valuepassedin

return dec3



case <n>



case else

Messagebox ("truncate error", "function limit is 8 decimal places")

end choose



Development:

The implementation of representing numercial data as type float (i.e. types float and double) in binary can introduce a degree of imprecision. In performing the "truncate( #, precision)" Powerscript function, the real number (which is "#" above) is involved in a multiplication within the function. The loading of certain real numbers, in this case "2.07", into the floating point register (using the assembly command "fld") in order to perform the multiplication amplifies this imprecision. The represented value loaded into the register in this case is "+2.06999999999999971e+0002", which is dictated by the system floating point representation. A truncation at this point will cause the value to become "2.06". There is not much we can do about this from within PowerBuilder without performing a potentially detrimental side-effect to applications which actually use the trailing decimal places - i.e. scientific data which relies on the proper binary floating-point values. This problem revolves around trying to represent a finite number which cannot be represented exactly in floating point. Other alternatives include integer, long, and decimal, which are designed to represent finite values.



The solution to this problem lies in the hands of the application developer. It is required that the developer use their application-specific knowledge of the data, and perform the appropriate logic (such as "truncate(salary + 0.000001)" to come up with numerical representations that are true within the context of their development projects, and can overcome any rounding problems.



CR:155275
CR Number:   155275
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Dec 2000 Presently Not Targeted For Any Future Release Of This Product
Description
Stored Procedure does not return output parameter if a cursor exists in athe stored procedure. Microsoft SQL Server 6.0 using native driver pbmss050.dll.



CR:155277
CR Number:   155277
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Problem with tabpage tab text color setting if color is set to black. It automatically reverts to wndtext if you set it to black. Did not try all colors, but trying several, problem only occurred when color was set to black. Setting on your system for wndtext was not relevant to the problem, i.e., it is not a case of reverting to wndtext if your wndtext is also set to black. wndtext could be white, and if you set the color to black, we revert to wndtext.



CR:155283
CR Number:   155283
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.00 17 Apr 1998 Fixed
Description
Using drag/drop between two listviews in large icon view causes drawing problems when you scroll one of the listviews vertically. The next dragged objects' drag icon and the cursor from the 'source' listview become seperated - it seems they are the exact distance you've scrolled the listview. Using DragAuto ON in the window painter for the source listview control.



WORKAROUND: The focus problems seem to be related to using None! as a drag icon or Application! if you have no ".ico" file defined for the application object (which is sort of the same as None!). Once you use a real Icon (Information!, or an Application icon file that exists), it works fine.



CR:155286
CR Number:   155286
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
The Tab Control property "CreateOnDemand" is not recognized when using the OpenTab or OpenTabWithParm functions for a User Object Tab Control.



CR:155293
CR Number:   155293
Product Name:   PB Enterprise
Product Component:   Machine Code Deployment
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Shortcut assignment operator using strings causes GPF in machine code.

windowname.title += "string"



CR:155295
CR Number:   155295
Product Name:   PB Enterprise
Product Component:   Plug-ins
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 469 31 Oct 2002 Fixed
Description
Datawindow plug-in. Gets invalid page fault in mfc40.dll at 0137:5F82E328 if you close down win95 while a web page with a dw plugin is open. In windows 3.11, you get the gpf in netscape at 002B:45C6. KNOWN PROBLEM documented in readme.txt of Internet Developers Toolkit.



CR:155296
CR Number:   155296
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows 3.1
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
In 4.0, when a DataWindow user event is mapped to pbm_dwnmousemove, both message.wordparm and message.longparm were set. Customer was using those values to extract x, y, and button positions from the mouse. In 5.0, they are not set. Instead, they are now arguments to the event. Customer does not want to get them from the event but from the message object. This is a regression from 4.0 to 5.0.



Developer: All of this is true, but we are not exposing the flag byte in a maintenance release (would cause compatibility issues). However, the programmer can use the WINAPI function GetKeyState (or GetAsyncKeyState depending) with the virtual keys VK_LBUTTON and VK_RBUTTON to get the state of the buttons. This is a good workaround for 5.0 maintenance.



CR:155298
CR Number:   155298
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Oracle 7 using SQLNET 2.2. GPF when previewing datawindow containing 16 or more tables. Crashes 32 bit Powerbuilder under NT 3.51 or NT 4.0.



CR:155309
CR Number:   155309
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
datawindow with retrieve arguments does not sort at all when put into query mode, and querysort is turned on. If there are no retrieval arguments it works just fine. WORKAROUND: Instead of retrieval argument use Query Criteria -> Equality Required from columns popup menu in the datawindow painter.



CR:155320
CR Number:   155320
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Trying to add tab pages using OpenTabWithParm() and creating three tabpages within a FOR loop. Only the first tab page is being created, although the FOR/LOOP does loop through three times. When you use OpenTab(), everything works fine.



CR:155338
CR Number:   155338
Product Name:   PB Enterprise
Product Component:   UO Painter
Status:   Closed
OS:   MS Windows 3.1
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Trying to override ancestor script in a descendant script, if the first line of code in the descendant script is identical to the first line of code in the ancestor script, you lose your code and override setting on the script. Easy workaround: add a comment to the top of the descendant script. As long as the two first lines are not the same you will not have a problem.



Cannot recreate with 6.0.



CR:155343
CR Number:   155343
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Tab controls and using multiline. When you resize the tab control to be smaller in the x-direction using resize() or by the width, height attributes, some of the multiline tab pages on the tab control (the ones that would be in "front") are not displayed and setredraw(true) doesn't fix the problem.



CR:155344
CR Number:   155344
Product Name:   PB Enterprise
Product Component:   DW Rich Text
Status:   Closed
OS:   MS Windows 3.1
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Preview function of a RichTextEdit control changes the margins of an RTF document. The RichTextEdit control does not restore document parameters (left margin, right margin, top margin, bottom margin) when a file is inserted into the control.



CR:155346
CR Number:   155346
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Customer has a window which instantiates an NonVisual User Object that has a function whose argument is a window. The NVO function passes back to the calling window an array of strings passed by reference. The NVO is calling the window function dynamically. When calling the NVO function he gets "Bad argument list for function/event" when passing the window by reference in conjunction with the string arrays by reference. If he calls the function statically then no problem occurs.



Cannot reproduce 6.0 Beta. Will not be addressed for 5.0.



CR:155348
CR Number:   155348
Product Name:   PB Enterprise
Product Component:   Menus - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Enable(), Disable() don't work with popup menus (menus created with popmenu). Must use m_item.enabled=false.



CR:155349
CR Number:   155349
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
The problem is actually that the Message.Powerobjectparm is not cleared well when closing the response window as it does not seem to be supposed to handle autoinstantiate content of Message.Powerobjectparm.

If you code Destroy Message.Powerobjectparm at the end of the open event of the response window, the problem is solved



PER DEVELOPMENT:

Fixed in 5.0.03. Not applicable to 6.0.



CR:155354
CR Number:   155354
Product Name:   PB Enterprise
Product Component:   Application Painter
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Oct 1998 Not a Bug
Description
Application Painter, Application Property sheet, long Library Path on the General tab truncates the end of the first line of the path, by cutting off the last letters.



You will see that the path is cut off at the end of the first line or if there was a space in the directory name, the rest of the file path goes to the next line, cutting off any text that doesn't fit.



CR:155357
CR Number:   155357
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
16bit - Connected to Sybase system 10 (Syc). Trying to run two 16 bit applications, they get a pbstub caused a gpf in pbsyc050.dll@0001:086a.

Using 10.0.03 of Open Client.



CR:155359
CR Number:   155359
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.x Catalina 1037 21 Jun 1999 Fixed
Description
When a crosstab is placed inside of another dw (nested or composite), the visible attributes of its drawing objects and labels is not taken into account. Computed fields and non-crosstab dw's are working fine.



CR:155363
CR Number:   155363
Product Name:   PB Enterprise
Product Component:   Business Graphics
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Series data is added to a graph control programmatically, then some of the properties of the graph are changed; graph symbols and symbol color to name a couple. If at least one of the series is deleted, the changed graph symbols go back to the default symbol, the changed symbol colors go back to the default, and the data points no longer match up with the category labels.



CR:155376
CR Number:   155376
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Dot notation not working when you try to get an entire array of data from a computed column in detail band. Could not get it to work with either string or numeric data. Element 2 of array has the data from the last row, and all the rest of the elements are either null or garbage, depending on the datatype of the array.



CR:155382
CR Number:   155382
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Apr 1999 Third Party Problem
Description
The FILE->Update menu item from an OLE Server (activating offsite!) is not updating the contents in a datawindow for a database OLE blob column, or for an OLE control in a window.



You must close the OLE server to have the changes updated in the datawindow.



CR:155384
CR Number:   155384
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 17 Apr 1998 Fixed
Description
PFC-16 and 32. of_FindItem()'s on treeview (and probably listview) recursive calls cause a stack fault when there are a large number of items to search through. 32 bit also stack faults - eventually.



Developer: There is a function nesting limit of about 58 calls under win16 due to OS limitations (1453 under win32) . The FindItem() function is called recursively in the object function and is therefore hitting this limit. The customer should change their code slightly or redo the treeview structure to have fewer elements..



CR:155390
CR Number:   155390
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 17 Apr 1998 Fixed
Description
Nup datawindow and it has 7 cells across. Clicking inbetween cells should return a "0" in the row argument - instead it returns the leftmost row number of the "visible" row. So you would get row 1, 8, 15, etc when clicking and not hitting an object.



CR:155392
CR Number:   155392
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.0.02 17 Apr 1998 Fixed
Description
Serial Column automatic update with a SQL Insert broken in 5.0.02.11. Just create a table with a serial and a char(10) column, create a datawindow based off it and you'll see it refresh the serial column of a newly inserted row correctly in 5.0.01 but in 5.0.02.11, the serial column always gets refreshed with a '0'.



Product Support Engineering: Fixed with other similar Identity problems either in the specific database driver or in DWE.



Used 16 bit Powerbuilder 5.0.01 and 5.0.02.11 under WFW 3.11. Broken in 5.0.02.10.



There is a related issue with multiple updates when there is an error in one of the update statements.



CR:155397
CR Number:   155397
Product Name:   PB Enterprise
Product Component:   Language - Compiler
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
To declare a window structure with an element which is also a structure, that sub-structure must have been defined first or you get an error "illegal data type: <sub-structure_name>." Easy to workaround, but if you define a window structure and then decide to alter it by adding a sub-structure element, you cannot do it. You have to declare the new structure which will be the new element, and then create your higher level structure again as a new structure. You can't simply change, for example, a string field/element to the sub-structure type.



PER DEVELOPMENT:

A type must be defined prior to use. The order of definition is preserved in the pbl. This restriction prevents 2 structures from being defined in terms of 1 another. Same issue in other languages like C.



Workaround : Export & reorder the structures.



CR:155403
CR Number:   155403
Product Name:   PB Enterprise
Product Component:   DPB
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
SetTransPool function for distributed Powerbuilder does not work with SQL Anywhere connections. Should this function work with local database ? With ODBC ?



Solution: If your application connections to the database through ODBC and only sets the dbms + dbparm fields, then you are not going to be able to take advantage of transaction pooling.





The following is bad:

sqlca.dbms = "ODBC"

sqlca.DBPARM = "ConnectString='DSN=NetImpact Dynamo Demo;UID=dba;PWD=sql;'"

connect using sqlca; // it will never get a hit in the transaction pool cache



The following is good:

sqlca.dbms = "ODBC"

sqlca.userid = "dba"

sqlca.dbpass = "sql"

sqlca.DBPARM = "ConnectString='DSN=NetImpact Dynamo Demo;UID=dba;PWD=sql;'"

connect using sqlca; // will get a hit



The deal is that our ODBC interface will suck the UserID + Password fields settings out of the dbparm and put them into our internal connection data structure's userid + password fields (not the transaction object fields).



So by the time that the disconnect does occur on the transaction object that originally didn't have the userid + password fields set, they will be set.



If the next connection attempt comes in without the userid + password fields set, then they will not take the cached database connection because the user id + password fields of the attempted connection must match the cached/pooled connection.



CR:155408
CR Number:   155408
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
When viewing a window script, the titlebar shows the specific text, ie. "Script - Clicked for dw_my_datawindow from uo_base_datawindow_single returns long". Under Windows 3.1, the text is getting truncated at around 78 characters.. Looks OK under Win95 and NT.



possibly only the dw.

recreated in win3.1, may be windows limitiation ??



StephenD: Reproduced only in Windows 3.11. I saw it only took 78 characters in the script painter sheet titlebar. We can fill the titlebar of a sheet from left-to-right in WFW 3.11 with greater than 78 characters. It does cut off so you can only see 78 characters .



PER DEVELOPMENT:

vendor bug - the same thing happens in 3.1 with the titles for message boxes



CR:155412
CR Number:   155412
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Closed
OS:   Solaris 2.5.1
Original Version:   5.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
This issue has been fixed as a result of another patch we received from Bristol to the WindU libraries.



CR:155413
CR Number:   155413
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Problems with the pipeline when using the Replace-Drop/Add table option and you are trying to update an informix 7 database using INET7.



User gets a "-310 table x already exists" error despite the fact that they are trying to drop and recreate this table.



CR:155414
CR Number:   155414
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Customer is using ole automation and is trying to pass decimals and reals to a method and is getting an error "R0051 Bad argument list for function/event calldecimal" when trying to pass a decimal to a method. When trying to pass a real, I get 0.00.



PER DEVELOPMENT:

retested this with 5.0.03 and 5.0.04 and both worked using the test scenario provided



CR:155418
CR Number:   155418
Product Name:   PB Enterprise
Product Component:   Structure - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Cannot print a window structure from File - print in window painter. Prints blank page. Can print global structure from structure painter no problem.



CR:155419
CR Number:   155419
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 17 Apr 1998 Fixed
Description
Problem fixed in bug #20404 for embedded SQL is not fixed for dynamic SQL: GetDynamicString is returning null for 256-multiple length strings.



CR:155420
CR Number:   155420
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Crosstab gives a GPF when you use both a sum and cumulativesum in the values section of the crosstab..



PER DEVELOPMENT:

Cannot recreate using 6.0.



CR:155422
CR Number:   155422
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Informix. If the user selects the option to 'prompt for database information on connect', when a database is selected from the 'databases' dialog, the OK button never enables. This dialog contains a listbox containing all the database names and an OK and Cancel button. Sometimes, when the database name isn't supplied in the dialog, you get the same behavior... a dialog to choose a database but once you choose it, you can't connect due to the OK being disabled..



CR:155428
CR Number:   155428
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Apr 1999 Duplicate
Description
Customer created a powerbuilder template file at begining of his application. Within the mdi sheet he created a child window with 2 sle's on it. He could not gain focus or edit paste on the second sle. Considering this scenario without the template file. i.e create your own mdi frame with sheet and child window then there is no problem at all. You can focus and cut and paste etc.. The problem seems to be with the powerbuilder template.

SOLUTION: This is a duplicate of CR 156272. It is a third party issue. See CR 156272 for details.



CR:155436
CR Number:   155436
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jul 1998 Presently Not Targeted For Any Future Release Of This Product
Description
External source rich text datawindow does not display imported rows (using Rows/Import after preview). You must go back into design mode and toggle back into preview to see the data.

July 8, 1998 - Product Support Eng.
There are no further enhancements planned for rich text datawindows so this will probably not be fixed.



CR:155437
CR Number:   155437
Product Name:   PB Enterprise
Product Component:   DPB
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Passing structures by reference to userobject functions can cause the return value of the function to be overwritten. Will be fixed in 5.03.01 build.



CR:155448
CR Number:   155448
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
GPF in USER.exe 0004:0000546f with a bad password parameter while connecting..



per development:

cannot recreate in 5.0.04.



CR:155449
CR Number:   155449
Product Name:   PB Enterprise
Product Component:   Function Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Return (none) from a user event becomes INTEGER return type if you go back into the user event. The source is saved correctly so it's the painter messing it up.



You must reset the return type to (none) each time you edit the event script or it will be saved incorrectly.



NOTE: Will only be fixed in 6.0



CR:155453
CR Number:   155453
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows 3.1
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Customer has a column in a dw with $###,###.00 as the editmask. If the customer changes the international settings in the control panel a strange behavior is observed.



Per Development:

This works in 5.0.0x and 6.0.0x. You sometimes have to restart PB to pickup locale changes.



CR:155457
CR Number:   155457
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
The Treeview Property 'DeleteItems' doesn't work, in script, or when checked (or, more to the point, when not checked) in the properties box. Even when you set it to false, the user CAN delete any items they want.



Developer: Expected Behaviour. The deletetitems attribute is for the DELETE KEY only.



CR:155459
CR Number:   155459
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Bitmaps for menu items Edit|Align, Edit|Space, and Edit|Size didn't appear under NT.



CR:155460
CR Number:   155460
Product Name:   PB Enterprise
Product Component:   Language - Compiler
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Using typeof() function using an ANY datatype in an IF...THEN statement. Works fine in the development environment. When trying to compile to a machine code executable, it gave the following error message:



codegen compilation error,see file c:\temp\cgen_compile_error.log



"syntax error, declaration statement follows an if statement"



Here is the line of C code generated causing the problem.

_boolTemp0 = err NO_TYPE left { _0bP_this, &_obdataARRAY[0 ] } == 8;



Offending line of Powerscript: (la_local is a variable of type any )



if la_local.typeof() = window! then

/* some code */

end if



Workaround: Use Choose...Case statement to take the TypeOf() out of the IF...THEN..



choose case la_local.typeof()

case window!

messagebox ('window','window')

end choose





Development: Any datatype no longer supports function calls. Closed a loophole in the compiler. Now gives compiler error - actually 2 for the 2 cases.



CR:155468
CR Number:   155468
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
PBEOL050. PowerBuilder's Object Cycle interface was not updating the [library] userID= entry in PB.INI upon successful connect. This can cause checkout status information for objects in a .PBL to be different from "checked out by" information in Object Cycle Manager.



CR:155470
CR Number:   155470
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
ENHANCEMENT. Save As.. HTML Table loses data occasionally using a freeform datawindow.



NOTE: Will not be fixed in 5.0. Needs re-architecting.



CR:155477
CR Number:   155477
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
PBEOL050. Object Cycle sub-folders are now supported in PowerBuilder 5.0.03 and 6.0. The restriction of only using folders one level deep in a project has been lifted. All sub-folders may be used when registering new PowerBuilder objects to Object Cycle.



CR:155478
CR Number:   155478
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 May 1998 Not a Bug
Description
Informix 7.1 using Inet 5 (and PBIN5xxx.DLL) causing a memory leak on the server using a combination of stored procedures and embedded SQL. Running the same SQL from the DBA notepad doesn't show the leak. There is a client side leak associated with this too.



This bug affects both 4.0 and 5.0 Powerbuilder. 4.0.06 should use WH1, 5.0 should use WJ2 of the 16 bit Informix Client software.



CR:155481
CR Number:   155481
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Deleting custom user event while the event script is open, causes a function to turn into an event script and corrupts the object.



NOTE: This will be fixed in 6.0 only.



CR:155483
CR Number:   155483
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
The problem is localized to the insertion of a dynamically created dw into a composite dw using libraryimport to create the dw and modify to change the dataobject of the composite datawindow's report. Within the development environment this runs as it should. When a pcode or a machine code exe is created, the dynamic dw is created (this can be seen by going into the library painter, into the pbl that houses the dynamically created dw to view the it) yet the child window that appears that is supposed to have the dynamically created dw does not contain the dynamically created dw, it contains the dummy freeform dw that was used to create the composite dw in the first place.



CR:155485
CR Number:   155485
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Connect dialog now has a check box - Save Password



CR:155494
CR Number:   155494
Product Name:   PB Enterprise
Product Component:   DB SQLAnywhere
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Pipeline of data sometimes terminates varchar column data - corrupting it and terminating it with a NULL. Oracle varchar to SQL Anywhere varchar columns.



CR:155498
CR Number:   155498
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 18 Sep 1998 Not a Bug
Description
Customer has a dw filled with data. There are 12 rows per page. If she scrolls down to the last row and hits the right arrow key the dw scrolls down one row. The customer does not want to redisplay another row.

PER DEVELOPMENT: left-arrow and right-arrow function the samve as shift-tab and tab. This is by design and will not be changed.



CR:155507
CR Number:   155507
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Simple nested report in header prints correctly on first page only. Doesn't print on other pages. Print or print preview - same behavior. This only happens if there are static text objects above the nested report. Removing the static text objects allows it to print fine as does embedding the text in the nested report or placing the static text below the nested report.



Development: Broken up to 5.0.02. 5.0.03, 5.0.04 and 6.0 Release. Appears to have been fixed by other fixes.



CR:155508
CR Number:   155508
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Enhancement. Would like the ability to print a datastore using a function similar to printdatawindow. Today, printdatawindow only works with a datawindow control. Most nvos uses datastores but still need printing capability like this.



The workaround of using an invisible datawindow control(s) for each datawindow defeats the purpose of using a datastore to begin with



CR:155509
CR Number:   155509
Product Name:   PB Enterprise
Product Component:   Machine Code Deployment
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
If a string is passed by reference to a user object function which appends to the string using the string() formatting function, a gpf occurs in 32 bit compiled machine code.



string s_buffer

s_buffer = "1234"

s_buffer += string(fs_override, "@@@@@@@@")



Workaround:



In the user object function create a temp string variable and perform the string function addition to it. Then assign the value of the temp variable to arg1. For example, replace the existing code in the user function with this code:



string temp

temp="1234"



temp += string("1234","@@@@@@@@@@")

arg1 = temp

return 0



Now 32 bit machine code will compile and run.



CR:155510
CR Number:   155510
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows 3.1
Original Version:   4.0.06
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.x Catalina 1037 14 Apr 1999 Fixed
Description
In a datawindow with groups, in the detail band, create a computed field defined as first(<column> for group 1) or last(<column> for groupg 1). If the computed field references a date column, the column behaves as if Suppress Repeated Values is turned on for that computed field, even though it is not. If the column is number or character, it behaves as expected, i.e. repeating values are not suppressed, and the computed column displays on each row as desired. Reproduced this behavior in 4.0.07 and in 5.0.02.



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

WORKAROUND:

Use a dummy date column in the datawindow result set and dwFindGroupChange function to loop through the datawindow, then getitemdate of the first row in each group, SetItem(date) to the dummy column.



CR:155513
CR Number:   155513
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Feb 1999 Fixed
Description
user has a find() (obsolete function name dwfind()) which searches for a string match in a datawindow column. A single quote is part of the text that is being searched for. This single quote causes a parsing problem upon executing the find function.



SOLUTION: replace the embedded single quote with 3 tildes and a quote. For example to search for "O'Connor" parse the search string, and modify it to pass "O~~~'Connor" to the find function.



This is probably not a bug, but is being routed to development for forwarding to documentation to clarify the function's behavior, and how it uses all those tildes preceding the quote.



CR:155514
CR Number:   155514
Product Name:   PB Enterprise
Product Component:   DW Rich Text
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
When an RTF file is inserted into an RTF Presentation Style DataWindow, previewed, then saved, when the DataWindow is edited again, the margins have moved messing up the original formatting of the RTF document. The reformatting tends to be more severs using Windows NT.



CR:155524
CR Number:   155524
Product Name:   PB Enterprise
Product Component:   Machine Code Exe Creation
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
16-bit machine code executable will not run if you create a dll which has the same name as the executable. Application execution error (R0014) Application terminated- error:error opening DLL library <exename.dll> for external function.

Works OK with pbds, or with 32-bit machine code.



PER DEVELOPMENT:

This is a 16 bit limitation caused by the OS. The call to LoadLibrary is failing. A simple workaround is to rename the .exe. This will only work if you gen everything to use dlls.



CR:155529
CR Number:   155529
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Locking for Informix 5.x doesn't seem to be working. Locking a record using an UPDATE embedded SQL statement and sqlca.lock= "Committed Read" still allows retrieval of information from the row. Behavior sometimes is a GPF in PBRTE050.DLL after receiving a -246 error.



CR:155530
CR Number:   155530
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Visual basic control (mscomm) Worked with PB 4.0x, in 5.0x the SendData causes a gpf in pbroi050 @ 0001:0780.





--------------------------------------华丽的分割线-------------------------------------------------------------------------

Sybase SQL Anywhere数据库恢复工具ReadASADB:

之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具: ReadASADB。
此工具支持ASA v5.0, v6.0, v7.0, v8.0, v9.0, v10.0, v11.0, v12.0, v16.0, v17.0等版本。
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具。
恢复Sybase SQL Anywhere的工具在国内处于领先水平。

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,16.x,17.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使用介绍

Sybase SQL Anywhere数据库恢复工具ReadASADB适用场景

各种误操作:

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

Sybase SQL Anywhere数据库恢复工具ReadASADB的应用场景:

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
7、*** ERROR *** Assertion failed: 201417 (7.0.4.3541) Invalid count or free space offset detected on a table page
8、Internal database error *** ERROR *** Assertion failed: 201425 (8.0.3.5594) Invalid count or free space offset detected on a free list page -- transaction rolled back.
9、Internal database error *** ERROR *** Assertion failed: 100702 (8.0.1.2600) Unable to modify indexes for a row referenced in rollback log -- transaction rolled back


-------------------------------------------------------------------------------------------

Sybase ASE数据库恢复工具READSYBDEVICE:

一个不依赖数据库管理系统、直接从Sybase数据库设备文件上提取数据的业内领先的恢复工具!
能够从损坏的Sybase ASE设备文件(.dat)上提取数据的非常规恢复工具。

Sybase ASE数据库恢复工具READSYBDEVICE的主要功能:

  1. 被勒索病毒加密数据文件及备份文件情况下的恢复;
  2. 系统崩溃只剩下数据文件的情况下的恢复,甚至数据库文件不存在而只有损坏的备份文件情况下的恢复;
  3. 因断电、硬盘坏道等造成数据库文件损坏情况下的恢复;
  4. delete数据恢复、误update数据恢复、误删除表(drop)恢复、误truncate表恢复 等;
  5. 各种Sybase内部系统表损坏、索引错误的修复;
  6. master数据库损坏而无法正常运行情况下的恢复;
  7. Sybase数据库被标记为可疑,不可用等情况的恢复;
  8. Sybase数据库中数据文件内部出现坏块情况下的恢复;
  9. Sybase数据库无数据文件但有日志文件的情况下的恢复;
  10. Sybase数据库只有数据文件无任何日志文件的情况下的恢复;
  11. Sybase数据文件被误删除情况下的碎片提取恢复;
  12. 磁盘阵列上的Sybase数据库被误格式化情况下的数据库恢复;
  13. 数据库sysobjects等系统表损坏无法正常应用情况下的恢复;
  14. Sybase数据库还原数据库出现失败情况下的恢复;
  15. Sybase数据库只剩下损坏的备份文件情况下的恢复。

Sybase ASE数据库恢复工具READSYBDEVICE支持的版本:

Sybase ASE 11.0.x,11.5.x,11.9.x,12.0.x,12.5.x,15.0.x,15.5.x,15.7.x,16.0.x


-------------------------------------------------------------------------------------------

SQL Server数据库恢复工具SQLRescue:

一个不依赖数据库管理系统、直接从SQL Server数据库文件上提取数据的业内领先的恢复工具!
能够从损坏的SQL Server数据库文件(.mdf)上提取数据的非常规恢复工具。

SQL Server数据库恢复工具SQLRescue的主要功能:

  1. 系统崩溃只剩下数据文件的情况下的恢复,即无日志文件或者日志文件损坏情况下的恢复;
  2. 断电导致数据库文件损坏情况下的恢复;
  3. 硬盘坏道造成数据库损坏情况下的恢复;
  4. 数据文件内部存在坏页情况下的恢复;
  5. 企业管理器误删除数据表记录,管理软件误删除数据表记录的恢复;
  6. 并闩锁错误、格式化、误删除后导致软件不能使用的情况;
  7. 无法读取并闩锁页sysindexes失败情况下的修复;
  8. 数据文件被误删除情况下的碎片提取恢复;
  9. 系统表损坏、索引错误、误删除数据库表、删除记录的数据找回;
  10. master数据库损坏而无法正常运行情况下的恢复;
  11. 数据文件无法附加情况下的数据恢复;
  12. 数据库被标记为可疑,质疑,不可用等情况的恢复;
  13. 数据库sysobjects等系统表损坏情况下的恢复;
  14. 数据被误(drop、delete、truncate)删除表数据的恢复,误update后的数据恢复等;
  15. 还原时报一致性错误,错误823等情况下的数据恢复,各种错误提示的数据库文件修复;
  16. 数据库被误格式化等情况下的数据库恢复;
  17. 日志收缩造成数据库损坏情况下的恢复;
  18. 仅剩损坏的备份文件情况下的恢复。

SQL Server数据库恢复工具SQLRescue技术特点:

只要SQL Server数据库的数据文件存在,我们就有办法帮您从数据文件中找回重要数据。
  1. 从数据文件中直接恢复数据
  2. 不能附加时直接恢复数据并生成新的数据库
  3. 系统表损坏的数据库修复
  4. 快速修复SQL 823错误、连接中断错误

SQL Server数据库恢复工具SQLRescue支持的版本:

Microsoft SQL Server 7.0, 2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017,2019。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------