Sybase数据库技术，数据库恢复专家

This is not a bug, but a result of the changes in 8.0 with exception handling. See CR 239632 for details.

following error:

SOAP Exception

Error while parsing SOAP XML payload: reference to invalid character number

The load file shows:

CLOSED

REQUEST:

CLOSED

POST /Crypto/CryptoService.asmx HTTP/1.1

Host: localhost

Connection: Keep-Alive

User-Agent: EasySoap++/0.6

Content-Type: text/xml; charset="UTF-8"

SOAPAction: "http://tempuri.org/EncryptMessage"

Content-Length: 443

<E:Envelope

xmlns:E="http://schemas.xmlsoap.org/soap/envelope/"

xmlns:A="http://schemas.xmlsoap.org/soap/encoding/"

xmlns:s="http://www.w3.org/2001/XMLSchema-instance"

xmlns:y="http://www.w3.org/2001/XMLSchema"

E:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">

<E:Body>

<m:EncryptMessage

xmlns:m="http://tempuri.org/">

<m:text

s:type="y:string">encrypt this</m:text>

</m:EncryptMessage>

</E:Body>

</E:Envelope>

RESPONSE:

HTTP/1.1 100 Continue

Server: Microsoft-IIS/5.0

Date: Wed, 22 Jan 2003 14:09:09 GMT

RESPONSE:

HTTP/1.1 200 OK

Server: Microsoft-IIS/5.0

Date: Wed, 22 Jan 2003 14:09:09 GMT

Cache-Control: private, max-age=0

Content-Type: text/xml; charset=utf-8

Content-Length: 449

<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><EncryptMessageResponse xmlns="http://tempuri.org/"><EncryptMessageResult>g
LSHqlhl](Iz6e'gJ.`oz</EncryptMessageResult></EncryptMessageResponse></soap:Body></soap:Envelope>

Example:

The following will return a 1, but will not print the BMP on the Page

li_ret1 = PrintBitmap(Job, s_bmp, 50,100, 1000,1000)

The following will return a 1 and prints the BMP in the Upper Left corner of the page

li_ret2 = PrintBitmap(Job, s_bmp, 50,100 * -1, 1000,1000 * -1)

Could not test on a PocketPC device.

*** Tuesday, January 28, 2003 10:21:31 AM *** kirchner ***

Update:

Tested build 12 and it works fine on Emulator 2000.

Could not test on a PocketPC device.

The following embedded sql is used:

DECLARE sp_test PROCEDURE FOR Proc4 VAR=:ls_arg_in,VAR1=:li_arg_out

USING SQLCA;

Execute sp_test;

When the execute statement is processed, the sqlcode return value is 100. When the fetch

statement is processed, the sqlcode return value is -1.

Versions and Build #s Reported: PB 7.03

Versions and Build #s Tested: 7.03.10243 / 7.03.10256 / 7.03.10251 / 7.03.10260 - FAILED

7.03.10227 and earlier -> ALL WORK

8.03.9809 /8.03.9820 / 8.03.9850 - FAILED

8.03.9704 and earlier - All WORK

9.0.5058 - FAILED

Comments:

If, from a response window, you close the window where the response window was opened PB will crash.

For example, in a main window open the response window

OpenWithParm(w_resp, parent)

On a button in the response window close the main window

// in the window open event

// iw_1 = message.PowerObjectPArm

Close(iw_1)

Crash in PB 8.03.9850 is:

"Instruction at 0x000a0d29 referenced memory at 0x000a0d29, memory could not be read."

Crash Handler info in PB 7.03 (full file is in the repro zip)

Exception code: C0000005 ACCESS_VIOLATION

File Name: unknown

File Version: unknown

Fault address=00000004 Section:Offset=00:00000000

Registers:

EAX:01EF0D00

EBX:01053C00

ECX:020377E0

EDX:020382A8

ESI:01EF3AB4

EDI:00000001

CS:EIP:001B:00000004

SS:ESP:0023:0012E8B0 EBP:0000C000

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

Flags:00010202

Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

00000004 0012E8AC 00000001 01EF3AB4 0000C000 01053C00 0000:00000000

113869D3 0000C000 00000000 00000000 00000000 00000000 0001:001659D3 F:\Builds\PB 7.x\7.03.10260\PBVM70.dll

The problem is a regression because PB 8.0.1 release is OK and does not cause a gpf.

the following error:

---------- Deploy: Deploy of p_ejb_proxy1

Retrieving Powerbuilder Proxies from EJB...

Generation Errors: Can't get information of example.ejb20.basic.containerManaged.AccountHome

Deployment Error: No files returned from server for package/component: 'example.ejb20.basic.containerManaged.Account' EJBServer error code: Unknown Proxy was not created.

---------- Finished Deploy of p_ejb_proxy1

It appears that none of the COM+ additions appear in doc.

1. two checkbox controls seem superimposed over two buttons at middle of the dialog

2. There is a properties button that always seems to be disabled at the bottom. I don't think it has any function and does this in PB8 too - so just remove it??

Powerbuilder build 5501 RC and the Sybase DataWindow PS driver is not installed.

In control panel/printers, the printer does not show up.

in the database painter.

When connecting with Informix native driver IN7 or IN9 the temp table is

not created and the sql error is:

"Select error: Cursor is not open"

When connecting with Informix through ODBC then the temp table is

created but still there is the sql error is:

"Invalid cursor state"

The datawindow has 47,000 rows.

From development - 2/3/2003:

A hourglass will now appear to show that PB isn't really hanging while the PDF is being

generated.

Reviewed by PB Engineering:

There is no problem here. Because the stored procedure captures all errors and exits cleanly, SQLCA.SQLCode in PB will be 0. When SQLCA.SQLCode is 0 then looking at SQLCA.SQLErrText is not valid. To capture the -1 returned by the stored procedure you need to call the proc as:

rc = SQLCA.blob_arg(ld_id, lb_col)

Source of error after being looked into by development appears to be EAServer 4.2 but no final solution was found.

The following workaround worked for us and the customer :

Follow these steps.

1. Look for following entry in registry.

HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{CLSID of QMSGEOSTAN.OBJECT }\InprocServer32

ClassID for QMSGEOSTAN.OBJECT should be {39A0EAB1-6E9A-11D0-8DA5-006097096AB9} as per test case. If not find it out.

2. Look for "ThreadingModel" string value under "InprocServer32". If not found create one.

3. Set the value of "ThreadingModel" to one of the followings

A. Apartment

B. Both

C. Free

D. Neutral

4. Start Jaguar and test it again

Try 4 values i.e, "Apartment" , "Both", "Free" and "Neutral" one by one. I am not sure which one will be suitable for client.

Versions and Build #s Reported: 8.0.3 #9838

Versions and Build #s Tested: 8.0.3 #9838 and 9.0 #6001

Database/Driver File/Version:

Comments: This seems to be related to CR 171038 BRC-6.5.00 Regression. Real(), Double() Powerscript/DW f(n) data corruption.

Step-By-Step Instructions: See "Repro" tab

TEST 1

******

0. create folder C:\TEMP\Sybase_supp , put there 99120S01.tif and 99120S01.tfw

1. put all other files in one other folder

2. set reginal settings decimal separator to "," and digit grouping symbol to "."

3. register dlls and ocx mentioned in the mo_reg.bat file

4. open the test_real_convert.pbl and run it

5. press the button "test convert" this shows the result of real('2,3456E2') and double('2,3456E2')

-> 234,559.... rounding issue!!!!!! and 234,56

6. press the "open GIS" button. that should show a map

I had some problems to get the OCX registered well on one PC. Intead of opening the window with the OCX just try to place the OCX on the window w_gis in the window painter. you will get a licence file error but if do step 7 you'll get the same result.

7. press the "test convert" button

-> 2 and 2 the rest of the values are not converted. It seems using the OCX did some internal settings in PB.

TEST 2

use instead of real('2,3456E2') the dot -> real('2.3456E2')

there are some more PBLs for testing the different behaviour with real() and double() which seems to be related to CR 171038.

Test Case (zip file) Name: 20308540.zip

Not a bug.

Versions and Build #s Reported: PB 8.0.1.8004

Versions and Build #s Tested: 6.5.1 build 1326 - NT 4.0 French & US OK

7.0.3 build 10243 - US English NT 4.0 OK

- FRENCH NT 4.0 OK

8.0.3 build 9850 - Windows NT4 French FAILED

8.0.3 build 9850 - Windows NT4 US OK

8.0.3 build 9850 Windows 2000 French OK

Comments:

The Datawindow datetime editmask below does not display the seconds when run on French Windows NT 4.0

EditMask : [date][time]

Format : [shortdate][time]

Use Format : unchecked.

Also tested on a Spanish Windows NT 4.0 machine and not seen the problem.

Not tested this in all possible language versions of Windows. Only happens on a French NT 4.0 (it's not enough to change input locales , it must be a French NT 4.0 installation)

The value:

15/01/2003 15:12:48

Displays as:

15/01/2003 15:12 <-----No seconds show

On a French NT 4.0 installation using PB 8.03 or PB 7.03

You can assign an animated cursor to your controls via script. You should be able to pick these from the Properties Pane. Note: Once assigned Animated Cursors work great!

1. In the Properties panes for various controls, the File Open dialog on the Other tab for Pointer displays only .cur files.

2. When building an EXE, the .ani files are not included in the EXE or PBD even when using a .PBR file

Add a button to the window on the Layout view. Double click the button to enter script.

Enter some invalid script.

Do not try to compile or save, just click on the Layout tab to look at the visual of the object.

Now double click the button again to go back to the script view.

The painter will bring you back to the script with the compiler errors displayed.

Note that the Layout tab remains the highlighted tab, even though now you have switched back to the Script view.

Fixed in PB 8.0.3 build 9918 and PB 9.0 build 6050.

projects (except application) have items in the Edit menu that are nonapplicable/nonusable.

The items under the Edit menu are:

Paste Executable

Paste Executable's Resource

Paste Dynamic Library's Resource

When you select one of these, nothing happens.

to readonly and then using the HTML property to generate html, the columns that were changed to readonly appear editable.

Using the following code:

dw_1.settransobject(sqlca);

dw_1.retrieve()

dw_1.object.customer_tab_id.border = "0"

dw_1.object.customer_tab_id.tabsequence = 0

dw_1.object.dept.border = "0"

dw_1.object.dept.tabsequence = 0

ls_html = dw_1.object.datawindow.data.html

The workaround could be "this.show()" BEFORE the messagebox function call in the window open function. It may be a while before this gets fixed, so use the workaround for now.

Fixed in PB 7.0.3 build 10279, PB 8.0.3 build 9918 and PB 9.0 build 6050.

Versions and Build #s Reported: PB 9.0 RC Build 5058, 5501

Versions and Build #s Tested: PB 9.0 Build 5058 and 5501 - Reproduced

PB 8.0.3 builds 9704 -> 9850 - Not reproduced

Comments:

Pasting data into a dw editmask does not work if the editmask contains symbols such as dashes, slashes, brackets, commas, periods etc.

eg ##-##-## or aaa/aaaa-aaa or xxx.xxx.xxx etc.

If you highlight the entire field with the mouse first and then paste, it works fine.

If the mask symbols are removed, it also works without the need to select the entire field.

Same behaviour with Window Edit controls

Possible related CRs:

CRs 231097, 228313, 228319, CR 296916

See also CR 298650 using the Paste() function.

and using in code string ls_error = "this is an error" + CRLF

Workaround:

Change coding to :

string ls_error

ls_error = "this is an error" + CRLF

codepage in XML header and national characters in data, C++ runtime error occurs with "Abnormal program termination". The same XML in UTF-8 works fine. CP-1252 with no national chars is OK as well.

you rmb on that object in the search results panel, selecting Edit Source will allow you

to open the object without giving any warning message.

If you select Edit from the search results panel, a warning message of: "object is not checked out and therefore cannot be overwritten. Open it anyway?"

the vertical scroll bar in the right pane (where the selection is taking place) jumps up and down. There's alot of flickering with the scroll bar.

- If you look at the online help for SaveAs, you will find the following in the index:

"SaveAs method (DataWindows)"

- Select it and you get a choice between:

SaveAs method (DataWindows)

or

SaveAs method (DataWindows) (PowerBuilder Help)

- Both entries open up a dialog with title: "SaveAs method (DataWindows)"

but the first entry concerns saving the data in a GRAPH in the format :

integer dwcontrol.SaveAs ( { string filename, } { string graphcontrol, SaveAsType saveastype, boolean colheading } )

and the second entry decribes saving a (normal) datawindow or datastore with the format:

integer dwcontrol.SaveAs ( { string filename, saveastype saveastype, boolean colheading } )

- The following should be fixed:

#1: Distinguish the graph and non-graph syntaxes in the help index

#2: Distinguish the title of both entries

#3: Correct the prototype in the graph syntax from:

integer dwcontrol.SaveAs ( { string filename, } { string graphcontrol, SaveAsType saveastype, boolean colheading } )

to:

integer dwcontrol.SaveAs ( string graphcontrol, { string filename,SaveAsType saveastype, boolean colheading } )

On device: when application initially comes up, the horizontal scrollbar is a "bleed through" area on the page. If you click on it, the scrollbar paints, and seems to work okay. The Horizontal Split does not work yet, though.

On the Emulator: the "bleed through" area appears and when you click on it the app freezes. I tested a couple of times and once I could close from the OK button, but another time I had to shut down the emulator via the taskbar.

Seems to work okay when run from the IDE.

WORKAROUND: This turns out to be a problem with the format when converting a date to a string. Workaround is to use the optional format string parameter. For example:

For example, change:

messagebox("date",string(Today( )))

to:

messagebox("date",string(Today( ),"m/d/yyyy"))

and it will display the date.

The return code of 1 indicates success but the no psr file is found in directory.

Used the following syntax:

ll_saveas=ds_1.SaveAs("/export/home/EAServer/bin/newtest1.psr",PSReport!,false)

Status:

Dupe of CR 275451.

Having or Compute tabs in the datawindow painter. Also add the menu option of Insert

for the Where, Having and Compute tabs.

When you select either Where,Having or Compute in the datawindow painter and then RMB,

a menu displays. It would be easier for customers to edit a datawindow if the menu

option of insert and (either clear or delete) were added to those menus.

Reviewed by PB Engineering:

PB engineering says it's not a bug, the behavior is correct.

PER DEVELOPMENT: Not a bug: Windows now have a default caption of "Untitled". The behavior however, is not a bug, it's more a case of the user "shooting themselves in the foot" if they should choose not to have a title. The system will not put the entry into the running apps list if there is not title. If the app has been run from applist, then clicking on applist will bring up the app again and the user can use a button to close it, but if it is a standalone executable, starting it will start another instance of the application - in which case a soft reset is necessary to stop the app. This is only the case for an untitled window. It's similar to having a window on the desktop without any means of closing it, such as the control menu or X button. It is up to the user to ensure that there is a way to get back to the application.

no workaround

for instance with following Orcascript:

// all objects in a pbl

scc get latest version "C:\...\name.pbl" -allobjects

// all objects of a target

scc get latest version "C:\...\name.pbt" -allobjects

// all objects of a workspace

scc get latest version "C:\...\name.pbw" -allobjects

the fractional part is missing when using French or other international standard.

For example, a select statement of 'select 1.234 from customer' will only show the value of 1 when the regional settings of the control panel are changed to French.

Fixed by PB Engineering:

NOTE: The fix for this issue also requires the dbparm setting of 慡taticBind=0�.

will occur:

Exception in CreateJavaInstance

Error calling method of a PBNI object

When the following line is not included when trying to connect a EJB client

to a application server:

connection.connectToServer(string properties[])

Fixed in PB 8.0.3 build 9918 and PB 9.0 build 6050.

I would like engineering to look at it just quickly to determine whether there may be a problem in the underlying PBNI to be shipped with PB 9 or if it's just an issue in the coding of the JavaVM extension provided in the example.

PER DEVELOPMENT:

"SmartMinimize" is a new feature with PPC2002 - therefore it will not be available for any system running PPC2000 (namely the 2000 emulator).

Also, I'm not sure if "Dismiss" is PocketPC terminology ? PB developers would be more familiar with the "Close" or "Exit" to terminate the application and "Minimize" label to minimize the app.

resultset, the only error message is:

Datawindow Error:

Select error

A more meaningful error message is needed to alert users.

When you run an application, it will trigger the dberror event. The sqlerrtext says

"Select error". The sqldbcode is 2, which is not documented.

Fixed in PB9 build 5506.

RESOLUTION:

Retrieve As Needed will not be supported for Pocket PowerBuilder. It is not needed for the device.

From within PB all looks fine but the jsp does not work. From outside of PB when viewing the JSP in the build folder with an editor you can see the problem.

errornous results when extracting from the blob and can lead to a crash afterwards.

This is a regression in PowerBuilder 7 around Build 10180 and later,

and in PowerBuilder 8 Build 9121 and later.

embedded with ? and ', Powerbuilder will translate them incorrectly.

Using different dynamic sql formats will produce different results. The input

argument will get translated differently.

For example, using the parameter of:

Hello?World'Hello

Will translate to:

Hello?World Hello'

no workaround

Doing the same using an automation server, when calling the COM function, the erromessage: Bad Image: The application or dll .... is not a valid NT image. Please check this against your installation diskette.

*** Thursday, February 20, 2003 10:33:00 AM *** kirchner ***

Did test using path to filename and it does work. Two other CRs regarding further problems have been created.

receiving the "No Suitable Driver" error message from the database profile.

The jdbc log shows:

DriverManager.getConnection("jdbc:thinweb:@tbone:1521:orcl")

DriverManager.initialize: jdbc.drivers = null

JDBC DriverManager initialized

getConnection: no suitable driver

java.sql.SQLException: No suitable driver

at java.sql.DriverManager.getConnection(DriverManager.java:477)

at java.sql.DriverManager.getConnection(DriverManager.java:137)

at com.sybase.powerbuilder.jdbc.PbjdbcSession.CreateSession(PbjdbcSession.java:131)

SQLException: SQLState(08001)

Java PbjdbcSession::CreateSession SQLException thrown

------->SQLState = 08001

------->ErrorCode = 0

------->Message = No suitable driver

Problem happens using the following:

URL: jdbc:thinweb:conlabtt:1521/conlatt or

jdbc:thinweb:@tbone:1521:orcl

Driver: com.thinweb.sql20.jdbc20.ThinDriver

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

Versions and Build #s Tested: 7.03 GA & 7.03.10260 /8.03 GA & 8.03.9872 / 9.0 RC

Comments: Incorrect datetime format in SaveAs() function: in the text file generated, a colon (the ':' used to separate seconds from microseconds)is used instead of period ('.')

This causes difficulties when using the saveas() text file as source files for other software as this is not recognised as a valid datetime format.

According to the documentation :

A standard data type that is time in 24-hour format: hh:mm:ss.ffffff where:

hh is the hour (a number 00 to 23)

mm is the minutes (a number 00 to 59)

ss is the seconds (a number 00 to 59)

ffffff is the microseconds (a number 000000 to 999999)

The colons (:) and period (.) are required. Blanks are not allowed.

For example, 23:59:59.999999 is one microsecond before midnight.

Also:

The PBODBxx.ini files specify the period as the correct separator for seconds and microseconds

PBDateTimeFmt='\'yyyy-mm-dd hh:mm:ss.ffffff\''

And:

In PB 9.0 SaveAsXML uses the correct format (ie uses a period) for datetime columns

And:

SaveAsAscii works if the dw has a column format of "dd/mm/yyyy hh:mm:ss.fff" (Workaround)

Per PB Engineering, this is not a bug.

This is the intended result, the last argument of Time() is really a PB integer type in prototype, but the value is microsecond.

Tested with PB 7.0.3_10251 and 8.0.3_9838.

As a workaround you can create a ClassNotFoundException proxy manually, but this should be generated automatically for you.

This works in previous versions of PB up through PB 9 build 2525 and appears to have been in use by customers since at least PB 3 but it is not documented and it is unclear if this is even supported.

Jaguar/Repository, receiving the following error:

User '' does not have any of the required roles 'Admin Role'

NO_PERMISSION: Jaguar/Repository (user)

SsytemException: NO_PERMISSION (Jaguar/Repository:home/create)

Problem happens when the pb component is not using instance pooling and

when no userid is used when connecting to jaguar server. CreateInstance

works ok when the pb component is set up for instance pooling even when no userid is

used to connect to Jaguar.

The call to instantiate the Jaguar/Repository is from the constructor event.

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

Click the DB Profile toolbar button and Edit the new profile you created. You'll see that there are corrupted characters (boxes, etc.) showing in the Driver-Specific Parameters field, even though nothing was entered there.

From this point on, attempts to make changes to anything, close the dialog, etc. usually will cause a crash.

Workaround: Either deselect UserID and Password, or enter valid values for them

PER DEVELOPMENT:

This is acting the way PowerBuilder and Pocket PowerBuilder are supposed to act.

The "clicked" event of w_sle:cb_2 has the script:

integer r = MessageBox("Title", "Text", Exclamation!, YesNo!, 2)

This statement is evaluated at _compile_ time, not run time. Hence, the message box comes up during the compile. Refer to the PowerScript book for specifying an initial value

to a declaration.

Fixed in PB 8.0.3 build 9918 and in PB 9.0 build 6053

DECLARE myproc DYNAMIC PROCEDURE FOR sqlsa;

sql = 'execute SP_20310306_RPC(?,?)'

PREPARE sqlsa FROM :sql USING itr;

EXECUTE DYNAMIC myproc USING :arg_empid,:arg_empfname;

Workaround: use RPC calls or DW with Stored procedures

Solution:

Development added a new BindSPInput dbparm for the feature

Example: SQLCA.DBParm = "BindSPInput='YES'"

Default value: 'NO'.

Easily remedied by toggling DefaultSize, but this should not be happening.

The BigInteger.srx is of type java.math.BigInteger. Used ejb2pb90 to generate proxy. Problem also happens from EJB Client Wizard.

The following is a snippet from the BigInteger.srx:

$PBExportHeader$BigInteger.srx

$PBExportComments$Java Proxy for class: java.math.BigInteger

global type BigInteger from Number

end type

type variables

protected:

string BigInteger_javaname= "java.math.BigInteger"

BigInteger i__BigInteger__BigInteger

end variables

workaround:

Edit the source of the datawindow and change the order manualy if you like to import a different order.

Workarounds: Either scroll with the "thumb" of the scrollbar or launch the application directly from the EXE without using the Applist.

selecting a different function in the function view without saving.

If you select another function using the function dropdown list of the scriptlist,

then there is no crash.

Workaround:

Call <DW>.GroupCalc() after <DW>.Filter() to get the Datawindow to redraw properly.

Fixed in PowerBuilder 9.0 build 6050 and PowerBuilder 8.0.3 Build 9918.

Not a bug. Changes made to the filter buffer do not apply as changes to be updated.

Fixed in PowerBuilder 9.0 build 6050 and PowerBuilder 8.0.3 build 9918.

(under 'Other Components') :

- PDF Distiller (which would deploy Ghostscript distiller and Postscript drivers)

- PDF: XLS-FO (which would deploy Apache FOP and related files)

(under PowerBuilder Base Components):

- Rich Text Support (if not selected, then PBRTC90.DLL is not deployed)

- Web DataWindow support (if not selected, then PBDWR90.DLL and PBDWRE90.PBD are not deployed).

- Java support (if not selected, then PBJVM90.DLL is not deployed).

Currently, the Runtime Packager creates an MSI file that always includes the following files:

libjcc.dll

libjsybheap.dll

pbdwe90.dll

pbdwr90.dll

pbdwr90.pbd

pbjag90.dll

pbjvm90.dll

pbrtc90.dll

pbtra90.dll

pbvm90.dll

All these files are not necessary to all applications.

Fixed in PB 9.0 build 6044 and PB 8.0.3 build 9918.

Help/Contents, it will show Translation Toolkit for PowerBuilder Version 8.

Under Help/About, it does show the correct version.

smaller reports that worked with the predecessor version.

Very likely the "fix" for this will be that Pocket PowerBuilder will use a different trace file name.

tab, it still shows 8.0.00.xxxx.

export an object from PocketPB and import into PowerBuilder.

Fixed in PB 9.0 build 6044.

composite report containing a nested report and you scroll up and down several times, the data disappears.

Problem happens in the datawindow painter in preview mode or in a datawindow control.

Scrolling appears to work ok when you just call up the nested report without composite report. Works ok with composite report when there is no computed field in the header band.

with carriage returns/newline characters, the dw shows different formatting when

the column has focus on it.

A table was loaded in with 2 fields,

CREATE TABLE "DBA"."text_text"

(

"id" integer NOT NULL DEFAULT autoincrement,

"text_lines" long varchar NULL,

PRIMARY KEY ("id")

)

The text_lines column is loaded with data that has carriage returns and new line

characters. When you preview the dw, it shows a different format when you actually

click in the text_lines column.

Information was given to the customer.

He wants a) to not have a "box" around the text/selection part of ddlb control, which you can get close to by turning off the border. b) have a setable text property that could be shown when the list is dropped down.

