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

 

随着Sybase被完全整合到SAP下,Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
考虑到Sybase数据库的初学者或者没有购买原厂服务的Sybase客户情况,现提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息。
在SAP Support Portal网站或者google上搜索Targeted CR List for ASE,可以看到针对不同版本的CR(CR表示Change Request)简单描述信息列表。
需要注意的是:Targeted CR List for ASE列出的CR虽然绝大多数是BUG,但有一些是更改需求。
以下提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息!

如有问题,请联系我!

QQ :289965371 联系我们获取数据库技术支持!
Email:
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

 

CR:480992
CR Number:   480992
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Nov 2007 Fixed
Description
DataWindow Painter crashes on saving the XHTML template after modifying the select in the Data Source.



CR:481011
CR Number:   481011
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)
11 Jan 2008 Consult Complete
Description
Unable to change the fontsize programmically in rte

using the SendMessage api.



There is no error message. The text size just doesn't change. Using the

following syntax:



function integer setcolorlogfont (ulong hwnd, ulong msg, ulong wparm, s_colorlogfont clf) library 'user32.dll' alias for "SendMessageA;Ansi"



Resolution: setlogfontmsg should be 3092. New RTE code sample is available on powerbuilder.codexchange.sybase.com.



CR:481108
CR Number:   481108
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Open
OS:   Windows XP
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When calling a MSSQL Web Service, no results

are returned.



Using the following syntax:

SoapConnection conn

long Val,log

string name

//any ws_any[]

getpurchaseorderendpoint proxy_obj

getpurchaseorderresponsegetpurchaseorderresult myresult



conn = create SoapConnection

conn.useintegratedwindowsauthentication(true)



Val = conn.CreateInstance( proxy_obj, "getpurchaseorderendpoint")

log= conn.SetSoapLogFile("C:\mySoapLog.log")

if Val <> 0 then

messagebox("Error","Cannot create proxy object")

else

try

myresult = proxy_obj.getpurchaseorder(244 )

catch (SoapException e)

messagebox("ERROR Message", e.Text)

end try



//name = proxy_obj.getpurchaseorderresponsegetpurchaseorderresult

end if

destroy conn



CR:481109
CR Number:   481109
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Windows XP
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Oct 2007 Not a Bug
Description
In the Window painter, a window has a tab control with several pages. Every click you make on objects in a tab page, causes the tab page to change. Keep clicking and it cycles through all the tab pages and even opens up the script editor.



CR:481154
CR Number:   481154
Product Name:   PB Enterprise
Product Component:   DW Rich Text
Status:   Closed
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 May 2008 Fixed
Description
The customer is using the page() and pagecount() expression in a computed field in an RTF datawindow to display page x of n. But pagecount() always returns 1. This is a regression. Works fine in build 5079.



CR:481238
CR Number:   481238
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Crash when working with an OLE control inserted in a tabpage.



CR:481256
CR Number:   481256
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Sep 2007 Not a Bug
Description
Customer has a PB 9 PFC app that they have migrated to PB 11.0 build 6525. They are seeing random crashes after running for a while. They have not been able to narrow down what it may be. They have supplied 3 ADPlus crash logs and are looking for any information that might help them determine the issue here.



CR:481359
CR Number:   481359
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Open
OS:   Windows XP
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Could make the usage of a DW a bit easier for users who don't want to create a storedprocedures to obtain a resultset based on a SQL batch that returns a resultset.
Workaround Description
 see repro on how to work with it currently.



CR:481366
CR Number:   481366
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   10.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Apr 2008 Fixed
Description
Big Memory growth (8MB for a 100000 loop) when using dot notation on a DW. For DS the leak is smaller.



Specially when modifying filter buffer using dot notation there is a big initial increase of memory for both DW and DS.



CR:481370
CR Number:   481370
Product Name:   PB Enterprise
Product Component:   DW Rich Text
Status:   Closed
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Apr 2008 Fixed
Description
Total page count is wrong when pasting a RTF document into a RTF DataWindow with <Ctrl><V>.



The page count is correct when you use the Paste option in the popup menu when right clicking in the RTF DW.



CR:481371
CR Number:   481371
Product Name:   PB Enterprise
Product Component:   DW Rich Text
Status:   Open
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RTF DatatWindow prints only once when more then 1 copy had been selected in the Print Setup Dialog.



CR:481416
CR Number:   481416
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 2007 Workaround
Description
Customer's application retrieves and writes out approximately 3.5 million records to a txt file. At some number over 3 million the application does not write out all records. All rows appeared to have been retrieved as the row count is correct.



CR:481497
CR Number:   481497
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.2.1 10 Oct 2007 Fixed
Description
When trying to insert a string that is 16384 or longer,

no data gets inserted into the column for a Oracle table. The column is blank.

Any data that is less than or equal to 16383 inserts into the column ok.



The following script works:

long ll_id = 1

string ls_long = "123,456,789" + space(16372)

INSERT INTO LONG_11380983 (id, report) VALUES (:ll_id, :ls_long);



But the following script does not insert any data in the report column:

ll_id = 2

ls_long = "123,456,789" + space(16373)

INSERT INTO LONG_11380983 (id, report) VALUES (:ll_id, :ls_long);



CR:481576
CR Number:   481576
Product Name:   PB Enterprise
Product Component:   PB.NET
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Add support for .Net framework 3.0 and Windows Presentation Foundation.



CR:481676
CR Number:   481676
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Oct 2007 Fixed
Description
DW dberror event not triggered



CR:481721
CR Number:   481721
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)
19 Nov 2007 Fixed
Description
While using the following code, XML is returning xsi:nil="true" with no blank tags.



// Sample code to export XML from a data store.



lds_docket_parms.Modify("DataWindow.Export.XML.UseTemplate ='t_export'")

lds_docket_parms.Modify("DataWindow.Export.XML.MetaDataType = XMLNone!")

ls_xml_temp = lds_docket_parms.Object.DataWindow.Data.XML



lds_docket_parms is object is inherited from data store





In PB 10.5.1 (build 6627), xml includes a blank tag when there is no data in a specific

field (ie., <parm_display_format/>)



CR:481749
CR Number:   481749
Product Name:   PB Enterprise
Product Component:   DB ADO.NET
Status:   Closed
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.5.1 21 Nov 2007 Fixed
Description
When connected to MSSQL with ADO.NET and running

a long stored procedure, the following error results:





*** ERROR 999 ***(rc -1) : Index #0 Message: Timeout expired NativeError: 0 Source: Microsoft OLE DB Provider for SQL Server SQLState: HYT00





Works ok using the OLEDB driver. Problem happens using ADO with System.Data.OleDb and System.Data.SqlClient namespaces.



