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

 

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

如有问题,请联系我!

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

 

CR:336850
CR Number:   336850
Product Name:   PocketBuilder
Product Component:   Window - Runtime
Status:   Closed
OS:   Pocket PC 2002
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Oct 2003 Fixed
Description
Picture Control: SetPicture( blob-bitmap ) does not work.



CR:336851
CR Number:   336851
Product Name:   PocketBuilder
Product Component:   DW Printing
Status:   Closed
OS:   Pocket PC 2002
Original Version:   1.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.5 28 Oct 2003 Fixed
Description
Modifing the data source for a window from regular joins to outer

joins, and when the query gets executed, the names of the tables get

chopped off to a few charecters. If I enter the syntax manuallly in the

Data Source it works fine.



CR:336854
CR Number:   336854
Product Name:   PocketBuilder
Product Component:   Script Painter
Status:   Closed
OS:   Pocket PC 2002
Original Version:   1.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.5 28 Oct 2003 Fixed
Description
SQL Paste function works fine in the DB Painter but broken in the Script Painter.



CR:337022
CR Number:   337022
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   Solaris 2.8
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 23 Feb 2004 Fixed
Description
DataWindow Group with new page on Group Break. When save DW as PDF file in XSLFOP format, the break page is lost.



CR:337024
CR Number:   337024
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Aug 2004 Fixed
Description
When using backspace in an edit mask, ####-##-## for example, when cursor is to the left of '-' user cannot revert to continuing to type characters into the mask. Have to use Arrow Keys. When navigating using the arrow keys the cursor jumps as expected and the mask works fine. The mask is not working correctly after backspace is pressed to bring the cursor before a '-'.



no workaround
Workaround Description
 non



CR:337057
CR Number:   337057
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Open
OS:   Microsoft Windows NT
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
For PB 10, it should be a high priority to redesign the Rows->Update Properties and Stored Procedures dialog. This entire issue arose because of the poor UI here. It appears we 'slapped on' a new stored procedure dialog versus rethinking the whole Update Properties scenario. For any datawindow, a developer has the option of a stored procedure OR a SQL statement for each of the three actions of UPDATE, DELETE, and INSERT. A SINGLE dialog should be designed to reflect these options. That dialog could actually allow more flexibility by allowing SQL Updates, Inserts, and Deletes to target individual tables.



CR:337064
CR Number:   337064
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Open
OS:   Microsoft Windows NT
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
PowerBuilder crashes on Datawindow stored procedure update when the application creates the stored procedure to be used in the dw.update.



CR:337075
CR Number:   337075
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 03 Dec 2003 Fixed
Description
Application uses a user event that maps to the pbm_dwnkey event id. The event traps for keys, including KeyDelete! KeyBack!, and KeyInsert! Using PB8, these keys are not trapped. It worked using PB7.



CR:337186
CR Number:   337186
Product Name:   PB Enterprise
Product Component:   Rich Text
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Mar 2004 Fixed
Description
GPF on RichTextEdit controls with selecttextall/Replacetext copyrtf()/pastertf() functions when used many times (in a loop).



CR:337194
CR Number:   337194
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 12 Jun 2006 Fixed
Description
HTML DW in JSP, getting unresolvable validation errors in browser. This only seems to happen with columns that are represented in the DW definition as PB datatype ulong.





no workaround
Workaround Description
 non



CR:337205
CR Number:   337205
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)
28 Oct 2004 Presently Not Targeted For Any Future Release Of This Product
Description
EG. using EAServer 4.2.2 : Strange errors in Jaguar.log file when connecting to Oracle 9 from PB Component via Connection Cache.



Oct 27 11:09:58 2003: Library: 'pbjag90.dll' for component type 'pb90'

Oct 27 11:10:03 2003: OCI9: Session End Error: -2

Oct 27 11:10:03 2003: OCI9: Server Detach Error: -2

Oct 27 11:10:07 2003: AFLIB Message: 18011/11/0: DLL lookup for 'af_dll_lookup()' failed, OS Message: 'oraclient8.dll'



Oct 27 11:10:07 2003: AFLIB Message: 18011/11/0: DLL lookup for 'af_dll_lookup()' failed, OS Message: 'oraclient8.dll'



Oct 27 11:10:07 2003: DLL lookup failed for CM xagetconn

Oct 27 11:10:07 2003: OCI8: Session End Error: -2

Oct 27 11:10:07 2003: OCI8: Server Detach Error: -2



CR:337225
CR Number:   337225
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jun 2005 Fixed
Description
When using the ImportString to import a string of type XML!

and the string contains a character entity of , any text after this value will be on the next row.



The importstring parses the xml. It appears to process the character entity of

as the carriage return. It processes the character entity whether its the ascii

value ( ) or hex value ( ).



CR:337240
CR Number:   337240
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 24 Nov 2003 Fixed
Description
A dddw populated by a getfullstate/setfullstate in which

a filter was applied, causes the dddw to have duplicate rows.





dw_1.retrieve()

dw_1.setfilter("emp_id=102")

dw_1.filter()

dw_1.getfullstate(lblb_data)

dw_2.setfullstate(lblb_data)



CR:337357
CR Number:   337357
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)
8.0.4 18 Nov 2003 Fixed
Description
DataWindow Error using O84 or O90 native interface : Ora-24334 "no descriptor for this position" when a Dynamic cursor is called in RetrieveRow event of the DataWindow.

When using the O73 driver, the retrieve works OK.



CR:337359
CR Number:   337359
Product Name:   PocketBuilder
Product Component:   Function Painter
Status:   Closed
OS:   Windows 2000
Original Version:   1.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Nov 2003 Fixed
Description
If we try to paste a SQL/Cursor statement on the function painter using "Paste Special->SQL..", nothing is pasted on the function painter.



Steps to reproduce problem:

1. Open up the function painter.

2. Right-click and select "Paste Special -> SQL -> Select".

3. Select a table and some columns in the SQL painter. Click "Return" to get back to the function painter.

4. Nothing is pasted on the function painter. The same thing happens if you select "Paste Special -> SQL -> Cursor Declare".



There is a similar problem with the window script painter (CR336854) that has been fixed.



CR:337361
CR Number:   337361
Product Name:   PocketBuilder
Product Component:   Menu Painter
Status:   Closed
OS:   Windows 2000
Original Version:   1.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Nov 2003 Fixed
Description
If we use the SQL Paste function to paste an SQL statement on the menu painter, PPB will crash with an application error.



Steps to reproduce crash:

1. Open up the menu painter.

2. Right click and select "Paste Special -> SQL -> Select".

3. Select a table from "Select Tables" dialog.

4. Select any columns from the table. Enter the approriate into columns for the select.

5. Click on the "Return" button on the SQL painter to return control back to the menu painter. PPB will crash with an application error.



The same crash will occur with other Paste Special functions such as declaring cursors.



CR:337379
CR Number:   337379
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 01 Dec 2003 Fixed
Description
In PowerBuilder 8 and PowerBuilder 9 a crash situation has

been found with a very large modify statement.



