远程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:210662
CR Number:   210662
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Apr 2000 Fixed
Description
Observed behavior in all versions of PB 7.0 tested ( 5031, 6012, 7021 and 7022) Edit mask of mm/dd/yyyy or mm/dd/yy, when you highlight a date, hit the backspace key or the delete key it zeros out the date to 00/00/0000 or 00/00/00. When you then hit the Tab key when you have previously hit the delete key the value stays as 00/00/0000 and gets updated to the database as Null but when you previously hit the Backspase key and you tab out the previous value is restored and also remains in the database.

In PB 6.5 and 6.5.1 the value would remain all zeroes after tabbing out regardless of whether the delete or backspace key had been used to clear the column.

UPDATE: 01/14/2000
This also occurs with all EditMasks regardless of type.



CR:210668
CR Number:   210668
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
Connected thru ASE 11.9.2 thru the jds driver will
produce the following error:

Internal Error : No ResultSet. the command did not produce any ResultSet.

Problem happens when using Stored Procedure as a datasource for a datawindow and
returns a value.

Works ok with syc.

Running the app the first time also produce the following error:
Stored Procedure 'getTCWUsersPHtml' may be run only in unchained transaction
mode. The 'SET CHAINED OFF' command will cause the current session to use
unchained transaction mode.
Used the following command to turn off error:
Set Chained Off

Or use
sp_procxmode "getTCWUsersPHtml", "anymode"
Workaround Description
 Development feels that the problem has to do
with using a return in a stored procedure.
Stored procedure getTCWUsersSPHtml gives and error
while getTCWUsersSPHtmlworks works.



CR:210699
CR Number:   210699
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 May 2000 Fixed
Description
Under certain conditions, a datawindow button that brings up a modal dialog, response window or messagebox - through a script in the buttonclicked event - will look "depressed" or "clicked" after you dismiss the modal dialog and the mouse is moved back over the button.



CR:210703
CR Number:   210703
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
Deactivate/ Destructor events not fired when refreshing PB service component
Workaround Description
 If possible move the code to the stop method.
WARNING : You will notice that it is not always possible, as the stop() method is called while the run() method is still running this could lead to misbehave.



CR:210707
CR Number:   210707
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
The original column value is lost by PowerBuilder when the column's status is altered from DataModified! to NotModified! using function SetItemStatus().
Workaround Description
 Preserve/ store original value in memory before altering item status flag for this scenario.Use SetItem() to place the original value and then SetItemstatus() to alter the status from DataModified! to NotModified! .



CR:210710
CR Number:   210710
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Solaris 2.6
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Getting error when trying to connect to Oracle 8i
using the o84 driver. The o84 driver is looking for libclntsh.so.1.0. Oracle 8i
installs libclntsh.so.8.0.

Workaround: Create a symbolic link called libclntsh.so.1.0 and point it to
libclntsh.so.8.0.
Workaround Description
 Workaround: Create a symbolic link called libclntsh.so.1.0 and point it to
libclntsh.so.8.0.



CR:210722
CR Number:   210722
Product Name:   PB Enterprise
Product Component:   Project Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
Proxy objects show as Windows objects in list Objects view in project painter



CR:210726
CR Number:   210726
Product Name:   PB Enterprise
Product Component:   UO Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2004 EOL'd version. Not to be Fixed.
Description
Enhancement request. Provide an option when printing User Objcet Info to print the info of nested objects.



CR:210731
CR Number:   210731
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 EBF1 11 Jan 2000 Fixed
Description
PB 7.0 Regression: Deleting column from extermal datawindow causes data corruption



CR:210732
CR Number:   210732
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 May 2000 Fixed
Description
After you save data to an "excel5" format using the saveas
powerscript function and you copy and paste data from that saved file into a new
worksheet, excel will crash. Works ok when you copy and paste data to the
same worksheet. Problem only happens when you open a new worksheet and
paste to it.

If data is saved to an "excel" format and than you copy and paste data from that
file into a new worksheet, than no problem.
Workaround Description
 1. Use the excel format instead of excel5 when you use saveas.
2. Cut and paste into an intermediate app like WordPad then cut and paste to the new worksheet .. works OK



CR:210735
CR Number:   210735
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   3.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Internal CORBA system error received retrieving image data through cached connection managed by Jaguar Connection Management.
Workaround Description
 Avoid using a JCM connection when attempting to retrieve blob/image data. Inserts do work through JCM so transaction processing is available. Retrieval will need to be via a direct or non-cached connection.