Using the following stored procedure:

create PROCEDURE dsp_TestTimeout

@DELAYLENGTH varchar(9) = '000:00:05'

AS Begin

Declare @StartTime datetime

Declare @EndTime datetime

Set @StartTime = GetDate()

WAITFOR DELAY @DELAYLENGTH

Set @EndTime = GetDate()

select @StartTime, @EndTime , DateDiff(second, @StartTime, @EndTime)

End



CR:481751
CR Number:   481751
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Open
OS:   Windows XP
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When customer opens two instances of PB 11 with same workspace in order to cut and paste script and second instance crashes.



With a simple workspace with only one target and a few objects I did not see the problem.



CR:481821
CR Number:   481821
Product Name:   PB Enterprise
Product Component:   DataBase
Status:   Open
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
An expression in embedded SQL can lead to errornous results due to unintended type conversions when DisableBind = 1 is used.



CR:481823
CR Number:   481823
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Feb 2008 Third Party Problem
Description
PB crashes in IDE mode when using a third-vendor ActiveX



CR:481879
CR Number:   481879
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Text not fully justifed in a DW column (Right and left).



CR:481885
CR Number:   481885
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Closed
OS:   Windows XP
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Dec 2007 Not reproducible with latest version of the product available as of Resolution Date
Description
When positioning the cursor in a dw column that is

part of a tab control, the webform just hangs and does not respond.



Works ok in PBNative and Winform



CR:481895
CR Number:   481895
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Windows XP
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Dec 2007 Fixed
Description
When retrieving a nested datawindow from a

component in EAS 6.01, not all the data is retrieve. When you try calling

the same function again, you get an access violation error:



2007-10-02 10:10:06.351 INFO Thread-61 [JaguarServer] PB INTERNAL EXCEPTION on: Thread : 3408, Address : 0x0567D549, Type : EXCEPTION_ACCESS_VIOLATION reading address 0xF005E9A1. CPB_Component::invoke

2007-10-02 10:10:06.351 INFO Thread-61 [JaguarServer] Dumped Succeeded to file:

2007-10-02 10:10:06.351 INFO Thread-61 [JaguarServer] C:\pb\EAServer6\bin/PB_20071002_100904_0001.dmp

2007-10-02 10:10:06.351 INFO Thread-61 [JaguarServer] Fatal Error Occurs when try to invoke PB method of_retrieve in p_nesteddw/n_nesteddw.



CR:481968
CR Number:   481968
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2007 Fixed
Description
When using Retrieve To Disk programmically in

script using either dot notation or the modify statement, the data retrieved is incorrect.



Using:

dw_1.Object.DataWindow.Table.Data.Storage = 'Disk'

or

dw_1.Modify("DataWindow.Table.Data.Storage='Disk'")



CR:481978
CR Number:   481978
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jan 2008 Fixed
11 Jan 2008 Fixed
Description
PB shuts down with no error message when failing to load wide jpeg



CR:482018
CR Number:   482018
Product Name:   PB Enterprise
Product Component:   PB DOM
Status:   Closed
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11.0 13 Dec 2007 Fixed
Description
The memory used keeps increasing with each successive execution of SaveDocumentIntoString of an xml datawindow. You can see it going up in the Windows Task Manager. It doesn't seem to be releasing the memory used for previous strings even though the same string variable is reused each time.



CR:482031
CR Number:   482031
Product Name:   PB Enterprise
Product Component:   DB Painter
Status:   Closed
OS:   Windows XP
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11.1 14 Oct 2007 Fixed
Description
DBPainter indicates a wrong Edit style detail when I clicked Edit style list,

if we get the save dialoge box.
Target Version
 11.1
Workaround Description
 Click again.



CR:482038
CR Number:   482038
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   10.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.5 12 Nov 2007 Fixed
30 Oct 2007 Not a Bug
Description
IDL generated is missing the package, causing failure to build stubs.



CR:482127
CR Number:   482127
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Datetime data being sent to webservice is modified to GMT



CR:482148
CR Number:   482148
Product Name:   PB Enterprise
Product Component:   PB.NET WinForm
Status:   Closed
OS:   Windows XP
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Sep 2009 Not a Bug
Description
When a classname is saved with a % (my%class), the powerscript

function ClassName() will return the value of my_u0025_class for a Winform or

WebForm app





RESOLUTION: A class name with char '%' is invalid in C#.



CR:482265
CR Number:   482265
Product Name:   PB Enterprise
Product Component:   Toolbar
Status:   Open
OS:   Windows XP
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In PB 10 and all previous versions of PB, the PB provided Find! icon and the Search! icons were different. New icons were introduced in PB 10.5 and PB 11 and in these versions, Find! and Search! are the same icon.



In many situations these two functions would mean the same functionality but this customer states that in their application they use these two for different functionality. They now have identical icons with different functionality in their migrated application.



They have replaced one of the icons and are all set but other customers might be using these two for different functions and they should have different icons.



CR:482267
CR Number:   482267
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Open
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer is unable to open Office 2007 Excel worksheets that have been saved in xlsb formate.



Add support in PowerBuilder to use the new xlsb format.



CR:482377
CR Number:   482377
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)
21 Nov 2007 Not a Bug
Description
OS: Windows XP SP2

Versions and Build #s Tested: PB 10.5.2_7016

EAServer 6.0.2.18 on Windows 2003 with PBVM 10.5.1_6021



Comments: Web Dw does not display data in EAServer 6.0. The same repro steps work fine in EAServer 5.x.