CR:337399
CR Number:   337399
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   Solaris 2.8
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 27 Nov 2003 Fixed
Description
Cannot get Euro symbol in a PDF file on Solaris using XSLFOP method.



CR:337475
CR Number:   337475
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jun 2004 Fixed
Description
Line's pen width isn't display by width expression at runtime
Workaround Description
 you can try to use a rectangle object and adjust the height property, if you design a new datawindow.



CR:337550
CR Number:   337550
Product Name:   PocketBuilder
Product Component:   Library Painter
Status:   Closed
OS:   Windows 2000
Original Version:   1.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.5 332 06 Nov 2003 Fixed
Description
I have korean language folders in PC, when this folders are opened in PPB library painter , PPB crashes.



CR:337562
CR Number:   337562
Product Name:   PB Enterprise
Product Component:   DW DDDW
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 17 Nov 2003 Fixed
Description
Multiple calls of SetFilter on a child datawindow (DDDW) in conjunction with changes to the column's background color, crashes Powerbuilder/application.



This works fine in PB 8.0.3 Build 9704. The crash can be delayed by posting the calls to SetFilter() and Filter().



CR:337563
CR Number:   337563
Product Name:   PocketBuilder
Product Component:   Window Painter
Status:   Open
OS:   Pocket PC 2002
Original Version:   1.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Using the App wizard we get a main window of 232 x 260 pixels (claims to be 1097 x 1280 units). using the new window menuitem we get a main window of 238 x 266 pixels (also claims to be 1097 x 1280 units).

To reproduce - New->target->template application then take defaults and see the true size of the generated main window using SPY or some other tool. Compare with file->new->PBobject->window and use SPY on that window (paint surface) to see the difference.



CR:337575
CR Number:   337575
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 13 Nov 2003 Fixed
Description
PowerBuilder 9 and versions of 8 after 8.0.3 crash when generating proxies for a component in EAServer with the prepend package name checked. Suspect it is a length issue; however, identifiers are all less than 40 characters even when succesful in 8.0.3



CR:337710
CR Number:   337710
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Nov 2003 Not a Bug
19 Nov 2003 Fixed
Description
Have a simple PB component returnning a resultset with 30000 rows. It used to work with EAS4.2 but after migrating to EAS 4.2.2, Jaguar crashes in libjcc.dll (see log below).

if I copy the 4.2 libjcc.dll to EAS 4.2.2 it works fine. The reverse crashes EAS4.2.



This is an EAS issue. Problem is fixed in EAS 4.2.2 EBF 11594 which includes a new version on libjcc.dll.



CR:337726
CR Number:   337726
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)
22 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
When hitting the browse button to select the location for the library and then selecting an existing pbl, dragging the *pbl is causing a access violation.



The following is listing is from the crash handler:

Exception code: C0000005 ACCESS_VIOLATION

File Name: C:\WINNT\system32\SHELL32.DLL

File Version: 5.00.3502.6144

Fault address=78325641 Section:Offset=01:00034641



Registers:

EAX:782F53F0

EBX:00000000

ECX:00000000

EDX:0012C510

ESI:0140E970

EDI:001A1408

CS:EIP:001B:78325641

SS:ESP:0023:0012C2B8 EBP:0012C4EC

DS:0023 ES:0023 FS:0038 GS:0000

Flags:00010202



Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

78325641 0012C4EC 001A1408 00000000 0140E990 00000000 Ordinal683+AC9

002E9F03 0012C520 0140E970 001A1408 00000001 00000174 PB_CreateDragDrop+1F3

77B13619 0012C554 001E0540 000303F0 00000000 00000001 StgGetIFillLockBytesOnFile+D111

77B13720 0012C594 000303F0 00000001 001DCE20 001A1408 StgGetIFillLockBytesOnFile+D218

77ADA4B3 0012C5D4 00000000 000303F0 00000000 001DDCB0 CreateDataCache+60B7

77ADA8CA 0012C618 001A1408 001DCE20 001DDCB0 00000000 DoDragDrop+131

77ADAD40 0012C66C 001A1408 001DDCB0 00000007 0012C6D0 DoDragDrop+5A7

783426F5 0012C6A0 00030376 001A1408 00000000 00000007 Ordinal187+78

78373FF0 0012C6D4 001A1408 00000005 001E1140 0000004E Ordinal183+2519

7837492E 0012CA6C 0012CD18 77E172FD 001E1140 001E1140 Ordinal183+2E57

78374F9D 0012CA84 0012CD18 C0000000 0000004E 00624260 Ordinal12+1FB

7831C493 0012CBF8 000703A2 0000004E 00000001 0012CD18 ShellExecuteExW+825

77E3A244 0012CC18 7831BF7F 000703A2 0000004E 00000001 SetProcessWindowStation+4

77E16362 0012CC48 00624260 0000004E 00000001 0012CD18 IsWindowVisible+65D

77E17341 0012CC68 000703A2 0000004E 00000001 0012CD18 SendMessageW+84

7171603F 0012CCF8 001DB580 FFFFFF93 0012CD18 0012CFFC Ordinal337+354

7173874A 0012CD74 000803A0 00000000 0000015F 0000005B PropertySheetW+97

71738A28 0012CD94 001DB580 00000000 0000015F 0000005B PropertySheetW+375

717171B9 0012CF04 000803A0 00000201 00000001 005B015F Ordinal342+415

77E3A244 0012CF24 717160D2 000803A0 00000201 00000001 SetProcessWindowStation+4

77E145E5 0012CFB0 0012CFFC 00000000 77E2EB7D 0012CFFC TranslateMessageEx+625

77E1A792 0012CFE0 00030376 00624318 000B034C 00000001 PeekMessageW+3D

77E33398 0012D01C 00030376 000B034C 00000010 00000001 MessageBoxA+142

77E43ED5 0012D040 76B30000 001D57F0 00000000 76B55E0D CheckRadioButton+CD

77E38B25 0012D060 76B30000 001D57F0 000B034C 76B55E0D RegisterClassExW+EB

77E3EA21 0012D080 76B30000 001D57F0 000B034C 76B55E0D DestroyAcceleratorTable+1B

76B56510 0012D0CC 00000000 00000001 76B39F32 0012D190 0001:00025510 C:\WINNT\system32\comdlg32.dll

76B565B7 0012D158 0012D190 76B3A447 028261BC 00000005 0001:000255B7 C:\WINNT\system32\comdlg32.dll

76B4060E 0012E220 0012E294 76B3A447 10BF48D2 0012E294 dwLBSubclass+2932

76B39E13 014119B4 014119B4 01410640 01407450 0000009E GetSaveFileNameA+E

014119B4 10DCB790 10C58740 00000000 10C59F40 10C59F60 0000:00000000

10C58730 10DCB7F8 10C63320 00000000 10DAA020 10DAA020 obFreeDebug+4D0
Review Status
 4/22/2005

This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release".



CR:337733
CR Number:   337733
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Feb 2004 Fixed
Description
When viewing the dddw.name from the online help or the

datawindow reference manual, it states the following:



A string whose value is the name of the predefined DropDownDataWindow style associated with the column. Named styles are defined in the Database painter and can be reused. Specifying a name that has not been previously defined associates the name with the column but does not define a new edit styleCall GetChild after setting dddw.Name to get a valid reference to the column's DropDownDataWindow



Actually when you run the command:

dw_1.describe("dept_id.dddw.name")



It will return the name of the dddw datawindow object and not the style name. To get the

style name, I used the following:

dw_1.describe("dept_id.edit.name")



CR:337740
CR Number:   337740
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)
14 Jun 2005 Presently Not Targeted For Any Future Release Of This Product
Description
After checking in an object after you branched, the

object will show the out of sync icon after you do a "Refresh Status".



The following is the log file from using sccloglevel=3:



10/31/03 11:17 Source Management Initialization...

Scc Provider: PVCS Source Control Capabilities: 1382070013

UserID:

Project Path: /branch1?PVCS Version Manager?D:\sourcecontroltrunk?

Aux Project Path: ?PVCS Version Manager?D:\sourcecontroltrunk?

Local Project Path: D:\pse-90\10976971\branch1



Diff_Strategy: SccDiff

Scc multi-threading set to TRUE

Connection to source control established

SccDiff(d:\pse-90\10976971\branch1\test1trunk.sra): RC=0

SccDiff(d:\pse-90\10976971\branch1\m_test1trunk_frame.srm): RC=0

SccDiff(d:\pse-90\10976971\branch1\m_test1trunk_sheet.srm): RC=0

SccDiff(d:\pse-90\10976971\branch1\n_test1trunk_sheetmanager.sru): RC=0

SccDiff(d:\pse-90\10976971\branch1\w_test1trunk_about.srw): RC=0

SccDiff(d:\pse-90\10976971\branch1\w_test1trunk_basesheet.srw): RC=0

SccDiff(d:\pse-90\10976971\branch1\w_test1trunk_frame.srw): RC=0

SccDiff(d:\pse-90\10976971\branch1\w_test1trunk_sheet1.srw): RC=6

SccDiff(d:\pse-90\10976971\branch1\w_test1trunk_sheet2.srw): RC=0

SccDiff(d:\pse-90\10976971\branch1\w_test1trunk_sheet3.srw): RC=0

SccDiff(d:\pse-90\10976971\branch1\w_test1trunk_toolbars.srw): RC=0

StatusAndDiff2002: Cache Updated. d:\pse-90\10976971\branch1\test1trunk.pbt Status: 0 (NOT CONTROLLED)

StatusAndDiff2002: Cache Updated. d:\pse-90\10976971\branch1\test1trunk.sra Status: 1 (CONTROLLED)

StatusAndDiff2002: Cache Updated. d:\pse-90\10976971\branch1\m_test1trunk_frame.srm Status: 1 (CONTROLLED)

StatusAndDiff2002: Cache Updated. d:\pse-90\10976971\branch1\m_test1trunk_sheet.srm Status: 1 (CONTROLLED)

StatusAndDiff2002: Cache Updated. d:\pse-90\10976971\branch1\n_test1trunk_sheetmanager.sru Status: 1 (CONTROLLED)

StatusAndDiff2002: Cache Updated. d:\pse-90\10976971\branch1\w_test1trunk_about.srw Status: 1 (CONTROLLED)

StatusAndDiff2002: Cache Updated. d:\pse-90\10976971\branch1\w_test1trunk_basesheet.srw Status: 1 (CONTROLLED)

StatusAndDiff2002: Cache Updated. d:\pse-90\10976971\branch1\w_test1trunk_frame.srw Status: 1 (CONTROLLED)

StatusAndDiff2002: Cache Updated. d:\pse-90\10976971\branch1\w_test1trunk_sheet1.srw Status: 33 (CONTROLLED | OUTOFDATE)

StatusAndDiff2002: Cache Updated. d:\pse-90\10976971\branch1\w_test1trunk_sheet2.srw Status: 1 (CONTROLLED)

StatusAndDiff2002: Cache Updated. d:\pse-90\10976971\branch1\w_test1trunk_sheet3.srw Status: 1 (CONTROLLED)

StatusAndDiff2002: Cache Updated. d:\pse-90\10976971\branch1\w_test1trunk_toolbars.srw Status: 1 (CONTROLLED)

Getting the latest version of selected items . . .

PVCS Source Control Info: /branch1/w_test1trunk_sheet1.srw Checked out revision 1.0.2.0.

Importing w_test1trunk_sheet1.srw . . .

Compiling types for w_test1trunk_sheet1.srw . . .

Regenerating w_test1trunk_sheet1.srw . . .

IMPORT and COMPILE Results. PASS 1 PASS 2 PASS 3

D:\pse-90\10976971\branch1\w_test1trunk_sheet1.srw OK OK OK

SetRefreshStatus: D:\pse-90\10976971\branch1\w_test1trunk_sheet1.srw Status: 1 (CONTROLLED)

Successful get of D:\pse-90\10976971\branch1\test1trunk.pbl(w_test1trunk_sheet1.srw)

Operation Completed

SccDiff(D:\pse-90\10976971\branch1\w_test1trunk_sheet1.srw): RC=6

StatusAndDiff2002: Cache Updated. D:\pse-90\10976971\branch1\w_test1trunk_sheet1.srw Status: 33 (CONTROLLED | OUTOFDATE)
Review Status
 6/15/2005

This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release".



CR:337741
CR Number:   337741
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 07 Dec 2003 Fixed
Description
A problem has been found with scripted events with phGantXControl.ocx

in PowerBuilder 9 around Build 6029 and later but not in PowerBuilder 8.



An access violation occurs due to memory relocation.



CR:337792
CR Number:   337792
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When connecting to PVCS 7.5 for the first time and you click

on the browse button next to the "Project" on the source control tab of the workspace,

you can open the PVCS database but none of the projects show up.



You can create a project thru PB, but the next time you try to connect to PVCS, it

won't find the project.



CR:337800
CR Number:   337800
Product Name:   PocketBuilder
Product Component:   GenApp
Status:   Closed
OS:   Windows 2000
Original Version:   1.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.5 332 06 Nov 2003 Fixed
Description
A workspace with a chinese target name - the workspace can be saved, but when reloaded, that particular target can't be loaded.



CR:337878
CR Number:   337878
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jun 2005 Presently Not Targeted For Any Future Release Of This Product
Description
PowerBuilder 8 and 9.

When using the event view and clicking on scripts within this view,

then under certain circumstance a confusion may occur between

ancestor and descendant scripts.

If ancestor scripts are edited this way then a crash may occur

later when trying to save the script or the object.
Review Status
 [*** Tuesday, June 21, 2005 14:30:35 ***]

This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release".



CR:337912
CR Number:   337912
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Open
OS:   Windows XP
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement request to integrate the PBUnit unit testing tool (PowerBuilder Unit Testing Framework) into the PowerBuilder IDE. Or to provide an easty way to integrate it into PB. This tool allows developers to write and run tests in the PB IDE and to highlight test errors and jump to the line in the test case where it occurred.



