远程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:155531
CR Number:   155531
Product Name:   PB Enterprise
Product Component:   Machine Code Deployment
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
Created a machine code executable and checked the trace information box they do not get a .dbg file created when they execute with the /pbdebug option. A .dbg file is created when they execute a pcode executable with the /pbdebug option.



Development: Made it so you only need to check the 1 box.



CR:155534
CR Number:   155534
Product Name:   PB Enterprise
Product Component:   Window Painter
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
When using the Drag Drop feature for a SLE control, the ICON does not show properly on the Drag Drop Properties Tab, and an outline of the SLE is dragged instead of the selected ICON when running the app.



CR:155551
CR Number:   155551
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
GPF in PBRTE050.DLL when running a window - CONTROL-W - that calls an RPC function. Doesn't happen if you run the application.



CR:155556
CR Number:   155556
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
NUP style datawindow. SelectRow(currentrow, TRUE) selects the entire NUP row horizontally across- which may contain 2,3,4,N rows. It should not highlight across the datawindow - only the row selected.



CR:155557
CR Number:   155557
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
Constants using "This" operator cause GPF only if last variable in computation.

ex: integer_variable = 1 + 2 + this.ic_max

//ic_max is a constant. Declaration: Constant int ic_max=10



CR:155558
CR Number:   155558
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Sep 1998 Presently Not Targeted For Any Future Release Of This Product
Description
5.0.03 Regression - Datawindow blob columns (color or black and white) not printing correctly, the size (font) of the blobs has enlarged which, when using the test pbl, results in the blobs overlapping. Problem exists for both 16 and 32 bit PB and color and black and white printers.



CR:155566
CR Number:   155566
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
4k Memory leak in PBRCS050 during initialization. Fixed in 5.0.03 and 5.1 code bases.



CR:155568
CR Number:   155568
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 1998 Not reproducible with latest version of the product available as of Resolution Date
Description
GPF in SQL Server ODBC driver sqlsrv32.dll, Microsoft SQL Server 6.5 version is 2.65.0201. GPF at 0137:04c0b3df when retrieving a datawindow with a retrieval argument of type number. The datawindow does a join but there are no primary keys on any of the tables.

Development: Cannot reproduce GPF in PB6 with sqlsrv32.dll 2.65.0240



CR:155570
CR Number:   155570
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 9002 13 Nov 2000 Fixed
Description
Setting the horizontal split scrollbar property to zero, and then retrieves the value of the horizontal split scrollbar property it is returning a positive number, 5. Doing either a describe or direct reference of the property returns the same value, 5.



CR:155572
CR Number:   155572
Product Name:   PB Enterprise
Product Component:   Window 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
list view object extendedselect= false so as to not be able to do a multiple select of the objects. This works correctly for the mouse control but if the cursor is used while holding the shift key down multiple items can be selected.



CR:155576
CR Number:   155576
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Blobedit function causing memory leak. Assigning some data to a local blob variable in script isn't releasing memory when the script is completed.



CR:155578
CR Number:   155578
Product Name:   PB Enterprise
Product Component:   Machine Code Deployment
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
Gpf in PBSHR050.DLL at 014f:111115ee when calling setitem() to place an 'any' that was initialized with a decimal value into a decimal column of a dw.



Development: same as fixes for other null problems. PBCMP050.DLL 5.0.03.06. You must compile with 5.0.03 or higher. It's not enough to just use 5.0.03 DLLs with an executable compiled with 5.0.02, it will still GPF.



CR:155579
CR Number:   155579
Product Name:   PB Enterprise
Product Component:   Menus - Runtime
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
Calling the ChangeMenu function on an MDI frame followed by an OpenSheet call which uses the actual sheet window object name as the first parameter instead of a window variable will cause menu items to shift position after the OpenSheet function call. The Sheet window in this case does not have a menu of its own, there is only a menu on the frame. If the ChangeMenu function is not used, this problem does not occur.



CR:155586
CR Number:   155586
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   4.0.06
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 16 bit pb 5.0.02, pb 5.0.04



If a modify forces a re- retrieval of crosstab dw, the formatting of the DW is lost.



When the user issues a reretrieve of data using a modify statement on the crosstab the format ( look ) of the datawindow changes



dw_1.dwModify("datawindow.crosstab.values='sum(units for crosstab)'") to

dw_1.dwModify("datawindow.crosstab.values='sum(profits for crosstab)'")



In 3.x, if you did a modify, the formatting was preserved. in 4.0.x and 5.0.x, the formatting is lost when you do the modify. Even though the re-retrieve problem introduced in 4.0.x has been solved, the formatting issue is still a problem. A really ugly workaround would be to write a function to re-apply all the formatting, but this could get complicated really quickly...



