远程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:164270
CR Number:   164270
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 1998 Third Party Problem
Description
16 bit and 32 bit. ole_1.object.application.cells(1,1).value = value fails after 35-48 attempts using 16 and 32 bit PB and 16 and 32 bit Excel. Fails with inserting into many cells or into the same cell. The number of attempts before failing depends on the version of Excel. Excel 5 errors out at 35.



Error received: R0035 message- Error Calling External Object Function 'Cells'. Underlying this error is one coming from Excel 5.0 from using PB's internal traces:



...GetProperty Invoke returned 0x00000000

...GetDispID - GetIDsOfNames returned 0x80010002 << here

PBROI_Term()

PBROIApplication:: dtor



NOT A POWERBUILDER BUG:

This issue also happens in Visual Basic 4.0 16 bit and 32 bit. The script that duplicates the error:



The same thing (OLE2) on Visual Basic 4.0 gets the same error after 47 iterations.



Script under a command button going against the Excel 5.0c Worksheet on a Visual Basic form.



Dim count As Integer

For count = 1 To 300

Label2.Caption = count

OLE1.object.cells(1, 1).Value = 1997

Next count



The runtime error in Visual Basic 4.0 16 bit under WFW 3.11 using Excel 5.0 16 bit.

Runtime Error: Ole automation error: -2147418110 (80010002)<<<< Notice same 80010002 error from Visual Basic 4.0.



The runtime error in Visual Basic 4.0 32 bit under Win95 using Excel 7.0 32 bit

Runtime error: Ole Automation Error: -2147023174 (800706ba). Excel 7.0 dies at 545 iterations.



NT 4.0 seemed to be a little bit more robust and VB 4.0 32 bit and Excel 7.0 32 bit completed 3000 inserts.

The Microsoft issue # is SRX971009600309.



CR:164272
CR Number:   164272
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)
21 Dec 2000 Not a Bug
Description
When decimal numbers reach the overflow condition the reported value of the decimal is inconsistent



CR:164273
CR Number:   164273
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Sep 2002 Fixed
Description
Getting message "999: An invalid handle was passed in a call to the database driver." when trying to OPEN CURSOR or EXECUTE PROCEDURE in Format 3 Dynamic SQL using ODBC driver to execute an Remote Stored Procedure on the DB2 mainframe that returns a result set. This is code that works using the MDI gateway native driver (MDI), but fails when using ODBC against the DirectConnect DB2 Access Service (essentially the old MDI Gateway).



CR:164278
CR Number:   164278
Product Name:   PB Enterprise
Product Component:   Function Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 28 Apr 1998 Fixed
Description
Using the reserved word 'Step' for a function argument as an array (step[]) is not caught by the compiler and this causes problems if you save the function and try to re-open it. Also causes an error during import. (5.0 and 6.0 affected)



Other reserved words also have this problem such as "update[]", etc.



The script compiler catches this.



CR:164297
CR Number:   164297
Product Name:   PB Enterprise
Product Component:   System Runtime Functions
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jul 1999 Fixed
Description
ProfileString not matching on spaces and equal sign embedded in the section name. Just a doc issue ?



User reports that ProfileString is not correctly matching if a section header includes an equal sign surrounded by spaces.



This is probably not a bug, we probably just send the call right to GetPrivateProfileString and that is not handling the spaces the way the user expects, but I didn't find documentation on GetPrivateProfileString that specifically addressed this scenario and user wants this reported as a bug.



Here is what the profile.txt file looks like:

<beggining of file>

[section 1]

key=Banana



[section = 1]

key=Apple



[section=1]

key=Orange



[section =1]

key=Grape



[section= 1]

key=Guava



<end of file>



In Powerbuilder, here are the function calls and what is returned:

Profilestring("c:\profile.txt","Section 1","key","Failed!") >>> Returns Banana

Profilestring("c:\profile.txt","Section=1","key","Failed!") >>> Returns Apple

Profilestring("c:\profile.txt","Section = 1","key","Failed!") >>> Returns Failed!

Profilestring("c:\profile.txt","Section =1","key","Failed!") >>> Returns Failed!

Profilestring("c:\profile.txt","Section= 1","key","Failed!") >>> Returns Failed!



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

PER DEVELOPMENT:



The GetPrivateProfileString function in Windows does the space mangling you are seeing. If you really need to care about spaces inside key names, you will need to embed quotations. Personally I recommend against it as Microsoft is no longer actively supporting INI files. However the following information from the Knowledge Base may be useful:



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

An application can retrieve information from a profile file by calling the GetProfileString or GetPrivateProfileString function. If the profile file associates the specified lpKeyName value with a string that is delimited by quotation marks, Windows discards the quotation marks when it copies the associated string into the application- provided buffer.



For example, if the following entry appears in the profile file:

[application name] [application name]

keyname = 'string' or keyname = "string"

The GetPrivateProfileString and GetProfileString functions read the string value and discard the quotation marks.



This behavior allows spaces to be put into a string. For example, the profile entry

keyname = string

returns the string without a leading space, whereas

keyname = ' string' or keyname = " string"

returns the string with a leading space.



Doubling quotation marks includes quotation marks in the string. For example:

keyname = ''string'' or keyname = ""string""

returns the string with its quotation marks -- 'string' or "string".



CR:164306
CR Number:   164306
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Dec 2000 Fixed
Description
Problem description::16 bit. Customer is using OLE and MS Word 97. Runing an application using OLE automation causes GPFs.



When closing word I get a GPF "PB050 caused an invalid page fault in module rpcrt4.dll at 0137:7fd07317.



The next GPF I get is " GPF in KRNL386.EXE "



CR:164307
CR Number:   164307
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)
Fixed
Description
*** 5.0.03 Regression ***

Customer is sharing data between two datastores. RowCount() from secondary datastore comes back with 0 (zero), it should be 2.



CR:164308
CR Number:   164308
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jul 1998 Fixed
Description
5.0.03 Regression. Win 3.11 only. OLE Blob column in datawindow causes painting problems on the datawindow when using 16 bit and closing the server application - in this case - Word 6.0 16 bit. Users must re-retrieve to force the datawindow to correct the painting problem. Development and runtime.



Development: This particular issue was fixed when other OLE window redraw issues were fixed.



CR:164311
CR Number:   164311
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Fixed
Description
Crtl+X and Ctrl + V don't work in an editmask control.



CR:164312
CR Number:   164312
Product Name:   PB Enterprise
Product Component:   Menus - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Fixed
Description
Problem description:: Menus or toolbars do not activate when closing a response window while multiple sheets are open ..



Customer has an MDI application. He opens a sheet, and pops a menu with a right mouse click that opens a response window.



He then right mouse clicks the reponse window which pops up another menu.



Once he closes the reponse window, the menu on the frame does not work. You can navigate the menu, but no scripts are executed when a selection is performed.