PBUnit (http://pbunit.codexchange.sybase.com/) is a unit testing tool based on the JUnit tool written for Java by Eric Gamma and Kent Beck.



CR:337915
CR Number:   337915
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement request to have the display of dwname.Saveas() not give the user the PDF option as this requires external software installed.



CR:337962
CR Number:   337962
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
For performance improvement, bind variables in where clause for the Selectblob and UpdateBlob.



For select and update statements, variables in the where clause can be bind. This

is controlled by the disablebind dbparm. That parm does not have any effect for the

selectblob or updateblob.



The following pbtrace shows the difference in binding for the select and selectblob:



selectblob:

BLOB READ: COLUMN=note TABLE=cbnote CLAUSE= from cbnote WHERE ( cbnote.source_relation ='DEALCO' ) AND ( cbnote.id ='1241-188634' ) AND ( cbnote.cbid ='1230' ) (430 MilliSeconds) LENGTH=19968



select:

select source_relation from cbnote WHERE ( cbnote.source_relation =:1 ) AND ( cbnote.id =:2 ) AND ( cbnote.cbid =:3 )



CR:337966
CR Number:   337966
Product Name:   PocketBuilder
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows 2000
Original Version:   1.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
342 18 Nov 2003 Fixed
Description
First, use insertrow() to make a new DW row, then use setitem() to set its value to a value 3 characters wider than the DB column definition. Issue a dw.update() to save the new row to the DB. Now that the save succeeded, use deleterow() to delete the first row (i.e., the new row), and issue a dw.update() to get rid of the row from the db. This second call to dw.update() causes a GPF at runtime, or using the debugger.
Workaround Description
 The root of the problem (no pun intended)is that watchpoints that are specified

without a fully qualified name (all the way to the root class) automatically

get a "parent.XXX" designation. That should work fine and it does for the current debug session



CR:338032
CR Number:   338032
Product Name:   PB Enterprise
Product Component:   DB Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 pre-beta
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Nov 2004 Fixed
20 Apr 2005 Fixed
Description
The Datatypes Unichar and Univarchar do not exist under Metadata Types folder for ASE12.5 with native driver. But these datatypes are existing for ASE12.5 DB with DataDirect ODBC/DataDirect OLE driver.



CR:338052
CR Number:   338052
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)
11 May 2004 Fixed
Description
When trying to use pbrx90.ocx in the Visual Basic script editor in Excel, you will get a GPF in PBVM90.dll



CR:338067
CR Number:   338067
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Mar 2004 Third Party Problem
Description
SaveAs PDF! file in a COM component not working when called from IIS active page.



This is not a PB bug, but an IIS condition. Under IIS COM runs as a predefined user (an IWAM Account) in the IIS process area. This user account has debugger user privilege. But debugger privilege is not enough for Ghostview to convert to pdf correctly.



As a workaround you can promote the IIS user account to have the Administrator privilege. The IIS user account has a prefix of IWAM. Change the group member from "Debugger users" to "Administrator". This workaround has security implications for IIS. Also note that there is no mechanism for PB to know the results of the PDF creation in IIS. The SaveAs in PB script will return success even if the IIS process is unable to create the PDF file as in this case.



CR:338245
CR Number:   338245
Product Name:   PB Enterprise
Product Component:   PB DOM
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jun 2005 Fixed
Description
GetChildElements returns true even if there are no child elements.



CR:338302
CR Number:   338302
Product Name:   PB Enterprise
Product Component:   DW Printing
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 23 Dec 2003 Fixed
19 Jul 2004 Fixed
Description
Request for a new datawindow function for group reports that have ResetPageCount = yes. This new function would make the absolute page number available to the application and enable the user of the application to script function to print a range of pages in the group report. Several old CRs have reported or requested this in the past ( CR 239084 and 161641 for example) but the new feature has not been implemented.



CR:338305
CR Number:   338305
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 01 Dec 2003 Fixed
23 Dec 2003 Fixed
Description
DragDrop not working correctly for button and picture button controls.



CR:338362
CR Number:   338362
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request for more result option from search facility



CR:338364
CR Number:   338364
Product Name:   PocketBuilder
Product Component:   DW - Runtime
Status:   Closed
OS:   Pocket PC 2002
Original Version:   1.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Nov 2003 Fixed
Description
I have an external datawindow and i created a datastore with it's dataobject assigned to this external datawindow object. I then tried to import a text file (exported from department table) into this datastore. On the device and emulators, the return code of the importfile function is always 0, which means no rows were imported. On the desktop, the importfile function returns 5, which is correct.



When deploying the same application as a PKD. But the fix on this is to always deploy selecting PKD option if external DS or Dynamic DW is used in the application.
Workaround Description
 When deploying the same application as a PKD. But the fix on this is to always deploy selecting PKD option if external DS or Dynamic DW is used in the application.



CR:338390
CR Number:   338390
Product Name:   PocketBuilder
Product Component:   DW - Runtime
Status:   Open
OS:   Pocket PC 2002
Original Version:   1.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
372 Fixed
Description
Issues with an UNUSUAL EditMask.

Notice the value set vs. the value read.



Failed to set data in EditMask Control. MaskType=numeric Mask='000###000' Value Set='123456789' Value Read='123456792'



Failed to set data in DW Column. MaskType=numeric Mask='000###000' Value Set='123456789' Value Read='123456792'



Pass. Test data successfully set in EditMask Control. MaskType=numeric Mask='000###000' data='-123456'



Pass. Test data successfully set in DW Column. MaskType=numeric Mask='000###000' data='-123456'



Failed to set data in EditMask Control. MaskType=numeric Mask='000###000' Value Set='-123456789' Value Read='-123456792'



Failed to set data in DW Column. MaskType=numeric Mask='000###000' Value Set='-123456789' Value Read='-123456792'



CR:338405
CR Number:   338405
Product Name:   PocketBuilder
Product Component:   PB GUI
Status:   Open
OS:   Windows 2000
Original Version:   1.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
360
Description
ActiveSync is required to run Pocket PowerBuilder. The Readme.htm file lists ActiveSync as required to run with Windows CE. The error that occurs is "RAPI.DLL file not found on specified path." There should be a more descriptive error message, and the readme should specify that ActiveSync is required even only to run the IDE, if that is the case.



CR:338416
CR Number:   338416
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement Request: In script painter RMB pop menue, goto item, add all ancestors and decendants.



CR:338457
CR Number:   338457
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)
8.0.4 01 Jan 2004 Fixed
9.0.1 7056 21 Dec 2003 Fixed
12 Jan 2004 Fixed
Description
2 problems are described in this CR.



1) PB crashes while adding an object to source control.

2) Script vanished during "Get Latest Version"
Workaround Description
 Apply this fix or else never close your lib painter instance and re-open it (during the same SCC session) and then try to perform ADD/Remove SCC in the new lib painter.



CR:338487
CR Number:   338487
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 07 Dec 2003 Fixed
Description
A large text column in a dw with an alignment of justify, is cutting off text on the right side.