CR:155588
CR Number:   155588
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   MS Windows 3.1
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
MKS Version Control Archive Directories located in the XXXXXX.CFG file will not allow large list of file paths to be opened after saved to a file.



CR:155592
CR Number:   155592
Product Name:   PB Enterprise
Product Component:   Window - Runtime
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
Treeview attribute PictureMaskColor being saved as StatePictureMaskColor.



CR:155593
CR Number:   155593
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)
17 Apr 1998 Fixed
Description
Columns defined in SQLAnywhere as char are being piped to Informix datatype of nvarchar. If the database does not have NLS (National Language Support) activated, you will get a SQL -201 error: a syntax error has occurred.



Workaround: If you change the nvarchar to varchar, the table will pipe.



In 4.0, char datatype is sent to Informix as varchar, and pipeline works.



CR:155597
CR Number:   155597
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Retrieval argument font underline attribute not painting correctly when placed in a nested report. Works fine when previewed by itself.



Development: No specific fix. Fixed with other problems with painting nests and retrieval arguments.



CR:155599
CR Number:   155599
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)
17 Apr 1998 Fixed
Description
Assigning a row from a DataWindow to a Structure using dot notation and specifying the buffer, results in an error.



PER DEVELOPMENT:

If "data" is not immediately followed by "[5]", the code assumes that we're dealing with an array; the fact that we eventually get to "[5]" (i.e., ...data.primary[5]) says that this is an array with only one value. The doc is correct in saying that both "dw_1.object.data[5]" and "dw_1.object.data.primary[5]" access current data for row 5. I suppose the Usage description on page 160 could be beefed up to say "when row number is omitted or not immediately after the data keyword" (or some such thing).



CR:155606
CR Number:   155606
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Informix INET 5.01 version WJ and WF1 Float Precision is set to 8 decimal places. In db painter indicates the correct number. In a datawindow the 8th position is not the same.



Workaround: The float datatype in Informix is being mapped to "real" in the datawindow. Change to "number" and the problem will go away. Users will old datawindows can either rebuild them from scratch (which will remap the "float" datatype correctly to "number") or delete and readd a column to force Powerbuilder to clean this up.



CR:155610
CR Number:   155610
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 22 Oct 1998 Not a Bug
Description
Font.Escapement property settings makes positioning field correctly difficult. There may be a bug as far as what the valid escapement values are. Indeed, if I used 1800 or 2700 there was no display at all. I also created a new freeform datawindow and tested several escapement values for both the column heading and some text objects I added to the datawindow object. In these cases, if the escapement was non-zero, the column/static text did not display.

Per development:
No bug -- code is working as designed. The anchor-point for the rotated-text has always been tied to the text-alignment setting of the field. We can't change the algorithm for a patch release. This would have to be an enhancement to the text-rotation feature to add a new Anchor Point property for the Escapement property. Changing the way it works now without adding a new property, would affect reports already in production at the client sites.



CR:155612
CR Number:   155612
Product Name:   PB Enterprise
Product Component:   Debugger
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
Debugger doesn't show shared variables of a window sheet instance declared from a global window type using OpenSheet().



Fixed in 6.0. Will not be fixed in 5.0.



CR:155635
CR Number:   155635
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
When using OpenUserObject() to place a tab control containing tab pages and "createondemand" set to TRUE, the constructor event fires twice - once when the OpenUserObject runs and once when the tab page(s) get clicked on. Workaround: Place the tab control object on the window instead of using OpenUserObject()



CR:155640
CR Number:   155640
Product Name:   PB Enterprise
Product Component:   Library Painter
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Since the control being used to display these messages is a listbox, each message will always display 1/line. I did supress the display of the useless CR/NL chars so it looks a bit better.



CR:155645
CR Number:   155645
Product Name:   PB Enterprise
Product Component:   Rich Text
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jan 1999 Not reproducible with latest version of the product available as of Resolution Date
Description
16 bit Powerbuilder only: Customer using the object browser. If he goes into one of his objects (window, dw, app), expands out events, functions,...clicks on the document cb, the document window displayed is blank. This does not happen for all his objects.



CR:155647
CR Number:   155647
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
The constructor event does not fire properly when autoinstantiation is used for a user object type global variable, nor does it work properly for user object instance variables declared from the application object.



Resolved as a result of fix for issue #382233, Bug #41327.



CR:155656
CR Number:   155656
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
256 color bitmap placed in picture control doesn't appear when creating a machine code exe. Shows fine in development.



CR:155663
CR Number:   155663
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Mar 1999 Not a Bug
Description
PB IS NOT ABLE TO INTERPRET SELECT STATEMENT WITH REMOTE DATABASE ACCESS