CR:482519
CR Number:   482519
Product Name:   PB Enterprise
Product Component:   UO - Runtime
Status:   Open
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
If you create a DataWindow control from within the constructor of another DataWindow Control using OpenUserObject(, the constructor of the created DW will get fired twice.



CR:482555
CR Number:   482555
Product Name:   PB Enterprise
Product Component:   DB Painter
Status:   Closed
OS:   Windows XP
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11.1 14 Oct 2007 Fixed
Description
When changing the new attribute of Database Painter, PowerBuilder crashes. It is reproduced when Style is changed.



CR:482623
CR Number:   482623
Product Name:   PB Enterprise
Product Component:   PB.NET WinForm
Status:   Closed
OS:   Windows XP
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Nov 2007 Fixed
Description
When running a winform app, the following error

occurs:



System.Reflection.TargetInvocationException

An unhandled exception of type System.Reflection.TargetInvocationException occurred

in mscorlib.dll

Exception has been thrown by the target of an invocation



CR:482638
CR Number:   482638
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
Customer is finding escapement issues on migrating to 10.5.2 and 11.



CR:482678
CR Number:   482678
Product Name:   PB Enterprise
Product Component:   Project Wizards
Status:   Closed
OS:   Windows XP
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Feb 2008 Fixed
Description
PB 11. EJB proxy generation is producing an invalid ( wrong ) proxy object for biginteger class. After a correction within the proxy object the problem can be fixed.
Workaround Description
 export BigInteger proxy to see its source code.

. edit biginteger.srx by using notepad. On line 77 append _j to xor so that line 77 will read :

function BigInteger xor_j( BigInteger BigInteger_1) alias for "xor,(Ljava/math/BigInteger;)Ljava/math/BigInteger;"

. save the biginteger.srx file.



. import the biginteger.srx into java_proxies.pbl. You will see it imports without errors.



CR:482679
CR Number:   482679
Product Name:   PB Enterprise
Product Component:   Project Wizards
Status:   Closed
OS:   Windows XP
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 May 2008 Fixed
Description
PB 11. EJB proxy generation is producing a wrong proxy object for the java byte because it conflicts with the internal byte datatype of PB. It should create java_byte proxy.
Workaround Description
 . delete byte proxy object from java_proxies.pbl

. import java_byte.srx into java_proxies.pbl

in java_byte.srx the java_ is set in front of the byte eg:

$PBExportHeader$java_byte.srx

$PBExportComments$Proxy imported from EJB through EJB Proxy generator.

global type java_Byte from Number

end type



type variables

protected:

string java_Byte_javaname= "java.lang.Byte"



public:

indirect int MAX_VALUE { __set_MAX_VALUE(*value), __get_MAX_VALUE() }

indirect int MIN_VALUE { __set_MIN_VALUE(*value), __get_MIN_VALUE() }

indirect long SIZE { __set_SIZE(*value), __get_SIZE() }

indirect any TYPE_j { __set_TYPE_j(*value), __get_TYPE_j() }

end variables



forward prototypes

private:

function int __get_MIN_VALUE() alias for "R:MIN_VALUE,B"

subroutine __set_MIN_VALUE( int MIN_VALUE) alias for "W:MIN_VALUE,B"

function int __get_MAX_VALUE() alias for "R:MAX_VALUE,B"

subroutine __set_MAX_VALUE( int MAX_VALUE) alias for "W:MAX_VALUE,B"

function any __get_TYPE_j() alias for "R:TYPE,Ljava/lang/Class;"

subroutine __set_TYPE_j( any TYPE_j) alias for "W:TYPE,Ljava/lang/Class;"

function long __get_SIZE() alias for "R:SIZE,I"

subroutine __set_SIZE( long SIZE) alias for "W:SIZE,I"



public:

subroutine java_Byte( int int_1) alias for "<init>,(B)V"

subroutine java_Byte( string string_1) throws NumberFormatException alias for "<init>,(Ljava/lang/String;)V"

function int byteValue() alias for "byteValue,()B"

function long compareTo( java_Byte Byte_1) alias for "compareTo,(Ljava/lang/Byte;)I"

function long compareTo( any any_1) alias for "compareTo,(Ljava/lang/Object;)I"

function java_Byte decode( string string_1) throws NumberFormatException alias for "decode,(Ljava/lang/String;)Ljava/lang/Byte;"

function double doubleValue() alias for "doubleValue,()D"

function boolean equals( any any_1) alias for "equals,(Ljava/lang/Object;)Z"

function real floatValue() alias for "floatValue,()F"

function long hashCode() alias for "hashCode,()I"

function long intValue() alias for "intValue,()I"

function longlong longValue() alias for "longValue,()J"

function int parseByte( string string_1) throws NumberFormatException alias for "parseByte,(Ljava/lang/String;)B"

function int parseByte( string string_1, long long_2) throws NumberFormatException alias for "parseByte,(Ljava/lang/String;I)B"

function int shortValue() alias for "shortValue,()S"

function string toString() alias for "toString,()Ljava/lang/String;"

function string toString( int int_1) alias for "toString,(B)Ljava/lang/String;"

function java_Byte valueOf( int int_1) alias for "valueOf,(B)Ljava/lang/Byte;"

function java_Byte valueOf( string string_1) throws NumberFormatException alias for "valueOf,(Ljava/lang/String;)Ljava/lang/Byte;"

function java_Byte valueOf( string string_1, long long_2) throws NumberFormatException alias for "valueOf,(Ljava/lang/String;I)Ljava/lang/Byte;"

end prototypes



CR:482684
CR Number:   482684
Product Name:   PB Enterprise
Product Component:   Menus - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Apr 2008 Fixed
Description
With compiled applications, icons that are compiled into the executable as resources

are not displayed properly in the menu different from the toolbar.

This issue does not appear if the icon is loaded from the filesystem at it's specified location.



CR:482736
CR Number:   482736
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Windows XP
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jan 2008 Fixed
Description
When trying to call the JagGetPeerAddress in EAS6,

the following error returns in the easerver log file:



com.sybase.jaguar.util.JException: getPeerAddress: no client connection

com.sybase.jaguar.server.Jaguar.getPeerAddress(Jaguar.java:133)

com.sybase.jaguar.server.JaguarObject.invoke(Native Method)

com.sybase.jaguar.server.JaguarObject.invoke(JaguarObject.java:289)

com.sybase.jaguar.server.JaguarObject.invoke(JaguarObject.java:97)

com.sybase.jaguar.server.JaguarObject_DJC.invoke(JaguarObject_DJC.java:333)

ejb.components.pb10_pkg.n_ora_cjw_EJB.of_jaggetpeeraddress(n_ora_cjw_EJB.java:269)

ejb.components.pb10_pkg.n_ora_cjwRemote.of_jaggetpeeraddress(n_ora_cjwRemote.java:362)

ejb.components.pb10_pkg.n_ora_cjwRemote_DJC.access$401(n_ora_cjwRemote_DJC.java:4)

ejb.components.pb10_pkg.n_ora_cjwRemote_DJC$5.invoke(n_ora_cjwRemote_DJC.java:877)

com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(TransactionManager.java:858)

com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(TransactionManager.java:753)

com.sybase.djc.transaction.TransactionManager.invokeRequired(TransactionManager.java:1105)

ejb.components.pb10_pkg.n_ora_cjwRemote_DJC.of_jaggetpeeraddress(n_ora_cjwRemote_DJC.java:902)

ejb.components.pb10_pkg.n_ora_cjwRemote_DJC.$invoke_0(n_ora_cjwRemote_DJC.java:244)

ejb.components.pb10_pkg.n_ora_cjwRemote_DJC.$invoke(n_ora_cjwRemote_DJC.java:156)

com.sybase.jaguar.server.JaguarServer.iiopHandler(JaguarServer.java:265)

com.sybase.jaguar.server.RequestHandler.processRequest(RequestHandler.java:9)

com.sybase.djc.rmi.iiop.server.MessageHandler.processRequest(MessageHandler.java:611)

com.sybase.djc.rmi.iiop.server.MessageHandler.run(MessageHandler.java:315)



RESOLUTION: Not a bug. Just needed the patch from cr464620. The patch is XXXGAWin32_patch_464620.zip. Where XXX is the EAS version.



CR:482844
CR Number:   482844
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Vista
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.5.1 23 Dec 2007 Fixed
Description
The border of a dw groupbox is not showing

up in Vista.



The testcase shows 3 groupboxes each with a border of box, lowered and raised.



When run the app at runtime, the border is not showing up for all 3 groupboxes.



CR:482847
CR Number:   482847
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 Jan 2008 Fixed
Description
Edit mask problems in webform applications that do not occur in either winform or PB applications. Details of problems:



Mask hh:mm am/pm

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

Problem: Editmask does accept 12 in the hours field.



Problem: "p" is entered as upper case in the field of lower case characters, showing "Pm".



Tab to field.

Shift-tab back to entered field.

Problem: Data is erased.



Fill in all fields to 11:30 am (or any value where hh < 12)

Click the Force PostBack button in DW_2

Problem: All DateTime fields return from the server as 00:00





Mask hh:mm

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

Click into the time field.

Problem: The cursor positions at the *end* of the mask instead of the beginning.



Move cursor to the beginning of the field.

Type "12"

Problem: Editmask does accept 12 in the hours field.



Move cursor to the beginning of the field.

Type "14"

Problem: Editmask does accept 14 in the hours field.



Tab to next field.

Shift-tab back to entered field.

Problem: Data is erased.



Fill in all fields to 11:30 (or any value where hh < 12)

Click the Force PostBack button

Problem: All DateTime fields return from the server as 00:00



String fields/Mask XX:XX

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



Problem: String field accepts only numerics where the numeric value before the colon is less than 12



CR:482932
CR Number:   482932
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
When entering a RighToleft column, PB selects the default keyboard (Hebrew on a hebrew machine, Arabic on ...). This was fixed in CR472051.

When leaving this column to move to a Non-RTL column, PB keeps the RTL keyboard.

On Israel Distributor demand, we want PB to select the last Non-RTL keyboard selected by the user.



CR:482944
CR Number:   482944
Product Name:   PB Enterprise
Product Component:   DataBase
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jan 2008 Not a Bug
Description
When creating a user defined transaction object, it is not behaving the same as using the default sqlca.



For example, running an embedded sql statement will return a resultset under sqlca

but not under a user defined transaction object.



Another example, when running an embedded sql statement and if the table does

not exist, the user defined transobject object does not generate a error message.

The default sqlca will return the following error:

SQLCA Eror

Error Text = SQLSTATE = S0002

[Sybase][ODBC Driver][Adaptive Server Anywhere] Table 'xxx' not found



PB Trace using SQLCA:

(2840008): LOGIN:(DBI_LOGIN) (6439.668 MS / 6439.668 MS)

(2840008): CONNECT TO tra ODBC:

(2840008): SERVER=EASDemoDB10

(2840008): DBPARM=ConnectString='DSN=EAS Demo DB V10;UID=dba;PWD=sql'(DBI_CONNECT) (199.273 MS / 6638.941 MS)

(2840008): (DBI_ADJUST_CONNECT) (0.001 MS / 6638.942 MS)

(2840008): (DBI_CURRENT_OF_CURSOR) (44.602 MS / 6683.544 MS)

(2840008): PREPARE:(DBI_PARSE_ONLY) (0.001 MS / 6683.545 MS)

(2840008): (DBI_SPECIAL_CURSOR) (0.001 MS / 6683.546 MS)

(2840008): (DBI_SKIP_VERIFY) (0.001 MS / 6683.547 MS)

(2840008): (DBI_DESCRIBE_BEFORE_EXEC) (0.001 MS / 6683.548 MS)

(2840008): (DBI_SUPPORT_INPUT_PARM_BIND) (55.460 MS / 6739.008 MS)

(2840008): BEGIN TRANSACTION:(DBI_START_TRAN) (188.716 MS / 6927.724 MS)

(2840008): EXECUTE:

(2840008): SELECT ID FROM JUNK (DBI_RUNTIME_EXECUTE) (277.514 MS / 7205.238 MS)

(2840008): *** ERROR -141 ***(rc -1) : SQLSTATE = S0002

[Sybase][ODBC Driver][Adaptive Server Anywhere]Table 'JUNK' not found

(2840008): COMMIT:(DBI_COMMIT) (172.661 MS / 7377.899 MS)

(2840008): DISCONNECT:(DBI_DISCONNECT) (477.410 MS / 7855.309 MS)

(2840008): SHUTDOWN DATABASE INTERFACE:(DBI_SHUTDOWN_INTERFACE) (0.002 MS / 7855.311 MS)



PB Trace using user defined transaction object:

(2840008): LOGIN:(DBI_LOGIN) (5524.225 MS / 5524.225 MS)

(2840008): CONNECT TO tra ODBC:

(2840008): SERVER=EASDemoDB10

(2840008): DBPARM=ConnectString='DSN=EAS Demo DB V10;UID=dba;PWD=sql'(DBI_CONNECT) (184.599 MS / 5708.824 MS)

(2840008): (DBI_ADJUST_CONNECT) (0.001 MS / 5708.825 MS)

(2840008): (DBI_CURRENT_OF_CURSOR) (61.311 MS / 5770.136 MS)

(2840008): PREPARE:(DBI_PARSE_ONLY) (0.001 MS / 5770.137 MS)

(2840008): (DBI_SPECIAL_CURSOR) (0.001 MS / 5770.138 MS)

(2840008): (DBI_SKIP_VERIFY) (0.001 MS / 5770.139 MS)

(2840008): (DBI_DESCRIBE_BEFORE_EXEC) (0.001 MS / 5770.140 MS)

(2840008): (DBI_SUPPORT_INPUT_PARM_BIND) (50.295 MS / 5820.435 MS)

(2840008): BEGIN TRANSACTION:(DBI_START_TRAN) (193.912 MS / 6014.347 MS)

(2840008): COMMIT:(DBI_COMMIT) (101.602 MS / 6115.949 MS)

(2840008): DISCONNECT:(DBI_DISCONNECT) (488.522 MS / 6604.471 MS)

(2840008): SHUTDOWN DATABASE INTERFACE:(DBI_SHUTDOWN_INTERFACE) (0.003 MS / 6604.474 MS)



RESOLUTION: Instead of using:

SELECT id INTO :ls_ID FROM JUNK;

it should be

SELECT id INTO :ls_ID FROM JUNK using MYSQLCA;



CR:482955
CR Number:   482955
Product Name:   PB Enterprise
Product Component:   PB.NET WinForm
Status:   Closed
OS:   Windows XP
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Nov 2007 Fixed
Description
When compiling a winform/webform app, the following error

occurs:



Error when compiling generated C# code:

ds_base.sharedata(ICdatawindow.)(3,44): error CS0115: 'c__ds_base.ShareData(Sybase.PowerBuilder.Win.PBDataWindow)': no suitable method found to override





Problem happens when a datastore is calling the sharedata function on system class. The following code in the sharedata function:

RETURN super::ShareData(d)



Problem also happens if using:

return sharedata(d)



CR:483047
CR Number:   483047
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Aug 2011 Insufficient priority to fix
Description
The RowFocusChanging and RowFocusChanged vents do not get triggered when the RowsCopy function has been called.



work-around:

After calling RowsCopy setrow to the row that had the focus and call setrow again to row 1.

In the event scripts ignore the events caused by the first setrow call.



CR:483089
CR Number:   483089
Product Name:   PB Enterprise
Product Component:   PB.NET WinForm
Status:   Closed
OS:   Windows XP
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Dec 2007 Not reproducible with latest version of the product available as of Resolution Date
Description
A shortcut key is not triggering a dw control event when

the dw control is within a tab page in a MDI app.



CR:483186
CR Number:   483186
Product Name:   PB Enterprise
Product Component:   DB Painter
Status:   Closed
OS:   Vista
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.2.1 14 Nov 2007 Fixed
Description
Problems with connection to Access via OLE native interface from DB Painter in PB ( Vista 64 bit business, Office 2007 ). Can see database structure, but can't read the content of the tables (rightclick on the table and then [Edit data] and [Grid]



CR:483195
CR Number:   483195
Product Name:   PB Enterprise
Product Component:   PB.NET WinForm
Status:   Closed
OS:   Windows XP
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Apr 2009 Fixed
Description
When running a winform app using pfc, the following

error occurs when calling lw_frame.dynamic event pfc_messagerouter (as_message):



System.StackOverflowException in System.Globalization.CompareInfo.Compare



The code is in the pfc_n_cst_menu/of_sendmessage:

li_rc = lw_frame.dynamic event pfc_messagerouter (as_message)



CR:483211
CR Number:   483211
Product Name:   PB Enterprise
Product Component:   UO - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   10.5 RC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jan 2008 Presently Not Targeted For Any Future Release Of This Product
14 Nov 2007 Fixed
Description
When opening a visual userobject on a tab page using

opentab(), the userobject defaults to visible=false.



Using the following code:

li_rtn = tab_criteria.closetab(u_to_open)

CHOOSE CASe ls_report_title

Case "a"

ls_to_open = "u_cst_a"

u_to_open = create u_cst_a

Case "b"

ls_to_open = "u_cst_b"

u_to_open = create u_cst_b

Case "c"

ls_to_open = "u_cst_c"

u_to_open = create u_cst_c

End CHOOSE



li_rtn = tab_criteria.opentab(u_to_open,ls_to_open,1)

//u_to_open.visible=true

li_rtn = tab_criteria.SelectTab(1)





The code is in the ddlb/selectionchanged event. If you use, visible=true than

the app works ok.



CR:483212
CR Number:   483212
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Oct 2007 Workaround
Description
IE OLE control on a window throws an error or crashes when Java VM is initialized from PB application and MSJVM is not installed.



Support for MS JVM ends on 12/31/2007



http://www.microsoft.com/mscorp/java/default.mspx
Workaround Description
 a) using MSJVM for IE