CR:338510
CR Number:   338510
Product Name:   PB Enterprise
Product Component:   DW Graph
Status:   Closed
OS:   Windows XP
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 29 Jan 2004 Fixed
Description
Data symbols for graph on DW printed as black box.



CR:338527
CR Number:   338527
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)
23 Mar 2004 Not a Bug
Description
Running PB component causes 100% CPU usage. Caused by user error not caught by compiler.Refer to CR 350160 for compiler improvement.



CR:338557
CR Number:   338557
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 19 Jan 2004 Fixed
Description
Syntax LEFT OUTER JOIN conversion from version 11 to 12.5 does not work correctly.

The generated SQL will produce different resultsets.



Workaround:

go into dw -> syntax mode and use the correct syntax:

SELECT a.ida,a.dato,b.ida,b.idb,b.dato FROM a LEFT OUTER JOIN b ON a.ida = b.ida AND b.idb = 2

or, select release 11



CR:338638
CR Number:   338638
Product Name:   PB Enterprise
Product Component:   Window Painter
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 17 Nov 2003 Fixed
Description
In PowerBuilder 8 the painters may crash when working with a tab control that has no visible tab pages.

There is no such gpf in PowerBuilder 9 Build 7031 and later.



CR:338666
CR Number:   338666
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 02 Dec 2003 Fixed
Description
When selecting a column in the DW painter connected to

a Firebird database using the Gemini odbc driver, pb is crashing in the pbdwpxx.dll.



If you close out the properties view in the dw painter or if you turn off the

extended attributes (in the db painter), than no problem. You can click on any column

without PB crashing.



The following is the crash handler from PB 8.0.4:

Exception code: C0000005 ACCESS_VIOLATION

File Name: C:\pb80\Shared\PowerBuilder\PBDWP80.dll

File Version: 8.0.4.10538

Fault address=120A86D4 Section:Offset=01:000A76D4



Registers:

EAX:00000000

EBX:06AD077C

ECX:012CC770

EDX:06DA4ACC

ESI:0664DDC8

EDI:06DA7E90

CS:EIP:001B:120A86D4

SS:ESP:0023:0012F718 EBP:06AD07F0

DS:0023 ES:0023 FS:003B GS:0000

Flags:00010282



Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

120A86D4 0012F728 0664DDC8 00000000 06AD077C 06DA7E90 CMT_DW_TYPE_columnGob::PopulateNameList+44

120A8165 0012F758 06AD38B4 06A7CA74 0012F814 120E5888 CMT_DW_TYPE_columnGob::OnAdjustPropertyView+195

120AB90E 0012F774 06DA7E90 00000000 1208B7CE 06AD0784 CMT_DW_TYPE_esEditGob::OnAdjustPropertyView+1E

12089FDA 0012F780 06AD0784 06DA7E90 00000000 0012F814 CMT_DW_TYPE::MyOnAdjustPropertyView+1A

1208B7CE 0012F7A0 06AD0784 0012F814 00000000 70000025 CDW_ExtraProps::OnAdjustPropertyView+6E

12004701 0012F7B8 06ACD6D8 70000025 0012F814 00000000 CPBWS_DataWindowPainter::OnNotify+321

002EA8DC 0012F7DC 06DB7520 06DA7DA0 70000025 0012F814 CPB_Publisher::Notify+5C

00322238 0012F81C 06AD0780 00000000 0012F97C 06AC2158 CPB_PropertyListView::OnMTTypeSelected+1C8

003222A1 0012F914 06DA7D80 06AC2158 0012F97C 002EA8DC CPB_PropertyListView::OnMTMultiSelect+41

00322050 0012F924 06DA7DA0 70000024 06AC2158 0012F97C CPB_PropertyListView::OnNotify+60

002EA8DC 0012F948 06A7CFF4 00000000 70000024 06AC2158 CPB_Publisher::Notify+5C

120B7CB0 0012F97C 06A8BC34 06DA4ACC 06DA0478 06DA0478 pdwMTSetPrp+140

1203E18B 0012FAD0 06BC6238 06DA0478 00000000 00000001 eventObjectSelect+5FB

1203CC36 0012FAEC 00000000 06DA0478 00000111 000F07BE eventObjectHit+F6

120073AF 0012FC98 00000001 000F07BE 00000002 00000111 CPBWS_DataWindowLayoutView::OnCommand+43F

12013EC5 0012FCB0 06D8DF20 00000111 00020001 000F07BE CPBWS_View::Message+35

12006F4C 0012FCD4 06D8DF20 00000111 00020001 000F07BE CPBWS_DataWindowLayoutView::Message+44C

120E0D4F 0012FCFC 000F0728 00000111 00020001 000F07BE PB_WndProc+12F

77E3A244 C0000000 00000000 00000000 00000000 00000000 SetProcessWindowStation+4



In the odbc sql.log, the following error is listed:

pb90 a00-5fc ENTER SQLExecDirect

HSTMT 025519B0

UCHAR * 0x0012F3F8 [ -3] "select pbe_name, pbe_edit, pbe_type, pbe_cntr, pbe_work, pbe_seqn, pbe_flag from sysdba.pbcatedt order by pbe_name, pbe_seqn\ 0"

SDWORD -3



pb90 a00-5fc EXIT SQLExecDirect with return code -1 (SQL_ERROR)

HSTMT 025519B0

UCHAR * 0x0012F3F8 [ -3] "select pbe_name, pbe_edit, pbe_type, pbe_cntr, pbe_work, pbe_seqn, pbe_flag from sysdba.pbcatedt order by pbe_name, pbe_seqn\ 0"

SDWORD -3



DIAG [HY000] [Gemini InterBase ODBC Driver][INTERBASE]Dynamic SQL Error. SQL error code = -104. Token unknown - line 1, char 88. . (-104)



CR:338756
CR Number:   338756
Product Name:   PB Enterprise
Product Component:   Library Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Feb 2005 Fixed
Description
PB9 IDE shuts down when adding new object to source control via library painter
Workaround Description
 Add new object to source control via system tree



CR:338758
CR Number:   338758
Product Name:   PocketBuilder
Product Component:   DW - Runtime
Status:   Closed
OS:   Pocket PC 2002
Original Version:   1.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
RC1 26 Nov 2003 Fixed
Description
We all understand that SetNull(null) and SetFilter(null) is not supported on the PDA.

However, calling this (accidentally) causes a memory error.



String ls_null

SetNull(ls_null)

dw_1.SetSort(ls_null)

dw_1.Sort()



OR



String ls_null

SetNull(ls_null)

dw_1.SetFilter(ls_null)

dw_1.Filter()



On the device, the sort or filter dialog will not appear. On the emulators, there will be a memory error message as appended:



"Memory error: Freeing previously freed memory or freeing using different anchor! Generate GPF?"



CR:338775
CR Number:   338775
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
Composite reports are not recreated properly with getfullstate/setfullstate when eg. the same nested report is put into the composite more than once.
Workaround Description
 Name another datawindow object differently (eg. d_child1 d_child2...)