CR:155691
CR Number:   155691
Product Name:   PB Enterprise
Product Component:   Language - Compiler
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
Getting Fatal Execution Error R0011 Error Internal Runtime Engine failure. Call Powersoft Tech. Support NOOP. This is due to a multiline comment using the backslash and asterisk. Example (this compiles too):



FOR i=1 to 10 /*johwdfjhdjvbscjcsdcojhsdc

pojwdpcojwdpcjwscdpijcoklpkj*/



NEXT



Workaround: Reformat the multiline comment.



CR:155692
CR Number:   155692
Product Name:   PB Enterprise
Product Component:   Printing
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 29 Oct 1998 Not reproducible with latest version of the product available as of Resolution Date
Description
Printing problem with a composite report, in which the nested report

also contains a nested report of type graph. When a graph does not fit on the page, the height of the graph gets compressed in height, but part of it gets printed on the next page, overwritting part of another nested report.



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



CR:155706
CR Number:   155706
Product Name:   PB Enterprise
Product Component:   SQL Painter
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Dec 1998 Presently Not Targeted For Any Future Release Of This Product
Description
Datawindow painter option "Show Table List" not honoring deselection. Works fine in the Database painter. Query painter and report painter also do not work.



CR:155712
CR Number:   155712
Product Name:   PB Enterprise
Product Component:   Migration
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
Migration warning:

"error c0101 referenced object (nvo name), is out of date, must be converted".



Using strange construct in instance variable section containing continuation characters and embedded function calls.



// Calculated Constants

//

int s_DOS_max_filename_length = &

s_DOS_file_prefix_length + &

s_DOS_file_suffix_length + &

Len (s_DOS_filename_separator)



CR:155717
CR Number:   155717
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Memory leak copying structures using dot notation from a datawindow or datastore to a local structure.



str_test mydata



FOR ii=1 TO 5000

mydata=ds.Object.Data[ii]

NEXT



CR:155718
CR Number:   155718
Product Name:   PB Enterprise
Product Component:   Installation
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Uninstall of PB enterprise, custom install with everything selected on NT 3.51. 5.0.02. Left behind the following files in pwrs\compglry directory:

vcf1net.cnt

vcf1net.hlp

vcfiu.cnt

vcfiu.hlp.



There are from the visual components.



CR:155724
CR Number:   155724
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows 3.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
Datawindow problem. When you create a datawindow against SQL Anywhere 5.0, you get lower case and quotes. When you try to run this datawindow against Oracle, the driver is smart enough to UPPERCASE the SELECT but not the WHERE clause..

When you paint the WHERE clause in Oracle (using quotes or delimitidentifier='yes'), you get the column list for the where clause in UPPER case automatically.

''DEPARTMENT''.''DEPT_ID'' = :dept_id

SELECT ''DEPARTMENT''.''DEPT_ID'',
''DEPARTMENT''.''DEPT_NAME'',
''DEPARTMENT''.''DEPT_HEAD_ID''
FROM ''DEPARTMENT''
WHERE department.dept_id = 100; << should be uppercase and quotes. This causes an Oracle error.

This is important if the developer is going multi-platform and wants to use just one datawindow.



CR:155728
CR Number:   155728
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.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
Tree view: want event arg for DeleteItem event that would disallow the deletion.