To see an example of what he wants, check out the Contacts application and File Explorer on the PPC:

In the Contacts app: There is a dropdown in the upper left of the window which denotes which contacts to display. The default is All Contacts, and that displays in a bar at the top. If you click the arrow to show the list, the text changes from whatever the default was to "Show", and you are to pick what to "show" from the list.

In File Explorer, the same idea applies on the upper left - the dropdown shows what folder is current, and when you drop down, the text changes to "Show". On the right side at the top, the dropdown text is "Name" by default, and when you drop down the list, the text changes to "Sort by" and the list shows the options for sorting the files in File Explorer.

I think much of this could be coded by using user events, etc., but users would like this to be built in to either enhancements to the existing ddlb, or a new type of control for the window. Coming from the PC world, it looks to me like sort of a dropdown menu - but of course menus are on the bottom on the PocketPC.

You could also get very close to this look by using a dw control with button face background, transparent column(s) that are ddlb edit style, but there would be challenges in showing the current selection in the list, etc.

Fixed in 9.0.1.

#1: HKLM\Software\Microsoft\Windows\Current Version\App Paths\PB90U.EXE => this is invalid, this file does not exist.

#2: HKLM\Software\Sybase\PocketBuilder\1.0u\vendors => this is not a good name, the vendors should probably be included under HKLM\Software\Sybase\Pocket PowerBuilder\1.0u

#3: HKLM\Software\Sybase\Pocket PowerBuilder\1.0u => this is OK, but the uninstall fails to remove it

#4: If there is a PB 9 installed on the same machine, then the following registry entry:

HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{99990001-9999-1000-8000-080009AC61A9}

InProcServer32= C:\Program Files\Sybase\Shared\PowerBuilder\pbvm90.dll

gets overwritten with:

InProcServer32= D:\Program Files\Sybase\Pocket PowerBuilder 1.0\pkvm10u.dll

(NOTE: #4 was only reproduced internally on one machine, for most cases we could not reproduce it.)

Fixed in PB 9.0 build 5031.

Workaround: simply add a call to SetPointer to set the pointer back to what you want.

Fixed in sources for PB8.x and PB9.x. Will be visible next time Help is rebuilt for a point release.

Same app works fine on Windows.

Fixed. Rebuilt Help is in the install for PB 9.0.1 Build 6520+.

The problems occur in both the "main" Structure painter and the Structure View of a window object.

FIXED: Composite datawindows will not be supported and have been removed from the IDE. Graph datawindows will be supported.

ASA 8.0.1 ODBC driver

On DBCS Window platform, DBCS data can't be inserted into and retrieved from easdemo9.db correctly by DSN "EAS Demo DB V9" which is created by PB installer.

Per PB Engineering:

It is not a bug, but an configuration issue.

In ASA, character set translation converts strings between character sets that represent the same characters, but at different values. In ASA 7, character set translation was turned off by default. In ASA 8, it is turned on by default. As a result, DBCS data cannot be inserted into or retrieved from the EAS Demo database when the ASA database engine is started with the default switches defined in the EAS Demo DB V9 DSN.

To turn off character set translation in ASA 8, add a minus sign after the -ct switch. In the Connection Profile dialog box, open the ODBC Administrator, select EAS Demo DB V9 from the System DSN page, and click Configure. On the Database page of the ODBC Administrator, add the -ct- switch to the command in the Start Line box. For example:

"C:\Program Files\Sybase\SQL Anywhere 8\win32\dbeng8.exe" -d -c8m -ct-

Versions and Build #s Reported: EAS 4.2 & 8.03

Versions and Build #s Tested: EAS 4.2 & 8.03 , OK in 4.1.3 and 8.03

Comments: Remote debugging a PB component is only possible if the breakpoint is triggered from another PB component (or PB client app). If triggered from a non-PB source (eg a java client, jsp page etc) then the breakpoint is ignored.

If the breakpoint is first triggered from a PB source then it is possible to step through the code from the non-PB source.

This worked OK in EAS 4.1.3.

According to Process Explorer, PK10U.EXE is loading the Program Files\Sybase\Shared\Web Targets\WtGenericServ80.dll file.

The ListDLLs utility does not report that dll as loaded, even when run together with Process Explorer.

Fixed in PB 9.0.1 build 6511, and PB 9.0 build 6086+.

may not take effect for generated HTML in a browser,

causing overlap of text problems.

RESOLUTION:

These options have been removed.

Versions and Build #s Tested: 8.0 GA -> 8.03.9872 & 8.03.9890

9.0 GA

Comments:

Blank rows appear in a DW with RetrieveAsNeeded and HSplitScroll set on if the dw control is resized and the DW is re-retrieved. It does not matter whether the Resize is done in code or with a resizeable dw control.

Workaround: SetRedraw(False) before Retrieve and SetRedraw(True)after call to Retrieve()

following error will result:

PowerBuilder Application Execution Error (R0039)

Application terminated.

Error: Error accessing external object property emp_fname at line 3 in clicked

event of object cb_1 of w_testnested.

Used the following syntax:

is_name = dw_1.object.child_object.object.emp_fname[2]

PB Engineering says they can't do this in an automated way. Here is their explanation and suggested workarounds:

We do not have an automated way to perform this request in PB using Get Latest Version. If someone moved several objects from one PBL to another, two possibilities exist:

1) If the 2 PBLs are in different subdirectories, then the objects that have been removed from source control will appear unregistered in the old PBL and can be manually deleted. We do not automatically delete the unregistered objects because we don't have any metadata in the PBG file to distinguish between unregistered objects and objects that have been explicitly deleted from source control.

2) If the 2 PBLs are in the same directory, then all of the objects moved from one PBL to the other will appear to be registered in BOTH PBLs (as far as the IDE is concerned). However, the object name will only appear as an entry in one .PBG file. Orcascript will know the difference when reconstructing PBLs from scratch. Deleting the old objects from existing PBLs is indeed difficult. This is one of the reasons why we recommend, as a best practice, that each PBL in a source controlled target live in its own unique subdirectory under the local project path.

If this type of thing happens frequently at this customer site, they should seriously consider using Orcascript to reconstruct the entire target from scratch every night using Orcascript Scc Refresh Target. [Note: OrcaScript allows you to write batch scripts to process PowerBuilder applications and files without using the PowerBuilder development environment. It is a new feature of PowerBuilder 9.0. It is not available in 8.0] This only needs to happen once on a build machine each night. All object deletions and moves from one PBL to another would automatically take place because each PBL is being rebuilt from scratch, based on the latest .PBG file specifications. Each developer could then XCOPY the newly rebuilt PBLs to their local workstation each morning.

Of course, if they adopt this approach, developers must also make a habit of copying checked-out objects (and new objects) to a WORK PBL before downloading the refreshed target PBLs from the build machine each morning. For a large, volitile project, this is a vastly superior way to perform nightly refresh for an entire team of developers! Instead of a dozen developers doing target-wide GLVs and full rebuilds every morning, do it once on a build machine and copy down the finished product!

TeamSybase has some PBDJ articles that discuss using a work PBL in detail. They should be on our SDN site somewhere.

In the simplest case of two windows with only commandbuttons, I could not reproduce this. There is another CR 311189 logged for the problem occurring when using a tab control. However this application does not use a tab control, but still shows the problem.

Fixed in PB 9.0 build 6050 and PB 8.0.3 build 9918.

Fixed in PB 8.0.3 and 9.0.

IDE, PPC, emu inconsistency: For item with a long text (that are wrapped), the IDE shows a truncated label when the LabelWrap property is on, otherwise the whole text is shown. On the PPC device, a truncated text is always shown (will not un-wrap). On the emulator, if LabelWrap is off the whole line is shown, otherwise the text is broken into multiple lines (not truncated like the others).

PPC, emu: CheckBox property has no effect except when run from the IDE. Will this be supported, or should it be removed from IDE ?

PPC, emu: TrackSelection property has no effect except when run from IDE. (probably not supported, but should be removed if that's the case).

Fixed in PB 9.0.1 build 6516.

grid style datawindows with computed expressions.

Fixed in PB 8.0.3 build 9943 and PB 9.0 build 6066.

Versions and Build #s Tested: 8.03.9890 / 9.0 GA

Database/Driver File/Version: PBOLEDB with SQLServer 2000 (only)

In dw painter, if a SQL syntax error occurs the dw painter gives the warning

"SELECT change has forced update specification change."

followed by the syntax error but the user is not given the chance to correct the error and all columns in the dw are lost.

The correct behaviour (ie with other dbms) is to display the syntax error first and offer the developer the opportunity to change the error or discard changes.

eg "SQLState = 42S02...invalid object name 'pbcatcolsss'

Do you want to correct errors? Yes No

This only happens when using Microsoft SQLServer 2000 with the PBOLEDB driver and either SQLOLEDB or MSDASQL (via ODBC). Same scenario using SQLServer 7.0 or MSS & SQLServer 2000 works OK.

This is very similar to CRs 213498 and 239877 (for Oracle)

When app is run from a java client, receiving the following error:

About to call method with short array passed by value:....OK

About to call method with short array passed by reference....OK

About to call method with structure array passed by value....FAILED

org.omg.CORBA.TRANSACTION_ROLLEDBACK: minor code: 0 completed: No

at java.lang.Class.newInstance0(Native Method)

at java.lang.Class.newInstance(Class.java:237)

at com.sybase.CORBA.iiop.Connection.createSystemException(Connection.jav

a:5238)

at com.sybase.CORBA.iiop.Connection.invoke(Connection.java:3602)

at ams._st_n_genapp.valstructarrayarg(_st_n_genapp.java:212)

at ClientTest.main(ClientTest.java:46)

RESOLUTION: The test case works ok on solaris in PBVM build 9704 and on NT builds

except build 9704. Closing cr.

Update from PB Engineering:

See CR 319543 regarding 2 new environment variables "PBOnFatalError" and "PBRollbackOnRTError".

Not a bug. SQL Server does not support bind variables. In the native (MSS) driver PB ignores a disablebind=0 and always disables binding. ODBC of course allows the disablebind=0, and you get the resulting database server error.

pb crashes with the following error:

The instruction at 0x1150b88c refrenced memory at 0x000000008. The memory

could not be "read".

The crash handler shows the following results:

Exception code: C0000005 ACCESS_VIOLATION

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

File Version: 8.0.3.9907

Fault address=1150B260 Section:Offset=01:0000A260

Registers:

EAX:00000000

EBX:0677D400

ECX:00000000

EDX:002E9CB0

ESI:07296C58

EDI:00000000

CS:EIP:001B:1150B260

SS:ESP:0023:0012CEFC EBP:06769360

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

Flags:00010206

Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

1150B260 0012D120 06769360 0012D140 02220002 06727398 dwCrosstabDefDynamic+100

12021D6E 0012D1C4 07296C58 067AAE98 06727398 0222006C pdwPreviewStyle+25FE

12021A60 0012D1E4 07296C58 00010011 00000111 00000001 pdwPreviewStyle+22F0

1200817E 0012D390 00000C9D 00000001 00000000 00000111 PBWS_CreateDataWindowLayoutView+16FE

12013EA5 0012D3A8 064872F0 00000111 00000C9D 00000001 DWControlListViewCompareFunction+485

12006F4C 0012D3CC 064872F0 00000111 00000C9D 00000001 PBWS_CreateDataWindowLayoutView+4CC

120E0B1F 0012D3F4 000B0528 00000111 00000C9D 00000001 0001:000DFB1F C:\pb80\Shared\PowerBuilder\PBDWP80.dll

77E11B60 C0000000 00000000 00000000 00000000 00000000 CreateWindowStationW+291

OS version:

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

Memory Status:

Total physical memory: 261552K

Available physical memory: 41204K

Total virtual memory usage: 276748K / 1060420K

PowerBuilder virtual memory usage: 199764K / 2097024K

Migration/Import from PB will need to alter window type appropriately.

PER DEVELOPMENT:

The defaults are for 2-D.

The references to 3-D will remain for the customer.

PSE NOTES:

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

OS: Win32

Versions and Build #s Reported: PB 8.03

Versions and Build #s Tested: PB 8.0 GA -> 8.03.9890

PB 9.0 GA

Using Find function in a dw.

When the first string argument includes a call to Double () then the PB app accesses ALL dynamic libraries in the library list. With identical expressions which access functions such as Long (), Integer(), Number () the PB app does not access any libraries in the liblist.

With applications containing long library lists or if dynamic libraries kept on a server there is a performance hit.

For example, the following shows the problem,

dw.Find ( "n1=Double(20)", 1, dw_find.RowCount())

Whereas these examples do not...

dw.Find ( "n1=Number('20')", 1, dw_find.RowCount())

dw.Find ( "n1=20", 1, dw_find.RowCount())

SetTransObject returns -1 on both PC and device.

Retrieve returns -1 on PC, 0 on device.

InsertRow returns -1 on PC, 0 on device

SetItem fails but does not crash PC, but on device the app disappears at this point.

If there were no newspaper columns the report would have 58 pages. Once put into the newspaper columns format there should be 29 pages. According to CR 188109 the numbers under this situation should be 1 of 29, 1 of 29, 2 of 29, 2 of 29, 3 of 29, 3 of 29, .........29 of 29. When viewed online the numbering seem correct except that you can only scroll to page 15 of 29. When the report is printed you get page 1 of 29, 1 of 29 and then a second page of 1 of 29, 1 of 29. You do get the entire 29 pages printed but the last pages are numbered 15 of 29 and not 29 of 29.

WORKAROUND: In datawindow painter, Design...Datasource... Convert to Syntax solves this problem as a workaround.

Solution: It is not a PB problem. EAServer on HP/UX issue which is solved in EAServer 4.2

Top level menu items on the menubar will not have associated events. Only submenu items will fire events on the PocketPC. (Possible exception of the "New" menu which is not actually on the menubar on the PocketPC, but this would not be until after release 1, if it is even possible to implement.) So for example, code in the clicked event of a top level menu item will not execute when that menu item is clicked. (Will the events be unavailable in the Menu Painter ? Undecided at this time.)

The application is copying the rows of a datawindow to the structure

lstr_array.depid = dw_dept.object.dept_id.primary

str_array

Array depid

Char colname

Which appear to be making it 1 structure with array of depid. That is being compared

to just a structure.

The crash handler shows the following:

Exception code: C0000005 ACCESS_VIOLATION

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

File Version: 8.0.3.9907

Fault address=10CDCDCF Section:Offset=01:001DBDCF

Registers:

EAX:00000000

EBX:0012E790

ECX:063FEF88

EDX:00000001

ESI:00000005

EDI:00000001

CS:EIP:001B:10CDCDCF

SS:ESP:0023:0012E72C EBP:064911C8

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

Flags:00010297

Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

10CDCDCF 0012E72C 063EEF78 063FEF88 00000000 0012E790 ot_is_array_eq+1F

10CDDBF6 0012E764 063EEF78 00000002 00000002 0012E790 ot_is_struct_eq+A6

10D8F997 0012E780 063EEF78 0648CB8C 00000000 0012E7A8 0001:0028E997 C:\pb80\Shared\PowerBuilder\PBVM80.dll

10CECDE4 0000090C 00000000 00000000 00000000 00000000 rt_set_pcode_to_line+6B4

OS version:

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

Memory Status:

Total physical memory: 261552K

Available physical memory: 33056K

Total virtual memory usage: 292392K / 1060420K

PowerBuilder virtual memory usage: 178016K / 2097024K

no workaround (PB 8.0.3)

Works fine in PB9

Versions and Build #s Reported: 8.03

Versions and Build #s Tested: 7.0 GA -> 7.03

8.0 GA -> 8.03

9.0 GA

Treeview control does not process the CTRL+TAB combination of keys. If an application uses a treeview on an MDI sheet window then it is impossible to navigate between sheets using the CTRL+TAB combination of keys if there is only a Treeview on the window. All other window controls tested process these keys correctly and change the active sheet window.

If there is another control on the window the CTRL+TAB is interpreted as a TAB and focus is changed to the other control where a second CTRL + TAB is then processed correctly (assuming the 2nd control is not another treeview).

dumping a transaction log, is causing PowerBuilder to hang.

The same stored procedure works ok when executing it from a ASE 11.9.2 database

server from Powerbuilder.

Works ok when executing SP outside of PB from isql. PowerBuilder will also hang

when executing SP from database painter.

This is not such a big deal on the device since it is not likely to be commonly done, but may be more of a problem on the emulator where users might be more apt to use the arrow keys.

They're running 50 clients with small reports and are facing 2 Assertion Failures errors during 7 minutes of test.

Test environment is the same as with BIG reports (PB 9879 Patch + PBDWE80.DLL Build9885 with 3 GB memory option)

error:

Error: Action Failed = -1

ora-01401 : inserted value too large for column No changes made to database. UPDATE

"CUSTOMER" SET "FNAME" = :1 WHERE "ID" = :2 and "FNAME" = :3 AND "LNAME" = :4

AND "ADDRESS" = :5 AND "CITY" = :6 AND "STATE" = :7 AND "ZIP" = :8 AND "PHONE" = :9

AND "COMPANY_NAME" = :10

In the Jaguar.log file,

HTMLDW: GetLastErrorString() = 'ORA-01401: inserted value too large for column

No changes made to database.

Update works ok in datawindow painter.

after having retrived .. the value of computed field was disappeared ..

The computed field is composed with another computed field.

These conditions are ..

salary : the column ( datatype : numeric )

compute_1 : Last ( salary for group 1 )

compute_2 : sum ( compute_1 for all distinct compute_1 )

The value of compute_2 is disappeared only once ,the value showed at first creation.

After retrieving or reopening or executing .. the value is disappeared .

According to our documentation (See also CR 305383) this is not supported currently.

Verified fixed in PowerBuilder 90 Build 6053.

properties of the target may fail if there are too many pbl's selected

at the same time in the Select Library window.

The limit lies around 8500 characters of the sum of the filenames.

Work-around:

Add the pbl's in two or more steps.

Example: c:\pbls\dot.test\test1.pbw

PBC file should be c:\pbls\dot.test\test1.pbc

Instead, the PBC file gets created as c:\pbls\dot.pbc

USAGE NOTE:

The old bug doesn't really hurt anything. PBC file gets written to wrong filename but it also reads this same incorrect filename next time you connect, so the user should never notice a problem. When this fix is applied, the next time you connect to this workspace you'll get an error message in the output view saying "Unable to restore status cache from nnn.PBC". Ignore it. At shutdown, a new PBC file will get created under the correct filename, and there won't be any more problems.

powerbuilder and you hit a keystroke, that keystroke is not being captured in 9.0.1.

The ole control is of type sound recorder (sndrec32).

In PB8 / PB9 exception handling it is only supported for P-Code (PBD) executables

(see CR 299793 and CR 267895)

European control panel settings, i.e. decimal separator comma and grouping symbol a dot.

When entering a value 45 and tabbing out, the value may change to

a value like 450 or 4500 depending on the mask.

on solaris, causing the following error:

Apr 10 12:52:46 2003: SIGSEGV 11* segmentation violation

Apr 10 12:52:46 2003: si_signo [11]: SIGSEGV 11* segmentation violation

Apr 10 12:52:46 2003: si_errno [0]: Error 0

Apr 10 12:52:46 2003: si_code [1]: SEGV_MAPERR [addr: 0x3B959320]

Apr 10 12:52:46 2003: stackpointer=cb20f404

Apr 10 12:52:46 2003:

Full thread dump Classic VM (JDK-1.2.2_010, native threads):

"Thread-27" (TID:0xd2661eb0, sys_thread_t:0x137a7e0, state:R, native ID:0x41) prio=5

"Thread-26" (TID:0xd265ac38, sys_thread_t:0x1377ce8, state:R, native ID:0x40) prio=5

"Thread-25" (TID:0xd263e5c8, sys_thread_t:0x1353778, state:R, native ID:0x36) prio=5

"Thread-24" (TID:0xd257b800, sys_thread_t:0x1f4eaa8, state:R, native ID:0x3f) prio=5

"Thread-23" (TID:0xd257cae0, sys_thread_t:0x1f4d758, state:R, native ID:0x3e) prio=5

"Thread-22" (TID:0xd2587738, sys_thread_t:0x1f46960, state:R, native ID:0x35) prio=5

"Thread-21" (TID:0xd2587f48, sys_thread_t:0x1b423c8, state:R, native ID:0x34) prio=5

"Thread-20" (TID:0xd2588120, sys_thread_t:0x19f9770, state:R, native ID:0x3b) prio=5

"Thread-19" (TID:0xd2589a50, sys_thread_t:0x1b40888, state:R, native ID:0x3d) prio=5

"Thread-18" (TID:0xd258b078, sys_thread_t:0x1b3dfe8, state:R, native ID:0x3a) prio=5

"Thread-17" (TID:0xd258b928, sys_thread_t:0x1b3d9c8, state:R, native

Apr 10 12:52:46 2003: Java VM aborting...

Verified fixed in PB 90_6066

Or we should implement a way that hides the different usage of the PBCatalog for DB2 from the users. Maybe it is possible to implement code that avoid to edit the DB2SYSPB.SQL script to change all instances of PBOwner to another name.

our documentation:

If you use the DB2SYSPB.SQL script to create the extended attribute system tables in a DB2 database and replace all instances of PBOwner in the script with the name of a nondefault table owner, owner_name must be the same as the owner specified in the DB2SYSPB.SQL script. .....

When you connect to a DB2 database, you can use the DB2SYSPB.SQL script to create the extended attribute system tables. If you use the DB2SYSPB.SQL script, keep the following in mind:

穀ou can edit the script to change all instances of PBOwner to another name, or leave the table owner as PBOwner in the script (the default).

Specifying SYSIBM is prohibited You cannot specify SYSIBM as the table owner. This is prohibited by DB2.

穀ou can set the PBCatalogOwner parameter to the owner you specified in this script or to PBOwner if you did not edit the script.

Versions and Build #s Reported: PB 8.03

Versions and Build #s Tested: 8.0 GA -> 8.03.9913

9.0 GA

Comments: In the following circumstances the dw RowHeight () function recalculates incorrectly

1) Detail band has autosizeheight set ON

2) RowHeight function is called in an expression to change the size of a visual dw object property in the group detail band.

