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

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

CR:350069

CR Number:   350069 Product Name:   PB Enterprise Product Component:   Jaguar Integration Status:   Closed OS:   Microsoft Windows NT Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Aug 2004 Fixed 16 Apr 2004 Duplicate Description Observed a memory leak when connecting/disconnecting to ASA 9 from a PB component running on EAServer.

CR:350072

CR Number:   350072 Product Name:   PB Enterprise Product Component:   DW Graph Status:   Closed OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Apr 2004 Fixed 19 Jul 2004 Fixed Description 1) PowerBuilder GPFs when calling GetDataValue against a series that has value of type date. The GPF happens not when calling GetDataValue, but later when you return from the routine that made the call. 2) PowerBuilder does not provide a way to determine the type of the values in a graph datawindow (the grAxis.DataType property does not exist for DataWindow graphs, but it does for the graph object). 3) When calling GetDataValue against a series that has value of type date, it succeeds for Date, DateTime and Time overloads. However, the column is specifically a date type, so the DateTime and Time overloads should fail. Especially considering there is no way to determine dynamically the data type of the series values (number 2 above). 4) When calling GetDataValue against a series that has value of type date, the overload for Double succeeds and returns a value of 1. GetData also returns a 1. These are definitely bugs as the value is a date.

CR:350078

CR Number:   350078 Product Name:   PB Enterprise Product Component:   DW Graph Status:   Closed OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11.0 29 Oct 2006 Fixed Description You can't create a graph that has a value axis that is a string. Actually you can create it, but it does not work. There an also an override of GetDataValue with a string, which implies this should work. If it is not possible to create a graph with a value axis of type string, then don't allow it in the painter, and there is no need for an override of GetDataValue with a string.

CR:350147

CR Number:   350147 Product Name:   PB Enterprise Product Component:   DW Painter Status:   Open OS:   Microsoft Windows NT Original Version:   8.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Background colours not displaying properly in composite DataWindows

CR:350180

CR Number:   350180 Product Name:   PB Enterprise Product Component:   Documentation Status:   Closed OS:   Microsoft Windows 2000 Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Aug 2004 Fixed Description ORBCodeSet ConnectionObject option default value value is documented to be iso_1, but is in fact utf8.

CR:350193

CR Number:   350193 Product Name:   PB Enterprise Product Component:   Machine Code Exe Creation Status:   Closed OS:   Microsoft Windows 2000 Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 8.0.4 22 Apr 2004 Fixed Description The multi file select feature of the GetFileOpenName dialog does not work in a machine code exe. You can only select one file. It works fine when running in the IDE and in a pcode exe.

CR:350198

CR Number:   350198 Product Name:   PB Enterprise Product Component:   DW Expression Status:   Closed OS:   MS Windows NT 4.0 Original Version:   8.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jun 2005 Presently Not Targeted For Any Future Release Of This Product Description In PowerBuilder 8 the datawindow property "suppress repeated value" does not work correctly when the relevant column contains empty strings or NULL values in between. The next column may be suppressed incorrectly. Review Status  [*** Tuesday, June 21, 2005 14:33:58 ***] This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release".

CR:350219

CR Number:   350219 Product Name:   PB Enterprise Product Component:   PB GUI Status:   Closed OS:   Microsoft Windows NT Original Version:   10.0 beta1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 8.0.4 21 Mar 2005 Fixed 07 Apr 2005 DEFER Description Painters are leaking handles leading to crashes if you open and close a painter over and over again.

CR:350229

CR Number:   350229 Product Name:   PB Enterprise Product Component:   DB Oracle Status:   Open OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In a local script painter you can use the Declare a Procedure context menu to declare a procedure. But if you then try to use the Fetch From Procedure context menu in that same script, you will get the "There are no instance, shared, or global procedures declared". Why isn't the locally declare procedure enough?

CR:350232

CR Number:   350232 Product Name:   PB Enterprise Product Component:   Migration Status:   Closed OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Mar 2004 Duplicate Description According to the online help, FromAnsi and ToAnsi will become obsolete in a future version of PowerBuilder. When you migrate an application using these two functions in PB 10 or use the Migration Assistant Tool in PowerBuilder, there's no warnings messages that these functions will become obsolete.

CR:350360

CR Number:   350360 Product Name:   PB Enterprise Product Component:   DW Graph Status:   Closed OS:   Microsoft Windows NT Original Version:   10.0 beta1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 May 2005 Fixed Description Setting the Shade color for a wedge in a pie graph (using SetDataStyle) incorrectly resets the color that appears in the legend.

CR:350364

CR Number:   350364 Product Name:   PB Enterprise Product Component:   PB GUI Status:   Closed OS:   Microsoft Windows NT Original Version:   10.0 beta1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2004 Fixed Description The Clean Up Workspaces dialog has a missing word. "The following keys were found to have no associated"

CR:350394

CR Number:   350394 Product Name:   PB Enterprise Product Component:   DW - Runtime Status:   Closed OS:   Microsoft Windows NT Original Version:   10.0 beta1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10.0 05 Apr 2004 Fixed Description GetSQLSelect() on DW with SQL in graphical mode returns keywords SELECT, FROM, WHERE, etc. in lowercase. In previous versions, they where uppercase. This change breaks the dynamic select modification logics.

CR:350402

CR Number:   350402 Product Name:   PB Enterprise Product Component:   PD Integration Status:   Open OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Would it be at all possible to get the PD browser and the PB system tree combined through the plugin? Same request with the PB output pane and the PD output and/or result list pane.

CR:350414

CR Number:   350414 Product Name:   PB Enterprise Product Component:   Language - Compiler Status:   Closed OS:   Microsoft Windows NT Original Version:   10.0 beta1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Mar 2004 Duplicate Description I'm not sure if this should happen before the functions are obsolete. I couldn't find any functions through online help to test that were not already obsolete, whereas for FromUnicode the help says it will be obsolete in the future. ToUnicode it does not say anything about being obsolete.

CR:350420

CR Number:   350420 Product Name:   PB Enterprise Product Component:   DW - Runtime Status:   Closed OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jun 2004 Fixed Description When a field on a datawindow with a radio button edit style does not have a value, the focus rectangle goes to the last item in the button group, it should go to the first item to allow for easier navigation via the keyboard.

