远程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:490836
CR Number:   490836
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Mar 2008 Fixed
Description
The customer is creating a crosstab datawindow dynamically with dw.Create using the SyntaxFromSQL. It creates the crosstab successfully. But if he repeats the exact same code to create the same datawindow again, PB 11.1 crashes. In PB 10.5 there is no crash second, third, or more times around.



3/10/2008: This issue is fixed. The fix is available in PB 11.1 build 8218 and later.



CR:490858
CR Number:   490858
Product Name:   PB Enterprise
Product Component:   DB Painter
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Apr 2008 Fixed
Description
Error during 'New Table' create using Specific Kanji columns name.
Target Version
 11.1
Workaround Description
 W/A : Using other database utility.



CR:490859
CR Number:   490859
Product Name:   PB Enterprise
Product Component:   DB Painter
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Apr 2008 Fixed
Description
Error during 'Table Name' uses specific Kanji table name.
Workaround Description
 W/A : Using other database utility.



CR:490884
CR Number:   490884
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.5 17 Mar 2008 Fixed
Description
When trying to create a datawindow from a stored

procedure as the datasource, the following error will occur if the input arguments

are on different lines or have tabs within them:



DataWindow Wizard

Cannot create DataWindow.

'SQL Error -201: A syntax error has occurred

1 execute tsmaint.accm_test3;0 =:a, =: , =: , =: '



CR:490901
CR Number:   490901
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Open
OS:   Windows XP
Original Version:   11.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Excel 2003 (excel 8) had a row limit of 65536 and

a column limit of 256.



Excel 2007 and higher has a greater row limit and column limit as per:

http://office.microsoft.com/en-us/excel/HP100738491033.aspx?pid=CH101030621033



Currently in the dwrxls.cpp, it is set to 65535:

// check the row-count against Excel's worksheet limit

if (rowCount > 65535)

return rc;



CR:490907
CR Number:   490907
Product Name:   PB Enterprise
Product Component:   PB.NET WS Deployment
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Apr 2008 Fixed
Description
Assemblies created with PB 11 get a wrong LibraryList when called from a VisualStudio WebService. Calling the assembly from a normal VisualStudio WinForm application works fine.
Workaround Description
 - Suggested workaround to customer:

1. Copy the PBD to where the web service is expecting it

2. Change the LibraryList dynamically.



CR:490911
CR Number:   490911
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11.1 11 Mar 2008 Fixed
Description
The header name for column aliases that inlcude periods are a problem with SNC. Works fine with ODBC and also in SQLServer Query Analyzer. For example the following SQL:



SELECT department.dept_id "Department.ID",

department.dept_name "Department.Name",

department.dept_head_id "Department.Head.ID"

FROM department



produces column headers of "ID" instead of "Department.ID", "Name" instead of "Department.Name" and "ID" again instead of "Department.Head.ID". Only the data after the last period survives. If the period is the last character you get nothing for a header name.



This used to work fine in older PB ersions using MSS. It works fine in PB 11 using ODBC, and also works in SQLServer Query Analyzer. OLE DB however behaves the same as SNC.



The customer also complains of a similar problem with hyphens. In this case the hyphen is replaced by a space. And ODBC behaves the same in this case.



CR:490924
CR Number:   490924
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Open
OS:   Windows XP
Original Version:   11.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When compiling a webform that has the following line of

code: message.To.Add(toAddress), results in the following error:





c:\pse\pse-11\11420389\smtpweb.pbl(w_test).cb_1.clicked.14 C0327: The best overloaded method match for 'system.net.mail.mailaddresscollection.add(string)' has some invalid arguments.
Workaround Description
 Use the following instead:

message = create @System.Net.Mail.MailMessage(fromAddress, toAddress)



CR:490931
CR Number:   490931
Product Name:   PB Enterprise
Product Component:   Machine Code Deployment
Status:   Open
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer would like us to add a digital signature to our PB EXEs.



When we run all our PowerBuilder Applications, the following security Warning message pops up:



"The publisher could not be verified. Are you sure you want to run this software?"

"This File does not have a valid digital signature that verifies its publisher. You should only run software from publishers you trust."



This warning message pops up after installing IE7 (Internet Explorer 7). With IE6 was not any warning message. Although there is inherently nothing wrong with this warning message. Clicking on "Run" will allow you to continue, but we have hundreds of users and this new message will confuse them. Could you please add a 'valid digital signature' on PowerBuilder executables to get rid of this annoying message with IE7?



CR:490992
CR Number:   490992
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Mar 2008 Fixed
Description
The Key Event KeyDecimal is not triggered in a DataWindow when using the comma key on the numeric key pad. German regional settings.
Workaround Description
 use Editchanged event with KeyDown(keydecimal!).



CR:490995
CR Number:   490995
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Apr 2008 Fixed
Description
Dataobject property not set for a datastore by SetFullState function



CR:491073
CR Number:   491073
Product Name:   PB Enterprise
Product Component:   DB Painter
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11.1 11 Mar 2008 Fixed
Description
When the attribute of DB Painter is changed, PB11.1 crashes.



CR:491093
CR Number:   491093
Product Name:   PB Enterprise
Product Component:   PB.NET WinForm
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Apr 2008 Fixed
Description
When using a Declare and Execute statement and the

parameter is populated after the declare statement, the parameter is not passed to the

execute statement.



For example, the following script:

DECLARE myproc PROCEDURE FOR bug_test1

@ls_string = :ls_val

USINg SQLCA;

ls_val ="aaaa"

Execute myproc ;



Will return the following in the dbtrace log:

execute bug_test1 @ls_string = '' (DBI_RUNTIME_EXECUTE)



But if you execute:

ls_val ="aaaa"

DECLARE myproc PROCEDURE FOR bug_test1

@ls_string = :ls_val

USINg SQLCA;

Execute myproc ;



The following will result in the db trace log:

execute bug_test1 @ls_string = 'aaaa' (DBI_RUNTIME_EXECUTE)



CR:491094
CR Number:   491094
Product Name:   PB Enterprise
Product Component:   PB.NET WinForm
Status:   Open
OS:   Windows XP
Original Version:   11.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Winform response window usng "close with return" is leaking memory.



Winform application is using Openwithparm and Closewithreturn. When using a structure this is causes a memory leak in the winform environment.



The memory leak (Private Bytes) can be seen using performance monitor when running the winform test applcation.



CR:491172
CR Number:   491172
Product Name:   PB Enterprise
Product Component:   DataBase
Status:   Closed
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.5.1 07 Apr 2008 Fixed
24 Mar 2008 Not a Bug
Description
Calling a database function from PB as an RPC call is returning a value of 0 for a long return value that is set to null in the database function. Happens in ASA (ODBC) and MS SQL Server (OLE DB).



CR:491184
CR Number:   491184
Product Name:   PB Enterprise
Product Component:   MTS Integration
Status:   Closed
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jul 2008 Fixed
16 Nov 2009 Fixed
Description
OS: Windows XP SP2

Versions and Build #s Tested: PB 10.5.2_7562 and 10.5.2_7599

Database/Driver File/Version: ODBC, using MS SQL Server 2000



Comments: In runtime, when executing multiple instances of a PB application that invokes a PB COM+ component, the performance slows down and sometimes applications never finish.

Issue does not happen when only one instance is executed, instead. Customer tried increasing COM+ pool and recycling inside Component Services, but this affected applications when working with 2 or 3 users at same time and this could not be used as workaround.



CR:491189
CR Number:   491189
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   11.0 RC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.5.1 11 Apr 2008 Fixed
Description
DW filter is removing rows when those rows should have

been displayed in the dw control.



Works ok in PB 10.2.1 (build 9891). Works ok in PB 10.5 up to build 5033.

Problem started happenning in PB 10.5 (build 5034). May be a regression of cr426357.
Workaround Description
 Reset the buffers:

dw_2.setfilter(" ")

dw_2.filter()



CR:491199
CR Number:   491199
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Nov 2008 Insufficient info provided
Description
EAServer hangs when calling PB components

under stress test.



Problem possibly could be at:

oci!OCIDescriptorAlloc+0x33

pbo90105!CPBOCI::OCIDescriptorAlloc(void * parenth = <Memory access error>, void ** descpp = <Memory access error>, unsigned int type = <Memory access error>, unsigned int xtramem_sz = <Memory access error>, void ** usrmempp = <Memory access error>)+0x1c

pbo90105!Ora_DoSelectBind(struct DBI_Command * lpCommandPtr = <Memory access error>)+0x396

pbo90105!PB_DB_Rout(struct DBI_Command * lpCommandPtr = 0x3f46a3d0)+0xc96

PBSHR105!DBI_Execute(struct DBI_Command * pCommandBlock = 0x00000000, int bBind = 1154120232, unsigned short * lpszCommandBuffer = 0x3d769438)+0x2c

PBDWE105!dwGetExceedPageMessage+0xebf

PBDWE105!CreateXHTMLTemplate+0xded7



and

oci!OCIStmtPrepare+0x36

pbo90105!CPBOCI::OCIStmtPrepare(struct OCIStmt * stmtp = <Memory access error>, struct OCIError * errhp = <Memory access error>, unsigned char * stmt = <Memory access error>, unsigned int stmt_len = <Memory access error>, unsigned int language = <Memory access error>, unsigned int mode = <Memory access error>)+0x21

pbo90105!Ora_DoCompile(struct DBI_Command * lpCommandPtr = <Memory access error>, int bUseSQLCache = <Memory access error>)+0x5e0

pbo90105!PB_DB_Rout(struct DBI_Command * lpCommandPtr = <Memory access error>)+0x107e

PBSHR105!SQLST_RemoveComments(unsigned short * lpStrSQL = 0x000004e4, unsigned short * lpStrOut = 0x000004e4, unsigned long nBufLen = 0)+0x36

PBDWE105!CreateXHTMLTemplate+0xded7

PBDWE105!dwGetExceedPageMessage+0x18ee



RESOLUTION: No contact from customer



CR:491266
CR Number:   491266
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Closed
OS:   Windows XP
Original Version:   10.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Apr 2008 Fixed
Description
Customer receives the following error when trying to call web service method with complex datatype



Error: The definition of the method signature in Web Service proxy is wrong.



CR:491493
CR Number:   491493
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Open
OS:   Windows XP
Original Version:   11.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Wants a new argument to close UpLoadfiles function after first upload.
Workaround Description
 In pbuploadfile.aspx, remove the button 'Close' by deleting the HTML line :

<pb:WebInternalButton text="Close" onclientclick="javascript:closeIt(this.form);return false;" runat="server" />

and for the 'Upload' button change its OnClick javascript as this :

onclientclick= "checkFile(this.form);closeIt(this.form)"



CR:491495
CR Number:   491495
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.5.1 17 Mar 2008 Fixed
Description
The DataWindow Painter can crash after changing the select statement and returning

to design if the XHTML view is open or there is an XHTML template.

Database interface used is Informix In9.



CR:491513
CR Number:   491513
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Nov 2008 Fixed
Description
The customer has a dw column with "empty string is null" checked. They are trying to have the initial value of the column be an empty string. How do they do this? They have code like this in the dw constructor:



this.object.colname.initial = "empty"