Only require installing MSJVM (it should be installed on most PCs). And app can change the register key automatically. No need to change option manually.



b) Or directly call java class

Calling a Java Class from PowerBuilder 10 http://www.sybase.com/detail?id=1037085



c) Or disable applet for IE.



CR:483214
CR Number:   483214
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Open
OS:   Vista
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
OS: Windows Vista Ultimate

Versions and Build #s Tested: PB 10.5.2_7016

Database/Driver File/Version: N/A

Network: Novell Vista 1.0



Comments: When using setProfileString over a network directory through Novell Vista 1.0, it returns -1 in Windows Vista. Works fine in Windows XP.



CR:483267
CR Number:   483267
Product Name:   PB Enterprise
Product Component:   Rich Text
Status:   Open
OS:   Windows XP
Original Version:   10.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Remove environment variable RTE_REPLACE_NULL_WT_SPACE for RTE, related to CR 478544.



CR:483283
CR Number:   483283
Product Name:   PocketBuilder
Product Component:   Window - Runtime
Status:   Open
OS:   Windows XP
Original Version:   2.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer lacks the ability to use OpenUserObject() on a tab control

Using the workarounds to use OpenTab() with different uo tabpages with different szenarios or using show/hide is too expensive.



CR:483385
CR Number:   483385
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Windows XP
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.5.1 17 Dec 2007 Fixed
Description
So as to get proper database charset handling for some customer's