3) DW must be printed - problem shows only after printing dw (on screen & on paper) .

Tried calling RowHeight in a computed field in the detail band and referencing the computed field in the dw object property expression (ie no not directly ref the function) - Still gives the problem

If the call to RowHeight is removed from the expression for dw object property then it calculates fine.

Changing dw units to pixels/inches/cms does not make a difference

Maybe related to CR 276802

Verified fixed in PB 803 build 9970. Verified fixed in PB 901_7011.

to update a column it appears to be in read-only mode. You have to use the backspace

key and then insert data into the column.

After data is retrieved and you select a column. The first time you select, the

entire column is highlighted. The second time you click into the column, the cursor

is placed in your column. If you try to add data at this point, you cannot.

You have to use the backspace key and then add the data.

Works ok using the o84 driver.

pb is not deleting the row.

Setchanges returns a 1. The update returns successful. Once you hit retrieve again,

the row is still there.

From Engineering: Not a bug. The OS's/platforms listed simply have to do with the version of the Microsoft PostScript Printer Driver. We're redistributing pscript.dll version 0.2, originally bundled with NT4 and W2K. This was superseded by pscript5.dll version 0.3, bundled with W2KSP3 and XP. However, no features or bug fixes were added relevant to our use. Recommend continuing to redistribute pscript.dll, as this is certified on the older OS's (while pscript5.dll is not) and back-compat by XP. Also the latest Adobe Acrobat Distiller (for PDF) PPD-based Pscript minidriver we're redistributing (version 5.0 ca. 2000) was certified with pscript.dll.

Problem does not occur if the 'launching' window is of type Main!

11 Feb 2004

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

Fixed in PowerBuilder90 Build 6066.

Workaround: set Language seetings to Deutsch (Deutschland) / German (Germany)

Verified fixed in PB804_10501. Verified fixed in PB901_7006.

ora-01008 Not All variables Bound

Works ok if disablebind=1.

Problem happens using the o84 and o90 drivers and using Oracle 8.1.7 and Oracle 9.0.1

clients in PB 8.0.3 (build 9907).

1 -In the "Database Profile Setup - Sybase Adaptive Server Enterprise dialog box" section of the online help, there is a DBParm listed under Sytax called "ModifySyntax". There is no such parameter.

2 -There is a "TrimSpaces" parameter listed under Sytax on the dialog that is not included on this page (though the help topic does exist in the help file).

3- The KeepAlive parameter listed under the Network tab is also not documented as a valid parameter in this section of the online help. There is an online help topic on a 'keep connection open' parameter, but it's actually called 'keep connection alive' in the database profile dialog.

4 - In the Directory Services portion of the ASE Connection Dialog, Not able to modify the value for "Directory Alias Entries". Noticed that toggling the values of certain parameters on this tab of the dialog did not always result in the correct settings in the preview tab of the same dialog. In particular, toggling the Enable Failover entry usually resulted in the value of DS_Copy (Use Caching) being toggled in the preview instead.

when connecting with an empty ConnectString in the DBParm parameter,

i.e. DBParm="ConnectString=''"

Work-around is to put a space within the quotes.

the boolean argument in the function is always returning False even though the return

value returns 0 for success.

OLEStorage ole_store

OLEStream ole_stream

ole_store = create OLEStorage

ole_stream = create OLEStram

li_status = ole_store.open("c:\mysavedbmp.jpg")

li_status = ole_store.memberexists("|Ole10Native", lb_olenative)

The lb_olenative is always returning false. Opened the jpg using DocFile Viewer and

the substorage name is |Ole10Native. (There is also a tool called stg.exe that

works just like Docfile Viewer.)

RESOLUTION: Customer resolved issue by using the following

ole_Store.MemberExists(char(1) + 'Ole10Native',lb_olenative)

Also to open the stream they also used the enumerators in the open:

ole_stream.open(ole_store, char(1) + 'Ole10Native', StgReadWrite!,StgExclusive!)

twice in 2 weeks. They are using the web datawindow which is instantiated

on a jsp.

The customer has a core dump that they hope will help shed some light on the problem.

Resolved with build 10286.

Workaround: Add "FileDSN=filename" to the Driver Specific Parameters portion of the dialog and leave the DSN field blank.

A crash can occur in drag\drop operations when deleting a row of a datawindow

that is still in drag mode and a MessageBox is put up in the dragdrop event.

The crash occurs when moving the mouse back to the datawindow where the row was deleted.

A work-around could be to call Drag(end!) before deleting the row.

may generate incorrect syntax in some cases for multitable select statements.

In the syntax the table name may be missing for column names and dbnames and

column header text and names.

Verified fixed in PB803 build 9961 and PB9 build 6511.

Reviewed fixed in pb90_6066.

Issue with edit masks.

Following are the various scenarios :

1) If there is an edit mask control of string with mask of (###) ###-#### and the text is highlighted on focus, nothing can be typed into it.

2) For numeric edit mask controls, with edit mask of currency, the control inserts decimals and can not insert dollar values when the field is highlighted.

3) For datawindows:

1. numeric field with mask of (###) ###-#### will allow input, but does not pass validation

2. strings with mask of (###) ###-####, input can not be added when field is highlighted.

3. numeric field with mask of currency has same problem has numeric edit control, highlighted field enters in decimal area and dollar values can not be entered.

Verified fixed on PB804_10501 and PB901_6533++++.

PBD files do not have comments. They have compiled code only. The example submitted was a re-named PBL and so it had comments.

verified fixed in PB 90_6075 and PB 803_9943.

lnv_array[]= {lnv_test1} // Results in an invalid array element for lnv_array[1]

Versions and Build #s Tested: 8.03.9704 and earlier OK

9809 and later - Crash

9.0 GA and later - Crash

Comments:

Regression, broke in 8.03.9809.

Calling a global function in a datawindow validation rule. The code in this function opens a response window which will crash PB on closing the window. A non response window does not crash and neither does MessageBox.

Calling a response window from the DW ItemChanged or ItemError event also works fine

Example crash in 8.03 build 9918 (but it varies)

*****

The exception Breakpoint

A breakpoint has been reached

(0x80000003) occurred in the application at location 0x002a1609

****

<<---------------- NOT a Bug -------------------------------------------------------->>

From PB7 to PB9

1. The position Func in Key event of RTE returned the same position from pb5

2. The position Func. in post user event call which called in Key event of RTE

returned different from pb5

( confirmed append ret.Paste()in user event after position func.)

This is reported in PB8 help doc. (refer below)

"When you post a function or event, it is added to the object's queue and

executed in its turn. In most cases, it is executed when the current script

is finished, but if other system events have occurred in the meantime, its

position in the queue may be after other scripts. Its return value is not

available to the calling script.

All events posted by PowerBuilder are processed by a separate queue from

the Windows system queue. PowerBuilder posted messages are processed before

Windows posted messages, so PowerBuilder events that are posted in an event

that posts a Windows message are processed before the Windows message.

For example, when a character is typed into an EditMask control, the

PowerBuilder pdm_keydown event posts the Windows message WM_CHAR to enter

the character. If you want to copy the characters as they are entered from

the EditMask control to another control, do not place the code in an event

posted in the pdm_keydown event. The processing must take place in an event

that occurs after the WM_CHAR message is processed, such as in an event

mapped to pdm_keyup. "

error message appears:

Access to SCC Provider Failed during SccCheckin(). Try Again.

Works ok from XP to remote drive that is not novell.

PER DEVELOPMENT:

The CloseQuery event is triggered by the windows WM_QUERYENDSESSION message.

This message is not supported in WinCE. Processing that would normally be done in a CloseQuery event script must be moved to one of the other event scripts.

e.g. Use the Close event or the "SuperMinimize" (Resize event).

Example of observed behavior for both PB/IM and MS Word :

Input String

i work in building six ,in "concord"

i come here five days a week

In Microsoft word if you do Format --> Change Case --> Title Case then the string will be like this :

I Work In Building Six ,In "Concord"

I Come Here Five Days A Week

But using PB/IM 7/8/9 Wordcap will give this :

I Work In Building Six ,in "concord"

i Come Here Five Days A Week

Verified fixed on PB901_6532.

in the Datawindow painter. For example, if you have 4 groups in a datawindow,

and you want the ability to insert a new group between groups 2 and 3. The

new group becomes 3 and automatically changes the existing groups to 3,4,5 (3 becomes

4, 4 becomes 5).

The agregate fields, etc in the moved groups should also be moved.

For example when group 4 becomes 5 (in the above example) all the aggregate fields,etc

should also move.

Solution:

This issue was resolved by having the customer make some coding changes to their application.

According to PB Engineering this is caused by different OCI behavior of o73 and o84. It is not a PB bug.

According to documentation, this property is supported for ODBC, Informix,and Oracle.

In PB 9.0 (build 5507) using ODBC and ASA, sqlreturndata is returning a value of 'Adaptive Server Anywhere'. In the latest builds of 8.0.3 and 9.0, it is not returning a value.

In PB 8.0.3 and 9.0 using Informix, sqlreturndata is returning 0 when inserting a row

into a table. Sqlreturndata is not returning a value by just connecting to the database.

In PB 8.0.3 and 9.0 using Oracle, sqlreturnata is not returning a value.

Workaround: Create a different dw style and do Rows > Create Group instead.

Update:

Documentation about pasing xsd files has been updated. See PB 9.0.1.

Verified fixed in PowerBuilder 8.0.3 Build 9961.

User Error: Line mode reads UNICODE files only. The DSN file is an ANSI file.

For example, pages 636,639,640 and 641 show the classid for pbrx90.ocx as:

CLASSID="CLSID:88881304-8888-1000-8000-080009AC61A9"

The classsid has changed for pbrx90.ocx and it should be:

CLASSID="CLSID:99991304-9999-1000-8000-080009AC61A9">

The classid for the pbrxs90.ocx is:

CLASSID="CLSID:99991314-9999-1000-8000-080009AC61A9">

Verified fixed in PB 803_9961, PB 90_6086

Verified fixed in PB9 build 7048

column field in the datawindow painter and once you tab off the format property,

the error message of:

Specified edit mask is invalid

Update:

Checked with PP1.5 - Fixed in PPB 1.5

The current implementation of printing pdf files does not lend itself to easy distribution to a large user community. If someone has to distribute their PB9 app to their 500 users(say) and wants the functionality to save the datawindow as pdf then they need to install Ghost script in each of those 500 machines. This issue needs to be addressed in future releases which will

1. not require a freeware driver (write our own?)

2. provide a packaging option when building an exe?

On your internet site:

http://manuals.sybase.com:80/onlinebooks/group-eag/ear0413e/eassolrb/@Generic__BookView) we read :

6.1 Unexpected deadlock errors If you see unexpected deadlock or slow database throughput when executing transactional components, check for the following setting in

the properties of the component that initiates the transaction:

com.sybase.jaguar.component.iso_level=serializable

This setting causes the transaction to run with serializable isolation

level ...

Per PB Engineering:

1. When we deploy a PB component in Jaguar, PB never creates the "Transaction Isolation Level property" for the component. So for any component, pb does not write "com.sybase.jaguar.component.iso_level=serializable".

2. When a Database is connected from PB application or component, if we don't set the transaction isolation level explicitly, the default isolation will be depend on how your database is configured.

3. Isolation level of a transaction object is handled trough the "Lock" property (e.g. Sqlca.Lock = value). You can refer to the PB Help for the value of the lock for different DBMS.

SELECT DIVISION_CODE, '"' FROM DIVISION".

The datawindow will preview acceptably with no problems. But if you try to edit the SQL PB GPFs.

Workaround:

Edit source shows the following: SELECT DIVISION_CODE, '~"' FROM DIVISION".

If I change the source to read: SELECT DIVISION_CODE, '~"~"' FROM DIVISION" PB no longer crashes.

function, the focus is not being set for the Web Datawindow row and column. The following function is being called from the onload event.

<script language=JavaScript>function setrow_and_column()

{

dw_1.SetRow(3)

dw_1.Setcolumn('dept_name')

The onload event appears to work ok because if you add dw_1.SetItem(1,2,'new dept name') to the function, it changes the first row, second column's dept name to the new value.

The javascript generated for the setrow function is:

function HTDW_SetRow(row)

{

var result = -1;

row -= 1;

var colNum = this.currCol;

if (colNum != -1)

{

var colObj = this.cols[colNum];

if (typeof colObj != "undefined" && colObj.displayGobName != null)

{

var control = this.findControl(colObj.displayGobName, row, true);

// if we can't find a control, then we can't set the row

if (control != null)

{

// force focus onto the found control,

// the onFocus event will change the currency variables

control.focus();

result = 1;

}

}

}

return result;

}

The javascript generated for the setcolumn is:

function HTDW_SetColumn(col)

{

var result = -1;

var colNum = this.getColNum(col);

if (colNum != -1)

{

var colObj = this.cols[colNum];

if (typeof colObj != "undefined" && colObj.displayGobName != null)

{

var control = this.findControl(colObj.displayGobName, this.currRow, true);

// if we can't find a control, then we can't set the column

if (control != null)

{

// force focus onto the found control

// the onFocus event will change the currency variables

control.focus();

result = 1;

}

}

}

return result;

}

Verified fixed in PowerBuilder 804 Build 10501. Verified fixed in PowerBuilder 901 Build 7011.

PB Engineering:

In PB 8 and 9, the default behavior has been changed so that for stateful components, the default behavior is the same as in PB 7, i.e. the transaction is rolled back. This issue was fixed on February 27, 2004, and is included in all PB 8.0.4 and PB 9.0.1 EBFs created after that date (which can be determined by looking at the datestamp on the PB EBF DLLs). This change does not apply to stateless components. A new CR 347702 has been raised to restore the default behavior for stateless components to the behavior in PowerBuilder 7.

Also introduced 2 new environment variables "PBOnFatalError" and "PBRollbackOnRTError".

PBOnFatalError environment variable:

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

Controls whether or not to restart server on PBVM corruption. Three case-insensitive values are available: "continue", "restart" and "shutdown". Default value is "continue", which will rollback the current transaction, but let the server continue running.

PBRollbackOnRTError environment variable:

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

If a runtime exception is raised by a PowerBuilder component running in EAServer, in PowerBuilder 7 the transaction is rolled back and the exception is thrown back to the client. In PowerBuilder 8, the behavior was changed so that the transaction is committed before the exception is thrown back. You can control this behavior by using the new PBRollbackOnRTError environment variable. To specify that the transaction is committed before the exception is thrown back to the client, set the PBRollbackOnRTError environment variable to 'n', 'no', or 'false'. When this environment variable is set to 'y', 'yes', or 'true', the transaction is rolled back before the exception is thrown back to the client.

These environment variables were introduced on August 13, 2003, and are included in all PB 8.0.4 and PB 9.0.1 EBFs created after that date.

PER DEVELOPMENT: the problem is this: A transparent gif allows the container window color to show through. Overlapping transparent gifs will not always work as expected because now the transparent pixels are using the container window color, not the colors in another object under the gif. Transparency happens when the picture is instantiated, based on its container color, it does not happen dynamically. Moving a gif programatically may also give unexpected results. The IDE produces a similar efect, but the container color used there is always button face (just as in PB9). We cannot get it any better than it is now in this release.

Verified fixed in PB 901_7011.

Workaround to the problem:

This is how the workaround works and the necesary files to use it.

The following is the code I added to the of_imprime_formulario function of the nvo_nf

It does following:

1. Delete a file temp.pdf if exists

2. Get the printername the user choosed

3. runs a command called print.bat (this batch copies the temp.pdf file to the printer.)

The print.bat file should be placed in the running directory (where the exe is) it will save there the pdf

The only problem I found was when using printers that have spaces in the name for example "My printer" in this case the workarround won't work I suggest to rename the printer to "MyPrinter" for example.

string ls_printer, ls_command

FileDelete("temp.pdf") // To be sure the file does not exist

pds_nota_fiscal.SaveAs ("temp.pdf",PDF!,true)

ls_printer = left(PrintGetPrinter(), pos (PrintGetPrinter(), "~t") -1)

ls_command = "print.bat "+ ls_printer

run (ls_command, Minimized! )

The print.bat file is as follows:

:Loop

SET ARG=%1

IF "%ARG%" == "" GOTO Print

set Printer=%Printer% %ARG%

SHIFT

GOTO Loop

:Print

copy temp.pdf %Printer%

According to MSDN.

To overcome .NET and COM differences, the runtime provides wrapper classes to make both managed and unmanaged clients think they are calling objects within their respective environment. Whenever your managed client calls a method on a COM object, the runtime creates a runtime callable wrapper <cpconruntimecallablewrapper.asp> (RCW). RCWs abstract the differences between managed and unmanaged reference mechanisms, among other things. The runtime also creates a COM callable wrapper <cpconcomcallablewrapper.asp> (CCW) to reverse the process, enabling a COM client to seamlessly call a method on a .NET object. As the following illustration shows, the perspective of the calling code determines which wrapper class the runtime creates.

In most cases, the standard RCW or CCW generated by the runtime provides adequate marshaling for calls that cross the boundary between COM and the .NET Framework. Using custom attributes, you can optionally adjust the way the runtime represents managed and unmanaged code.

_______________________________________________________________________________________________

This seems to indicate that there needs to be nothing new done from the client side. However I still get the "-3 Object could not be created" error.

Resolution:

This is an XP Operating System problem. The same problem happens in VB on XP.

work for datastores. The printout is always directed to the default printer.

This is a regression in PowerBuilder 8.0.3 Build 9601 and later.

To work-around the issue use the PrintSetPrinter function or

add the following section into the pb.ini file:

[Datastore Behavior]

usehwnd=yes

Verified fixed in PB901_7026

stays in memory until you exit Powerbuilder. The reason is the com object is hosted in the same process that Powerbuilder is.

A side effect to this behavior is if you call a com object and then go back and make a change and then try to regenerate the com object (from the project painter), you will see

errors such as:

CGEN: Compiling 'c:\case\powerbuilder9x\_tmpguid.cpp'

CGEN: Compiling 'c:\case\powerbuilder9x\_tmpclas.cpp'

CGEN: Compiling 'c:\case\powerbuilder9x\_tmpserv.cpp'

CGEN: Linking... cannot open pb9bug.dll : unknown error I/O error processing pb9bug.dll : Permission denied

You will need to exit and restart PowerBuilder to remove the object from memory.

oleobject lole_comapp

lole_comapp = create oleobject

lole_comapp.connecttonewobject("PB9.0.n_pbcom")

lole_comapp.of_com()

disconnect lole_comapp

Update:

For applications, the Handle function does not return a useful value when the previous flag is true. You can use the FindWindow Windows function to determine whether a Windows application is already running. FindWindow returns the handle of a window with a given title.

Update:

Fixed in latest builds.

We have not been able to recreate the problem internally, so this may not be solvable.

Verified fixed in PB 804_10501. Verified fixed in PB 901_7011.

remote database using dblink, receiving a ora-03113 end-of-file communication error.

Problem happens using:

Oracle 9.2.0.1.0 Client -> Oracle 8i db -> o84

Oracle 9.2.0.1.0 Client -> Oracle 8i db -> o90

(Works ok using Oracle 9.0.1 client)

Works ok using:

Oracle 9.2.0.1.0 Client -> Oracle 9i db -> o84

Oracle 9.2.0.1.0 Client -> Oracle 9i db -> o90

Works ok when retrieving from a datawindow. Problem happens when using embedded sql.

RESOLUTION: Works ok using PB 8.0.4 (build 10538) and PB 9.0.1 (build 7048) and Oracle client 9.2.0.3. Upgraded Oracle client per tech doc http://www.sybase.com/detail?id=1011566.

Fixed in PB 901_6516.

Versions and Build #s Reported: EAS 4.0 GA with PB 7.03.10108

Versions and Build #s Tested: As above (not reproduced outside production env)

Database/Driver File/Version: ASE 12.0.0.4/P/SWR 9842

Comments:

2 Jag servers in a cluster on multiprocessor W2K machines running PB 7.03.10108 components

Both servers crashing randomly each day with no messages in the log. As this is only happening in the production env the ct is unwilling to test an upgrade without guarantees the upgrade will fix the problem. This consult is to ask if engineering can analyse the user.dmp files from these crashes to gives us evidence that this crash is due to a known CR which is fixed in later versions of EAS/PB.

*** Wednesday, June 04, 2003 2:36:21 PM

The problem has not repeated itself since bind.thread=true was set for the PB components.

create PROCEDURE DBA."dbp_test_parameter" ( in @argstring varchar(6) )

BEGIN

print @argstring;

END;

subroutine dbp_test_parameter(string argstring) RPCFUNC ALIAS FOR "~"dba~".~"dbp_test_parameter~""

Use in a customized transaction object : code

sqlca.dbp_test_parameter("123456");

-> The ASA log will show only 123.

UPDATE:

Fixed in builds after in 6/17/03 build.

Workaround: assign one column for the data and a different column for the display in the dddw style column. Then it works fine.

04/25/2005:

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

Verified fixed in PB 804 build 10501++ and PB 901 build 6533++.

2. Right-Click on "Users" under the connected database. Click on "New User...".

3. Under the "User properties" page, enter a new user name and password, as well as confirm the new password".

4. Right-click on "Save Changes" in the "User properties" page.

5. Right-click on "Users" under the connected database. Click on "Refresh...". Nothing shows up under "Users".

6. Repeat steps 2-5 but this time work on "Groups" under the connected database.

If we open up PowerBuilder after creating the users and groups and connect to the same database, we can see the new users and groups created successfully.

workaround: do an refresh on the object to show the right status.

Versions and Build #s Reported: EAS 4.2 & 8.03.9704

Versions and Build #s Tested: 8.03 Builds 9704 -> 9838 EAS version

Some background info:

Tried to repro on a single CPU machine, on a dual CPU machine and when binding the Jag process to just 1 CPU on a machine with 4 CPUs and not able to see the problem. Only able to reproduce the problem when using 4 CPUs or more.

All PB components are deployed as standard, non-transactional, threadsafe components. Instance pooling and automatic demarcation supported.

Bind thread is not selected (this is PB 8.03 on EAS 4.2 and no datastores are used)

(Tested with concurrency & pooling on and off, with of without transaction support or dbms access)

On the client side (PB) the app uses shared components to simulate concurrent users on separate threads.

On the Jaguar server, there is a component that accepts the request and

launches another component for executing the business logic.

So launching 5 concurrent clients gives 5 + 5 components active/concurrent on the Jaguar server.

The components seem to respond sequentially which didn't happen in PB 8.0.1. Giving the impression that one component waits for the other to finish, or places a lock somewhere...

Behaviour Difference observed with 8.03 and 4 CPU machine.

Counting the number of method invocation in a given amount of time (10 secs) with 2 simultaneous components and with 20

With Powerbuilder 8.0.3 Build 9704 or 9838

2 components / 10 seconds 927 method invocations

20 components / 10 seconds 975 method invocations

With Powerbuilder 8.0.1 Build 8004

2 components / 10 seconds 825 method invocations

20 components / 10 seconds 2450 method invocations

With PB 8.03 20 simultaneous connections process almost the same number of method invocations as 2 simultaneous connections ( 927 vs 975)in the same time (10 secs)

With PB 8.01 20 simultaneous connection process 3 times as many method invocations as 2 simultaneous connections

On a single or dual processor machine (or on the same machine with the jag process bound to 1 CPU) the results are similar as those for 8.01

Versions and Build #s Tested: 8.03/9.0

Comments:

The horizontal and vertical scrollbars in the DW control cannot be disabled when there is less than 1 page of data, they are hidden when not required. This NFR raised to display the scrollbars Greyed Out when there is not more than one page of data. Or add a property so the developer/user can decide to have scrollbar disabled or allow it to be hidden (current behaviour).

Verified fixed in PB 901_7011. Verified fixed in PB 703_10305.

IMPORTANT INFORMATION: This issue does not happen when both logins and passwords are equal in primary and secondary ASEs.

Resolution: This is not a PB defect. It's just a behavior changE between ASEs 11.x and 12.x. From 12.x on, there's new transactional model for RPCs. So, it was possible to reproduce the same issue by using isql and SQLAdv. Solution is to map and use CIS + external logins in ASE.

3/2004 Update from PB Engineering.

This is not a bug. This problem can be solved by shrinking the bottom space room of detailband to a height less than zero. The previous fix will be reverted.

one pbl to another pbl if you use RIGHT click and drag and drop in the systemtree.

The active application can not be moved. To move it, select a second application

and use the Move popupmenu item without drag and drop to move the object.

all the pbd check boxes can be click with one option.

For example, add an "Check All" check box.

iterations. You cannot log in to Jaguar Manager.

The client application is set up where the timer event creates a shared object instance and then calls a function from that shared object where a connection to EAServer is made and then a getfullstate is done on the server side. The datastore is retrieving aprox. 4000 rows.

I was able to capture the following from win2000:

Full thread dump Classic VM (JDK-1.2.2_010, native threads):

"Thread-28" (TID:0x25ed10e0, sys_thread_t:0x42441810, state:R, native ID:0xc44) prio=5

"Thread-20" (TID:0x25ddb420, sys_thread_t:0x423c2a88, state:R, native ID:0xb38) prio=5

"Thread-13" (TID:0x25ece420, sys_thread_t:0x422eb950, state:R, native ID:0x910) prio=5

"Thread-2" (TID:0x25e6f9e0, sys_thread_t:0x42197ab8, state:R, native ID:0xc24) prio=5

"Thread-1" (TID:0x25e71370, sys_thread_t:0x403edd80, state:R, native ID:0xc70) prio=5

"SymcJIT-LazyCompilation-0" (TID:0x25e0f380, sys_thread_t:0x4019f850, state:CW, native ID:0x950) prio=1

at SymantecJITCompilationThread.DoCompileMethod(Native Method)

at SymantecJITCompilationThread.run(JITcompilationthread.java, Compiled Code)

"SymcJIT-LazyCompilation-PA" (TID:0x25e0f3a8, sys_thread_t:0x4019f6e0, state:CW, native ID:0x900) prio=10

at java.lang.Object.wait(Native Method)

at java.lang.Object.wait(Object.java:424)

at SymantecJITCompilationThread.run(JITcompilationthread.java,

(c613800):

Error 999 (rc -1) : [Microsoft][SQLServer 2000 Driver for JDBC]The DBMS returned an unspecified error.

User opens worksheets through a Treeview control, depending of what he/she wants to do. To activate a worksheet, the user doubleclick on an item. The ENTER key simulates the DoubleClick. Also, a sheet can be closed by pushing the ESCAPE key.

The problem:

User Doubleclicks on an item. It opens a new sheet but the first control does not have focus. User presses ESC to close the sheet, but instead, it closes the sheet with the Treeview control.

Other graph types (eg. bar, column, area) will have no problem displaying the series label on the same graph datawindow.

Problem worked ok in PB 7.0.3 (build 10180) and started happenning in (build 10197).

This reported issue is probably due to cr277649. Other issues that were similar were

cr302489 and cr289495 (issue #2).

Define a property or format to display #### when a value is too big to fit in

the text box of a datawindow field or column.

An alternative might be:

- Define maximum or minimum values and change font or background characteristics

when the value exceeds it.

For example an expression like the following can be defined for the

strikeout property:

if(dept_head_id > 999, 1, 0)

HKCU\Software\Sybase\PocketBuilder

It has "1.0u\Wizards" keys underneath it.

The other keys I have are correctly under:

HKCU\Software\Sybase\Pocket PowerBuilder\1.0u

NOTE: Check out code exchange. Third parties are already working on building application frameworks appropriate for the Pocket PC.

PER DEVELOPMENT: A framework such as PFC is not planned for Pocket PowerBuilder, but as noted above, one or more are posted on Sybase's Code Exchange website.

WORKAROUND: Appears to be caused by using the array subscriptor max value. If you initially set the array one higher than what you need, the reference will work.

In this example, change the w_main open event from:

////////////old//////////////

iu_pb_box[5,5] = Create u_pb_box

This.OpenUserObject(iu_pb_box[5,5],10,64)

This.OpenUserObject( iu_pb,10,364)

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

to:

//////////new////////////////

iu_pb_box[6,6] = Create u_pb_box

This.OpenUserObject(iu_pb_box[5,5],10,64)

This.OpenUserObject( iu_pb,10,364)

This happens both with datawindows and editmask controls.

UPDATE:

No Plan To Fix any AppList bugs

WORKAROUND: This appears to be some sort of timing problem as to when the window paints and when the Open event completes. I found two workarounds, and users may find other methods. First, I added a Messagebox call to the Open event of the window to double check the return string from the ProfileString function call. That caused the behavior to be fixed, i.e. the EXE opened Maximized, as the user desired. Second, I found that I could take out the Messagebox call, and add "this.hide()" to the beginning of the Open event script, and "this.show()" to the end of the Open event script, and this also worked around the problem. Another possibility that I did not test might be using a 'splash' screen that timed out and closed on its own, etc.

11 Feb. 2004:

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

NOTE: You can export an entire target by using the "Export CE to Desktop" tool on the "Tools" tab of the PK IDE.

and "Carriage Return" 0x0D from database by White space 0x20

Errormessage: SQLSTATE = 42000

PER DEVELOPMENT: Current behavior is correct. PB8/9 only allow opening web-target style objects.

PER DEVELOPMENT:

This is not a bug. The tab control defaults to the full size of the window. If you resize the second tab _control_ (not the page), you will see that the page appears as it would in PowerBuilder.

11 Feb 2004:

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

Fixed in PB 901_6511.

When a password is set to expire in x number of days,

the popup window is not displaying when a runtime application is using the

dbparm of pwdialog=1.

When connecting from the development environment, the popup window does appear.

Versions and Build #s Tested: 8.03.8870 OK 9.0 GA -> 9.0.6075 Problem

When source control provider is on a remote server or on any server where access is delayed a little, when you connect to source control the system tree collapses.

This is not dependent on the source control provider as it has been reproduced with VSS & PVCS. A fast connection (eg connect to source control server on the same machine) does not give the problem.

Opening the library painter also helps to 'slow down' the connection to source control as the views in the library painter need to be redrawn - sometimes opening the library painter helps reproduce the problem

causes an access violation. The following is the crash handler results:

Exception code: C0000005 ACCESS_VIOLATION

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

File Version: 9.0.0.6075

Fault address=10BA2044 Section:Offset=01:000A1044

Registers:

EAX:00000000

EBX:0000000C

ECX:7E0A0D20

EDX:4E4F4653

ESI:0000000A

EDI:001D9370

CS:EIP:001B:10BA2044

SS:ESP:0023:0012E61C EBP:02668CD8

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

Flags:00010206

Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

10BA2044 0012E630 7E0A0D20 4E4F4653 10BA0A0D 02668CD8 print_job::Printer_Escape+84

10BA278C 0012E654 0222000C 02668CD8 FFFFFFFF 00000002 global_print_job::Printer_Escape+1C

10C359C5 0012E684 00000000 00000002 027A0068 025D4150 fnPrintSend+95

10C65CDC 0012E6D8 00000000 00000000 026700E5 017C69BA OB_RUNTIME_CLASS::invoke+38C

10C65940 0012E724 025D4150 00000000 026700E5 00000002 OB_RUNTIME_CLASS::invoke+1F0

10CCF18B 0012E74C 025D4150 00120000 0258525E 026740B9 ot_process_class_call+AB

10DA9CD4 0012E77C 025D4150 026715CE 00120000 0012E7A4 sf_class_call+44

10CE3963 00000002 00000000 00000000 00000000 00000000 rt_exec_pcode+403

UPDATE:

Fixed on PDA. If still happens on emulater, than it is a emulator bug.

11 Feb 2004:

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

This issue is not reproducable in later builds of 8.0.3, or 9.0.

11 Feb 2004:

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

refferring to CR 306009. In PB9 (PVCS 6.8.1) the liblist is updated and libraries are there but objects in libraries are absent after "get latest version" on target level.

New objects created by developer 1, are not delivered to developer 2, by using GetLatestVersion. PB9 get an updated liblist and the new PBL's. But these PBL's are still empty.

Versions and Build #s Tested: All versions

Database/Driver File/Version: Powerscript Reference - SetTransPool

Help docs for SetTransPool () state:

"The maximum value specified for a transaction pool limits the total number of database connections made by the application. When the transaction pool is full, each attempt to connect will fail after the timeout interval has been exceeded."

In the example it states

"When the maximum number of connections has been reached, each subsequent connection request will wait for up to 10 seconds for a connection in the pool to become available. After 10 seconds, the server will return an error to the client."

This is slightly inaccurate as SetTransPool does not return an error. Nothing is returned to SQLCode to indicate an error has occurred. The first we know about an error is if SQL is sent to the db using this (unconnected) connection.

The help could mention that DBHandle will confirm if a connect to a TransPool connection is valid or not

This leads to questions about how the application developer can test on the Pocket PC for remaining memory / resources, etc. Can this be handled by the Pocket PB runtime ?

"Specifies whether the user can scroll vertically when not all of the items in a control are visible"

When this is run what appears is a horizontal scroll bar and not a vertical scroll bar and it doesn't actually scroll but seems to paginate the items in the list vertically by using a horizontal scrollbar.

If this is the way it should work then the documentation needs to be corrected.

as toolbar icon for a menu item.

When a network drive has been mapped and had been added to the path environment variable,

then PowerBuilder could be searching for these icons on the network drive.

With the following icons the problem may be experienced:

[ AppIcon!, Application5!, AppRectangle!, Asterisk!, CreateLibrary5!, Database!, DataPipeline!,

DataWindow5!, Debug5!, DisplayCurrentLibrary!, DosEdit5!, Error!, Exclamation!, Form!, Function!,

Hand!, Information!, JaguarProfile!, Library5!, Librarylist5!, LibraryOpen!, Menu5!, OleGenReg!,

Project!, Query5!, Question!, Report5!, RunReport5!, StopSign!, Structure5!, UserObject5!, Warning!,

WebPBWizard!, Window!, WinLogo! ]

Fixed in PB 901_6520+ and PB 803_9977.

In the DataWindow painter, you can place a Computed Field. The Computed Field must contain an expression. We will occasionally use this approach to include additional database data (i.e. text from a blob as the value of the computed field. For example, suppose the computed field is named comp_field1 and contains the global function: fn_get_text(id_value). When the fn_get_text executes, the value is retrieved from the database and placed in comp_field1.

When sort/filter/resize the DataWindow , the function will re-execute (again-and-again). We would like to suppress additional executions of the expression once the value has been resolved, we should not need to re-execute the expression/function once the value has been determined. This only slows down performance and irritates our uses.

Verified fixed in PB901 build 7011.

datawindow control, will result in scrolling row by row.

When you run the same test case in PB 7.0.3, it will scroll one page at a time each

time you hit the down arrow.

Verified in PB901_6531

Per PB Engineering, this is a Third Party Problem:

The customer succeeded in connecting to DB(DB2-400) in PB9 with CA400 V5R2M0(SI08894).

(This is caused from SI07675 which caused the crash by returning a invalid value).

in PB 8.x and PB 9.x , in typing DW's column , press Tab , Locale-toggle-key(right-alt-key) was toggled automatically without user's intention.

in PB7.x it works well.

the resultend display may not be as expected.

For example:

The following format is used: "-#,##0.00;#,##0.00; "

When entering 1.05, then displayed is -0,001.05 instead of the expected -1.05

To work-around it, a computed column could be used, displayed on top of the column.

The expression would be minus the column value with format "#,##0.00;-#,##0.00; "

A call to GetElementsByTagName will immediately place you where you want to be and

save a significant amount of DOM processing dy drilling down directly to the content.

From TeamSybase:

Consider the following XML document fragment:

<LoginResponse defaultCommunityId="10" defaultLocale="en-us"

hostUrl="http://localhost:9992/Rhythmyx/">

<SessionId>bf1146ac7ccf74733b3ecd57a8572fddff554bcb</SessionId>

<Communities>

<Community id="10">Product Information (PI)</Community>

</Communities>

<Roles>

<Role>Admin</Role>

<Role>PI Member</Role>

</Roles>

</LoginResponse>

If I want to extract the list of roles from this document, I currently have

to:

Get the root element

Call GetContent() on the root element

Loop through the content array of PBDOM_Object, calling GetName() on

each object until I get to the <Roles> element

Call GetContent() on the <Roles> element

Loop through the content array of PBDOM_Object, calling GetName() on

each <Role> element to obtain the value

Now consider a call to GetElementsByTagName( "Role" ) which will

immediately place me at step #4 above. It can save me significant amount of

DOM processing by drilling down directly to the content I'm interested in.

expensive processing can be saved.

From TeamSybase:

If I wanted to send the following fragment of the XML above, e.g.:

<Roles>

<Role>Admin</Role>

<Role>PI Member</Role>

</Roles>

Currently, I would need to do one of two things:

Write the new XML to file then call use ReadFile to store the XML in a

string variable, i.e.:

a. Construct a new PBDOM_Document

b. Detach the <Roles> element from it's original document

c. Attach <Roles> to the new document

d. Call document.SaveDocument()

e. Open the resulting file

f. Read the file contents into a string variable

Assemble the string programmatically, e.g.:

String ls_xml

Long length, i

length = UpperBound( rolelist )

ls_xml = "<Roles>"

FOR i = 1 TO length

ls_xml += "<Role>"

ls_xml += rolelist[i].GetText()

ls_xml += "</Role>"

NEXT

ls_xml += "</Roles>"

EAServer environment, where PowerBuilder component co-exists with Unicode Java.

From TeamSybase:

Translating XML that was originally authored in say, CP1250 into another code page requires conversion to Unicode first, or else data is lossed. Maybe an overloaded versions of GetText(), GetTextTrim() and GetTextNormalize() that return a Unicode blob

would work in the interim, at least until PB9.x or 10 is Unicode-enabled.

1 to row 5 (last row) in PB 8.0.3 and 9.0. This is a change in behavior from

PB 7.0.3 where if you hit the down arrow, pb will scroll down only 1 row.

The test case has the dw_1.scrollnextrow in the scrollvertical event. If you take

this out in PB 8.0.3/9.0, than the behavior works ok. When you press the down arrow,

pb will scroll down only 1 row.

It appears that in PB 7.0.3 when you hit the down arrow, the following events are

triggered in the order of:

1. ScrollVertical

2. Rowfocuschanging

3. Rowfocuschanged

4. Itemfocuschanged

In PB 8.0.3/9.0, the following events are triggered:

1. Rowfocuschanging

2. Rowfocuschanged

3. Itemfocuschanged

4. Scrollvertical

Since the scrollvertical event has the scrollnextrow() coded in the event, it causes the rowfocuschanging event to fire which causes the rowfocuschanged to fire..... This

chain of events continues until it hits the last row (row 5).

RESOLUTION: Not a bug. Behavior as expected.

"Cannot convert string in Any variable to extobject at line..."

Verified fixed in PB 703 build 10312+.

Verified fixed in 8.0.3 build 9977.

Verified fixed in 9.0.1 build 6531.

Verified fixed in PB 703_10312+ , PB 803_9977 and PB 901_6532.

Verified fixed in 9.0.1 build 6531. Verified in PB 703_10312+

Development & runtime (deployed to device) environment:

1. Calling dw.saveas for a text format will return a resultset that's not correct. It will contain strings like:

"ID;PPB

B;Y75;X6

C;Y1;X1;K"emp_id"

C;X2;K"emp_fname"

..."

The resultset from calling dw.saveas for a text format with header is OK!

2. Calling dw.saveas for a SQL format in the development environment will trigger a datawindow error message:"Line 31 Column 2: incorrect syntax". The SQL file is still created but it contains garbage data. A similar error message is triggered if we do a "Save Rows As..." in the database painter. On the device, saving as a SQL format will not return an error message but no SQL file is created.

3. Calling dw.saveas for a Excel format in the development environment is OK. But with the created Excel file opened, calling dw.saveas a 2nd time will cause PPB to crash.

Calling dw.saveas for a Excel format on the device will create an excel file which cannot be opened by PocketExcel. PocketExcel will trigger the error message "Unable to open. The file format is invalid."

There is no problem saving as a Excel5 format instead.

settext to add text to a field on a datawindow with an editmask set, it is displayed differently in version 9 compared to version 7 and 8. Final dot is added at the end after item changed

The null part of this issue is to be addressed by enhancement CR 171033.

The date portion of this issue is deemed by engineering to be too risky to fix.

is called from a JSP page randomly opens a html page in background.

The JSP page has two examples, one where a html button opens the html page with:

<input type="button" value="HTML Button" STYLE="width:1.500in; height:0.238in" onClick='childWin=open("popup.html","ChildWin","scrollbars,height=600,width=700");'>

When this button is clicked, the popup.html will always open on top of the jsp page.

When clicking on the DW user defined button:

function dwTransfer_ButtonClicked(row, objName)

{

if(objName=="b_but")

{

var strURL;

childWin=open("popup.html","ChildWin","scrollbars,height=600,width=700");

}

The popup.html will sometimes open on top of the jsp page and sometimes it opens in behind the jsp page.

The code that is generated for the html button is:

<TD><INPUT TYPE="button" NAME="b_but_0" VALUE="DW Button" onClick="{dwTransfer.buttonPress('',0,'b_but'); dwTransfer.restoreFocus();}"></TD>

this.SelectRow(0,false)

this.SelectRow(currentrow,true)

When the user scrolls using the device scroll dial, the code works okay until user scrolls to the row *after* the initially visible set of rows. Then the SelectRow(0,false) appears to fail - rows continue to highlight and remain highlighted as the user scrolls through the dw.

Verified fixed against PB8-10561. Verified fixed against PB9-7061.

Fixed in PB 901_6531.

control or standard visual user object of type datawindow, a new datawindow object window

will open even if its already opened.

PB should be able to check if the datawindow is already opened before opening

another datawindow.

This behavior is in PB 7.0.3,8.0.3 and 9.0.

Wizard Error:

Error generating <path to the library>

Reason is: Error opening the gen template or the source library.

on a Datawindow, it is not limiting the characters on a Web Datawindow.

In the dw painter, the limit property works ok with a sle and mle. On a Web Datawindow,

the limit property will work with the sle only.

In javascript, the maxlength is not supported with textarea fields. The DW mle field

maps to a textarea. The sle field maps to a text field which does support the maxlength

property. The maxlength maps to the DW limit property.

The following is HTML generated:

<TD>Single Line Edit column</TD>

<TD><INPUT TYPE="text" NAME="test1_0" SIZE=69 MAXLENGTH=60 VALUE="" onFocus="{htmldw.itemGainFocus(0,1,this,htmldw.gobs.test1); htmldw.selectControlContent(this);}" onClick="{var ret; ret= htmldw.itemClicked(0,1,'test1'); return ret;}" onChange="{this.bChanged = true;}" onkeypress="DW_EditKeyPressed(-1)" onBlur="{htmldw.itemLoseFocus (this);}"></TD>

<TD>Mutiline Edit column</TD>

<TD ROWSPAN=2> <TEXTAREA NAME="test2_0" ROWS=3 WRAP onFocus="{htmldw.itemGainFocus(0,2,this,htmldw.gobs.test2); htmldw.selectControlContent(this);}" onClick="{var ret; ret= htmldw.itemClicked(0,2,'test2'); return ret;}" onChange="{this.bChanged = true;}" onkeypress="DW_EditKeyPressed(-1)" onBlur="{htmldw.itemLoseFocus (this);}"></TEXTAREA></TD>

Normally if we pass a NULL filename into the ImportFile function, we will have a file dialog box which displays for the user to select the file to be imported. In this case I use it to select the text file on the device and emulators but Importfile function still returns -8.

On both instances, the importfile fails and nothing is imported on the datawindow for the device and emulators.

redrawn when increasing it's size.

The picture gets cut-off and the remaining part only shows

the background color of the OCX.

To work-around it, make the the control very large at design time

and set the required size at opening time.

When you have an argument specified for a nested report in the base datawindow,

then this expression is not copied into the Modify Expression dialog like PowerBuilder 6 did.

Example Date() function:

30/06/2003. -> 01/01/1900

02/07/2003 -> 07/02/2003

Example IsDate() function:

Isdate("30/06/2003") -> not a valid date

UPDATE: on 2003/08/12 15:50:28

fixed -> CR324718 - date/time format using old technique

results is the wrong value. For example, if you enter in the value of 999 and then

point the cursor at the beginning and then enter in 123, what happens is after entering

the 1, the value becomes 1,999.00. The cursor now jumps to after the first 9. When you type in the next value of 2, the edit mask value becomes edit mask of 19,299.00. After entering the 3, the value is now 19,239.00

In PB 8.0.3, the same value entered will result in:

12,399.00

Changeing SELECT with Modify for instance where ls_sql is

SELECT Decode( col , 'xxx', 1) FROM xxx WHERE xxx= :xxx AND xxx = 'xxx'

or

SELECT CASE WHEN xxx = 'xxx' THEN 1 END FROM xxx WHERE xxx= :xxx AND xxx = 'xxx'

and then doing a

ls_ret=dw.Modify("DataWindow.Table.Select='" + ls_sql + "'")

Workaround:

use the SyntaxFromSQL and Create DataWindow methods : that way, he can pass some "non-ansi" functions like DECODE or some statements like CASE...WHEN.

under same environments, in windows PBVM(i.g 803.9890) , it dispayed well.

When requesting a "Refresh Status" the status of the object errornously changes to checked out.

order-by clause disappeared after converting graphics mode and return syntax mode,

also order-by clause disappeared.

If order-by columns added in select-list , no problem.

LibraryCreate

LibraryImport (datawindow)

use datawindow

LibraryDelete -> fails

replace and the replace function has a argument of '~~~"', its causing PB to crash.

The following is the syntax of the export dw:

retrieve="SELECT DISTINCT

REPLACE( ST_NM, '~~~"', '@' ) display,

ST_NM code

FROM

CUST_LNDLRD

WHERE

ST_NM <> ' '

" sort="display A " )

The following is the output from the crash handler:

Exception code: C0000005 ACCESS_VIOLATION

File Name: E:\pb80\Shared\PowerBuilder\PBSQL80.dll

File Version: 8.0.3.9977

Fault address=12505C8F Section:Offset=01:00004C8F

Registers:

EAX:00000000

EBX:021F4750

ECX:FFFFFFFF

EDX:021F4750

ESI:021D3618

EDI:00000000

CS:EIP:001B:12505C8F

SS:ESP:0023:0012E9F8 EBP:00000000

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

Flags:00010286

RESOLUTION: Could not reproduce problem in PB 9.0.2 (Build 7672) and PB 10.2 (build 8049)

Workaround in code: call dw.print(true) instead of dw.print() to display the cancel dialog. No workaround for the dw painter problem.

with children, the following is the results:

- <shoppingcart>

- <item

book

<title>A Walk in the Woods</title>

<author>BillBryson</author>

</item>

It should look like this:

- <shoppingcart>

- <item>book</item>

<title>A Walk in the Woods</title>

<author>BillBryson</author>

The template is setup as:

- shoppingcart

- item

item

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

- title

title

- author

author

when closing the application in build 10290.

The following is the crash handler log that customer sent:

Exception code: C0000005 ACCESS_VIOLATION

File Name: C:\Program Files\Sybase\Shared\PowerBuilder\PBVM70.dll

File Version: 7.0.3.10290

Fault address=11385171 Section:Offset=01:00164171

Registers:

EAX:00000000

EBX:01423C00

ECX:022A02D0

EDX:01423C00

ESI:03871F60

EDI:00000000

CS:EIP:001B:11385171

SS:ESP:0023:0012FAC0 EBP:03871F60

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

Flags:00010246

Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

11385171 0012FC80 00050252 00060262 00000435 000003F8 ob_create_consolidated_library+411

77E8479C 01423C00 01423C00 01A000F8 01A00068 00000000 GetMessageTime+6B3

01423C00 1149B080 11361E10 00000000 113633F0 11363410 0000:00000000

11361E00 1149B0E8 1136AD40 00000000 1147E6C4 1147E6C4 ob_convert_chararray_to_string+470

OS version:

Windows NT 4.0, Build Number: 1381, Service Pack 6

Memory Status:

Total physical memory: 521620K

Available physical memory: 365012K

Total virtual memory usage: 138072K / 1027088K

PowerBuilder virtual memory usage: 77772K / 2097024K

will crash will the following error:

pb90.exe - Application Error

The instruction at "0x77f87ece" referenced memory at "0x10dc14b8". The memory could

not be "written".

The following is a crash handler log:

Exception code: C0000005 ACCESS_VIOLATION

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

File Version: 9.0.0.6111

Fault address=10DA13F9 Section:Offset=01:002A03F9

Registers:

EAX:00000020

EBX:013B15E0

ECX:0000000C

EDX:10E35E50

ESI:00000004

EDI:00090652

CS:EIP:001B:10DA13F9

SS:ESP:0023:0012C3D0 EBP:013B15E8

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

Flags:00010246

Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

10DA13F9 0012C3EC 013B15E0 10B53EDE 013B15E8 10C8476A PbHeap_free+2B9

10BCA081 0012C3F4 013B15E8 10C8476A 014003D0 013B15E8 shtokenReject+A4C1

10B53EDE 0012C3FC 014003D0 013B15E8 03787D40 02740108 pbstg_fee+E

10C8476A 0012C424 02740108 02740108 00000000 10C8FFBD ob_create_interface_in_library+AEA

10C84C2C 0012C434 00000000 00000000 10DBDBD5 02740108 ob_create_interface_in_library+FAC

10C8FFBD 0012C440 02740108 03787D40 10CE4123 02740108 ob_destroy_rtinst+D

10DBDBD5 0012C44C 02740108 028E02B4 02740108 0012C474 0001:002BCBD5 E:\pb90\Shared\PowerBuilder\PBVM90.dll

10CE4123 03787D40 00000000 00000000 0000000F 00000000 rt_set_pcode_to_line+793

OS version:

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

Memory Status:

Total physical memory: 261552K

Available physical memory: 32848K

Total virtual memory usage: 281212K / 1060304K

PowerBuilder virtual memory usage: 132864K / 2097024K

Per PB Engineering, this is not a bug.

1. The problem happens only for the PSR's having Paper Size in Printer Specifications of the corresponding DW is set to Default(0) value.

2. Once, the paper size is set to default value, the report's page height will become a machine dependant value and the value will be set according to the default page size of the machine's default printer setup.

3. If the default page size (default printer setup) between two machine is different, then a PSR file created in one machine will no longer be portable on the other machine. This is because of the difference of the report's page height in different machine. If the page size differs with machine, the number of rows in a page will also differs and that will cause the problem.

4. To resolve the problem, just change the report's page size to a non-default value and make sure that the new page size is supported by the printer drivers of both the machine.

5. This is not a PB bug and requires no changes in source code end.

for a normal size report:

When printing the datawindow basically prints out from left to right aligned, not as expected right to left. On the right hand side there will be some empty space left.

for a large width report:

When printing the datawindow in landscape mode basically prints out from left to right aligned, not as expected right to left.

On the overlapping pages (the ones that are extra pages because of the width) the print is also started from the left to right.

Information on skins can be found at:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmplay/mmp_sdk/whymakeskins.asp

1. Source code examples using the PBDOM methods should no include the ref keyword or the & characters. Below are two examples, but there may be others:

SetContent under PB_DOM_ELEMENT shows the following line of script

pbdom_doc.GetRootElement().SetContent(ref & pbdom_obj_array)

that should become

pbdom_doc.GetRootElement().SetContent(pbdom_obj_array)

BuildFromFile shows:

pbdom_doc.GetRootElement().GetChildElement & ("data").GetContent(ref pbdom_obj_array)

and that should be

pbdom_doc.GetRootElement().GetChildElement & ("data").GetContent(pbdom_obj_array)

basic authentication is set, the following error message appears:

Application terminated.

Error: Unexpected return code: 401 Unauthorized

From the Soaplog.log file the following appears:

CLOSED

REQUEST:

CLOSED

POST /WEBSERVICES/SOAP HTTP/1.1

Host: duquette-w2k:8080

Connection: Keep-Alive

User-Agent: EasySoap++/0.6

Content-Type: text/xml; charset="UTF-8"

SOAPAction: "calc/n_calc.add return,short,return in,short,i_1 in,short,i_2"

Content-Length: 402

<E:Envelope

xmlns:E="http://schemas.xmlsoap.org/soap/envelope/"

xmlns:A="http://schemas.xmlsoap.org/soap/encoding/"

xmlns:s="http://www.w3.org/2001/XMLSchema-instance"

xmlns:y="http://www.w3.org/2001/XMLSchema"

E:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">

<E:Body>

<add>

<i_1

s:type="y:short">22</i_1>

<i_2

s:type="y:short">66</i_2>

</add>

</E:Body>

</E:Envelope>

RESPONSE:

HTTP/1.1 401 Unauthorized

Content-Length: 47

Connection: Keep-Alive

WWW-Authenticate: Basic realm="newtest"

Content-Type: text/html

Server: Jaguar Server Version 4.2

<head><title>UNAUTHORIZED!!!!!</title></head>

Connection Disconnected

This is not a bug. The String format was being used incorrectly. In the string format you must always use the US standard. Then the regional settings are plugged in to the runtime display, so you will aways get the regional settings display.

A workaround is to use Escape characters in the column display format (The String format). For example, try with '#\.###\,00'. But the problem in this case is, the characters will be treated as ASIS characters and display will not be proper if the mask length is more than actual data. For example, if we use the above mask and specify an initial value 123456, the data will be displayed perfectly, as per their requirement. But if we change the initial value to 12345 (data length is less than mask length) there will be a problem.

To avoid this, they can set the display format in script. Before applying the format , they have to call a function, say GenerateMask(). Let's say the function will take 5 parameters - data, generated mask string by ref, number of digits after decimal position, digit group length and $ or Uro or other currency flag. They have to put code in the function, so that it will form the mask string (depending upon the currency flag) whose length will be exactly same to the data length. Then this mask can be applied.

Workaround:

eg. replace the code in the clicked event of the queryclear button

dw_2.setredraw(false) //disable flickering

dw_2.height=1388 //set to a larger size

dw_2.Object.DataWindow.QueryClear="yes"

dw_2.height=984 //set back - eg. to original value !

dw_2.setredraw(true)

It would be helpful for customers if the SybHeap dump output could be directed to a specific file, so customers do not have to dig through to get output and piece together for analysis. Customers should be able to specify a file name to send the dump to.

PB Engineering created 2 new environment variables:

PB_HEAP_LOGFILENAME

The PowerBuilder SybHeap memory manager can provide diagnostic output that helps you troubleshoot memory allocation issues in your application. The PB_HEAP_LOGFILENAME environment variable lets you set the name and location of the file to which this output is written.

If you specify a file name but not a directory, the file is saved in the same directory as the PowerBuilder executable, or, for a PowerBuilder component running on EAServer, to the EAServer bin directory.

If you specify a directory that does not exist, the file is not created, or, for a PowerBuilder component running on EAServer, output is written to the EAServer console.

PB_HEAP_LOGFILE_OVERWRITE

PB_HEAP_LOGFILE_OVERWRITE is a boolean environment variable that specifies whether diagnostic output should overwrite or append to the existing data in the file specified by PB_HEAP_LOGFILENAME. Values are:

true - overwrite existing data in the log file

false - append to existing data in the log file

Workaround: save object and close object and then reopen and add the function

and after appending sql in query then return, PB is crashed.

between query isn't interpreted well in graphics mode .

At once first adding between query in graphics mode , converting to syntax and graphics mode , it doesn't matter.

Workaround: dw column type from long to ULong and use Disablebind = 1

problem happens using EAServer 4.2.1. The component is returning ok

to the instance pool once the component timed out using EASErver 3.6.1 C5.

From the srv.log, you can see that the deactivate and canbepooled events are fired in

EAServer 3.6.1 C5.

Resolution: Determined to be an EAServer issue and that EAServer engineering determined the reason that the component is not timing out is that there is a transaction that is still active. The component 'requires' a transaction and so one is started. No action is done by the component to ever end the transaction. In addition the HTMLdw component returns the ContinueWork primative after each method call via the PB EnableCommit() method. The means that the HTMLdw is giving it's blessing to a Commit, but is not issuing one.

There are two timeout variables. Instance timeout and transaction timeout. The component has set an instance timeout, but no transaction timeout.

WORKAROUND: Set the transaction timeout to the desired time. This property can be found on the 'Resources' property tab of the component properties. The same tab as the instance timeout property. This will give the component the same behaviour as 3.6.1.

path in length is 90 or greater and you copy an object into the pbl, pb will crash.

The following is the crash handler results from PB 90:

Exception code: C0000005 ACCESS_VIOLATION

File Name: unknown

File Version: unknown

Fault address=70617369 Section:Offset=00:00000000

Registers:

EAX:00000001

EBX:02747D50

ECX:10E3B210

EDX:10E3B210

ESI:026FFE68

EDI:0012FB1C

CS:EIP:001B:70617369

SS:ESP:0023:0012F3FC EBP:0273F168

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

Flags:00010206

Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

70617369 0012F3F8 72756F73 6F636563 6F72746E 6973756C 0000:00000000

7265646C 0273F168 00000001 00000001 00000001 00000001 0000:00000000

OS version:

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

Memory Status:

Total physical memory: 261552K

Available physical memory: 95124K

Total virtual memory usage: 242280K / 1060304K

PowerBuilder virtual memory usage: 118660K / 2097024K

you are trying to do a saveas to PDF using ghostscript, the process takes much

longer than if the application was running on a local drive.

For example, it took 33 seconds to save a datawindow to a PDF from a network drive. When

the same pbl was on a local drive it only took 4 seconds to save to a local drive and 5

seconds to save on a network drive.

Workaround: Manually remove object from PBG and PBC files, making sure to remove it from the 'master' copy as well as local copy. Reopen the workspace *working offline* so that you are *not* connected to source control. At this point you should be able to delete the object from the PBL. Then close workspace and reopen, connecting normally to the source control system.

perhaps using the GetPicture function if getting the blobs using SELECTBLOB but cannot add those pictures to the dw.

A vmstat shows the following:

procs memory page disk faults cpu

r b w swap free si so pi po fr de sr dd dd f0 s0 in sy cs us sy id

0 0 0 2286904 234096 0 0 2 0 0 0 0 0 2 0 0 307 57 49 0 0 100

0 0 0 2071584 7912 0 0 0 49 69 0 10 1 3 0 0 317 297 272 3 0 97

0 0 0 2070800 7904 0 0 0 36 48 0 4 1 3 0 0 317 438 439 2 0 97

0 0 0 2068680 7888 0 0 48 99 158 0 25 5 2 0 0 354 484 313 4 1 95

0 0 0 2067736 7912 0 0 0 41 58 0 8 2 2 0 0 318 282 277 2 1 97

0 0 0 2067000 7904 0 0 0 43 66 0 9 1 3 0 0 318 296 277 2 0 97

0 0 0 2066216 7936 0 0 0 42 59 0 7 0 2 0 0 315 283 269 3 0 97

0 0 0 2065416 7912 0 0 0 36 57 0 8 1 3 0 0 315 284 271 2 1 97

0 0 0 2064600 7936 0 0 2 42 62 0 8 1 3 0 0 317 275 273 2 0 97

0 0 0 2063904 8024 0 0 18 62 88 0 14 2 2 0 0 320 309 286 3 0 97

0 0 0 2063088 8064 0 0 18 30 36 0 3 2 3 0 0 321 303 272 2 1 97

0 0 0 2062296 7928 0 0 0 48 63 0 10 1 3 0 0 318 277 270 3 0 97

0 0 0 2061504 7904 0 0 0 44 67 0 9 0 2 0 0 316 305 276 3 0 97

0 0 0 2060712 7904 0 0 0 35 55 0 7 1 2 0 0 315 274 271 2 0 97

0 0 0 2059920 7880 0 0 7 48 76 0 12 1 3 0 0 317 293 275 2 0 97

0 0 0 2059080 7936 0 0 0 48 62 0 7 0 2 0 0 315 276 270 2 0 97

0 0 0 2058296 7912 0 0 0 48 66 0 10 1 3 0 0 318 291 271 2 0 97

0 0 0 2057488 7896 0 0 0 36 53 0 8 1 3 0 0 317 289 277 3 0 97

0 0 0 2056704 7920 0 0 0 48 71 0 10 0 2 0 0 316 283 270 3 0 97

procs memory page disk faults cpu

r b w swap free si so pi po fr de sr dd dd f0 s0 in sy cs us sy id

0 0 0 2055880 7896 0 0 0 42 63 0 9 1 3 0 0 315 294 275 2 1 97

0 0 0 2055088 7920 0 0 4 44 59 0 7 1 3 0 0 368 329 289 2 0 97

0 0 0 2054304 7904 0 0 0 36 51 0 6 0 2 0 0 438 433 307 3 1 97

0 0 0 2053504 7880 0 0 3 43 66 0 11 1 3 0 0 426 409 307 2 1 97

0 0 0 2052720 7880 0 0 4 54 78 0 10 1 4 0 0 319 309 280 3 1 97

0 0 0 2051888 7920 0 0 8 41 60 0 9 1 2 0 0 316 276 274 2 0 97

0 0 0 2051112 7888 0 0 48 62 110 0 18 7 3 0 0 328 302 290 2 1 97

0 0 0 2050312 7904 0 0 0 44 64 0 9 1 3 0 0 318 327 319 3 0 97

0 0 0 2049520 7880 0 0 0 41 64 0 8 0 2 0 0 314 276 272 2 0 97

0 0 0 2048712 7888 0 0 1 43 71 0 11 1 3 0 0 317 302 281 3 1 97

0 0 0 2047920 7944 0 0 0 42 56 0 7 1 3 0 0 315 262 275 2 0 98

HTMLGenerator80 Stats (Counter on jsp page was 192)

Method Invocations: 1170.0

Instances Active: 0.0

Instances Pooled: 1.0

Transactions Completed: 975.0

Transactions Rolled Back: 0.0

Last Maximum Method Invocations: 0.0

Last Maximum Instances Active: 0.0

Last Maximum Instances Pooled: 0.0

Last Maximum Transactions Completed: 0.0

Last Maximum Transactions Rolled Back: 0.0

Peak Maximum Method Invocations: 1170.0

Peak Maximum Instances Active: 1.0

Peak Maximum Instances Pooled: 1.0

Peak Maximum Transactions Completed: 975.0

Peak Maximum Transactions Rolled Back: 0.0

The pmap.txt included with the test case shows the following:

23284: /apps/Sybase/EAServer/bin/jagsrv Jaguar

00010000 360K read/exec /apps/Sybase/EAServer/bin/jagsrv

00078000 56K read/write/exec /apps/Sybase/EAServer/bin/jagsrv

00086000 1032920K read/write/exec [ heap ]

B17FE000 16K read/write/exec [ anon ]

B1872000 64K read/write/exec [ anon ]

.

.

.

FF390000 8K read/exec /usr/lib/libdl.so.1

FF3A0000 8K read/write/exec [ anon ]

FF3B0000 160K read/exec /usr/lib/ld.so.1

FF3E8000 8K read/write/exec /usr/lib/ld.so.1

FFB70000 24K - [ stack ]

FFB76000 488K read/write/exec [ stack ]

total 1179080K

RESOLUTION: Fixed in PB 8.0.3 builds after 8/11/2003.

Ability to 'freeze' one or more columns on a datawindow, to allow horizontal scrolling while still seeing 'frozen' columns, similar to the 'Freeze Panes' functionality in Microsoft Excel.

In PB 6.5, the Library Painter interface to SCC API (PVCS) is very poor. We would like the following enhancements : (a) It must display all revisions of all objects directly in the Library Painter (similar to the interface used by PVCS Client s/w) and it must be possible to select any revision of an oject to be used for building the EXE and PBDs. (b) The Registration Directory dialog box must provide the flexibility to choose the way the objects are listed (for e.g, alphabetical, librarywise, etc.). (c) Provide the facility to assign Version Labels to Tip and Previous revisions of an object. Currently, this has to be done thru the PVCS interface only.

the sql statement are shown in long one line

If you type in 31 in the day portion (dd) and then type in the character 慉�, PB8 correctly sets the month field (mmm) to 慉UG�, but PB9 does not allow you to type in anything (probably because APR is the first month beginning with 慉� and it does not have 31 days).

Alternatively, if you type in 31 in the day portion (dd) and then type in the characters 慗U�, PB8 correctly sets the month field (mmm) to 慗UL�, but in PB9 you will end up with the month part being 慏EC� (here again JUN is the first month starting with 慗U� and it does not have 31 days).

To see this behavior you can use either an editmask control on a window with date mask dd/mmm/yy or you can use an external datawindow with a date column having the editmask dd/mmm/yy.

This is a duplicate of CR 354030.

Workaround: exclude the column from the Where Clause in the datawindow painter, using the Update Specifications dialog.

Expected behaviour:

If the user tabs into the column (existing value not highlighted) and enter 1, the result is 10.00.

If the user double clicks the column (existing value highlighted) and enter 1, the result is 1.00.

Problem behaviour: IN PB 9 newer builds:

It makes no difference if the existing value is highlighted, the result is always 10.00

This worked using PB 6.5 but does not work with PB7 or greater. This may be controlled by the Microsoft treeview control, and it may not be possible to fix in PowerBuilder 8.

04/25/2005:

This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release". This change is due to using the Microsoft Treeview control and cannot be controlled within PowerBuilder.

If the target is added to source control there is no ability to scroll the library list when there are more PBLs then the window's size and without disconnect SCC.

In PB8 and PB9 you only can scroll the if you check out the target file.

The scrollbar is not grayed and suggest that you can scroll through the library list.

select * from tableA where id = "b" gives error: Invalid column name 'b'. No problem if single quotes are used instead of double quotes.

The workaround:

execute immediate "set quoted_identifier off" using sqlca;

This doesn't apply to design time, only runtime.

25 - April - 2005:

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

that memory is not released when objects are closed.

In PowerBuilder 8 no such memory leak was experienced.

The problem appears to happen a new row is inserted and a value from a previous row

is placed in this field and then you modify it. A value is added to this field by setitem(). Once you tab out, it will appear as:

B -A -AH-AC---

Instead of

B -A -AH-AB--

Customer does have the following workaround in the wf_getdetailrowitems and the

itemchanged event of dw_1 of w_program_view.

wf_getdetailrowitems:

dw_1.AcceptText()

d_group_code = dw_1.getitemstring(l_row, 'group_code')

if pos(d_group_code, '-') > 0 then

do until pos(d_group_code, '-') = 0

d_group_code = replace(d_group_code, pos(d_group_code, '-'), 1, '')

loop

dw_1.setitem(l_row, 'group_code',d_group_code)

dw_1.accepttext()

end if

//d_group_code = dw_1.getitemstring(l_row, 'group_code')

w_program_view/dw_1/itemchanged event:

string ls_chg

string ls

if lower(dwo.name) = 'group_code' then

ls_chg = data

do until pos(ls_chg, '-') = 0

ls_chg = replace(ls_chg, pos(ls_chg, '-'), 1, '')

loop

if ls_chg <> data then

post setitem(row, dwo.name, ls_chg)

post accepttext()

end if

end if

Created a window with a couple buttons and a listbox for results.

Each button and the window...

The "clicked" event log the:

int ptrX, ptrY

ptrX = this.PointerX()

ptrY = this.PointerY()

..log..

ptrX = parent.PointerX()

ptrY = parent.PointerY()

..log parent coords..

Get really goofy numbers for the X & Y pos.

Happens eg. in the DW or DB Painter.

PB Engineering investigated this issue and has determined it is not a bug. The tab is the character that PB uses to change the focus for controls on a window. Tab to move forward in the tab order, shift tab to move in reverse order. PB is trapping the tab and shift tab for that purpose and the ocx doesn't get them. It was actuallly a bug in 5.0 and 6.0 that there was no keyboard way to navigate to other controls in a window. And it was fixed. The behavior now in 8.0.3 is correct.

The checkbox display is "shadowed" when deselected.

Steps to reproduce error:

1. Create a new datawindow using the product table (you can use any other table as well).

2. Select any four columns from the table.

3. Insert the datawindow control on a window and call the datawindow SaveAs method from a commandbutton.

4. Deploy the application to the device.

5. On the device, retrieve the datawindow data and then click on the commandbutton triggering the SaveAs method.

6. Give the filename as "prodtxt" and filetype as the default "Text with headers". You can also try saving as text or other formats. Click "OK". The device will show an hourglass pointer that turns non-stop. The saved file is created but there's no content in it. Calling the SaveAs method a second time will cause a return code of -1.

the cursor will skip.

For example, after inserting a new row and enter in the following:

B -AB-AB-AB-AB

The cursor will skip to where the y is instead of in the x position:

B -AB-xy-xy-xy-xy

nested reports, some of the data is not printing on the report. There is

no indication or message that this data is missing.

The data does appear from print preview.

The composite datawindow (d_po_hardcopy_internal_main) has the following nested reports:

d_po_hardcopy_internal

d_po_hardcopy_items

d_po_hardcopy_items_not_s

d_po_hardcopy_inv_fwd_int

d_po_hardcopy_terms_and_conds

d_po_hardcopy_terms_and_conds_2

d_po_hardcopy_terms_and_conds_3

d_po_hardcopy_spec_mar_cons_ship

d_po_hardcopy_mar

d_po_hardcopy_acknow

The problem is in the d_po_hardcopy_internal dw. If you call up this dw and print it,

than all the data is showing ok. If you create a new composite dw and place this dw on it,the print problem happens.

the properties of a dynamically created control through the create statement.

When defining a standard visible user object and dynamically creating it using

the OpenUserObject function, then there is no such crash.

3/2004 Per PB Engineering, this is not a bug.

The application should prepare several images for one icon, including different sizes, 16x16, 32x32, 48x48 etc, for the supplied .ico file. Refer to MSDN on icon usage.

Note: The issue that PB Engineering did fix, was for a "side issue".

data, the same data near the middle of the report keeps repeating.

The datawindow is a nested report (d_po_hardcopy_terms_and_conds_main2) but the problem can be reproduce by just calling up the nested report (d_po_hardcopy_terms_and_conds2) and printing that.

PowerBuilder/EAServer application with a modified heapmanager for CR327180\320515.

These instabilities are related to threading (also SharedObjectRegister) and can

occur in particular with multi CPU PC's or under higher load conditions.

Similar to CR 183985, but this is an extension to it. The Allow updates checkbox is unselected and all other properties as well when having three tables in the select, whereas in 183985 only one table is reffered to.

routine deferring it to be executed when acutally needed:

"SELECT * FROM SYS.SESSION_ROLES WHERE ROLE = 'DBA'"

within the debugger nor can you save them to the EAServer logile.

Work-around is to write a function to write it to a custom file

or a loop to write it in parts to the log file.

from a pb client, that exception is not properly returned back to the client.

The error message returned to the client is:

Error: Soap Fault: Soap Server Error

If logging is turned on, the full exception message is in the log file but not

returned using soapexception, runtimeerror or pbxruntimeerror.

The message in the log file is:

<message>

Invocation Target Error:

"Divide by zero at line 3 in function add of object n_calc.;1;3;n_calc;n_calc;add;"

</message>

The message that is appearing back to the client is from the following:

<faultstring>SOAP Server Error</faultstring>

The following is the results of the crash handler:

Exception code: C0000005 ACCESS_VIOLATION

File Name: E:\pb80\Shared\PowerBuilder\PBDWE80.dll

File Version: 8.0.3.10002

Fault address=1162FCED Section:Offset=01:0012ECED

Registers:

EAX:0000B250

EBX:021EE300

ECX:00000001

EDX:0000164A

ESI:00000000

EDI:0000076E

CS:EIP:001B:1162FCED

SS:ESP:0023:0012EE6C EBP:0012EED0

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

Flags:00010212

Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

1162FCED 0012EED0 07E30A70 00000113 000007D2 00000000 dwWinProc+76D

77E72CED 0012EEEC 1162F580 07E30A70 00000113 000007D2 CallWindowProcA+11

77E72D0B 0012EF0C 1162F580 07E30A70 00000113 000007D2 WaitMessage+12

10B70996 0012EF44 07E30A70 00000113 000007D2 00000000 PBC_NormalProc3D+76

77E72CED 000007D2 00000000 00000000 00000000 00000000 CallWindowProcA+11

OS version:

Windows NT 4.0, Build Number: 1381, Service Pack 6

Memory Status:

Total physical memory: 196024K

Available physical memory: 54988K

Total virtual memory usage: 299416K / 415332K

PowerBuilder virtual memory usage: 97540K / 2097024K

If the uo_button\constructor event is commented out then the app works ok. If the uo_dw_updateable\losefocus event is commented out then the app also works ok.

editmasks like:

#,###.00

#.00

#.0000

When selecting the entire column and entering 1.5

The columns will not show the expected values.

Update: Works fine in PB10.2 build 8045

WA: Daynumber() function works ok.

the nested report changes appearance in the dw control and the pdf and print

out shows a large white space between the numbers.

When printing or saving to pdf the d_test2, it will generate many unnecessary

pages of output.

When displaying the nested dw by itself, the line control appears ok. When viewing

as a nested report, the vertical line does not appear. Works ok in PB 9.0 (build 5507).

DataWindow, nor what the real problem is. Please change this to indicate

which DataWindow has the problem, and whether the column specified does

not exist, or whether you're referencing a row that doesn't exist.

DataWindow Object, even if you were really accessing a DataStore.

field values are no longer held if they are left blank.

For example, in PB 8.0.3 and 9.0 a column will appear as:

B -A -AA-AA--

In PB 7.0.3, the same column will appear as:

B -A -AA-AA- -

the shift position, a date datewindow editmask doesn't advances the

cursor location when inputting <shift> <1> etc.

When the Caps Lock key is used instead, dates can be entered normally.

It would be fantastic if the autoscript would, at this point, list the columns in the DataWindow, and/or some of the other object types such as column, etc and then allow for further drill down.

It would also be nice if PB could validate the entries made in a DataWindow get or set operation before runtime.

nested report, the expression of the property is not working consistently.

The final outcome of the report should be that the nested report is staggered as follows:

(where as X represents the nested report position on the datawindow)

X

X

X

X

X

X

That affect is not being achieved. The appearance is:

X

X

X

X

X

X

The first row is always taking the value or the position of the last row in the report.

The expression of the X property is location_1 * 3. The value(s) of location_1 are: 100,200,300.

The first row of the report should have the nested report staggered as:

(location_1 * 3 where location_1 is 100)

X

The next row has the following value (location_1 * 3 where location_1 is 200)

X

The last row should be (location_1 * 3 where location_1 is 300).

When the location_1 value is 100, it is always placing the nested report in the

position for whatever the last value for location_1 would be in the report. In this

test case, it is 300.

procedure has 11 or more parameters, receiving the following error message:

(0031): Database C0038 name11 is not a parameter for procedure country_sel

Not able to reproduce the problem here using two different stored procedures for testing--getuid2 and country_sel. Customer is only able to reproduce the

error using the Informix jdbc driver. Works ok using the IN7 and odbc.

The following is the customer's jdbc log:

DriverManager.initialize: jdbc.drivers = null

JDBC DriverManager initialized

registerDriver: driver[className=com.informix.jdbc.IfxDriver,com.informix.jdbc.IfxDriver@8e9b3b17]

DriverManager.getConnection("jdbc:informix-sqli://tsts03:2034/dev_100_pct:informixserver=d100srvnet")

trying driver[className=com.informix.jdbc.IfxDriver,com.informix.jdbc.IfxDriver@8e9b3b17]

SQLWarning: reason(Database has transactions) SQLState(01I01)

SQLWarning: reason(Informix Dynamic Server database selected) SQLState(01I04)

SQLWarning: reason(Informix extension to an ANSI-compliant standard syntax) SQLState(01I06)

getConnection returning driver[className=com.informix.jdbc.IfxDriver,com.informix.jdbc.IfxDriver@8e9b3b17]

SQLWarning: reason(Informix extension to an ANSI-compliant standard syntax) SQLState(01I06)

SQLWarning: reason(Informix extension to an ANSI-compliant standard syntax) SQLState(01I06)

SQLWarning: reason(Informix extension to an ANSI-compliant standard syntax) SQLState(01I06)

SQLWarning: reason(Informix extension to an ANSI-compliant standard syntax) SQLState(01I06)

The customer provided the following logs:

pbtrace.log

listdlls.txt

protocolfile.log (Generated using the informix debug jdbc file and setting PROTOCOLTRACE=3)

informixjdbc.log (Generated using the informix debug jdbc file and setting TRACE=3)

pathandclasspath.txt

After reproing the issue locally it seems the issue is either with JConnect or Power builder (most probably Power Builder).

I am seeing the query being executed properly for the connection and appropriate results being got. But it seems Power builder is not able to handle the results got back.

This is not an EAServer Bug. As EAServer is only resposible for providing valid connection to the component, which EAServer did provide it.

This might be critical bug at PB level.

datawindow, the circle should be displayed as a normal circle. However,

when customer checked for "Scale Circles", the circle will be displayed

as a "Star-like" image within the datawindow, during run-time, when running

on a Pocket PC.

Add the examples target to this workspace.

Right click the target and do a search on "if"

You should get a GPF or PowerBuilder will disappear.

There is a new DBParm available that solves this problem:

StripParmNames='Yes'

This DBParm is available from PB 7.0.3 onwards.

Workaround:

Use an ODBC connection instead of JDBC.

Apparently occurs when 1) the list of open sheets is displayed under the first menu item, and 2) there is only one submenu item underneath the first menu item. May not be limited to these circumstances but as yet we have not found others.

Workaround: Either display the list of open sheets under a different menu item, or, if possible, add another submenu item to the first menu item.

There are two datawindows, d_prod1 and d_prod2 (updatable). Both datawindows are defined with the following columns:

id integer

description char(30)

When d_prod2 description column is updated with the following data:

This

is

a

test

The appearance in page10 (d_prod1) description field overlaps with the rows below.

page10 (d_prod1 - before update)

<SPAN CLASS=dw-1B7 STYLE="position:absolute; left:0.551in; top:0.021in; width:2.958in" onClick="{return dw_1.itemClicked(0,-1,'description');}" >Tank Top </SPAN>

page20 (d_prod2 - before update)

<TEXTAREA NAME="description_0" ROWS=5 WRAP="off" CLASS=dw-1EE TABINDEX=2 STYLE="position:absolute; left:0.499in; top:0.010in; width:3.792in" onFocus="{dw_1.itemGainFocus(0,2,this,dw_1.gobs.description); dw_1.selectControlContent(this);}" onClick="{var ret; ret= dw_1.itemClicked(0,2,'description'); return ret;}" onChange="{this.bChanged = true;}" onkeypress="DW_EditKeyPressed(-1)" onBlur="{dw_1.itemLoseFocus (this);}">Tank Top </TEXTAREA>

page10 (d_prod1 - after update)

<SPAN CLASS=dw-12E0 STYLE="position:absolute; left:0.551in; top:0.021in; width:2.958in" onClick="{return dw_1.itemClicked(0,-1,'description');}" >This<BR>is<BR>a<BR>test</SPAN>

However, when running on Emulator 2002 and PPC2003, windows CheckBox is TICK, but Datawindow CheckBox is CROSS.

char, or varchar display as textareas in the browser. The side effect is that scrollbars

are displaying when they don't need to.

In PB 7.0.3 (build 10047):

<SPAN CLASS=4 STYLE="position:absolute; left:0.875in; top:0.031in; width:0.907in" onClick="{return .itemClicked(2,-1,'code_code_desc_1');}" >Student Transfer</SPAN>

In PB 9.0.1 (build 7006):

<TEXTAREA NAME="code_code_desc_1_0" ROWS=5 WRAP CLASS=htmldw5 TABINDEX=-32766 STYLE="position:absolute; left:0.875in; top:0.031in; width:0.907in" onFocus="{htmldw.itemGainFocus(0,22,this,htmldw.gobs.code_code_desc_1); htmldw.selectControlContent(this);}" onClick="{var ret; ret= htmldw.itemClicked(0,22,'code_code_desc_1'); return ret;}" onChange="{this.bChanged = true;}" onkeypress="DW_EditKeyPressed(-1)" onBlur="{htmldw.itemLoseFocus (this);}">Student Transfer</TEXTAREA>

Answers from development on customer's specific questions regarding PB 9 support of Oracle 9i RAC:

====Question #1

I'm爈ooking燼t爐his燼rticle爎elating爐o燨racle燭AF燼nd燫AC.

http://otn.oracle.com/oramag/oracle/02-may/o32clusters.html

In爐he燼rticle,爐hey爉ake爐his爏tatement:

"For燼n燼pplication爐o爑se燭AF,爄t爉ust爑se爁ailover-aware燗PI燾alls爁rom爐he燨racle燙all營nterface

(OCI).營nside燨CI燼re燭AF燾allback爎outines爐hat燾an燽e爑sed爐o爉ake燼ny

application爁ailover-aware."

I爏till爓ould爈ike爐o爇now爀xactly爓hat燩B爊atively爏upports爁or燾allback爎outines.

Ans ==> PB natively suuports OCI calls only .OCI calls takes

care of the TAF ( Transaction Application Failover ).

=====Question #2

The燼rticle燼lso爏ays爐his:

"Currently,燭AF爓ill爁ail爋ver爏tandard燬QL燬ELECT

statements爐hathave燽een燾aught燿uring燼爊ode燾rash爄n燼n爄n-flight爐ransaction爁ailure.

In爐he燾urrent爎elease爋f燭AF,爃owever,燭AF爉ust爎estart爏ome爐ypes爋f爐ransactions爁rom爐he燽eginning爋f爐he爐ransaction.

Transactions爄nvolving營NSERT,燯PDATE,爋r燚ELETE爏tatements燼re爊ot爏upported燽y燭AF."

Could爕ou爃elp爉e爎elate爐his爐o爉y燩B燼pplication爄f爄t爓as爑sing燭AF燼nd燾onnecting爐o燼燫AC?

Ans ==> We normally make API calls which in turn may call TAF aware API

calls . Through PB we are able to connect to Oracle Failover servers.

"......Oracle OCI client applications can take advantage of automatic

reconnection after failover, replay of interrupted SELECT statements, and

callback functions that help to automate state recovery....." ( from the

sites reffered above)

========Question #3

I'm爐hinking爐hat燼ny燬ELECT爏tatement爓ould爁ailover爐ransparently燼nd燾omplete爓ithout爐he爑ser爀ver爇nowing爄t爋ccurred.

If爄t爓as�1/2燿one爐hen爐he爏econd�1/2爓ould燽e燾ompleted爋n爐he爊ew爏erver,爀tc...燼nd爐here爓ould燽e爊o

coding爊ecessary爋n爌art爋f爐he燩B爌rogrammer爐o爂et爐his爁unctionality.

(just爉aking爏ure爐he爐snames.ora爄s燾orrect)

For燼n營NSERT,燯PDATE,爋r燚ELETE爏tatement爐hat爓as爄ssued爁rom燼燩B燼pp,爓hat爓ould爃appen?

would燩B爇eep爐rack爋f爐he爏tatements爐hat爓ere爄ssued燼nd爎e-issue爐hem燼gainst爐he爊ew燾onnection?

Ans ====> In Oracle documentation I also found the following statements .

"Database Manipulation Language Clients

Database Manipulation Language (DML) database clients perform INSERT,

UPDATE, and DELETE operations. Oracle handles certain errors and performs a

reconnect when those errors occur.

Without this application code, INSERT, UPDATE, and DELETE operations on the

failed instance return an un-handled Oracle error code. Upon re-submission,

Oracle routes the client connections to a surviving instance. The client

transaction then stops only momentarily until server-side recovery

completes."

====Question #4

What燼bout爄f爉ore爐han爋ne營NSERT爓as爌art爋f燼爈arger爐ransaction,爋r爏ome爋ther燾omplicated燾ombination,爓hat爓ould爃appen?

again爓ould燩B爇eep爐rack爋f爓hat爃as爋ccurred燼nd爎e-issue爐he燬QL燼gainst燼爊ew燾onnection?

Ans ===> Answer to this directly relates to the answer to question 3 above.

to allow scrolling in script of the right pane when the

HScrollbar is not enabled.

PCL driver, it will default to the WingDings font even though Arial is specified

in the printdefinefont function.

job = PrintOpen("Jim")

lr = PrintDefineFont( job, 2 , "Arial", -10, 400, Variable!, Swiss! , FALSE, FALSE )

IF lr = 1 then

PrintText(job, "This is a test", 2000, 2000, 2)

ELSE

MessageBox("Error", "Print Define Font failed")

END IF

PrintClose(job)

Using the filemon utility, you can see that PB is querying the wingdings.ttf file

instead of the arial.ttf.

If I post it, I get a general failure system error, Exception: oxc00000005,

Address:01fb8860, then the application is forced to be closed.

The same app works ok on the same machine in PB 7.0.3 and 8.0.3 but fails in the createinstance in PB 9.0 (build 5507).

The Jaguar.log shows the following:

Sep 17 16:30:10 2003: Library: 'libpbjag90x.so' for component type 'pb90'

Sep 17 16:30:10 2003: AFLIB Message: 18011/11/0: DLL lookup for 'libpbjag90x.so' failed, OS Message: 'ld.so.1: /../duquette/EAServer/bin/jagsrv: fatal: libCstd.so.1: open failed: No such file or directory'

Sep 17 16:30:10 2003: AFLIB Message: 18011/11/0: DLL lookup for 'libpbjag90x.so' failed, OS Message: 'ld.so.1: /../duquette/EAServer/bin/jagsrv: fatal: libCstd.so.1: open failed: No such file or directory'

Sep 17 16:30:10 2003: DynamicLibrary::lookup: af_dll_lookup (libpbjag90x.so, new_JagComponent) failed

Sep 17 16:30:10 2003: CTS_JagComponent::load: failed to load component model library

Sep 17 16:30:10 2003: CTS_Component::load: failed for component 'sedcsm_pkg/n_sedcsm'

Sep 17 16:30:10 2003: SystemException: OBJECT_NOT_EXIST (sedcsm_pkg/n_sedcsm:Home/create - @199.93.182.34)

workaround: shutdown and restart Jaguar with Jaguar Manager

Tabular DW with a DDDW column. DW is read-only.

cannot use the Up or Down Arrow keys if the DDDW has the focus.

No workaround.

in excel.

The problem happens using the Save Rows As from the IDE or using the saveas().

From the excel online help, the column width limit is 255 but the length of cell

context (text) is 32,767. Only 1,024 display in a cell; all 32,767 display in the formula bar. Having wrap text turn on will result in a column having 32,767 instead

of 255.

select File/New/Window, the ActiveX Datawindow will display but the javascript

events will stop working on the new window.

When using IIS, the error in the log file shows a 304: Using the following code:

META http-equiv="Expires" content=-1

SCRIPT language=javascript event="MouseDown(Button, Shift, XPos, YPos, Row, Name)" for="mydw2" alert("MouseDown");

OBJECT id=mydw2 codebase=psdwc80.cab height="100%" width="100%" classid=88881503-8888-1000-8000-080009AC61A9 name=mydw2

WebDw was created thru the Web/JSP Datawindow Page wizard and deployed to a

existing ASA dynamo web site on solaris.

When com.sybase.datawindow.trace is turned on, the trace shows that the

Update, Delete or Insert are not even being called.

Customer would like the ability when the actual datawindow row is too large for the datawindow control to specify some sort of virtual/continuous scrolling so that when the up/down arrows are clicked the action initially lets one see the remainder of the current row but then with an additional click brings up the next row.

When retrieving the dw, the nested report is displayed OK.

However, if you print the datawindow, the nested DW is not printed and it disappears from the screen.

Customer would like the -5 return code documented, explaination of why this is occurring and better documentation on this function and the HTMLContextApplied event.

from one application to another, its causing an access violation and the

application crashes.

The system has one main PB application using the run() to kick off several PB applications. Its switching between these applications when focus is on a cb that will cause the crash.

Switching between the individual PB apps works ok when not invoked from the main

PB app with the run function.

Customer generated a user dump file and dr. watson files and it appears that the

problem is in:

pbvm80!EvtDefaultKillFocus(struct HWND__ * hWnd = <Memory access error>, struct HWND__ * hWndSet = <Memory access error>)+0x48 (CONV: cdecl) [fnevents.cpp @ 1060]

The disassembly code where it fails is:

10c4dbb6 7437 jz pbvm80!EvtDefaultKillFocus+0x7f (10c4dbef)

10c4dbb8 39b8c8000000 cmp [eax+0xc8],edi ds:0023:014d1468=????????

10c4dbbe 752f jnz pbvm80!EvtDefaultKillFocus+0x7f (10c4dbef)

Using the kd utility results in the following output from the memory.dump (nm.dmp) file:

FAULTING_IP:

SharedUserData+304

7ffe0304 c3 ret

EXCEPTION_RECORD: 0012eea8 -- (.exr 12eea8)

ExceptionAddress: 10c4dbb8 (PBVM80!EvtDefaultKillFocus+0x00000048)

ExceptionCode: c0000005 (Access violation)

ExceptionFlags: 00000000

NumberParameters: 2

Parameter[0]: 00000000

Parameter[1]: 014d1468

Attempt to read from address 014d1468

FAULTING_THREAD: 00000d30

BUGCHECK_STR: 80000003

DEFAULT_BUCKET_ID: APPLICATION_FAULT

PROCESS_NAME: a_nm32.exe

CONTEXT: 0012eec4 -- (.cxr 12eec4)

eax=014d13a0 ebx=055f17c0 ecx=0000c000 edx=00001901 esi=0006035a edi=00060374

eip=10c4dbb8 esp=0012f190 ebp=0006035a iopl=0 nv up ei pl nz na po nc

cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000 efl=00010206

PBVM80!EvtDefaultKillFocus+0x48:

10c4dbb8 39b8c8000000 cmp [eax+0xc8],edi ds:0023:014d1468=????????

Resetting default scope

LAST_CONTROL_TRANSFER: from 00000000 to 10c4dbb8

STACK_TEXT:

0006035a 00000000 00000000 00000000 00000000 PBVM80!EvtDefaultKillFocus+0x48

FOLLOWUP_IP:

SharedUserData+304

7ffe0304 c3 ret

FOLLOWUP_NAME: MachineOwner

SYMBOL_NAME: SharedUserData+304

MODULE_NAME: Unknown_Module

IMAGE_NAME: Unknown_Image

DEBUG_FLR_IMAGE_TIMESTAMP: 0

STACK_COMMAND: .cxr 12eec4 ; kb

BUCKET_ID: 80000003_SharedUserData+304

Followup: MachineOwner

The customer confirmed that application crash is happenning when there is focus on the

windows command button and switching to other PB 8.0.3 apps. It doesn't happen if there is focus on other windows controls. There is no script in the Losefocus command button.

The application worked ok in PB 6.5 (Build 1219) and problem happens in PB 8.0.3 (build 9918/10011).

An application using the run() to kick off PB applications

The datawindow painter may crash when going back to the DataSource,

if you have a computed column as select in Syntax mode.

The problem was found using the SYC interface.

When renaming the PBDOM.PBD before adding to the librarylist and creating a m-code executable then in run-time there will be an error R0021 Bad runtime function reference.

04/25/2005:

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

no workaround

Per PB Engineering:

The problem only occurred with PB 8.0.3 and is no longer reproducible with 8.0.4.

provide a propertie like "new page" but only if the child datawindow is splitted over one (or more) pages.

Workaround:

"Check the MenuBar option of the Window and provide a dummy menu if it is Respond window"

Verified fixed in PB 9.0 build 7056.

in which at run-time a certain popup menu subitem is not showing.

Instead a separator line is showing. The sub-menu also contained invisible items.

halt close, the application appears to close but the process is still remaining

when viewing thru the task manager.

The pfc application is coded with 2 yields in the destructor event of n_cst_peat.

The application was closing properly in PB 8.0.2 (build 9506) up thru build 9631. The change in behavior begins in build 9636.

When viewing the output of the PBDebug trace in build 9506, it doesn't appear that the

yields were executed and the last line of the trace is:

End class function +DESTROY for class PEAT, lib entry PEAT

When viewing the output of the PBDebug trace in 9636:

Executing class function YIELD for class SYSTEMFUNCTIONS, lib entry _TYPEDEF

The end of the trace log for build 9636 shows that the class for Peat is never destroyed:

End event +CLOSE for class PEAT, lib entry PEAT

End class function OPENWITHPARM for class SYSTEMFUNCTIONS, lib entry _TYPEDEF

End class function TRIGGEREVENT for class W_S_PROJECTLIST, lib entry W_S_PROJECTLIST

End class function +PFC_MESSAGEROUTER for class W_S_PROJECTLIST, lib entry W_S_PROJECTLIST

End class function OF_SENDMESSAGE for class N_CST_MENU, lib entry N_CST_MENU

End class function OF_SENDMESSAGE for class M_PEAT_MASTER, lib entry M_PEAT_MASTER

Executing object function +DESTROY for class N_CST_MENU, lib entry N_CST_MENU

Executing instruction at line 2

Executing object function TRIGGEREVENT for class N_CST_MENU, lib entry N_CST_MENU

Executing system dll function

End class function TRIGGEREVENT for class N_CST_MENU, lib entry N_CST_MENU

End class function +DESTROY for class N_CST_MENU, lib entry N_CST_MENU

Executing object function +DESTROY for class DWOBJECT, lib entry _TYPEDEF

Executing instruction at line 2146

Executing object function __DESTROY_OBJECT for class DWOBJECT, lib entry _TYPEDEF

Executing system dll function

End class function __DESTROY_OBJECT for class DWOBJECT, lib entry _TYPEDEF

End class function +DESTROY for class DWOBJECT, lib entry _TYPEDEF

Executing object function +DESTROY for class DATASTORE, lib entry _TYPEDEF

Executing instruction at line 4105

Executing object function DATASTOREDESTROY for class DATASTORE, lib entry _TYPEDEF

Executing system dll function

End class function DATASTOREDESTROY for class DATASTORE, lib entry _TYPEDEF

End class function +DESTROY for class DATASTORE, lib entry _TYPEDEF

If you remove the yields from the destructor event of n_cst_peat, than the app

closes ok and there are no left over processes.

Whenever there is long name (128 byte) pass to the function, there will be around 8K memory leakage.

"Move DW data source into additional tab page in DW painter to eliminate need to exit painter via SQL button or any right mouse clicking."

at runtime to false, you cannot enter any data into that control.

The problem only happens when the DisplayOnly property is set to true in the PB IDE

and then changed to false at runtime. It works ok if the property is not checked

in the PB IDE and then during runtime it is changed to true.

Problem is only for editmask. Multiline, singleline and rich text controls work

ok.

When using the generateresultset in a PB component called

from either a PB client or Java client, it will result in a Sybase Heap Manager Exception.

The following code is used:

f_generateresult return resultset

resultset rs

Datastore lds

lds = create Datastore

lds.dataobject = "d_import"

lds.generateresultset(rs)

return rs

From the Jaguar.log file:

ct 01 12:32:14 2003: Sybase Heap Manager Exception:

Oct 01 12:32:14 2003: commitVM(425984) failed

Oct 01 12:32:14 2003: _______________________________________________________________________________

Oct 01 12:32:14 2003: Sybase Heap Manager Exception:

Oct 01 12:32:14 2003: alloc(type JagOctet*, size 263402) failed

Oct 01 12:32:14 2003: _______________________________________________________________________________

Oct 01 12:32:14 2003: Heap Summary:

Oct 01 12:32:14 2003: _______________________________________________________________________________

Oct 01 12:32:14 2003: #blocks #blocks #blocks #bytes #bytes #bytes size index | range

Oct 01 12:32:14 2003: free in use total free in use total

Oct 01 12:32:14 2003: ________ ________ ________ __________ __________ __________ ___________________

Oct 01 12:32:14 2003: 1 11065 11066 80 885200 885280 00 | 0..8

Oct 01 12:32:14 2003: 0 6482 6482 0 570416 570416 01 | 9..16

Oct 01 12:32:14 2003: 116 2008 2124 11136 192712 203848 02 | 17..24

Oct 01 12:32:14 2003: 28 341 369 2912 35464 38376 03 | 25..32

Oct 01 12:32:14 2003: 147 1385 1532 17640 166200 183840 04 | 33..48

Oct 01 12:32:14 2003: 19 112 131 2584 15232 17816 05 | 49..64

Oct 01 12:32:14 2003: 3 54 57 504 9072 9576 06 | 65..96

Oct 01 12:32:14 2003: 2 24 26 400 4800 5200 07 | 97..128

Oct 01 12:32:14 2003: 3 15 18 792 3960 4752 08 | 129..192

Oct 01 12:32:14 2003: 3 3 6 984 984 1968 09 | 193..256

Oct 01 12:32:14 2003: 3 20 23 1368 9120 10488 10 | 257..384

Oct 01 12:32:14 2003: 3 4 7 1752 2336 4088 11 | 385..512

Oct 01 12:32:14 2003: 1 0 1 840 0 840 12 | 513..768

Oct 01 12:32:14 2003: 0 25 25 0 27400 27400 13 | 769..1024

Oct 01 12:32:14 2003: 0 2 2 0 3216 3216 14 | 1025..1536

Oct 01 12:32:14 2003: 0 2 2 0 4240 4240 15 | 1537..2048

Oct 01 12:32:14 2003: 0 10 10 0 41680 41680 17 | 3073..4096

Oct 01 12:32:14 2003: 0 1 1 0 6216 6216 18 | 4097..6144

Oct 01 12:32:14 2003: 0 2 2 0 16528 16528 19 | 6145..8192

Oct 01 12:32:14 2003: 0 13 13 0 213928 213928 21 | 12289..16384

Oct 01 12:32:14 2003: 1 0 1 65536 0 65536 25 | 49153..65464

Oct 01 12:32:14 2003: 0 1 1 0 98304 98304 26 | 65465..98232

Oct 01 12:32:14 2003: 1 0 1 262144 0 262144 28 | 163769..262072

Oct 01 12:32:14 2003: 0 453 453 0 192970752 192970752 29 | 262073..425912

Oct 01 12:32:14 2003: 6 0 6 502816 0 502816 unused small blocks

Oct 01 12:32:14 2003: ________ ________ ________ __________ __________ __________ ___________________

Oct 01 12:32:14 2003: 331 22022 22353 871488 195277760 196149248 VM size: 196575232

Oct 01 12:32:14 2003: _______________________________________________________________________________

Oct 01 12:32:14 2003: committed bytes: 123428864 (total)

Oct 01 12:32:14 2003: in small blocks: 502816 (unused), 40992 (free), 2208704 (in use)

Oct 01 12:32:14 2003: in large blocks: 120676352 (in use)

Oct 01 12:32:14 2003: permanent bytes: 0

Oct 01 12:32:14 2003: _______________________________________________________________________________

Oct 01 12:32:16 2003: CORBA Runtime Error Occurs when try to invoke PB method f_generateresult in testresult/n_testgenresult.

Oct 01 12:32:16 2003: SystemException: NO_MEMORY (testresult/n_testgenresult/f_generateresult - jagadmin@204.167.42.175)

Oct 01 12:32:21 2003:

The request is to have greater flexibility in setting the size and position

of the text and picture of the PictureButton control, positioning them separately.

property on the last fields in a datawindow at runtime, its causing the last

column to wrap around to the first column even though the visible property

has been set to false and and the width property set to 0 for these columns.

There are 10 columns on the datawindow:

s_first

s_second

s_third

s_fourth

s_fifth

s_sixth

s_seventh

row_tag

error_flag

protect_flag

At runtime, the following code is in the constructor event of the w_testapp_datawindow:

This.object.s_outage_start_date.protect = 0

This.object.row_tag.width = 0

This.object.error_flag = 0

This.object.protect_flag = 0

This.object.row_tag.visible = false

This.object.error_flag.visible = false

This.object.protect_flag = false

However, by moving the order when the properties are set as follows, than the

application works ok:

This.object.row_tag.visible = false

This.object.error_flag.visible = false

This.object.protect_flag = false

This.object.s_outage_start_date.protect = 0

This.object.row_tag.width = 0

This.object.error_flag = 0

This.object.protect_flag = 0

inaccuracy can occur due to implicit conversions to the double type.

Conversion to the decimal type may improve accuracy.

This behavior has been noted since at least PB 3.0b/4.0. An old enhancement request ( CR 153870) was opened but never implemented. The CR was closed as part of a review as 'Not targeted for any future release'.

Current behavior is:

FOCUS ON: Tabs are interpreted correctly by the edit control.

FOCUS OFF: Tabs become "square or rectangular boxes".

The customer believes this current behavior is a bug and that the embedded tabs should be formatted in the datawindow column even when the focus is not on that row.

Printing the datawindow displays all rows with the embedded tab spacing.

"If the window is not visible, SetRedraw fails."

SetRedraw method (DataWindow) is missing the above line of text.

Tested and reproduced in PB 9.0_5507, 9.0.1_6533.

ODBC error : Column not found: Column 'id' not found

<package>/<compoent>, the Jaguar Console will be thrown an exception :

" No handler for exception."

and in PowerBuilder 9.

will occur when trying to use it in an OLE container control:

"OLE Control Is Missing Critical Interface 'IPersistStorage'"

This is an enhancement request to support also other Interfaces

IPersistStream, IPersistStreamInit.

Resolution notes that this needs to be addressed for both PowerBuilder and Pocket PowerBuilder.

occurs when trying to create a datawindow on a stored procedure that returns multiple resultsets.

No crash occurs either connecting through the O73 Oracle7 native interface or connecting

to an Oracle8 database.

either the datawindow painter or database painter, it takes 50+ seconds to retrieve

in PB 8.0.4 and PB 9.0.1.

If the same table was retrieved from PowerBuilder 6.5 (build 444 or 620), it takes

only 10-15 seconds. I realize that PB 6.5 isn't supported anymore but there is

a difference in performance even in PB 6.5. Performance is 45-50+ seconds using

PB 6.5 (builds 1137 and 1326).

04/25/2005:

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

correctly, or it looks like sometimes parts of the keyboard

are drawn overtop of the buttons.

This is on windows which contain a data-window along with

common controls like command buttons.

This does NOT happen every time, but rare - like once in 25 windows...

Customer is using PB 8 to attempt to build an application to communicate

with a serial port device. They are also using an OLE object ('IO.OCX')

for the actual communication functions. This OCX has specific events that

are supposed to fire whenever a character is added to the serial port buffer. This doesn't seem to happen in PB but does with the OCX supplied VB sample application.

Using a Visual Basic demo application one can see the events firing when

the device is in the initialization stage, however the PowerBuilder

application doesn't seem to recognize that the device is adding

characters to the buffer.

The ocx is available from http://www.jspayne.com/io/home.html - it comes with

its own demo application in VB.

The hardware they are using is a Ingenico eN-crypt 1200 pinsmart card reader

machine, In the initilization mode it sends <ENQ> charactors in RS-232 protocol toggling

between 4800 and 9600 baud.

Workaround that worked for this situation:

First delete the ole object that had already been inserted. (We can backup the code we had written on the object before we delete it. )

Second insert IO Control from tab 擨nsert Control�. Name it and write its code as the original ole object. You will find it will works.

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

1. Open the window that you wish to place the OCX control on.

2. Choose Controls甇LE to invoke the Insert Object dialog.

3. From the Insert Object dialog, select the third tab titled Insert Control.

It is very important that you use the Insert Control tab instead of the Create New tab.

When you use Create New tab, it inserts the control as an OLE Automation object.

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

web service, the following error returns:

Unknown error, problem with SoapClient

There is no errors in the soap.log file. The ASinSearchRequest is defined with the following arguments: asin,tag,type,devtag and version and returns a structure of type ProductInfo.

The ProductInfo structure contains:

totalresults

totalpages

listname

details[]

The details structure contains many arrays and structure arrays. When viewing

the debug code, it appears the problem may be getting the return value (productinfo).

PBSELECT that is difficult to alter in case of multi-table joins and complex SQL statements. Further, changing the object definition at runtime is not currently being supported (similar to changing a datawindow's attributes) that confines this wonderful object inside a limited scope. To use a 'different' pipeline object for each piping operation is redundant if we can achieve it by just modifying its definition/select-statement/where-clause... dynamically with ease like a datawindow.

BuildFromDataStore will fail if the end users have restricted access.

Workaround: Do not Post the call to Modify, or if possible, do not use the ItemChanged event. Other events also worked even when the call was posted.

Workarounds:

1) Click on the left parenthesis “(“ button.

2) Copy and paste “(“

3) Return to script painter to enter “(“

The global function painter may crash when saving a function, after

the application has been run.

At a minimum, the part about "Please update current Database Profile" should be removed. Some developer control over the message would also be advantageous.

argument is a decimal, the following error will result if the decimal field is not

initialize first before calling the stored procedure:

241: Scale error during implicit conversion of decimal value to a decimal field

The following is the stored procedure called:

create proc getdecimal_9 (@val decimal(18,9) output) as select @val = convert(decimal(18,9), 0.123456789)

The output variable is defined in PB as:

decimal{9} decvar_9

workaround:

add first the client script or change the <SCRIPT language="Java"></SCRIPT> to <SCRIPT language="JavaScrip"></SCRIPT> in the source directly

Workaround:

Add: style="overflow: hidden". In the Web datawindow, it can be added for the column in the field 'Append Html Syntax'.

Works fine on DDLB and Edit fields, but for CheckBox and RadioButtons no values can be preset visually, the values in the buffers are ok.

s_open_window_parms lstr_parms

istr_parms = lstr_parms

openwithparm(w_import_revision_300,istr_parms)

//open event of w_import_revision_300

window lw

lw = this

open(w_version_compare, lw)

// open event of w_version_compare

garbagecollect() <- powerbuilder will crash

garbagecollect()

If you don't use a structure in the openwithparm, than application works ok. Passing

a string or double instead of a structure will work.

This is for with Phone edit masks (###)-###-####, if I type the number say as 624 637 5, and then hit a backspace, the cursor goes

before the dash (-) just after number 7 of 637. Now if you try to type in anything, it does not allow you unless you move the cursor one postion to

the right. In PB 8.0 and previous releases, cursor used to remain after the dash (-) and hence you could start typing the number directly.

Workaround: Post the call to ScrollToRow().

Workaround:

1. create crosstab without String(sales_order_order_date, "dd/mm/yyyy")

2. Add the String(sales_order_order_date, "dd/mm/yyyy") directly by edit the source

columns = "string(sales_order_order_date,~"dd/mm/yyyy~")" rows = "....

No workaround

Editmasks of type #0.00 ###0.00 00.00 do not

enter digits properly when selecting the fields.

In an editmaks "#0.00" entering 1234 results into

1.23 instead of 12.34

If choosing a control (button or ceckbox etc.) in the datawindow, hover over it, then whish your mouse away very very quickly -> the control will still have the effect on it.

no workaround

-> SoapException: java.lang.NumberFormatException: Unexpected characters

in the log:

soapenv:Server.userException</faultcode>

<faultstring>java.lang.NumberFormatException: Unexpected characters

under the print specification tab is set to landscape, that property is not

passed on to the print dialog box. When the print dialog window opens, and you click on the layout tab, it always defaults to portrait.

In order for this to work, the paper orientation must be passed to the s_printdlgattrib

structure and it appears that must be manually coded. You must code that in the

u_dw/pfc_preprintdlg event:

string ls_orientation

ls_orientation = this.object.datawindow.print.orientation

astr_printdlg.i_orientation = integer(ls_orientation)

Even if the s_printdlgattrib is coded with the paper orientation, the code in the pfcprtdg.cpp does not populate that property. For example the following code

is needed before the print dialog opens (LONG lReturn = PrintDlg(&pd):

If (pAttrib->i_orientation == DW_PRINT_ORIENT_LANDSCAPE)

pDevMode->dmOrientation = DMORIENT_LANDSCAPE;

The pfc_print calls the pfc_printdlg. The pfc_printdlg calls the pfc_preprintdlg and the

of_printdlg. The of_printdlg calls the external function pfc_printdlg(ll_hwnd, astr_printdlg). This is located in the pfc_n_cst_platformwin32.

datawindow in the header, detail, summary and footer, the last line is missing

is the header and footer bands.

:unable to initialize scc status cache from backup (your workspace directory)\(your workspace).pbc"

Resolution:

This is an informational message only.

You can safely ignore it.

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

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

Data Source it works fine.

no workaround

no workaround

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

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

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

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

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

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

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

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

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

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

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

value ( ) or hex value ( ).

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

dw_1.retrieve()

dw_1.setfilter("emp_id=102")

dw_1.filter()

dw_1.getfullstate(lblb_data)

dw_2.setfullstate(lblb_data)

When using the O73 driver, the retrieve works OK.

Steps to reproduce problem:

1. Open up the function painter.

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

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

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

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

Steps to reproduce crash:

1. Open up the menu painter.

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

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

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

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

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

been found with a very large modify statement.

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

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

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

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

The following is listing is from the crash handler:

Exception code: C0000005 ACCESS_VIOLATION

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

File Version: 5.00.3502.6144

Fault address=78325641 Section:Offset=01:00034641

Registers:

EAX:782F53F0

EBX:00000000

ECX:00000000

EDX:0012C510

ESI:0140E970

EDI:001A1408

CS:EIP:001B:78325641

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

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

Flags:00010202

Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

10C58730 10DCB7F8 10C63320 00000000 10DAA020 10DAA020 obFreeDebug+4D0

datawindow reference manual, it states the following:

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

Actually when you run the command:

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

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

style name, I used the following:

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

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

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

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

Scc Provider: PVCS Source Control Capabilities: 1382070013

UserID:

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

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

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

Diff_Strategy: SccDiff

Scc multi-threading set to TRUE

Connection to source control established

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Getting the latest version of selected items . . .

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

Importing w_test1trunk_sheet1.srw . . .

Compiling types for w_test1trunk_sheet1.srw . . .

Regenerating w_test1trunk_sheet1.srw . . .

IMPORT and COMPILE Results. PASS 1 PASS 2 PASS 3

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

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

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

Operation Completed

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

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

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

An access violation occurs due to memory relocation.

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

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

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

won't find the project.

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

then under certain circumstance a confusion may occur between

ancestor and descendant scripts.

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

later when trying to save the script or the object.

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

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

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

selectblob or updateblob.

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

selectblob:

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

select:

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

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

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

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

Notice the value set vs. the value read.

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

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

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

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

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

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

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

2) Script vanished during "Get Latest Version"

The generated SQL will produce different resultsets.

Workaround:

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

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

or, select release 11

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

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

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

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

without PB crashing.

The following is the crash handler from PB 8.0.4:

Exception code: C0000005 ACCESS_VIOLATION

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

File Version: 8.0.4.10538

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

Registers:

EAX:00000000

EBX:06AD077C

ECX:012CC770

EDX:06DA4ACC

ESI:0664DDC8

EDI:06DA7E90

CS:EIP:001B:120A86D4

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

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

Flags:00010282

Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

77E3A244 C0000000 00000000 00000000 00000000 00000000 SetProcessWindowStation+4

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

pb90 a00-5fc ENTER SQLExecDirect

HSTMT 025519B0

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

SDWORD -3

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

HSTMT 025519B0

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

SDWORD -3

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

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

String ls_null

SetNull(ls_null)

dw_1.SetSort(ls_null)

dw_1.Sort()

OR

String ls_null

SetNull(ls_null)

dw_1.SetFilter(ls_null)

dw_1.Filter()

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

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

When selecting a nvo you'll get a proxy.

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

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

no workaround

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

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

Not reproducible in PB 8.0.4 build 9882.

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

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

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

The crash handler log reports:

Exception code: C0000005 ACCESS_VIOLATION

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

File Version: 9.0.1.7048

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

Registers:

EAX:00000006

EBX:00000000

ECX:00000000

EDX:FFFFFFFF

ESI:0280C31C

EDI:FFFFFFFF

CS:EIP:001B:1166F42D

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

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

Flags:00010296

Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

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

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

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

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

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

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

11645C2E 00000519 00000000 00000000 00000000 00000000 dwWinProc+116E

OS version:

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

Memory Status:

Total physical memory: 261552K

Available physical memory: 33100K

Total virtual memory usage: 309616K / 763108K

PowerBuilder virtual memory usage: 131916K / 2097024K

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

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

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

C0166: Variable name conflicts with parameter name:myany

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

Workaround:

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

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

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

General information

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

For information about naming conventions, see Application Techniques.

X and Y as variable names

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

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

Also:

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

Overusing the Any datatype

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

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

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

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

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

SQLDBCode: 1007

SQLErrText: ORA-01007: variable not in select list

or

SQLDBCode: DBCode: 0

SQLErrText: Mismatch between retrieve columns and fetch columns

causes the following error to occur:

pb100.exe - Application Error

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

at location 0x10db5636.

is selected, the right most character is partially truncated.

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

static text field on a window.

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

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

pb does not respond anymore. Its just hangs.

Implicit destroy the datawindow (by closing the window

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

Reopen the window (shareData called again), and code

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

program hangs or GPF's. This causes no problems

if the program runs from the IDE.

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

editmask.

definition of the numerical separators in the control

panel while PowerBuilder applications are running.

Currently (datawindow) editmasks may not function properly

after changing the symbols for the decimal separator and

thousands separator and require the restart of the application

or the development environment.

Executing a SQL statement from PB DB painter like this :

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

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

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

EditMask : ####,##0.00

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

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

Suggestions:

1) increase the physical memory installed on the machine

2) using Windows 2000 Server/Advanced Server Edition

3) using /3GB flag to start Windows 2000

4) Increase PB_HEAP_SIZE to a large value

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

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

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

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

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

blobmid ( blob b, unsignedlong o ) returns blob

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

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

blob is passed by value.

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

slow with a sizeable blob.

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

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

under the Data Export tab, than no problem.

According to the online help for saveas:

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

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

Exception code: C0000005 ACCESS_VIOLATION

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

File Version: 9.0.1.7056

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

Registers:

EAX:00000000

EBX:0334F2F8

ECX:00001178

EDX:10E3FA00

ESI:00000000

EDI:032DC9F8

CS:EIP:001B:1165FA8F

SS:ESP:0023:0012E158 EBP:00000000

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

Flags:00010246

Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

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

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

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

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

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

11645CDE 00000519 00000000 00000000 00000000 00000000 dwWinProc+116E

OS version:

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

Memory Status:

Total physical memory: 261552K

Available physical memory: 32084K

Total virtual memory usage: 418988K / 763108K

PowerBuilder virtual memory usage: 132980K / 2097024K

The PowerScript Reference states:

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

A global external function.

A global function.

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

A system function.

and the DataWIndow Reference states:

User-defined functions in PowerBuilder

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

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

When doing a retrieve several times on a datawindow having slightly more than 100 rows there is a gpf on the device:

Application mawi.exe has performed an illegal operation and will be shut down. If the problem persists contact the prgram vendor.

Exception: 0xc0000005

//Update

Works ok on a fresh PPC with PPB 1.5 GA.

Also newer builds have an improved memory management.

and calling a jsp webdatawindow, the following error displays in the jaguar.log:

Entering SetDWObject('d_tabular.srd','')

Doing SRD

Entering Create()

Exiting Create() = 'Datawindow syntax has incorrect release number.'

EnableCommit()

SetDWObject: ERROR - Create from SRD failed for 'd_tabular.srd', Error String =

'Datawidnow syntax has incorrect release number.'

The following is DW HTML for a row that contains a datetime

column:

d_query_offload_expenditure_niin.rows[0] = new HTDW_RowClass(

"((1 0 '002029473')(5 0 'H')(6 0 '2003-05-06 07:13:00:043000

'))",0,"002029473","EA",31,"V","H",new

DW_DatetimeClass(103,4,6,7,13,0,43000),"20885",new

DW_DatetimeClass(103,4,6,0,0,0,0),"0001","3126","3126","STK",new

DW_DatetimeClass(103,4,6,0,0,0,0),"-679");

When the GOB is created for the datetime cell it separates the

date and time pieces into separate values. If the microseconds

contain a leading zero that zero is lost because the value is

treated as a number rather than a string. Note the bolded

values above. When the datetime is represented as a string it

correctly contains the leading zero on the microseconds

("043000") but when the date and time parts are passed to

DW_DatetimeClass the microseconds are passed as a number

(043000) and the leading zero is lost (43000). As far as I can

tell the only date and time part that is hurt by losing leading

zeroes is the microseconds. All others are evaluated properly

without the leading zeroes.

WORKAROUND: What's happening here is that when he tries to build the app using DLLs, PowerBuilder attempts to write the PBSOAPCLIENT90.PBD as a DLL. This overwrites the PBSOAPCLIENT90.DLL file that ships with the product. He'll need to re-apply PBSOAPCLIENT90.DLL from the build he is using. Then he can write the project using PBDs.

Workaround:

Under one combination of keydown(keyp!) and sleobject.triggerevent(rbuttondown!), the event runs once.

Per development: Response windows by definition do not have menus. This is not a bug.

Migrated" dialog, nothing happens.

This is not a PB bug. It is common bug that is described in MSDN. You can read it at http://support.microsoft.com/?id=247791. As a workaround try using the modal form instead:

form.Show vbModal

and click on it with the stylus it works fine. If I fill in the URL

and try to programmatically trigger the clicked event (shl_1.event

clicked()) nothing happens. If I create a user event on the control

and trigger it, the user event works fine.

6533).

Initially reported for PowerBuilder 9. Also reported for Infomaker 8.0.4.

Workaround: If you need to do "Save Rows As" for a result set, get the results one SQL statement at a time.

computed field and text field, you will see that the 2 nested reports are overlapping

each other by scrolling thru the report in the dw painter.

At least in the simplest case, can work around this by setting the column height to zero instead of turning off the Visible property.

At runtime on the device.

When the cursor is positioned at the and of the date-field AND the date is

not selected AND then I click the spin-control.

Nothing spins.

Not a bug. Need to set Locale Language to Hebrew before running the migration.

OS: Win2000 SP4

PB Version and builds TESTED in: 9.0_5507, 9.0.1_6533, 9.0.1_7031 and 9.0.1_7048

This happens only when using O90 interface. Works fine with ODBC.

a text field and computed field, these fields overlap onto the nested report.

Tested in: PB 8.0.4_10551, 9.0_5507, 9.0.1_7048, 9.0.1_6533

The error does not occur if you turn on DisableBind

Use of 'this' pronoun in global function should be flagged as compiler error.

PowerBuilder crashes when you call ClassName or TypeOf in a global function.

no workaround

This seems to be very icon dependent, possibly even related

to the tool used to create the icon.

Repro:

a) In the window painter - set the "window icon", browse to the "ship.ico"

b) press <open>