CR:210782
CR Number:   210782
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Sep 2000 Fixed
Description
DOC Update: Correct usage of accelerator keys on window controls. When the current object is *NOT* a DropDownListBox, ListBox, MultiLineEdit, or SingleLineEdit, the clicked event will be performed on a control if you press the accelerator key for the control (you don't need ALT-<accelerator>.



CR:210786
CR Number:   210786
Product Name:   PB Enterprise
Product Component:   DW Wizards
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.x Catalina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jan 2000 Fixed
Description
Columns don't show in the ddlb in the dw wizard for
category, values and series when creating a graph dw in the dw painter and
you selected "convert to syntax".

If the datasource was left in graphical mode, than columns show in ddlb's in
the dw wizard.

Works ok in PB 6.5.1 (build 1137).
Workaround Description
 If the datasource was left in graphical mode, than columns show in ddlb's in
the dw wizard.



CR:210789
CR Number:   210789
Product Name:   PB Enterprise
Product Component:   DB DB2
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Apr 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Enhancement. PBDIR, ODBC support for old TableCriteria format (pseudo WHERE clause could be used for table list) from the native PB 5.0 PBIBM050.DLL driver (no longer supported). 7.0 now doesn't have the granularity of 5.0 in terms of limiting (or selectively showing) table lists.

The PBDIR driver now uses the Sybase sp_tables procedure which limits us to allowing just wildcards like percent "%".

Users can look at sp_tables and see how it handles the 4 arguments. One argument "@table_name" is only 32 characters and is not used directly for WHERE clause generation as in was 5.0.



CR:210792
CR Number:   210792
Product Name:   PB Enterprise
Product Component:   Structure Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Dec 2000 Fixed
Description
Structure painter displays structure variable names with trailing space padding



CR:210818
CR Number:   210818
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Feb 2000 Fixed
Description
When you have an action of "edit" for a painter function in
the to do list and you either doubleclick on that task or right mouse click and
select "go to link", a warning message appears saying that it could not find
that function.

Could not find the function f_xxxxxx ( ) returns (none)

The painter will open but it doesn't necessary take you to the script of that function.



CR:210842
CR Number:   210842
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Dec 2000 Fixed
Description
App error in window painter if all views are pinned, closed and re-opened.



CR:210855
CR Number:   210855
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
8.0 Beta 2 2030 15 Nov 2000 Fixed
Description
DataWindows with Outer Joins may have incorrect database column associationed with column objects and may rename column objects when modifying the SQL and returing to the DataWindow painter.



CR:210931
CR Number:   210931
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Dec 2000 Fixed
Description
Affects: 7.0 Builds 7021, 7022, 7023
ENTER key does not work with MLE control when control loses focus and regains it by the TAB key. If the mouse is used to lose/gain focus, the key will continue to work.



CR:210948
CR Number:   210948
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
PB client using disconnectserver doesn't appear to
be disconnecting from Jaguar. In the Jaguar Manager under Runtime
Monitoring/Network/iiop, session number doesn't decrement after
disconnect. Connecttoserver does increase the session number. Only
way to decrement the session number is to close out of pb or exit out of
the exe app entirely.

Disconnectserver isn't disconnecting from jaguar. Return code returns success.
Workaround Description
 Close out of pb or runtime exe after doing the disconnectfromserver.
The session number in runtime monitor will decrease or if you reached
the 10 connection limit will be able to connect once one of the processes
is closed down.



CR:210960
CR Number:   210960
Product Name:   PB Enterprise
Product Component:   DB JDBC
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Apr 2001 Fixed
Description
Connect to DB2/UDB fails with pbjds70.dll when running app via running man or if pbnocatalog=yes with error:
[IBM][JDBC Driver] CLI0611E Invalid column name. SQLSTATE=S0022.

Workaround in Dev environment is to use the pbcat tables. In runtime there is no workaround.



CR:210982
CR Number:   210982
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Not a Bug
Description
The Null date in an edit mask control is interpreted as 01/01/2000
This happens regardless of the date separator (dot, slash..)



CR:210983
CR Number:   210983
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Tested with PB 5.0.04 EBF 4
An invalid date (example 01/00/0000) interpreted as 01/01/2000



CR:211010
CR Number:   211010
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jul 2000 Fixed
Description
Regression from PB 6.5.1. DropDownListBox appears to have a limit to the number of characters it can contain. Regardless of number of items the limit seems to be around 992. In PB 6.5.1 3000 characters were saved without any problems.

When saving past this limit an error is encountered and you are unable to save. The error is as follows:

Library: D:\Tempdj\ISSUES\Jordan\jordan.pbl
Object: w_1
ddlb_1 Class Declaration
(0015): Error C0037: Unclosed quoted string
(0015): Error C0031: Syntax error



CR:211047
CR Number:   211047
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
If you have the following Swedish characters in a deployed HTML DW, they are displayed as garbage:

邃 拍

The characters appear as normal in the development environment.



CR:211070
CR Number:   211070
Product Name:   PB Enterprise
Product Component:   DW Synchronization
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Dec 2001 Fixed
Description
Computed field using retrieval argument not working after SetFullState of a crosstab datawindow
Workaround Description
 If possible use the column name in the computed field rather than the retrieval argument name.



CR:211072
CR Number:   211072
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Nov 2000 Duplicate
Description
While in the script painter highlight a section of text menu/edit/replace/ check 'search selection only' pressing replace all , the whole line in which the replaceable characters are will be replaced or with replace nothing happens.



CR:211086
CR Number:   211086
Product Name:   PB Enterprise
Product Component:   DB Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Apr 2000 Fixed
Description
When executing a stored procedure in the db painter
using jds and connected to informix, the following error will result:

(0001:) C0195: Method can only be called once

Stored procedure will execute and give a result set in db painter. Also stored procedure
will work using the following embedded sql:

declare proctest procedure for testjdbc;
execute proctest;
fetch proctest into :ls_string;



CR:211136
CR Number:   211136
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
The Oracle 7.3 native driver to a 7.3 database using the Oracle 8i client software GPFs in PBO7360.DLL when trying to connect with any version of Powerbuilder 6.0 or 6.5. The version shown for OCIW32.DLL is 8.0.5.0.0 (from February 17, 1999) and the DLL list shows 1.0.05. Seems to work fine with 7.0



CR:211175
CR Number:   211175
Product Name:   PB Enterprise
Product Component:   DW Expression
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 09 Mar 2004 Fixed
Description
Memory is not freed before objects are destroyed when copying data between DataWindow controls with dot notation



CR:211182
CR Number:   211182
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
When the script contains words with umlaute, the specified search pattern is not found.

Workaround:
Check the checkbox 'Regular Expression' and the word containing umlaute can be found.



CR:211190
CR Number:   211190
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 May 2000 Fixed
Description
This is a regression of CR 192780



CR:211218
CR Number:   211218
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Aug 2000 Fixed
Description
Documentation. Using the SYC (native Sybase driver), you get errors creating datawindows with simple UNIONs as shown below. This doesn't happen if you turn ModifySyntax OFF (ModifySyntax=0) in the DBPARM. The option is on the Syntax Tab "Optimize Syntax for prepare". We should update the ModifySyntax doc to include both references to Subselects causing this and UNIONS too.

SELECT employee.emp_id,
employee.manager_id,
employee.emp_fname
FROM employee
WHERE employee.emp_id < 120
UNION
SELECT employee.emp_id,
employee.manager_id,
employee.emp_fname
FROM employee
WHERE employee.emp_id > 1120
ORDER BY employee.emp_id



CR:211223
CR Number:   211223
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Solaris 2.6
Original Version:   3.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.2 25 Feb 2004 Fixed
Description
A Jaguar component uses SyntaxFromSQL to create a dw definition, retrieve data, and return it all in a blob to the client application. This is successful when done using a Jaguar server running on NT but not on Solaris. On solaris, data is returned but no the datawindow formatting (column headers, etc.). Also successfull when done directly from the client application to the db.



CR:211239
CR Number:   211239
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0 Beta 3.1 27 Apr 2001 Fixed
Description
The PowerBuilder VM does not handle marshalling correctly for IDL union types, for example
CtsComponents::PropertyValue in Jaguar 3.5.

** This issue must be addressed so that PowerBuilder clients and components will be able
to access the new Message Service component. **



CR:211252
CR Number:   211252
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 8015 27 Mar 2000 Fixed
Description
PowerBuilder does not return an error, but hangs and eventually causes an access violation when executing an Oracle stored procedure with the o84 driver and the user doesn't have execute rights on the procedure. This happens on Dynamic SQL and DECLARE PROCEDURE - an RPC correctly returns an error. Driver o73 also returns an error.
Workaround Description
 use RPC
use o73 driver



CR:211256
CR Number:   211256
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jan 2001 Fixed
Description
PB cannot pass array argument to OCX control when OCX is expecting argument of type VARIANT ARRAY. You will get the error message:
PB App Error R0035
Error calling external object function <function>..............



CR:211266
CR Number:   211266
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 16 Oct 2000 Fixed
Description
6.5 build 444 Regression. Retrieval of a serial type column in 6.5 and up comes back zeros or the wrong number. This doesn't happen with the native PBIN7060.DLL driver.

This is also broken in 7.0 up through 7.0.1 build 6012.


User should change PBODB60.INI to the following:
[INFORMIX_SPECIALDATATYPES]
SpecialDataTypes='MONEY=DBI_TYPEMONEY=100,SERIAL=DBI_TYPEINT=101'



CR:211308
CR Number:   211308
Product Name:   PB Enterprise
Product Component:   DB Other
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jul 2000 Presently Not Targeted For Any Future Release Of This Product
Description
One handle is leaking when connecting/disconnect from a database
- affects PBSYC, PBO84 drivers

WORKAROUND:
1) Declare a global or instance variable as appropriate:
ulong hLib

