远程Sybase数据库技术支持,联系手机:13811580958,QQ:289965371!

 

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

如有问题,请联系我!

QQ :289965371 点击这里给我发消息
Email:
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

 

CR:157777
CR Number:   157777
Product Name:   PB Enterprise
Product Component:   Profile Painter
Status:   Closed
OS:   Solaris 2.5.1
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Solaris - NO scrollbar on Database Profiles when there are more profiles than can fit in the display area.



Fixed by patch received from Bristol Technologies



CR:157781
CR Number:   157781
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Stored procedure with result set to a datawindow works fine, but when ASYNC is turned on, the retrieve does not get cancelled until the first row comes back. ASYNC does work properly when the SQL behind the datawindow is a select statement.



CR:157787
CR Number:   157787
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Allow a Page Break function with Nested Reports



CR:157789
CR Number:   157789
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
comparing dw buffers in powerscript using the dot notation leads to an error at runtime : Array comparison: type not handled, file otquery.cpp line 456



CR:157793
CR Number:   157793
Product Name:   PB Enterprise
Product Component:   Toolbar
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description



CR:157794
CR Number:   157794
Product Name:   PB Enterprise
Product Component:   Toolbar
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Fixed for beta 4.



CR:157795
CR Number:   157795
Product Name:   PB Enterprise
Product Component:   Toolbar
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Fixed for beta 4.



CR:157797
CR Number:   157797
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Setpointer Function does not work under PB4 or PB5 working under win95. Both 16 bit and 32 bit .



Workaround: Use External function calls (The following are 32 bit calls)

Function ulong LoadCursor(ulong hi, ref string str) Library "USER32.dll"

Function ulong SetCursor(ulong hCursor) Library "USER32.dll"

Function ulong SetSystemCursor(ulong hCursor,long ll) Library "USER32.dll"

Function ulong GetCursor( ) Library "USER32.DLL"

Function ulong CopyIcon(ulong hInstance, ulong hIcon) Library "USER32.DLL"



CR:157800
CR Number:   157800
Product Name:   PB Enterprise
Product Component:   Profile Painter
Status:   Closed
OS:   Solaris 2.5.1
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
SOLARIS - AIX ONLY - HP WORKS. Display area of the Database Profiles popup becomes blank.





Developer: Fixed by patch recieved from Bristol Technologies.



CR:157802
CR Number:   157802
Product Name:   PB Enterprise
Product Component:   System Runtime Functions
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Calling the FileOpen() with an empty/null string for the argument causes a gpf, rather than returning a -1 (Regression)



CR:157804
CR Number:   157804
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
This bug only occurs when there are multiple dropdown buttons on toolbars and one is dropped.



CR:157805
CR Number:   157805
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
***** 5.0.03 REGRESSION *****

In 5.0 thru 5.02 when an oracle stored procedure was pasted the datatype (double) of the stored procedure was pasted correctly. In 5.03 the datatype is defaulting to (decimal). If you have coded a variable as a double and passing it to the RPC call it will now give an error "referenced arguments do not match definition:"



Workaround: Change the data type in the RPC declaration from "decimal" to "double".



CR:157810
CR Number:   157810
Product Name:   PB Enterprise
Product Component:   Project Painter
Status:   Closed
OS:   HP-UX 10.20
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Problem involved use of signal() and the system() call inside of a threaded application. Fix was made in WindU to use sigaction() instead of signal() so that the system call would work in PB.



CR:157811
CR Number:   157811
Product Name:   PB Enterprise
Product Component:   Toolbar
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Text in toolbar items now etched(when items disabled) such as when in the debugger.

Color changes are tied to 3d system color changes; were tied just to window text changes.



CR:157826
CR Number:   157826
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Just upgraded from 5.0.02 to 5.0.03. External function call worked in 5.0.02, with 5.0.03 customer getting gpf with external function call to FindWindow (16bit) findWindowA (32bit). gpf: pbrte050.dll at 014f:10b4f390 or runtime error: R0010 "Unsupported argument type in DLL function FindWindow (or FindWindowA) at line # in clicked event of object...



Changed 5.0.04 and 6.0 to allow NULL string variables to be passed to external dlls. The windows API calls expect a NULL C pointer and there's no other way to provide that except SetNull. ***NULL doubles and decimals, etc will still be disallowed.



CR:157829
CR Number:   157829
Product Name:   PB Enterprise
Product Component:   Toolbar
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
In the Examples for 6.0, when you go into the multiple toolbars example and open a sheet, then click on the DropDownToolBar you will get an access violation. The other problem is all the toolbars on on top of one another, not side by side as in 5.0