CR:350454

CR Number:   350454 Product Name:   PB Enterprise Product Component:   DW - Runtime Status:   Closed OS:   MS Windows NT 4.0 Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Aug 2005 Duplicate Description Getting "row changed between retrieve and update" error when updating DW

CR:350463

CR Number:   350463 Product Name:   PB Enterprise Product Component:   Jaguar Integration Status:   Closed OS:   Microsoft Windows 2000 Original Version:   8.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Aug 2004 Not reproducible with latest version of the product available as of Resolution Date Description Corba Exception in Jaguar log

CR:350488

CR Number:   350488 Product Name:   PB Enterprise Product Component:   DW - Runtime Status:   Closed OS:   Windows XP Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jun 2004 Duplicate Description New Visual Controls build option causes a regression in the DataWindow. When using for example selectrow() on rows/columns that have taborder set to zero, the column becomes unreadable (white text on grey background) and has a blue highlight border around it.

CR:350497

CR Number:   350497 Product Name:   PB Enterprise Product Component:   Printing Status:   Closed OS:   MS Windows NT 4.0 Original Version:   8.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 8.0.4 03 Jun 2004 Fixed Description In Citrix, users can see not only their own printers in the printer setup, but all other users as well.

CR:350514

CR Number:   350514 Product Name:   PB Enterprise Product Component:   DataBase Administrator Status:   Closed OS:   Microsoft Windows 2000 Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jun 2005 Presently Not Targeted For Any Future Release Of This Product Description If you try to update a column of a result set in the database painter where the result set was generated from select * from customer in the isql, the Update and Insert icons on the powerbar menu are greyed out. If you execute select * from dbo.customer, then the Update and Insert are enabled in the powerbar menu. There appears to be an inconsistency because although the Update and Insert icons are greyed out after you execute a select * from customer, if you execute a update statement from isql without referencing the dbo, the update works ok. Review Status  6/14/2005 This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release".

CR:350660

CR Number:   350660 Product Name:   PB Enterprise Product Component:   OLE - Active X - OCX Status:   Closed OS:   Microsoft Windows 2000 Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 9.0.1 19 Nov 2004 Third Party Problem 10 Mar 2005 Fixed Description PB crash saving a window with OCX compiled in VC++.Net (VC7). Works fine in VB6 and VB7 Solution: download the patch from MS to solve the problem as MS had confessed it is a bug in MFC71

CR:350669

CR Number:   350669 Product Name:   PB Enterprise Product Component:   JSP 4GL Status:   Open OS:   Windows XP Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Enhancement request for the Webdw Webdatawindow: The serverside getrow function currently always returns 1 as this function needs to be called at the clientside. The request is to make this information available at the server side so that it can be used for further processing.

CR:350692

CR Number:   350692 Product Name:   PB Enterprise Product Component:   Script Painter Status:   Closed OS:   Microsoft Windows NT Original Version:   8.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Apr 2004 Fixed Description PowerBuilder crashes when hitting the Delete key on the first line of the script after having used the backspace to delete several lines.

CR:350695

CR Number:   350695 Product Name:   PB Enterprise Product Component:   DW.Net Status:   Closed OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Apr 2004 Fixed Description Datawindow EditControl Cut/Paste/Copy operations do not refresh display until you give focus back to the datawindow. With other controls the refresh is immediate.

CR:350698

CR Number:   350698 Product Name:   PB Enterprise Product Component:   Window - Runtime Status:   Closed OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Apr 2004 Third Party Problem Description When calling Cut on a DropDownListBox control on a window, no text is cut and it returns zero. When using Paste in a DDLB, it always pastes at the beginning and not at the insertion point. PB Engineering says this is not a PB problem. The problem resides in the Windows common control "ComboBox", which is used for the PB DDLB. The behavior of the combo box in VB is the same. A workaround is to use the shortcut keys Ctrl+C and Ctrl_P to cut and paste. Workaround Description  A workaround is to use the shortcut keys Ctrl+C and Ctrl_P to cut and paste.

CR:350706