CR:164327
CR Number:   164327
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 19 Mar 1999 Presently Not Targeted For Any Future Release Of This Product
Description
Connecting with Powerbuilder to Adaptive Server 11.5. Pulling up the list of tables in the painter gives the error "301 error message:- Query contains illegal outer join request".



This is due to a problem with a subselect statement in the pbsyc2.sql that comes with either pb 5.0 or 6.0. Pbsyc2.sql changes the syntax for the sp_pb50table stored procedure created in pbsyc.sql so the user sees only tables that he has access to. You can use the original sp_pb50table (or sp_pb60table) stored procedure that comes in the pbsyc.sql file by rerunning the pbsyc.sql file or if you want to fix the pbsyc2.sql file the following change can be used:-



Original statement:

or ((select max(((sign(uid) * abs(uid-16383)) * 2) + (~(protecttype/2)))

from sysprotects p

where p.id =* o.id

and (p.uid = 0

or p.uid = user_id()

or p.uid =* u.gid)



Change to:

or ((select max(((sign(p.uid) * abs(p.uid-16383)) * 2) + (~(protecttype/2)))

from sysprotects p,sysobjects q, sysusers r

where p.id =* q.id

and (p.uid = 0

or p.uid = user_id()

or p.uid =* r.gid)



CR:164330
CR Number:   164330
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)
09 Oct 1998 Not reproducible with latest version of the product available as of Resolution Date
Description
Powerbuilder executables formerly had no means of returning an exit code to the operating system. This has been addressed by allowing the user to set the message.longparm as the last line of the application close event--this value is then passed out to the OS as the return code.



CR:164332
CR Number:   164332
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)
05 Oct 1998 Fixed
Description
After modifying the Edit.Case property of a column for a datawindow by script dw_1.Modify ("column_name.Edit.Case='lower'"), you get an uncomplete syntax when you execute dw_1.describe ("datawindow.syntax") from the modified datawindow.

Dot notation gives also an uncomplete syntax. The "edit.case = lower" is missing in the resulting syntax.



CR:164342
CR Number:   164342
Product Name:   PB Enterprise
Product Component:   Web.PB
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 31 Jul 2001 Fixed
Description
Using the PBNS2050.dll NSAPI interface in the Netscape Enterprise Server v3.0 with encryption (SSL) turned on doesn't work. If you turn off encryption on the web server it works fine.



Solution Per Development:

This issue has been defined as an enhancement and not as a bug. The interface was developed in accordance to the Netscape Enterprise 2.0 NS-API interface. Therefore Powersoft's statement currently is that we don't support the NS-API 3.0 interface. This same situtation happens each time a database vendor provides an new version of their database drivers. Development has committed to and is working on a NS-API 3.0 interface.



CR:164345
CR Number:   164345
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Problem description:: win 95, win nt 4.0

Customer is handling pointers to methods when using an ole object. Customer has created a dll using MS VC++ ver 5. 2 gpfs occur when closing an application involving the invokation of variant and long arrays



On win 95 Error "PB050 caused an exception 03H in module KERNEL32.DLL at 0137:bff76694."



On win NT 4.0 " " The exception Breakpoint has been reached. (0x80000003) occured in the app at 0x77f75d64."



10-15-97



Development says that the return coming back from the server is of unknown memory size. So the user will need to know ahead of time what memory to allocate or pass unbounded arrays.



CR:164350
CR Number:   164350
Product Name:   PB Enterprise
Product Component:   Shared Objects
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Problem description: Object browser. Trying to find the hierarchy of particular objects cause a GPf at PBRTE050.DLL at 0137:10b14472. This can easily happen if the objects are in a PBL that's left off the library list by mistake. It should produce the same compile errors that a script compile with a missing object does or a migration does.



In win NT 4.0 get a Dr. Watson

An application error has occurred and an application error log is being generated PB050.exe.

Exception: access violation (0xc0000005, Address 0x10b14472)



In win 95

the error message there is:

PB050 caused an invalid page fault in

module PBRTE050.DLL at 0137:10b14472.



Solution Per Development:

This can't be fixed in 5.0 because it requires an architectural change. The library list has to be correct. In 6.0, no GPF occurs (but there is no helpful error message). This type of message is already given during incremental rebuilds, etc.



CR:164351
CR Number:   164351
Product Name:   PB Enterprise
Product Component:   Installation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 1998 Not reproducible with latest version of the product available as of Resolution Date
Description
**** 5.0.03 regression ****. When installing from the 5.0.03 enterprise CD (the FULL CD), it doesn't install PBDSE050.DLL. When you try to bring up Powerbuilder, it gives you an error "PBDSE050.DLL" not found.



CR:164352
CR Number:   164352
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 1998 Presently Not Targeted For Any Future Release Of This Product
Description
Win95 only. Running a 16 bit PB application, then a 32 bit PB application causes a gpf in pbshr050.dll @0009:00000107 or 0000010a. If you run the 32 bit application first and then the 16 bit application everything is fine.



In 6.0, the GPF is in module PBVM60W.DLL at 002c:00000101.



NOTE: The original bug to fix window class collisions bug 41416 - is still OK. 41416 was strictly window class name collisions. This particular bug occurs when there is a datawindow on the particular window(s) in the 16 and 32 bit application.





Per Development:

This issue cannot be addressed in any maintenance release or EBF. This is because changing class names will affect existing applications that are dependent upon the original class names.



CR:164354
CR Number:   164354
Product Name:   PB Enterprise
Product Component:   System Runtime Functions
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 1998 Not a Bug
Description
Unable to retrieve keys/values from the registry when running the 16 bit PB on NT 4.0 using key HKEY_CURRENT_USER, but can with 32 bit PB on NT 4.0. Can use key of HKEY_CLASSES_ROOT on both.



Development: This is a documentation issue. Registry functions all refer to RegistrySet for detailed usage info. RegistrySet documents that HKEY_CLASSES_ROOT is the only root string accessible on Win 3.1.



CR:164355
CR Number:   164355
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Nov 1998 Presently Not Targeted For Any Future Release Of This Product
Description
If you use hh:mm for a date editmask in a datawindow, and you change data, the system always sends back "2000" for the year instead of the original year.



1950-02-15 becomes 2000-01-01 in the "date" portion when you're only trying to change the "time" portion.



The bug perhaps here is that since the date value is in the buffer, why generate a bogus date on something already retrieved.



If you leave the date portion off by editing the "sqlpreview", you get todays date



UPDATE "timestamp" SET "timestamp1" = '12:15:35.000000'

WHERE "newid" = 1 AND "timestamp1" = '1950-03-15 12:10:00.000000'



becomes



January 8, 1998 12:15:35 - the date this issue was entered.



If you let it default, the system always generates 2000-01-01 for the date portion.



CR:164356
CR Number:   164356
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Fixed
Description
32 bit. REGRESSION 5.0.03

Customer is using an OLE/OCX gamesman control. The control is CTyear. He was originally using pb 5.0.02 and the control worked fine. When he went to 5.0.03, they were having trouble with ole/ocx controls.



You get an error about external function daycolor not being passed the correct number of arguments.



CR:164357
CR Number:   164357
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)
Fixed
Description
***5.0.03 Regression***

Drag and drop: dragging from a dw and move to another dw which happens to not be a valid drop dw, it changes to the invalid drop icon, but when moving cursor away from the invalid drop dw to a valid drop dw, the icon never changes back and it starts to flicker then a page fault occurs: PBRTF050.DLL@0137:10d1f67f (in 32bit). In 16bit, it boots you out of powerbuilder and windows.



CR:164361
CR Number:   164361
Product Name:   PB Enterprise
Product Component:   P-Code Exe Creation
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Fixed
Description
Unable to generate an Exe WIN 3.1 with PB 5.0.04_54



CR:164363
CR Number:   164363
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)
7.0.00 Beta 3 3242 23 Nov 1998 Fixed
Description
When using the SelectText function on a datawindow column that has an EditMask of ##:## or 00:00, you cannot immediately start entering the replacment text. If you do, only one character can be entered because the previous contents are removed and cursor remains at the end of the edit field.