c) GPF - referenced memory at "0x00002e"

partly outside the sheet when the sheet is opened with a

larger Windows 'Active Title Bar' sizes set than at design time.

structure we got an error :

"Could not find Element by name versiontns1:TipiVersionen"

In this case there is a need of two substructure inside

the returned structure (not only one !).

The crash found occurs during garbage collection and may go away when setting

the GarbageCollect Time Limit to a very high limit (for example 1000000).

The root cause of this problem was found to be passing powerobjects to

external functions which is not supported.

sometimes looses the format of the detail report.

When the detail report is larger than the frame to display the report in, the format

appears to get scrambled.

Quiesce hold after it is released, the query is cancelled in PB and there is a datawindow

error of:

Datawindow Error:

Your query is blocked because it tried to write and database 'pubs2' is in quiesce state.

Your query will proceed after the DBA performs QUIESCE DATABASE RELEASE.

No changes made to database.

The query does not proceed, its cancels and indicated by the following pbtrace.log:

7474848): INSERT INTO test ( id, name ) VALUES ( 744, 'Test Row 744' )

(7474848): SRV 10 #880 Your query is blocked because it tried to write and database 'pubs2' is in quiesce state. Your query will proceed after the DBA performs QUIESCE DATABASE RELEASE. (0 MilliSeconds)