CR:155729
CR Number:   155729
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.x Catalina 31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
The customer has defined an edit mask with 19 digits (############.#######). When he enters some values, they are rounded. Some values are corrupted.



CR:155730
CR Number:   155730
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Sep 1998 Not reproducible with latest version of the product available as of Resolution Date
Description
If I open 2 instances of the dw painter then tile them the rmb doesn't work correctly when I move between instances. If I click on an object in window 1 (window 1 is active) and put the mouse over a column or static text object on window 2 and press the right mouse button. Window 2 does not become active and the status bar does not reflect the name or coordinates of the newly selected object. However, if I select the properties option on the rmb menu I get the properties for the object under the mouse pointer. If the object on window 2 is a dw control nothing happens (no rmb menu pops up).



CR:155731
CR Number:   155731
Product Name:   PB Enterprise
Product Component:   Machine Code Exe Creation
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
There is a memory leak when using dot notation in machine code only



DUPLICATE BUG: 41077



CR:155741
CR Number:   155741
Product Name:   PB Enterprise
Product Component:   System Runtime Functions
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Apr 1998 Presently Not Targeted For Any Future Release Of This Product
Description
The GetFileSaveName function behaves differently on when run on differrent platforms. It behaves one way running on Windows 3.11 and Windows NT 3.51, another way running Windows 95 and Windows NT 4.0, and still another way running on the Mac platform.



CR:155742
CR Number:   155742
Product Name:   PB Enterprise
Product Component:   Language - Compiler
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
An array is populated with reference to a computed field using dot notation. Gave a workaround by using a getitemdecimal in a loop. this works, but still a bug.



CR:155743
CR Number:   155743
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 18 Sep 1998 Not reproducible with latest version of the product available as of Resolution Date
Description
in a composite datawindow, the refreshing of pages is wrong when retrieving data twice with a different argument. The nested report uses page() and pagecount() in its footer. The second retrieve must generate less pages than the first one. Before doing the second retrieve, you must be positionned on a page with a number higher than the total number of pages generated by the second retrieve.



CR:155750
CR Number:   155750
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Open
OS:   Microsoft Windows 95
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement request. Want access to child DWs in Composite DWs.



CR:155757
CR Number:   155757
Product Name:   PB Enterprise
Product Component:   DW - 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
Printing a datawindow containing a NESTED graph type datawindow loses GDI resources in PB5.0x. This behavior did not occur in PB 4.0x.



This is different than having a graph object on the datawindow. Bug 43752.



CR:155761
CR Number:   155761
Product Name:   PB Enterprise
Product Component:   P-Code Exe Creation
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Declaring a global constant string which is initialized as the concatenation of other global variables causes a gpf in PBRTE050.DLL when trying to create a 16 bit p-code executable. If the variables referenced are not also constants, this is probably not a bug except that it should be an error instead of a gpf. This is because constant values are initialized at compile time and a non-constant variable has no value at compile time. If the variables are also constants, this may be allowed. It still causes the gpf, however. Submitting to development for determination. (Solution of fix: Concatenation of a constant with a constant to initialize another constant should be allowed. This problem has been fixed in the builds noted. Initializing a constant to be the concatenation of non-constant variables is not legal and no changes were made to the compiler relating to this.)



CR:155766
CR Number:   155766
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
Lack of white space around the UNION keyword causes error painting UNION statement. Sometimes with databases such as Oracle, the error is cryptic (ora 933) vs error near SELECTUNION from SQLAnywhere.



CR:155768
CR Number:   155768
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Using the PBIN7050.DLL (Informix 7) driver, the SQLCA variable SQLNROWS is not being correctly updated during update operations. SQLNROWS contains a zero when multiple rows are updated.



CR:155779
CR Number:   155779
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows 3.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
Grid datawindow with Selectrow(0,false);Selectrow(row,true) in the clicked event. Occasionally, when clicking on a horizontal line of the grid, it's possible to have one row highlighted but another row(column) which has focus and the edit control. Settings of Mouse Selection and Column Moving don't make any difference.



CR:155780
CR Number:   155780
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.x Catalina 1032 06 May 1999 Fixed
Description
When resizing a dw control with a composite dw attached to it while the retrieve is still going on, and did not end, the results are displayed incorrectly when the retrieval is finished. This does not happen with other types of dw. Resizing the dw control while non composite dw's are being retrieved does not cause any problems.



CR:155786
CR Number:   155786
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Editmask control on window with or without editmask - you can't enter a decimal number using the number pad and '.' which is really a ',' (comma) in European format. Need to set up your system for Comma decimal seperator in Regional Settings in control panel to see this.



CR:155793
CR Number:   155793
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 95
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
Datawindow with an OLE column using Word 6.0. When the document is updated in the datawindow, and then reopened by double clicking on it, the word document format is corrupt: it displays as a very narrow column in Word instead of as a full width document.



CR:155794
CR Number:   155794
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 01 Dec 1998 Duplicate
Description
Customer has datawindow with columns that are beyond the width of page. They destroy these columns in script but when printing, they get blank pages (as if the runtime engine thinks the columns off the page width are still there). Workaround: Use another datawindow for printing with the columns removed and use "sharedata".



CR:155797
CR Number:   155797
Product Name:   PB Enterprise
Product Component:   Window 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
Listview, report view. Scrolling down to the bottom, then deleting items and re-populate it. The scrollbar does not reset to the top. Sometimes the data will be displayed over the column title and sometimes, if there is a much shorter list of data, no data will display at all until you manually scroll up to the top.



CR:155804
CR Number:   155804
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)
12 Jan 1999 Not reproducible with latest version of the product available as of Resolution Date
Description
When opening two new sheets in a MDI frame, closing the original sheet, then using the ArrangeSheets(tilehorizontal!) function - instead of two sheets each taking approximately 50% of the screen, the new sheets each take up about 1/3 of the screen positioned up from the bottom leaving the top 1/3 of the screen empty.