CR:164365
CR Number:   164365
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 22 Oct 1998 Fixed
Description
Oracle8 driver: In the table painter, object datatypes don't have their Width, Dec, Null, or Default columns grayed out, and also extended attributes, so it looks as if you can change them. If you do and attempt to save the table, will gpf in pbor8xx.dll.



CR:164367
CR Number:   164367
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Apr 2000 Fixed
Description
Using ODBC driver - ASYNC=1, DBCancel() and comment/code in RetrieveRow event for asynchronous processing. If retrieve is cancelled before even one row comes back, the next time you try to retrieve an error occurs:

- Error "CLI0125E Function sequence error. SQLSTATE=S1010" (for DB2/MVS)

- SQLState=S1000 Connection is busy with results for another hstmt (for MS SQL Server)



CR:164369
CR Number:   164369
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)
24 Sep 1998 Not a Bug
Description
Developer is dynamically creating the datawindow and wants the user to be able to move columns in a grid, etc drag & drop to select columns.

Development: Needs the dot notation or Modify() after the fact to change the moveable attribute. A dynamically created datawindow might not have these and definitely not if it isn't a grid.



CR:164370
CR Number:   164370
Product Name:   PB Enterprise
Product Component:   Shared Objects
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Fixed
Description
Beta 6.0 build 235 - SharedObjectRegister() function, causes page fault if a user object is registered in the constructor event of another user object that has been instanciated. PB60 caused an invalid page fault in module PBVM60.DLL at 0137:10c4711d.

Note: no SharedObjectGet() is involved



CR:164374
CR Number:   164374
Product Name:   PB Enterprise
Product Component:   Library Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 04 Nov 1998 Fixed
Description
6.0 build 248 RC3. Library painter. Comments for objects that have duplicate names (a menu and a window named 'm_test' show the comment of the first object.



CR:164375
CR Number:   164375
Product Name:   PB Enterprise
Product Component:   Plug-ins
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 31 Jul 2001 Fixed
Description
6.0 beta Regression. Posted events (postevent ('ue_event') do not get fired when they are called as part of an internet application on the window plug in. Both the window plugin and the Window ActiveX control show the same problem. Worked in 5.0.



Workaround: Use Triggerevent()



CR:164378
CR Number:   164378
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 03 May 2000 Not a Bug
Description
Datawindow that has a titlebar causes problems with autoselection. When editing the field, autoselection keeps the entire field selected when it should shut off when users start editing. It should only stay highlighted when the field initially has focus.



Probably closely related to child window with titlebar bug 41443. As with bug 41443, HOME/END seems to unhighlight the edit control so users can edit.



CR:164381
CR Number:   164381
Product Name:   PB Enterprise
Product Component:   Plug-ins
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jul 1998 Fixed
Description
Beta 6.0 - builds 220 & 230. Datawindow Plug-in.

DW plugin does not show up in Internet Explorer; in Netscape after hitting the reload button two page faults occur: NPDWE60.DLL@0137:00ebb2fc, click OK another page fault in MFC40.DLL@0137:5f80103b.



CR:164383
CR Number:   164383
Product Name:   PB Enterprise
Product Component:   Shared Objects
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Fixed
Description
*** 5.0.04 Regression *** Strange display behavior in PB development environment. Happens on NT 3.51 16 bit PB + prereleased 5.0.04 dlls only.



Comments: 16 bit on NT 3.51 only !

Step-By-Step Instructions (In development environment):

1) go into the Application painter

2) right mouse click , selecting properties,

3)-> the tab folders are "white-ish" without any 3d effect.



CR:164386
CR Number:   164386
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)
04 Jan 2001 Fixed
Description
memory leak when calling the chartgroups collections of the OCX "Olectra Chart" from the KL Group. expl. ole_1.object.chartgroups[1].elevationdata.value[i,j] = rand(100)



CR:164388
CR Number:   164388
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)
24 Sep 1998 Not a Bug
Description
If you have two tab controls on a window and the tab controls are marked "Create on Demand", the constructor event of the first tab control (tab_1) tabpage does not fire. The constructor event of the second tab control (tab_2) tabpage does fire as does the constructors of objects on that tabpage.



PER DEVELOPMENT:

The tab control functions correctly in both 5.0 and 6.0. The above test scenario can't be used to verify the tab control behavior, because MessageBox calls disturb the message control flow.

To verify that all constructors are being called please replace the MessageBox calls with e.g. writing to a file. You will find that the constructor events for selected tab pages and controls on the selected tab page are always triggered even though CreateOnDemand is TRUE.



CR:164392
CR Number:   164392
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Fixed
Description
Oracle 7.3. Invalid interpretation of the type NUMBER by PB. Defining a column of type NUMBER in Oracle. It is a NUMBER (22) by default in Oracle. In database painter, it appears as a FLOAT (22).

When creating a pipeline based on this table, the column appears as a NUMBER(43,5). This produces an error : "numeric precision specifier is out of range (1 to 38)"



CR:164402
CR Number:   164402
Product Name:   PB Enterprise
Product Component:   ORCA
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 31 Oct 2002 Fixed
Description
Problem description: Regression in pb 6.0 that was fixed in pb 5.0.03 . Customer will get an access violation in PBCMP60.DLL when machine code dlls are created in a second orca session. A similar issue 353609 was fixed in 5.0.03 . This issues has been broken again in pb 6.0 panther build 203 - 251.



If you step through the source code in the second session and place a break point

and step via the debugger in assembly language you will get a message that an Access Violation error occured. The title bar will read " PBCMP060.dll " which indicates the dll is broken. All other dlls that are read in to this point have no errors attached.



CR:164405
CR Number:   164405
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 1998 Not a Bug
Description
'Row changed between retrieve and update' error when modifying a character column in a SQL Anywhere database.



WORKAROUND: Using the pipeline to re-create the table seemed to clear up the problem.



