远程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:295303
CR Number:   295303
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Apr 2003 Presently Not Targeted For Any Future Release Of This Product
Description
Problem occurs when using multi table datawindow on HTML page when ever you update or add data to the table get the error message.



April 03

This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release".
Review Status
 April-29-2003.This CR was reviewed and closed as part of the Quarterly CR Review process. It is \"Not targeted for any future release\".



CR:295335
CR Number:   295335
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Open
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer would like a way to present a datawindow as a treeview, with ability to expand and contract nodes, etc.



CR:295338
CR Number:   295338
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Nov 2002 Fixed
Description
Using the dw describe returns an extra set of quotation marks

when used with a text field and includes a ?.



CR:295340
CR Number:   295340
Product Name:   PB Enterprise
Product Component:   JSP Editor
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5026 19 Nov 2002 Fixed
Description
The page parser seems to get 'confused' as simply moving a { from one line to another causes all of the HTML/Java to appear in the Preview tab, just like it does in the source tab.



CR:295354
CR Number:   295354
Product Name:   PB Enterprise
Product Component:   DB OLE DB
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 2003 Third Party Problem
Description
The OLE DB driver does not retrieve the stored procedure list until you "force" a Refresh in the database painter.



Workaround: In the database painter, right click on the Stored Procedures & Functions folder, and click Refresh. Now the stored procedures will appear. Now also if you go into the datawindow painter, you should get the list. For the Stored Procedure Update option in the datawindow painter, it is necessary to click the Procedures button, click Cancel when you see the empty list, and click the Procedures button a second time to get the list. Even with this workaround, you'll still only get a list of procedures owned by the user you are logged in as.
Review Status
 24 Sep 2003:

This is thought to be an OLEDB driver bug, not a PB bug. This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release".



CR:295367
CR Number:   295367
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Solaris 2.6
Original Version:   8.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.2 29 Jul 2003 Fixed
Description
SetFullState to a datastore in an EAServer component with the same dataobject as the client source datastore, fails on Solaris EASserver.



CR:295376
CR Number:   295376
Product Name:   PB Enterprise
Product Component:   Language - Compiler
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 18 Dec 2002 Fixed
Description
Please don't require a database connection to recompile code containing embedded SQL.



CR:295390
CR Number:   295390
Product Name:   PB Enterprise
Product Component:   DW XML
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 2003 Presently Not Targeted For Any Future Release Of This Product
Description
The Value/Text option on the Element Attributes dialog is misleading - it's not clear how you would enter hard-coded text.

The biggest problems with the dialog =:are



1.The fact that the EITHER / OR option of entering a Value or Text are not mutually exclusive (entering in one does not clear the other)

2.You would think you could enter the column name in the Text portion and have it include the column name in the XML; however, it inteprets the column name to mean the actual value, essentially interpreting it exactly as if you'd entered it in the first Value SLE
Review Status
 24 Sep 2003:

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



CR:295449
CR Number:   295449
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   NT4
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 03 Nov 2002 Fixed
Description
Memory leak seen when a datawindow is assigned values from a structure with an array of any



CR:295475
CR Number:   295475
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 28 Oct 2002 Fixed
Description
ODBC CursorLock DBParm default is now Lock in 8.0, it did not lock in 7.0. Something in PB changed as both use the same ODBC driver and dsn but a select in 7.0 does not lock rows, and a select in 8.0 does lock rows.



CR:295478
CR Number:   295478
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Nov 2002 Fixed
26 Dec 2002 Fixed
Description
Changing one column property in a datawindow using the Modify method results in one or more other column properties changing.



Note: This may be a documentation issue. Some datawindow properties interact so there may at times be "side effects" of changing one property that effect another by default.



CR:295487
CR Number:   295487
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 10247 26 Dec 2002 Fixed
Description
Blank pages in a composite report.



These blank pages may be a result of the basic datawindow premise of one row (or in this case one nested report) fitting on one page. However when the other two nested reports are removed and all the displayed columns are removed from the detail band leaving only the header, there is still an initial blank page. The offending datawindow has complex SQL behind it.



CR:295489
CR Number:   295489
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Oct 2002 Fixed
Description
Specifying SQLCache DBParm in PB using 8.1.7 Oracle client causes PB to crash on saving after an insert row.



CR:295496
CR Number:   295496
Product Name:   PB Enterprise
Product Component:   DB OLE DB
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Oct 2002 Fixed
Description
Document what happens if OLE DB provider does not support the ITableDefinition interface:



1. The PowerBuilder catalog tables cannot be used even if they already created.

2. DDL operations, like modifying columns are enabled, but bring up an empty column list.

3. Edit Data selected on a table in the database painter fails with message "table contains no columns with supported datatypes".



CR:295502
CR Number:   295502
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 May 2003 Presently Not Targeted For Any Future Release Of This Product
Description
Scrolling in the summary band not working correctly.



May 03

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



CR:295504
CR Number:   295504
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement Request: Ability when retrieving data using the syj driver to interpreted

special characters properly. The following characters interpret properly using the SYC

driver.



哙徕沅彐



Now the SYJ will interpret them as:

奕睦馓宰



Workaround currently is to:

1. Change EAServer codeset to "iso_1" and restart it.

2. Use following DBParm in the component when you retrieve data using SYJ

SQLCA.DBParm = "Release='12.5',Charset='iso_1'"





When retrieving data using the syj driver, the following special

characters are not being interpreted properly



哙徕沅彐



The output from Jaguar.log afther the data is retrieved looks like:

奕睦馓宰



The database server has the codeset to Roman8. Easerver has been changed to roman8 too.



CR:295629
CR Number:   295629
Product Name:   PB Enterprise
Product Component:   JSP Deployment
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Oct 2002 Fixed
Description
PowerBuilder crashes or disappears when building a JSP page with the following line:

<META http-equiv="Refresh" content="180">



CR:295633
CR Number:   295633
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Provide capability to supply tab order for datawindow buttons.



Given the attention now being made to comply with Section 508 requirements (for use with accessiblity software like JAWS).



CR:295641
CR Number:   295641
Product Name:   PB Enterprise
Product Component:   Browser
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The Inet object provides the ability to display a web page in the default browser, access the HTML for a specified page. Customer requested enhancement request to add SSL(Secure Sockets Layer) support to the Inet object.



CR:295674
CR Number:   295674
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 14 May 2003 Fixed
Description
When useHwnd=no, pb is crashing on executing querymode or

querysort.



PB is crashing with an unhandled exception/access violation. Error of symbol "this" not found.



Works ok in PB 9.0. Works ok when useHwnd=yes in PB 8.0.3.



CR:295677
CR Number:   295677
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 20 Nov 2002 Fixed
Description
Objects under source control occasionally have an extra blank line in the exported source that resides on the local project path. This causes SccDiff to return "out-of-sync" for some vendors.



Currently, we've always observed this extra blank line after an "end function" or "end event" line in the PB syntax.
Workaround Description
 Check in the edited object. Check it out again. Check it back in a second time.



CR:295684
CR Number:   295684
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Sep 2002 Duplicate
Description
When PB gets an ORA-28002 error from Oracle about a password in it's grace period, PB suppresses it completely. Instead, can you add an option to the PWDialog dbparm that allows the PB developer to indicate if they want it to show up only after the password has expired, or during the grace period as well.



CR:295819
CR Number:   295819
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 19 Nov 2002 Fixed
Description
PB 9.0 Beta 3: In a grid DW column, make the column invisible and the column data and the header disappear. Make it visible again, and the data re-appears but the header is blank.



CR:295850
CR Number:   295850
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   8.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
Customer is on PB 8.0.1 9056. He has a window which has 15 sle's on it. He has a user event called ue_hover and he has it mapped to pb_mousemove. He codes the event to show microhelp when the mouse hovers on the sle. He codes for all the sle's one by one and then saves the window and runs the application. PowerBuilder crashes.



WORKAROUNDS:The most efficient workaround is to create a user object SLE and declare the event in the user object, then use this instead of a "plain" SLE on the window.



Alternatively, this worked okay for the customer when he added one SLE and user event at a time, saving and closing the window in the window painter after each SLE was added. This would be time-consuming and frustrating.



04/25/2005:

This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release".
Workaround Description
 The most efficient workaround is to create a user object SLE and declare the event in the user object, then use this instead of a "plain" SLE on the window.



CR:295953
CR Number:   295953
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 2003 Presently Not Targeted For Any Future Release Of This Product
Description
Non-western text (Cyrillic, for instance) is not being rendered in the IDE script painter, properties dialog SLEs, find dialogs, etc.
Review Status
 24 Sep 2003:

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



CR:295968
CR Number:   295968
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 26 Dec 2002 Fixed
Description
A dw column with focus has a visible expression that currently evaluates to true (visible). The dw loses focus and conditions change that make the expression evaluate to false (invisible) and the column disappears. But when the dw regains focus, the column reappears partially.



CR:295970
CR Number:   295970
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Apr 2003 Not a Bug
Description
Possibly an enhancement request and not a bug. ASE Error 7514 the transaction log full error is not handle in Powerbuilder when connected with ASE native drivers. Powerbuilder will just hang. When the error occurs with a PB component deployed to EAServer the customer would like to be able to trap and handle the error. That part of the problem may turn out to be an enhancement request but PB should not hang when error is encountered.



CR:295976
CR Number:   295976
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 11 Nov 2002 Fixed
Description
Drop Informix 7 native interface.



CR:296061
CR Number:   296061
Product Name:   PB Enterprise
Product Component:   DW Expression
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Oct 2003 Presently Not Targeted For Any Future Release Of This Product
Description
The DB Bind is always disabled regardless the setting of DisableBind in DBParm if using lowercase "from" in the select statement in the DW.



Workaround:

To use upper case on the SQL statement.
Review Status
 October 03

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



CR:296082
CR Number:   296082
Product Name:   PB Enterprise
Product Component:   Menus - Runtime
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2004 EOL'd version. Not to be Fixed.
Description
Menu/Toolbar button causes different behavior depending upon the navigation path of the application. If accessed via a Popup menu the code does not execute.



The application uses two MDI Frame windows, so there may be an error related to that. The menu script uses the ParentWindow method to trigger an event. May be that the wrong window is accessed if a Popup menu is used in this case.



CR:296112
CR Number:   296112
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Oct 2002 Duplicate
Description
Add Connection Cache options to DataWindow DTC.



CR:296131
CR Number:   296131
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Add support for taborder for commandbuttons in datawindows.



CR:296132
CR Number:   296132
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Nov 2002 Fixed
Description
Add Documentation for enabled/disabled property of a commandbutton in Datawindow.



CR:296134
CR Number:   296134
Product Name:   PB Enterprise
Product Component:   Browser
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 26 Jan 2003 Fixed
Description
PB Browser does not list properties for Datawindow command buttons.



CR:296137
CR Number:   296137
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 18 Dec 2002 Fixed
9.0.1 5045 09 Nov 2004 Fixed
09 Apr 2009 Fixed
Description
PB 9.0 Beta 3: DWSyntax tool does not include new enabled property for datawindow buttons.



CR:296186
CR Number:   296186
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Open
OS:   Microsoft Windows NT
Original Version:   8.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
SetColumn() doesn't work with Netscape 6.22



CR:296217
CR Number:   296217
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Aug 2003 Presently Not Targeted For Any Future Release Of This Product
Description
DataWindow and Sliding-Up

Controls so not slide up above invisible columns and controls.



By manipulating the height of the controls above it, it is possible to make it slight.
Review Status
 [2003-08-08]

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



CR:296228
CR Number:   296228
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2003 Presently Not Targeted For Any Future Release Of This Product
Description
A datawindow where the first two columns are computed fields with conditional datawindow expressions causing problems with autosize height and slide up.



The first computed field is setup to only appear on the first page, first row:

if (GetRow() = 1, 'First Page Header', "")



The second computed field is setup to appear on the first page, second row and page 2

and after, first row:

if ( Integer(Describe("DataWindow.FirstRowOnPage")) = GetRow() , 'Page Header', "")



The problem is there is an rectangle object in the report and on the 2nd page and after,

it is being cut off.



Tried moving the detail band down but that is causing additional white space that the

customer does not want. Tried using different datawindow expressions to no avail.
Review Status
 August 03

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



CR:296241
CR Number:   296241
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 04 Dec 2002 Fixed
Description
ScrollToRow and SetColumn on Windows 98 platform causes a datawindow display problem. The area below the current column is blank.



CR:296266
CR Number:   296266
Product Name:   PB Enterprise
Product Component:   DW Synchronization
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jun 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
Trailer Footer property of 'No' lost after GetFullState/SetFullState.



CR:296310
CR Number:   296310
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Feb 2004 Not a Bug
Description
Calling a pooled PB component blocks DDE chanel in the explorer.





Per PB Engineering, this is not a bug.

1. A DDE client application sends a WM_DDE_INITIATE message to initiate a conversation with a server application responding to the specified application and topic names. Upon receiving this message, all server applications with names that match the specified application and that support the specified topic are expected to acknowledge it.



So whenever we double click on DDE client application, say Excel (keeping "Use DDE" checked), Excel sends WM_DDE_INITIATE message to all DDE server application using SendMessage() function. So client waits until a response received from server. PB, VC++ can act as a DDE server application. Upon receiving that message if PB does not process it client will hang. If you uncheck "Use DDE" no DDE message is sent to server.



2. Notepad.exe can't act as DDE client application and never sends any DDE message to DDE server.



CR:296324
CR Number:   296324
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Nov 2002 Fixed
Description
-----------------------

PSE NOTES:

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

Versions and Build #s Reported: PB 7.03

Versions and Build #s Tested: Fails in 7.03.10180 and later (OK in 10135)

Fails in 8.01.9121 and later (OK in 9100)

Fails in 9.0 Beta 3 builds (not tested earlier betas)

Database/Driver File/Version: PBO8480.DLL

Comments:



DW causes Oracle error -> "ORA-00904 Invalid column name" when ...

Default delimitidentifier setting (ie with quotes, delimitidentifier = 'yes')and a string constant is used in the SQL select statement eg ...



SELECT "EMP"."EMPNO",

"EMP"."ENAME",

'test' <---------Culprit

FROM "EMP"



This shows up in pbtrace as...



SELECT

"SCOTT"."EMP"."EMPNO" ,

"SCOTT"."EMP"."ENAME" ,

"'TEST'" <----------- The problem

FROM "SCOTT"."EMP"



Workaround is to use dbparm Delimitidentifier = 'no'



NOTE:

The following similar SQL also gives the ORA-00904 error but this also happens using SQLPlus so it is not a PB issue. This CR only deals with the situation detailed above



SELECT "EMP"."EMPNO",

"EMP"."ENAME",

"test" <---------Note the double quotes this time

FROM "EMP"
Workaround Description
 dbparm Delimitidentifier = 'no'



CR:296343
CR Number:   296343
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Open
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Add an Enabled Property for other Datawindow controls, primarily DropDown Datawindows.

DDDWs



CR:296362
CR Number:   296362
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   8.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
-----------------------

PSE NOTES:

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

Versions and Build #s Reported: PB 8.02

Versions and Build #s Tested: 7.03/8.03/9.0 Beta3



New feature request so that editmask controls with a numeric mask and DW edit masks automatically apply the decimal seperator and digit grouping when changed in Windows control panel (the datawindow column format currently does this automatically - see repro)



CR:296385
CR Number:   296385
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2003 Presently Not Targeted For Any Future Release Of This Product
Description
When using tableowner.tablename.table alias in select statement, causing incorrect dw syntax to be generated for the updatewhereclause. Using the table alias appears to be ignored when used with tableowner.



Used the following select statement:

SELECT dep.dept_name,

epl.emp_fname,

epl.emp_lname

FROM dbo.department dep

JOIN dbo.employee epl

ON dep.dept_id = epl.dept_id



When viewing the syntax using dw export, or edit source thru the system tree (in pb 8.0.3 and 9.0), the following syntax appears:

table(column=(type=char(40) updatewhereclause=yes name=department_dept_name dbname="department.dept_name" )

column=(type=char(20) updatewhereclause=yes name=employee_emp_fname dbname="department.emp_fname" )

column=(type=char(20) updatewhereclause=yes name=employee_emp_lname dbname="department.emp_lname" )



If you take out the table owner and just leave the table alias, the dw syntax looks ok:

SELECT dep.dept_name,

epl.emp_fname,

epl.emp_lname

FROM department dep

JOIN employee epl

ON dep.dept_id = epl.dept_id



The dw syntax looks ok:

table(column=(type=char(40) updatewhereclause=yes name=department_dept_name dbname="department.dept_name" )

column=(type=char(20) updatewhereclause=yes name=employee_emp_fname dbname="employee.emp_fname" )

column=(type=char(20) updatewhereclause=yes name=employee_emp_lname dbname="employee.emp_lname" )
Review Status
 August 03

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



CR:296405
CR Number:   296405
Product Name:   PB Enterprise
Product Component:   DW DDDW
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 May 2003 Not a Bug
Description
DDDW context not changing with new current row in main datawindow.



From PB Engineering: It's not a bug. That's how it works.



CR:296483
CR Number:   296483
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 May 2003 Presently Not Targeted For Any Future Release Of This Product
Description
If the datawindow provided in the start function of a pipeline object

is a datawindow control on a tabpage,

then the datawindow control disappears when there are pipeline errors.



Work-around is to set the bringtotop property of the datawindow control to true

after the call of the start function.



Also in the selectionchanged event of the tab, you need to set the bringtotop property

to true or false, dependant on which tabpage is selected.
Review Status
 [2003-05-23]

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



CR:296513
CR Number:   296513
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   8.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 May 2003 Presently Not Targeted For Any Future Release Of This Product
Description
Copy any object from pbl One to pbl Two and if you already have an object with the same name in pbl Two then Powerbuilder crashes if you have long pathname for the pbls. With shortpathname it works fine.



The pathname example :



C:\Documents and Settings\thistest\My Documents\Powerbuilder\XXX\XXX_8_0



05/08/2003:

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



CR:296561
CR Number:   296561
Product Name:   PB Enterprise
Product Component:   Installation
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Downloaded and installed PB 8.0.3 (build 9704) and

noticed that web target dlls did not installed.



When running the pb803.exe, the following is a list of what was going to install on

machine:

PowerBuilder Program Files

PowerBuilder ODBC Driver

Native Database Interfaces

Direct Connect Interface (DIR)

INFORMIX v7.x Interface (IN7)

INFORMIX v9.x Interface (IN9)

Microsoft SQL Server Interface (MSS)

Oracle7 Interface (O73)

Oracle8/8i Interface (O84) 8.x.4+

Oracle9/9i

Adaptive Server Enterprise (SYC)

Sybase ASE Interface for EAServer (SYJ)

JDBC Drivers

JDBC Interface for Microsoft VM (JDM)

JDBC Interface for Sun VM 1.1 (JDS)

JDBC Interface (JDB)

Web Plugins

Window ActiveX (Standard)

Window ActiveX (Secure)

DataWindow Web Control for ActiveX

SCC Interface

PB Resource Monitor



When selecting file/new, I do have the web tab page with the 4gl, html page, etc generation. I have the web target icons under target tab page. Web targets were installed on machine.





I also ran the regall8.bat file included with the pb9.0 beta. That didn't work. Web target dlls still did not install. Also ran the RegisterWT8 and RegisterWT9.



CR:296574
CR Number:   296574
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 15 May 2003 Fixed
Description
After migrating an app from PB 6.5 to PB 8 it crashes when run.



CR:296589
CR Number:   296589
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 9676 28 Oct 2002 Fixed
Description
In the object properties dialog, the user can type <ctrl><enter> to embed a carriage return/line feed (CRLF) into the comment multiline edit. The comment then reads as follows in the multi-line edit control:

Generated MDI Sheet
This comment has an embedded CRLF

If the user checks this object in, the exported source has a "~r~n" in the $PBExportComments$ line.
$PBExportComments$Generated MDI Sheet #3 ~r~nThis comment has an embedded CRLF.
The classic import file dialog processing successfully decrypts the ~r~n back into CRLF (0x0D0A). However, the SCC GetLatestVersion and SCC Checkout processing does not. This causes all future SccDiffs to fail and the object appears to be perpetually out-of-sync. Also, the comment property no longer displays properly in the object properties dialog.
Workaround Description
 Remove all ~r, ~n, ~t, ~~ characters from the object comments when working with objects under source control. Once you have this fix installed, the problem will no longer appear.



CR:296698
CR Number:   296698
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 10 Nov 2002 Fixed
Description
Oracle db user with expired password and an unlimited grace period, but PB won't login the user. It does login a user with an expired password but with a limited grace period. It should login both users.



CR:296730
CR Number:   296730
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 May 2003 Presently Not Targeted For Any Future Release Of This Product
Description
Customer is connected to Informix 7 from Powerbuilder 7.0.3 build 10213. She has a Char(1) column. Doing an embedded sql select of the column into a string variable returns a string of length 39. The problem does not occur for retrieving a datawindow result set.



WORKAROUND: use an ODBC connection to Informix and using the PBTrimCharColumns setting in the PBODB70.INI file.



05/08/2003:

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



CR:296798
CR Number:   296798
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 5049 13 Jan 2003 Fixed
Description
PDF generated from a DataWindow seems to be one page regardless of the amount of data.



CR:296805
CR Number:   296805
Product Name:   PB Enterprise
Product Component:   Printing
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 Beta 4 5007 05 Nov 2002 Fixed
Description
When trying to print a object using the print function, its

returning -1. No object is printed.



ll_job = PrintOpen()

ll_ret = tab_1.Print(ll_job,1,500)

ll_ret = tab_1.Print(ll_job,1,4000)

ll_ret = PrintPage(ll_job)

PrintClose(ll_job)



CR:296894
CR Number:   296894
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
do check out/in automaticly with an automatic comment

PB should provide an automatic comment configuration.

Add an enhancement for automatic comment the check in of pbg files like "New objects registered: ...." or "Objects removed: ...". If someone does not like to use this dialog to place any comments it should be able to disable. If anyone needs this

feature really you PB offer a checkbox to configure it.



CR:296916
CR Number:   296916
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 21 Oct 2003 Fixed
Description
Column (string type) with EditMask ##-###-###-##

When copy & paste (ctrl+v) some characters to this column, the data isn't being paste

right. i.e. the original characters are: 1111111111 after paste it display:

11-111-111-

this might be a dup of CR 231097 Paste (Ctrl + V ) is incorrect in EditMask.



CR:296955
CR Number:   296955
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 06 Jan 2003 Fixed
Description
There is no way to see what exceptions a proxy throws without exporting the proxy and opening in file editor



Since proxies built from EAServer (or now from other application servers) cannot be edited in the IDE, there is no way to see what exceptions individual methods throw. Those exceptions should be visible in both the system tree and within the PowerBuilder object browser; however, they aren't in either place. The only way to see them is to export the proxy and open it up in the File Viewer, which is really unacceptable.



If we cannot add this information into the system tree and the object browser, then please make proxy objects editable via Edit Source so we can examine the exceptions there. If there is reluctance to make them editable, then provide a View Source option versus Edit Source.



CR:296960
CR Number:   296960
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   AIX 4.3
Original Version:   8.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 29 Jan 2004 Fixed
Description
A case statement in a computed expression is not interpreting the column value properly when the column is not of type string.



For example, a case statement of case( id when 1 then 'R & D' when 2 then 'Sales' )

does not return the proper result. The column 'id' is of type number.



Workaround: (Convert the column value to a string)



case (string(id) when '1' then 'R & D' when '2' then 'Sales')



CR:297005
CR Number:   297005
Product Name:   PB Enterprise
Product Component:   DW XML
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Oct 2002 Fixed
Description
A computed expression for the Iterate Header for Groups

is not being evaluated properly.



The computed expression being used is:

if (1 = 1, 0, 1)

shows the same results as: if (1 = 1, 1, 0)



The department element is incorrectly repeated.



CR:297081
CR Number:   297081
Product Name:   PB Enterprise
Product Component:   DW Wizards
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   8.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer like to customize the "Update Properties" for creating Datawindows.

For instance it should be possible to have "Use Update" enabled by default instead "Use delete and then Insert" for all datawindows he creates.

In our wizard only the colors etc. can be customized by using the catalog tables.

If we don'n like to enhance the catalog table we should enhance the datawindow wizard.

There you should be able to open somthing like a "profile" for creating datawindows with all properties beginning from "General Properties", "Pointer", Fonts up to customize the update properties, retrieve options etc. and the "HTML Table", "HTML Generation", "JavaScript Generation" and the new XML specification etc.



CR:297082
CR Number:   297082
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   8.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
OS:Win32

Versions and Build #s Reported:PB 7.03

Versions and Build #s Tested: Reproduced in PB 6, 7, 8 & 9

Desired behaviour in PB 5.0



Comments:

The doubleclicked event does not fire in windows and window controls such as listboxes, mles, richtexts etc if the mouse moves slightly between clicks. The same is true with other Windows applications such as Explorer (both IE and Windows explorers), Lotus Notes, Netscape etc etc.



In PB versions 6 -> 9 the Datawindow doubleclicked event IS fired if you move the mouse between clicks.



In PB 5 the datawindow had the same behaviour as other controls & apps.



Customer has requested the behaviour be changed back to how it was in PB 5.



CR:297263
CR Number:   297263
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Dec 2002 Fixed
Description
Running the same application in PB 8.0.3 and PB 9.0

shows a difference in behavior with a datetime column with a editmask of [date].



In PB 8.0.3, it shows the date as mm/dd/yy. In PB 9.0, it will show the same column

as mm/dd/yyyy.



Using the regmon utility with PB 8.0.3 and PB 9.0, it shows the last entries for

HKCU\Control Panel\International\sShortDate. The 9.0 log shows the last entries

read for HKCU\Control Panel\International\sDate.



The difference in behavior may be in the fmtcmpld.c module (getwindowsdate or shformatCmplDateTimeMask funnctions).



CR:297284
CR Number:   297284
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Apr 2006 Presently Not Targeted For Any Future Release Of This Product
Description
HTML Datawindow DeleteRow Problem.



I have a HTML page with a DW and a button. In the button's onclick event I wrote:



dw_1.DeleteRow(0) // wanting to delete currentrow



the first time I clicked this row, I get 2 rows deleted, the second time 4, the third one 8 and so on.



I then tried to use an embedded button with the delete action. This works fine the generated code was following:



dw_1.buttonPress('DeleteRow',0,'cb_delete')



So, I copied this script to my button (thinking it will trigger the cb_delete that works fine) and I get the same wrong result.

Then I erased the 0 so my code changed to dw_1.DeleteRow() and again the same strange behavior. The same also ocurres when my code is dw_1.performAction("DeleteRow").
Workaround Description
 Use and embedded Delete button



CR:297402
CR Number:   297402
Product Name:   PB Enterprise
Product Component:   Inheritance
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement request to allow you to specify an ancestor for a particular menu item.



When you define a menu in the painter, each menu item is inherited from the base class menu, but there is no way to specify default code for this class. For instance, suppose that for EVERY menu item you want to run some sort of query against a database to determine security privileges for actions that item would initiate. To do so, you would have to add code to every menuitem in the painter. If the base menu item class were 'codeable' you would be able to code it in one place and it would be available to all menu items as they would inherit from this base ancestor.



CR:297414
CR Number:   297414
Product Name:   PB Enterprise
Product Component:   Menu Painter
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Provide GUI widget like OUTLOOK BAR in MS Outlook.



OUTLOOK bar is essentially a toolbar/menu control (like the icon bar in Lotus Notes on the left), so this is essentially a request for updated widgets. Customer also wants to be able to add items dynamically to that control.



CR:297424
CR Number:   297424
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 11 Nov 2002 Fixed
Description
Date EditMask 'MM/DD/YYYY' behaves poorly entering '00000000'



CR:297434
CR Number:   297434
Product Name:   PB Enterprise
Product Component:   WT - 4gl
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 May 2003 Presently Not Targeted For Any Future Release Of This Product
Description
A webpage deployed from PowerBuilder into IIS 5.0 ASP does not function as it functions when deployed to PowerDynamo. Page A calls Page B when one clicks on a command button on page A. Script is using the redirect(). In Dynamo, the page either navigates or throws error if required. But with ASP, and one clicks on the command button, nothing appears to be happening. No errors are reported either.



When searching through old Powersite 1.5 CR(165437) stating that psDocument.Redirect was not supported with ASP and that it was (is) an issue with ASP that we could not work around. It also states that it is documented but I cannot find this documented in either the old Powersite 7.0 manuals or the Web Targets 8.0 manual.



Is this still a limitation with ASP? Is this a Web Targets bug?
Review Status
 [May 07, 2003]

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



CR:297576
CR Number:   297576
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jan 2003 Fixed
Description
When a datawindow has a sort or filter criteria and a rowscopy or rowsmove is used to populate the datawindow, the sort or filter is not invoked automatically.

Can this be documentated under the rowscopy and rowsmove. It is already documented

under the sort or filter.



In the datawindow reference manual, it is documented for the sort

(dw_1.object.datawindow.table.sort): "The Table.Sort property sorts the data before it is retrieved. To sort data already in the datawindow buffers, the setsort and sort functions."



The filter is documented: "To filter data already in the Datawindow buffers, use the filter property or the setfilter and filter functions".



CR:297641
CR Number:   297641
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 20 Oct 2003 Fixed
Description
PB crashes when trying to add nested report object, if total number of DW > 256
Workaround Description
 (1) Downgrade to PowerBuilder Enterprise - 7.0.3 build 10180 which does not hit this problem.
(2) Use existing nested datawindows as a template and then change the inner nested report object for new reports, instead of adding a new report object.



CR:297707
CR Number:   297707
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 May 2003 Presently Not Targeted For Any Future Release Of This Product
Description
A saved ResultSet is corrupt when returned from EAServer. The PB component has been configured as shared and stateful on EAServer.
Review Status
 [May 07, 2003]

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



CR:297709
CR Number:   297709
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   AIX 4.3
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 25 Feb 2004 Fixed
Description
A jsp page calling a powerbuilder component and returning

a htmldw back to the browser, results in extra javascript code generated.



When reviewing the html source generated from AIX and windows, the following

extra line appears (in the <INPUT TYPE section for each column) from the PBVM generated:



<SCRIPT LANGUAGE="JavaScript">document.obj_dataForm.emp_fname_0.focus();</SCRIPT>



These extra lines of javascript don't appear when running the same pb component on nt.



CR:297780
CR Number:   297780
Product Name:   PB Enterprise
Product Component:   Function Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 11 Sep 2003 Fixed
Description
GPF when saving a function with many arguments.

A normal function or object function with more arguments than 24 will GPF upon a save. No matter if the function is created from scratch or imported etc.
Workaround Description
 When possible using an array for a argument type simulating many arguments.



CR:297783
CR Number:   297783
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Mar 2004 Fixed
Description
Automatic garbagecollect failed with sybheap.



If declaring local datastores in a sheet the memory used by the datastore / sheet is not freed if closing the sheet. Only way to force to free the memory is doing an explicit destroy or garbagecollect() call.
Workaround Description
 doing an explicit destroy or garbagecollect() call



CR:297816
CR Number:   297816
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Dec 2002 Not a Bug
Description
Regression - Intercomponentcall: A component calling a function in another component , with a datawindowchild argument , by reference, gets a return of -1 on an InsertRow(0) to the datawindowchild.



Closure description:

Originally datawindowchild is a structure with a field which will store the window handle of child datawindow in parent datawindow or datastore. Through this window handle, we can get our child datawindow object's data structure pointer and can operate on it to implement the functionality of datawindowchild.

Window handle can not be transfered between two machine, as window handle in one machine is not meaningful in another machine.In n-tier application, user should not use process, machine or OS specific value ( such as pointer, window handle ) as input parameter of function since they are meaningless in other process, machine or OS. This is one basic idea of n-tier application.

Now since we are trying to implement no hwnd datastore, we are trying to use runtime variable (instead of field )to hold child datawindow object's data structure pointer instead of using window handle field to get it. This is the reason why child datawindow operations used to work (in back door method) earlier but does not work now.



Workaround:

Use a standard component and use the create statement to instantiate the component instaed of CreateInstance.



CR:297834
CR Number:   297834
Product Name:   PB Enterprise
Product Component:   P-Code Exe Creation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 06 Nov 2002 Fixed
Description
When powertip text is used on a picture control or picture

button control, and you create a pcode or machine code executable, the following

error will result:

---------- Deploy: Deploy of p_test

Creating executable file . . .

Inspecting Application Dependencies. . .

Building type D:\Pse-80\20300494\testpowertip.pbl(testpowertip.sra) . . .

Building type D:\Pse-80\20300494\testpowertip.pbl(testpowertip.sra) . . .

Building type D:\Pse-80\20300494\testpowertip.pbl(testpowertip.sra) . . .

Inspecting Application Dependencies. . .

Building type D:\Pse-80\20300494\testpowertip.pbl(testpowertip.sra) . . .

Regenerating D:\Pse-80\20300494\testpowertip.pbl(testpowertip.sra) . . .

Inspecting application libraries . . .

Unresolved resource 'HelloWorld' referenced from object 'w_test.win'

Error writing object information

---------- Finished Deploy of p_test
Workaround Description
 Deploy with pbd's or dll's. Use a dynamic library and

exe will be built.



CR:297839
CR Number:   297839
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 May 2003 Fixed
Description
The GetText() function fails to return a value for the current row/column when executed against a windowless datastore (PB 8.0.3 +)



CR:297842
CR Number:   297842
Product Name:   PB Enterprise
Product Component:   DW Printing
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 2002 Not a Bug
Description
Add additional parameter to datawindow/datastore print routines to print to file. This would enable PB users to generate PDF files from datawindows and datastores.



CR:297865
CR Number:   297865
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 9933 09 May 2003 Not reproducible with latest version of the product available as of Resolution Date
Description
When connected to PVCS and selecting "Get Latest Version"

on multiple objects in the workspace, the error of: Internal Error: Import filename

could not be found. Problem happens when you have "Delete PowerBuilder Generated Object

Files" checked.



When the PVCS project is created in the same folder/directory structure as the workspace

and pbl, problem is not happenning. When creating the project in the PVCS Version

Manager and select the default location for the project, problem appears to be happening.



CR:297876
CR Number:   297876
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 Beta 4 19 Nov 2002 Fixed
Description
When trying to connect to PVCS version 6.8.1 or

browsing to select the project from the source control tab on the workspace property,

the following error appears:



Load Error D:\Program Files\PVCS\vm\devint\bin\ifc_scc.dll

Failed to load D:\Program Files\PVCS\vm\devint\bin\ifc_scc.dll



In the workspace the following errors appear:

Unable to Load SCC Provider DLL: D:\Program Files\PVCS\vm\devint\bin\PVCS_IFC.DLL

Unable to Load SCC Provider DLL: D:\Program Files\PVCS\vm\devint\bin\PVCS_IFC.DLL



CR:297879
CR Number:   297879
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 15 May 2003 Fixed
Description
When adding objects to source control using PVCS 6.8.1,

the following error appears in the workspace:



PVCS Source Control Info: Added: d:\pse-80\10875633\testc\genapp.pbg

PVCS Source Control Info: An error occurred while checking in your files. Any associated operations have been canceled.

Access to SCC Provider Failed during SccAdd(). Try again.

Operation Completed



CR:297910
CR Number:   297910
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2004 EOL'd version. Not to be Fixed.
Description
The length of the blob extracted from ole_1.ObjectData after calling the Clear() function of the Ole Control is 1536. In PowerBuilder 6.5 the length was zero.



CR:297926
CR Number:   297926
Product Name:   PB Enterprise
Product Component:   System Runtime Functions
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer would like to see enhanced exception handling capabilities for SQL Errors in Embedded SQL, eg. an Exception type of SQLException.



Currently the Exception has to be set manually eg.



/*********************************************************

script: f_select

parameters: emp_id_var

emp_name_var by reference

salary_var "

return value: 1 success

-1 error

**********************************************************/

int li_rc

ex_transaction lex_transaction



li_rc = 1

//select for testing, having a wrong column name..

SELECT emp_fname, saalary INTO :emp_name_var, :salary_var FROM employee WHERE emp_id = :emp_id_var using this;



if this.sqlCode <> 0 then

lex_transaction = create ex_transaction

lex_transaction.setMessage(this.sqlErrText + "~r object: " + this.classname() + "~r function: f_select")

li_rc = -1

throw lex_transaction

end if



return li_rc



This means that eg. the line number will have to be set by the programmer and cannot be set automatically in code.



CR:298039
CR Number:   298039
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Nov 2002 Fixed
Description
Changing tabsequence on first column to 0 causes current row to change



CR:298045
CR Number:   298045
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 May 2003 Presently Not Targeted For Any Future Release Of This Product
Description
VscrollBar on a Datawindow does not scroll properly when LMClick on the light Gray "Track" of the ScrollBar. Would Expect the Datawindow to scroll down, However nothing happens.
Review Status
 [May 07, 2003]

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



CR:298232
CR Number:   298232
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Database: ODBC connection to ASA

PowerBuilder version 6.5 to 8



When in the local external function declaration of a remote procedure call (rpc)

the return type is declared of type decimal, then a crash occurs on calling the function.



Work-around is to change to return type in the declaration to type string or

use an output parameter instead of a decimal return type.



CR:298235
CR Number:   298235
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   AIX 4.3
Original Version:   8.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.2 03 Dec 2003 Fixed
Description
A getfullstate not copying a datawindow with a dddw properly.



When the blob is returned to the client it shows a blob length of 6020. The blob on the server, before its sent to the client, shows a blob length of 12608.



CR:298236
CR Number:   298236
Product Name:   PB Enterprise
Product Component:   Function Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Nov 2002 Fixed
Description
PowerBuilder crashes when adding slightly over 20 arguments to a function. Happens with both global and window functions.
Workaround Description
 Step-By-Step Instructions:

1. Create a new global function and add 20 arguments. Save the function (it should save fine), now successively add one argument and save. You should see the crash around 21 or 22 arguments.



For me the save time increas



CR:298333
CR Number:   298333
Product Name:   PB Enterprise
Product Component:   Printing
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Feb 2003 Not a Bug
Description
Will PrintSend function still exist in PowerBuilder 9 ? In versions 7 and 8 it is listed as obsolete.



CR:298336
CR Number:   298336
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 5038 06 Dec 2002 Fixed
Description
SaveAs PDF! for Grid datawindow causes bad display in pdf file toward the bottom of the pdf file.



CR:298382
CR Number:   298382
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 25 Apr 2003 Fixed
25 Feb 2004 Fixed
Description
When autosize height is unchecked on the detail band for

a nested report, the page() function does not return the proper value.



When autosize height is checked than the page() function in the summary band works ok.



CR:298386
CR Number:   298386
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Versions and Build #s Reported: 8.02

Versions and Build #s Tested: Beta 3 PB 9.0, 8.03 & 7.03



Comments: If the x property of a checkbox editstyle is changed dynamically via an expression for that property then at runtime the user has to click twice to select/deselect the checkbox if doing so on a different row. It seems the click is 'getting lost' in the rowfocuschanged event and not being passed to the checkbox.

This only happens with the x property and not with other properties such as y, height, width etc.



CR:298417
CR Number:   298417
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   AIX 4.3
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 25 Feb 2004 Fixed
Description
When either updating or deleting data from a datawindow

and applying changes on the server, a pb component will immediately deactivate

once it processes the setchanges().



Data is retrieved to a datawindow from a pb component running on EAServer. A getfullstate/setfullstate is issued to retrieve the data. Once data is updated or

deleted, a getchanges/setchanges is issued. The first time it works ok, the

second time you issue a getchanges/setchanges, the pb component will immediately deactivate once it hits the setchanges in the n_sedcsm/table_update function in test2.pbl.



Works ok on nt in PB 7.0.3 (build 10225), fails for UNIX.



CR:298504
CR Number:   298504
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 21 Nov 2002 Fixed
Description
When connected to Informix using a native driver,

using Convert to Graphics crashes in the datawindow painter.



CR:298510
CR Number:   298510
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 5041 16 Dec 2002 Fixed
Description
When trying to save a dw using SaveAs(filename, PDF!) and the dw contains a picture that is external, the saveas fails with -1, but a file get written, that cannot be opened using Adobes Acrobat Reader.



CR:298513
CR Number:   298513
Product Name:   PB Enterprise
Product Component:   DW XML
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 24 Jan 2003 Fixed
Description
Enhancement request to provide a non-XSL:FO approach to PDF generation. The XSL:FO approach to PDF generation requires the Java Runtime on machines that want to use that facility and that's too 'heavy' for a lot of client/server customers.



CR:298523
CR Number:   298523
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When a System Error occurs, the object and event (function) and line number are listed. If the function is overloaded, there is no clear way to determine which version of the function errored.



CR:298525
CR Number:   298525
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 23 Jan 2003 Fixed
Description
Passing null values to a RPC stored procedure using

odbc shows different results from PB 7 and PB 8.



The following is from the sql.log:



A db2 stored procedure is showing a different sqlulen between pb7 and pb8 when passing nulls.



PB70 233-16e EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)

HSTMT 037A1F08

UWORD 1

SWORD 1 <SQL_PARAM_INPUT>

SWORD 1 <SQL_C_CHAR>

SWORD 1 <SQL_CHAR>

SQLULEN 1

SWORD 0

PTR 0x01A20328

SQLLEN 1

SQLLEN * 0x039D28F4 (-1)





In PB 8.0.3, running the same stored procedure, shows the sqlulen value of 4294967295

PB80 161-1e2 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)

HSTMT 02501848

UWORD 1

SWORD 1 <SQL_PARAM_INPUT>

SWORD 1 <SQL_C_CHAR>

SWORD 1 <SQL_CHAR>

SQLULEN 4294967295

SWORD 0

PTR 0x01F16D50

SQLLEN 0

SQLLEN * 0x01EEBB44 (-1)







The subcase that was submitted used a cobol stored procedure running on 0s390. The error

message received was: odbc [ibm][cli driver][db2] to fail



Customer has tried using RPCReBind and different combinations of disablebind. Same problem.



CR:298549
CR Number:   298549
Product Name:   PB Enterprise
Product Component:   JSP 4GL
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5020 13 Nov 2002 Fixed
Description
When Design->Options->Source View->Format Source is checked, the editor rewrites JSP code incorrectly



CR:298553
CR Number:   298553
Product Name:   PB Enterprise
Product Component:   JSP 4GL
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Nov 2002 Fixed
Description
JSP code is incorrectly rewritten during the build process.





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