CR:155805
CR Number:   155805
Product Name:   PB Enterprise
Product Component:   DW - Runtime
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
32-bit PowerBuilder 5.0.01 and 5.0.02 released versions



Getting an access violation when assigning a row from a datawindow to a structure using dot notation where an integer column of this datawindow row has been set to null. In Win95, the GPF is in PBRTE050.DLL Also occurs for decimal and long datatypes.



Development: Cannot reproduce in later versions of 5.0.04 and 6.0



CR:155812
CR Number:   155812
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 sharedata between two datawindows. Then turning querymode ON for primary datawindow, retrieving data and turning querymode OFF. Now setting queryclear to 'yes' on primary datawindow to reset the criteria : the PC hangs or a GPF occurs in PBDWE050.DLL



CR:155815
CR Number:   155815
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows 3.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
Using a crosstab datawindow which has a summary computed field that sums the values of multiple columns. When trying to obtain the data into an array of type ANY, the values are displayed as null however the array size seems to be okay.



i.e. any my_array[]

my_array = dw_1.object.computed_field.Original



This is documented on page 152 of the Datawindow Reference Guide.



CR:155823
CR Number:   155823
Product Name:   PB Enterprise
Product Component:   Shared Objects
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
User Object painter using user object structure for function arguments is case sensitive. You have to enter lower case for the argument type or you get an error: "Argument type 1 is not defined". No problems if you use a global structure type. Happens with any object structure (Menu Structure in Menu Painter, Window structure in window painter, etc).



CR:155827
CR Number:   155827
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Gpf at pbrte050.dll 0137:10b16fc6 when dragging and dropping a statictext control on a dw which doesn't have a dataobject associated with it.



CR:155829
CR Number:   155829
Product Name:   PB Enterprise
Product Component:   Language - 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
calling a function which has a powerobject argument passed by reference using DYNAMIC option produces a runtime error : "bad argument list for function/event f_ref..."



CR:155830
CR Number:   155830
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)
13 Aug 1998 Presently Not Targeted For Any Future Release Of This Product
Description
PB5 Win95 : decimal tabs doesn't work neither in RTE control nor in datawindow RTF. They behaves as left tabs, not decimal tabs.

See PB Product Management Support Statement : PowerBuilder Rich Text Support
http://techinfo.sybase.com/css/techinfo.nsf/DocID/ID=47864



CR:155833
CR Number:   155833
Product Name:   PB Enterprise
Product Component:   DPB
Status:   Closed
OS:   Solaris 2.5.1
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
DPB,after processing data from client to server, and you shutdown and restart the server, PB will crash. This happens in development mode or in exe form, the DPB server is on Solaris, and the client can be on NT or Solaris. Found this when testing the Solaris version of WebPB, once the DPB server gets a WINSOCK_RECV_ERROR, and you stop and restart the server it crashes.



CR:155840
CR Number:   155840
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
LinkTo() using a .bmp file shows black diagonal lines through the bitmap on the ole2 control on a window. Embedding this in the same control doesn't show the diagonal lines.



CR:155841
CR Number:   155841
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.01 17 Apr 1998 Fixed
Description
The x1 coordinate of a line object in a dw disappears when the properties dialog for the line object is closed and then reopened and viewed in the expressions sheet.



CR:155845
CR Number:   155845
Product Name:   PB Enterprise
Product Component:   Machine Code Exe Creation
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
Embedding an ANY datatype variable with the powerscript function Mid() causes a machine compile error:

ot_get_data_any 'has not been declared'. The script would look something like:



any current_object

ls_CurrentTabPgNumber = MID(current_object.ClassName(),2 ,1)



Workaround: Place the return of any_variable.classname() into a string variable and use the string variable with Mid().



CR:155846
CR Number:   155846
Product Name:   PB Enterprise
Product Component:   Printing
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
A stack fault results when printsetup() is invoked for Xerox drivers and the 'setup' button on the print setup dialog box is depressed in win 3.x with pb 5.0.x.



Cannot recreate during 6.0 beta.



CR:155850
CR Number:   155850
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Mar 1999 Not a Bug
Description
When looking at the print preview from the datawindow painter (landscape) all columns over the 11 inch mark that have the visible property set to zero are being previewed and printed as blanks. i.e. blank page.

Per Development:
Not a bug. The DW Engine only alters the report width for invisible objects when the presentation style is grid, or the right-most object is a nested DW. It has always been this way. It cannot be changed as release patch, as it could affect hundreds of established reports already in use in the client base. Any change would have to be implemented as an enhancement that would only affect a report if the user specifically requests it.



CR:155854
CR Number:   155854
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 11 Nov 1998 Duplicate
Description
Problem: A composite report with two columns prints with a second blank page.