Development: - If you unload of database, and examine the data contained in the .dat files, you will see that the "date" column "fccreacion" is of type date, but the data is actually of type datetime. Now, this would not cause a problem if all the time portions were set to 00:00.

(I believe that all dates are stored as datetimes internal to the db). In this case, however, there is a specific time stamp associated with some of the rows. If you go through the .dat file and see which rows have the 00:00 time stamp, you will find that the "row changed between retrieve and update" message will not occur. For example, try to change/update row 1 ( '2BDAT', -1 ). There will not be a problem. I believe that when you pipelined the data, it must have stripped the time ( zeroized ).



An example of an inserted value that might "take" and get stored in the database as a datetime:



'95-12-01 00:00:02'



CR:164406
CR Number:   164406
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 03 Aug 2000 Fixed
Description
Informix 7.22 using IN7 driver - when trying to update a decimal value below 0.5 and binding is used (DisableBind=0 / default) - With 5.0.04 driver no error, but the update has no effect.



CR:164408
CR Number:   164408
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)
6.0.01 12 Dec 2000 Fixed
Description
If a function returns an ANY datatype variable and a NULL decimal variable is cast into the ANY return value, the function call GPFs at the RETURN statement of the function if you're using machine code. There are no problems in development or p-code.



The PFC-Specific GPF:



gpf in pfcdwsrv.DLL 0137:02a1276e



This is not the same as bug 40759 which was fixed in 5.0.03 regarding a GPF right at a getitemdecimal() call going to a NULL decimal column.. This bug specifically deals with returning a NULL decimal cast to an ANY datatype variable and GPFing right at the "RETURN <any variable>" statement. This is exactly how of_getitemany() FORMAT 4 is structured in PFC "pfc_n_cst_dwsrv". PFC uses a non-visual user object function but this can be recreated this with a window function.



NOTE: ALL other numeric datatypes work in machine code with NULLs using of_getitemany() - datawindow types ULONG, LONG, REAL, NUMBER all work correctly.



This bug exists in 5.0 and 6.0



Workaround: (for PFC users)



First option

=========

Make the calls to Getitemdecimal() manually rather than using of_getitemany(). You could evaluate the "Describe("#1.coltype") and only if it returns "decimal", use Getitemdecimal() manually with in-line script.



Second Option

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



Object: pfc_n_cst_dwsrv



Function of_getitemany() format 4 - returns ANY



CASE....

...

CASE "decim"

la_value = dw_1.GetItemDecimal ( al_row, as_column, adw_buffer, ab_orig_value )



// Add some checking code here

if isnull(la_value) then

decimal ld

ld = "-100"

la_value = ld

// cast this with a NON-null but identifyable value so it doesn't GPF at the 'return' call



return la_value

/*----------- end of of_getitemany() function ----------*/



/* back in powerscript - trap for your decimal NULL condition*/

decimal ld_decimal

setnull(ld_decimal)



if of_getitemany(x, y) = -100 then

setitem(a,b,ld_decimal)

end if



DEVELOPMENT: Fixed in compiler in pb 5.0.05 and later. Requires regenerating your machine code exe.



CR:164412
CR Number:   164412
Product Name:   PB Enterprise
Product Component:   Structure - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Nov 1998 Fixed
Description
In structure painter when moving rows with the mouse (no keyboard) and then saving, the structure is not being saved.



CR:164415
CR Number:   164415
Product Name:   PB Enterprise
Product Component:   Plug-ins
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jul 2001 Fixed
Description
*** 5.0.03 Regression *** There is a problem with datawindows displayed in the Window Plug which use checkbox or radiobutton editmask's. The checkboxes are always checked. They also appear as a yellow checkbox with a red check in them. The radio buttons on the other hand are a red blob that you can not determine if they're checked or not. Clicking between the two radio buttons doesn't change either.



CR:164417
CR Number:   164417
Product Name:   PB Enterprise
Product Component:   Shared Objects
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 May 1998 Not a Bug
Description
Beta 6.0 builds 230 & 235: The STRING() function does not work if data = ErrorReturn. It does not give an error, it just comes up blank in a MessageBox or SLE.



Solution:

Please refer to the documentation for String() in the Return value section. It specifies that it returns and empty string if the data type of the data passed is an incompatible type. Enums are not compatible w/ this function



CR:164418
CR Number:   164418
Product Name:   PB Enterprise
Product Component:   Shared Objects
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jul 1998 Not a Bug
Description
Beta 6.0: Messagebox appearing behind window when called from SharedObject UO_function()



Solution:

This is not a bug. As indicated in the 6.0 documentation you should not call any visual function from a shared object or server session. On Unix they will not work. See above for more detail.



CR:164423
CR Number:   164423
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 23 Jul 1999 Fixed
Description
Button object on a datawindow. Documentation/help is incorrect when descibing the datawindow buttonclicking, buttonclicked, and clicked events.

See PSE notes in issue for details.



DOCUMENTATION ERROR:

The documentation and help should refect this.



1) The clicked event on the dw will fire first if there is code in it. The return code here is unchanged from 5.0 and has no effect on the new button events. Return 0 allows normal dw processing to continue (ie, column clicked on gets focus), Return 1 stops the focus from changing.



Note it is not a good idea to use messageboxes in this event. It can inhibit the button events that follow.



2) There are two new events in the dw; buttonclicking and buttonclicked. These will be fired as described below. Also there is a Suppress Event Processing property for the button object. If it is on, the buttonclicking and buttonclicked events are not fired, but the action assign to the button is executed.



3) If the Suppress Event Processing property is off, the buttonclicking event will fire after the clicked event (if the clicked event has code), and before the action assigned to the button is executed. A return code of 0 here allows the action to be executed followed by the buttonclicked event. A return code of 1 will inhibit the action from being performed, and inhibit the buttonclicked event. So processing here prior to the action can be used to inhibit the action from executing.



The order of events then is:



Suppress Event Processing ON:

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

1) clicked if coded

2) button action executed





Suppress Event Processing OFF:

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

1) clicked if coded

2) buttonclicking

3) button action executed (if buttonclicking returned 0)

4) buttonclicked (if buttonclicking returned 0)



CR:164427
CR Number:   164427
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)
06 Dec 2000 Not reproducible with latest version of the product available as of Resolution Date
Description
Transparent background pick is not available on the "background color" button of the toolbar although if the user sets the property in the property sheet, they get a box representing it on the painterbar.



[n] <--- This means transparent when set from the property sheet. This is not available from the dropdowntoolbar.



CR:164429
CR Number:   164429
Product Name:   PB Enterprise
Product Component:   Migration
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 09 Oct 1998 Not reproducible with latest version of the product available as of Resolution Date
Description
Beta 6.0 - Application Gallery:

Migration of FTPTest.PBL with SOCKETS.PBL omitted causes gpf in pbvm60.dll



