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

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

CR:593158

CR Number:   593158 Product Name:   PB Enterprise Product Component:   PB Web Services Status:   Open OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The customer has hundreds of web services being called from PB using .NET web services. Each dll is named as the service. They have a production environment, four test environments, and a training environment. Each environment is self contained and has it's own database, and it's own webservices etc. They want to keep all the PB webservice dll names the same in all 6 environments. Obviously they need to create each webservice dll in it's own environment for it to access the webservice in it's environment. They do this because they don't want a unique proxy object in each environment. They want to create the proxy object for each webservice only once, and have the same proxy object referencing the same named dll in all enviornments. Because there are so many webservice dlls and they are all named the same across the six environments, sometimes they make misstakes and have the wrong dll in an environment, a dll that was created in another environment. When that happens there is no error and the wrong webservice is accessed. This can cause data integrity problems, and they aren't even aware it is happening. What they are asking for is for PB to warn them when this happens. They want PB to internally mark the dll somehow when it is created, and when a dll is being used that was not created with that environment, they want PB to error at run time.

CR:593466

CR Number:   593466 Product Name:   PB Enterprise Product Component:   PB.NET Status:   Closed OS:   Windows XP Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Nov 2009 Duplicate Description In a WPF application if you do not put any code in the Open event you do not get an error message as you do in PB Classic.

CR:593898

CR Number:   593898 Product Name:   PB Enterprise Product Component:   DB MS SQLServer Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Oct 2009 Not a Bug Description Divide by Zero error inside a SP not raised to PowerBuilder.

CR:594004

CR Number:   594004 Product Name:   PB Enterprise Product Component:   PB.NET WebForm Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Nov 2009 Fixed Description EMF & WMF result generated by WebForm using SaveAs is different from Windows

CR:594080

CR Number:   594080 Product Name:   PB Enterprise Product Component:   System Runtime Functions Status:   Open OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Enhancement request to digitally sign all the PowerBuilder runtime DLLs.

CR:594090

CR Number:   594090 Product Name:   PB Enterprise Product Component:   DB ODBC Status:   Open OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Memory leak with datastore create function.

CR:594125

CR Number:   594125 Product Name:   PB Enterprise Product Component:   PB Web Services Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Oct 2009 Not a Bug Description 1 - Customer is using PB 11.5.1 as the front end and COBOL as the backend. There are some COBOL files that contain variables with "_x0056_", For example: Wsm_x0056_last_nam, Wsm_x0056_first_nam, . . . . . . . 2. Using Shadow Studio (dataDirect) as midware to generate a wsdl file. The variables displayed in the wsdl file as <s:element minOccurs="1" maxOccurs="1" nillable="true" name="Wsm_x0056_last_nam" type="s:string" /> <s:element minOccurs="1" maxOccurs="1" nillable="true" name="Wsm_x0056_first_nam" type="s:string" /> 3. Using PowerBuilder Web Service Proxy Wizard to get the variables passed to the PB application. Cusotomer is using the.Net engine as SOAP engine. 4. After deployed the generated Web Service Proxy Project. Above variables name displayed as String WsmVlast_nam, String WsmVfirst_nam. PB is substituting the letter V for the string _x0056_. x0056 is the hex representation for the capital V but this is a string and customer does not think it should. Searching the internet to see if name fields can contain hex representations of characters did not produce anything definitive. 5. Customer has tried to use the variables as it is generated. There is no data can be passed to the variables. 6. She also tried to change the names of the variables back to Wsm_x0056_last_nam, Wsm_x0056_first_nam. And the data were not passed either. Beside the variables name with "_x00nn_" so far, there are some names with "_t00nn_ are displayed correct. Customer sees this as a bug.

CR:594142

CR Number:   594142 Product Name:   PB Enterprise Product Component:   UO Painter Status:   Closed OS:   Windows XP Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Nov 2009 Fixed Description The PB12 Classic IDE crashes when you set the DataObject in a Standard class datastore.

CR:594474

CR Number:   594474 Product Name:   PB Enterprise Product Component:   Rich Text Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Nov 2009 Workaround Description Customer has an application where they insert rich text fields by using InputFieldInsert and choosing from a list which fields to insert into the control. "InputFieldNamesVisible" is false and so the user just sees '??'. If the user makes a mistake and they backspace over the field it appears to be deleted as the '??' are gone but it isn't really deleted. If they then insert another field on the same line, it does not appear and if they then turn on "InputFieldNamesVisible" you can see that the original field is returned from InputFieldCurrentName.

CR:594618

CR Number:   594618 Product Name:   PB Enterprise Product Component:   DB SQLAnywhere Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11.5 17 Nov 2009 Fixed Description Cannot pass large blob as parameter to an ASA stored procedure. Workaround Description  Use RPC call.

CR:594900

CR Number:   594900 Product Name:   PB Enterprise Product Component:   DW HTML Status:   Open OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Problem with decimal keypad when decimal separator is comma. Workaround Description  In the JSP page add this line : <SCRIPT SRC="/keyHandler.js"></SCRIPT> Create a JavaScript file keHandle.js and put into the following : var DecSepKey = 46; var CharSepKey = 44; document.onkeypress = keyHandler ; function keyHandler(e) { var key; if (document.all) e = window.event; if (document.layers) key = e.which; if (document.all) key = e.keyCode; switch (key) { case DecSepKey : e.keyCode = CharSepKey; break; default : break; } }

CR:594928

CR Number:   594928 Product Name:   PB Enterprise Product Component:   DB Informix Status:   Open OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description OS: Windows XP SP3 Versions and Build #s Tested: PB 11.5.1_4590 Database/Driver File/Version: IN10 Interface connecting to Informix 9.x Database, with Informix Client 3.00.TC3 Comments: During Web Forms runtime, datawindow retrieve() sometimes return the error: Select Error: SQL Error -404: The cursor or statement is not available The issue happens if we split SQLCA connection, dw.setransobject(), dw.retrieve(), disconnect in different buttons within window. If we place the entire code from all buttons into Connect Button (connection, set trans, query and disconnect), the issue never happens In PB Native (client/server), the issue never happens.

CR:595051

CR Number:   595051 Product Name:   PocketBuilder Product Component:   DB ODBC Status:   Open OS:   Windows Mobile 6 Original Version:   9.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description We are unable to raise this issue using a Dell Axim X30, HP iPAQ 214, Mio A701, Samsung Omnia and Unitech PA500. The only known PDA that this will occur on ( every time ) is the HP iPAQ Data Messenger. Same issue is also on Vodafone v1615s.

CR:595076

CR Number:   595076 Product Name:   PB Enterprise Product Component:   DW Display Status:   Open OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Display format of #,0 will display as 1,2,4,5 instead of 1,245. This worked ok in PB 10.5.2.

CR:595079

CR Number:   595079 Product Name:   PB Enterprise Product Component:   Jaguar Integration Status:   Open OS:   Microsoft Windows 2003 Original Version:   9.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description An EAS/pbvm application sometimes crashes randomly without apparent cause, both on AIX and Windows platform.

CR:595081