CR:155855
CR Number:   155855
Product Name:   PB Enterprise
Product Component:   Window - 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
GPF when using run window button from function painter twice in a row.



Solution:Cannot recreate in 6.0 233. Will not be fixed for 5.0.



CR:155857
CR Number:   155857
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Dec 1998 Presently Not Targeted For Any Future Release Of This Product
Description
In version 5, the 6th level of nested is not showing up when viewing the psr file although the 5 first levels are showing correctly (without retrieve, isn't that against the manual ?). In version 4, even after a retrieve, psr's with so many levels are not showing the data.



CR:155858
CR Number:   155858
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows 3.1
Original Version:   4.0.06
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
When the whole of the nested dw will not fit on the remainder of a page PB starts a new page. This results in pages being left half blank and therefore wastes space and paper For example, if a nested report takes up 1.5 pages for 1 row of the base report, instead of placing the second row (of the base report) immediately at the end of the nested report and hence split the nested report for the second row over the next page, PB places the 2nd row of the base report on a new page. The customer does not want this to happen. He wants the 2nd row to be placed immediately after the nested report and hence leave new gaps



CR:155861
CR Number:   155861
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
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
Selecting a TIMESTAMP column in the datawindow painter and previewing causes the following error:



Select Error: Data-conversion resulted in overflow.



The trace shows the BIND goes from len=8 to len=2 causing the overflow. Found in SYB going against Microsoft SQL Server 4.x



CR:155866
CR Number:   155866
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 12 Aug 2004 Not reproducible with latest version of the product available as of Resolution Date
Description
Informix. When doing using multiple tables and multiple outer joins, the SQL syntax generated has multiple occurances of the OUTER keyword after the FROM keyword. Ex: FROM <tablename>, OUTER OUTER OUTER <tablename>



CR:155867
CR Number:   155867
Product Name:   PB Enterprise
Product Component:   DW - Runtime
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
Datawindow control : unable to capture ALT key and point key of the numpad.



Per development:

The ALT key cannot be captured. This is expected behavior.

Numpad '.' works in 6.0. Fixed numpad '.' in 5.0.05.



CR:155868
CR Number:   155868
Product Name:   PB Enterprise
Product Component:   Printing
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   5.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Mar 1999 Not reproducible with latest version of the product available as of Resolution Date
Description
Very specific issue with LaserFax (UK) product ( a faxing product like Winfax that uses a print driver concept). GPF in GDI.exe when printing datawindow containing a picture (bitmap) to fax - OK when the bitmap isn't on the datawindow. Also getting GPF in PBRTE050.DLL.



CR:155869
CR Number:   155869
Product Name:   PB Enterprise
Product Component:   System Runtime Functions
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
Memory leak when using null value in PB 5.0.03. A pibble is available on \\Yipee\PT FIles\Temp\pt383955.ZIP



CR:155871
CR Number:   155871
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Dec 1998 Fixed
Description
Building invalid string argument for Modify function then calling modify with that arg causes a GPF in PBDWE050.DLL. Shouldn't gpf, but easy to code with error checking to avoid this.



CR:155874
CR Number:   155874
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)
18 Jan 1999 Fixed
Description
in datawindow painter, when editing once again the properties of a column with an editmask style, some attributes that had been checked (like required, spin control) are no more checked.



CR:155875
CR Number:   155875
Product Name:   PB Enterprise
Product Component:   DPB
Status:   Closed
OS:   MS Windows NT 3.51
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
Problem description: Customer cannot trigger or post events from connectbegin and connectend events, in his dpb application.



He is trying to trigger a command button from the connectionbegin . This may be behaviour or bug. Wont work in any version of Powerbuilder.



CR:155878
CR Number:   155878
Product Name:   PB Enterprise
Product Component:   DW 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
Previewing a composite datawindow causes a GPF in PBDWE050.DLL 0040:2671 when doing a cancel (DBCancel) in the datawindow painter or at runtime. 5.0.02.



CR:155881
CR Number:   155881
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
When placing a Nested report containing a group in the summary band of the parent datawindow and previewing, the first row of the nested report group header is missing. Placing the nested report in the detail section works fine.



CR:155883
CR Number:   155883
Product Name:   PB Enterprise
Product Component:   DW DDDW
Status:   Closed
OS:   MS Windows 3.1
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
Lines in Dropdown property of dropdowndatawindow column in a datawindow is ignored the first time that column gets focus. If the value is greater than zero, only one row drops down the first time the column gets focus. If you move focus to another control and then back to the dddw column, then the number of lines that display is correct, i.e. equal to the setting for the "lines in dropdown" property.



Workaround: Set lines in dropdown to zero and then 8 lines will be displayed.