Migrated an application from the AppGlry\FTP\FTPTest.pbl. I accidentally did not include both pbl's (omitted sockets.pbl from library list) and received a gpf in pbvm60.dll. (in build 220 I received a gpf in pbcmp60.dll)



CR:164433
CR Number:   164433
Product Name:   PB Enterprise
Product Component:   P-Code Deployment
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 13 Nov 1998 Fixed
Description
*** 5.0.03 Regression *** Powerbuilder 16bit P-code ONLY.

Has a function that retrieves the sql statement appropriate for the particular db connection and it calls a dynamic cursor that fetches one record. They call that function that executes the dynamic cursor approximately 5000 times, it gpf's between 1,000 - 2,000 iterations in module PBSHR050.DLL @ 000D:0799



CR:164435
CR Number:   164435
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Mar 2001 Fixed
Description
Modified pbsyb0's Syb_DbShutdown() to use Sleep rather than GetTickCount to allow for Thread Processing Completion.



CR:164441
CR Number:   164441
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Fixed
Description
5.0.03 Regression. Worked until 5.0.03. Windows event timer doesn't work in 5.0.03, 5.0.04.66, 6.0 build 244 when the event calling the timer is called via a postevent() in the open event of a window.



Window Open event

Postevent("ue_timer")



Window ue_timer event

timer(1)



This works fine if you use a triggerevent instead of a postevent.



CR:164443
CR Number:   164443
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Fixed
Description
** PB 6.0 Regression **

GPF in PBVM60.DLL at 0137:0053d745 when trying to insert an OLE control and there are no registered controls on the machine.



CR:164444
CR Number:   164444
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)
5.0.04 24 Sep 1998 Not reproducible with latest version of the product available as of Resolution Date
Description
Calling the SaveAs() function saving almost all file types causes a handle leak within the operating system. Each SaveAs() call loses one handle. PSR loses 4 handles per save.



Appears fixed by bug 44892 fix.



CR:164447
CR Number:   164447
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Dec 2000 Not reproducible with latest version of the product available as of Resolution Date
Description
Problem Description: PB 6.0 build 245, All Painters appear to have significant handle leaks



Each time that you enter any of the development painters, handles are allocated but never released. Run the etsk manager and notice the amount of handles being taken up but not released.



DEVELOPMENT: could not reproduce.



CR:164449
CR Number:   164449
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Dec 1998 Not reproducible with latest version of the product available as of Resolution Date
Description
Oracle stored procedure date output parameter incorrectly converted by PowerBuilder on a declare / execute stored procedure.



CR:164452
CR Number:   164452
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 25 Sep 1998 Fixed
Description
*** 5.0.03 - REGRESSION *** SQLAnywhere database 5.5.02 - table has a column defined as type FLOAT. Datawindow column property using the 0% Format, numbers are showing up either as zero or some unrelated large number. This appears to be specific to ODBC only.



Fixes uploaded to: //ftp.powersoft.com/pub/private/pbpatch/48091_32.zip (for 32bit) or 48091_16.zip (for 16bit)



CR:164459
CR Number:   164459
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 24 Sep 1998 Fixed
Description
*** 6.0.00 Regression RC3 *** This works in 5.0.03, 5.0.04. DirList() does not find drives when used with a dropdownlistbox(). Works fine with a plain listbox. Also when using 16384 (just list drives), 6.0 RC3 Build 248 shows files only in a dropdownlistbox and files and drives in a listbox. 5.0.03 and 5.0.04 show only drives in both.



CR:164461
CR Number:   164461
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Fixed
Description
Setting focus on a visual component ocx resized it



CR:164463
CR Number:   164463
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Fixed
Description
5.0.04 regression : Numeric Edit Mask ##0.00. When you select the value in the Edit Mask (0.00) and type 1 you get 10. In 5.0.02 and 5.0.03 you got 1.



CR:164468
CR Number:   164468
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.0.04 09 Dec 1999 Fixed
Description
Oracle - O73: When using a DW based on a stored procedure, no rows are being retrieved if the retrieval argument is a datetime and the date to be retrieved is anything other than 00:00:00



CR:164469
CR Number:   164469
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 24 Apr 1998 Fixed
Description
SaveAs to Excel format from a datawindow with a text field > 255 characters truncates the output and only puts <# chars> - 255 in the output. It probably should be putting out at least 255 characters - still truncating but at least putting out the maximum it can. A warning message would be nice too "truncating data".



Developer: Cannot put out a warning message -esp with datastores. Perhaps some kind of computed field which would show "DATA TRUNCATED" or null for a visible thing.



CR:164473
CR Number:   164473
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 370 16 Nov 1998 Not reproducible with latest version of the product available as of Resolution Date
Description
Constuctor events of objects on tabpages not fireing if the tabpage is opened in script with OpenTab and the Tab Control has Create On Demand checked.



CR:164474
CR Number:   164474
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 08 Jul 1998 Fixed
Description
Regression in Help from 5.0.04.67 to 6.0, Build 250. When are in the window painter and you select properties, click on the icon tab, select browse and then help on the Select Icon window, you get help for Select Declared Cursors dialog box



CR:164476
CR Number:   164476
Product Name:   PB Enterprise
Product Component:   Browser
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 29 May 1998 Fixed
Description
6.0.00 Regression. Regenerating from object browser after using "show hierarchy" does not work. The actual menu pick for "regenerate" appears to do nothing.



CR:164479
CR Number:   164479
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 22 Oct 1998 Fixed
Description
MS SQL Server 6.5 - In the Database Administration painter, when you select menu option: Design-->Maintain Users, select a database and an error message displays: "Attempt to bind to a non-existent column".



CR:164480
CR Number:   164480
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   HP-UX 10.20
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 07 Jul 1998 Fixed
Description
Accessing the HTMLTable attribute of a DataWindow using Web PB returns only the last column of a multi-column datawindow. The GenerateHTMLForm function behaves the same way. This is HPUX and AIX specific.



CR:164493
CR Number:   164493
Product Name:   PB Enterprise
Product Component:   System Runtime Functions
Status:   Closed
OS:   MS Windows 3.1
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 21 Dec 2000 Not reproducible with latest version of the product available as of Resolution Date
Description
6.0.00 Regression. 16 bit only. Passing null any array arguments - (all null) to the retrieve() function (using datawindow or datastore) causes a GPF in PBVM60W.DLL 0001:23BB. More specifically, this affects 6.0 16 bit deployed PFC applications using the datawindow caching service - used by treeviews for example.. when a retrieve() against a datawindow using no retrieval arguments is being cached - used by treeviews for example..



(PFC_N_CST_DWCACHE, of_refresh (string as_id)).



any la_args[20]

..

// nulls in all entries

ds.retrieve(la_args[1], la_args[2]......) <-- GPFs here.



Line 123 of of_refresh(string as_id) contains this construct in the



CHOOSE CASE



statement "RETRIEVE,SQL" section. The PFC examples uses this construct populating the listview and treeview on w_examplemain - the frame window for the examples.