CR Number:   595081 Product Name:   PB Enterprise Product Component:   PB.NET WebForm Status:   Open OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description After migrating from Win32 to .NET Webform, customer's application is slow on initial startup before even connecting to the Oracle 10g database. Performance improves on subsequent runs. Development indicated that there may be ways to improve performance and the customer is requesting these ehancements.

CR:595093

CR Number:   595093 Product Name:   PB Enterprise Product Component:   Rich Text Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jan 2010 Not a Bug Description Customer finds that RTE tab stops are lost when you save your document and reinsert it. Tested saving an rtf in Word and once document loaded the tab stops that were set were active.

CR:595094

CR Number:   595094 Product Name:   PB Enterprise Product Component:   ORCA Status:   Closed OS:   Windows XP Original Version:   11.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Oct 2009 Fixed 26 Nov 2009 Fixed Description Customer is claiming that #if defined PBNATIVE then is still always evaluating as false when used with Orca. This was submitted as CR 576927 and the resolution states that the fix was implemented in PB 11.2 but testing with build 8896, it doesn't appear to be fixed.

CR:595109

CR Number:   595109 Product Name:   PB Enterprise Product Component:   PB.NET WebForm Status:   Open OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Getting the following error when running a web forms application on Vista 64 bit. Application was deployed from an msi file. Deploying same msi file to XP machine works as expected. System.Security.SecurityException Request for permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed in event open of object ora10 Analysis/Actions (Workaround): Determined that the following needed to be added (http://msdn.microsoft.com/en-us/library/tkscy493.aspx) to the system.web node of the web.config file. <securityPolicy> <trustLevel name="Full" policyFile="internal" /> <trustLevel name="High" policyFile="web_hightrust.config" /> <trustLevel name="Medium" policyFile="web_mediumtrust.config" /> <trustLevel name="Low" policyFile="web_lowtrust.config" /> <trustLevel name="Minimal" policyFile="web_minimaltrust.config"/> </securityPolicy> <trust level="Full" originUrl="" processRequestInApplicationTrust="true" />

CR:595218

CR Number:   595218 Product Name:   PB Enterprise Product Component:   DW - Runtime Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Nov 2009 Fixed Description Object in detail band at y pos zero will shift one pixel down at runtime and hence you will see a gap line displayed in the color of the Datawindow background. Workaround Description  You may increase the thickness/penwidth of the rectangle or line object to 2 but that might lead to other onwanted display issues.

CR:595460

CR Number:   595460 Product Name:   PB Enterprise Product Component:   PB GUI Status:   Open OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Cannot reset image in a Picture Control after the function setPicture (blob lb) has been called. Workaround Description  Set the image unvisible when there is no image to display.

CR:595465

CR Number:   595465 Product Name:   PB Enterprise Product Component:   Language - Compiler Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Nov 2009 Fixed Description PowerBuilder is crashing after removing code in Create event and saving a custom visual object.

CR:595622

CR Number:   595622 Product Name:   PB Enterprise Product Component:   DW - Runtime Status:   Open OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When entering the richtext column the richtext toolbar does not come up if set to activate on edit. Only after a second click it appears. Workaround: post the modify call. Workaround Description  Workaround: post the modify call.

CR:595874

CR Number:   595874 Product Name:   PB Enterprise Product Component:   Rich Text Status:   Open OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Customer is asking for an enhancement to upgrade Rich Text support to v1.9.1 (Word 2007: http://www.microsoft.com/downloads/details.aspx?FamilyID=dd422b8d-ff06-4207-b476-6b5396a18a2b&displaylang=en). Documentation states that we currently support v1.6]

CR:596025

CR Number:   596025 Product Name:   PB Enterprise Product Component:   PB.NET WebForm Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Nov 2009 Fixed Description When using PBDataWindowEnableDDDW=true and you tab into a dddw, there is no indication that focus is on the dddw and if you use the arrow key nothing happens.

CR:596639

CR Number:   596639 Product Name:   PB Enterprise Product Component:   OLE - Active X - OCX Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2010 Third Party Problem Description When using the activex Word 2003 control and the compatibility pack for 2007, the ole activate fails with a File Conversion error. RESOLUTION: Uninstall Office 2003. Reinstalled Office 2003. Open the *.docx and a message appears that a converter needs to be installed. Click ok. Goto this site http://www.microsoft.com/downloads/details.aspx?FamilyId=941B3470-3AE9-4AEE-8F43-C6BB74CD1466&displaylang=en. Install the required patches and then FileFormatConverters.exe. Not a PB bug.

CR:596646

CR Number:   596646 Product Name:   PB Enterprise Product Component:   DW - Runtime Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Dec 2009 Fixed Description Nested n-up DataWindow is missing last row on last page break of main Datawindow. It behaves correctly when I make the summary band a bit smaller by just a bit. ie. from 100 to 83. I also set autosizeheight on for that band. Workaround Description  It behaves correctly when I make the summary band a bit smaller by just a bit. ie. from 100 to 83. I also set autosizeheight on for that band.

CR:605068

CR Number:   605068 Product Name:   PB Enterprise Product Component:   Menus - Runtime Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Dec 2009 Fixed Description The customer has a MDI application with a Frame menu on the Frame. The sheet menu is inherited from the frame menu and has 2 existing menu items marked as not visible, and disabled (Jump and Action). The sheet is opened in a maximized window state as set in the sheet window properties. In the sheet open event one menu item (Action) is set to to be visible and enabled in script. But the resulting menu has the menu item (Board) that should be after Action before it and Action is still disabled. If you open the sheet in normal or minimized state, then the menu is correct. Workaround Description  Open the sheet as minimized, then set the windowstate to Maximized! after the menu maniplulations.

CR:605227

CR Number:   605227 Product Name:   PB Enterprise Product Component:   Documentation Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Nov 2010 Fixed Description For the rte preview(), the online help and the PowerScript manual list 'Preview mode provides edit boxes for specifying paper dimensions and margins'. According to cr435746, the new rte control starting in PB 10.5 no longer shows that information. Please also add the following to the online help and PowerScript manual: (the following is from the App Techniques manual): Users can page through the control contents in print preview mode by using the up arrow and down arrow keys or the Page Up and Page Down keys.

CR:605492

CR Number:   605492 Product Name:   PB Enterprise Product Component:   DB Informix Status:   Closed OS:   Windows XP Original Version:   11.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11.2 18 Nov 2009 Fixed 11.2 20 Aug 2010 Fixed Description When "<>" is used for the operator of DataWindows, "NULL" may be unable to be used for the value to compare. PB embeds "<> NULL" at SQL. This SQL cannot be executed by Informix.

CR:605616

CR Number:   605616 Product Name:   PB Enterprise Product Component:   PB.NET WebForm Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Nov 2009 Not a Bug Description OS: Windows 2003 R2 SP2 Versions and Build #s Tested: - PB 11.5.1_4608 web forms on Windows XP - IE 7.0 and IIS 6.0 on Windows 2003 R2 SP2 - Microsoft .NET Framework 2.0 - PB 11.5.1_4608 Runtime Packager deployed (.NET and Standard components) deployed correctly into Win2k3 R2 machine Database/Driver File/Version: N/A The following error appears when clicking on webform dw_control (if its "clicked" event is coded): array boundary exceeded: void d(system.string) of object sybase.powerbuilder.web.webdatawindow.

CR:605620

CR Number:   605620 Product Name:   PB Enterprise Product Component:   WPF Window Painter Status:   Closed OS:   Windows XP Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jan 2010 Fixed Description As you can see now we have a FlowDirection = RTL that solve the position of the tabs, but the text in the tab are shown incorrect they must be different. --Update-- This seems to be the same as an existing Microsoft WPF Designer bug. BugID 320579 https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=320579

CR:605621

CR Number:   605621 Product Name:   PB Enterprise Product Component:   WPF Window Painter Status:   Closed OS:   Windows XP Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Nov 2009 Not a Bug Description Static Text in DW is not RTL and the RTL Column in a DW change the Alignment of the column but not change the language to Hebrew

CR:605624

CR Number:   605624 Product Name:   PB Enterprise Product Component:   WPF Window Painter Status:   Closed OS:   Windows XP Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jan 2010 Fixed Description There is no RightToLeft property per column level in PB 12 .net IDE as it used to be in PB 11.5.

CR:606609

CR Number:   606609 Product Name:   PB Enterprise Product Component:   DB MS SQLServer Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11.5 24 Dec 2009 Fixed Description SNC:error when using bind variables in a sql with subselect queries SQL statements with sub-select queries with parms gives error: "Microsoft SQL Server Native Client 10.0 Parameter Information cannot be derived from SQL statements with sub-select queries. Set parameter information before preparing command. Workaround Description  To workaround the issue, wrap the SELECT statement with subselect into a complete new stored procedure and call it with dynamic sql or simply using sp_executesql.

CR:606620

CR Number:   606620 Product Name:   PocketBuilder Product Component:   Menus - Runtime Status:   Open OS:   Windows Mobile 5 Original Version:   2.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Workaround Description On a menu with 3 levels the 2nd level doesn't fire a clicked event. Workaround Description  For PocketBuilder 2.5.2.1273 Current workaround recommendation from development: a) create a generic handler which will perform _all_ the menu alterations (fixups) b) on the main window, add a handler for the custom event "PBM_InitMenuPopup" c) from both the "Level_1_A" click handler _and_ from the custom event PBM_InitMenuPopup call the generic menu alteration handler This solution will work on both WM2003 and WM5 The messages we now see: WM 2003 device (ver 4.20.0) using mouse (no keys available) Click in Level_1_A Click in Level_3_I WM 5 device (ver 5.1.195) using left and select keys or the stylus PBM_InitMenuPopup handler (on main window) Click in Level_2_C Click in Level_3_I

CR:606630

CR Number:   606630 Product Name:   PB Enterprise Product Component:   Install Status:   Open OS:   Windows 2008 Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Need an official certification for PB 11.5.1 on Windows 2008 in developement mode.

CR:606805

CR Number:   606805 Product Name:   PB Enterprise Product Component:   Window - Runtime Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Dec 2009 Fixed 19 Jan 2010 Fixed Description Migrated app from PB 9 to PB 11.5.1 and getting a random crash in the pbvm115. FOLLOWUP_IP: pbvm115!EvtUserEventProc+4c [e:\pb115\runtime\function\fnevents.cpp @ 2301] 10c0d48c eb02 jmp pbvm115!EvtUserEventProc+0x50 (10c0d490) FAILED_INSTRUCTION_ADDRESS: +26b952f01dddf74 00000001 ?? ??? NTGLOBALFLAG: 0 APPLICATION_VERIFIER_FLAGS: 0 FAULTING_THREAD: 0000122c BUGCHECK_STR: APPLICATION_FAULT_BAD_INSTRUCTION_PTR_INVALID_POINTER_READ_WINDOW_HOOK

CR:606807

CR Number:   606807 Product Name:   PB Enterprise Product Component:   DB ADO.NET Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Dec 2009 Fixed Description Request for a localized build that includes the fix for CR 580960 "SQLServer incorrect generation -exec sp_executesql- with index varchar columns" for the SNC and ADO.net driver

CR:606817

CR Number:   606817 Product Name:   PB Enterprise Product Component:   PB Web Services Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jan 2010 Fixed Description PB 11.5: Performance problem with .NET Web service engine when using byte array

CR:606868

CR Number:   606868 Product Name:   PB Enterprise Product Component:   Installation Status:   Open OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The PB 11.5 DVD (pb1150prodwin32.zip), English version from the SPDC includes a file, RuntimeEdition.html, which includes info on deploying the runtime version of SQL Anywhere but is in Chinese Simplified so customers cannot read it. With PB 11.5 there is no separate install for the Runtime version of the database server. English version of RuntimeEdition.html: SQL Anywhere 11 Runtime Edition Version 11.0.0 June 2008 Runtime Edition overview The Runtime Edition of SQL Anywhere is a special version of the SQL Anywhere database server. It is intended for use as a low-cost deployment option where the full functionality of SQL Anywhere is not required. Feature summary The Runtime Edition of SQL Anywhere has the following features. It is a single-user, transaction-processing database server. It supports up to 10 same-machine connections. It fully supports the DML subset of SQL commands, such as SELECT, INSERT, UPDATE, and DELETE. It provides full referential integrity, including cascading updates and deletes. It supports declared temporary tables. It allows users to be added to a database. Supported operating systems The Runtime Edition is available for Windows XP/200x (both 32 bit and 64 bit) and Windows Mobile. Runtime Edition features The SQL Anywhere Runtime Edition is a restricted version of the SQL Anywhere personal database server. Runtime and personal server differences The functions supported by the SQL Anywhere personal database server that are not fully supported in the Runtime database server are as follows: Function supported by personal database server How it operates in the Runtime Edition Executable name: dbeng11.exe The executable name is rteng11.exe. You must ensure that any ODBC data sources and command lines you distribute reflect this executable name. This executable name can be used in configuration files with conditional parsing. Replication and synchronization You cannot replicate data using either MobiLink or SQL Remote, or by any other means. ALTER statements You cannot use any of the ALTER statements. CREATE statements You can use CREATE VARIABLE to create SQL variables. SQL variables do not form part of the database definition. You cannot use any other CREATE statements. COMMENT statement You cannot add comments to the system tables. DROP statements You cannot use any of the DROP statements to drop a database object from the system tables. CALL/EXEC statement You cannot invoke stored procedures, including system procedures. Consequently, you cannot obtain procedure profiling information. GRANT statement You can grant the special user permissions (CONNECT, DBA, RESOURCE, GROUP, MEMBERSHIP IN GROUP) using GRANT, but you cannot change permissions on tables and views. REVOKE statement You can revoke the special user permissions using REVOKE, but you cannot change permissions on tables and views. Triggers Triggers are not fired by the Runtime Edition. Events You cannot add events to a database. No transaction log To simplify database administration, the Runtime Edition does not employ a transaction log. Users should back up their databases by making copies of their database file. If a Windows General Protection Fault or a power failure occurs during a standard operation, the database file may be corrupted. Because there is no transaction log, failed transactions cannot be recovered. Auditing is not supported because there is no transaction log. Heterogeneous query support You can only issue queries to a single database. You cannot access data from external databases using the Runtime Edition. Adaptive Server Enterprise/Microsoft SQL Server compatibility INSERT, UPDATE, DELETE, and SELECT statements can be common between Adaptive Server Enterprise and the Runtime Edition. However, the advanced syntax feature is not supported in the Runtime Edition. Database logic cannot be reused within a SQL Server database because the Runtime Edition does not support stored procedures. The Runtime Edition does not support Open Server or Open Client, and none of the SQL Server connectivity tools or applications work against the Runtime Edition database server. Communication encryption You cannot encrypt communications in the Runtime Edition. Database file encryption You cannot encrypt database files that are used by the Runtime Edition. The database server options that refer to transaction logs (-a, -f) Not applicable to the Runtime Edition. The dbbackup options that refer to transaction logs (-r, -t, -x) Not applicable to the Runtime Edition. INSTALL statement You cannot install Java classes. JDBC access from client applications The Runtime Edition supports JDBC applications using the iAnywhere JDBC driver. The Runtime Edition does not support applications using jConnect for JDBC access. Java in the database You cannot store or execute Java classes in a database used by the Runtime Edition. You must use an external environment. Web services Web services are not supported. Table encryption Table encryption is not supported. Application profiling and diagnostic tracing Application profiling and diagnostic tracing are not supported. Redistributable components This section lists the components that are redistributable under your SQL Anywhere Runtime software license. The Runtime Edition is licensed for standalone use only. If you plan to use SQL Anywhere within the context of an application server, web-server, multi-plexors and/or synchronization, you must license the full edition of SQL Anywhere. Deployment issues are also discussed in the section "Deploying databases and applications" of the book SQL Anywhere Server - Programming. Windows XP/200x Redistributable files for Windows XP/200x are held in the bin32 or bin64 directory under your SQL Anywhere installation directory. For Windows Mobile they are held in CE\ARM.50. If your application uses ODBC, your users need ODBC installed on their computer. Contact Microsoft for information about redistributing ODBC. The following files can be redistributed under the software license. File Description dbbackup.exe Utility to back up a database. dbcoen11.chm Help file for connections and ODBC configuration. dbcon11.dll ODBC connection window. dbctrs11.dll Database server DLL. dbdsn.exe Utility to create, delete, describe, and list SQL Anywhere ODBC data sources. dberase.exe Utility to erase a database. dbicu11.dll Required only if the database character set is multi-byte or if the UCA collation sequence is used. dbicudt11.dat Required for ICU on Windows Mobile. dbicudt11.dll Required for ICU on Windows XP/200x. dbinfo.exe Utility to display information about a database. dbisqlc.exe SQL command processor. dbjodbc11.dll iAnywhere JDBC driver. dblgen11.dll Language-specific strings for interface and server. dblib11.dll Embedded SQL interface DLL. dbodbc11.dll ODBC driver DLL. dboledba11.dll OLE DB provider support utility. dboledb11.dll OLE DB provider. dbserv11.dll Database server DLL. dbstop.exe Utility to stop a database server. dbsvc.exe Utility to create, delete, and modify SQL Anywhere services. dbtool11.dll Database tools utility DLL. dbtsinfo.exe Technical support utility. dbvalid.exe Utility to validate a database iAnywhere.Data.SQLAnywhere.dll policy.11.0.iAnywhere.Data.SQLAnywhere.dll .NET Data Provider utility. These files are installed in install-dir\Assembly\v2. jodbc.jar iAnywhere JDBC driver. This file is installed into the java subdirectory. rteng11.exe Runtime database server. sqlany.cvf Character set conversion mappings. util_db.ini Specifies the password to use when connecting to the utility database.

CR:606869

CR Number:   606869 Product Name:   PB Enterprise Product Component:   Documentation Status:   Open OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Fixed Description With PB 11.5 there is no separate install for the Runtime version of the database server. English version of RuntimeEdition.html: SQL Anywhere 11 Runtime Edition Version 11.0.0 June 2008 Runtime Edition overview The Runtime Edition of SQL Anywhere is a special version of the SQL Anywhere database server. It is intended for use as a low-cost deployment option where the full functionality of SQL Anywhere is not required. Feature summary The Runtime Edition of SQL Anywhere has the following features. It is a single-user, transaction-processing database server. It supports up to 10 same-machine connections. It fully supports the DML subset of SQL commands, such as SELECT, INSERT, UPDATE, and DELETE. It provides full referential integrity, including cascading updates and deletes. It supports declared temporary tables. It allows users to be added to a database. Supported operating systems The Runtime Edition is available for Windows XP/200x (both 32 bit and 64 bit) and Windows Mobile. Runtime Edition features The SQL Anywhere Runtime Edition is a restricted version of the SQL Anywhere personal database server. Runtime and personal server differences The functions supported by the SQL Anywhere personal database server that are not fully supported in the Runtime database server are as follows: Function supported by personal database server How it operates in the Runtime Edition Executable name: dbeng11.exe The executable name is rteng11.exe. You must ensure that any ODBC data sources and command lines you distribute reflect this executable name. This executable name can be used in configuration files with conditional parsing. Replication and synchronization You cannot replicate data using either MobiLink or SQL Remote, or by any other means. ALTER statements You cannot use any of the ALTER statements. CREATE statements You can use CREATE VARIABLE to create SQL variables. SQL variables do not form part of the database definition. You cannot use any other CREATE statements. COMMENT statement You cannot add comments to the system tables. DROP statements You cannot use any of the DROP statements to drop a database object from the system tables. CALL/EXEC statement You cannot invoke stored procedures, including system procedures. Consequently, you cannot obtain procedure profiling information. GRANT statement You can grant the special user permissions (CONNECT, DBA, RESOURCE, GROUP, MEMBERSHIP IN GROUP) using GRANT, but you cannot change permissions on tables and views. REVOKE statement You can revoke the special user permissions using REVOKE, but you cannot change permissions on tables and views. Triggers Triggers are not fired by the Runtime Edition. Events You cannot add events to a database. No transaction log To simplify database administration, the Runtime Edition does not employ a transaction log. Users should back up their databases by making copies of their database file. If a Windows General Protection Fault or a power failure occurs during a standard operation, the database file may be corrupted. Because there is no transaction log, failed transactions cannot be recovered. Auditing is not supported because there is no transaction log. Heterogeneous query support You can only issue queries to a single database. You cannot access data from external databases using the Runtime Edition. Adaptive Server Enterprise/Microsoft SQL Server compatibility INSERT, UPDATE, DELETE, and SELECT statements can be common between Adaptive Server Enterprise and the Runtime Edition. However, the advanced syntax feature is not supported in the Runtime Edition. Database logic cannot be reused within a SQL Server database because the Runtime Edition does not support stored procedures. The Runtime Edition does not support Open Server or Open Client, and none of the SQL Server connectivity tools or applications work against the Runtime Edition database server. Communication encryption You cannot encrypt communications in the Runtime Edition. Database file encryption You cannot encrypt database files that are used by the Runtime Edition. The database server options that refer to transaction logs (-a, -f) Not applicable to the Runtime Edition. The dbbackup options that refer to transaction logs (-r, -t, -x) Not applicable to the Runtime Edition. INSTALL statement You cannot install Java classes. JDBC access from client applications The Runtime Edition supports JDBC applications using the iAnywhere JDBC driver. The Runtime Edition does not support applications using jConnect for JDBC access. Java in the database You cannot store or execute Java classes in a database used by the Runtime Edition. You must use an external environment. Web services Web services are not supported. Table encryption Table encryption is not supported. Application profiling and diagnostic tracing Application profiling and diagnostic tracing are not supported. Redistributable components This section lists the components that are redistributable under your SQL Anywhere Runtime software license. The Runtime Edition is licensed for standalone use only. If you plan to use SQL Anywhere within the context of an application server, web-server, multi-plexors and/or synchronization, you must license the full edition of SQL Anywhere. Deployment issues are also discussed in the section "Deploying databases and applications" of the book SQL Anywhere Server - Programming. Windows XP/200x Redistributable files for Windows XP/200x are held in the bin32 or bin64 directory under your SQL Anywhere installation directory. For Windows Mobile they are held in CE\ARM.50. If your application uses ODBC, your users need ODBC installed on their computer. Contact Microsoft for information about redistributing ODBC. The following files can be redistributed under the software license. File Description dbbackup.exe Utility to back up a database. dbcoen11.chm Help file for connections and ODBC configuration. dbcon11.dll ODBC connection window. dbctrs11.dll Database server DLL. dbdsn.exe Utility to create, delete, describe, and list SQL Anywhere ODBC data sources. dberase.exe Utility to erase a database. dbicu11.dll Required only if the database character set is multi-byte or if the UCA collation sequence is used. dbicudt11.dat Required for ICU on Windows Mobile. dbicudt11.dll Required for ICU on Windows XP/200x. dbinfo.exe Utility to display information about a database. dbisqlc.exe SQL command processor. dbjodbc11.dll iAnywhere JDBC driver. dblgen11.dll Language-specific strings for interface and server. dblib11.dll Embedded SQL interface DLL. dbodbc11.dll ODBC driver DLL. dboledba11.dll OLE DB provider support utility. dboledb11.dll OLE DB provider. dbserv11.dll Database server DLL. dbstop.exe Utility to stop a database server. dbsvc.exe Utility to create, delete, and modify SQL Anywhere services. dbtool11.dll Database tools utility DLL. dbtsinfo.exe Technical support utility. dbvalid.exe Utility to validate a database iAnywhere.Data.SQLAnywhere.dll policy.11.0.iAnywhere.Data.SQLAnywhere.dll .NET Data Provider utility. These files are installed in install-dir\Assembly\v2. jodbc.jar iAnywhere JDBC driver. This file is installed into the java subdirectory. rteng11.exe Runtime database server. sqlany.cvf Character set conversion mappings. util_db.ini Specifies the password to use when connecting to the utility database.

CR:607943

CR Number:   607943 Product Name:   PB Enterprise Product Component:   Installation Status:   Closed OS:   Windows XP Original Version:   11.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Mar 2010 Fixed Description Crash dump analysis request. Customer install crashes when selecting next on the "license type" screen in the PB 11.1 install.

CR:608078

CR Number:   608078 Product Name:   PB Enterprise Product Component:   Window - Runtime Status:   Open OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Problems with multiselect property when it is changed in eg. constructor event or open event of a window on which the listbox resides. The dotted focus rectangle behaves wrong. Workaround: There seems to be a timing issue in event sequence when the multiselect property is changed in either constructor event or open event of a window on which the listbox resides. After moving the codeline lb_1.multiselect = TRUE from constructor of lb_1 on the sheet window to the getfocus() event of lb_1 it works ok. Similar in the response window sample part, if the multiselect change part is put into the eg. show() event of the window, or if that code section is posted from the open event, it worked fine. Workaround Description  Workaround: There seems to be a timing issue in event sequence when the multiselect property is changed in either constructor event or open event of a window on which the listbox resides. After I eg. moved the codeline lb_1.multiselect = TRUE from constructor of lb_1 on the sheet window to the getfocus() event of lb_1 it worked ok. Similar in the response window sample part, if the multiselect change part is put into the eg. show() event of the window, or if that code section is posted from the open event, it worked fine.

CR:608081

CR Number:   608081 Product Name:   PB Enterprise Product Component:   PB Web Services Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Nov 2009 Not a Bug Description Failed to call a php WebService method with .Net engine.

CR:608088

CR Number:   608088 Product Name:   PB Enterprise Product Component:   DW Painter Status:   Open OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description DataWindow Painter: In the Control List selecting a text object or a button object marks the DataWindow as modified. This does not happen for a column object, a picture, a line, oval or other graphical object or a computed field.

CR:608097

CR Number:   608097 Product Name:   PB Enterprise Product Component:   PB.NET WebForm Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Apr 2010 Fixed Description OS: Windows XP SP3 Versions and Build #s Tested: PB 11.5.1_4608 Database/Driver File/Version: ASA 11.0 with sample EASDemoDB V115 Comments: Decimal format does not follow regional settings when generating PDF from dw report based on stored procedure resultset. Also, datawindow displays incorrect decimal format within nested reports. Issue happens with webforms, only. Works fine in Native PB (client/server).

CR:608292

CR Number:   608292 Product Name:   PB Enterprise Product Component:   Jaguar Integration Status:   Closed OS:   Solaris 2.8 Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Oct 2010 Not reproducible with latest version of the product available as of Resolution Date Description Customer has a PB 11.5/EAS 6.3 application that crashes on the following line of code when EAS is on Solaris but does not crash when on Windows. ds_data.Object.DataWindow.Data.HTML

CR:608309

CR Number:   608309 Product Name:   PB Enterprise Product Component:   Rich Text Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Dec 2009 Fixed Description When entering data into merge fields in an RTE control on a Vista machine, the whole document below the entry point starts to shift and move like it is wrapping. Doesn't happen on XP.

CR:608340

CR Number:   608340 Product Name:   PB Enterprise Product Component:   DW - Runtime Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2010 Not a Bug Description Page numbering is incorrect for a group datawindow that has a large text field. When paging thru the psr, you can see it displays Page 1 of 3, Page 2 of 3, Page 2 of 3. It should be display Page 1 of 3, Page 2 of 3, Page 3 of 3. RESOLUTION: Not a PB Bug. From PowerBuilder User's Guide manual, Chapter 25 Using Nested Reports Working with nested reports --> Using options for nested reports --> Using the Autosize Height option Handling large rows To avoid multiple blank pages or other anomalies in printed reports, never create a DataWindow object with a data row greater than the size of the target page. To handle large text-string columns, break the large string into a series of small strings. The smaller strings are used to populate individual data rows within a nested report instead of using a single text column with an autosized height. RESOLUTION: Not a PB bug

CR:608672

CR Number:   608672 Product Name:   PB Enterprise Product Component:   P-Code Deployment Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Dec 2009 Not reproducible with latest version of the product available as of Resolution Date Description PB 11.5 application often crashes on Windows 7.

CR:608703

CR Number:   608703 Product Name:   PB Enterprise Product Component:   PB.NET Status:   Open OS:   Microsoft Windows 2003 Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Comparing with c# .net web service, the customer found PB web service has bad performance when running embeded SQL, which affects their application's performance. They wish PB improve it as soon as possible.

CR:608793

CR Number:   608793 Product Name:   PB Enterprise Product Component:   DW - Runtime Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Dec 2009 Fixed Description Multi-lines Column in datawindow ,with background color expression, and has the FIRST tab order, the background color cannot be changed completely under certain tab key condition. When the problem happens, two different of color exist on the same column. i.e. Lines with empty space, Lines with characters and last line get different colors.

CR:609403

CR Number:   609403 Product Name:   PB Enterprise Product Component:   PB.NET WebForm Status:   Closed OS:   Windows 7 Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Dec 2009 Fixed Description For PowerBuilder WebForm application on Windows 7 IIS7.5 with default settings, creating permanent user will fail when trying to open UserInit.aspx page. Error info given by IE may look like: Server Error in '/myapp' Application. -------------------------------------------------------------------------------- Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed. You can get detailed info on WebForm permanent user from PowerBuilder HTML Help -->Deploying Applications and Components to .NET -->WebForm targets -->Chapter 4 User Management and Registry Operations in Web Forms A workaround for this issue is to change the PBAppPool's identity from ApplicationPoolIdentity to NetworkService in IIS management console.

CR:609420

CR Number:   609420 Product Name:   PB Enterprise Product Component:   DW Edit Mask Status:   Open OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The checkmark in a DataWindow column is not displayed when the Window text color is configured dark red\brown within the control panel for Windows Classic Style controls. This happens only for this color Red=128, Green=0, Blue=0 If you adjust the Green and Blue from 0 to 1 in the control panel then the check boxes are displayed.

CR:610093

CR Number:   610093 Product Name:   PB Enterprise Product Component:   DW - Runtime Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jan 2010 Fixed Description A highlighted column gets blinking when scrolling DataWindow with Horizontal scroll bar .

CR:610102

CR Number:   610102 Product Name:   PB Enterprise Product Component:   PB Web Services Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jan 2010 Fixed Description How to set URL exceptions / bypass proxy with SetProxyServer method for PB 11.5.1 .NET ?

CR:610105

CR Number:   610105 Product Name:   PB Enterprise Product Component:   DB Oracle Status:   Open OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Dec 2009 Third Party Problem Description Binding problem with a CHAR(n) column and ODBC interface.

CR:610128

CR Number:   610128 Product Name:   PB Enterprise Product Component:   Workspace and Targets Status:   Open OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description There is much confusion by customers relative to the use of the PB 11.5 Powerbuilder .ini files including pb.ini and pbodb115.ini and which one is being used. For years powerbuilder developers had altered their ini file located in C:\Program Files\Sybase\PowerBuilder 11.5 now in powerbuilder 11.5 the ini files that are actually used are in C:\Documents and Settings\user\Local Settings\Application Data\Sybase\PowerBuilder 11.5 Having the .ini files in two locations causes much confusion for our customers. Worse the ini files that are actually used, are hidden and do not show up on a search! Is there any good reason for the duplication of these files? I believe the .ini files left in C:\Program Files\Sybase\PowerBuilder 11.5 should be deleted.

CR:610131

CR Number:   610131 Product Name:   PB Enterprise Product Component:   OLE - Active X - OCX Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2010 Third Party Problem Description When running a word macro from PB OLE, the document looses the formatting. The results of the macro in the word document is the format is not the same as the rest of the document. RESOLUTION: Not a PowerBuilder issue.

CR:610140

CR Number:   610140 Product Name:   PB Enterprise Product Component:   DB OLE DB Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Apr 2012 Added to user documentation Description Please document that the time and date datatypes are no longer supported using OLEDB and MSSQL Server 2008. Please document the timestamp datatype for OLEDB and MSSQL Server 2008 will be fixed in PB 12. this is according to cr586186

CR:610487

CR Number:   610487 Product Name:   PB Enterprise Product Component:   Language - Compiler Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Dec 2009 Fixed 14 Jan 2010 Fixed Description Conditional directive test fails after using #ELSEIF directive.

CR:610492

CR Number:   610492 Product Name:   PB Enterprise Product Component:   Machine Code Exe Creation Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jan 2010 Fixed Description When passing commandline arguments with umlaute, they will be received incorrectly in machine code executable. If you call eg. receiver abc周咪鳇xyz in cmd, it will be received as receiver.exe (applications's open event): MessageBox( "....", commandline ) -> "abc-_鞒xyz" Workaround: P-code exe will work ok. Workaround Description  Workaround: P-code exe will work ok.

CR:610949

CR Number:   610949 Product Name:   PB Enterprise Product Component:   DW - Runtime Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jan 2010 Fixed Description Transparency not working when Font.Escapement is set.

CR:611581

CR Number:   611581 Product Name:   PB Enterprise Product Component:   Source Control Status:   Open OS:   Windows XP Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Allow DataWindow object check-out from within the window painter ie. after modify datawindow is selected in the rmb menu. When The developer try to modify the datawindow PB need to display a message asking if you want to check it out (if it possible). This would speed up and ease development.

CR:611614

CR Number:   611614 Product Name:   PB Enterprise Product Component:   DB MS SQLServer Status:   Open OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When using the SNC driver and staticbind=0, a datawindow returns the following error: Select Error: Column lists do not match The error happens when returning values from a stored procedure. The error happens at runtime. It works ok when retrieving from the dw painter. Customer is staticbind=0 to workaround an issue with the bit datatype. If they use staticbind=1, than it works ok but then they run into the issue with the bit datatype (cr463142).

CR:612016

CR Number:   612016 Product Name:   PB Enterprise Product Component:   DB Oracle Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jan 2010 Fixed Description Description of Problem: Allow caching of large Package specification with oracle db interface driver. Currently we retrieve the Package spec often and therefore cause network traffic. This can be problematic in slow network speed environments.

CR:612254

CR Number:   612254 Product Name:   PB Enterprise Product Component:   Window - Runtime Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 May 2010 Work as design Description Crash dump analysis required. call stack is: > PBDWE115.DLL!DWTable::ChangeTableValue(unsigned short * newValue=0x00000000, long dddw_currow=0) Line 312 + 0x15 bytes C++ PBDWE115.DLL!DWDataWindow::AcceptText(long lParam=0, unsigned int wParam=0) Line 42 + 0x14 bytes C++

CR:612467

CR Number:   612467 Product Name:   PB Enterprise Product Component:   DB MS SQLServer Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jan 2010 Not a Bug Description Using the SNC driver and dbparm of spcache=0 results in executing sp_procedure_xx_params_rowset many times. Using spcache=0 to workaround null problem (related to cr587611). From SQL Profiler, you can see it is executing sp_procedure_params_rowset many times. RESOLUTION: Since disabling caching of stored procedure information by dbparm SPCache=0, PB needs to get the parameters information from server every time stored procedure is executing, this is what the sp_procedure_xx_params_rowset be used to do. Not a bug.

CR:612697

CR Number:   612697 Product Name:   PB Enterprise Product Component:   DB Oracle Status:   Closed OS:   Windows XP Original Version:   11.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jan 2010 Fixed Description When you update a row using O10/O90 interface with DisableBind=1, the specific characters "->" may be replaced by "pb1.." if the updated data contains a single quotation mark (').

CR:612958

CR Number:   612958 Product Name:   PB Enterprise Product Component:   DW - Runtime Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Feb 2010 Fixed Description Complex composite report with many nested reports. Autosize height is turned on for DataWindow columns defined in the nested report. When data is displayed at the bottom of a page, the data is cut and displayed at the beginning of subsequent page. Workaround Description  easy workaround by increasing the height of each DW column in the nested DW.

CR:613077

CR Number:   613077 Product Name:   PB Enterprise Product Component:   System Runtime Functions Status:   Open OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description asca(x) function returns certain value incorrectly depending on regional settings. The problem is already in the argument x = string(blobmid(lb_file_contents, i, 1), encodingANSI!)

CR:613410

CR Number:   613410 Product Name:   PB Enterprise Product Component:   OLE - Active X - OCX Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11.0 21 Mar 2010 Fixed Description Wrong text displayed over a blob column.

CR:613892

CR Number:   613892 Product Name:   PB Enterprise Product Component:   Function Painter Status:   Open OS:   Windows XP Original Version:   11.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Declaring Instance Variables after show/hide of prototype window causes GPF of PB.

CR:614161

CR Number:   614161 Product Name:   PB Enterprise Product Component:   Jaguar Integration Status:   Closed OS:   Linux Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Oct 2010 Fixed Description DirectoryExists PowerScript function does not work.

CR:614366

CR Number:   614366 Product Name:   PB Enterprise Product Component:   Jaguar Integration Status:   Closed OS:   Linux Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Oct 2010 Fixed Description ProfileString function returns wrong value when defaultvalue is blank

CR:614391

CR Number:   614391 Product Name:   PB Enterprise Product Component:   DW - Runtime Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Apr 2010 Fixed Description When DataWindow Storage To Disk is used then accessing a long type column with an array in dotnotation gives back only Nulls while a string type worked. datawindow.Object.colname.Primary = Array All values of the column in the array are NULL if the column type is long.

CR:614739

CR Number:   614739 Product Name:   PB Enterprise Product Component:   Rich Text Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Apr 2010 Presently Not Targeted For Any Future Release Of This Product Description After migrate PB9 application to PB11.5. Customer discovered that most of her RichText Datawindow reports are distorted. One of the reason is the Tab Stop Size of last line is changed after migrate to PB11.5. Workaround Description  Avoid to have last line with tab key in RTE DW report.

CR:614940

CR Number:   614940 Product Name:   PB Enterprise Product Component:   Rich Text Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Apr 2010 Third Party Problem Description After migrate PB9 application to PB11.5. Customer discovered that most of her RichText Datawindow reports are distorted. One of the reason is the missing Fixedsize input field column properties on the RichText Datawindow control. When the input field coumn is multi-lines , there will be a large distortion on those lines with the column.

CR:614970

CR Number:   614970 Product Name:   PB Enterprise Product Component:   Jaguar Integration Status:   Closed OS:   Linux Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Oct 2010 Fixed Description ProfileString and SeProfileString functions do not search the file using the PATH environment variable.

CR:614972

CR Number:   614972 Product Name:   PB Enterprise Product Component:   DB Oracle Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jan 2010 Fixed Description RPC call to a stored procedure fails when decimal separator is comma.

CR:615241

CR Number:   615241 Product Name:   PocketBuilder Product Component:   DW Printing Status:   Open OS:   Windows XP Original Version:   2.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Fixed Description This is a PocketBuilder 2.5.2 issue. Customer installed Build 1273 which says it fixed this isue: 'Error return values from the printer driver were being dropped. Propogated the return codes to the PrintOpen() and the PrintClose() system functions. ' But it apears to not be working still. We are not able to capture anywhere the fact that the user currently doesn't have the RW220 Zebra Printer turned on when trying to print.

CR:615363

CR Number:   615363 Product Name:   PB Enterprise Product Component:   PB.NET WebForm Status:   Closed OS:   Windows 7 Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jan 2010 Third Party Problem Description For PowerBuilder WebForm application on Windows 7 IIS7.5, DataWindow SaveAs(pdf) and Print fail to work, SaveAs() returns -1 although you have set IIS_IUSRS full control permissions to Sybase DataWindow PS printer. A workaround for this issue is to change the PBAppPool's identity from ApplicationPoolIdentity to NetworkService in IIS management console.

CR:615411

CR Number:   615411 Product Name:   PB Enterprise Product Component:   Jaguar Integration Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Nov 2010 Third Party Problem Description Calling pb components and EAServer process goes to 100 cpu usage. Dump files included. RESOLUTION: Oracle patches resolved issue. Oracle patch 9233830 (Bundle 31) and patch 5893079 were applied to Oracle 10g client. Patch 5893079 was applied to Oracle 10.2.0.4 server.

CR:615445

CR Number:   615445 Product Name:   PB Enterprise Product Component:   WPF System Tree Status:   Open OS:   AIX 4.2 Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description From Newsgroup - 14-Jan-2010 I have a C# assembly (SureWest.Operations.Clients) that references another C# assembly (SureWest.Operations.Common). When I add a reference to SureWest.Operations.Common in PB.NET the IDE can reflect over the assembly and show the types in it; however, when I reference SureWest.Operations.Clients, the IDE doesn't show any of the types. This happens whether I have SureWest.Operations.Common referenced or not. My Response: This behavior looks like when reflecting over the (Operations.Clients) assembly, the IDE is not finding the assembly that is referenced the 'base' (Operations.Common). If the two assemblies are neither in the GAC nor on the PATH, then this is probably what would happen. I'm not sure what happens if the two assemblies are in the _same_ directory, which itself is neither the GAC nor in the PATH (I'll give that a look in a bit).

CR:615658

CR Number:   615658 Product Name:   PB Enterprise Product Component:   Shared Objects Status:   Open OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Three issues with SetLibraryList. 1) If you include the exe in the new string, then you get the exe twice in the resulting library list. The documentation says it should be ignored. 2) If you do a setlibrarylist in the application open event and set the list to the same files (with or without the extra exe) as were originally in the list. Then start a sharedobject, do a SetLibraryList call in the SharedObject, the library list is not good. It can't find objects in the pbds in the list. 3) If you make changes to the library list with setlibrarylist, and then you start up a sharedobject. The getlibrarylist in the sharedobject thread does not get the changes you made to the library list. It gets the original default library list.

CR:615798

CR Number:   615798 Product Name:   PB Enterprise Product Component:   PB.NET Status:   Closed OS:   Windows 7 Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jan 2010 Not a Bug Description For PowerBuilder .NET WebForm client applications to connect with EAServer using the Secure Sockets Layer (SSL), mutual authentication will fail on Windows 7 with IIS7.5. You can get detailed info on .NET client SSL from PowerBuilder HTML Help -->Deploying Applications and Components to .NET -->.NET Language Interoperability -->Chapter 15 Building .NET client for EAServer -->SSL connection support. A workaround for this issue is to change the PBAppPool's identity from ApplicationPoolIdentity to NetworkService in IIS management console.

CR:615848

CR Number:   615848 Product Name:   PB Enterprise Product Component:   Jaguar Integration Status:   Closed OS:   Linux Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Oct 2010 Fixed Description OS: Linux Red Hat 5 Versions and Build #s Tested: PBVM 11.5.1_4608 on EAServer 6.3.0.06 Advanced Edition for Linux The issue happens when dw container has a datawindow a with Spin Control inside it. It resides in PBVM 11.5.1_4608. On EAServer 6.x on Windows, all works fine.

CR:615850

CR Number:   615850 Product Name:   PB Enterprise Product Component:   DB Sybase System Status:   Open OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Custoemr wants ISQL Painter when connected to ASE databases with SYC or ASE drivers to handle batch processing. For example a group of statements like this: declare @id char(9) select @id = "LAUER" select @id ; This should return a resultset of "LAUER". This works fine with SNC. Customer would like the same capability for SYC and ASE connections.

CR:615860

CR Number:   615860 Product Name:   PB Enterprise Product Component:   DW - Runtime Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Feb 2010 Fixed Description 02/10/2010: This CR was fixed in 11.5.1 builds 4695 and after. Customer went from PB 8 to 11.5 and are having a crash problem with reselectrow. He found CR 563133 which was similar and fixed around Mar 11, 2009. But he has upgraded to 11.5.1 which is well after that and is still having the problem. His problem occurs under these conditions: The underlying table has no primary key defined, but does have an unique clustered index defined. The datawindow has the index unique defined as primary key in the update properties. When running the attached application, the application will crash if the record whose key value is empty is updated and then reselected.

CR:615975

CR Number:   615975 Product Name:   PB Enterprise Product Component:   OLE - Active X - OCX Status:   Open OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Using InsertFile on an ole control and accessing the ObjectData caused a runtime error Bad runtime function reference on a certain PDF file that contained scanned images.

CR:615986

CR Number:   615986 Product Name:   PB Enterprise Product Component:   OLE - Active X - OCX Status:   Open OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When using OLE InsertFile on a certain PDF file an error -9 is returned.

CR:616159

CR Number:   616159 Product Name:   PB Enterprise Product Component:   Jaguar Integration Status:   Closed OS:   Linux Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2012 Fixed Description SetProfileString function adds some Control Characters to the file.

CR:616170

CR Number:   616170 Product Name:   PB Enterprise Product Component:   System Runtime Functions Status:   Open OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Please resolve difference or at least document: setitem - getitem throws a runtime exception when accessing a value that is not existant, accessing via dot notation does not. assigning a value using dot notation inserts a row implicetely, for setitem an insertrow is needed.

CR:616380

CR Number:   616380 Product Name:   PB Enterprise Product Component:   Jaguar Integration Status:   Open OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description EAS is crashing when the application calls a PB11.5 component which executes a MSSQL2005 stored procedure via DECLARE/EXECUTE statements. Migration from PB9 to PB11.5. -> worked in PB9 PBVM, ->Regression. Workaround Description  workaround is to declare as external function RPC call.

CR:616399

CR Number:   616399 Product Name:   PB Enterprise Product Component:   Window - Runtime Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Mar 2010 Fixed Description The customer has a complex PFC app and on windows that have command buttons, if another window is opened from the already open window the text in the buttons on the first window appear a second time in a different position during the delay before the second window is opened. Once the second window is open everything is OK, but for the second or 2 delay, it gets kind of messy and unprofessional looking. The app was migrated from PB 9.0.3 to PB 11.5. They are using the Open Source 11 version of PFC.

CR:616412

CR Number:   616412 Product Name:   PB Enterprise Product Component:   Jaguar Integration Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Oct 2010 Fixed Description Powerbuilder OS: Windows XP SP3 Versions and Build #s Tested: - Powerbuilder 11.5.1_4608 - PBVM 11.5.1_4608 on EAServer 6.3.0.06 Advanced Edition for Linux on Linux Red Hat 5.0 Database/Driver File/Version: N/A When Using SetFullState after SetFilter/Filter on datastore, PB client crashes. I could isolate the issue has to do when connecting to PBVM 11.5.1_4608 on Linux. I installed same Linux PBVM 11.5.1_4608 on EAServer 6.2 and 6.3 (both on Linux machine) and issue is always reproduceable. Issue does not happen if connecting to PBVM 11.5.1 on EAServer 6.3/Windows instead.

CR:616414

CR Number:   616414 Product Name:   PB Enterprise Product Component:   Jaguar Integration Status:   Closed OS:   Windows XP Original Version:   11.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Nov 2010 Workaround 17 Feb 2010 Workaround Description Calling a pb webservice from Eclipse causes an exception in thread error in EAServer. The error in the eas log is: Exception in thread "btpool0-1" java.lang.StackOverflowError at com.sybase.jaguar.server.JaguarObject.invoke(Native method) at com.sybase.jaguar.server.JaguarObject.invoke (JaguarObject.java.303) at com.sybase.jaguar.server.JaguarObject.invoke (JaguarObject.java:97) at com.sybase.jaguar.server.JaguarObject_DJC.invoke (JaguarObject_DJC.java:341) at ejb.components.keystoneseq.n_keyeasseq_nvo_EJB.of_get_system_datetime(n_keyeasseq_nvo_EJB.java:92) at ejb.components.keystoneseq.n_keyeasseq_nvoRemote.of_get_system_datetime(n_keyeasseq_nvoRemote.java:60) at ejb.components.keystoneseq.n_keyeasseq_nvoRemote_DJC.access$801(n_keyeasseq_nvoRemote_DJC.java:4) It works ok using a PB client calling the webservice. It works the first time invoking the webservice from Eclipse. RESOLUTION: Changed the pb code to use the SYJ driver instead of the jdbc driver.

CR:616619

CR Number:   616619 Product Name:   PB Enterprise Product Component:   Language - Runtime Status:   Open OS:   Windows XP Original Version:   11.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Read-only arguments are corrupted.

CR:616641

CR Number:   616641 Product Name:   PB Enterprise Product Component:   DB Oracle Status:   Closed OS:   Windows 7 Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Nov 2010 Not reproducible with latest version of the product available as of Resolution Date Description When connect to Oracle 10g using the O10 driver on windows 7, the table list does not expand in the db painter. The SQL statements to not work in the db painter. RESOLUTION: Cannot reproduce