2) Declare local external functions for the following windows API calls:
Function ulong LoadLibraryA(string dllname) Library "kernel32.dll"
Function boolean FreeLibrary(ulong hLibrary) Library "kernel32.dll"

3) During application open (or object constructor), issue the following:
hLib = LoadLibraryA("PBSYC70.DLL")

4) During application close (or object destructor), issue the following:
boolean bFree
bFree = FreeLibrary(hLib)

Our testing indicates that the memory and handle leak is associated with all of the following DLLs being removed from the process address space when the PBSYC70.DLL reference count goes to 0. This usually happens when a PB app issues a disconnect. As you can see, there's more than just PBSYC70.DLL involved. All of the Sybase Open Client DLLs get loaded and removed together with SYC:

0x15E00000 0x6D000 7.00.0001.7007 3/20/00 5:44 AM D:\pb70_ebf\build\nt\PBSYC70.DLL
0x3BE0000 0x4B000 4/28/99 12:34 PM d:\SQL12B~1\dll\libct.dll
0x3C30000 0xB000 4/28/99 12:34 PM d:\SQL12B~1\dll\libintl.dll
0x10200000 0x55000 4.10.0000.6038 12/21/98 11:26 AM C:\WINNT\System32\MSVCRT40.dll
0x3C40000 0x4B000 4/28/99 12:34 PM d:\SQL12B~1\dll\libcomn.dll
0x3C90000 0x1B000 4/28/99 12:34 PM d:\SQL12B~1\dll\libtcl.dll
0x3CB0000 0xE000 4/28/99 12:34 PM d:\SQL12B~1\dll\libcs.dll
0x77670000 0x15000 4.00.1381.0131 10/15/98 12:04 PM C:\WINNT\System32\MSWSOCK.dll
0x77660000 0xF000 4.00.1381.0037 10/15/98 12:04 PM C:\WINNT\system32\msafd.dll
0x77690000 0x9000 4.00.1381.0037 10/15/98 12:04 PM C:\WINNT\System32\wshtcpip.dll
0x74FF0000 0xD000 4.00.1381.0131 10/15/98 12:04 PM C:\WINNT\System32\rnr20.dll
0x4120000 0x6000 4/28/99 12:34 PM d:\SQL12B~1\dll\nlwnsck.dll
0x4130000 0x6000 4/28/99 12:34 PM d:\SQL12B~1\dll\nlmsnmp.dll
0x4140000 0x6000 4/28/99 12:34 PM d:\SQL12B~1\dll\nlnwlink.dll

Any one of these may be causing the handle leak, and the ONLY dll that PowerBuilder engineering has any control over is PBSYC70. Our analysis of PBSYC70 indicates no problem with our DLL. What this does is keep all of these DLLs in the process address space for the duration of the application, whether the app is connected to the database or not. The extra LoadLibraryA("pbsyc70.dll") prevents the reference count from ever going to zero on a PB disconnect.