Workarounds: For pfc pfc_n_cst_dwcache service of_refresh (string as_id) function.



Case RETRIEVE, SQL



// Workaround: Check to see if null arguments exist in the first few arguments

// of the la_args[] array of any that is used in the retrieve(). If they are null,

// this means a 'normal' retrieve for a datawindow with NO retrieval

// arguments - exactly the example that causes the GPF IF YOU USE AN ARRAY.



// instead, catch the specific null condition.

if isnull(la_args[1]) and isnull(la_args[2]) and isnull(la_args[3]) then

// 3 entries is enough. Don't feed it the array if all nulls. This causes the GPF.

// instead do your own retrieve()

li_rows = istr_cachelist[li_cnt].ds_obj.Retrieve()

return li_rows



else

// normal processing with old PFC code. At least one any array argument is non-null.

// This doesn't GPF.

li_rows = istr_cachelist[li_cnt].ds_obj.Retrieve(la_args[1]....la_args[20])

return li_rows

end if



NOTE: This should be fixed soon, but if you need to use the workaround, as always, don't edit the PFC_ layer, add the function on the PFE_ layer where it will override the ancestor automatically.



CR:164500
CR Number:   164500
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)
24 Apr 1998 Fixed
Description
Setchanges on a datawindow using a blob from a getchanges which had a return code of 0 is causing pb to crash.



CR:164503
CR Number:   164503
Product Name:   PB Enterprise
Product Component:   Web.PB
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jul 2001 Fixed
Description
GetURL( ) function on the INet object will GPF in development when called after the application has been stopped and restarted. If the application is restarted and the PostURL() function is called prior to a GetURL(), the function works properly.



CR:164512
CR Number:   164512
Product Name:   PB Enterprise
Product Component:   Installation
Status:   Closed
OS:   MS Windows 3.1
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 15 Jul 1998 Fixed
Description
DDDK16: pbtra60w.dll is not on the deployment kit -- this was an oversight. Customers whose apps use trace will need the dll deployed. OK on 32-bit DDDK. Should be one of the optional dlls listed like RTC.



CR:164516
CR Number:   164516
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2000 Not a Bug
Description
Dot notation with HTMLTable.GenerateCSS. The statement:

ds.Object.DataWindow.HTMLTable.generatecss="yes" causes the error R1041 "Error accessing external object property generatecss



The .HTMLTable.NoWrap property will also fail.



Workaround: Use Modify() instead.



ds.Modify("datawindow.htmltable.generatecss='yes'")



dw_1.Object.datawindow.HTMLTable.NoWrap = 'yes' // This will fail

dw_1.Modify("datawindow.htmltable.NoWrap='yes'") // This will work



PER DEVELOPMENT:

the following syntax will work:

dw_1.object.datawindow.htmltable.generatecss = "~"yes~""



CR:164520
CR Number:   164520
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 17 Nov 1998 Fixed
Description
Active X built in Visual Basic doesn't work in PB. The tab, enter, escape, and delete keys don't work.



Per Development:

Fixed only in PB7.0 because it was a major change that could not be fixed in a PB 6.0 maintenance release.



CR:164525
CR Number:   164525
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)
6.0.01 28 Apr 1998 Fixed
Description
Problem with the characterlabel in DW. When changing a text e.g. dross into dro it looks ok until he tabs away. The text dro is changed back to dross.



CR:164529
CR Number:   164529
Product Name:   PB Enterprise
Product Component:   Shared Objects
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 29 Apr 1998 Fixed
Description
ShareObjectGet call to get a reference to a registered shared object hangs when issued in constructor of another shared object.



CR:164532
CR Number:   164532
Product Name:   PB Enterprise
Product Component:   DB DB2
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 19 Jan 1999 Fixed
Description
PB 6.0_251 - You cannot check the Generate Trace checkbox on the connection profile dialog for the MDI Gateway. The click is acknowledged (known, because the Apply button will become enabled) but the checkbox is never checked.



CR:164537
CR Number:   164537
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 1998 Third Party Problem
Description
User cannot access x and y arguments of the Visual Components Formula One worksheet component in the dragdrop event of the window. They are not showing up although the doc says they should be there.



Mouse events do have x,y. OCX_y , OCX_x but drag events don't reveal x,y



Development: The VCI doc refers to the VisualBasic "DragDrop" event which is different. Documentation deficiency.



CR:164538
CR Number:   164538
Product Name:   PB Enterprise
Product Component:   Installation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Nov 1998 Fixed
Description
PB 6.0.0 GA Window Plugin doesn't work with Microsoft Internet Explorer (IE) 4.0 or 3.0.

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

2/3/98 JMartin

The problem is the registry entries that are created by the PB 6.0 installer. The entries are documented in the PTrack.



The Installer program needs to be modified so that these entries are not created.

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

The error from IE 3.0 when loading a page with a pbd embedded in it states "An error occurred inside a plug-in contained on this page".



The result from accessing either the window or DW plug in from IE 4.0 is that the area/rectangle is blank (no icon) and if you right click on the document you can analyze the doc. The result of the analyze is: "The following EMBED did not install properly." It goes on to say:

This might have been caused by one of the following conditions:

1. Your current security settings prevent this EMBED from being used.

2. This EMBED was not propertly installed on your computer

3. The page or EMBED was authored incorrectly.



Environments that fail:

Window Plugin: IE 3.0, IE 4.0

DW Plugin: IE 4.0



NOTE: See bug #48588 for the status of the Datawindow Plugin fix.



PER DEVELOPMENT:

Solution:

PB Development spoke with Microsoft Tech Support - they recommended to:

**completely uninstall IE4.0 then re-install IE4.0

**There is a technote at Microsoft website about how to _completely_ remove IE4 from a client machine.



Also - make sure that the browser security options allow _any_ plugin to run.

Also - like the discovery above, make sure the PB5 plugin is not being loaded rather than the PB6 plugin.

Also - IE will look into the NETSCAPE 'plugins' directory when looking for the plugin to load...



CR:164542
CR Number:   164542
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   Solaris 2.5.1
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Fixed
Description
Using ORCA with PowerBuilder for Solaris, the PBORCA_CompileRegenerate function causes a segmentation fault when invoked from an EXE.



CR:164544
CR Number:   164544
Product Name:   PB Enterprise
Product Component:   Shared Objects
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 29 Apr 1998 Fixed
Description
SharedObjectGet hangs when called from within a shared object to obtain a reference to another shared object when no shared objects are currently registered.



CR:164548
CR Number:   164548
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 21 Sep 1998 Fixed
Description
Oracle 8.0.03, DBMS = OR8: Accessing a table that has a primary key defined on a non-unique index. This is now supported in Oracle 8. The uniqueness of the primary key is enforced in the constraint not in the index. In data manipulation, cannot insert records; Insert icon and menu choice are disabled. Creating a new datawindow, the datawindow defaults to non-updateable.