CR:157831
CR Number:   157831
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Build 162: In the PB Example 6.0, when you run the Populate DDLB example from the Sql Embedded Example you will get an Access violation.



CR:157837
CR Number:   157837
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows 3.1
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
With PBDBMS=0 and SQLCache set, an insert statement form script that fials with a duplicate key returns 100 as the SqlCode. If Sqlcache is not specified, it returns -1, as expected.



CR:157838
CR Number:   157838
Product Name:   PB Enterprise
Product Component:   Rich Text
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Problem: When doing merge of data into rich text edit object with insert fields (by using the DataSource function), format specified on dw is not applied to input field values. If you apply a format change to the column in the RTE and print, the print clears your formatting.



CR:157846
CR Number:   157846
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   HP-UX 10.20
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Fixed in build 174 of PB for HP. There was a function that was not being exported correctly in pbsyd60.sl on HP. The fix is in pbsyd60.sl (aka dll).



CR:157858
CR Number:   157858
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Regression pb 5.0.02 to pb 5.0.03 32 bit



OLE control's datachange and viewchange events do not get triggered. This is critical to deployment and upgrading to 5.03



The events: ViewChange, DataChange, Close, Rename, and Save are all optional events which the OLE server may or may not implement.

There are also no rules about when the OLE server should call these events when they even are implemented.

Hence, the problem is with the OLE server, not PowerBuilder.



This is general to pb but in this particular case there is a regression occuring



This issue is now fixed using pbroi050.dll from pb 5.0.04_36 or later.



CR:157861
CR Number:   157861
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Enhancement. Informix - native drivers. Today, char() fields are padded out to their maximum size and varchar are not. This causes problems with update statements and editing data. The enhancement would be to right-trim the char() columns



CR:157864
CR Number:   157864
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Solaris 2.5
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
On UNIX, the modify event is not triggered after an item is modified in a drop down list box (DDLB). This works fine on the Windows version.



CR:157873
CR Number:   157873
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
DPB. Trying to update a datastore in the server application. Two fields in a datastore contain numbers. When the datastore update() function executes, an insert statement is generated with one row in created. The insert fails with an ORA-1400 b/c two numeric fields that are defined as Not Null are (null).



CR:157880
CR Number:   157880
Product Name:   PB Enterprise
Product Component:   Table Painter
Status:   Closed
OS:   Solaris 2.5.1
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
PB 6.0 build 162 (v2), Sun Sparc Solaris



From the table painter, a properties sheet can be accessed which has a Foreign Key tab page. The New button on that page is grayed out, although it can be activated by double-clicking.



Steps to recreate:

1) Enter the table painter (with a new or existing table).

2) Go to the properties sheet.

3) Go to the Foreign Key tab page.



The New button is grayed out. However, if it is double-clicked, it works.



The button should not be gray, and it should work with a single click.



CR:157881
CR Number:   157881
Product Name:   PB Enterprise
Product Component:   DW DDDW
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.x Catalina 1072 13 Dec 2000 Fixed
Description
Problem: Floating DropDownDatawindow

Opening a dddw (one of several) on a grid, causes the

Drop Down portion of the first DDDW to display away from the drop down arrow. The items in the DDDW cannot be selected.



Workaround: Do not Modify() column color



CR:157883
CR Number:   157883
Product Name:   PB Enterprise
Product Component:   Printing
Status:   Closed
OS:   Solaris 2.5.1
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Cannot select a specific printer from Solaris PB Help when Help is called from within Solaris PowerBuilder. Running hyperhelp outside of PowerBuilder does allow you to select a specific printer.



CR:157887
CR Number:   157887
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Closed
OS:   HP-UX 10.20
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description



CR:157895
CR Number:   157895
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
ReselectRow sometimes returns 0 instead of -1 as documented when row cannot be reselected. Against SQL anywhere, -1 was returned when I shut down the engine, but using Oracle 7.2, 0 was returned when I disconnected my network connection. For these two db's and MSS, 0 was returned when the row was deleted from another PB session.



CR:157905
CR Number:   157905
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
NT 4.0 is calling the wrong dialog in GetFileOpenName() function call. It should be using the Win95-style dialog...for File/Open like Wordpad.



CR:157907
CR Number:   157907
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
The function OpenTab() accepts a user object of type "tab" as an argument. This causes OpenTab() to GPF since it's really expecting an object of type userobject rather than tab. Migrating to 6.0 gives:



(0001): Error C0174: Type of actual parameter cannot be ancestor of formal reference parameter type.





PER DEVELOPMENT:We won't be fixing this in 5.0--the compiler flaw that allowed this behaviour in the first place has been corrected in 6.



CR:157910
CR Number:   157910
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Informix 7.x driver (IN7) doesn't support autocommit= false.