With this workaround in place, leak handle will be leaked when the application is closed, but should not leak handles and memory for each database connect/disconnect.
Workaround Description
 Use the LoadLibrary() API call to load the oracle or sybase DLLs in memory. Call UnloadLibrary() at the application close event to ensure that they are removed when the application is shut down.



CR:211311
CR Number:   211311
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Apr 2000 Fixed
Description
In previous version of PowerBuilder the control list displays both visible and invisible controls. In PB 7.0, the control list displays invisible controls only if the show invisible controls painter option is turned on.



CR:211312
CR Number:   211312
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Mar 2000 Not a Bug
Description
Many Datastores use up resources and crash when plenty of memory available.
Per development: Not a bug. Datastores use visual resources too, and they may run out before memory does. Windows gives a generic "Out of memory" for either case. Workaround: In dataobjects used exclusively for datastores make columns invisible if resources are a concern.
Workaround Description
 Workaround: In dataobjects used exclusively for datastores make columns invisible if resources are a concern.



CR:211347
CR Number:   211347
Product Name:   PB Enterprise
Product Component:   Library Painter
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   7.x Catalina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
New Feature Request:
In case you get corrupt pbl's, you cannot open the library anymore and gets a GPF in pbvm70.dll. Ct would like to get a utility that will allow to repair them. Other tools like winzip etc. reporting a problem if they detect corruption.



CR:211445
CR Number:   211445
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2001 Fixed
Description
In PB7 DecimalSeparator,DelimitIdentifier is not working for Informix DB.
See Techdoc document #47934:
" ... in PB 6.5.1 we added some DBparm parameters for the Informix native driver.
-DecimalSeparator
-DelimitIdentifier
-DateTimeAllowed
These enhancements are NOT currently part of the PowerBuilder 7.0 release...."



CR:211449
CR Number:   211449
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jun 2000 Fixed
Description
DW SaveAs in Excel5 format over the network is much slower

workaround: use Excel format



CR:211453
CR Number:   211453
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   HP-UX 10.20
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
When a edit mask is associated with a column such as
a date, ssn or phone number, pb does not skip over the '/' , '-', '.'. You have to
reposition the cursor after the '/' or '-' and continue entering the data.

For example if you enter in a ssn with a edit mask of xxx-xx-xxxx. You can enter
in the first 3 numbers but pb does not skip over the dash. You can't type anything
until you reposition the cursor of the 'xx'.

Problem can also be seen using an edit mask control.



CR:211457
CR Number:   211457
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 Fixed
Description
DB OLE Column does not activate when there is NULL Data.
Verified fixed in 7.0.2 build 9010.



CR:211494
CR Number:   211494
Product Name:   PB Enterprise
Product Component:   Migration
Status:   Closed
OS:   HP-UX 10.20
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Port an application from windows to aix or hp and pb will
crash when trying to open dw painter.

Works ok on Solaris. Works ok if application and dw were created on unix.
Application will run on aix and hp ok. Problem is when opening dw painter.
Workaround Description
 Change the column border. Problem appears to be 3d lower, 3d raised and resize.



CR:211533
CR Number:   211533
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jun 2004 Fixed
Description
Assigning a huge text to a static text control on an external dw and saving the dw as htmltable! with the saveas() function causes a access violation.

workaround: use a computed field instead a static text and assign the text as to the expression of the computed field.
Workaround Description
 use a computed field instead a static text and assign the text as to the expression.



CR:211536
CR Number:   211536
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 Fixed
Description
DW,Editmask control: For a number field choose an EditMask like ###,###
Type 123456. It appears correct as 123,456. Then highlight it and type it again.
The comma will not appear until pressing BACKSPACE. -> Inconsitent behaviour.



CR:211537
CR Number:   211537
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 Fixed
Description
Datastore Retrieve function when connected using SYJ driver leads to memory leak
Workaround Description
 Don't pool the component or use ODBC driver. Note that those workaround decrease performance and should be use carefully.



CR:211542
CR Number:   211542
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
When using Web DW component, PBL is locked preventing datawindow updates (overwriting an existing datawindow with another) when the system is "LIVE". This CR contains a proposed modification that has not yet been implemented in the main code line.

In the PBL PBDWRMT.PBL, normally in the "Code Examples\HTMLDW\ directory in the install, in the object 'n_remote_datawindow' and the user object function SetDWObject(). Change the existing case statement to include a specific one for PBLs.

case "PBL"
string ls_syntax
if ib_trace then of_log("Doing PBL")
ls_syntax = LibraryExport(as_sourceFileName, as_dwObjectName, ExportDataWindow!)
if ls_syntax <> "" then
if this.Create(ls_syntax) = "" then
li_result = 1
end if
end if

case "PBD" // was case "PBL", "PBD"

The old code actually assigned a datawindow dataobject from the PBL. This assignment causes the PBL to be locked in READONLY mode preventing a developer from saving changes to an existing dataobject or overwriting the PBL once the system is "LIVE". This happens to a lesser extent in Client/Server.

The default behavior is to lock the PBL/PBD once a data object is assigned from it to a datawindow control or datastore.



CR:211549
CR Number:   211549
Product Name:   PB Enterprise
Product Component:   Language - Compiler
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Dec 2000 Fixed
Description
Enhancement. Currently, Powerbuilder has WordCap() for datawindow painter expressions only. It would be nice if this was exposed in the Powerscript too.



CR:211551
CR Number:   211551
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.x Catalina 28 Dec 1999 Fixed
Description
New Powerbuilder 7.0 function GetLibraryList() documentation missing from on-line help and Powerscript reference books. Should be something like:

applicationname.GetLibrarylist()

Return Value:
String. In development, GetLibraryList() returns a comma separated current library file list that includes the full path nmes to the PBLs. At runtime, the list includes the executable name and full path as the first item with the PBD files, if any, in a comma separated list.