CR:155884
CR Number:   155884
Product Name:   PB Enterprise
Product Component:   DPB
Status:   Closed
OS:   Solaris 2.5.1
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
WebPB for solaris, WebServer will get a WINSOCK_RECV_ERROR with last error: WSAEWOULDBLOCK when getting environment information from the netscape server



CR:155885
CR Number:   155885
Product Name:   PB Enterprise
Product Component:   Source Control
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
SCC Prompts you to overwrite writable files in working directory, if you select No, the file is not overwritten, but it is deleted.



CR:155891
CR Number:   155891
Product Name:   PB Enterprise
Product Component:   DPB
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 May 2001 Presently Not Targeted For Any Future Release Of This Product
Description
Distributed PowerBuilder Server using NamedPipes driver: If you place the DPB Server executable on a network drive, then remote client's will not be able to connect to the DPB Server.



Work-Around: Place the exe on a local drive or use WinSock driver instead.



CR:155894
CR Number:   155894
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jul 1998 Presently Not Targeted For Any Future Release Of This Product
Description
RTF Control on a window does not interpret some special characters correctly when you insert a file that contains them. Example sent includes CTRL-<minus key> , CTRL-<numlock>-<minus key>, and CTRL-SHIFT-<dash/underscore>



CR:155896
CR Number:   155896
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows 3.1
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
Create a datawindow using a table with a blob column. Place a blob object on the datawindow. Preview the datawindow and double click on the blob object. When word is activated, place some text into the document, then update it. The text that is displayed in the datawindow is distorted. Update the document again from word and the text appears correctly.



CR:155903
CR Number:   155903
Product Name:   PB Enterprise
Product Component:   DW - 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
Problem with dd/mm/yy edit mask format. If the month entered is Oct, Nov, or Dec and the day entered is 10,11, or 12, the format of the mask switches to mm/dd/yy.



Additional testing showed that there was more to the problem than just testing the 3 months of Oct, Nov, and Dec. My testing showed that whenever the two values entered for month and year were less than 13, i.e. were valid numbers for a month, the editmask simply interprets the incoming string as already being in the dd/mm/yy format and does no checking. If the day number entered was greater than 12, i.e. not a valid month, then further checking was done and the mm/dd/yy format of the string entered was successfully rearranged into the dd/mm/yy format of the editmask control. More details than you probably want follow.



Date editmask. Customer wants users to enter a date in an sle in one format (mm/dd/yy), but display in an editmask in a different format (dd/mm/yy). The editmask does not always correctly interpret the entered date. Details follow, but a summary is that we only use the machine system date setting under certain circumstances when interpreting a date passed to an editmask as a string, and the user would like us to always use the system date setting for interpretation.



**Note that this issue deals with US English settings, and the problem and workarounds must be dealt with in that context. International system date settings would be handled differently within the users code.





The code example for this issue included an editmask control of type date, with an editmask format of dd/mm/yy. The user entered a date in the format mm/dd/yy in a single line edit control. Then the date function was used to convert the entered string to a date, and the editmask.text value is set to the string of that date

(editmask.text = string(date_var)) Using different format strings on the string conversion function had no effect on the results.





*Per Development*: This is due to function internals, and will be treated as an enhancement request rather than as a bug. The following editmask formats work fine, so unless/until this is fixed, use them instead:



dd/mmm/yy

dd/mm/yyyy

mm/dd/yy



WORKAROUND:

Here is the existing customer code. There is an editcontrol em_1. There is a singleline edit control, sle_1. The system date format under regional settings is "mm/dd/yy". The editmask format setting is "dd/mm/yy". The application wants users to enter a date in the sle in the format "mm/dd/yy" and then have the editmask display in the format "dd/mm/yy"



////CODE THAT CAUSES A PROBLEM, in clicked event of a command button:

date ld_date

ld_date = date(sle_1.text)

em_1.text = string(ld_date)



//WORKAROUND IS TO MODIFY CODE AS FOLLOWS:

date ld_date

ld_date = date(sle_1.text)

em_1.text = string(ld_date,"mm/dd/yyyy")



////////////////////

The reason for this is that the editmask control is being passed a string, not a date. It assumes that the string is in the format expected by the editmask definition, unless the

length of the string and the editmask format do not match. Then it will look at the machine's system date setting in order to determine what the valid date format is, and so determine which 2 digit value is the day and which is the month, and do

a proper conversion to the defined editmask format. Adding the format string with 4 digits for the year to the call to the string function forces a check of the system date format setting, and enables the editmask to correctly interpret which value is the month and which is the day, and then to rearrange them to match the defined mask of the editmask control.