Solution: Logging was not turned on for the database.



CR:157914
CR Number:   157914
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
ddlb - disable and re-enable -> works like a normal combobox.



CR:157916
CR Number:   157916
Product Name:   PB Enterprise
Product Component:   DW DDDW
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 10 Apr 2003 Fixed
Description
Nested reports containing dropdowndatawindows display fine in development and runtime but not when saved as PSR files. From 5.0 on, they show DATA values only instead of display values.



Related to "Saved Data" in the dataobject since similar behavior is seen with DDDWs when you save data in the PARENT data object.



Workaround: For the DDDW column, you must join the table and column for the Display value into a second datawindow - one you use just to use Save As.. ".PSR".



CR:157917
CR Number:   157917
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Dec 1998 Not reproducible with latest version of the product available as of Resolution Date
Description
Appears that tabpage.picturename uses only the 32x32 icon (large icon view). Using a 16x16 only icon shows up as an 'X'.



CR:157918
CR Number:   157918
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Vertically stacked ddlb columns with "always show arrow" on (freeform) in a datawindow cause the lowermost ddlb to not drop when using the arrow. Works fine when clicking on the edit control part of the lower ddlb column. The distance required to work correctly seems to be about 25 units in the y direction between the two ddlbs.



CR:157922
CR Number:   157922
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 May 2001 Fixed
Description
Changes to a descendant is impacting the ancestor in such a way that you have to regenerate it to have the app running.



CR:157923
CR Number:   157923
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Getting the following error in 6.0.00.170 32 Bit & 16 Bit while executing a Local External RPC to a MS SQLServer 6.5 stored procedure, sqlca.sqlcode = 201 and it's sqlerrtext is: 'Procedure sp_bill expects parameter @my_input, which was not supplied'. But this parameter was supplied.



DEVELOPMENT: Cannot recreate - fixed during 6.0 beta.



CR:157925
CR Number:   157925
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Dot notation for copying data from one datawindow to another doesn't work with certain conditions. It appears to be related to a datawindow with a datetime datatype. When I take out the datetime, it doesn't GPF on assignment. This example uses PSRs for both the source and destination dataobject.



Workaround: Insert an empty row in the destination datawindow control first.



dw_1.dataobject="test.psr"

ds_1.dataobject="test.psr"

dw_1.insertrow(0)

dw_1.object.data = ds_1.object.data



CR:157929
CR Number:   157929
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jul 1998 Presently Not Targeted For Any Future Release Of This Product
Description
CopyRTF then PasteRTF, first of one other datawindow row, then a second row from the datawindow results in the second row being in the richtext control twice, instead of having a copy of both row 1 and row 2.



CR:157931
CR Number:   157931
Product Name:   PB Enterprise
Product Component:   P-Code Deployment
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Changing current directory causes PB to not find ini file. This, in turn, causes great heartache when things continue to go wrong.



PER DEVELOPMENT: Fixed by a different issue's code change.



CR:157962
CR Number:   157962
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
*** 5.03 REGRESSION ***

32 bit Short, Win 95b ( plus) - Development pb 5.0.03



keywords:: ole automation .. office 95.. win 95b



problem description::

If you preview a dw that is OLE style (Excel Spreadsheet) you hang if you try to exit the preview.



This does not happen on my machine. Only happens with win 95B (upgrade version of win 95) and office 95. With pb 5.0.02 32 bit the DW does not hang



I use office 97 and win 95 Gold. I get no data retrieved although it states at the microtab section at the bottom of the DW that 30 out 60 rows retrieved.



There is no problem whatsoever with NT 4.0



CR:157964
CR Number:   157964
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.00 17 Apr 1998 Fixed
Description
If you place a dw in the header band of a nested dw, the dw in the header band only prints on the first page. This also occurs in preview mode. When you click on the Next button the State is being dropped.



CR:157969
CR Number:   157969
Product Name:   PB Enterprise
Product Component:   UO - Runtime
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
PB doesn't release memory after a destroy of a nvo.



CR:157992
CR Number:   157992
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
DataWindow sort order--- if you have a string with a dash in it, the DataWindow will not sort it correctly. DataWindow seems to be ignoring the dash.



CR:157994
CR Number:   157994
Product Name:   PB Enterprise
Product Component:   Table Painter
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
I get an error message when I try to create a new table.

The steps that I do to make this occur is:



1. Hit the table painter icon.

2. Select new.

3. Name the column.

4. Give the table a data type.

5. File --> Save.

6. Name it.



The error message reads:



{

Create Table Definition



Stop!



The following syntax pattern provided in the pbodb60.ini file is incorrect:

Column Element.

}