CR:164551
CR Number:   164551
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 29 May 1998 Fixed
Description
***6.0.00 Regression*** Some .CUR files used as Pointers cause a GPF when you try to save the Pointer setting, or preview/run. These worked in 5.0. Also, migrated objects that used them in 5.0 crash the system when previewed or run. Reported for datawindows, but I tried the window painter as well and also got a gpf.



CR:164554
CR Number:   164554
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 26 Mar 2001 Fixed
Description
PBSYC050 Generated syntax to invoke sp_password should put double quotes around arguments. This enables users to create passwords that begin with a number instead of a letter.



CR:164557
CR Number:   164557
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 Fixed
Description
The currency symbol for Regional Settings German(standard) does not display correctly in editmasks of [currency(xx)]. In the Control Panel > Regional Settings > Currency tab, the currency symbol is defined to be DM. In PB it shows up as MDM.



CR:164560
CR Number:   164560
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 03 May 1999 Fixed
Description
Sybase System 11 (DBMS = SYC) - When attempting to make the 26th connect (twenty six connection objects) he gets the following error: Error 6 (rc -1) : ct_connect(): user api layer: external error: The maximum number of connections have already been opened.



Also, when 2nd connect fails during SelectBlob processing, PB GPFs.



2/9/98 Update:

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

File located: ftp://ftp.powersoft.com/pub/private/pbpatch/48726_32.zip.

Contains PBSYC050.DLL from 5.0.05.



Three main enhancements added:



1) New static DBParm lets the user override the default CS_MAX_CONNECT property for the Client Library context used by PBSYC.

Usage: sqlca.dbparm="maxconnect=nn" where nn = number of connections you wish

to allow for this context.



2) New dynamic DBParm, OptSelectBlob=1, lets the user optimize SelectBlob processing

by using the current transaction object to perform the SelectBlob request. It is the user's responsibility to make sure that they are not doing any datawindow retrieval of blob or binary data while OptSelectBlob=1. This dbparm can greatly improve performance for applications that use the SelectBlob powerscript function. User can specify OptSelectBlob at connect time or at any other time while the connection is open. The

following example shows how to turn OptSelectBlob for one specific request:

sqlca.dbparm="OptSelectBlob=1"

SelectBlob blobcol into :myblob_variable from blob_table where id = :idvalue;

if sqlca.sqlcode = 0 then

...

end if

sqlca.dbparm="OptSelectBlob= 0"



3) Fixed GPF in PBSYC that occurred whenever the 2nd connection requested by Select Blob processing failed.



CR:164563
CR Number:   164563
Product Name:   PB Enterprise
Product Component:   DB SQLAnywhere
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 03 Aug 2000 Fixed
Description
***5.0.03 Regression*** Database: SQL Anywhere - passing a string from embedded SQL to a stored procedure, execute the stored procedure to update the DB. Column in database is defined as Long VarChar. Now when doing Insert or Update and string is larger than 16,000 char's this error occurs: SQLSTATE = S1001 [Microsoft] [ODBC Driver Manager] Memory allocation failure.



CR:164565
CR Number:   164565
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 Fixed
Description
5.0.04 Regression - In a datawindow, customer has a numeric column with the mask ##,##0. Customer enters 40000 then go to the right of the field and press backspace key to suppress the last 0 : it still displays 40000. Gettext() in editchanged event returns 4000.



1/9/98 RENEEN PSE Update:

Regarding the backspace behavior, per development:



"In the edit mask code we DO intend to keep the '0' if we are backspacing over it's position in the mask ... maybe not "correct" behavior but it looks like original code."



This was verified with PB 4.0.03 gold and 4.0.07 gold, PB 5.0 gold through 5.0.04_70, and 6.0 gold (build 251) and 6.0_332. As the developer points out, this may not be "correct" behavior but it's original code in the product and changing it at this point could cause problems for other customers that have built applications based on the current behavior.



>>I do not feel that we should change this behavior at this point because of the impact it may have on other customers.



Regarding the editchanged event not firing:



>>This event now appears to fire using PB 5.0.04 Build 70 and 6.0 gold as well as 6.0_332.



Regarding the editchanged event returning the wrong value:



>>I feel that this is the only behavior that should be investigated for a fix.





Per Development:

Partially fixed. The error where we might return incomplete data when the mask has a comma in it is fixed. The behavior of the delete key and what is returned to editgettext in the itemchanged event when the delete key is pressed is not changed. Too much risk of screwing up other applications.



CR:164567
CR Number:   164567
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Nov 1998 Not reproducible with latest version of the product available as of Resolution Date
Description
** 5.0.04 REGRESSION 32bit, NT platform ONLY ***

Placing Visual Components Formula 1 ocx v.4.1.0.5 on a window in NT 4 will cause intermittent hanging, Dr Watson and sometimes pb will simply crash without warning.



CR:164568
CR Number:   164568
Product Name:   PB Enterprise
Product Component:   Installation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jul 1998 Fixed
Description
PB 6.0.0 GA Datawindow Plugin doesn't work with Microsoft Internet Explorer (IE) 4.0.

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

2/3/98 JMartin

The problem is the registry entries that are created by the PB 6.0 installer. The entries are documented in the PTrack.



The Installer program needs to be modified so that these entries are not created.

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



NOTE: See bug #48389 for the status of the Window Plugin fix.



PER DEVELOPMENT:

PB Development spoke with Microsoft Tech Support - they recommended to:

**completely uninstall IE4.0 then re-install IE4.0

**There is a technote at Microsoft website about how to _completely_ remove IE4 from a client machine.



Also - make sure that the browser security options allow _any_ plugin to run.

Also - like the discovery above, make sure the PB5 plugin is not being loaded rather than the PB6 plugin.

Also - IE will look into the NETSCAPE 'plugins' directory when looking for the plugin to load...



CR:164573
CR Number:   164573
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 30 Apr 1998 Not reproducible with latest version of the product available as of Resolution Date
Description
*** 5.0.03 REGRESSION *** PowerImage w/Powerbuilder 32bit.

A bitmap opened on a window, as the window is resized, there is alot of flickering. Also if you open another window ontop of another and then close the top one, the other window loses it scrollbars. If you click in the area where they should be the scrollbars repaint.



CR:164577
CR Number:   164577
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 18 Jan 1999 Fixed
Description
***5.0.04 Regression*** MS SQL Server 6.5 - EXECUTING a Stored procedure returns correct value as long as the output value is an INTEGER. If it is a string or a getdate() being returned the following error will occur:

Error 242 "implicit conversion from datatype varchar to int is not allowed use the convert function to run this query"



Workaround: Prefix stored procedure with owner name, ie dbo.spname.



CR:164578
CR Number:   164578
Product Name:   PB Enterprise
Product Component:   Plug-ins
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 31 Jul 2001 Fixed
Description
Netscape 3.0x, Internet Explorer 3.0x and other 4.x browsers GPF when opening the printer setup dialog available while using the right mouse button and selecting Print... (the print dialog comes up), then Printer/Setup. GPFs in either IEXPLORE.exe or Netscape.exe for 3.0x browsers. GPFs in NPDWE60.DLL using Netscape 4.04 browser.