(7474848): SRV 10 #880 Your query is blocked because it tried to write and database 'pubs2' is in quiesce state. Your query will proceed after the DBA performs QUIESCE DATABASE RELEASE. (0 MilliSeconds) (7561 MilliSeconds)

(7474848):

Error 880 (rc -1) : Your query is blocked because it tried to write and database 'pubs2' is in quiesce state. Your query will proceed after the DBA performs QUIESCE DATABASE RELEASE.

(7474848): CANCEL: (0 MilliSeconds)

Workaround:

There is a zip file that has been staged on our ftp site that contains the

.reg files (IStorage.reg, IStream.reg) and can be downloaded from:

ftp://psaftp.sybase.com/pub/private/pbpatch/CR239044.zip

Copy the .REG files and double-click on them to update.

directory as pb9 and you try to run a pb9 web services client, a runtime function

reference error will result.

freeing the datawindow memory or pbheap_dump(0).

The following error appears:

pb90.exe - Application Error

The exception Breakpoint

A breakpoint has been reached.

(0x80000003) occurred in the application at location 0x10da78a4

Per PB Engineering, this is not a PB bug:

This problem is caused by Oracle client interface version 8 (OCI8) not caused by PB. There is no problem with OCI9 (query table of Oracle 7 and Oracle 8).