I tested the same steps on this version in Win95 and NT4 and nothing abnormal.



CR:157999
CR Number:   157999
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
When Windows settings has been set to International, a "," replaces the decimal. The Editmasks in datawindows do not work properly at all. The Editmask in question is [currency(7)]



PER DEVELOPMENT: This specific problem dealt with importing text files with currency data. The files had been exported in US currency and were being imported with settings changed to another currency which used the comma decimal separator. The problem is that given a particular countries settings of decimal points and thousands seperators there is NO WAY we can tell or translate from a text file stored with another countries settings. This is ONLY a problem for text files, a DB wouldn't actually store the '.' or ',' in the data.



USA 119,989.27

International 11.998.927.00 instead of 119.989.27 or sometimes you cannot type anything in at all as numbers spread all over the mask.



POSSIBLE WORKAROUND: if the mask is ###,###.00, then this mask works fine with international settings, so long as this format is acceptable for the various international settings you may be using.



This is the danger of using text files for import. Having different decimal separator settings does have an effect.



CR:158002
CR Number:   158002
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   HP-UX 10.20
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
PB 6.0 : Build 162 v4 (beta2) : HP-UX : Oracle 7.3 Connectivity : Unable to connect to a Oracle database using the O73 driver using the "Thread Safe" option. After setting up the profile, when I try to connect, PB will core dump after displaying the following message on the console:

/lib/dld.sl: Unresolved symbol: opinit (code) from /pwrs/pb6_162/pb6/bin/libpbo7360.sl

IOT trap (core dumped)



CR:158007
CR Number:   158007
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   HP-UX 10.20
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Bduquette - 01/06/99 - reopened - history of cr is listed after the following description

Short Description: When adding text to window controls, controls (check boxes,
command buttons, radio buttons, singleline edits, edit mask) do not resize appropriately.
Works ok on windows. Problem was first discovered in PB 6.0 beta.



CR:158010
CR Number:   158010
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Oct 1998 Fixed
Description
pasting '02/97' in a datetime edit mask with format mm/yy doesn't work using Crtl+Ins



CR:158015
CR Number:   158015
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   HP-UX 10.20
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
In the database painter, a primary key can be added for any columns. The primary key doesn't seem to do anything - columns in the primary key can have duplicates or nulls.





PER DEVELOPMENT:

This is not a bug for syb, 4.0x Dblib Database servers. The primary key implementation was not 'really' supported in this version of the servers. The 4.0x servers only used the sp_primarykey stored procedures for documentation/user intent puposes. The 4.0x server did not enforce any constraints, as constraints & rules were not available in the database itself in the 4.0x version of the Server for a primary key.



If one uses MS SqlServer 6.0 (or higher) the primary key constraint is supported and enforced as expected. (ie. If one executes the steps above in SqlServer 6.0 or higher,, then one will receive the error messages: "8111 Attempting to define a primary key constraint on nullable column in table.")



This excerpt is right from the MSDN: "calling sp_primarykey and sp_foreignkey simply creates entries in the syskeys table and Microsoft SQL Server does nothing more with them." That is if one executed a sp_primarykey in a 4.21 server in ISQL (ie. No PB), the database would not enforce the primary key 'rule', where a dup column or null values, would be created by the DB.



I have included more information per the MSDN Article below

==================================================

The following is in the MSDN Article, 8/12/96, Migrating your Database from MS SqlServer 4.21 to 6.5:



Syntax to Create a Table and a Primayr & Foreign Key

============================================

CREATE TABLE Article (ArticleID PKID, ArticleType TypeCode,

AuthorID PKID, Title StdDescription NULL)



exec sp_primarykey Article, ArticleID

exec sp_foreignkey Article, Author, AuthorID



Here we have created the two tables, declared a primary key on each, and declared a foreign key in the Article table. Unfortunately, defining these keys does not mean that the database will enforce them! In version 4.21, primary and foreign key declarations are for documentation purposes only; calling sp_primarykey and sp_foreignkey simply creates entries in the syskeys table and Microsoft SQL Server does nothing more with them. To enforce the primary keys, a unique index must be created:



CREATE UNIQUE CLUSTERED INDEX XPKAuthor

ON Author (AuthorID)



CR:158018
CR Number:   158018
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   HP-UX 10.20
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
PB 6.0 : Build 162 v4 (beta2) : HP-UX : Oracle 7.3.2 Connectivity : Unable to connect to a Oracle database using the O73 driver. After setting up the profile, when I try to connect, get assertion failure and a core dump.



CR:158026
CR Number:   158026
Product Name:   PB Enterprise
Product Component:   Pipeline Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
SYB. Executing a pipeline to replace the destination table corrupts the destination table.