enviornment, Customer has to use DBParm NLS_Charset="Local". However, it is discovered

that the return of string array will get problem when the string array is passed as

reference argument to RPCFunc call to oracle side.

The returned string array seems get alignment problem, some get data but some get empty or junk data.



CR:483426
CR Number:   483426
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Windows XP
Original Version:   10.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.5 27 Feb 2008 Fixed
Description
Customer's production server is crashing. Cause is unknown.



CR:483434
CR Number:   483434
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   10.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.5 24 Dec 2007 Fixed
Description
Customer has a Picture Button that he disables changes the tooltip. He has noticed some inconsistencies when the button is disabled and when it is not in the display of the new tooltip.



If the picture button is never disabled, the changed tooltip displays correctly. If he disables the picture button, then enables it and then changes the tooltip, the new tooltip is not displayed.



If the picture button is disabled he must first change the tooltip and then enable the picture button to see the correct tooltip. He feels that this is inconsistent behavior and should be changed.



CR:483489
CR Number:   483489
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Open
OS:   Windows XP
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Workaround
Description
In response or popup window, set transparency=0, and set closeanimation=XXXXslide(such as bottomslide!, leftslide!, rightslide!, topslide!). When close the response and popup window, closeanimation works incorrectly, its behavior like use XXXXroll (such as bottomroll!, leftroll!, rightroll!, toproll!) for closeanimation.



But if you set transparency>0 for response and popup window, the result will be correct.



WORKAROUND