CR:338825
CR Number:   338825
Product Name:   PB Enterprise
Product Component:   PD Integration
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 pre-beta
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jan 2004 Fixed
Description
Toolbar of PB objects does not match the object placed in PD workspace. Eg. when you select a new window, you'll get a structure.

When selecting a nvo you'll get a proxy.



CR:338884
CR Number:   338884
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement Request: Add PowerBuilder ODBC Drivers and syntax for MySQL, Firebird, and PostgreSQL Databases. These databases are becoming increasingly popular.



CR:338912
CR Number:   338912
Product Name:   PocketBuilder
Product Component:   DB Synchronization
Status:   Closed
OS:   Windows 2000
Original Version:   1.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.5 10 Nov 2003 Fixed
Description
Specifying extended synchronization options causes a "Synchronization error 1" message, which corresponds to an "Invalid option string" error from dbmlsync. This error occurs whether extended dbmlsync options are specified while running through the "MobiLink Synchronization for ASA" wizard, or if they are specified at runtime via the generated configuration dialog.



To reproduce, specify "lt=share" or "sv=salesdb" for extended options either during the wizard or at application runtime.



CR:338987
CR Number:   338987
Product Name:   PB Enterprise
Product Component:   DW Expression
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 May 2004 Fixed
Description
Number array as a Retrieval Arg in a nested datawindow does not work



CR:339009
CR Number:   339009
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jun 2004 Fixed
Description
Using Save Rows As and selecting HTML. Examining the html in a browser one of the column headers is dropped
Workaround Description
 The workaround is to experiment with the position of the column/header to enable good html output as demostrated in the example.



CR:339016
CR Number:   339016
Product Name:   PocketBuilder
Product Component:   DW - Runtime
Status:   Closed
OS:   Pocket PC 2002
Original Version:   1.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Nov 2003 Fixed
Description
Calling the datawindow GetRowIDFromRow() or GetRowFromRowID() functions will cause the application on the device to crash out. There's no error message triggered. There's also no problem for the functions to work on the IDE.



CR:339017
CR Number:   339017
Product Name:   PocketBuilder
Product Component:   DW - Runtime
Status:   Closed
OS:   Pocket PC 2002
Original Version:   1.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
352 21 Nov 2003 Fixed
Description
Calling the datawindow SaveAsAscii function will cause the application to crash on the device, with no errors triggered. There is no problem calling this function on the IDE.



eg. i_rc = dw_1.SaveAsAscii(".\dept_ascii.txt","/","-")



CR:339039
CR Number:   339039
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.2.1 08 Jun 2007 Fixed
Description
With the MSS database interface, using Paste Special>Remote Stored Procedure to declare a MS SQL Server stored procedure as a local external function translates SMALLINT and TINYINT as LONG instead of INT. Also, REAL translates as DOUBLE instead of REAL. The REF keywords are missing, but this is reported in CR 274045. There are similar problems using the OLEDB database interface as well. These are reported in CR 339042.



CR:339113
CR Number:   339113
Product Name:   PB Enterprise
Product Component:   EJB Client
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 26 Nov 2003 Fixed
Description
Using ejb client to call Java functions of JDK. Functions with arguments of type any seem to throw nullpointerexceptions. Functions with no arguments, or arguments or working fine.



CR:339122
CR Number:   339122
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Seems CR 265087 is back in VSS. Show blank line if doing "Show differences" after adding blank after instance variables of an user object.



no workaround
Workaround Description
 non



CR:339129
CR Number:   339129
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Nov 2007 Presently Not Targeted For Any Future Release Of This Product
Description
Regression in PowerBuilder 8 Build 10521 on datawindow editmask when using European settings.



When in the control panel the comma is used as decimal separator, PowerBuilder 8 crashes

when entering a value behind the decimal in a column with editmask ###.00



CR:339166
CR Number:   339166
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 02 Dec 2003 Fixed
9.0.1 12 Feb 2004 Fixed
Description
Datawindow EditMask does not let one enter Feb 29th without entering the year part first. You need to enter a valid leap year and then enter the day for this to work. This used to work in PB7.x.



Not reproducible in PB 8.0.4 build 9882.

Fixed in PB 9.0.1 build 7119 and PB 10 build 3014.



CR:339308
CR Number:   339308
Product Name:   PB Enterprise
Product Component:   Install
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   10.0 Alpha
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jun 2004 Fixed
Description
Install only PowerBuilder on a machine where ASA 9 has not yet been installed, you'll get a Warning dialog indicating that "Adaptive Server Anywhere 8.0 is not installed on your machine." This should refer to ASA 9.0 instead.



CR:339309
CR Number:   339309
Product Name:   PB Enterprise
Product Component:   Install
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   10.0 Alpha
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Mar 2004 Fixed
Description
Remove MSS and O73 db interfaces from installer options since they will not be support by PB 10.



CR:339318
CR Number:   339318
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 17 Apr 2005 Fixed
Description
Upon 'convert to graphics', the where clause is lost if the Where tab is visible. If another tab is visible, then it works fine.



CR:339346
CR Number:   339346
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 01 Dec 2003 Fixed
Description
Saveas to XSL-FO on an external datawindow when there is

no data in the datawindow and controls in the footer band will cause PB to crash.



When a row is inserted and then the saveas to XSL-FO is performed, than no problem. The footer band of the external datawindow has a computed field, text and a round rectangle. When the controls are removed from the footer band, than no problem. Saveas to XSL-FO works ok when there is no data in the datawindow. Even when the controls in the footer band were moved to the summary band, than it worked ok.



The crash handler log reports:

Exception code: C0000005 ACCESS_VIOLATION

File Name: E:\pb90\Shared\PowerBuilder\PBDWE90.dll

File Version: 9.0.1.7048

Fault address=1166F42D Section:Offset=01:0016E42D



Registers:

EAX:00000006

EBX:00000000

ECX:00000000

EDX:FFFFFFFF

ESI:0280C31C

EDI:FFFFFFFF

CS:EIP:001B:1166F42D

SS:ESP:0023:0012E4EC EBP:0283088C

DS:0023 ES:0023 FS:0038 GS:0000

Flags:00010296



Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

1166F42D 0012E78C FFFFFFFF 00000000 7FFFFFFF FFFFFFFF dwXMLGetDefaultEncoding+11F4D

1166EDC3 0012E7A0 02831E8C FFFFFFFF 00000000 0280C884 dwXMLGetDefaultEncoding+118E3

11630813 0012E7DC 0012E800 00000000 00000000 02830B9C DW_SortDlgProc+1253

1166F6C6 0012E814 0280C884 0282E760 00000000 0012E840 dwXMLGetDefaultEncoding+121E6

1166F77E 0012E974 02830B9C 0012EA24 00000519 01000000 dwXMLGetDefaultEncoding+1229E

1155B0CD 0012EC78 02830B9C 00000000 00000000 C0000000 CreateImportDataList+17ED

11645C2E 00000519 00000000 00000000 00000000 00000000 dwWinProc+116E



OS version:

Windows NT 5.0, Build Number: 2195, Service Pack 3



Memory Status:

Total physical memory: 261552K