Steps to recreate:

1) If employee_copy exists, drop the table.

2) Create a pipeline to copy the employee table to employee_copy.

3) Execute the pipeline.

4) Change the option to Replace.

5) Execute the pipeline.



If you open the table in the database painter, it will show up as having no columns.



CR:158027
CR Number:   158027
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Microsoft Web Browser does not retrieve websites if the URL contains frames. This works ok in Visual Basic.



CR:158030
CR Number:   158030
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Activating and OLE style datawindow by double clicking it (INProc activation), and then single clicking it will deactivate the OLE program. This occurs only if the datawindow resides in a dynamically created window.



CR:158040
CR Number:   158040
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Casting the Datapoint argument as Double in the First Impressions OCX, causes PowerBuilder to crash only in the machine code executable.



Customer's Code:



int i,j



i = 0

j = 0



for i = 1 to 4

for j = 1 to 4

ole_1.object.datagrid.setdata(i,j,double(i*j),0)

next

next





WORKAROUND - Change the Code to the following:



int i,j

double d <---------



i = 0

j = 0



for i = 1 to 4

for j = 1 to 4

d = i*j <---------

ole_1.object.datagrid.setdata(i,j,d,0) <---------

next

next



12/11/97 Update from Development:

Workaround is to assign the double to a variable and use that variable in the OLE call. (see above). Development will be looking into possible means of correcting this architectural problem in a future major release, it cannot be addressed in a maintenance release.



CR:158045
CR Number:   158045
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Powerbuilder only accepts one method to refer to bookmarks using Word 97. The index number is the only method that works:

i.e. acitvedocument.bookmarks[2].select



However the Microsoft Visual Basic for macros, allow for the reference of bookmarks through their names as well.

i.e. activedocument.bookmarks("temp").select



which the above does not work in Powerbuilder

Error: "Error calling external function bookmarks at line xx in event xxxx..."



CR:158054
CR Number:   158054
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
**** 5.0.04 Regression ****

Database=Oracle 7.3, DBMS=O73. Only happens on 16bit with O73 driver and numeric columns and DisableBind=0 (default). Inserting NULL into numeric column causes a gpf in PBO73050.DLL.



CR:158061
CR Number:   158061
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Win 95 and win nt 4.0

32 bit only {pb 5.0.02_11, pb 5.0.03_35, pb 5.0.04_31} panther version 186



keywords:: OCX .. mapocx from chigago Corp.



Problem description::



The OCX ( Mapocx.ocx ) is a control from Chicago Map corp. This OCX will register in the registry but PB cannot display it on a window. No OCX properties can be displayed for it. It is completely non functional within powerbuilder.



CR:158064
CR Number:   158064
Product Name:   PB Enterprise
Product Component:   Table Painter
Status:   Closed
OS:   Solaris 2.5.1
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
PB 6.0 beta2 build 162v5 on Solaris. The cursor is not correctly positioned when adding columns through the table painter so the user is forced to manually position the cursor in the ColumnName field as they add each new column to a table definition. Verified that this is not the behavoir on PB5_230i.



To recreate

1) after connecting to a database, go into the DB Painter and select menu options Object...New...Table.

2) Upon arriving in the table painter, your cursor is in the ColumnName field and you can immediately type the first column name - do so.

3) Tab to the DataType field and assign a datatype to the column.

4) Hit the enter key. You are now presented with a new column template for defining your second column. If you begin typing, the characters don't show up anyplace - none of the fields has focus. ColumnName should have focus - it does on Intel and in PB5_230i on Solaris.



CR:158070
CR Number:   158070
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Posting an OpenSheet PowerScript function call from the frame open event, and using the global sheet variable for the sheetrefvar, GPFs in 6.0.

Workaround:
Triggering the OpenSheet works fine, and using a local variable of type w_sheet as the sheetrefvar also works:
w_sheet lw_sheet
Post OpenSheet(lw_sheet, w_frame)
Or create a user event or function that triggers the opensheet(w_sheet, w_frame) and post that user event.

Per Development (11/10/97):
This is a problem with Posting with a global variable representing the window (e.g. w_sheet). By the time the posted function runs, the window class has been garbage collected and removed from memory. A work around would be to put the call to openSheet() in a function and post the execution of that function. Another alternative (but not recommended) is to turn off garbage collection until the sheet has appeared. The same problem would happen in 5.0 if a window were closed after the POST call as that is when 5.0 ran its form of garbage collection. This would require architectural changes to force the window class to stay in memory and thus needs to be deferred to a future release.



CR:158074
CR Number:   158074
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Under certain conditions, arrow keys do not work as expected in a listview control on a window.