CR Number:   350706 Product Name:   PB Enterprise Product Component:   DW Edit Mask Status:   Closed OS:   Microsoft Windows 2000 Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 9.0.1 13 Dec 2004 Fixed Description A datawindow editmask of: (###) ###-####. You can cut the phone number out of the field, but if you try to paste it back, it won't go, you hear the bell. If type the 'end' key, then the paste works. But it should paste right back in without having to type the 'end' key.

CR:350779

CR Number:   350779 Product Name:   PB Enterprise Product Component:   Machine Code Deployment Status:   Closed OS:   Microsoft Windows 2000 Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Sep 2005 Fixed Description A string parameter is passed to a function in an external DLL. If PB is compiled into machine code script the local data is overwritten in some circumstances. If the same pb code is compiled into p-code everything works as expected. It also works in the IDE. Workaround Description  Use just REF keyword (or leave the keyword ie. by value)

CR:350839

CR Number:   350839 Product Name:   PB Enterprise Product Component:   DW Display Status:   Closed OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Apr 2004 Fixed Description The Scroll method returns one less than the currently visible row of the edit control. [Note: this is the method that scrolls the edit control, not to be confused with the ScrollToRow, etc. methods that scroll the entire datawindow]. You pass to it a number of lines to scroll and it is supposed to return the line number of the line it scrolled to. If you are on line 1 and scroll foward 3 lines that takes you to line 4, but the scroll returns a 3. It is always off by one.

CR:350916

CR Number:   350916 Product Name:   PB Enterprise Product Component:   Window Painter Status:   Closed OS:   Microsoft Windows 2000 Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Oct 2004 Fixed Description Copy a function in the function list from one window to an other window by copy and paste. If you open for instance an Internet Explorer and do copy the URL PB IDE will crash immediately.

CR:350941

CR Number:   350941 Product Name:   PB Enterprise Product Component:   DW - Runtime Status:   Closed OS:   Microsoft Windows 2000 Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 9.0.1 12 Apr 2004 Fixed Description A shared datawindow with a filter and scrolltorow in the rowfocuschanged event is causing a access violation in the pbdwe90.dll. The crash handler reports: Exception code: C0000005 ACCESS_VIOLATION File Name: E:\pb90\Shared\PowerBuilder\PBDWE90.dll File Version: 9.0.1.7136 Fault address=1164CDB1 Section:Offset=01:0014BDB1 Registers: EAX:00000008 EBX:00000000 ECX:0127BB6C EDX:0127BB7C ESI:01274BF8 EDI:0012D7F4 CS:EIP:001B:1164CDB1 SS:ESP:0023:0012D71C EBP:012761B0 DS:0023 ES:0023 FS:0038 GS:0000 Flags:00010212 Call stack: Address Frame Param0 Param1 Param2 Param3 Function Name 1164CDB1 0012D770 00000001 0012D7F4 77F43C16 01274BF8 dwTabSortCmp+1151 1164CA0A 0012D78C 012761B0 0012D7F4 0000000F 00000400 dwTabSortCmp+DAA 1153E612 0012D8A8 01274BF8 1D0108A9 00000000 0000000F dwPaintDC+7A2 11645D45 0000000F 00000000 00000000 00000000 00000000 dwWinProc+365

CR:350959

CR Number:   350959 Product Name:   PB Enterprise Product Component:   Machine Code Exe Creation Status:   Closed OS:   Microsoft Windows 2000 Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Sep 2004 Not a Bug Description Creation of a PBD exe (or machine code) fails when a certain icon is set as the application icon. I suspect that this is a newer icon that is not currently supported by PB. However, I used the icon as a menu tollbar icon and it works. If it works there it should work as an application icon as well (if it is a legitimate icon). This is not a bug. The so called icon was a renamed bitmap. This is not a valid icon file and will fail.

CR:350963

CR Number:   350963 Product Name:   PB Enterprise Product Component:   Documentation Status:   Closed OS:   Microsoft Windows 2000 Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Dec 2004 Fixed Description Ghostscript installation instructions need correction.

CR:350977

CR Number:   350977 Product Name:   PB Enterprise Product Component:   Jaguar Integration Status:   Closed OS:   Microsoft Windows 2000 Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Aug 2004 Fixed Description When a jsp calls a pb component and that component has a print statement, it causes easerver to use up alot of memory. The pb component is first retrieving about 300,000 to a datastore but its when a print statement is issued that easerver appears to choke. Works ok when easerver is taken out of the picture. Problem also happens when a pb client calls the pb component in easerver. Not jsp to pb component specific. From the jaguar.log file it shows: Fatal Error Occurs when try to invoke PB method memtestreport in memorytest/memtest. Mar 30 09:14:06 2004: SPID: 16 Fatal Error Occurs in PB Component, Transaction Rollbacked. Mar 30 09:14:06 2004: SPID: 16 CORBA Runtime Error Occurs when try to invoke PB method memtestreport in memorytest/memtest. Mar 30 09:14:18 2004: SPID: 16 SystemException: INTERNAL (memorytest/memtest/memtestreport - )

CR:350980

CR Number:   350980 Product Name:   PB Enterprise Product Component:   Documentation Status:   Closed OS:   Microsoft Windows 2003 Original Version:   10.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Aug 2004 Fixed Description Documentation should indicate that for end-user applications to create PDFs, administrative privileges are required. Refer to CR 350988 that is an enhancement request for engineering to provide a small utility that will install the Sybase DataWindow PS printer and drivers. PowerBuilder developers that distribute end-user applications can run that utility (as administrator) within the larger context of installing their end-user application so that end-users themselves do not need administrator privileges to run applications that generate PDFs.

CR:350987

CR Number:   350987 Product Name:   PB Enterprise Product Component:   DW Painter Status:   Closed OS:   Microsoft Windows 2000 Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 9.0 18 Jul 2005 Fixed Description In the Datawindow painter when creating a datawindow from a stored procedure, in the Select Stored Procedure window, if you toggle the "System Procedure" checkbox a few times, you will get a error with some garbage info. Then more following errors occur.You need an ASE database with a large list of stored procedures to see the problem.

CR:350995

CR Number:   350995 Product Name:   PB Enterprise Product Component:   Documentation Status:   Closed OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jul 2004 Fixed Description If you RMB on a method in the system tree, a properties dialog is displayed. This is mainly for PBNI users and appears in the PBNI Reference, but a quick mention in the User's Guide would be a nice-to-have, if only to direct people to the PBNI doc.

CR:351002

CR Number:   351002 Product Name:   PB Enterprise Product Component:   DW Display Status:   Closed OS:   Microsoft Windows 2000 Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jul 2004 Fixed Description A regression. A datawindow has a computed field that has the expression: "Bitmap( bitmapname )" where bitmapname a bitmap filename. The computed field has Resize Border selected. The bitmap displays, but the border doesn't appear. This worked in PB 9.0.1 Build 7066, but starts failing to display the border in builds 7096 and after.

CR:351004

CR Number:   351004 Product Name:   PB Enterprise Product Component:   DW - Runtime Status:   Open OS:   Microsoft Windows NT Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When you have a radio button edit style, you cannot cycle through all of the options using the arrow keys. Contrast this to common window behavior where when in a Radio Button group you and use the arrow keys to cycle REPEATEDLY through the options. NOTE: PB9 has the same behavior. This could possibly be revised to be an enhancement request.

CR:351089

CR Number:   351089 Product Name:   PocketBuilder Product Component:   DW - Runtime Status:   Open OS:   Pocket PC 2003 Original Version:   1.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 1.5.2 Description Redraw problems in tabular datawindows if I scroll with the key-pad and I have expressions in the "graphical" properties of the columns (example: Border="If (getrow() = currentrow(), 1, 0)") or simply if I have checked 'Show Focus Rectangle' in edit properties of a column

CR:351093

CR Number:   351093 Product Name:   PB Enterprise Product Component:   Language - Runtime Status:   Closed OS:   MS Windows NT 4.0 Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Nov 2004 Fixed Description Calling functions with readonly object references in a response window gives null object references after closing the response window as the objects have been garbage collected. Work-around is to change the argument type from readonly to value.

CR:351097

CR Number:   351097 Product Name:   PB Enterprise Product Component:   WT - Help Status:   Closed OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jun 2004 Fixed Description In the online help for JSP web target, it list the syntax and example for PSJaguarConnection with the following: PSJaguarConnection(serverName, userId, password, componentName, bOneTrip) The serverName in PB 10 can either be the servername or an EAServer Profile and that information is stored in the jaguar.properties file that gets deployed with the JSP target. The example for PSJaguarConnection shows the following (needs to be updated for PB 10): jagConn = new PSJaguarConnection ("my-desktop:9000", "jagadmin", "", "DataWindow/HTMLGenerator90", false)

CR:351102

CR Number:   351102 Product Name:   PB Enterprise Product Component:   WT - System Tree Status:   Closed OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 May 2004 Not a Bug Description In the system tree, you can open the treeview for any object and open the function or event folder. When right clicking on a function or event, and selecting properties, when the Propeties dialog window opens the function or event signature is highlighted and the cursor is all the way to the right.

CR:351106

CR Number:   351106 Product Name:   PB Enterprise Product Component:   Script Painter Status:   Closed OS:   Microsoft Windows NT Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2005 Not a Bug 28 Mar 2005 Fixed Description If you have tab characters within your script and then from menu File --> Print Script , print the script , the print out is dislocated . Bottomline is the printout is not similar to what you see in the script painter. But if you do File--> Print it prints properly.

CR:351115

CR Number:   351115 Product Name:   PB Enterprise Product Component:   DB Oracle Status:   Closed OS:   Microsoft Windows NT Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Apr 2004 Not a Bug Description Consult: Customer is looking for guidance in working with various Oracle charsets when moving to PB 10 Unicode.

CR:351134

CR Number:   351134 Product Name:   PB Enterprise Product Component:   DB Oracle Status:   Closed OS:   Microsoft Windows 2000 Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 May 2004 Fixed Description Trying to create a datawindow in syntax mode using the following sql: SELECT sign(employee.start_date - :adt_date - 1) FROM employee In PB it gets: Error "ORA-30081 : invalid data type for datetime/interval arithmetic" Workaround Description  Declare the retrieval argument of type string make the sql the following: SELECT SIGN(employee.start_date - TO_DATE(:adt_date, 'mm/dd/yyyy') - 1) FROM employee

CR:351137

CR Number:   351137 Product Name:   PB Enterprise Product Component:   Script Painter Status:   Open OS:   Microsoft Windows NT Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Customer also wants a Enhancement request : To provide a checkbox , if selected the Hard Tab Characters within the script painter will be treated as spaces. This would apply to printing (See CR 351106) as well as the issue described below. An issue with having hard tab characters built into the script code is that the column indicator on the bottom of the window does not accurately indicate the column that you are actually on. As an example, if you use spaces, the column indicator on the bottom of the script painter window for a given line indicates 6 for six spaces. On the next line, if you tab twice with a tab size of 2, it will be indicate you are on column 3, which actually you are on column 5. Product Support Engineer compared to a couple of other products. Treatment of tab character with regard to current column is not consistent. Some treat tab as a single character, others as multiple space chars, when it comes to setting the column value.

CR:351138

CR Number:   351138 Product Name:   PB Enterprise Product Component:   WT - System Tree Status:   Open OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Enhancements for Search capability requested. 1. Make the seach dialog box non-modal, but always on top, and leave it open after the search is complete in case another search is desired. 2. Allow search results to be concatenated in the output window, so a subsequent search doesn't overwrite the existing contents. This should be a configurable option - checkbox on the search dialog.

CR:351146

CR Number:   351146 Product Name:   PB Enterprise Product Component:   Migration Status:   Closed OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Apr 2004 Fixed Description During migration from earlier PB versions to PB 10.0, it inserts ;ansi at the end of the Alias clause of External Function Declarations. But if the Alias name doesn't have quotes around it the ;ansi get's put in the wrong place resulting in a syntax error. If the Alias name has quotes around it, the migration seems to be successful.

CR:351206

CR Number:   351206 Product Name:   PB Enterprise Product Component:   DW - Runtime Status:   Closed OS:   Microsoft Windows 2000 Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jun 2004 Fixed Description Change in behavior of line thickness display (pen.width) at runtime in the datawindow when calling modify. Additionally a difference occurs between preview and runtime when the pen.width is set via an expression.

CR:351222

CR Number:   351222 Product Name:   PB Enterprise Product Component:   Window - Runtime Status:   Open OS:   Windows XP Original Version:   10.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description This is an enhancement request to suppor hyperthreading. Hyper-Threading Technology is a hardware solution that enables multi-threaded software applications to execute threads in parallel.

CR:351224

CR Number:   351224 Product Name:   PB Enterprise Product Component:   DW Display Status:   Closed OS:   Windows XP Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Apr 2004 Third Party Problem Description Text displayed differently after installing SP1 of XP. This a MS issue.

CR:351237

CR Number:   351237 Product Name:   PB Enterprise Product Component:   DW Painter Status:   Closed OS:   Microsoft Windows NT Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10.0 4010 12 Apr 2004 Fixed Description In the datawindow painter, Export/Import template XHTML view, when deleting an element from the XHTML template, it shows an empty messagebox with a YES/NO option. If you click yes it deletes, if you click no it doesn't. The message in the messagebox itself is missing.

CR:351238

CR Number:   351238 Product Name:   PB Enterprise Product Component:   Source Control Status:   Closed OS:   Microsoft Windows 2003 Original Version:   9.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 9.0.1 7156 01 Jun 2004 Fixed Description Customer is using pvcs Tracker Link Version Control this product works in conjunction with Visual Source Safe to keep track of his application changes. With powerbulder 8 everything has been working fine in powerbuilder 9 he gets an error when checking out objects: ---------- Source Control Checking out selected items . . . SccCheckoutEx called with 1 files. 0 callbacks processed. Non Specific Error performing SccCheckoutEx() SccCheckout for C:\PB9\test\d_dddw_states.srd appears to have failed. Operation Completed ---------- Done Source Control The customer is trying this with powerbuilder 9.0.1 build 7119. If he uses regular pvcs Source control everything seems to work fine he is able to check out and check back in normally. WorkAround: Manually edit the PB.INI file that normally resides in the program files\sybase\PowerBuilder 9.0 directory. Add the following entry to the [library] section of the pb.ini file: [library] SccExtensions=0 This will turn off all calls to SccQueryInfoEx, and should fix the problem completely. PB will revert back to using SccDiff() to determine if objects are out of sync with the SCC repository. Workaround Description  Fixed in PB9.0.1 build 7156 or higher. Recommend upgrade to this EBF for complete solution to the problem. For earlier builds of PB 9, manually edit the PB.INI file that normally resides in the program files\sybase\PowerBuilder 9.0 directory. Add the following entry to the [library] section of the pb.ini file: [library] SccExtensions=0 This will turn off all calls to SccQueryInfoEx. PB will revert back to using SccDiff() to determine if objects are out of sync with the SCC repository.

CR:351242

CR Number:   351242 Product Name:   PB Enterprise Product Component:   DB OLE DB Status:   Closed OS:   Microsoft Windows 2000 Original Version:   9.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10.2.1 27 Sep 2007 Fixed Description Using embedded sql to execute a stored procedure, a decimal value of 42064.19999999999488 pass to a proc argument of decimal(14,2) is rounded using MSS but not using OLEDB.

CR:351244

CR Number:   351244 Product Name:   PB Enterprise Product Component:   PB GUI Status:   Closed OS:   Microsoft Windows NT Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 May 2004 Fixed Description In the Language tab of the System Tree, if you select any of the items under "Syntax" and ask for Help, you will be misdirected. It will take you to the "Other Resources" section of the Web Target Help. Almost every link to an external web site in that section of the help is invalid. Either it is marked as out of date (most of the Netscape links) or returns a Page Cannot be Found error (the MSDN links).

CR:351246

CR Number:   351246 Product Name:   PB Enterprise Product Component:   Window - Runtime Status:   Closed OS:   Microsoft Windows 2003 Original Version:   9.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Feb 2005 Fixed Description When opening a window from another window. The 2nd window is then closed. After this any time when MessageBox is used, focus returns to the control that caused the 2nd window to open, and not the control that had focus before the MessageBox was displayed.

CR:351248

CR Number:   351248 Product Name:   PB Enterprise Product Component:   DW Painter Status:   Closed OS:   Microsoft Windows NT Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10.0 07 Apr 2004 Fixed Description In DataWindow painter - "Specify Retrieval Arguments" dialog (menu Design -> Retrieval Arguments) - Add keyboard shortcuts for "Add", "Insert", "Delete" buttons for specifying retrieval arguments.

CR:351269

CR Number:   351269 Product Name:   PB Enterprise Product Component:   BAM Deployment Status:   Closed OS:   Microsoft Windows 2000 Original Version:   8.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Apr 2004 Not a Bug Description The memory manager makes a call to TryEnterCriticalSection which is an API not available on Win9x. The PBHeap memory manager implementation includes a call to TryEnterCriticalSection which is an API call not available on Windows 95 or Windows 98. We supposedly support Windows98, so the question is whether or not this API call might preclude applications from running on WIndows 98. A Sybase proserv person was at a client site where this was a problem running and end-user app on Windows 95 - the message TryEnterCriticalSection not being found in kernel32.dll was the error message. While we don't support Windows 95 for anything, we do support Windows 98 for deployment and this method according to Windows API docs is not supported on Windows 98 either. However, the TryEnterCriticalSection call is made within an IF statement within pbspheap.c, therefore it's very possible our testing did not hit the right set of circumstances to cause the failure. RESOLUTION: TryEnterCriticalSection was implemented in win98 kernel32.dll so no problem using PB memory manager on win98.

CR:351322

CR Number:   351322 Product Name:   PB Enterprise Product Component:   Structure - Runtime Status:   Closed OS:   Solaris 2.8 Original Version:   8.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 8.0.4 19 Jul 2004 Fixed Description Only on Solaris PBVM804.10606 , Array insert works wrong.

CR:351348

CR Number:   351348 Product Name:   PocketBuilder Product Component:   DW - Runtime Status:   Open OS:   Pocket PC 2002 Original Version:   1.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 1.5.2 386 Fixed Description Importing a comma separated string does not work. Tab separated works just fine, but not comma.....

CR:351349

CR Number:   351349 Product Name:   PocketBuilder Product Component:   DW - Runtime Status:   Open OS:   Pocket PC 2002 Original Version:   1.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 1.5.2 388 Fixed Description The DBase 2/3/4 file import/export options don't work AND they consume space we can't spare. These options should be removed.

CR:351365

CR Number:   351365 Product Name:   PB Enterprise Product Component:   Migration Status:   Closed OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Apr 2004 Fixed Description The migration of an application from PB 8 or PB 9 to PB 10 consumes too much virtual memory to the point where PB crashes.

CR:351371

CR Number:   351371 Product Name:   PB Enterprise Product Component:   PD Integration Status:   Closed OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Apr 2004 Fixed Description If you have a PB app and you then reverse engineer it in PB, if you go in to PD and generate PowerBuilder for an object without making any changes to the object in PD, the syntax written for that object has changed from what it was before. It compiles OK in PB, but if you then rename a control on a window in PB, you can't save the window due to a compilation error. Workaround Description  - Start PowerDesigner - Select Tools>Resources>Object Languages - Select PowerBuilder - Click on the Properties button - Expand the Profile folder - Expand the Class folder - Expand the Stereotype folder - Expand the window Stereotype folder - Expand the Templates folder - Select the createAndDestroy template - Remove the following lines: call super::create TriggerEvent(this, "constructor") call super::destroy TriggerEvent(this, "destructor") - Repeat the same operation for the control stereotype - Save the PB Object Language

CR:351377

CR Number:   351377 Product Name:   PB Enterprise Product Component:   Project Painter Status:   Open OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description We would love to have the ability to add custom component properties in the PB deployment project instead of having to add them to each component manually using Jag Manager or jagant. For a complete list of these properties please refer to pages 455 - 460 in the powerbuilder 9 application techniques manual.

CR:351393

CR Number:   351393 Product Name:   PocketBuilder Product Component:   DW - Runtime Status:   Open OS:   Pocket PC 2002 Original Version:   1.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Virtual Keyboard disappears when moving between datawindow columns. Pkt PB help states that setting an Edit Field's property SIPonFocus to "No" does not open/close SIP automatically. Moving between fields that do not have SIPonFocus set should not close SIP automatically.

CR:351464

CR Number:   351464 Product Name:   PB Enterprise Product Component:   PB Web Services Status:   Open OS:   Microsoft Windows 2000 Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description PB webservices client (implemented with easysoap++) does not support the WS-Security specification eg. to be found at: Spec on webservice security ws can be found at http://www-106.ibm.com/developerworks/library/ws-secure/ http://msdn.microsoft.com/webservices/understanding/specs/default.aspx?pull=/library/en-us/dnglobspec/html/wssecurspecindex.asp

CR:351477

CR Number:   351477 Product Name:   PB Enterprise Product Component:   DB OLE DB Status:   Closed OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 8.0.4 26 Apr 2004 Fixed Description When connecting to an OLEDB and you selected the Impersonate option from the Security's Tab Impersonate Level property, powerbuilder will crash with the following information: Exception code: C0000005 ACCESS_VIOLATION File Name: E:\pb10\Shared\PowerBuilder\MSVCR71.dll File Version: 7.10.3052.4 Fault address=7C350582 Section:Offset=01:0000F582 Registers: EAX:012D10F0 EBX:00000000 ECX:001A0049 EDX:00000000 ESI:14F3ED0C EDI:00000004 CS:EIP:001B:7C350582 SS:ESP:0023:0012CAB4 EBP:7C35056A DS:0023 ES:0023 FS:0038 GS:0000 Flags:00010246 Call stack: Address Frame Param0 Param1 Param2 Param3 Function Name 7C350582 7C35056A 09EB570C 74C98566 46424211 0E8B6646 wcscmp+18 24748B56 0424548B 00000000 00000000 00000000 00000000 0000:00000000

CR:351509

CR Number:   351509 Product Name:   PB Enterprise Product Component:   Source Control Status:   Closed OS:   Microsoft Windows 2000 Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Apr 2004 Presently Not Targeted For Any Future Release Of This Product Description Enhancement request: For PowerBuilder to utilize an array of objects when doing a GetLatestVersion rather than one at a time. See CR# 231796. Per PB Engineering this will not be implemented. There are two better methodologies: 1) The customer should Issue a target-wide "Refresh Status" request prior to doing a target-wide GetLatestVersion. Refresh status was purposely re-designed in PB 9 to indeed call SccQueryInfo with an array of objects. It also has the benefit of running on a background thread so the user can continue working while the refresh status takes place in the background! Status info gets cached so if the workspace expiration interval is set to 20 minutes or more, you can run the target-wide refresh status and immediately follow it up with the GLV request. GLV won''t need to do any SccQueryInfo calls because it has up-to-date info in the cache. 2) Orcascript refresh target is a far superior methodology for refreshing the target and it too uses array of SccQueryInfo. Orcascripts can be run at night, further enhancing productivity. Workaround Description  Call target-wize "Refresh Status" first. To understand how a target-wide Refresh Status helps performance requires an understanding of how our "StatusAndDiff" routines work: 1) We keep a hash table in memory called the "refresh status cache". This is extremely efficient. 2) Each entry in the hash table has its own "expiration timestamp" which is time that entry was last refreshed plus the workspace property expiration interval. 3) A target-wide Refresh Status request will update every single entry in the refresh status cache. One of the arguments to our "StatusAndDiff" routine is a "lStatFlags" bitmask which determines how the processing should proceed. A Refresh Status request sets the bitmask to the following for PB9 and PVCS: STAT_ForceQueryInfo | STAT_DiffByVersion. The calls use SccMaxArraySize setting to control the array passed to the server. This is customizable in PB.INI as Biao points out. 4) A subsequent target-wide GLV request will indeed call our "StatusAndDiff" routine one entry at a time to populate the SCC dialog box. These requests sets the bitmask to the following for PB9 and PVCS: STAT_UpdateCache | STAT_DiffByVersion. Here's how the processing works: a) At SCC initialization, populate the cache with PBC file entries and mark each entry as "dirty" b) If SCC offline, always use the cache value (extremely fast lookup) c) If (((lStatFlags & STAT_ForceQueryInfo) == 0) && (entry found in cache) && ( expiration timestamp > current time)) then use cache value (no server call needed) else Call SccQueryInfoEx and update the cache Running Refresh Status before running GLV causes 4c above to always hit the "then" condition (no server calls). Running GLV without a previous Refresh Status will indeed call the server for each dirty cache entry.

CR:351510

CR Number:   351510 Product Name:   PB Enterprise Product Component:   PD Integration Status:   Closed OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Apr 2004 Fixed Description When a PB transaction object that has an RPCFUNC call is reverse engineered, the syntax of the external function declaration is changed in the oom from what was in PB. If you then try to Generate PB it gives a compilation error, but still writes the PB object with the incorrect syntax.

CR:351511

CR Number:   351511 Product Name:   PB Enterprise Product Component:   DB ODBC Status:   Closed OS:   Microsoft Windows NT Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 8.0.4 12 May 2004 Fixed Description Commits fails, If PBNewSPInvocation='Yes'" & "DefaultProcOwner='proms'" set in DBParm

CR:351516

CR Number:   351516 Product Name:   PB Enterprise Product Component:   Debugger Status:   Closed OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Apr 2004 Fixed Description Debug the following code in the debugger and click on the olestorage or olestream variable in the local variable tab in the debugger. OLEStorage olestore OLEStream olestr olestore = create olestorage olestr = create olestream If you click on an olestorage variable, you get a R0051 execution error: "Application terminated. Error: Bad argument list for function/event: get_documentname at line <line#> in clicked event of object <controlname> of <windowname>"

CR:351581

CR Number:   351581 Product Name:   PB Enterprise Product Component:   DW - Runtime Status:   Open OS:   Microsoft Windows 2000 Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The DW edit field does not support the microsoft intelli mouse mode. Workaround Description  Workaround: Set the mouse driver to "Enhance Scroll Mode" (Available on tested Dexxa mouse), it will then support all applications that use scroll bars, with zoom, Auto-panning and scrolling functions.

CR:351601

CR Number:   351601 Product Name:   PB Enterprise Product Component:   DB MS SQLServer Status:   Closed OS:   Microsoft Windows 2000 Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Apr 2004 Not a Bug Description When calling a stored procedure and it triggers a raiserror, that raiserror message is not returned back to the application when MS DTC is used. When not using MS DTC, the raiserror is returned back to the application. Also tried using different syntaxs for the stored procedure and that didn't work. For example instead of using: CREATE procedure GeacTest AS RAISERROR 50001 "Geac Test of raiserror 50001." RETURN 1 go Used: RAISERROR 50001 "Geac Test of raiserror 50001." RETURN -1 ----- Also tried RAISERROR (50001,20,-1) returm -1 ---- Or adding the message using sp_addmessage RAISERROR (50002,20,-1) with log return -1 In this case, the error message was seen in the application log file but not returned in the application RESOLUTION: Customer has removed the instantiation of callback functions from the DLL and now raiserrors are working fine.

CR:351602

CR Number:   351602 Product Name:   PocketBuilder Product Component:   DW - Runtime Status:   Closed OS:   Pocket PC 2002 Original Version:   1.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2005 Duplicate Description Virtual Keyboard disappears when moving between datawindow columns. Pkt PB help states that setting an Edit Field's property SIPonFocus to "No" does not open/close SIP automatically. Moving between fields that do not have SIPonFocus set should not close SIP automatically.

CR:351604

CR Number:   351604 Product Name:   PB Enterprise Product Component:   DB Oracle Status:   Open OS:   Microsoft Windows 2003 Original Version:   10.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Add support for PL/SQL records and objects as PB structures in remote procedure calls in PB10. A PL/SQL RECORD is a composite datatype. In contrast to a scalar datatype like NUMBER, a record is composed of multiple pieces of information, called fields. Records can be declared using relational tables or explicit cursors as "templates" with the %ROWTYPEdeclaration attribute.

CR:351612

CR Number:   351612 Product Name:   PB Enterprise Product Component:   DW.Net Status:   Closed OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Apr 2004 Not a Bug Description PB and DW.NET have different behavior in GotFocus/getfocus and LostFocus/losefocus. This scenario was tested using a .NET listbox and the following code for the GotFocus event: Private Sub lb_1_GotFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles lb_1.GotFocus MessageBox.Show("lb_1 got focus") End Sub The results were the same as with the DataWindowControl, repeated MessageBoxes and you cannot close the form. According to development we have to defer to the .NET behavior and will not attempt to make this work like PowerBuilder.

CR:351645

CR Number:   351645 Product Name:   PB Enterprise Product Component:   Documentation Status:   Closed OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Aug 2004 Fixed Description The return datatype for the OLEStream Write function is incorrect in the online help. The help indicates that it returns an integer, it really returns a long.

CR:351699

CR Number:   351699 Product Name:   PB Enterprise Product Component:   Migration Status:   Closed OS:   Microsoft Windows NT Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Apr 2004 Fixed Description Description of Problem: Select the "Automatically convert DBCS String-Manipulation Functions" option, the migration GPF due to the conversion or will have syntax errors and code is not converted properly.

CR:351701

CR Number:   351701 Product Name:   PB Enterprise Product Component:   OLE - Active X - OCX Status:   Closed OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jun 2005 Presently Not Targeted For Any Future Release Of This Product Description When using a ole control and referencing it from a cb, getting a null object reference on parentstorage. Using the following code: ole_1.insertobject() ole_1.parentstorage.saveas('myfile.txt') Review Status  6/14/2005 This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release".

CR:351724

CR Number:   351724 Product Name:   PB Enterprise Product Component:   DB OLE DB Status:   Open OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description This is an enhancement request that perhaps there is another way to get a stored procedure resultset description without actually executing the stored procedure when creating an sp based datawindow.

CR:351747

CR Number:   351747 Product Name:   PB Enterprise Product Component:   Documentation Status:   Closed OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Aug 2004 Fixed Description The example in App. Techniques, Chap 18, Using OLE in an application, Advanced ways to manipulate OLE objects, opening and saving storages...could be improved.

CR:351749

CR Number:   351749 Product Name:   PB Enterprise Product Component:   OLE - Active X - OCX Status:   Open OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Enhancement Request: When an OLE control is inserted, its functions, events and other information can be found by going to the Browser pane, under the OLE tab and navigating to the control. Would like to see the same information in the OLE control properties pane itself and be able to drag and drop the functions from the properties painter.

CR:351751

CR Number:   351751 Product Name:   PB Enterprise Product Component:   DW Display Status:   Open OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Enhancement Request: DataWindow property while running application: Right / Left Arrow to scroll grid DW grid horizontally

CR:351753

CR Number:   351753 Product Name:   PB Enterprise Product Component:   DW - Runtime Status:   Open OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Enhancement: DataWindow has a lack of events: onHideBefore, onHideAfter, onShowBefore, onShowAfter. These events could be triggered with dw_control.Hide() and dw_control.Show() functions, and especially after clicking the "close" button on title bar of DataWindow.

CR:351754

CR Number:   351754 Product Name:   PB Enterprise Product Component:   WT - System Tree Status:   Open OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Enhancement Request: PowerBuilder 10.0 Beta 2, In the System Tree -> "Workspace tab" (main navigation object window in PowerBuilder) might have additional options: - Search option with history, saved after closing PowerBuilder (and a shortcut for it). Right now it has only simple search option. - Regenerate option to target, single pbl, and a workspace (and a shortcut for it) - it means: the possibility of regeneration all objects inside selected object but not rebuilding them. - "Properties" of pbl (user description of pbl) displayed optionally after the name of pbl - Right mouse key on KEYBORD (not on mouse) for selected object (it works on "components tab" and on "language tab", however not correctly).

CR:351815

CR Number:   351815 Product Name:   PB Enterprise Product Component:   DW XML Status:   Closed OS:   Microsoft Windows 2000 Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jun 2005 Fixed 31 Jul 2005 Fixed Description When importing a XML file with a CDATA section, the following error results and the import fails: CREATING SAX PARSER. USING XML IMPORT TEMPLATE: ud_new XML NAMES MAPPING TO DATAWINDOW IMPORT COLUMNS: ATTRIBUTE: /AMS_DOC_XML_EXPORT_FILE/PYMT_RETN_DOC NAME: '__pbband' >>> RESERVED TEMPLATE NAME - ITEM WILL BE IGNORED XML Import Error No matching DataWindow column reference within XML template. The XML file to be imported is: <AMS_DOC_XML_EXPORT_FILE> <PYMT_RETN_DOC> <CHK_NO> <![CDATA[ 000000000000009]]> </CHK_NO> <CHK_NO> <![CDATA[ 000000000000124]]> </CHK_NO> </PYMT_RETN_DOC> </AMS_DOC_XML_EXPORT_FILE> The template is set up as: - AMS_DOC_XML_EXPORT_FILE ------------------------- < - Detail Starts - PYMT_RETN_DOC - CHK_NO ![CDATA[~t idss ]]

CR:351819

CR Number:   351819 Product Name:   PB Enterprise Product Component:   Documentation Status:   Closed OS:   Microsoft Windows NT Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Sep 2004 Fixed Description Documentation request: Add another example for FileWrite to show technique used with large files, eg. could use example from PFC: pfc_n_cst_filesrv: of_filewrite()

CR:351840

CR Number:   351840 Product Name:   PB Enterprise Product Component:   DW.Net Status:   Open OS:   Microsoft Windows 2003 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Provide AdoTransaction support for SqlConnection, OracleConnection, OdbcConnection in Datawindow.Net. They all implement IDbConnection interface. Currently AdoTransaction object only supports OleDbConnection

CR:351856

CR Number:   351856 Product Name:   PB Enterprise Product Component:   DB OLE DB Status:   Closed OS:   Microsoft Windows 2000 Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 9.0.1 29 Apr 2004 Fixed 28 Jul 2004 Fixed Description Unable to update a table when calling a c++ function from within Powerbuilder and connected to a MS Sql Server 2000 database using OLE DB and MS DTC. Customer believes that a ReturnCommandHandle is needed for a OLE DB connection to that the proper handle is returned to their c++ dll.

CR:351937

CR Number:   351937 Product Name:   PB Enterprise Product Component:   DW - Runtime Status:   Open OS:   Microsoft Windows NT Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description pbm_dwnkey event does not work for KeyRightButton! I think this is not a bug and the KeyLeftButton! is processed by the Clicked event and the KeyRightButton! is processed by the rbuttondown event and the processing never gets to the pbm_dwnkey event. Checking with development on the KeyMiddleButton!. Request documentation note if this is correct behavior.

CR:351947

CR Number:   351947 Product Name:   PB Enterprise Product Component:   Documentation Status:   Closed OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Apr 2004 Fixed Description This is a request to document the Datawindow SaveAs function as several enumerated types have been discontinued in 10.0, including EXCEL5!, WK1!, WKS!, and WMF!

CR:351962

CR Number:   351962 Product Name:   PB Enterprise Product Component:   DB OLE DB Status:   Closed OS:   Microsoft Windows 2000 Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 May 2004 Not a Bug Description Unable to create a Datawindow from a stored procedure when using OLE DB driver. One gets an error message procedure 'xxxx' expects parameter @<param name> which was not supplied. This happens for stored procedures which have an input argument. Per PB Engineering: This is not a bug. The supplied stored procedure does not return a resultset. PB requires a resultset returned for stored procedures to be used as datawindow sources.

CR:351966

CR Number:   351966 Product Name:   PB Enterprise Product Component:   Language - Runtime Status:   Closed OS:   Microsoft Windows 2003 Original Version:   9.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Sep 2004 Not a Bug Description SyntaxFromSql memory link.

CR:351970

CR Number:   351970 Product Name:   PB Enterprise Product Component:   DB Oracle Status:   Open OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description CR 300345 introduced a new Oracle DBParm called Timestamp. In 9.0.1 this DBParm could be set only in script. This is a request to add a checkbox to the Oracle connection Profile for the Timestamp DBParm.

CR:352037

CR Number:   352037 Product Name:   PB Enterprise Product Component:   OLE - Active X - OCX Status:   Open OS:   Microsoft Windows NT Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Customer wants to access properties and methods in OLEStorage objects and wants the capability to do that. Customer wants to be able to take an arbitrary OLE compound document and interrogate it to get the stream name and any property sets. This cannot be done with the current functionality is the storage class though, because that class doesn抰 exposed methods that would allow to enumerate the streams or retrieve the property sets. Visual Basic also can抰 read property sets, so Microsoft provides an ActiveX that allows them to interface with some compound OLE documents. What I'm basically looking for is this: OLE Compound Documents are composed of three types of data: Storages Streams Property Sets The problem with PB's implementation is: 1. I can only access storages and streams, I can't access property sets and 2. I have to know the name of the member in order to access it. There's no way in PB to query the object for the names of the members. I want to be able to get the names of the members, and I want to be able to pull property set information.

CR:352038

CR Number:   352038 Product Name:   PB Enterprise Product Component:   Window Painter Status:   Open OS:   Microsoft Windows 2000 Original Version:   9.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Deletion of objects referenced in other objects require manual editing of the referencing objects to resolve the situation. It would be nice to have a way to automatically remove references to deleted objects.

CR:352053

CR Number:   352053 Product Name:   PB Enterprise Product Component:   PB GUI Status:   Closed OS:   Microsoft Windows 2000 Original Version:   8.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Apr 2005 Presently Not Targeted For Any Future Release Of This Product Description With a rather large library list, none of the PBLs show up in the Open or Run dialogs, though they all show in the Inherit dialog. Review Status  04/24/2005: This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release".

CR:352062

CR Number:   352062 Product Name:   PB Enterprise Product Component:   DB Other Status:   Closed OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10.0 beta3 15 Apr 2004 Fixed Description PowerBuilder crashes with memory error during connect MS SQL Server 2000 (8.00.760) database using ADO.net access using udl file and sql server security.

CR:352070

CR Number:   352070 Product Name:   PB Enterprise Product Component:   DW - Runtime Status:   Closed OS:   Microsoft Windows 2000 Original Version:   10.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10.0 16 Aug 2004 Fixed Description The clicked and doubleclicked events of a datawindow have a row argument. With a label style datawindow, sometimes this argument is incorrect. Intermitently it reports the last row on the page instead of the label you clicked on.