CR:211553
CR Number:   211553
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.2 1098 13 Mar 2001 Fixed
Description
6.0 Regression. Large number of rows retrieved or large imports from text files into a datawindow give misleading 'Out of Memory' error BEFORE all virtual memory is exhausted. In 5.0, the datawindow would continue to retrieve and use up all Virtual Memory. In 6.0, sometimes 200MB of Virtual Memory on NT 4.0 is left when Powerbuilder shuts down with an 'Out of Memory' error.

This problem has been fixed in builds after Dec/20/1999 in PBVM60/70.DLL. The fix for CR203026 also solved this 'Out of Memory' problem.

Fixed in the following builds:
6.5 build 1098

7.0.2 ebf builds > 8011. This was not fixed in 7.0.2 Maintenance build 8003 or 8011.



CR:211569
CR Number:   211569
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Nov 2005 Workaround
Description
CreateFrom() with an ADO resultset (not created with GenerateResultSet()), returns -5 using MS ODBC driver for Oracle driver, or crashes PB with ASA



RESOLUTION: Use the following workaround:

datastore ds_local

OLEObject Con, Cmd, Rec

ADOresultset lrs_ADOresultset



Eec = CREATE OLEObject

Con = CREATE OLEObject





lrs_ADOresultset = CREATE ADOResultSet

Con.ConnectToNewObject("ADODB.Connection")

Con.Open ("DSN=EAS Demo DB V9;UID=dba;PWD=sql")

Cmd.ActiveConnection = Con

Rec.ConnectToNewObject("ADODB.Recordset")

Rec.Open("SELECT id, fname,lname FROM customer", Con, 3) -> number 3 is adOpenStatic



lrs_ADOresultset.SetRecordSet(Rec)

ds_local.CreateFrom(lrs_ADOResultset)



CR:211588
CR Number:   211588
Product Name:   PB Enterprise
Product Component:   UO - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
After a page is made invisible on a tab control or a tab userobject the PowerTipText is still visible.



CR:211622
CR Number:   211622
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 8026 16 Jun 2004 Not reproducible with latest version of the product available as of Resolution Date
Description
When creating or opening a descendant object an ancestor object in the painter, there is an execution error R0023 - "Cannot assign object of type cb_1 to variable of type cb_1 at line 3 in create event of object uo_1"
or "Cannot assign object of type cb_1 to variable of type cb_1 at line 3 in create event of object uo_1".

It generally references a simple object in nested in the custom visual user object.

This also can happen running a window containing a user object (custom visual usually) in the development environment.

The problem happens in 6.5 build 1102 and 7.0 Build 7021. It worked in 6.5 build 1094 and 7.0 build 7017.

It is fixed in the builds after March 30th, 2000 in 7.0.



CR:211625
CR Number:   211625
Product Name:   PB Enterprise
Product Component:   Automation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
OLE Automation connecting to Excel 97. Opening a sheet and running a macro that sets a NumberFormat for all selected cells.In Excel, the macro works fine. Calling from PB, the format is set incorrect. In VB works fine.


Workaround:
Excel Macro:
Sub Macro1()
'
' Macro1 Macro
' Example Macro for Woraround demonstration
'
Range("A1:A2").Select
Selection.NumberFormat = _
"_(* #.##0\.00_);_(* (#.##0\.00);_(* """"-""""??_);_(@_)"
ActiveWorkbook.Save
End Sub

Set the NumberFormat property from PB using the syntax below:

//The format is an example for an Excel custom format for the range A1 to A2
ole_obj.Application.Range("A1","A2").NumberFormat= '_(* #,##0\.00_);_(* (#,##0\.00);_(* ""-""??_);_(@_)'

This gives the same effect as the macro.



CR:211703
CR Number:   211703
Product Name:   PB Enterprise
Product Component:   Menus - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
When a menu item is made visible and it has no ToolBarItemName,
then modifying the ToolBarItemName has no effect, it will never appear on the toolbar.

If at design time the ToolBarItemName had a value, then the ToolBarItemName can be
changed at run-time and it will appear on the toolbar.

Putting just one space in the toolbaritemname of the menuitem at design time is sufficient to make it appear dynamically.



CR:211708
CR Number:   211708
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 26 Jul 2000 Fixed
Description
The 'dd' portion of a date editmask on a dw column does not allow '3' to be entered unless whole item is selected..
For example if the current displayed date is 09/15/99 and the cursor is at the 1 in the day and you wanted to chnage the day to 30, you cannot enter a 3.



CR:211714
CR Number:   211714
Product Name:   PB Enterprise
Product Component:   DB Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.x Catalina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2004 EOL'd version. Not to be Fixed.
Description
PB Version and Build: 7.0 GA -> 7.02 Catalina

Cannot specify order in which columns for an index are selected when creating a new index.
The index order is a determining performance factor and performance is why you create an index in the first place. This was easily controlable with PB 6.5
Workaround Description
 Do it manually using ISQL view or dbms tools



CR:211778
CR Number:   211778
Product Name:   PB Enterprise
Product Component:   DB Other
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
If you create a datawindow with retrieval arguments against a database that supports lower case or mixed case and then try to use the datawindow against a database that requries upper case identifiers, you will get an error on the retrieve because the where clause will contain lowercase identifiers.



CR:211805
CR Number:   211805
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.x Catalina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Mar 2004 Fixed
Description
When designing datawindow object that use the function "stored procedure update" to trigger certain stored procedure, options selected during design time are not being saved correctly. Tested in PB 7.0 build 7024
Workaround Description
 export dw object out and manually modify the script and import dw object
customer can't work with this work-around



CR:211806
CR Number:   211806
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
A stored procedure having output variables while connecting with ODBC cannot be accessed by PowerBuilder. Inconsitant behavior connecting to ASE and ASA.