The classic workaround for animation bugs is to set the transparency to 1% (IOW - essentially opaque).

This forces the code to use the GDI+ window layers and usually fixes up any issues.
Workaround Description
 The classic workaround for animation bugs is to set the transparency to 1% (IOW - essentially opaque).

This forces the code to use the GDI+ window layers and usually fixes up any issues.



CR:483619
CR Number:   483619
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Open
OS:   Windows XP
Original Version:   10.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When using MSSA (Active Accessibility Object Inspector) with PB DataWindow and the DW has a 'Border' or 'TitleBar' set to on, then the yellow highlight rectangle is displaced.



CR:483654
CR Number:   483654
Product Name:   PB Enterprise
Product Component:   PB.NET Assembly Deployment
Status:   Closed
OS:   Windows XP
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Nov 2007 Fixed
Description
Creating a MSI file in a .NET Assembly Target fails when using directories and/or file names with spaces.



When you deploy a .NET Assembly target from a location where the directory name and/or the file name have spaces in it the deployment fails. The mymkmsi.bat file that is created needs to be edited to put quotes around the entire path to the bin directory.



For example the following in the file needs to be edited:



FROM:



xcopy /H /Y "%PBNET_HOME%\bin\nvoassembly.wxs"

"%PBNET_HOME%\bin\tallow.exe" -d C:\pbapps\pb11\dot net\pb2csdotnettempout\bin -nologo -dac -dav > productlist.wxs



TO:



xcopy /H /Y "%PBNET_HOME%\bin\nvoassembly.wxs"

"%PBNET_HOME%\bin\tallow.exe" -d "C:\pbapps\pb11\dot net\pb2csdotnettempout\bin" -nologo -dac -dav > productlist.wxs



CR:483716
CR Number:   483716
Product Name:   PB Enterprise
Product Component:   Rich Text
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Dec 2007 Fixed
Description
RTE Printex removed the format of decimal field



CR:483764
CR Number:   483764
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.2.1 15 Apr 2008 Fixed
Description
Customer is using PB Native and whenever two or more users are connected and alternately adding objects to the project the .pbg file becomes out of sync and has to be manually edited. While this is described in the User's Guide as a possible problem the fact that it happens most of the time appears to be a bug.



The customer receives the following:

---------- Source Control

Adding selected items to source control...

PB Native Status: Adding C:\testsc\PB105\d_emp.srd...

PB Native Status: Checking out C:\testsc\PB105\menuicon.pbg...

PB Native Status: Adding C:\testsc\PB105\menuicon.pbg...

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

Error checking in .PBG file. Verify that new entries are correct and check

in .PBG file manually.

C:\testsc\PB105\d_emp.srd version 1 successfully added to source control

Operation Completed

---------- Done Source Control

The entries can be added to the .PBG files and then the other users can see them.



See workaround tab for a discussion of a new performance optimization and a library entry:

[library]

sccpbgrefresh=nn
Workaround Description
 In PB.INI file you can change the PBG refresh rate by setting:

[library]

sccpbgrefresh=nn

The default is 10 minutes. This allows a user to issue a target-wide "Refresh Status" followed by a target-wide "Add to Source Control" and not have to issue SCC_Get() requests for every PBL in the target library list twice. The down side to this optimization is that another user can update the PBG file during this brief time. Unlikely, but certainly possible.



Setting sccpbgrefresh=1 effectively disables this performance optimization and forces a Scc_Get() request for each target-wide "Add To Source Control".



Another workaround is not to use target-wide "Add To Source Control" but simply highlight a new object and choose "Add To Source Control".



CR:483835
CR Number:   483835
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.5.1 21 Nov 2007 Fixed
Description
Problem with Oracle datatype TIMESTAMP WITH LOCAL TIME ZONE



CR:483971
CR Number:   483971
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Open
OS:   Windows XP
Original Version:   10.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When using the EAServer Component Wizard to deploy EAServer components if the pbl does not include an application object an error occurs. The following error message appears in the lower left hand corner : "Class must be of type nonvisualobject! Class n_jaguar_server is type corbaobject.



CR:484050
CR Number:   484050
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)
06 Mar 2008 Fixed
Description
While running PB and EAS 5.3 with EBF14147, customer

is experiencing an PB Internal Exception error.



CR:484057
CR Number:   484057
Product Name:   PB Enterprise
Product Component:   PB.NET WS Deployment
Status:   Open
OS:   Windows XP
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The Runtime Packager has an option under PowerBuilder Base Components (left hand side) to select PowerBuilder .NET Components for building the PowerBuilder Runtime MSI. If you select this option and are deploying to WinFORMs or simply an Assembly, you receive a warning message box that IIS is required in order to run WEBFORMS. This annoys my customers when installing the runtime for non WEBFORM or WEB Services type deployments. It would be a very simple thing to add a couple of different .NET options in lieu of just one, thus allowing the warning to appear for that particular deployment.

My suggestion is to expand the options to:

1. PowerBuilder WIN32 Standard Componets

2. PowerBuilder .NET for WEBFORMS

3. PowerBuilder .NET for WEB Services

4. PowerBuilder .NET for WinFORMS

5. PowerBuilder .net for Assemblies

In this way only items 2 and 3 would give the IIS installation warning message if in fact this is really necessary and the rest would not.

It is the small things like this which are very easily solved, that makes PowerBuilder look un-professional.



CR:484070
CR Number:   484070
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)
29 Nov 2007 Workaround
Description
When using HALT {CLOSE} in an application, it is failing.

The following is from the dump file:

FAULTING_IP:

CNL_MSWord+1388a

060c388a 8b0a mov ecx,[edx]



EXCEPTION_RECORD: ffffffff -- (.exr ffffffffffffffff)

ExceptionAddress: 060c388a (CNL_MSWord+0x0001388a)

ExceptionCode: c0000005 (Access violation)

ExceptionFlags: 00000000

NumberParameters: 2

Parameter[0]: 00000000

Parameter[1]: 00000000

Attempt to read from address 00000000



DEFAULT_BUCKET_ID: APPLICATION_FAULT



0012d7b0 060c4476 001ef798 0012d7f8 060b228c CNL_MSWord+0x1388a

0012d884 660ca914 001ef798 00000001 001ef798 CNL_MSWord+0x14476

0012d8e0 660c9e30 00000001 00000000 00000001 MSVBVM60!ErrLinkPoke+0x2e

017e0ef0 114f2f3f 017e4520 00000000 017e4550 MSVBVM60!_ScrollSetPageSize+0x4a

017e44f0 00000000 00000000 00000000 00000000 PBVM105!PBROI_Set_Property_Item+0x23f