The string "empty" appears to be special and have a special meaning in this context. It does not display as the initial value. The initial value in the case appears to be blank or a real empty string. But the column is not null even when "empty string is null" is checked. So it is not acting as an empty string should even though it looks empty. (Personally I think allowing the string "empty" to set the initial value as an empty string is the silliest convention one could come up with. I see no documentation on this. So the question to Engineering then, is this supposed to work? If so then make it act like an empty string and be null if "empty string is null" is checked. If not get rid of it. A string is a string even if it is "empty".



The way it should work is to set the initial value to a real empty string like:



this.object.colname.initial = ""



But this behaves the same way. It seems like an empty string, but it is not null even when "empty string is null" is checked. Please fix this.



CR:491530
CR Number:   491530
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Apr 2008 Not a Bug
Description
When connected to MSSQL2005 using SNC and the dbparm of

BindSPInput=1 is set, PB fails when returning an output variable of type real.



It works ok when the app returns an output variable of type decimal. App also

works ok for real and decimal using MSS2000 and SNC and bindSPInput=1.



App is using the DynamicDescriptionArea and the DynamicStagingArea.



CR:491614
CR Number:   491614
Product Name:   PocketBuilder
Product Component:   DB ODBC
Status:   Open
OS:   Windows Mobile 5
Original Version:   2.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
PKODB25.INI is missing from the CAB files used to deploy the PocketBuilder runtimes.



CR:491631
CR Number:   491631
Product Name:   PocketBuilder
Product Component:   PB GUI
Status:   Open
OS:   Windows XP
Original Version:   2.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Found during FDCC Testing - XP only (Vista was correct)

There are a set of _mandatory_ "HKEY_CURRENT_USER" used by PocketBuilder. When the product is installed by running setup.exe and selecting "Run As Administrator" - some of the current-user specific registry keys are placed into the administrator's account rather than the true user's account.

The fix is for the IDE, not the installer.

There is no need to re-install the product to get the benefit of this change.



After this fix, PocketBuilder 2.5 passes the U.S. FDCC compliance tests for both Windows XP and Vista (as of this date).



CR:491898
CR Number:   491898
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Mar 2008 Presently Not Targeted For Any Future Release Of This Product
Description
OS: Windows XP SP2

Versions and Build #s Tested: PB 11.1_8123

Database/Driver File/Version: N/A



Comments: Running Sun ActiveX Bridge as nvo oleobject within PowerBuilder works ok for the methods, but never triggers the mapped events. From outside PB, if you use Visual Studio ActiveX Control Test Container and test the ActiveX, it will say that PropertyChange event was triggered.



CR:491994
CR Number:   491994
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Apr 2008 Fixed
Description
If a DataWindow in PB11 with one numeric retrieval argument, that compares with a database column of type INTERGER and error is given by the IBM iseries ODBC driver:

[IBM][iSeries Access ODBC-Treiber]Fehler bei Zuordnung.



CR:492007
CR Number:   492007
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jun 2008 Fixed
Description
datetime retrieval argument in DW cause ODBC error SQL0418 on DB2/400

Workaround: change DisableBind



CR:492034
CR Number:   492034
Product Name:   PB Enterprise
Product Component:   DW Printing
Status:   Closed
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Mar 2008 Fixed
Description
Customer's datawindow report get problem after apply PB10.5.2

build 7611+2. With a specific length of data and column with AutoSize Height,

an extra empty line occur on datawindow print preview mode.

Besides, on the datawindow printout, data wrap up to cover the empty line.

Thus printout and printprview are not match.



CR:492049
CR Number:   492049
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Open
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
OS: Windows XP SP2

Versions and Build #s Tested: PB 11.1_8204

Database/Driver File/Version: N/A



Comments: When distributing web form application msi onto other machines with IIS and .NET Framework, we need to manually enable ASPNET user with Full Control on base treeview dw directory so that content of treeview gets displayed.



Customer would like a way to automate this process when running msi installer instead, in case he needs to install many web form distributions for different web form projects and/or machines.



CR:492062
CR Number:   492062
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   10.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Mar 2008 Not a Bug
Description
Sum within an Evaluate expression not returning correct result when sum is 0. Returned value is 1.387778780781446E-16 and not 0.



Seems to work for all non zero sums correctly.



CR:492531
CR Number:   492531
Product Name:   PB Enterprise
Product Component:   DB JDBC
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.5.1 15 Apr 2008 Fixed
Description
Trying to update a BLOB Oracle column with UpdateBlob using JDBC driver results in an Oracle error like:



- ORA-01461: can bind a LONG value only for insert into a LONG column

- ORA-01465 invalid hex number



CR:492548
CR Number:   492548
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Mar 2008 Third Party Problem
Description
In an MDI frame if you open up sheets the sheets are then listed under the "Windows" menu item. Once you hit about 10 sheets only 10 sheets are listed and the last menu item becomes "More Windows". When you select more windows you get a dialog box that lists all the sheets.



But if you initially open up a sheet that is not enabled and then open up more than 10 sheets that are enabled, if you click the "More Windows" menu item and select a sheet that was not listed in the Windows menu, ie it is a greater than 10 sheet, then that sheet is not displayed as it should be, a different sheet is displayed, or the disabled sheet is displayed.



3/11/2008: Engineering determined this is a Microsoft issue. VC++ programs exibit the same behavior.



CR:492556
CR Number:   492556
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Feb 2009 Consult Complete
Description
Request Engineering to analyze a PBVM crash dump within EAServer for California Courts in their production application. From the dump it seems that the crash happened in Oracle Client dll: oraclient10.dll.



CR:492566
CR Number:   492566
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Apr 2008 Fixed
Description
Columns in a datawindow do not display correctly in WebForms. A raised border column with an Edit Style of 3D RadioButton does not have white background in the circles. Also the text and circles could be centered better. Columns with a lowered border and an Edit Style of Edit do not appear lowered at all, but have a blue outline. A groupbox on a window is larger in webforms and runs into other controls. A horizontal scroll bar does not display on a datawindow. And the initial highlight of a dddw column in a datawindow is not highlighted in webforms.



CR:492621
CR Number:   492621
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jun 2008 Fixed
Description
SQL query has a where condition with subselect with union. Cause SQL0255 'Function not supported for query'

workaround is to change disablebind.
Workaround Description
 change disablebind



CR:492661
CR Number:   492661
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11.1 11 Apr 2008 Fixed
Description
MS SQL Server 2005 using the SNC PB driver. A datawindow query with a large number (16) of joins crashes PB11. The same query works OK in ASA (ODBC):



SELECT Atable.ColumnA,

Atable.ColumnB,

B1.ColumnA,

B1.ColumnB

FROM Atable

JOIN Btable B1 ON Atable.ColumnA = B1.ColumnA

JOIN Btable B2 ON Atable.ColumnA = B2.ColumnA

JOIN Btable B3 ON Atable.ColumnA = B3.ColumnA

JOIN Btable B4 ON Atable.ColumnA = B4.ColumnA

JOIN Btable B5 ON Atable.ColumnA = B5.ColumnA

JOIN Btable B6 ON Atable.ColumnA = B6.ColumnA

JOIN Btable B7 ON Atable.ColumnA = B7.ColumnA

JOIN Btable B8 ON Atable.ColumnA = B8.ColumnA

JOIN Btable B9 ON Atable.ColumnA = B9.ColumnA

JOIN Btable B10 ON Atable.ColumnA = B10.ColumnA

JOIN Btable B11 ON Atable.ColumnA = B11.ColumnA

JOIN Btable B12 ON Atable.ColumnA = B12.ColumnA

JOIN Btable B13 ON Atable.ColumnA = B13.ColumnA

JOIN Btable B14 ON Atable.ColumnA = B14.ColumnA

JOIN Btable B15 ON Atable.ColumnA = B15.ColumnA

JOIN Btable B16 ON Atable.ColumnA = B16.ColumnA

WHERE 1 = 1



CR:492689
CR Number:   492689
Product Name:   PB Enterprise
Product Component:   Rich Text
Status:   Closed
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.5.1 07 Apr 2008 Fixed
Description
An RTE.copyrtf() function is leaking memory. In a loop it's a very bad leak increasing rapidly to a point where you crash.



CR:492763
CR Number:   492763
Product Name:   PB Enterprise
Product Component:   DB ADO.NET
Status:   Open
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request to include support for Informix in our ado.net DBMS driver.



Currently .Net dataproviders for ASE, Oracle and SQL Server are supported

Table 5-1 in the Connecting to your Database manual of PowerBuilder 11.1



CR:492797
CR Number:   492797
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11.1 12 Mar 2008 Fixed
Description
The customer has an application that connects to Oracle and it runs 24 hours a day. One of the requirements of this application is if the network goes down or the database isn't available, his powerbuilder app will try to do a reconnect every 30 seconds until in connects successfully agian. Sometimes at night or over the weekend, the database goes down and stays down. His app keeps trying to re-connect every 30 seconds. When this happens there is a memory leak and eventually the PB app crashes.



3/10/2008: This issue is fixed. The fix is available in PB 11.1 build 8218 and after, and PB 11.2 build 8509 and after.



CR:492806
CR Number:   492806
Product Name:   PB Enterprise
Product Component:   Debugger
Status:   Open
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Team Sybase reports that in the debugger the bubble help not displaying in the source pane when you hover the cursor over a variable in the script if the variable name contains a "#". Variable names without "#" in them display the bubble help showing the contents of the variable when you hover over it.



Team Sybase also claims that in PB 11.2 variables with a "#" in their names are not displayed properly in variable panes. For example the variable 'ls_y#' is displayed as 'ls_y_u0023_'.



CR:492844
CR Number:   492844
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   Windows XP
Original Version:   10.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Nov 2009 Fixed
Description
PB does not provide the option which rewrites dw object in a PrintPage event.



CR:492911
CR Number:   492911
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   11.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Mar 2008 Fixed
Description
PB crashes after calling ShareDataOff and then setfilter.



CR:493009
CR Number:   493009
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Aug 2008 Fixed
22 Jul 2008 Fixed
Description
When a variable or an object new in an ancestor window after changing the code of a descendant window has been located, PB cannot open a descendant window. This issue causes GPF. The Workspace cannot be re-opened after GPF occurs.



CR:493051
CR Number:   493051
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Mar 2009 Not a Bug
Description
OS: Windows XP SP2

Versions and Build #s Tested: PB 11.1_8123

Database/Driver File/Version: O90 connecting to Oracle 10g, using Oracle 10.1.0 client

IIS 5.1

.NET Framework 2.0.50727.42



Comments: When trying to connect to Oracle database via O90 from within webforms, we always get the error "Oracle library OCI.dll could not be loaded".



CR:493055
CR Number:   493055
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Apr 2008 Fixed
Description
OS: Windows XP SP2

Versions and Build #s Tested: PB 11.1_8123

Database/Driver File/Version: N/A

IIS 5.1

.NET Framework 2.0.50727.42



Comments: Issue reproduced in a treeview DataWindow with a Checkbox for each level-2 Node. When it's used on the WinForm, if they select one or more Checkboxes inside Node 1, for example, and then clicks to display the content of Node 2, the content is displayed as expected, and all modifications are kept. When it's used on the WebForm, as soon as you click Node 2 its content is displayed, but any modification made to Node 1 is undone.



CR:493066
CR Number:   493066
Product Name:   PB Enterprise
Product Component:   Rich Text
Status:   Closed
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.5.1 07 Apr 2008 Fixed
Description
The rte.InputFieldLocate funtion locates an input field in a RichTextEdit control. It returns a string with the name of the input field if it succeeds. InputFieldLocate returns an empty string if no matching input field is found or if an error occurs. However in the latter case the returned string appears to be an empty string, but if you do a len() on the string you get a -1! Worse, and probably caused by the -1, if you do a Trim() on that string, PB crashes.



03/17/2008: Fixed in PB 10.5.2 build 7640 and after.



CR:493087
CR Number:   493087
Product Name:   PB Enterprise
Product Component:   PB.NET WinForm
Status:   Open
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A tab control with a two lines on the tab displays incorrectly when deployed as a winform. Only the first line of the tab's legend text displays. Customer claims in PB 11.2 build 8407 that the Tahoma font is displayed too large.



Webform and win32 both display both lines of the tab's legend text.



CR:493165
CR Number:   493165
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Apr 2008 Fixed
Description
The datawindow datawindow.syntax property reports other values then the edit source in IDE. Some properties like hidegreyline and backgroundcolorxp are not there, but in the syntax there is eg. a property selected.mouse=no that is not in edit source.



CR:493209
CR Number:   493209
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Open
OS:   Solaris 2.8
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Milliseconds of current time within PB comp are not available in Solaris. Works fine in Windows environment.



When you run the testcase , you would see following in EAServer log :



Solaris :

**********



2008-03-03 09:48:28.086 INFO btpool0-2 [JaguarServer] Begin :09:48:28:000 <---- Milliseconds part is 000

2008-03-03 09:48:28.087 INFO btpool0-2 [JaguarServer] From Function of_test

2008-03-03 09:48:28.087 INFO btpool0-2 [JaguarServer] End :09:48:28:000 <---- Milliseconds part is 000



Windows :

***********



2008-03-03 10:04:41.595 INFO btpool0-2 [JaguarServer] Begin :10:04:41:595 <--- Valid Milliseconds

2008-03-03 10:04:41.595 INFO btpool0-2 [JaguarServer] From Function of_test

2008-03-03 10:04:41.595 INFO btpool0-2 [JaguarServer] End :10:04:41:595



CR:493302
CR Number:   493302
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Apr 2008 Fixed
Description
Cannot edit data on Treeview DWs when 1st row is not collapsed

no Workaround



CR:493319
CR Number:   493319
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Open
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The datawindow detail band is set to autosize height. There are 2 computed fields in the detail band. On top is a computed field with the following expression:



if(getrow() = min(getrow() for page), title, "")



This is intended to only show the title column for the first row on the page. Directly below the first computed field is the second that shows a detail row. Both computed fields are slide up all above and autosize height. The intention is to display a title column at the top of the page for the first row, then first row data underneath. Then for the rest of the rows on the page, no title displayed, only row data, with the row data sliding up because the title is blank. When it displays, the first row is correct with the title and the data, but all other rows have a blank space where the title would be, and the row data does not slide up as expected leaving this large space between the row data. I have tried other ways to do the same thing for example the following expression for the title computed field height:



if(getrow() = min(getrow() for page), 77, 0)



But it has the same results. I suspect that the aggregate function is the cause in that when the datawindow engine is determining what each row should look like, the aggregate function is not known, so the expression doesn't evaluate properly. It's a Catch 22.



So the question is, can this be fixed?



CR:493334
CR Number:   493334
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Nov 2008 Fixed
Description
Customer have an application set running on Windows Server 2003 Service Pack 2 compiled with Version 11.1 Build 8204 that has the application crash in PBVM110.dll.This is an application that uses tcp/ip as a communication protocol between other applications runing on the same machine and remote clients over TCP/IP.

This program set runs as a server for remote clients. There are several administrators that will connect to the Windows Server 2003 machine using remote desktop. If their display setting of remote desktop are different from the last user then the PowerBuilder application will crash. Testing revealed that changing the "desktop size" or the "color resolution" between connections will crash the program. Customer set up a simple midi application with three empty sheets and that application does not crash.



App doesn't crash outside of Terminal Services. Customer tried changing resolution and color depth about 15 times with no failure outside of Terminal Services. While using Terminal Services customer notice that when you reconnect with a different resolution that all applications will minimize. (Both Task Manger and the MobileServ application). Apparently, Terminal Services is triggering an event to cause this to happen. This is just an observation.



CR:493471
CR Number:   493471
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Apr 2008 Fixed
Description
The customer has an app with a response window that has picture buttons lined up in a column to the left of a tab control. When deployed to Web Forms the buttons are on top of the tab control and nothing happens when you click them. Also the tabs don't respond when clicked.



It's not related to a response window as the same behavior happens when it's changed to a main window.



4/29/2008: Verified fixed in PB 11.2 build 8407.



CR:493519
CR Number:   493519
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11.1 11 Apr 2008 Fixed
Description
PB with SNC cannot store the correct value in a decimal host variable from float data.

For example,
Workaround Description
 A host variable is created by double. And the obtained value is substituted for a decimal type. The value of float will be rounded correctly.



CR:493590
CR Number:   493590
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 May 2008 Fixed
Description
Sheets on MDI webform not opening. It appears the

open event and activate event of sheet are firing but sheet never appears.



The Receipt Entry (m_poreceiptentry) calls gf_open_sheet_with_name in the gbl_menu.pbl.

The function is trying to open the w_m_receipt window.



w_m_receipt - \inventory\receipts.pbl

inherited from w_ma_window - \_common\inh_win.pbl

inherited from w_ma_sheet - \_common\inh_win.pbl



CR:493683
CR Number:   493683
Product Name:   PB Enterprise
Product Component:   PB.NET Assembly Deployment
Status:   Closed
OS:   Windows XP
Original Version:   11.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jun 2008 Consult Complete
Description
Deployement failed without any information for debugging



CR:493734
CR Number:   493734
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Mar 2008 Fixed
Description
The customer has an MDI application. On one of the sheets is a tab control with three tab pages. Each tab page has a bitmap displayed on it's tab. There is also a treeview on the sheet. There are 2 problems when the application is deployed to Web Forms. First the three bit maps displayed on the tab pages are washed out. They don't appear with the same detail and clarity as they do in client sever. (The tabs them selves, and the whole tab control is flat in WebForms with a blue border, whereas in client server the tab control and the tabs have a raised border - this issue is reported in another CR)



The second issue is resizing. The customer has resizing code so that the tab and the treeview fill the sheet, whatever it's size. This works fine in client server, but in webforms the resizing is not done when the sheet is first displayed. You have to click on an object on the window before the resizing is done.



CR:493867
CR Number:   493867
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Apr 2009 Not a Bug
Description
Webform:



With a Treeview and a Datawindow control in the same .Net WebForm window, tabbing out

from a modified column gives a flickering effect with postbacks and loss of the focus

due to the itemchanged event.



CR:493879
CR Number:   493879
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   11.0 RC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 2008 Fixed
Description
App is crashing when using sharedata() or rowscopy().

The faulting ip address is as follows:



FAULTING_IP:

PBDWE110!DWDataBuffer::GetItem+12 [e:\pb11\dw\engine\table\dwtbufr.cpp @ 535]

116e0fd2 8b04b8 mov eax,[eax+edi*4]

EXCEPTION_RECORD: ffffffff -- (.exr ffffffffffffffff)

ExceptionAddress: 116e0fd2 (PBDWE110!DWDataBuffer::GetItem+0x00000012)

ExceptionCode: c0000005 (Access violation)

ExceptionFlags: 00000000

NumberParameters: 2

Parameter[0]: 00000000

Parameter[1]: 00000004

Attempt to read from address 00000004



CR:493884
CR Number:   493884
Product Name:   PB Enterprise
Product Component:   DW Wizards
Status:   Open
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Cannot build a DW based on a Web Sevice with an HTTPS url



CR:493975
CR Number:   493975
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Open
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
AutoSelect of the head column of DW does not become effective.



CR:494014
CR Number:   494014
Product Name:   PB Enterprise
Product Component:   DB OLE DB
Status:   Open
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11.1 13 Apr 2008 Fixed
11.1 Fixed
Description
In MSS, if raiserror was called more than once , the one with the highest severity was reported in PB transaction object. With the other interfaces, it is the first raiserror that gets reported, no matter what the severity is set to.



CR:494056
CR Number:   494056
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Open
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The customer has a number of tabpages in a tab control. The tab control has the Powertips and Multiline properties checked. Some of the tabpages become invisible at times. But when you hover the cursor near where an invisible tab page is, it's Powertip still displays. For example if tabpage 5 is invisible, if you hover the cursor around where the tabpage 4 and tabpage 6 tabs are adjacent, you'll see the tabpage 5 Powertip displayed.



CR:494150
CR Number:   494150
Product Name:   PB Enterprise
Product Component:   Menus - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.5 29 Apr 2008 Fixed
Description
SetToolbarPos function crashes PB.



CR:494173
CR Number:   494173
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 May 2008 Fixed
Description
Bug on webform File manager. It does not appear to be working properly when whe use GetFileOpenname with the graphic filter.



GetFileOpenName("Select an Image File to Upload", s_filename, s_pathname, "jpg", "Graphic Files (*.jpg;*.bmp;*.gif;*.tif;*.png),*.jpg;*.bmp;*.gif;*.tif;*.png;*.jpeg;*.tiff")



Works fine when not using the graphics filter



GetFileOpenName("Select File", s_pathname, s_filename, '*', " Files (*.*),*.*")



CR:494194
CR Number:   494194
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Aug 2008 Not a Bug
Description
Customer is having a memory leak in EAServer with a PB component. They have sent in a dump file. Asking for Engineering anaysis of the dump.



CR:494218
CR Number:   494218
Product Name:   PB Enterprise
Product Component:   DW Ink Control
Status:   Closed
OS:   Windows XP
Original Version:   10.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Apr 2008 Fixed
Description
Null InkPicture crashes on SetFullState



CR:494246
CR Number:   494246
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Open
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Calling SetFullState on an empty DW will cause a GPF if the BLOB was created with GetFullState on a DW with a InkPicture control populated from an Oracle database.



CR:494301
CR Number:   494301
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   11.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jun 2008 Presently Not Targeted For Any Future Release Of This Product
Description
Crash dump collected from PowerBuilder Application. Application started crashing once migrated to PB 11 and XP. Application uses Attachmate to connect to the mainframe.



Application is crashing in PBSHR110.dll.



CR:494363
CR Number:   494363
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 2008 Workaround
Description
Customer's application use window timer event to trigger

sequences action and end with a response window. On the other hand, there is validation

triggered by datawindow itemchanged event, that lead to another popup dialog box.

Under frequent trigging of both response window and itemchanged dialog box, The timer event stop triggering and itemchanged event get pass for wrong value on validation.



CR:494440
CR Number:   494440
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Open
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The customer is using a tab control and has both an bitmap icon and text on the tab of each tab page. In Win32 client server, the icon and text are centered on the tab with an equal space on the left edge and the right edge of the tab. But in WebForms the icon and text are shifted all the way to the left of the tab, with no space on the left edge, and a very wide space on the right edge.



CR:494546
CR Number:   494546
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   Windows XP
Original Version:   10.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Apr 2008 Fixed
Description
During printing a Datawindow containing about 50 Thousand rows (approximately 1250 Pages) when moving the mouse a GUI Problem starts to show ie. after a few seconds only strange figures appear on screen. This happens when using the windows 2000 style. When using XP Style display settings then it works fine !



CR:494586
CR Number:   494586
Product Name:   PB Enterprise
Product Component:   Rich Text
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Nov 2008 Fixed
Description
From the online help for showheadfoot, it list the

following as a code example to use to insert the current page number in a footer:

rte_1.showheadfoot(true,false)

rte_1.setalignment( Center! )

rte_1.inputfieldinsert("PAGENO")

rte_1.showheadfoot(false,false)



Please clarify in the documentation that the headerfooter property must be checked

at design time. The above code should be added to the Application Techniques Manual,

Implementing Rich Text.



Also in the Application Techniques Manual, Implementing Rich Text, Preview and Printing,

theres a section on Setting the page number. I believe that code is obsolete.



For more info, see cr433830.



CR:494634
CR Number:   494634
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jun 2008 Fixed
Description
When EditMask has mask value of "000" and type of "numericmask!" ,update value moved to wrong position.



CR:494722
CR Number:   494722
Product Name:   PB Enterprise
Product Component:   PB.NET Smart Client
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Apr 2008 Fixed
Description
Error when publishing an application to a ftp site.

Publishing to ftp site fails.



CR:495110
CR Number:   495110
Product Name:   PB Enterprise
Product Component:   DB OLE DB
Status:   Closed
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.5.1 10 Apr 2008 Fixed
Description
Connecting to MS SQLServer via OLE DB. The customer has a stored procedure and is calling this procedure in embedded SQL in PB using delclare, execute, and fetch, accessing parameters by name. The stored procedure is used in other none PB applications as well. Sometimes changes are made to the stored procedure, like adding a new parameter. In the past the existing PB exe continued to work fine after a change like this as it was accessing parameters by name and didn't need to use the new parameter. But now in build 7611, he is getting the error "Mismatch between Retrieve Columns and Fetch Columns". He believes this should not be happening.



CR:495343
CR Number:   495343
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Open
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When using dw_1.saveas to save in XML! format with EncodingANSI,

PB is saving the file with extra hex characters.



In textpad you can see the following characters at the beginning of the file where

these characters are not there in PB 9:

EF BB BF 3C....



In PB 9:

3C....



CR:495542
CR Number:   495542
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Open
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Need different sorting of events/functions in script painter.



Currently the choices are (a) scripted first and (b) alphabetical. If you're working with a large framework (.e.g., PFC) you can have a lot of events/functions that are scripted in the ancestor but not in the current object. Events/functions that are scripted in the current object should have precedent. So when scripted first is chosen the order should be (1) scripted in current object, then (2) scripted in ancestor and finally (3) not scripted.



CR:495571
CR Number:   495571
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Mar 2008 Not a Bug
Description
The customer has an app that is crashing after closing the main window. He can run his app in IDE but it crashes in the exe.



CR:495698
CR Number:   495698
Product Name:   PB Enterprise
Product Component:   DB OLE DB
Status:   Closed
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.5.1 14 Apr 2008 Fixed
Description
Memory leak with the OLEDB ODB interface against MS SQL Server when using the SyntaxFromSQL function.



CR:495771
CR Number:   495771
Product Name:   PB Enterprise
Product Component:   DW XML
Status:   Open
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
PB cannot import the element of omitted XML correctly. XML imported to DW must include all elements. An empty element is sufficient as it.
Workaround Description
 Please add an empty element to XML. example( <xxxx /> ).



CR:495833
CR Number:   495833
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Open
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Team Sybase reports that when using OLE in Powerbuilder to access Excel and you try to make a column larger then 255 you get an error. The error message is "Powerbuilder Application Execution Error (R0039)" "Error: Error accessing external object property columnwidth at line..." But when attempting to do the same when running Excel standalone the Excel error is "Column width must be between 0 and 255 characters". Shouldn't PowerBuilder be able to report the real Excel error?



CR:495841
CR Number:   495841
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11.2 30 Apr 2008 Fixed
Description
Imported XML data is getting cut off in a datawindow on a webform



CR:495845
CR Number:   495845
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11.2 30 Apr 2008 Fixed
Description
Extra scrollbars appearing next to text data in a datawindow

on a webform



CR:495947
CR Number:   495947
Product Name:   PB Enterprise
Product Component:   Rich Text
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Apr 2008 Fixed
Description
Inputfieldcurrentname is inconsistent when inserting a document thru the popmenu.



For example, when inserting a document thru the popmenu and then selecting text (but

not an input field), PB will return the first inputfield in the document. This will

continue to happen until you select an inputfield, then PB will return the current name ok. When you continue to select text after that (but not an input field), PB will return nulls ok for InputFieldCurrentName.



However, when you insert a document using rte_1.insertdocument("my.rtf,true,filetyperichtext!) and then select text (but not an input field), PB

will return nulls for the inputfieldcurrentname. This is ok. PB should only

return an inputfield when one is selected.



CR:495949
CR Number:   495949
Product Name:   PB Enterprise
Product Component:   PB.NET
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Apr 2008 Not a Bug
Description
Unable to call an NVO deployed in a .NET assembly.



CR:495954
CR Number:   495954
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Open
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
OLEStorage Open crashes PB when directory path and filename is long. The customer is getting a -9 returned. But TSE and PSE are crashing. Either way can we get the limit increased so any (un)reasonably long name will work?



CR:496037
CR Number:   496037
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Open
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 May 2008 Fixed
Fixed
Description
When try to call external function "Shell_NotifyIconA;Ansi", PB11 seem able to perform all

expected but the PB Application crash on return. If convert to ANSI call to

"Shell_NotifyIconW", PB Application does not crash but fail to call the Balloon Tip in

system tray icon.



CR:496060
CR Number:   496060
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Open
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A crash or connection loss is encountered when calling DataWindow DBCancel before the first row has been retrieved.

The retrieve has a long prepare time.



Versions used:

PowerBuilder 10.5.2 Build 7611

Database interface O90 or O10 with Oracle Client 9.2.0.8, 10.2.0.1 or 10.2.0.2



CR:496086
CR Number:   496086
Product Name:   PB Enterprise
Product Component:   Rich Text
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2008 Fixed
Description
Customer needs a way to programmically set superscript and

subscript.



The following example on code exchange opens a font dialog. There you have to

set the radio button for subscript or superscript. Is there a way to set

this as a default when you open.



CR:496377
CR Number:   496377
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jun 2008 Fixed
Description
The second column has a visible expression, that depends on the value of the first column. When you change the value of the first column, a postback is sent to the server and the second column is not visible. You can't see, which column has the focus now.

When you now change the value of the first column again (to 101), the second column becomes visible, but the cursor is in the third column.



CR:496412
CR Number:   496412
Product Name:   PB Enterprise
Product Component:   PB.NET WinForm
Status:   Closed
OS:   Windows XP
Original Version:   11.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 May 2008 Fixed
Description
When the cursor on a webform is in a column the getfocus function does not work.



CR:496463
CR Number:   496463
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Open
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
OS: Windows XP SP2

Versions and Build #s Tested: PB 11.1_8204, 11.1_8218 and 10.5.2_7635

Database/Driver File/Version: ASE 15.0, accessed via WSDL



Comments: When retrieving information from ASE web service via SOAP, PowerBuilder display size mismatch in array-to-object conversion between tns_datareturn structure and self-created structure variable. It seems that the generated proxy is invalid.



CR:496537
CR Number:   496537
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Aug 2008 Fixed
Description
Display overlap problem with a large text column and a nested datawindow report using autoseize height and sliding up.



CR:496582
CR Number:   496582
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Access violation error using PB 10.5.2, EAServer 5.3

and Oracle 10g.



The exact error is:

FAULTING_IP:

oraclient10!kppisize+374a

61c829fe 0fb64618 movzx eax,byte ptr [esi+0x18]



EXCEPTION_RECORD: ffffffff -- (.exr ffffffffffffffff)

ExceptionAddress: 61c829fe (oraclient10!kppisize+0x0000374a)

ExceptionCode: c0000005 (Access violation)

ExceptionFlags: 00000000

NumberParameters: 2

Parameter[0]: 00000000

Parameter[1]: 00000118

Attempt to read from address 00000118



064cdd74 61c2988a 0324ae10 448d596c 00000100 oraclient10!kppisize+0x374a

064cddac 031816ce 0324ae10 448d596c 00000100 oraclient10!OCIDateTimeConstruct+0x38

064cdde4 077a1d52 0324ae10 448d596c 00000100 oci!OCIDateTimeConstruct+0x42

064cde18 077a781c 0324ae10 448d596c 00000100 pbo10105!CPBOCI::OCIDateTimeConstruct+0x42

064ce278 077a9bd4 400df110 00000001 400df110 pbo10105!Ora_DoBindWInputParms+0xa7c

064cec84 06b55387 400df110 0762e701 400df110 pbo10105!PB_DB_Rout+0x10c4

064cec8c 0762e701 400df110 4019c01c 426a27c8 PBSHR105!DBI_PrepareWithParms+0x37

064ced10 074a1627 064cfbd8 06e6a8c7 56433230 PBDWE105!dwGetExceedPageMessage+0xa11

064cedcc 426a2788 3fe142f0 00000001 43039550 PBDWE105!CreateXHTMLTemplate+0xe077

40122f84 40099228 43fda468 4011fca4 00000000 0x426a2788

400df110 00000000 00000000 00000000 00000000 0x40099228



CR:496686
CR Number:   496686
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Open
OS:   Windows XP
Original Version:   11.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
On a simple MDI application, when two child windows are opened with a delay containing a button, the button's text appears 2 times during the opening.

In PB 11.2 the button appeary 2 times on the sheet.
Workaround Description
 I have taken a look at the sample and I have some workarounds, and depending on the application they might be applicable by the customer.



Eg. use a different OpenSheet argument for arrangeopen.



In the sample that would mean use

li_rc = OpenSheet ( lw_sheet, as_sheetname, w_genapp_frame, 0, Cascaded! )

in the of_opensheet function. (or use Layered!)



or use the original code and use later in that event:

w_genapp_frame.ArrangeSheets ( cascade! )



CR:496734
CR Number:   496734
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Aug 2008 Third Party Problem
Description
Wrong DateTime conversion in PB EasySoap.



CR:496791
CR Number:   496791
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 May 2008 Fixed
Description
Somewhere in version 9 this behavior changed. You have a date, datetime, or time column in a datawindow with an editmask and autoskip checked. With a record in the dw if you click in a column to position the cursor just after the last digit, it will immediately skip to the next column. In PB 8 and earlier versions of PB 9 you could click at the end and edit the column.



CR:496807
CR Number:   496807
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Aug 2009 Not a Bug
Description
CR 466805 was not fixed on DateTime datatype.





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