deploy, the project (to create an exe) does not get deployed. In the output

view, it just shows:

-------Deploy:Deploy of project p_project_1

-------Finished Deploy of project p_project_1

If you RMB on the project and select deploy, the exe does get generated.

If you RMB on the workspace and select properties, under the "Deploy Preview" tab

you will see that the project name is truncate. It shows p_project_1 instead of

p_project_1_test_this. If you also RMB on the target and select properties, under

the "Deploy" tab it also shows the project name truncated.

then the height of the window increases.

European Control Panel Settings are used (decimal separator comma ',' and thousand separator a dot '.').

This is a regression in PowerBuilder 8 Build 10521

powerobject p

p = w_1

open(p)

will not compile but

powerobject p

p = w_1

close(p)

does compile. I would say neither should compile.

PER DEVELOPMENT: This is not a bug.

The powerscript is a kind of script language so that it has no strict type checking and type casting. For arguments passed by reference, the PB compiler does a strict type checking to make sure that the passed arguments must be same to the function prototype or be a descendant of prototype argument. For arguments passed by value, the PB compiler relaxs the limit, besides a situation as shown above, the PB compiler thinks that it is OK if the passed argument is a ancester of prototype argument.

According to the prototype of the function Open(), the prototype argument is passed by reference. So, the compiler will give out an error for passing POWEROBJECT. Otherwise, the prototype argument is byvalue in the prototype of the function Close() and POWEROBJECT is the ancester of WINDOWOBJECT, it can compile properly.