When opening a window with a listview control, the 3rd item in the listview is selected. When trying to arrow from one item to another, using the keyboard arrows, the up and down arrows do not work correctly. If an item is selected using the mouse (clicking on it), the arrows then work fine.



Create a window with a listview.



Add 5 items to the listview arranged as shown above.



Add the above code to the window open event.



When the window opens, you can see that the 3 rd item is selected. If you type the up arrow the focus does not change (If you were at the 1st item the up arrow would not move you up, there is no place to go up from item 1). If you type the down arrow, focus does not change. (If you type the down arrow for item 1 it would move you to item 3, but since item three already has focus, nothing appears to change. At this point the focus and the internal index are both at item 3 and the arrows work fine from this point on.



CR:158087
CR Number:   158087
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jan 1999 Not reproducible with latest version of the product available as of Resolution Date
Description
Datawindow painter resizes nested reports too small when you use "Modify Report" to modify a child report and return to the main report. More noticable with freeform reports as children.



CR:158088
CR Number:   158088
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Problems with quotes when using SaveAs() function to save the contents of his DW to a text file.



Development: Not a bug.



We saveas .txt files the way we (i.e. dw) would want to read them back in ( if one was to do an importfile on the file). Therefore,

let's say you have a .txt file with the following three lines:

"ABC"

""ABC""

"""ABC"""

and that this file was being imported into a dw with one column. The column value for

row 1 = ABC (we read quoted string contents and throw away the quotes)

row 2 = null (we read the first quoted string which is null and ignore the rest)

row 3 = "ABC" (we have special logic to understand that these are quotes that matter to the string)



CR:158104
CR Number:   158104
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
OS and version of PB: win 95 and win nt 16 and 32 bit pb 5.0 5.0.02, pb 5.0.03 pb 5.0.04



Keywords:: modify , describe, datawindow "incorrect syntax at line XXX"



Problem description::



When you do a modify on a variable that has been associated with a describe function you get an error. "Incorrect syntax at line XXX"



Eg ii_instance = dw_1.Describe("DataWindow.Table.Select")

then do a modify



dw_1.Modify("DataWindow.Table.Select='ii_instance")



you get an "Incorrect syntax at line XXX"



This is not database specific. The modify function should be able to use the syntax from the describe.



Also using a specified sql statement for a syntaxfromsql command that is valid should be valid when applying the same statement to a modify. Instead the result is "Incorrect syntax at line XXX". This should not be the case. The modify statement should be able to recognise the syntax.



CR:158113
CR Number:   158113
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Problem: When passing a blob as a parameter to an Oracle RPC function, the blob does not reach Oracle correctly.



CR:158129
CR Number:   158129
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 17 Apr 1998 Fixed
Description
Setting SQLCache to a positive number in the DBPARM is causing data not to be piped using a pipeline to Oracle as the destination (O72, O73). If you take out the reference to SQLCache in the DBPARM, it works fine.



CR:158134
CR Number:   158134
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
*** REGRESSION 5.0.03 *** 32 bit PowerBuilder w/ ObjectCycle 2.0

Checking out objects to 'work' pbl, after a certain number of objects an error occurs: "cCheckout Object : client rpc error out of memory" and objects if using NT3.51.



Problem only occurs with PBEOL050 and Object Cycle 2.0 on the Win 95 or NT platforms. Not a problem in Win 3.1 or in PB 6.0.



Fix requires changes to both PBEOL050.DLL and OCC020.DLL.



CR:158138
CR Number:   158138
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Solaris 2.5.1
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
PB 5.0.03 UNIX CDE : popup windows cannot be minimized. If you check the minimize (or maximize) check box, the popup window doesn't display these boxes.



CR:158144
CR Number:   158144
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Solaris 2.4
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
PB UNIX : Drop-down list box colour attributes are ignored when ddlb is allowediting



CR:158150
CR Number:   158150
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
for database objects that may be referenced with prefix of owner two requests:

1.) An option to control whether or not an owner prefix is used

2.) An option to control what value for the owner prefix is applied, if used.



CR:158153
CR Number:   158153
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Hebrew is not supported in rich text edit control. There is no RightToLeft property.



CR:158156
CR Number:   158156
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
**5.0.03 REGRESSION**



Operating system and version of Powerbuilder

win nt 4.0 only, 32 bit only . pb 5.0.03 and pb 5.0.04.



Problem description.::



Printing from a dw printpreview in landscape mode. When the user prints in the print preview of his datawindow 400 pages of the same data are printed out instead of 1. Also when you run the window the same thing happens .Normaly there is one page of data from the dw that should be printed. Instead there are around 400 pages being printed out of the same data.



This only happens when newspaper columns are set to 2. when they are set to 1 there is no problem.