Available physical memory: 33100K

Total virtual memory usage: 309616K / 763108K

PowerBuilder virtual memory usage: 131916K / 2097024K



CR:339407
CR Number:   339407
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Restart and external function causes PB to fail to "recognize" global structure.



CR:339470
CR Number:   339470
Product Name:   PocketBuilder
Product Component:   DB ODBC
Status:   Open
OS:   Windows 2000
Original Version:   1.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.5
01 Jun 2005 Fixed
Description
The data value of an Autoincrement column does not get returned when using a proxy table.



CR:339472
CR Number:   339472
Product Name:   PB Enterprise
Product Component:   Function Painter
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
If a function is declared with an argument of type ANY e.g. myany and a local variable is declared with the same name i.e. ANY myany. When the script was compiled (CTRL L).



PB 8.x and earlier versions of PB (PB 6.5, 7.x) does NOT give a compilation error.

NOTE a compiler error is displayed for all other types e.g. integer



PB 9.x and 10 would produce the following compiler error message:

C0166: Variable name conflicts with parameter name:myany



Enhancement request is to "back port" this feature back into PB 8.x, so that the compiler error message also appears in PB 8.x.



Workaround:



PSE recommendation to avoid this scenario is to use a good naming convention when declaring function arguments and variables. Function arguments should be prefixed with ai_myint and aa_myany[] and local variables should be prefixed with li_myint and la_myany[].



Here is a couple of sections from the on-line help:



**************************************

General information



In a well-planned application, standards determine how you will name your PowerScript variables. Naming conventions make scripts easy to understand and help you avoid name conflicts. A typical approach is to include a prefix that identifies the scope and the data type of the variable. For example, a prefix for an instance variable's name typically begins with i (such as ii_count or is_empname), a local integer variable's name would be li_total and a global integer variable's name would be gi_total.



For information about naming conventions, see Application Techniques.



X and Y as variable names



Although you may think of x and y as typical variable names, in PowerBuilder they are also properties that specify an object's onscreen coordinates. If you use them as variables and forget to declare them, you will not get a compiler error. PowerBuilder will assume you want to move the object, which may lead to unexpected results in your application.

**************************************



Also:



**************************************

Overusing the Any datatype



Do not use Any variables as a substitute for selecting the correct datatype in your scripts. There are two reasons for this:



At execution time, using Any variables is slow PowerBuilder must do much more processing to determine datatypes before it can make an assignment or perform an operation involving Any variables. In particular, an operation performed many times in a loop will suffer greatly if you use Any variables instead of variables of the appropriate type.

At compile time, using Any variables removes a layer of error checking from your programming

The PowerBuilder compiler makes sure datatypes are correct before code gets executed. With Any variables, errors that can be caught by the compiler are not found until the code is run.

**************************************
Workaround Description
 See customer description for workaround.



CR:339480
CR Number:   339480
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)
9.0.3 17 Nov 2005 Fixed
Description
The value of the autoincrement field when using proxy tables with ASA is not properly returned to PowerBuilder. This was reported originally for PocketPB where proxy tables will most likely be frequently used. See CR 339470, which is cross-referenced in this CR.



CR:339481
CR Number:   339481
Product Name:   PocketBuilder
Product Component:   Language - Compiler
Status:   Open
OS:   Windows 2000
Original Version:   1.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Please add a new Native Object for RFID (Radio Frequency Identification)



CR:339570
CR Number:   339570
Product Name:   PB Enterprise
Product Component:   DW DDDW
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 18 Jan 2004 Fixed
Description
Under normal conditon, DropDown Datawindow will scroll to the page to display the first row of data with match up the character on the edit control. In this case, it seems that DDDW fail to scroll with chinese character. e.g. 0xB35C or 0xD25C, or 0xA55C in Big5 code.



CR:339587
CR Number:   339587
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)
10 May 2005 Presently Not Targeted For Any Future Release Of This Product
Description
During load, when more than one stateless component and the shared component is executing embedded SQL statements at the same time, the query will fail with either of the following errors:



SQLDBCode: 1007

SQLErrText: ORA-01007: variable not in select list



or



SQLDBCode: DBCode: 0

SQLErrText: Mismatch between retrieve columns and fetch columns
Review Status
 *** Tuesday, May 10, 2005 14:19:42 ***

This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release".
Workaround Description
 - Use datastore retrieves instead of embedded SQL.

or

- Limit the lifetime of the Shared components connectioncache.

or

- Move the connect/disconnect statement from destructor of the shared component to the activete/deactivate event (only possible whe



CR:339592
CR Number:   339592
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 Alpha
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Dec 2003 Fixed
Description
When hitting the F1 key when your in the Tools/Systems Options

causes the following error to occur:



pb100.exe - Application Error

The exception unknown software exception (0xc00000fd) occurred in the application

at location 0x10db5636.



CR:339613
CR Number:   339613
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 30 May 2005 Fixed
Description
Clicking on dw columns, the leftbuttonup event doesn't fire as it does with other dw objects.



CR:339620
CR Number:   339620
Product Name:   PB Enterprise
Product Component:   Font
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 May 2009 Third Party Problem
Description
When columns on a datawindow are right aligned and italic

is selected, the right most character is partially truncated.



The problem is most noticeably using Tahoma. Problem also happens with a

static text field on a window.
Review Status
 4/22/2005

This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release".



CR:339627
CR Number:   339627
Product Name:   PB Enterprise
Product Component:   JSP Wizards
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 pre-beta
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Dec 2003 Fixed
Description
When creating a JSP target and you click thru the

defaults, on the "Choose File Deployment Options", the text of "option is checked.)"

is partially truncated under the "Deploy Only Successful files".



CR:339632
CR Number:   339632
Product Name:   PB Enterprise
Product Component:   DW Printing
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 07 Dec 2003 Fixed
Description
Regression. In 8.0.3 the customer opens a print job and prints some text and then a datawindow to the same print job. They both print on the same page. In 9.0.1 there is a page break between the text and the datawindow.



CR:339633
CR Number:   339633
Product Name:   PB Enterprise
Product Component:   JSP DW DTC
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 pre-beta
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Dec 2003 Not reproducible with latest version of the product available as of Resolution Date
Description
When in a jsp page and you select the Web DTC,

pb does not respond anymore. Its just hangs.



CR:339639
CR Number:   339639
Product Name:   PocketBuilder
Product Component:   DW - Runtime
Status:   Closed
OS:   Pocket PC 2002
Original Version:   1.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
363 13 Jan 2005 Fixed
Description
The effect happens with a shared global datastore/ local datawindow pair.

Implicit destroy the datawindow (by closing the window

containing it) but *don't shareDataOff the DW*.

Reopen the window (shareData called again), and code

ds.setItem(...). The next script line will never executed,

program hangs or GPF's. This causes no problems

if the program runs from the IDE.



CR:339642
CR Number:   339642
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Apr 2005 Fixed
Description
A text object with a transparent background is rotated using the escapement property. Visible nderneath the text are the rows of the datawindow. If the rows are scrolled the text bleeds and becomes distorted.



CR:339652
CR Number:   339652
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)
30 Apr 2008 Fixed
Description
When entering in a editmask of HH for a datawindow datetime column, the following error appears when trying to save the changes:



Specified edit mask is invalid. In PB 8.0.4, you are allowed to enter HH for a

editmask.



CR:339720
CR Number:   339720
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In the library painter, if you right click on an object and choose properties, you are able to change the SCC version.



CR:339739
CR Number:   339739
Product Name:   PB Enterprise
Product Component:   DataBase
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
How to get the new database password after it expired.



CR:339755
CR Number:   339755
Product Name:   PB Enterprise
Product Component:   Language - Compiler
Status:   Open
OS:   Microsoft Windows NT
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement Request: Now that PB is only supported on newer OS, support some of the windows messages that are only available on those: WM_MOUSELEAVE, WM_NCMOUSELEAVE, etc.



CR:339761
CR Number:   339761
Product Name:   PB Enterprise
Product Component:   DW Rich Text
Status:   Open
OS:   Microsoft Windows NT
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When customer prints RTE datawindow with one printer driver and then changes printer driver to another type (like acrobat Distiller), all the fonts in the datawindow are messed up.



CR:339762
CR Number:   339762
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
This is an enhancement request to support changing the

definition of the numerical separators in the control

panel while PowerBuilder applications are running.

Currently (datawindow) editmasks may not function properly

after changing the symbols for the decimal separator and

thousands separator and require the restart of the application

or the development environment.



CR:339771
CR Number:   339771
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Open
OS:   Microsoft Windows NT
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Using PB DATADirect OEM 4.10 dBASEFile (*.dbf) alows invalid update to execute.

Executing a SQL statement from PB DB painter like this :



UPDATE table1 SET col3=1, col3=1 where col3 = <some value>



doesn't produce any error But according to SQL standard "Columns may not be specified more than once on LHS of assigment operator in SET clause of UPDATE statement."

If you run the same type of sql to EAS Demo database , it will not execute.



CR:339787
CR Number:   339787
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 14 Jan 2004 Fixed
Description
This is a duplicate of CR 327915 which was fixed in build 7011. That fix caused a regression when the editmask was ###,###.00 (CR 330276) and that is now fixed, but now the original problem is back with an editmask of ###,##0.00 in build 7048.



EditMask : ####,##0.00



If you highlight the column and enter 15 , it will be 1.50.



CR:339839
CR Number:   339839
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)
23 Feb 2004 Not a Bug
Description
Returning a blob data causes Sybase Heap Manager Exception.





Reviewed by PB Engineering "Not a Bug", running out of memory.

Suggestions:

1) increase the physical memory installed on the machine

2) using Windows 2000 Server/Advanced Server Edition

3) using /3GB flag to start Windows 2000

4) Increase PB_HEAP_SIZE to a large value

5) change PB_POOL_THRESHOLD to find an appropriate value to save memory

6) Make sure that your swap space is double your available RAM.

7) change the program logic if possible, don't fetch large data in a time. only retrieve the data actually needed.



CR:339856
CR Number:   339856
Product Name:   PB Enterprise
Product Component:   P-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 20 Jan 2004 Fixed
Description
PB 9.0.1 build 7048 has introduced a severe memory leak, which impacts customers trying to create executables with "large" applications. With very large applications PowerBuilder will eventually give an out of memory message.



The memory leak is also evident if a "full rebuild" is initiated from the workspace.



CR:339885
CR Number:   339885
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The definitions of the Blob functions are as follows:



blobedit ( ref blob b, unsignedlong o, any v ) returns unsignedlong

blobmid ( blob b, unsignedlong o ) returns blob

blobmid ( blob b, unsignedlong o, unsignedlong c ) returns blob



With blobedit the blob b is passed by reference while with the blobmid function the

blob is passed by value.

Passing by value means that a copy must be made of the variable which can be very

slow with a sizeable blob.



CR:339904
CR Number:   339904
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 01 Dec 2003 Fixed
Description
When saving a group datawindow to XML when no template

is specified under the Data Export tab, pb shuts down without any warning. Problem

happens either from the PB IDE or using dw_1.saveas to XML!. If a template is specified

under the Data Export tab, than no problem.



According to the online help for saveas:

If no export template is specified, the default template is used.



When running with the crash handler exe, the following log file is generated:

Exception code: C0000005 ACCESS_VIOLATION

File Name: E:\pb90\Shared\PowerBuilder\PBDWE90.dll

File Version: 9.0.1.7056

Fault address=1165FA8F Section:Offset=01:0015EA8F



Registers:

EAX:00000000

EBX:0334F2F8

ECX:00001178

EDX:10E3FA00

ESI:00000000

EDI:032DC9F8

CS:EIP:001B:1165FA8F

SS:ESP:0023:0012E158 EBP:00000000

DS:0023 ES:0023 FS:0038 GS:0000

Flags:00010246



Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

1165FA8F 0012E6E4 02874C28 0012E6FC 00000000 0012E758 dwXMLGetDefaultEncoding+246F

1165F67D 0012E70C 00000002 00000001 1165E42D 01225008 dwXMLGetDefaultEncoding+205D

11660B7D 0012E718 01225008 00000519 01000000 00000000 dwXMLGetDefaultEncoding+355D

1165E42D 0012E974 01225008 0012EA24 00000519 01000000 dwXMLGetDefaultEncoding+E0D

1155B095 0012EC78 01225008 00000000 00000000 C0000000 CreateImportDataList+17B5

11645CDE 00000519 00000000 00000000 00000000 00000000 dwWinProc+116E



OS version:

Windows NT 5.0, Build Number: 2195, Service Pack 3



Memory Status:

Total physical memory: 261552K

Available physical memory: 32084K

Total virtual memory usage: 418988K / 763108K

PowerBuilder virtual memory usage: 132980K / 2097024K



CR:339906
CR Number:   339906
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Feb 2004 Fixed
Description
This is a duplicate of CR 287478 which was closed in the CR 'cleanup'. I do not think it's wise to change PowerBuilder behavior; however, I think this behavior could be documented, so this a documentation CR request.



The PowerScript Reference states:



If you do not qualify a function name with an object, PowerBuilder searches for the function and executes the first one it finds that matches the name and arguments. It searches for a match in the following order:

A global external function.

A global function.

An object function and local external function. If the object is a descendant, PowerBuilder searches upward through the ancestor hierarchy to find a match for the function prototype.

A system function.





and the DataWIndow Reference states:



User-defined functions in PowerBuilder

You can include user-defined functions in DataWindow expressions. The data type of the function's return value can be any of the following: double, string, boolean, date, DateTime, or time. The function must be defined as a global function so that it is available to the DataWindow object.



Both manuals should be updated to reflect that built-in datawindow functions cannot be overriden.





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

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

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

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

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

各种误操作:

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

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

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


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

Sybase ASE数据库恢复工具READSYBDEVICE:

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

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

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

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

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


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

SQL Server数据库恢复工具SQLRescue:

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

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

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

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

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

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

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