only 1 table appears in the db painter view or the table list when creating a

datawindow.

The sql.log files shows the following error:

pb80 ce4-7d4 ENTER SQLExecDirect

HSTMT 02552600

UCHAR * 0x01260D40 [ -3] "CREATE TABLE pbcattbl ()\ 0"

SDWORD -3

pb80 ce4-7d4 EXIT SQLExecDirect with return code -1 (SQL_ERROR)

HSTMT 02552600

UCHAR * 0x01260D40 [ -3] "CREATE TABLE pbcattbl ()\ 0"

SDWORD -3

DIAG [37000] [ProvideX][ODBC Driver]Expected lexical element not found: <identifier> (1015)

pb80 ce4-7d4 ENTER SQLErrorW

HENV 02551540

HDBC 025515E8

HSTMT 02552600

WCHAR * 0x0012E260 (NYI)

SDWORD * 0x0012E2AC

WCHAR * 0x0012DE60

SWORD 512

SWORD * 0x0012E2B4

pb80 ce4-7d4 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)

HENV 02551540

HDBC 025515E8

HSTMT 02552600

WCHAR * 0x0012E260 (NYI)

SDWORD * 0x0012E2AC (1015)

WCHAR * 0x0012DE60 [ 71] "[ProvideX][ODBC Driver]Expected lex"

SWORD 512

SWORD * 0x0012E2B4 (71)

You can connect to excel and see all the tables. The log file from ProvideX shows the following when connected to excel:

<3140> ISAMOpen: Open file D:\pse-80\10987656\Nomads\providex.ddf , returns fhFile=1496064

<3140> <Customer Classes> Open file D:\pse-80\10987656\Nomads\clsfile , fhFile =1549832 , maxksz=35

<3140> ISAMCloseTable: Closing table Customer Classes - 0 file reads, 0 re-reads, 0 writes, 0 removes

<3140> CACHE STATS - 0 reads, size 11264 estimated, 0 used

<3140> <Customer Classes> Open file D:\pse-80\10987656\Nomads\clsfile , fhFile =1548352 , maxksz=35

<3140> ISAMCloseTable: Closing table Customer Classes - 0 file reads, 0 re-reads, 0 writes, 0 removes

<3140> CACHE STATS - 0 reads, size 11264 estimated, 0 used

<3140> <Salesman> Open file D:\pse-80\10987656\Nomads\smnfile , fhFile =1548352 , maxksz=35

<3140> ISAMCloseTable: Closing table Salesman - 0 file reads, 0 re-reads, 0 writes, 0 removes

<3140> CACHE STATS - 0 reads, size 4096 estimated, 0 used

<3140> <Salesman> Open file D:\pse-80\10987656\Nomads\smnfile , fhFile =1548352 , maxksz=35

<3140> ISAMCloseTable: Closing table Salesman - 0 file reads, 0 re-reads, 0 writes, 0 removes

<3140> CACHE STATS - 0 reads, size 4096 estimated, 0 used

<3140> ------------------------------

<3140> SELECT DISTINCT SMN_NAME FROM ""Salesman Salesman

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

When connected thru PowerBuilder, you don't see it getting past the first table--customer:

64> ISAMOpen: Open file D:\pse-80\10987656\Nomads\providex.ddf , returns fhFile=1964064

<3364> <Customer> Open file D:\pse-80\10987656\Nomads\cstfile , fhFile =1975680 , maxksz=35

<3364> ISAMCloseTable: Closing table Customer - 0 file reads, 0 re-reads, 0 writes, 0 removes

<3364> CACHE STATS - 0 reads, size 9216 estimated, 0 used

<3364> <customer> Open file D:\pse-80\10987656\Nomads\cstfile , fhFile =1972664 , maxksz=35

<3364> ISAMCloseTable: Closing table customer - 0 file reads, 0 re-reads, 0 writes, 0 removes

<3364> CACHE STATS - 0 reads, size 9216 estimated, 0 used

<3364> <customer> Open file D:\pse-80\10987656\Nomads\cstfile , fhFile =1972664 , maxksz=35

<3364> ISAMCloseTable: Closing table customer - 0 file reads, 0 re-reads, 0 writes, 0 removes

<3364> CACHE STATS - 0 reads, size 9216 estimated, 0 used

<3364> <customer> Open file D:\pse-80\10987656\Nomads\cstfile , fhFile =1972664 , maxksz=35

<3364> ISAMCloseTable: Closing table customer - 0 file reads, 0 re-reads, 0 writes, 0 removes

<3364> CACHE STATS - 0 reads, size 9216 estimated, 0 used

SOLUTION: Add the following to the pbodbxx.ini file:

;ProvideX odbc driver

[ProvideX]

PBFileManager='YES'

Block=1

The CR was fix by this build as customer successfully test on tripped down PB App. However, customer found that fail to build on his True Application. Got error on compilation : Compiled segment size exceeds 64k

Resolution:

Fixed in PB 9.0.1 EBF builds 7066 and >.

Powerbuilder, getting a '"X" not a parameter for procedure select_hello_world'.

From isql using the following syntax will generate the error:

execute select_hello_world 'X';