Sybase数据库技术,数据库恢复

• 首页
• 关于
• 订阅
• 归档
• 留言
• 标签
• 免费ASE测试环境
• 镜像站
• 恢复工具

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.