10-21-97:: Adeering . I tested out pbdwe050.dll on the win nt 4.0. This dll is from build 65 of pb 5.0.04. I optimised the pbl and did some checks to see if pbdwe050.dll would break anything else. It did not. I will now give this dll to the customer.



CR:158171
CR Number:   158171
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
a datawindow with an OLE database blob column : when closing the OLE server window after having activated it by doublecliking, the refreshing of the datawindow is not correct.



CR:158173
CR Number:   158173
Product Name:   PB Enterprise
Product Component:   Menus - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Menus - Setting the Visible property of a Menu item in the Open Event of an MDI Frame Window causes the Menu to become corrupted. Menu items from one menu will overlay menu items next to them when a Sheet is opened using OpenSheet. Although there are two work arounds described below, submitting this as a bug since the original application was developed on the Mac platform and worked. After moving the app to the Windows platform, the menus didn't work properly.



CR:158176
CR Number:   158176
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Return from making changes in the application script painter. A prompt to save appears. After selecting No, another prompt to save (incorrectly) appears.



CR:158178
CR Number:   158178
Product Name:   PB Enterprise
Product Component:   DB DB2
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
B 6.0 beta3 build -believe it is build 180. Misspelling in error message in the MDI native driver.



The word "structure" is misspelled in the following string "Unable to find an available protocol driver strcuture".





PER DEVELOPMENT:

Confirmed that this error is coming from the server; thus, we cannot fix this misspelling: sqldbcode 20012, 'Unable to find an available protocol driver strcuture.'



CR:158187
CR Number:   158187
Product Name:   PB Enterprise
Product Component:   DPB
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 11 Jun 1998 Fixed
Description
Problem returning large amounts of data from dpb server back to 16 bit client. This happened in this case where an unbounded array of structures was passed by reference to the server and the server loads up the array with a bunch of data. The structure has 26 fields and there are 1500 elements in the array.

This issue only occurs with 16 bit clients.

Problem fixed in 5.0.04, but still a problem in 6.0.01



CR:158189
CR Number:   158189
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Windows with lots of command buttons, delays between the painting of each button.



CR:158196
CR Number:   158196
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
PB asserts when inheriting from a window or user object that has controls on it. This does not happen on solaris.



CR:158207
CR Number:   158207
Product Name:   PB Enterprise
Product Component:   Shared Objects
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description



CR:158215
CR Number:   158215
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
PROBLEM: When passing an array of datetime values to an Oracle function, the values as referenced in the function are the default date values, indicating the arguments are not reaching the function.



CR:158224
CR Number:   158224
Product Name:   PB Enterprise
Product Component:   Application Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
**** 5.0.04 Regression **** 16bit ONLY

Getting error message, "System error sharing violation on drive <X>:". PowerBuilder is installed locally but the pbl's are on the Novell network. If the pbl's are brought local or an NT server is used this error does not occur.



CR:158225
CR Number:   158225
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
ListView in Report mode. If the entire list does not fit within the display and you scroll down to the bottom of the list, then minimize the window on which the list is displayed, and then restore the window, the column headings of the listview become corrupt and are not readable.



CR:158227
CR Number:   158227
Product Name:   PB Enterprise
Product Component:   DW Rich Text
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jan 1999 Presently Not Targeted For Any Future Release Of This Product
Description
Printdatawindow for an RTF style datawindow doesn't work when running 16 bit under Win95. Works fine with 16 bit under NT 4.0. Tabular, etc other datawindow styles print fine. 5.0.01-5.0.04.39 have the same behavior.



CR:158228
CR Number:   158228
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Oct 1998 Not reproducible with latest version of the product available as of Resolution Date
Description
Opening a response window from the doubleclicked event of a datawindow and then closing the window results in the inability to edit data until the datawindow is clicked.



CR:158240
CR Number:   158240
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.00 26 Oct 1998 Not reproducible with latest version of the product available as of Resolution Date
Description
Using the Left and Right mouse buttons in script sometimes causes a GPF. For instance, the following:

1. Hold left mouse down.
2. Press right mouse and pick "paste" from menu.
3. Let up on right mouse
4. Let up on left mouse. GPF.

This does not happen in 6.0.00 and beyond.



CR:158243
CR Number:   158243
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description



CR:158245
CR Number:   158245
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
When you are in the script painter for the application and you exit you have to maximized the application workspace in order to get your toolbar and menu commands back.



CR:158250
CR Number:   158250
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 5007 21 Apr 1999 Fixed
Description
Microsoft Access 7.0 datasource. PB gives the error "[Microsoft][ODBC Microsoft Access 7.0 Driver] Too few parameters. Expected 1." when using a "query" (like a view in PB) as a source for a datawindow during retrieval.