The reason that some date values worked the way the user wanted and some don't was that if a date is interpreted as invalid coming in, it would also force a check of the system date format, and would then be interpreted as the user desired. Whenever the value for the day was 12 or less, ie. a valid number for a month, the program would not work as the user desired. If the value for the day was 13 or greater, ie not a valid value for a month, we would check the system date format setting, and figure out that the month was expected before the day, and then do the "swap" from mm/dd to dd/mm desired by the user.



This is best illustrated by examples:

sle: 01/02/97 goes into the editmask as 01/02/97 since both 01 and 02 are valid month values. The string coming in passes the check for both a valid length, and valid values for a date, so the system setting is never checked, and the string goes in as is even though the mask is defined as dd/mm/yy.



sle: 01/24/97 goes into the editmask as 24/01/97, just as the user wants. This is because although the string passed to the editmask passes the length check, it does not pass the data type check because 24 is not a valid month. So the next check is the system date setting of mm/dd/yy. So now the editmask determines that 01 is the month and 24 is the day, and it can put the values in the the dd/mm/yy editmask correctly.



Adding the string conversion format does the following to the 01/02 example. sle value entered is 01/02/97. But the editmask is passed 01/02/1997 instead of 01/02/97. Now the length of the string and the mask are compared, and since they differ, the system date format is checked. The system date format mm/dd/yy tells the editmask that 01 is the month and 02 is the day, so the editmask correctly sets the values to dd/mm/yy as 02/01/97.



CR:155904
CR Number:   155904
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
Selectedtab=2 in the constructor of a tab control with CreateOnDemand ON causes the constructor to be fired twice. Workaround: Post the "Selectedtab" outside the constructor event.



CR:155906
CR Number:   155906
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)
6.5.00 28 Oct 1998 Fixed
Description
Using dot notation to copy array elements from an array to the datawindow buffer. The datawindow only shows 1 row when 100 rows should appear and user should get a scrollbar.

Workaround: Issue a Filter() or Setredraw(True). There are many cases with dot notation and SetItem() where changing the buffer doesn't "bubble up" the change to the display. Issuing a Filter() or Setredraw(true) will normally force the display to repaint and you will see all the rows.



CR:155908
CR Number:   155908
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 3.51
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 1998 Fixed
Description
Re-Retrieving a nested or composite PSR placed in a datawindow control causes a GPF in PBDWE050.DLL. Re-retrieving a non-nested report works fine.



Fixed in 6.0 only.



CR:155911
CR Number:   155911
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.x Catalina 1045 29 Apr 1999 Fixed
Description
If the user sets the current sqlid and sets pbtableowner='no', the pbcat tables are not found when previewing data in the DBA Notepad or when building a datawindow. The explanation seems to be that PB only uses the pbcatalogowner='blah' when searching for the catalog tables at connect time. It seems that we should at this point be using the pbcatalogowner that the user specified to go after the pbcat tables and not the logid or the current sqlid of the user.



CR:155913
CR Number:   155913
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Nov 1999 Fixed
Description
Arabic Powerbuider 5.0.02 & Informix: If you use the Retrieve function in script and include Arabic characters, it will return SQL Error: -202: "An illegal character has been found in the statement". In addition, if you use Arabic characters in extended attributes (headers or label) in a table it also displays this error message.



CR:155916
CR Number:   155916
Product Name:   PB Enterprise
Product Component:   DW Rich Text
Status:   Closed
OS:   MS Windows 3.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
Setting the LineRemove property to 'true' or 'yes' for columns in a rtf (Rich Text) datawindow has no effect on empty input fields. Neither dot notation, nor modify syntax work.



CR:155917
CR Number:   155917
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows 3.1
Original Version:   5.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Oct 1998 Presently Not Targeted For Any Future Release Of This Product
Description
Problem: System resources leak in PB Window painter in PB 5.



CR:155919
CR Number:   155919
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)
7.0.00 RC0 4021 28 Jan 1999 Fixed
Description
Enhancement. Describe() doesn't return the retrieval arguments and datatype. Long standing bug.
Need a property that handles this directly.



CR:155922
CR Number:   155922
Product Name:   PB Enterprise
Product Component:   Window Painter
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
Would like to be able to change the property of several objects at a time.



CR:155927
CR Number:   155927
Product Name:   PB Enterprise
Product Component:   Language - 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
Memory leak when accessing methods of a non instantiated object



CR:155928
CR Number:   155928
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Enhancement. Want built-in "Find" window for datawindow painter and runtime. Search all or for column. "Find and filter" would be nice too so in one or two clicks, you'd have the functionality to highlight a text throughout the datawindow or find/filter mode which would filter down all rows matching a certain text field..





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从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等等。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------