Workaround:
Using a native connection, it works fine. (ASE).



CR:211832
CR Number:   211832
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Apr 2000 Not reproducible with latest version of the product available as of Resolution Date
Description
Edit mask behavior change on integer column edit mask with format #,###,##,0 does not work the same way that it did in build 6012. Created a new external data window (works on any data_window that retrieves an integer)
Created 1 column of type number. Took default for datawindow parameters in the column properties/ format change from default to #,###,##,0
In the column properties/ edit / change style type to edit mask change the mask to be #,###,##,0
In preview, pb puts the zero automatically in the row. If you insert 65, you get a 650 which is expected.
But IF YOU HIGHLIGHT THE ZERO TO CLEAR IT, AND TYPE 65 YOU GET 605.
It acts as if the highlight gets replaced by a zero, not overwritten. This did not behave this way using build 6012



CR:211893
CR Number:   211893
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.2 30 Mar 2000 Fixed
Description
Using dot notation to computed field in a nested report does not return the correct values in most cases. The example is a Page() or Pagecount() computed field in the header or footer of a nested report. By using:

dw.object.dw_nested.object.pageheader[n]

(if pageheader is a computed field of "page()" in the header of a nested datawindow)

you can obtain values but this seems to have never worked correctly. In normal and composite reports, it's possible to use the Describe("Evaluate("page()", <row>)") to get the value of a computed field based on a certain detail row. Using a nested report, each parent detail row has a child handle result set that is of type "dwobject" which is not "Describe'able()". This is why dot notation seems to be the only avenue.

Fixed in 6.5 build 1155 and 7.0.2 build 8014, and 8.0 build 1232

January 24, 2000
With the fix to CR210556, dot notation to a computed field on a nested datawindow in a composite or nested report now works correctly. If 'dw_level_1' is a named child/nested datawindow in a composite or nest and "pageheader" and "pagecountheader" are "named" computed fields, you can get the array of values for each row by:

Composite:
long ll_values[],i,ll_counts[]
// For composite. This works Now for getting an array for each row. You don't need GetChild() and Evaluate()
// anymore
ll_values= dw_1.object.dw_level_1.object.pageheader.primary
ll_counts= dw_1.object.dw_level_1.object.pagecountheader.Primary