MsQuery 32 bit gives the error "syntax error in from clause". Seems like a driver issue.



CR:158258
CR Number:   158258
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Sep 1998 Not reproducible with latest version of the product available as of Resolution Date
Description
5.0.03 Regression: dw PageCount() in a computed field of a datawindow object used as the dataobject for a datastore. The computed field should tell how many pages would be printed out. Worked in 5.0.02, in 5.0.03 and later, pagecount() always returns 1 (for only one page), regardless of the number of rows in the result set.



CR:158260
CR Number:   158260
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Enhancement Request - Options for Objects Menu item within DataWindow painter sorted in alphabetical sequence. Additionally, options for Controls Menu item within window painter sorted in alphabetical sequence.
Not sure what logic is used for placement, frequency of usage (?), but alphabetically would enable quick scanning and location of appropriate menu choice.



CR:158266
CR Number:   158266
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Unable to access the EntryID property of a MailRecipient Object.

Error: The Property 'entryid' was found in class 'mailrecipient', but insufficient rights are available to access it.



CR:158268
CR Number:   158268
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Informix I-Connect 7.02. (IN7) Customer gets error message after deleteing a row and saving changes and using DBParm=DisableBind=1: "Row Changed Between Retrieve and Update", "No changes made to database". NOTE: Same error occurs if you modify a row and try to save the change.



CR:158270
CR Number:   158270
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.00 RC2 29 Mar 1999 Fixed
Description
trace from Powerbuilder shows Error -201 (rc -1) : SQLSTATE = 37000 when trying to execute Informix stored procedure through ODBC





Solution:

Documentation bug in Online help:

ODBC DECLARE and EXECUTE

DECLARE logical_procedure_name PROCEDURE FOR

procedure_name

({@param1 = value, @param2 = value2, ...})

{USING transaction_object};



---> For ODBC parenthesis should not be used -



CR:158276
CR Number:   158276
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Using Oracle with O72 or O73, OR8 driver causes the error "select error: column lists do not match" previewing a datawindow when there is a retrieval argument in the select statement and there is a blank DBPARM. Even though staticbind=1 is the default, using staticbind=1 in the DBPARM explicitly causes this error to go away during preview.



In general, when this retrieval argument issue was investigated in other drivers, it was mentioned that users should use "staticbind=0" to re-describe the result set - effectively forcing the developer back to 3.0/4.0 behavior to get rid of binding problems.



NOTE: When DBPARM is left blank (meaning staticbind should default to "1") we can still see in the trace that a DESCRIBE is done on the result set and yet we still get the error "Column lists do not match". Staticbind=1 should be the default.



CR:158279
CR Number:   158279
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Solaris 2.5.1
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Solaris - Seen directly in the Window painter. Use any Window object. Right-click on the Window. Select Properties, then Position. Note there is no representation of the window in the space provided. Therefore, you can't size the window manually within this area as you can do on the Windows platform.



CR:158285
CR Number:   158285
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
EditMask scroll to the right always in Hebrew and Arabic 6.0. Changing the alignment has no effect. By the way, English scrolls to the left and alignment has no effect there either.



CR:158286
CR Number:   158286
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Using ModifiedCount() in the rowfocuschanged event of another datawindow fails when both datawindows are doing sharedata with a parent datawindow.



Example: Datawindow "a" is the parent and shares with "b" and "c"



In the rowfocuschanged of "b", there is the function call

"c".modifiedcount(). This causes a GPF in PBDWE050.DLL 0137:11589d1d when a row is deleted from the parent or "a" datawindow.



Workaround: Easy. Put the Modifiedcount() in a posted event from the rowfocuschanged event in datawindow "b"



CR:158310
CR Number:   158310
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
***Regression****



OS and version: win nt 4.0 , win 95 32 bit and 16 bit {pb 5.0.03}



Keywords:: External function call



Problem description: Customer is trying to make a call to an external function she wrote.



Customer gets the following error



"Unsupported argument type in function ml_net_addconnection in herdll.dll". This error message did not appear in pb 5.0.02.



This issue was fixed with pbrte050.dll w.r.t pb5.0.04. I also tested this out in pb 6.0 build 235.

A -1 error is returned, but all the custoemr wants is to be able to use this function call ml_net_addconnection





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具:ReadASADB。
此工具支持ASA v5.0,v6.0,v7.0,v8.0,v9.0,v10.0,v11.0,v12.0等版本。
恢复Sybase SQL Anywhere的工具在国内应该算首创。

ReadASADB功能
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具

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

ReadASADB适用场景

各种误操作:

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

本工具的应用场景:

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