CR:164582
CR Number:   164582
Product Name:   PB Enterprise
Product Component:   Language - Compiler
Status:   Closed
OS:   MS Windows 3.1
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 08 Jul 1998 Fixed
Description
A deployed 16 bit PFC exe displays a validation error during closequery if there are pending changes in a dw. No validation errors occurred inputting the new row. There are no validation rules in the datawindow.



February 9, 1998 - StephenD (Stephen Dupre) PSE

The REAL problem: 6.0.00 Regression in 16 bit. Works fine in 5.0.04 16 bit and 32 bit and 6.0 32 bit. A 16 bit only problem with casting a numeric into an any variable which incorrectly evaluates to >1 and <= 0 - an impossible condition. Most numeric datatypes have the problem.



// here is the example.

int li_int = 1

long ll_long =1

decimal ld_decimal = 1

double ld_double = 1

real lr_real = 1



any la_rc



la_rc = <ll_int, ll_long, ld_decimal, ld_double>



if la_rc < 0 then messagebox("evaluate < 0", "true")

if la_rc >= 1 then messagebox("evaluate >=0", "true")



Any of the variables shown will return "true" in both sets of messageboxes. It should only return true for the "evaluate >=0" messagebox.



For a REAL datatype cast into an ANY variable under 16 bit, it seems NEITHER if ... then statement evaluates to "true"



Again, all numeric datatypes cast into any variables under 32 bit work (even REAL)





The very specific 16 bit PFC problem

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

PFC has a construct in the pfc_n_cst_luw (logical unit of work service)in the object function



of_updatespending (powerobject apo_control[]) returns integer



that evaluates a "1" assigned to an any variable incorrectly as a -1 in an if..then statement as a window with pending changes is being closed.



//excerpt from of_updatespending((powerobject apo_control[]) returns integer)

any la_rc

la_rc = lpo_tocheck.Dynamic of_UpdatesPending ()

If ClassName(la_rc) = 'integer' or ClassName(la_rc)='long' Then

// Functionality was found.

If la_rc < 0 Then Return -1 /*** << both evaluate to true

If la_rc >= 1 Then /*** <<

//some code

end if



The dynamic call above to of_UpdatesPending() during a window close with pending changes returns "1" into la_rc in both 16 bit and 32 bit (as seen in the debugger) but when doing the IF...THEN evaluations following evaluates BOTH



If la_rc < 0



and



if la_rc >= 1



to true - an impossible condition. Since the "if la_rc < 0 return -1" evaluates true first, the system errors out with a bogus validation error when it should produce a "Save changes y/n dialog".



IMPORTANT NOTE:

Product Support Engineering: There are other similar constructs that are fixed with this fix. Dot notation returns an any and in an IF..THEN construct would evaluate TRUE always using 6.0.00 16 bit:



if dw_1.object.datawindow.table.select = 'total_garbage' then

Messagebox("evaluate", "true")

end if



This could have far-ranging effects so far as code execution is concerned. You must be using 6.0.01 build 366 or higher to get the patch that fixes this.



CR:164588
CR Number:   164588
Product Name:   PB Enterprise
Product Component:   Migration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 09 Oct 1998 Not reproducible with latest version of the product available as of Resolution Date
Description
Problem with Full ReBuild after upgrading 5.0 PFC application to 6.0 PFC.



CR:164591
CR Number:   164591
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 22 Sep 1998 Fixed
Description
SaveAs Excel5! broken if null value exists in a column. Columns/rows beyond the first null value are garbage. Using Excel! instead works okay.



CR:164596
CR Number:   164596
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)
24 Apr 1998 Not a Bug
Description
Several editmask problems found while migrating from 4.0.07 to 5.0.03.

Using ##,###,###.0 If user enters negative number (ex, -60), edit mask only accepts the 6. The only way it works is to type in number and then backspace to put in - sign.



Using ###.00000

a) If user puts in .365, edit mask reads it as 365.

b) If user puts in 0.365, edit mask accepts it as .365.



Product Support: These both exist in 5.0.03 but not in later builds due to many changes in editmask processing.



CR:164598
CR Number:   164598
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 21 Sep 1998 Fixed
Description
Oracle 8.0.03, DBMS=OR8: DataWindow, select statements has a retrieval argument. Preview data, enter in value for retrieval argument, error displays: "Unnecessary or unimplemented conversion requested."

Retrieval of data is successful under these scenarios:

- There is any DBParm (w/out StaticBind, which it will default to 1)

- Set StaticBind = 1 explicitly even though it is considered to be the default

- Set StaticBind = 0 and DisableBind = 1

- Set DisableBind = 1



Workaround: If using default StaticBind= 1, hard code the DBPARM where the database connection information is or in your database profile. Or set a different DBPARM (if applicable).



CR:164601
CR Number:   164601
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 13 Jan 1999 Fixed
Description
ODBC setting PBTrimCharColumns='YES' affects only datawindow retrievals and not FETCHs issued on a cursor with embedded SQL (SELECT INTO embedded SQL does, however, work as desired).



CR:164603
CR Number:   164603
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 31 Oct 2002 Fixed
Description
A GPF will occur when connecting via ODBC to a database in a PowerBuilder component running in Jaguar CTS or MTS.



CR:164606
CR Number:   164606
Product Name:   PB Enterprise
Product Component:   SQL Painter
Status:   Closed
OS:   Solaris 2.5
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
In the SQL painter, the area where you choose the column name is improperly sized. To re-create:

1) Enter the script painter for any event of any object.

2) Select "Paste SQL" from the PainterBar.

3) Double-click "non-cursor / Update".

4) Click OK to select any table.

Notice, on the "Update Column Values" window, that the child window on which you select column names is too small to fit the scroll bar completely. I remember an earlier version of PB where this child window was actually movable. This seems OK, but the right half of the vertical scrollbar is cut off. I'm using a Thinkpad with SVGA/800x600/small fonts.



CR:164611
CR Number:   164611
Product Name:   PB Enterprise
Product Component:   Machine Code Deployment
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 06 Jul 1998 Fixed
Description
6.0.00 Regression. Creating and running machine code with an object compare construct in an IF...THEN statement causes a GPF in 6.0. Regular datatypes seem to work fine.



CR:164612
CR Number:   164612
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 03 Dec 2000 Fixed
Description
Descendant window control scripts being moved to the associated script on the window, if there is no ancestor script in the window. If you have inherited a window with a cb on it. in the descendant, if the ancestor cb has no script in the clicked event, the descendant script will be moved to the clicked event of the window.



This has also been reported with menus. The menu painter is unable to save script of a descendant menu if the ancestor has no script. The script moves 1 item up. If the menu shows:



File

New

Open



and you script the clicked event, it ends up in the "New" clicked script.





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