Nested: (example shows for FIRST row of nested report - denoted [1] below.
long ll_values[],ll_counts[]
ll_values = dw_1.object.dw_level_1[1].object.pageheader.Primary
ll_counts = dw_1.object.dw_level_1[1].object.pagecountheader.Primary



CR:211932
CR Number:   211932
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jul 2000 Not reproducible with latest version of the product available as of Resolution Date
Description
7.0 Regression. A Global Function used in a datawindow object expression(such as protect attribute of a column) will GPF when that column object is clicked on or the datawindow is repainted causing the global function to fire. Another similar case will GPF when clicking a datawindow button if a computed field that contains a global function is located somewhere on the datawindow (band doesn't matter).

System functions in the datawindow work fine (getrow(), Abs(), Page(), etc), just user-defined global functions are the problem.



CR:211944
CR Number:   211944
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
6.0 Regression. Printer escape codes no longer work in computed fields. In 5.0.04, you could place a computed field with an embedded print escape sequence such as

+"~h1B~h28~h73~h33~h42"+

to set the type of font to BOLD. In 6.0 and 7.0, it doesn't seem like we're passing these codes directly to the printer when they're embedded in computed fields.
NOTE: PrintSend() still works but requires the use of PrintDatawindow() which does not allow the user any control over the print setup dialog.



CR:211980
CR Number:   211980
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Apr 2000 Fixed
Description
A date or datetime editmask will fail with a PB70.exe Application Error of "The instruction at "0x11219615" referenced memory at "0x00000004". The memory could not be read. This occurs when the editchanged event contains an accepttext(). This did not happen in PB 6.5.1.

This was originally reported as an Oracle datetime problem when the editmask was a spin control but it can be reproduced also in Adaptive Server with any date or datetime editmask.



CR:211985
CR Number:   211985
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
When modifying a column's attribute edit.displayonly and there are no rows in datawindow, inserting a
new row will not enable the first column.

The following sequence will not enable the first column to be updated until another column has been
selected:
ll_new_row = dw_1.insertrow(0)
dw_1.deleterow(ll_newrow)
dw_1.modify('code.edit.displayonly=no')
dw_1.insertrow(0)
Workaround Description
 Change the order to:
dw_1.modify('code.edit.displayonly=no')
dw_1.insertrow(0)
dw_1.deleterow(ll_newrow)
dw_1.insertrow(0)

or setting another column in the dw to the current column if you have more than 1 column in the dw.



CR:211998
CR Number:   211998
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Sep 2000 Not a Bug
Description
The format of the name returned from GetObjectAtPointer() has changed when pointing at a column heading in a dynamic crosstab datawindow. In PB 7 build 5031 (7.0 GA), the neme was in the format <column name>_<number>_t. In build 7024 it is in the format <column_name>_t_<number>.



CR:212021
CR Number:   212021
Product Name:   PB Enterprise
Product Component:   DW Plugin
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2004 EOL'd version. Not to be Fixed.
Description
A nested report saved as a psr will result in the
"Load of nested report failed" when viewing in a browser. Happens with
Internet Explorer 5.x, Netscape 4.5, and 4.7.

Viewing the psr report in PB 7.x (report painter) appears to view properly.



CR:212055
CR Number:   212055
Product Name:   PB Enterprise
Product Component:   DW Plugin
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Fixed
Description
Nested reports that are in the trailer band of a datawindow
appear to get swapped when viewing a psr thru a browser or thru the report painter.

When viewing thru dw painter/preview, dw appears ok. Save the dw to a psr and view
it thru the report painter or thru a browser and the nested reports are swapped.

Problem happens with Internet Explorer 4.0,5.0, Netscape 4.5 and 4.7.



CR:212081
CR Number:   212081
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
BlobEdit() GPFs when the data argument is an any variable containing a decimal
Workaround Description
 if Classname(l_any) = "decimal" then
l_dec = l_any
BlobEdit(l_blob, 1, l_dec)
else
BlobEdit(l_blob, 1, l_any)
end if



CR:212116
CR Number:   212116
Product Name:   PB Enterprise
Product Component:   DB DB2
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
PowerBuilder 6.5 and PB7 connecting to DB2/NT 2.1 DB2CLI ODBC Driver

When updating a datawindow with a large number of columns in the where clause,
a crash can occur when using the following parameters in the pbodb60.ini or pbodb70.ini :

PBSupportBindSelect='YES'
PBSupportBindUpdate='YES'
PBSupportDBBind='YES'



CR:212121
CR Number:   212121
Product Name:   PB Enterprise
Product Component:   DB OLE DB
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0 Beta 1 2022 24 Oct 2000
Description
Using the OLEDB driver withthe SQLOLEDB provider produces a script compilation error if you use the 'OUT' argument indicator in the declare procedure statement.



CR:212137
CR Number:   212137
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
Composite DW returns inconsistent results using GetBandatpointer()/Getobjectatpointer(). This seems to be something in the product since these functions were created.



CR:212139
CR Number:   212139
Product Name:   PB Enterprise
Product Component:   Library Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Dec 2000 Not reproducible with latest version of the product available as of Resolution Date
Description
Library Painter GPFs when invoked. Occasionally, the library painter will GPF. Most often this is caused by corrupt settings possibly caused by low resources or some other issues.

Workaround: Go into Regedit, navigate your way through the tree structure into the following key:
HKEY_CURRENT_USER\Software\Sybase\Powerbuilder\7.0\Layout\Default\Library

You will see a set of values such as:
"PBTV{0 _PL_TVBV_{..."

Doubleclick on the right pane for value associated with Library. When the 'Edit String' dialog comes up, null out the information and save it, then exit Regedit. The next time you use the library painter it will come up in default mode.

It's somewhat related to CR203467 (datawindow painter related) in that it appears to be a parsing problem once the string for this key value gets corrupted but there are probably many ways to get a corruption.



CR:212144
CR Number:   212144
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Oct 2000 Not a Bug
Description
When migrating from PB 4 to 5, Singlelineedit (SLE) fields now have a blank leading spaces in the window SLE control which shifts everything over by one. In some cases, a space has been added to the end of the singlelineedit too causing developers to have to resize their controls after migration.

This happens most often when using TRUE TYPE fonts.

Win95/98 has more blank space at beginning and end; Win NT has only a little blank space at beginning and end.

Development: Some of the size changes is due to the way 3d borders changed from 4.0 to 5.0--this is documented. The remaining size of the control is governed by the operating system and the font, not PowerBuilder. This behavior is expected.



CR:212146
CR Number:   212146
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Dec 2000 Not a Bug
Description
Double-clicking on a picture object that is being programatically moved, the doubleclicked (and Clicked) event does not fire.



CR:212221
CR Number:   212221
Product Name:   PB Enterprise
Product Component:   DB Other
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 8020 25 Feb 2004 Fixed
Description
Passthru connections via OMNI fail in PB due to warning message 11217
Workaround Description
 None. User cannot connect.



CR:212239
CR Number:   212239
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.x Catalina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
When certain Chinese characters in which the second byte is a ~, update to htmldw will resulted in Corba error and Jaguar will crashes. The test was done in EAS 3.5
Workaround Description
 Work around is to place another~ after the Chinese character but this is unacceptable becuase user has no way of knowing which Chinese characters has a~ in the second byte



CR:212250
CR Number:   212250
Product Name:   PB Enterprise
Product Component:   Pipeline Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Aug 2000 Fixed
Description
Pipeline incorrectly identifies Timestamp column as Char(31) when column is named TimeStamp and the datasource is ODBC



CR:212294
CR Number:   212294
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 RC2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Mar 2004 Not a Bug
Description
Cannot trigger dw click event on HTMLDW when using Netscape Browser, no problem in IE4 and IE5.

Per Development this is not a PB bug:
Capturing the Click event for a text field in Netscape is impossible. Exhausted all potential workarounds. It seems Netscape is strictly controlling the text field at their level, preventing any kind of interposing--you get a Focus, a Blur, an I-bar cursor, and that's it.

Would suggest customers exploit ItemFocusChanged, RowFocusChanging, RowFocusChanged, etc. instead.



CR:212299
CR Number:   212299
Product Name:   PB Enterprise
Product Component:   File Editor
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Dec 2000 Duplicate
Description
File editor search dialog box does not respond to tab or return keys, but still responds to the mouse.



CR:212332
CR Number:   212332
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 9015 01 Sep 2000 Fixed
Description
6.5 EBF/7.0.2 Regression. Crosstab with expression on field causes a GPF in KERNEL32.DLL after retrieval and while building the crosstab. Appears to be a problem in NT 4.0 only. Win98 SE works fine. Other expressions on crosstab columns also cause a GPF (example: a Textcolor expression or a FORMAT expression on "val" of '##0;[RED](##0)' normal for expressions)

The Microhelp says "Building Crosstab".. This happens after the retrieval is complete and while building the crosstab.


Started in 6.5 and 7.0 ebf builds around 9/13/1999.
Fixed in 6.5 1219 and 7.0.2 9015.



CR:212341
CR Number:   212341
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Dec 2000 Fixed
Description
Window classes in new IDE are very unpredictable. Script Painter view is
sometimes detectable, sometimes not. Caption of Script Painter is usually
incorrect (showing Constructor instead of the script name shown in the
Rollup Caption). Affects a few external modules I have which rely on the
ability to "read" the IDE. (Source Code reader, ToDo List Wizard etc)

Results confirmed with Watcom SPY.


This is not one which will affect everyday PowerBuilder developers, but affects
3rd party tool developers like myself.



CR:212346
CR Number:   212346
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Aug 2000 Not reproducible with latest version of the product available as of Resolution Date
Description
Opening a window on WindowsNT over the network takes twice the time as Windows98



CR:212383
CR Number:   212383
Product Name:   PB Enterprise
Product Component:   DB Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
PB Version and Build: PB 7.0 GA and 7.02 (Catalina)

When in the ISQL view in the database painter, click RMB -> Paste special -> From file... select a directory and file. If you later click Menu -> File -> Save as... the save as dialog does not 'remember' the directory you already selected in the earlier 'Paste from file operation. You must select it again.

However if you click Menu -> File -> Save as... select a directory and file. THEN when you click RMB -> Paste special -> From file... the paste from file dialog DOES remember the directory already selected in the earlier 'Save as operation'

The equivalent operation in PB 6 ( 'Save as' and 'Import from file') is more consistant



CR:212401
CR Number:   212401
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
PowerBuilder 6.5.x should show an error and not give an access violation when selecting tables in the database painter the Database Painter against an Oracle 7 server through o84 driver.
Note: Oracle 7 servers have to be accessed through the o73 driver.



CR:212413
CR Number:   212413
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 8020 25 Feb 2004 Fixed
Description
PBLIB70 - Integrate SCC interface with CONTINUUS to allow duplicate object names in various subprojects.



CR:212452
CR Number:   212452
Product Name:   PB Enterprise
Product Component:   Menus - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Win95/98 only. If Menu item toolbar text matches title name for FindWindowA call, the application does not open correctly. The example is a menu item script trying to open "calc.exe"

Workaround: Since the menu item toolbar text is "calculator" and is the same name as the Title of "calc.exe", you can workaround this by renaming the menu text and include a space like this -> "calculator ".



CR:212456
CR Number:   212456
Product Name:   PB Enterprise
Product Component:   Plug-ins
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Netscape browsers only. Opening a popup type window from the Powerbuilder window plugin causes problems with tabbing through edit fields (SingleLineEdit)'s on the popup window. It seems like the popup window is not using the correct parent window (even if given one). It appears to be using the Netscape browser window as the parent since if you tab from an SLE, it goes to the URL SLE on the Netscape browser. Tabbing from SLE to SLE on a popup window using IE 4.0 or above works fine.



CR:212502
CR Number:   212502
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.x Catalina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
PSE NOTES

OS: Win32
PB Version and Build: 7.0 GA (5039) -> 7.02 build 8009
DB/DLL: PBVM70.DLL
Comments:
Declaring object instance variables can give an unhandled exception in PBVM70.DLL when the following combination occurrs:

Any stored procedure (declared as public) followed by...
At least 2 private instance variables the first of which must be initialised to some value ...

Var1 - Initialised. Reproduced with integer, long, real, boolean (not reproduced with dec, date or string)
Var2 - No need to initialise. Reproduced with date, string or decimal (not reproduced with long or integer).

Gives unhandled exception in PBVM70.DLL, for example with Var1 as an int and Var2 a string using 7.02
Instruction at 0x111e8873 ref'd mem at 0x00000001 mem could not be read

An example of a combination of Instance variable declarations which would crash.

DECLARE iproc_dummy PROCEDURE FOR sp_help;

Private:
long Var1= 1
string Var2
Workaround Description
 Always declare the private variables first and stored procedure last.



CR:212510
CR Number:   212510
Product Name:   PB Enterprise
Product Component:   DW Expression
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Using the describe function on Datawindow.Table.CrosstabData
will show only 1 level of info.

Using the following code:
string s_describe
s_describe = "Datawindow.Table.CrosstabData"
dw_1.describe(s_describe)

According to the documentation crosstabdata should return a string containing
a tab-separated list of the expressions used to calculate the values of columns
in a crosstab Datawindow.
Workaround Description
 s_desc = "DataWindow.Table.CrosstabData"
s_describe = "DataWindow.Data"
mle_labels.Text = dw_1.describe(s_desc) + " " + dw_1.Describe (s_describe)



CR:212511
CR Number:   212511
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
The function SetText() is used to replace text on an edit control with edit style DropDownDW.

For European settings (non-English) e.g. French, Turkish - the problem is that this function strips/ removes space characters when there is a dot char followed by a space char.

DDDW 'Display' values are OK for the following pattern string:-
-dot char(s) with NO space(s) char(s)
-text with space(s) and NO dot char(s)



CR:212558
CR Number:   212558
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 Beta 4 25 Feb 2004 Fixed
Description
SCC API connected to Microsoft Visual SourceSafe (Version 6.0 build 8163) does not save more than 61 characters for comments.



CR:212561
CR Number:   212561
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 Fixed
Description
DOCUMENTATION. DataWindow.table.arguments property not documented (from enhancement 155919) in 7.0 help . This new property brings back a list of datawindow arguments and their datatypes.

It was difficult to parse the datawindow syntax to get a list of retrieval arguments AND TYPES for a datawindow. This often relied on whether the datawindow was in syntax or graphic mode too.

This property can be retrieved independent of how the datawindow is saved (syntax or graphic).



CR:212562
CR Number:   212562
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Changing the background color in the pbm_dwnkey event in a datawindow loses the typed character.



CR:212567
CR Number:   212567
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Mar 2000 Not reproducible with latest version of the product available as of Resolution Date
Description
Typing an escape in a Window EditMask causes application to halt.





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