RESOLUTION: Customer found a workaround and does not want to pursue.



CR:484152
CR Number:   484152
Product Name:   PB Enterprise
Product Component:   SYSAM
Status:   Open
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhance SYSAM message of

License does not validate



To further indicate where the underlying problem may be. The 'License does not

validate' is too generic. The message should further clarify what the problem is.



CR:484253
CR Number:   484253
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
When many PDF files had been displayed with the Adobe PDF Reader OLE control 7.09 or 8.0 or higher, a PowerBuilder executable can crash when closing the ole window or the application.



CR:484283
CR Number:   484283
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Solaris 2.8
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Apr 2008 Fixed
19 Feb 2008 Not a Bug
Description
OS: Sun Solaris 10

Versions and Build #s Tested:

Server side: EAServer 5.3 for Sun Solaris using HTMLGenerator105

Client side: PB 10.5_5063 and 10.5.1_6662

Database/Driver File/Version: PB JDBC Interface with Oracle JDBC thin driver



Comments: After pressing Insert button many times in web datawindow in Internet Explorer, EAServer returns an HTTP 500 and HTMLGenerator105 cannot instantiate web dw container anymore.



CR:484355
CR Number:   484355
Product Name:   PB Enterprise
Product Component:   DW Synchronization
Status:   Closed
OS:   Windows XP
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jan 2008 Fixed
Description
Input a large dataset into a datawindow, then call getfullState, the function will crash with memory access viloation. If the dataset is small, then it works fine. It does't seem to be pushing into a memory limit problem. Memory usage is only around 800,000 KB when it crashes.



CR:484420
CR Number:   484420
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   Windows XP
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Nov 2009 Fixed
Description
The default value of a DDETimeOut property is not 10 seconds. The correct value is 20 seconds.



CR:484424
CR Number:   484424
Product Name:   PB Enterprise
Product Component:   DDE
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Mar 2008 Fixed
Description
DDETimeOut setting on general tab of an application does not work.
Workaround Description
 The value is available when DDETimeOut is set up in application code.



DDETimeOut = value



CR:484441
CR Number:   484441
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   Vista
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.5.1 14 Nov 2007 Fixed
Description
Retrieve on dynamically created DW against Access 2007 on Vista causes GPF if SELECT contains a string literal.



The crash is due to the creation of a 2GB column in the syntax string.

column=(type=char(2147483598)



CR:484476
CR Number:   484476
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
Enhancement Request: If FireFox is an unsupported browser for PB WebForms, then putting FireFox as the browser on the Project's Run tab because it is the default browser is pretty useless. It would be more useful to always fill in IE, instead of picking the default browser.



CR:484515
CR Number:   484515
Product Name:   PB Enterprise
Product Component:   DDE
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Apr 2008 Fixed
Description
StopHotLink receives error -2 in the DualCore environment.



CR:484534
CR Number:   484534
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Linux
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Nov 2007 Workaround
Description
Provide the PowerBuilder 11.0 HTMLGenerator110 and PBDebugBroker11 components and support files.



CR:484550
CR Number:   484550
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.5.1 26 Nov 2007 Fixed
Description
When calling a stored procedure that has double quotes

around the input parm, returns a 'Cursor Not Open' error.



If you use single quotes, than the SP works ok. Using the following syntax

to call the stored procedure:

DECLARE mysp PROCEDURE FOR testsp

@myinparm = "From PB", // Works ok with single quotes

@myoutparm = :ls_fromsp OUTPUT using SQLCA;

execute mysp;

fetch mysp into :ls_fromsp;





Worked ok in PB 8.0.4 using OLEDB and MSSQL 2000. Migrated to PB 10.5.1 using

OLEDB and MSSQL 2000 and getting error now.
Workaround Description
 Change input parm to single quotes from double quotes.



CR:484672
CR Number:   484672
Product Name:   PB Enterprise
Product Component:   Installation
Status:   Closed
OS:   Windows XP
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Nov 2007 Presently Not Targeted For Any Future Release Of This Product
Description
PB 11. 'Sybase DataWindow PS' does not automatically install. Tested with Windows XP and Windows 2003.



CR:484675
CR Number:   484675
Product Name:   PocketBuilder
Product Component:   DW - Runtime
Status:   Open
OS:   Pocket PC 2003
Original Version:   2.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
dw column's background color is ignored if DispayOnly is enabled: it always turns into gray



CR:484676
CR Number:   484676
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Open
OS:   Windows XP
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Application deployed as Web Form, print to pdf file fails, pdf file is created but empty. Print and SaveAs PDF works fine in Native PB11 or under Window 2003. Is using GPL GS v8.6 and the postscript distiller provided by Sybase.



CR:484680
CR Number:   484680
Product Name:   PB Enterprise
Product Component:   PB.NET Assembly Deployment
Status:   Open
OS:   Windows XP
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Interoperability Enhancement Request to access System.Collection.Generic.* types in .Net classes from PowerBuilder.



CR:484795
CR Number:   484795
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jan 2008 Presently Not Targeted For Any Future Release Of This Product
Description
Customer applied workaround from cr461025 and

now that application is expanded and grown, the webform is getting stack overflow exception.



Workaround provided to customer was to create a new thread with a larger stack size

and use that to call the Assembly.Gettypes() method.



RESOLUTION: Customer added more RAM to the server and that seemed to fix the problem.



CR:484810
CR Number:   484810
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
In a datawindow with a date field and a dropdown calendar editstyle, if you drop down the calendar and then type a tab, nothing happens. The tab is ignored. By comparison, in a dropdown listbox, if you drop it down and then type tab, the drop down closes, the current value remains in the field and focus moves to the next field in the tab order. It would seem then that a dropdown calendar should have similar behavior with reguard to the tab.



CR:484946
CR Number:   484946
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)
15 Apr 2008 Fixed
Description
On certain size of data width, the Autosize Height seems to work but fail in "Print Preview"

and "Print out". The second row of the column data will be overlapped masked by follow up

column or detail band bar and make it disappear.



CR:485077
CR Number:   485077
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Open
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A datawindow displaying dates with years prior to 1800 using an editmask of mm/dd/yy display the year as 94.



CR:485125
CR Number:   485125
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Closed
OS:   Windows XP
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Nov 2007 Fixed
Description
When using PBCommandParm it seems that the variable is shared across sessions. When using PBCommandParm to hand over infos to a WebForm app http://localhost/test_commandparm?pbcommandparm=something and you access the app with http://localhost/test_commandparm/default.htm from another machine you will get the same pbcommandparm back.



CR:485154
CR Number:   485154
Product Name:   PB Enterprise
Product Component:   PB.NET DW
Status:   Closed
OS:   Vista
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Dec 2007 Fixed
Description
PB11 .Net WebService\Webform\Winform:



GetItemDecimal and Dot Notation on a DataStore decimal column can return incorrect data

when a comma is used as decimal separator in the Regional Settings of the Control Panel.



CR:485158
CR Number:   485158
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)
04 Jan 2008 DEFER
Description
When running EAS 5.3 and PB 10.5.1, EAS is crashing

with an access violation under load.



CR:485175
CR Number:   485175
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)
19 Feb 2008 Not a Bug
Description
Customer has an mdi application that opens the sheets in the Client Server version but the sheets do not open in the Webform version.



This looks similar in behavior to CR 477774 fixed in PB 11.1 but only webform and not winform.



CR:485189
CR Number:   485189
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Open
OS:   Windows XP
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When calling a webservice using .NET, it results in an exception - 'Cannot invoke Web Service'.



The webservice is trying to call getquotesnap (string userid, string password,string id,string ws_type, string symbol) returns any



The wsdl file shows the function returning an xml document (System.xml.xmlnode).



If GetQuoteSnap return simple type (such as int or string), the web service works ok. If the function return a complex type, than the error occurs.



CR:485251
CR Number:   485251
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)
11.1 24 Dec 2007 Fixed
Description
A Crash is encountered when rapidly dragging an application over a PowerBuilder 11 MDI sheet having an ocx on it.



The crash occur very quickly when the application is build with the "Windows Classic Style" option activated.

When this option is unselected, the crash is much more rare.



CR:485394
CR Number:   485394
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   10.5 RC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11.0 11 Jan 2008 Fixed
Description
When opening a response window in an MDI frame

and than changing a dw's ddlb, that response window moves behind the MDI frame.



The problem only happens after 2 other windows are opened and is relative to

some java local external function calls being called the n_cst_javavm.



CR:485459
CR Number:   485459
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.2.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.5.1 13 Dec 2007 Fixed
Description
ConnectString parameters stripped when calling SelectBlob



CR:485502
CR Number:   485502
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)
24 Dec 2007 Fixed
Description
The customer has 2 rtf files each with a header. One file was created with the PB RTE and the other with Word. If he does a rte_1.showheadfoot(true) focus goes to the header only in the PB RTE file. The header doesn't get focus in the Word file.



CR:485513
CR Number:   485513
Product Name:   PB Enterprise
Product Component:   DB SQLAnywhere
Status:   Closed
OS:   Windows XP
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Dec 2007 Fixed
Description
A regression in PB 11.1 from PB 10.5. The customer has an inherited datastore (n_ds) with a stored procedure used for update and insert. The n_ds object has script in the dberror event to print out an error message if there is an error. The stored procedure is raising an error. In script they are inserting a new row and doing an update that then calls the update stored procedure. (The sp doesn't actually insert the new row, it only raises an error) In PB 10.5 all is well with the dberror event reporting the correct error and error message. But in PB 11.1, a different error other than the one raised by the sp is reported. It's a "Row changed between retrieval and update" error. The sp does nothing other than raise the error, so a real error shouldn't occur, but appears to be happening.



CR:485555
CR Number:   485555
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Vista
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Feb 2008 Third Party Problem
Description
Underline attribute of DataWindow texts not rendered when printing.



CR:485586
CR Number:   485586
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)
15 Jan 2008 Fixed
Description
Customer has a PB 10.5.1/EAS 5.5 application that was recently migrated from PB 9 that is now crashing for one customer. This customer is the with the most users but it worked fine in PB 9.0.3.



Customer is currently running with PB 10.5.1 build 6684 but has also tried to upgrade to PB 10.5.2 build 7016 and is still crashing.



Although they cannot reproduce it in a small sample they believe the problem occurs in the following function which although it is pure PB is from the EAF 2.0 framework from Cynergy.



CR:485611
CR Number:   485611
Product Name:   PB Enterprise
Product Component:   Menus - Runtime
Status:   Closed
OS:   Vista
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Feb 2008 Not reproducible with latest version of the product available as of Resolution Date
Description
Menus are not displayed (color and size) consistently on Vista and XP. On XP the default menu color is grey. On Vista the same menu is displayed as white and it is somewhat larger as well.





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

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

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

Sybase SQL Anywhere数据库恢复工具ReadASADB功能
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具
  1. 适用于所有的SQL Anywhere版本    包括:5.x,6.x,7.x,8.x,9.x,10.x,11.x,12.x,16.x,17.x
  2. 适用于所有的UltraLite版本
  3. 能够恢复出来表结构和数据
  4. 能够恢复自定义数据类型
  5. 能够恢复存储过程等对象的语法
  6. 能够导出到目标数据库
  7. 能够导出到SQL文件并生成导入脚本
  8. 支持多种字符集,包括:cp850、cp936、gb18030、utf8等
  9. 能够恢复未加密或者简单加密类型的数据
  10. 简单易用
  11. 限制:不支持AES加密的数据文件
请参考:研发成功了从Sybase SQL Anywhere的DB文件上恢复数据的工具
            SQL Anywhere数据库非常规恢复工具ReadASADB使用介绍

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

各种误操作:

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

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

1.因为物理磁盘故障、操作系统、系统软件方面或者掉电等等原因导致的Sybase SQL Anywhere数据库无法打开的情况;
2.误操作,包括truncate table,drop table,不正确的where条件导致的误删除等;
Sybase SQL Anywhere无法打开时,比较常见的错误是:Assertion failed。
如:
1、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Checkpoint log: invalid bitmap page -- transaction rolled back
2、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Page number on page does not match page requested -- transaction rolled back
3、Internal database error *** ERROR *** Assertion failed:200502 (9.0.2.2451) Checksum failure on page 23 -- transaction rolled back
4、File is shorter than expected
5、Internal database error *** ERROR *** Assertion failed: 201116 Invalid free list index page found while processing checkpoint log -- transaction rolled back
6、*** ERROR *** Assertion failed: 51901 Page for requested record not a table page or record not present on page
7、*** ERROR *** Assertion failed: 201417 (7.0.4.3541) Invalid count or free space offset detected on a table page
8、Internal database error *** ERROR *** Assertion failed: 201425 (8.0.3.5594) Invalid count or free space offset detected on a free list page -- transaction rolled back.
9、Internal database error *** ERROR *** Assertion failed: 100702 (8.0.1.2600) Unable to modify indexes for a row referenced in rollback log -- transaction rolled back


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

Sybase ASE数据库恢复工具READSYBDEVICE:

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

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

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

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

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


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

SQL Server数据库恢复工具SQLRescue:

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

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

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

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

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

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

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