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

when using a FILE DSN or DSN-less connect.

This CR is related to CR 329080 for earlier EAServer versions.

==========

DSN-less connects are not supported, the connection parameters need to be written to a dsn file. Also the length of the pathname may not be too long (up to 80-90 characters).

Examples:

SQLCA.DBParm = "ConnectString='FILEDSN=c:\test_asa.dsn;uid=dba;pwd=sql'"

install of Infomaker, you can still write changes to the database.

After installation, the Readonly property in the im.ini is set to 0. When you create

a query and preview it, if you make a change and then close out of the preview, you

are prompted to save changes back to the database. If you hit yes, the changes are

updated to the database.

From looking at the fop.bat,

java -cp build\fop.jar;lib\batik.jar;lib\xalan-2.3.1.jar;lib\xercesImpl-2.1.0.jar;lib\xml-apis.jar;lib\avalon-framework-cvs-20020315.jar;lib\logkit-1.0.jar;lib\jimi-1.0.jar org.apache.fop.apps.Fop %1 %2 %3 %4 %5 %6 %7 %8

When it should something like:

java -cp build/fop.jar:lib/batik.jar:lib/xalan-2.3.1.jar:lib/xercesImpl-2.0.1.jar:lib/xml-apis.jar:lib/avalon-framework-cvs-20020315.jar:lib/logkit-1.0.jar:lib/jimi-1.0.jar org.apache.fop.apps.Fop $*

building formatting object tree

[1]

fo:flow must contain block level children

at org.apache.fop.fo.flow.flow.layout (Unknown Source)

at org.apache.fop.fo.pagination.PageSequence.format(Unknown Source)

at org.apache.fop.apps.StreamRenderer.render (Unknown Source)

at org.apache.fop.fo.FOTreebuilder.endElement (Unknown Source)

.

.

at org.apache.fop.apps.Driver.render (Unknown Source)

at org.apache.fop.apps.CommandLineStarter.run (Unknown Source)

at org.apache.fop.apps.Fop.main (Unknown Source)

From Engineering: This is not a bug. The dddw filter is being applied to the dddw in the rowfocuschanged event of the main datawindow. What is happening in the case where they click on a row and select a value from the drop down and then tab off, is they are tabbing into the next row. This applies a different filter to the dddw and the value they picked for the previous row, has now been filtered out of the dddw. PB is doing what it always does when a data value does not have a match in a dddw, it displays the data value, so there are no leading zeros. You have to realize there is only one dddw, and it applies to the dddw column of all the rows on the main datawindow. So if you are filtering to be different for each row, be careful you don't eliminate vaues that are in use by other rows.

closing the remote connection makes the PDA run extremely slow.

Solution: Updated DBODBCx.DLL from iAnywhere

Fixed by the ASA crew - need a new DBODBCx.DLL

Change ported to 8.0.2 and 8.0.3, as well as all the 9.0.0 and later codelines.

what is available now for PB targets.

SELECT Coalesce((SELECT item_receipt_flag FROM item_table WHERE item_no

= :ls_itemno,(SELECT item_receipt_flag FROM item_table WHERE

trim(item_no) = trim(:ls_itemno))) FROM dummy;

From the Print Dialog box inturn, it provide a feature "pages per sheet" to merge mulitple

page into one sheet printout. The feature work fine with it is Win95/98 but fail on

Windows 2000

So this is a request that documentation explicitly mention that a null value passed in as a style string to the DataWindowSyntaxFromSql method results in the default datawindow style being used. This is unlike most other string arguments which would throw an ArgumentNullException.

"Microsoft VBScript runtime error Permission denied: 'InputBox' (0x800A0046) At line 24, character 4".

object le_t

le_t = this.typeof()

This contains the correct value at runtime (like a CHOOSE/CASE stmt) but the

debugger always displays ADOResultSet! (which is zero)

If you install Build 4016, for instance, you will find the following registry sub key has been installed

HKEY_CLASSES_ROOT\CLSID\{13B236BD-1AA9-4EA2-8ADB-0A12510C8CBE}\InprocServer32\10.0.4016.0

These types SHOULD be hidden from DW.NET though (as they are currently but via a different mechanism).

For the other classes of DW.NET we have provided ToString methods so that when you do a MsgBox(dw.ToString()) you get some information about the current instance of the class - like datawindow object and library list.

We should do the same for Transaction and AdoTransaction; HOWEVER, we should not display the userid and password in clear text, since that would be a security issue. The other DW.NET classes have a pattern for how to format the ToString output.

In the Object Browser of VS.NET you can see that we currently we have the following overloads:

GetItem (row#, col#)

GetItem (row#, colname)

GetItem (row#, col#, original)

GetItem (row#, colname, original)

GetItem (row#, col#, buffer, original)

GetItem (row#, colname, buffer, original)

and

GetItemSQLxxx (row#, col#, buffer, original)

GetItemSQLxxx (row#, colname, buffer, original)

So there is some inconsistency here both within the overrides of GetItem and between GetItemxxx and GetItemSQLxxx

1. Remove the two GetItemxxx(row, col, original) overloads, this reduces the number of overloads and eliminates the illogical progression where the original parameter is last the GetItemxxx(row, col, buffer, original) overload.

2. Add a GetItemSqlxx(row, col#) and GetItemSqlxx(row,colname) overload so that we have a consistent set of overload for all the GetItem methods.

1. Does SaveAsAscii save only in Ascii? If not, we need an encoding argument like for SaveAs. If so, then shouldn't there be a SaveAsUnicode method as well?

2. This would be better called SaveAsEx and then we could add an encoding argument and deprecate SaveAsAscii

Whatever choices are made in PowerBuilder should be carried through consistently to DataWindow .NET

the formatting leaves large spaces between words.

Simple resolution here, the C# layer should throw InvalidRowNumberException if the input argument is less than 0... N.B., 0 itself is a VALID value.

its missing from the datawindow after page 1.

The problem happens after you retrieve data and using getfullstate/setfullstate

It can also be seen on a psr report.

If you open the psr in the datawindow, its missing the nested report after page 1.

SaveAs methods all require FileSaveAsType argument, so ImportFile/String/Clipboard should as well. This would reduce the number of overloads of each of those functions from four to two.

Also, given that SaveAs now requires a FileEncoding, does Import need to specify that as well?

This would result in:

SetTransaction(Sybase.DataWindow.Transaction) and

SetTransaction(Sybase.DataWindow.AdoTransaction)

The method currently throws MethodFailureException if the datawindow source is not a SQL select statement, so end-user is aware that method has not completed successfully; however, most other methods throw System.NotSupportedException when the method does not apply to the DataWindow type.

2. Change Csv to CommaSeparatedText.

3. Change Text to TabSeparatedText

4. Change Pdf and Xml to PDF and XML respectively.

5. Change PSReport to PSR.

6. Change FileSaveAsEncoding should to FileEncoding.

7. Change the name of the enumeration to just FileType.

is displayed in the Add/Remove programs from the Control Panel.

SQLPreviewEventArgs class has no property corresponding to the return values allowed in PowerBuilder:

0 Continue processing

1 Stop processing

2 Skip this request and execute the next request

From looking at some other .NET class implementation, one option is to file a CommandCanceled event when the Retrieve is cancelled by any mechanism. That event can allow user to code what should happen when the retrieve is cancelled - if anything.

Datastore.Create method throws an exception if there is not already a DataWindowObject assigned.

a. the data should be left alone and not changed, since the method is doomed to failure and should not have this side-effect

b. the exception thrown should be System.InvalidOperationException

"If you have selected more than one table, PowerBuilder joins columns according to whether they have a key relationship: Columns with a primary/foreign key relationship are joined automatically. Columns with no key relationship are joined, if possible, based on common column names and types."

In 8.0.4 this seemed to be working as stated. But it appears to have regressed in 9.0.1. In this testcase there are 2 tables and there is a foreign key relationship consisting of 5 columns from one table to another. When selecting these 2 tables in PB 8.0.4, they are joined with a where clause that correctly reflects the foreign key relationship. But in 9.0.1 the where clause is a single column that is not part of the foreign key, but is another column that does have the same name and type in both tables. It appears that something has changed in 9.0.1.

components in EAServer.

the application level, the filemon utility is showing that the exe is still searching

for the icons.

The icons are being added dynamically from a dropdown picture listbox using

addpicture. When the executable is running, you can see the icons in the dropdown.

The above turned out to be an Oracle issue, as discovered by the customer. However it leaves a question about UpdateBlob and binding as noted:

"I found the problem, and it's a bug in the Oracle 9i OCI layer (see attached metalink note). On 9i, OCI is reporting the size of long (and long raw) columns as if they were VARCHAR2(4000). So PB is sizing the host variable too small, which is why you end up with a Error 2 code. I was able to finally track it down because I wrote a Java Stored Procedure to transfer the data and it worked fine on 8i but generated ORA-01406 errors when run on 9i. Basically, any tool (including PB and Java) that sizes it's host variables based on what the OCI layer tells it the size of the data is will have this problem. Those tools that don't rely on that information don't have the problem.

The remaining question is how to get PB to do a 'describeless retrieval' for the SelectBlob statement. Apparently the staticbind setting doesn't seem to affect that statement.

Oracle's Bug Document :

ftp://psaftp.sybase.com/pub/uploads/ecm/11027367_2553240.pdf "

ora-01740 error:

Missing double quote in identifier

Problem happens when calling Oracle stored procedure using synonyms and with the O84 driver.

The function PrintGetPrinter crashes when there are a large number of printers with possibly long names are defined.

in a pbl, the following error occurs:

Command syntax error at line 4. Found "w_test", expected "<word>"

endSession

parent window using the closewithreturn, causes the application to shut down immediately.

I was able to run the crash handler and not too much information was provided:

Exception code: C0000005 ACCESS_VIOLATION

File Name: unknown

File Version: unknown

Fault address=00000003 Section:Offset=00:00000000

Registers:

EAX:FFFFFFFF

EBX:0124C9DC

ECX:0012E464

EDX:0012E28C

ESI:00000001

EDI:0000029E

CS:EIP:001B:00000003

SS:ESP:0023:0012D5D0 EBP:00000003

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

Flags:00010286

Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

00000003 0012D5CC 00000010 00000000 00000000 00000010 0000:00000000

00150458 00000003 00000000 00000000 00000000 00000000 0000:00000000

Customer is searching for information on eliminating the overhead introduced by EAServer PB NVO componenets connecting to ODBC sources (ASA in particular) and the overhead that access to PBODB90.INI introduces.

Can we get information on the current mechanism and ways of reducing overhead?

The customer has not edited or removed any entries in the ini file.

Customer Resolution:

1) Eliminating the PBODB.INI file is not an option

2) The phrase "round trip every time" confuses me. Usually "round trip" refers to network communication between a client and a server. Both PBODBnn.DLL and PBODBnn.INI presumably reside on the same EAServer machine. There's no network communication involved to read the INI file, just some local file I/O.

3) ODBC connection caches the contents of the ODBC.INI file (that it needs) in memory. This reduces the number of file I/Os on the PBODBC.INI file from over 100 to less than 10, and cuts in half the amount of time needed to initiate an ODBC database connection.

We've also done a lot of work to cache the answers that require us to parse the INI file text. The first time a question is asked, we have to parse the INI file text in memory to obtain the answer. Subsequent requests require no file I/O and no parsing. The previous answer is cached for the duration of the database connection.

4) EAServer components should be using connection pooling. This will make the ODBC.INI file overhead negligible once the connections are established.

Specifically:

BackColor should cause a Modify("DataWindow.Color")

Cursor should affect the DataWindow.Pointer

RightToLeft is tougher because there is no RightToLeft property on the entire datawindow only on individual elements, so it's not clear what setting RightToLeft for the control should do, but whatever it is we should document what we consider the defined behavior.

Note that each of these properties has a 'Changed' event which also fires, so if we do implement these, the Events should also work correctly - although I suspect that will be obtained with no further coding on our part.

A couple of modifications needed:

1. SQLPreviewEventArgs should no longer extend System.CancelEventArgs, since the Cancel is built-in to a recently added Action property

2. Change SqlPreviewRequest to RequestingMethod, since it is really the DataWindow method itself, not anything really 'SQL'.

3. As a consequence of #2, change the enumeration name from SqlPreviewRequest to SqlPreviewMethod AND change the enum value Update to UpdateData

4. Change SqlPreviewType property name to SqlVerb (or SqlDmlVerb, but that might be too obtuse?). SqlVerb is much more clear as to what it indicates.

5. As a consequence of #4, change the enumeration name from SqlPreviewType to SqlVerb

EndRetrieveEventArgs: change RowsRetrieved to RowCount. Rationale: the property contains the number of rows now in the datawindow, including previously retrieved rows if the append option in RetrieveStart was activated; therefore, it's not the number of rows truly retrieved, its the number of rows in the datawindow when the associated retrieve action completed.

RowFocusChangedEventArgs: change CurrentRowNumber to just RowNumber. Rationale: 'Current' is superfluous since there is no other row number argument in this class. Additionally, the name is also used in RowFocusChangingEventArgs and can lead to confusion and programming errors, especially since the value of 'CurrentRowNumber' in RowFocusChanged is really the same as 'NewRowNumber' in RowFocusChanging and not 'CurrentRowNumber' in RowFocusChanging, which is actually the previously selected row.

RowRetrievedEventArgs: change RowNumberBeingRetrieved to just RowNumber. Rationale: too wordy and not in line with other events. Additionally, it's actually the row that has just completed being retrieved not the one 'being retrieved' - which implies you could cancel the retrieve for the row whose number is stored by that property.

ScrollHorizontal/ScrollVerticalEventArgs: change ScrollPos to ScrollPosition. Rationale: no need to abbreviate here, spell it out as is the style everywhere else in DW.NET.

workaround: Export, modify and re-import the dw object.

This does not happen with controls on a window, only for the DataWindow.

Failed: Distributed Service Error:

E13 Could not create object of class

In the Jaguar.log is shows the following error:

ld.so.1 jagsrv: fatal: libpthread.so.1: version 'SUNW_1.2' not found (required by

file libipbvm90x.so)

Problem appears to be that PB 8.0.4 and higher were built using version 6 of

the Sun C++ compiler on solaris 8. Even though easerver 4.2.2 is supported on solaris 2.6 and 2.8, the pbvm doesn't appear to work on solaris 2.6 machine.

RESOLUTION: Updated EAServer Release Bulletin on Solaris:

On Solaris, the EAServer binaries and libraries are provided in formats that are compatible with the Solaris C/C++ compiler version 4.x or 6.x. You can specify which version to use with the -compilerversion command-line argument. PowerBuilder support requires that you run the server binary that is compatible with version 6.x of the Solaris C/C++ compiler. For more information, see the EAServer System Administration Guide.

Tested and reproduced with 9.0.1_7151 and 9.0.1_7161

Since this is not available, we have to implement *everything* using external function calls rather than the scanner object.

pb will sort in ascending order instead.

Works ok using D, or A or ASC.

The underlying implementation is a separate control; however, from the DW.NET developers perspective the DataWindowControl (including the Edit Control) is a single control, so these events should not be firing.

When the tilde is used in a string editmask definition then data entered

may give a validation error or corrupted when tabbing out of the column.

has a datetime field, the following error will result:

Item '01/01/1950 00:00:00' does not pass validation test

Item validation error on IMPORT. Continue IMPORT?

PB will then crash. The problem cust is now facing is that if he clicked on a

previous entry form the call stack, and do some hovering. Then proceed to finish the

debugging process. PB will crash every time.

The pbvm100.dll has a dependency on libjcc.dll and pbshr100.dll. The libjcc.dll has a dependency on libjlog.dll.

The libjlog is the new logging facility in EAServer 5.0.

The libjcc.dll is required for EAServer applications. With the introduction of

EAServer 5.0, libjcc.dll now has a dependency on libjlog.dll. For applications that

are not using EAServer, its 2 extra files that are required for deployment.

In EAServer 5.1, the libjlog.dll will be replaced by libutils.dll. The dependency

to libjcc.dll will still be their.

The error you get a run time is "Error accessing external object property dataobject, incorrect syntax. But we know the syntax is correct because the same syntax works with a datawindow object.

This CR is an enhancement request to PB so that the correct exception can be thrown and caught in DW.NET.

GetColumnObjectByNumber method throws ArgumentException when column number > column count, but InvalidColumnNumberException when column number < 1. It should throw InvalidColumnNumberException in both cases.

We have GetColumnName, GetObjectByName, GetColumnObjectByNumber, and GetColumn. The latter is ambiguous given the various ways we can identify a column, so change it to GetColumnNumber.

We have FindRow, FindNextModifiedRow, and FindRequired (see CR 355738 advocating that be called FindNextRequiredColumn), and GetSelectedRow, so let's be consistent and call it FindNextSelectedRow.

1. FindRequired should be renamed FindNextRequiredColumn to make it similar to FindNextModifiedRow and FindRow

2. Reorder the arguments to RowNumber, ColumnNumber, Buffer, UpdateOnly to make it consistent with Get/SetItem methods. Note, ColumnName is removed and can be obtained by other means.

3. Remove test for System.NotSupportedException when crosstab or composite. The Find will fail as it will for other styles where there is not required column.

The current implementation for Create is as follows:

if ( Syntax == null )

throw new ArgumentNullException ( "Syntax", "Create specified NULL for Syntax." );

if ( Syntax == String.Empty )

throw new InvalidArgumentException ( "Create", String.Empty, "Syntax" );

theDW = SF.Create ( Syntax, ref Error );

if( theDW != IntPtr.Zero )

{

SHR.SetLibraries(theDW, m_LibraryList);

RecreateDataStore(theDW);

}

else

{

throw new MethodFailureException ( "Create", Error );

}

return;

we can eliminate the test for if ( Syntax == String.Empty ) altogether and just let SF.Create take care of it as it would for any other invalid syntax. This simplifies the TRY/CATCH scenarios the DW.NET developer must handle.

The Import methods should have some type of callback mechanism to allow the user to cancel or continue via their own constructs (in both a DataWindow and DataStore) and not just throw up a message box. It's better to restrict behavior for the 'new' product and introduce this capability later than struggle to maintain backward compatibility.

[red]Dept: ### causes the words [red] to appear in the datawindow display.

[red]Name: @@@@ (a string format) works however.

This is a documentation issue though, because engineering is aware of the problems with using literals in numeric formats. Documentation should recommend that literals within numeric masks be escaped. For instance:

[red]\D\e\p\t\: ### works as we'd want it to.

It seems as though the large inherited menu has hit some internal PowerBuilder limit, as a workaround you could delete some submenu items from the parent menu and regenerate the inherited menu and you are able to delete the sae submenu items without PB crashing.

Note: If you delete any items from the parent menu, you will run into CR 234995. As a result of CR 234995, you have to manually edit the source code on the inherited menu to delete the same menu items that you have deleted from the parent object before you can regenerate the inherited menu.

SetRowFocusIndicator should likewise apply the Location argument in whatever units the underlying DataWindow utilizes. This may necessitate not using a Location type since that implies pixels and use instead an xoffset and yoffset argument.

For consistency with other DW.NET methods that accept a row number argument, the argument should be checked for < 0 and > rowcount and throw InvalidRowNumberException.

ItemChangedAction has:

Accept

RejectAndAllowFocusChange

RejectWithoutFocusChange

ItemErrorAction has:

Accept

Reject

RejectAndAllowFocusChange

RejectWithNoMessage

ItemErrorAction is the tricky one because the focus change and the appearance of the validation message coud be independent events. RejectWithNoMessage, implies no focus change in that case.

My recommendation is that ItemErrorAction RejectWithoutFocusChange just be a plain Reject, so that ItemChangedEvent args becomes a superset of ItemErrorEvent args, making documentation and usage more clear.

rowheight() -4.

Thus at run time a blue line appears above each row of text and a red line appears below each row of text. This was working fine and would print preview and print correctly. (It should be noted that the original problem fixed in CR 342984 was evident here, that is after the print, the size of each row increased significantly in the print preview, but that was not a concern to this customer.)

Now after the fix for CR 342984, the print preview is still OK, but the red line is not visible when printed, and it's clear that the rowheight is much larger than it was when it was working correctly and is causing the redline to be too far down. Part of the fix for CR 342984 requires that any object that uses rowheight() in it's own height should start the y values at 0 in the painter. In this case nothing is using rowheight() to change the height of itself, but the red line is using rowheight() for it's y values. Unfortunately, the setting of the initial y values to 0 does not help the problem.

The root of the problem is that GraphicObjectTableBlob does not extend GraphicObjectColumn or perhaps a new class is needed for the object that represent the blob on the datawindow, which may be different from GraphicObjectTableBlob that references the underlying database table information. A GraphicObjectBlobColumn should extendGraphicObjectColumn and then perhaps include a GraphicObjectTableBlob as one of its own properties.

OleActivate throws the same exception, InvalidColumnException, if the column name/number is not valid OR if the column is not an OLE blob column (but the column name/number is valid). These need to be differentiated. The underlying problem is really that one DWE return code is used for both cases, so we should make additional tests in the C# layer with the result that:

1. a column number or name that does not exists throws InvalidColumnException

2. a column that exists but is not a BLOB causes InvalidOperationException

Several of developers require the ability to rebuild projects without having to actually connect to the SCC provider.

This will be accomplished by exposing a new ORCA function, PBORCA_SccConnectOffline. In Orcascript it will be "scc connect offline". When you connect with PBORCA_SccConnectOffline, you must specify IMPORTONLY as a refresh option. Either OUTOFDATE or REFRESH_ALL may be specified. If OUTOFDATE is specified, no calls are made to the SCC provider. Instead, the object source residing in the PBL is compared with the object source on the local project path. If they are different, then the object source on the local project path is imported and compiled. EXCLUDE_CHECKOUT may also be specified. In offline mode, rather than calling the SCC provider to obtain checkout status, Orca relies on the accuracy of the workspace .PBC file instead. Therefore, the user must code PBORCA_SccGetConnectProperties in order to specify the "workspace.PBC" file that will be used. Objects marked as "checked out to the current user" in the PBC file will not be imported into the PBLs during SccRefreshTarget processing.

Null values in structures are no longer passed between EAServer components and clients.

The ObjectUnderMouse property after clicking on a nested report in a datawindow reports that the object is the DataWindow background for all nested reports associated with detail rows after the first row.

This is another consistency issue. In GetCategoryNumber we throw MethodFailureException when the category name is invalid; however, in GetCategoryName we throw ArgumentOutOfRangeException if the category number is not valid. We should throw ArgumentException for GetCategoryNumber instead of MethodFailureException. This is a simple modification, but there are three overrides in which this should occur.

In DW.NET, we are using the InvalidOperationException when a method is called on an object that is generally allowed, but not currently because of the state of that object. One example of that would be when using the GetObjectByName and GetColumnObjectByNumber methods applied to a column that exists but is NOT included in the DataWindow layout. Currently, we get two different exceptions:

GetObjectByName throws an ArgumentException

GetColumnObjectByNumber throws a InvalidColumnNumberException

both of these exceptions may be puzzling because they are also thrown when the column simply doesn't exist.

the "Installing PowerBuilder stored procedure in Adaptive Server Enterprise" section in Chapter 5 of the Connecting to your Database manual:

sp_pb90primarykey

sp_pb90foreignkey

sp_pb90extcat

sp_pb90db

The reason is these stored procedures are not listed in the pbsyc.sql and don't get created.

Per engineering, there is no way in the Get/SetDataStyle methods for a graph object in a datawindow, to determine if a given point number exists or does not exist. As a result of this, we cannot test for a valid point and throw an exception that indicates that. Instead, we have to charge forward and try to get the various properties for the point, like color, symbol style, etc. Each of those methods will fail so we will get a MethodFailureException as an overall result; however, for consistency in the DW.NET methods, we should be getting an ArgumentException for the illegal point value.

1. FillPattern constant values do not match with results. I suspect this is a bug introduced by the fix to CR 355411. In that fix, the constants values were changed to reflect the datawindow property for brush; however, those 'new' values must also be mapped internally to the other set of constants defined for the FillStyle enumeration type in PowerBuilder. We want to use the datawindow constants here because other objects like shapes will also make use of the FillStyle enumeration constant in .NET.

2. LineStyle doesn't seem affected at all when the property is changed. This may be a result of a 'fix' just like the one to FillPattern - that CR is 355413.

3. When changing SymbolStyle, you see the symbol flash to the desired style and then it gets immediately reset. This is 'new' behavior and there were no previous CRs like the above that should have affected it.

In the sample app, in the menu m_help, I have coded the Help event of the top level menu item 搈_help1� and the sub-menu item 搈_show_help_file�. It should display a help file in each case. When you run the sample and move the mouse over the 揌elp� menu item until it is selected and press f1, nothing happens. But when you click the Help menu and move the mouse over the submenu item 搒how_help_file� and press f1, the code in the Help() event fires and displays a help file.

the following error appears:

Error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

ORA-06512: at "TECHSUPP.XXXXXX", line 6

ORA-06512: at line 1

Orca error in 'setLibList'. Result Code -4.

Library 'orcascript.pbl' failed to open

An OpenLibrary() operation failed. It is possibly locked by another user or

deleted.

The display format is:

$#,##0.00;[RED]($#,##0.00)

The field called "balance" is showing the Display Format ok. The column value is appearing in red but not the computed field called "compute_1". It still shows the

column value in black.

When viewing the datawindow in a browser, the following appears:

dwClient.gobs.compute_1 = new HTDW_ComputeGob('compute_1', 0, dwClient_compute_1_compute, DW_FormatNumber, "$#,##0.00;[RED]($#,##0.00)");

dwClient.cols[3].addDepend(new HTDW_DependCompute(dwClient.gobs.compute_1));

dwClient.gobs.balance = new HTDW_ColumnGob('balance',3, 0, 0, false, false, true, DW_FormatNumber, "$#,##0.00;[RED]($#,##0.00)", null, dwClient.cols[3]);

dwClient.cols[3].addDepend(new HTDW_DependColumn(dwClient.gobs.balance));

Workaround:

don't move the 90 degrees rotated text object over the label border or the page border. Add some line breakes (~r~n) before text you like to show at the left side of label border or the page border. The line brakes move the rotated text to the left.

In this function the YIELD() function is called. If scrolling the datawindow after a retrieve a GPF is caused.

No workaround

Solution: Duplicate of CR 355015 fixed with build 7196 of PB9

web service proxy wizard and you enter in the url of the wsdl, no services

will appear.

If you use XMLSpy (2004 version) and enter in the url of the wsdl, it will find

the two services (activate and download) ok.

However, when I used XMLSpy (2003 version) I received a schema error after I entered

in the url of the wsdl. Once I ran XML/validate on the file, I received the following error:

Schema error - undefined value for 'type' encountered.

The following was highlighted:

xsd:element

= name xtvdDocument

= type tms:xtvd

filter feature. It is reported that after apply simple arithmetic operation as setfilter,

the datawindow may fail to filter some expected row.

e.g. dw_1.setfilter("col1 = col2 + col3") where col1, col2, col3 are decimal(2)

In previous versions of PB a mask containing special characters was marked by tilde character before the (preceeding) special character eg. ~S####~/####

will result in a display of: S1234/5678 - when doing an accepttext() now gives:

S234 /78 and in the buffer is: 234/78 whereas it should be 12345678

Solution: Dup of 357310 - solved in PB 9 build 7196

editmask or window editmask control, PB will default to JAN.

For example, the editmask is DD-MMM-YYYY and if you enter in

12-B

PowerBuilder will default to 12-JAN.

For example:

PocketBuilder -> PowerBuilder

"DataWindow Error: Line 14 Column 263: incorrect syntax".

Line 14 Column 263 is referring to the source line: "edit.siponfocus=yes".

This fix filters out the "SIPOnFocus" property in DataWindows when exporting to PB.

Similiarly, this fix filters out PowerBuilder 9 & 10 specific attributes when both importing the SRD and importing an entire Target.

you select a pbl (either absolute or relative), after the web datawindow is created

and you select the web datawindow DTC properties you will see an invalid path

for the Datawindow library.

It will show:

D:\web examples\Target1\SourceD:/web examples/Target1/Source/testdtc.pbl

If you change any properties of the DTC after the web datawindow is created, the

PSDataWindowSourceClass will be updated with this invalid path.

PER DEVELOPMENT: The customer's syntax in the JSP required a change. Specifics were dependent on the SQL for the datawindow source. In some cases it might not always work and instead a change might be required for the SQL. Solution is fairly involved and depends upon the specific implementation, but did not turn out to be a PowerBuilder change.

Found the following when searching on google:

http://forums.viaarena.com/messageview.cfm?catid=13&threadid=52978&STARTPAGE=1

The customer has the same version of ntdll.dll (1217) loading on his machine so wondering if that could be a problem??

into a datastore.

Happens in PB 9.0.1 and PB 10.

string s = '<?xml version="1.0" encoding="UTF-8" standalone="no"?><d_emp><d_emp_row><emp_id>102</emp_id><manager_id>501</manager_id><emp_fname>Fran</emp_fname><emp_lname>Whitney</emp_lname><dept_id>100</dept_id><street>49 East Washington Street</street><city>boston</city><state>MA</state></d_emp_row></d_emp>'

integer i

ds.reset()

for i = 1 to Integer(em_iter.text)

ds.ImportString(XML!,s)

next

no workaround

is set to 0 for a freeform datawindow, easerver takes up an unusual amount of cpu

usage and memory to return the page in the browser.

Problem is noticeable using Generatexhtmlweb also. If you call up the same

datawindow just using generateweb(), the page returns quickly and cpu usage is not

thru the roof.

SOLUTION: Input characters by Alt + numeric keyboard is a problem with Windows and is not a PowerBuilder bug. Visual Studio 2003/2005 also have the same problem.

If you use Alt + xxxx to enter a unicode character, only three digit are available in most applications(except for Wordpad and Word). For example, when you enter 8322 on numeric keyboard, actually the Windows system only sends 322 to the application which should receive the character.

return value is always mailreturnfailure!. When using the maillogoff to logoff

from the mail system, the return value is always mailreturnfailure!. The maillogon

works ok.

the application appears to be slower in PB 9.0.1 than in PB 6.5.1.

Used the profiler to examine the difference:

uo_screen_meter_column`dw_screen_meter_column.ue_keydown() - PB6.5.1=0.0086/PB9.0.1=0.0007

uo_screen_meter_column.ue_next() - PB 6.5.1=0.1039/PB 9.0.1=0.1371

The application has two datawindow controls. The top control sets print.preview='yes'

and then dw_1.print(). The botton dw control has the composite report. The report

is printed just by dw_1.print(). When you print both reports, the composite report printout shows that the rightmost column gets cut off wherewas the printout from the top

dw control, prints ok.

no workaround

PB10 build 4506 works fine so a backpatch would be required.

Thus, i would like to request for a resizable dialogbox or any other solution to allow users to see the full path of the target which cannot be opened. This will aid them to pinpoint which target has a problem.

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

is set to 3, the following messagebox appears and processing appears to stop until you

hit ok in the messagebox:

ClearCase

Unable to access "m:\testscc.txt": No such file or directory.

SetProperty causes a MethodFailureException if the property value expression is not enclosed in single quotes. For instance,

DataWindowControl1.SetProperty("t_1.color", "0~tRGB(255,0,0)") causes an exception, but

DataWindowControl1.SetProperty("t_1.color", "'0~tRGB(255,0,0)'") does not.

Passing an array or structure with an array between a PowerBuilder

component and the asp page gives an error in the asp page:

HTTP 500.100 - Internal Server Error - ASP error

Internet Information Services

Microsoft VBScript runtime (0x800A01FB)

An exception occurred: 'obj.getstruct'

/CallComp.asp, line 10

Now the PBVM memory is growing constantly until it eats all resources and they have to bring EAS down every few hours.

5,994 characters, the following error will appear in the log file:

(113365fc): CONNECT TO tra O90 ORACLE8/8I (8.X.4+):

(113365fc): DBPARM=UseContextObject='Yes',CacheName='Oracle817',StaticBind=0,PBCatalogOwner='tsdata',BindSPInput='Yes' (0 MilliSeconds)

(113365fc): PREPARE WITH BIND VARIABLES:

(113365fc): Execute CHG_PERMANENCY_NARRATIVE ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31)

(113365fc): VCHAR Length=0 ID=:1 (NULL)

(113365fc): VCHAR Length=0 ID=:2 (NULL)

(113365fc): VCHAR Length=0 ID=:3 (NULL)

(113365fc): VCHAR Length=0 ID=:4 (NULL)

(113365fc): VCHAR Length=0 ID=:5 (NULL)

(113365fc): VCHAR Length=0 ID=:6 (NULL)

(113365fc): VCHAR Length=0 ID=:7 (NULL)

(113365fc): VCHAR Length=4000 ID=:8 *This is a Test ' jrorehwr"" ueoreuor : erueru ''' This is a Test ' jrorehwr"" ueoreuor : erueru ''' This is a Test ' jrorehwr"" ueoreuor : erueru ''' This is a Test ' jrorehwr"" ueoreuor : erueru ''' This is a Test ' jrorehwr"" ueoreuor : erueru ''' This is a Test ' jrorehwr"" ueoreuor : erueru ''' This is a Test '

.

.

.

sssssssssssssfffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffsssssssssssssssssssssssssssss

*

(113365fc): VCHAR Length=0 ID=:10 (NULL)

(113365fc): VCHAR Length=0 ID=:11 (NULL)

(113365fc): VCHAR Length=0 ID=:12 (NULL)

(113365fc): VCHAR Length=0 ID=:13 (NULL)

(113365fc): VCHAR Length=0 ID=:14 (NULL)

(113365fc): VCHAR Length=0 ID=:15 (NULL)

(113365fc): VCHAR Length=0 ID=:16 (NULL)

(113365fc): VCHAR Length=0 ID=:17 (NULL)

(113365fc): VCHAR Length=0 ID=:18 (NULL)

(113365fc): VCHAR Length=0 ID=:19 (NULL)

(113365fc): VCHAR Length=0 ID=:20 (NULL)

(113365fc): VCHAR Length=0 ID=:21 (NULL)

(113365fc): VCHAR Length=0 ID=:22 (NULL)

(113365fc): VCHAR Length=0 ID=:23 (NULL)

(113365fc): VCHAR Length=0 ID=:24 (NULL)

(113365fc): VCHAR Length=0 ID=:25 (NULL)

(113365fc): VCHAR Length=0 ID=:26 (NULL)

(113365fc): VCHAR Length=0 ID=:27 (NULL)

(113365fc): VCHAR Length=0 ID=:28 (NULL)

(113365fc): VCHAR Length=0 ID=:29 (NULL)

(113365fc): VCHAR Length=0 ID=:30 (NULL)

(113365fc): VCHAR Length=7 ID=:31 *EI08120* (10 MilliSeconds)

.

.

.

(113365fc): DESCRIBE SELECT: (0 MilliSeconds)

(113365fc): 1 Bind Columns

(113365fc): CHAR Length=45

(113365fc): EXECUTE: (2633 MilliSeconds)

(113365fc):

Error 3113 (rc -1) : ORA-03113: end-of-file on communication channel

(113365fc): CANCEL: (0 MilliSeconds)

Customer is using the BindSPInput='Yes' dbparm. However, when I ran a test

and set the BindSPInput='No', the pbtrace.log showed the following error too:

ORA-24333: zero iteration count

Also, the EntryInfo.lSourceSize returned for PBORCA_BINARY components is not sufficient for exporting the hexascii source.

For PB9 users, do not use relative path specification starting with ".\" to indicate "current working directory". Simply omit the ".\" and it will work OK.

In PB9, the best way to calculate the size of PBORCA_BINARY buffer needed is to call PBORCA_LibraryEntryInformation with otEntryType=PBORCA_BINARY. (EntryInfo.lObjectSize + 5000) will always be sufficient for PB9 PBORCA_BINARY objects. lObjectSize takes into account the fact that hexascii representation is 2X as many bytes as the actual binary object. lSourceSize does not. The 5000 fudge factor is for padding the last 4000 byte data record with binary zeros and taking into account the size of the limit records.

In PB10 and PocketBuilder 2.0, we return the same value in both lSourceSize and lObjectSize. This value represents the number of bytes needed to represent the hexascii representation of the binary object using UNICODE encoding. This size also includes the extra bytes needed to pad the final 4000 byte data record and includes bytes needed for the header and footer limit records.

When the dw are db source (not external) the effect is different, the data whifts to the right hand side.

MDI window calls open(w_child) in open event but no child window is shown up.

workaround: use BringToTop=TRUE in the open event of the child window

Doing a dw.groupcalc() prior to the Describe("DataWindow.Data.HTML") does cause the correct calculation to be in the html.

lots of access violation errors. The errors are happenning randomly. Using Windows

NT Terminal Server 4.1.9. Works ok on regular windows machine.

Workaround: Use interfacing with the he rte control via windows messages.

If you already have the product installed, you will get the warning from the installer that you need to un-install the previous version first. Great, but when you attempt to cancel the install, it only cancels that portion of the install. That is, if you cancel the install of DataWindow.Net, the installer will still proceed to try to install DataWindow Designer and the DataWindow Reference. And since those products are also already installed, you will get the error messages for those products as well. There should be an option to exit out of the install completely if an error occurs, not just that portion of a mulit-product install.

With an editmask containing a thousands separator, then deleting digits may make

the pointer move to the wrong position when also the thousands separator is deleted.

For example an edit mask '###,###,###,###.00' having the value '2.850.000,00'

If you put the pointer between the '8' and the '5' and press the delete (or backspace) button then

the '8' is deleted and the pointer moves behind the 5 instead of staying before it.

The behavior in PowerBuilder 8 and 9 may be slightly different.

PB to crash.

Works ok when generating a pcode exe. Customer provided a user dump file. It appears

the crash is happending in pbcmp90!initializeArguments

pbcmp90!initializeArguments+74 [cmgenrou.cpp @ 2032]

1094e4d4 8a448110 mov al,[ecx+eax*4+0x10]

Using windbg and using ln produced the following results:

> ln 1094e4d4

(1094e460) pbcmp90!initializeArguments+0x74 | (1094e590) pbcmp90!initializeLocalVariables

> ln 1094e590

(1094e590) pbcmp90!initializeLocalVariables | (1094e7f0) pbcmp90!generateLocalInitialValues

Exact matches:

pbcmp90!initializeLocalVariables (cm_generation_state*)

> ln 1094e7f0

(1094e7f0) pbcmp90!generateLocalInitialValues | (1094ee10) pbcmp90!generateLocalArrayInitialValues

Exact matches:

pbcmp90!generateLocalInitialValues (cm_generation_state*, char*, ob_data*)

> ln 1094ee10

(1094ee10) pbcmp90!generateLocalArrayInitialValues | (1094ef60) pbcmp90!generateInitializedLocalArray

Exact matches:

pbcmp90!generateLocalArrayInitialValues (cm_generation_state*, char*, ob_data*, ob_arraydef*)

> ln 1094ef60

(1094ef60) pbcmp90!generateInitializedLocalArray | (1094f130) pbcmp90!initializeTempLocalVariables

Exact matches:

pbcmp90!generateInitializedLocalArray (cm_generation_state*, char*, ob_data*, ob_arraydef*)

generated.

When you use importstring(ls_xml) it produces a datawindow error. That appears to

be covered under cr348035. The reason for this cr is when no saveas type is specified,

the xml trace is not generated.

For example:

string ls_xml

integer ii_rc

dw_1.Modify("DataWindow.Import.XML.Trace = 'yes'")

dw_1.Modify("DataWindow.Import.XML.TraceFile = 'd:\xmltrace.log'")

ls_xml "some xml"

dw_1.importstring(ls_xml) // does not generate a xml trace and produces error

// covered under cr348035

dw_1.importstring(XML!,ls_xml) // works ok

RESOLUTION: When you want to generate a xml trace file with importstring, you must specify the import type. For example, use dw_1.importstring(XML!, ls_xml) instead of

dw_1.import(ls_xml).

the LeadTools Common Dialog ocx and the previewenabled=true is set at runtime for

the ocx. The access violation happens when halt() is used to close the application.

The following access violation occurs:

Exception code: C0000005 ACCESS_VIOLATION

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

File Version: 9.0.1.7216

Fault address=10B1B736 Section:Offset=01:0001A736

Registers:

EAX:096068F8

EBX:0012EB40

ECX:0012EB08

EDX:10DCC550

ESI:01264124

EDI:00000000

CS:EIP:001B:10B1B736

SS:ESP:0023:0012EA98 EBP:0012EB18

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

Flags:00010202

Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

10B1B736 0012EB18 01264124 00000001 01264124 0124FA0C PBROI_OLEIPSubClass+1AF6

10B2EC46 0012EB2C 00000001 00000000 01264124 00000000 PBROI_StreamsysGetName+12256

10B16579 0012EB40 01264124 00000000 0124FA0C 0134D530 PBROI_ControlRunHelp+3B9

10B1652C 0012EB54 01264124 10C03E8A 01264124 0134D530 PBROI_ControlRunHelp+36C

10B14095 0012EB5C 01264124 0134D530 10C02B59 0124FA0C PBROI_ControlDestroy+15

10C03E8A 0012EB68 0124FA0C 0134D530 10BE754B 0124FA0C FN_StaticTextNCPaint+157A

10C02B59 0012EB74 0124FA0C 0134D530 0124FA0C 0134D530 FN_StaticTextNCPaint+249

10BE754B 0012EB8C 0124FA0C 0134D530 0134D530 0124FA0C FN_FieldGetWN+9B

10BE3818 0012EBA0 0124FA0C 0134D530 0027062E 00000000 FN_CtlFree+18

10C45F8A 0012EBBC 01250434 0027062E 00000000 00000000 fn_txnservice_create_instance+2FDA

10C19609 0027062E 00000000 00000000 00000000 00000000 FN_WndProc+42F

All properties/functions related to Arabic are only applicable to PB, not PocketPB.

the datawindow painter and then put it in SQL Syntax mode.

You shouldn't have to go thru all those steps. It should be available as part of the

datawindow properties in the system tree.

The problem also appears to be happenning on a datawindow when a column border

is set to Lowered.

RESOLUTION: To revert to the windows 2000 style in the IDE, from the Control Panel/Appearances and Themes, change to Windows Classics. To revert to windows 2000 style

for an application executable, uncheck the 'New Visual Style Controls' in the project painter.

When SetPostion is called on an object in a Label DataWindow, SetPositon returns 1, but no change is visually apparent in the DataWindow.

an access violation error. The access violation appears to be happenning in:

PBVM80!rtdb_trans_pool_login

Using Windows NT Terminal Server 4.1.9. Works ok on regular windows machine.

of Find() will return 0 on a RichText Control.

When DisplayOnly is set to False, than Find will return the number of characters found.

HKCU/Software/Sybase/PowerBuilder/10.0/appname/MobiLink/Current Object Build

Instead it is setting the value to 1 more than PocketBuilder registry key.

HKCU/Software/Sybase/Pocket PowerBuilder/1.5u/appname/MobiLink/Current Object Build.

Just ignore the value displayed by the dialog. Set it yourself to 1 more than last time.

This is similar to CR 336645 witch was only fixed for PB9 and PB10.

Editmasks of type #0.00 ##0.00 ###0.00

0.00 do not enter digits properly when selecting the fields.

In an editmaks "#0.00" entering 8 results into 80.00 instead of 8.00

possible workaround:

use ,##0.00 mask

you specify a Web Service service name and leave the WebApplication blank, after

you complete the wizard the service name will appear in the WebApplication property and

the service name property is blank.

try to select the project, it doesn't show up in the IDE.

You create the project from the Add to Source Control, click on Create Project. The

next time you connect to PVCS and browse for that project it won't be there. Problem

appears to be machine specific. It appears that the registry entry is being deleted

once you disconnect from PVCS (by selecting (None) from the Source Control System).

/ulnone

/ul0

The problem is that it refuses to set a greek/turkish default font for the RTE control.

The text stays at Times New Roman.

The problem can be worked around by increasing the height of the fields. Unfortunately this is not an option for this customer.

dddw column and that column is null, scrolling the dddw and then scrolling back

to the null value results in the following error:

Microsoft Internet Explorer

Item "Does not pass validation test."

The error doesn't go away once you hit ok. The validation error is in a loop.

The function definition for the column is:

function HTDW_ColumnGob(name, colNum, rowInDetail, region, bRequired, bNilIsNull, bFocusRect, formatFunc, getDisplayFormatFunc, getEditFormatFunc, column)

When you view the source of the html, the bNilIsNull should be set to true but shows

false whether Empty String Is Null is set to True or False.

webDW.gobs.manager_id = new HTDW_ColumnGob('manager_id',4, 0, 0, false, false, false, null, null, null, webDW.cols[4]);

If you set any other column to true, that column (bNilIsNull) will show up as true

in the html source.

on a datawindow, when the process is repeated PB crash if you click on the format

expression when the icon is red.

The format expression should be green, but when repeatedly accessing the format expression, the icon will eventually be red. When it is, and you click on it, PB will crash.

The crash handler shows that the crash happened in the pbdev90.dll:

Exception code: C0000005 ACCESS_VIOLATION

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

File Version: 9.0.1.7236

Fault address=00321AC0 Section:Offset=01:00040AC0

Registers:

EAX:00000000

EBX:00000000

ECX:0012F938

EDX:10DCDDE0

ESI:0129ADA8

EDI:80004005

CS:EIP:001B:00321AC0

SS:ESP:0023:0012F914 EBP:0127A0E6

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

Flags:00010202

Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

00321AC0 0012FA40 002EFBE9 0127A0E6 0129ADA8 00190576 pbdv_template_object_copy+2730

002EFBD5 0012FA58 0127A290 0129ADA8 0012FABC 012A9764 PB_CreatePropertyList+1735

003007EA 0012FA6C 00190576 00190576 00000111 002F3174 PB_CreatePropertyList+1234A

0030077E 0012FA7C 012A9768 00190576 00000111 00000000 PB_CreatePropertyList+122DE

002F3174 0012FAA8 0125C3A4 00000111 012A9768 00000000 PB_CreatePropertyList+4CD4

00338AFF 0012FAD0 00210672 00000111 00000000 00190576 CreatePBIBuildServices+88F

77E11EF0 00687900 E47BC228 8114A358 A03E7900 20080000 0001:00000EF0 C:\WINNT\system32\USER32.dll

PER DEVELOPMENT:

The customer got the right display effect for grid datawindow. A grid datawindow has grid line ,which displays around the field, especially when the fields are defined to use Lowered borders. As a result the right grid line is close to the right border line. The visual effect looks like a double box around the field and the borders show up.

Customers can set the fields to no border when using Grid data window.

Workaround: use a static datawindow if possible.

It is related to the split scroll, because if you eliminate that, the retrieve times become fast again. And it is related to the retrieverow event, if you eliminate that code (and keep splitscroll), the retrieves are also fast again.

Example:

If on the Original Retrieve, column X row Y has a Null Value. This Column is a type DDDW. The Original DDDW will have the values Selected from the List and an extra OPTION VALUE="".

When a Value is selected from the List, other than the NULL(Or empty string) and the Database is Updated the Extra OPTION VALUE="" is lo longer in the DDDW Select in the HTML

The Allow Updating Datawindow Property has no affect on the DDDW column in an HTML Datawindow.

Workaround: use .Net engine

Not clear whether this is a migration problem, or whether the Online Help needs additional clarification.

When migrating a complete workspace they will show up.

in PVCS and then the application is migrated from PB 8.0.4 to PB 9.0.1, the application will show that its not registered in source control. It shows a plus sign next to the objects in PB 9.0.1 instead of the green dot. If the PB 9.0.1 app is opened and closed many (15) times, some of the objects will show a green dot and others will show a plus sign (as reported in subcase.)

If you use a smaller application like the template application, this problem doesn't happen. In PB 9.0.1, you will see a green dot next to all the objects.

RESOLUTION: If you open the library painter and click on a pbl within the target, you

will see a hour glass and "Initialization ..." in the title of the library painter. Once

the initialization process is complete, the application will show that its registered in PVCS. You must click on each pbl within the target and wait until the initialization process is completed.

This only seem to happen on a Printek driver. Seems not to happen with Postscript printers.

Comment out the call that passes the ds reference readonly, and the ds retrieves successfully multiple times.

This is not a bug. Passing a ds reference by readonly is the same as passing by reference really. The reference itself is protected but it never changes and can still be used to access and change the datastore. In this case they were applying a filter that remains in the ds and filters out all the rows on subsequent retrieves...

Information C0207: Append ALIAS FOR clause to external function '...' for back compatibility.

It is resetted to default zero by the painter.

the monthcalendar control when you use the mouse to click on different date. The datechange event does fire. The messagebox returns -1 when you use the mouse to

change the date on the monthcalendar control.

The messagebox does fire ok when you use the up,down,right and left arrow.

A workaround: In the second child window open event put:

this.bringtotop = true

Workaround: Use datawindow without a saved template

save the data to the file. It does work if the Excel! format is used.

This particular datawindow is an external dw. But if you create one from scratch

it worked ok with Excel8!.

When incorporating error handling with datawindow errors there is a problem that the behavior of the dberror event

depends on the return value. However if you add a throw statement then the return statement will never be executed and

you cannot control the event processing.

You can create a runtimeerror object in the datawindows DBERROR event, populate this object with information about db errors, and throw it for error handling at a different place.

This may give better error handling across all our scripts instead of checking lots of return codes ( -1 ) in all kinds of scripts.

Except there is one problem: Using Return 1, the default error dialog should not appear: But with the THROW, return 1 is never processed, so the dialog appears anyway.

Other (datawindow) events have quite similar problems.

======

There is one existing solution to this problem but it is an obsolete one.

You can still use the SetActionCode to control the processing of the event.

changes the window size. For example, after you create a new window and you change

the windowtype from main to child!, you can see the height and width increase.

If you keep changing the windowtype, it will mostly increase. Changing from

child! to popup!.

pb will crash with an access violation. When you click on any of the objects from the search results, it will open the object. If you do that several times, it may crash PB.

From the user dump generated, the problem appears to be happenning in the:

PBUDO90!CDS_Object::UnsubscribeVariables+8e

ExceptionAddress: 1270568e (PBUDO90!CDS_Object::UnsubscribeVariables+0x0000008e)

ExceptionCode: c0000005 (Access violation)

Fixed in PB 9.0.1 build 7270 and after.

looking at the second page, it only shows the header and page number in the footer band.

The group nested report has groups in the header and detail.

RESOLUTION: The extra page will disappear if you decrease the detail area size. Move detail bar up, until it reach the bottom of nested DW. The page will show good by one page.

The dw and nested dw are set to autoheight, but the length of nested dw to bottom detail bar still needs to be calculated.

The crash is avoided when the generation is divided into smaller subsets of the service structures (around 30).

the activate event is not triggered. The only way to get focus back on the window

is to click on the icon on the task bar to activate the window.

The testcase will use openwithparm to open window1. Then by clicking on the cb

openwithparm is called again to open window2. Finally by clicking on the cb openwithparm is called to open window3. Window2 is closed. In the open event of window3, calls

a user event which calls the openwithparm on window1 again and closes window3. Window3

is closed but the activate event in window1 is not triggered.

Fixed in PB 9.0.1 build 7265 and after.

There is no problem deleting a number or a character on a single-line edit field using the emulator's "Back" button. There is also no problem deleting a character on an editmask field.

eg. if i want to enter a phone number on a numeric editmask field:

-> 0651112345 will turn out as 651112345, the leading 0 is backspaced automatically.

1. Attempted to use ActiveSync to install the runtime on the device (throught the Add/Remove programs option). It copies over the CAB fine, but then can't install it. Apparently the CAB gets installed in the phone's main memory and then there isn't enough room left to decompress it.

2. Copied the SP_PocketBuilder.SPARM.CAB file over to a storage card on the phone manually and then decompressed it. It appeared to work fine. However, only the APPLIST file ended up in the Program Files\Sybase\PocketBuilder directory. I have no idea where, if anywhere, the DLLs got deployed to.

3. Attempted to compile the app and deploy it to the device. No matter what I put in for the program location, PocketBuilder couldn't seem to figure out where it was supposed to deploy it to.

4. Copied the compiled application over to the device manually, placing it in the same directory as the APPLIST file. Attempted to run it and was told that the application couldn't find the PKVM20.DLL file.

5. Copied the files from the \Program Files\Sybase\PocketBuilder 2.0\WinCE\sparm directory on the desktop into the same folder as the APPLIST file on the device. Attempted to run the deployed application again, and was told that the PKVM20.DLL file is not a valid DLL file.

1. I cannot deploy PocketBuilder to the SmartPhone using ActiveSync.

2. I cannot deploy PocketBuilder to the SmartPhone using the CAB file.

3. When the application is run on the SmartPhone, the load time seems extremely long.

4. The application does not appear to have a title, even though the window has. Instead, it still shows the title from the File Explorer (which I used to launch it).

5. The deployed application didn't pick up the application icon I used (though I've still got to try a few other formats).

6. I'm dynamically modifying the text on the menu items I'm using for the option buttons, but the text isn't updating. Is there a way to force the application to refresh the text on the option buttons?

Using the FieldSoftware printer driver, if the datawindow has an autosize height column in the detail band, a blank page is printed. If the column is NOT autosize then the datawindow prints OK, but we've lost the autosize functionality.

Sample uses the script found in the PB help and works as expected if more than one file is selected, but appends an extra filename as part of the path as shown below if only one file is selected. The result is displayed in an mle.

The code snippet from PB Help that is used is:

string docpath, docname[]

integer i, li_cnt, li_rtn, li_filenum

li_rtn = GetFileOpenName("Select File", &

docpath, docname[], "DOC", &

+ "Text Files (*.TXT),*.TXT," &

+ "Doc Files (*.DOC),*.DOC," &

+ "All Files (*.*), *.*", &

"C:\Program Files\Sybase", 18)

IF li_rtn < 1 THEN return

li_cnt = Upperbound(docname)

for i=1 to li_cnt

mle_selected.text += string(docpath)+"\"+(string(docname[i]))+"~r~n"

next

If I select one file named readme.txt located under C:\Program Files\Sybase , the mle shows :

C:\Program Files\Sybase\readme.txt\readme.txt

The docpath is returned as C:\Program Files\Sybase\readme.txt when it should be just C:\Program Files\Sybase

Butif more than one file is chosen, this doesn't occur. The docpath is correct and the mle shows something similar to this:

C:\Program Files\Sybase\readme.txt

C:\Program Files\Sybase\PB10install.txt

C:\Program Files\Sybase\DWNET10readme.txt

The docpath is returned as : C:\Program Files\Sybase

Using a NumericMask! the behavior is the same in all versions tested.

has different behaviour on DBCS OS and non-DBCS OS.

DBCS sort by case sensistive.

non-DBCS sort by case insensistive.

Thus this CR Request to enhance the datawindow sort syntax with a case sensistive switch:

Suggestion.

no matter on DBCS or not it is default to case insensistive

e.g. integer dwcontrol.SetSort ( string format [, boolean case-sensistive])

case-sensistieve

- false (default ), sort by case insensistive logic

- true , sort by case sensistive.

any type arguments containing a datetime, i.e: IsNull(function(any_datetime))

This corruption could also lead to a later crash.

To test for Null values convert the any variable or the function return value first

to a regular datetime variable or test IsNull directly on the any variable, i.e. IsNull(any_datetime)

if ( sum (unit_price) = 0.00 ,string ('0.00',"0.00" ) , if ( sum (unit_price) < 0 ,string (sum (unit_price) , "###,###,###,##0.00"),string (sum (unit_price) , "###,###,###,##0.00")))

This computed field is able to be verified in the computed field dialogue box but when you open the window that has a datawindow with this dataobject associated with it in the Window painter, you will gpf when clicking on the datawindow control. The customer has a workaround to this issue (remove the quotes around the first 0.00 in the first string function):

if ( sum (unit_price) = 0.00 ,string (0.00,"0.00" ) , if ( sum (unit_price) < 0 ,string (sum (unit_price) , "###,###,###,##0.00"),string (sum (unit_price) , "###,###,###,##0.00")))

Fixed in PB 9.0.1 build 7270 and after.

Select error: internal error: no result set

In the jdbc log, the following error displays:

Java PbjdbcCommand::GetRowSet No ResultSet

Errormessage claims a variable is not defined - the referenced variable is a word of a comment in the script. compile error C0015: Undefined variable: or sometimes you get a c0165: Misused type:

<xsd:element name="MetFACSBrokerageId" minOccurs="0" maxOccurs="1" type="xsd:string"></xsd:element>

<xsd:element name="MetFACSCustNo" minOccurs="0" maxOccurs="1" type="xsd:string"></xsd:element>

<xsd:element name="MetFACSProspectNo" minOccurs="0" maxOccurs="1" type="xsd:string"></xsd:element>

The issue is that when PowerBuilder sends the SOAP request message, it sends ALL fields of this structure within the message, even if that field is NULL or an empty string. When the web service receives the message it builds a WHERE clause with all of the fields, and so the desired elemnt in the DB is never located.

Since there is a minOccurs=0 clause on these fields, we feel that PowerBuilder should not send the fields in the SOAP message if the value of the structure field in PowerBuilder is NULL. The same might be said if the value of the field is an empty string; however, that is subject to interpretation.

RESOLUTION: Set the structure fields to null will cause the nill=true attribute to be set and then web service worked ok.

DataWindow Designer doesn't allow you to do an Edit Source directly, we should enable this option for convenience.

A datawindow is shared and set in querymode.

After a retrieve of the datawindow a crash occurs when setting DataWindow.QueryClear = "yes".

Work-around is to call sharedataoff() before the QueryClear and re-establish the sharedata afterwards.

and you try to expand a table in the db painter, the following error will result:

SQL Error -217: Column(extended_id) not found in any table in the query

(or SLV is undefined).

error message will appear:

Location Services Error - Procedure

ORA-06550: line1, column 15:

PLS-00306: wrong number or types of arguments in call to 'NEWPART'

ORA-06550: line1, column 15:

PL/SQL: Statement ignored

Verified fixed in PB 9.0.1 build 7284.

project, a codegen compilation error results. From the log file, the following

is listed:

CGEN: Compiling 'C:\WINNT\TEMP\a_cdap_repl.c'

CGEN: Compiling 'C:\WINNT\TEMP\cgi3h2uv.c'

CGEN: Compiling 'C:\WINNT\TEMP\cgi3h2uu.c'

C:\WINNT\TEMP\cgi3h2uu.c(935) function argument(s) do not match those in prototype

C:\WINNT\TEMP\cgi3h2uu.c(935) 'OB_OBJECT * stdcall ob_copy_rtinst( ob_this *, OB_OBJECT * )' defined in: C:\pb80\Shared\PowerBuilder\cgen\DN32T.h(44) (col 44)

C:\WINNT\TEMP\cgi3h2uu.c(935) cannot convert argument 2 defined in: C:\WINNT\TEMP\cgi3h2uu.c(935) (col 103)

C:\WINNT\TEMP\cgi3h2uu.c(935) source conversion type is "tag_OB_NARRAY * (lvalue)"

C:\WINNT\TEMP\cgi3h2uu.c(935) target conversion type is "OB_OBJECT *"

RESOLUTION: Applying fix of CR273803 to PB80 will require all the current PB80 applications to do a full rebuild to work correctly. That means all the application must do migration. That's why we haven't applied the fix to PB80. The fix is in PB 90.

pb will crash when you select edit data -> tabular or freeform for a stored procedure

that has 13 or more arguments.

and that sp has 13 or more arguments, pb will crash as soon as you select that

sp in the datawindow wizard.

driver, pb will crash when you try to paste the Declare Procedure syntax into

any pb object.

When in the open event of a mdi sheet a popup window is opened and closed,

then a subsequent popup menu may open at the wrong position.

After minimizing and restoring the frame window, the popup menu appears at the right position.

The problem is reproducible in PowerBuilder 9 Build 7096 and later, and also in PowerBuilder 8 and 10.

When the PBMaxBlobSize is set high value, the pbtrace.log shows the following:

(12a5ff4): BLOB READ: COLUMN=store_data1 TABLE=store_data1 CLAUSE= from store_data1 WHERE store_key ='APDF111122223333' AND segment =0 (90 MilliSeconds)

(12a5ff4): GET AFFECTED ROWS: (0 MilliSeconds)

(12a5ff4): ^ 0 Rows Affected

When its set to 32767, the log file shows the correct results:

(1300220): BLOB READ: COLUMN=store_data1 TABLE=store_data1 CLAUSE= from store_data1 WHERE store_key ='APDF111122223333' AND segment =0 (10 MilliSeconds) LENGTH=346

(1300220): GET AFFECTED ROWS: (0 MilliSeconds)

(1300220): ^ 1 Rows Affected

Customer setting the PBMaxBlobSize to PBMaxBlobSize='2147483647' in the pbodb100.ini.

Works ok in PB 9.0.1 (build 7560).

Workaround: run right project manualy from project painter

External function declaration in PB 9.x before migration:

FUNCTION int GetNames(ref string names[]) LIBRARY "TEST.DLL"

External function declaration in PB 10 after migration:

FUNCTION int GetNames(ref string names[]) LIBRARY "TEST.DLL" alias for "GetNames;Ansi"

UpperBound is returning invalid values and data returned is also corrupted.

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".

Wants to develop a big secured application with Datawindow .net product.

According to the .NET technology, it is possible to create signed assemblies (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconProgrammingWithAssemblies.asp)

Customer has noticed that, unlike pbdata100.dll which is signed and has a section .publickey, datawindow.dll and datawindowinterop.dll are not signed.

following is written to the Jaguar.log:

Java VM loaded. Version: 1.4.1_03, Vendor: Sun Microsystems Inc."

If you doing alot of connections, it will create alot of output. The java vm message

appears whether a connection cache is used or not.

It is reported that PB JSP 4GL get problem on handling the variables / parameter,

as the variable content of the first JSP session always be overwritten by another session.

No workaround

As a workaround until this is fixed you can set the insertion point in an editmask to the first position with this code:

em_1.SelectText ( 1, 0 )

See the help on SelectText for more details.

There is a hard-coded limit of 1000 columns per datawindow as evidenced by the following constant in the dw.h include file:

// Restrict maximum number of columns to ensure consistent performance.

// Should look at this number again at some point.

#define DW_MAXIMUM_COLUMNS 1000

This limitation should be documented.

Workaround: reassign the dataobject to the datawindow or datastore before a 2nd retrieve

dw_1.dataobject = "d_test"

dw_1.settransobject(sqlca)

dw_1.retrieve()

doesn't work. This behavior is different than with a datawindow. Getitem does

return the value when the taborder is 0 for a regular dw.

Customer would like to seem the same behavior on a web datawindow that is now

for a regular dw and that is getitem works when the taborder is 0.

When taborder is 0 the following is generated:

<SPAN CLASS=dwClient92C STYLE="position:absolute; left:2.803in; top:0.000in; width:1.980in" onClick="{return dwClient.itemClicked(125,-1,'address');}" >91 Washington Street</SPAN>

When taborder is greater than 0, the following is generated:

<INPUT TYPE="text" NAME="address_125" SIZE=30 MAXLENGTH=35 VALUE="91 Washington Street" CLASS=dwClient629 TABINDEX=629 STYLE="position:absolute; left:2.803in; top:0.000in; width:1.980in" READONLY onFocus="{dwClient.itemGainFocus(125,4,this,dwClient.gobs.address); dwClient.selectControlContent(this);}" onClick="{var ret; ret= dwClient.itemClicked(125,4,'address'); return ret;}" onChange="{this.bChanged = true;}" onkeypress="DW_EditKeyPressed(-1)" onBlur="{dwClient.itemLoseFocus (this);}">

The getitem function generated from the webdw:

function HTDW_GetItem(row, col)

{

var result;

var colNum = this.getColNum(col);

var rowObj = this.rows[row-1];

if (colNum == -1 ||

(rowObj + "" == "undefined") ||

rowObj[colNum] + "" == "undefined")

result = -1;

else

result = rowObj[colNum];

return result;

}

using SQL Server and IIS on the same machine.

Machine is a quad processor with 4GB of RAM.

has a Declare statement with output parameters defined as follows will cause

the error of 'Database C0038: Can't use the OUTPUT option when passing a constant to a

stored procedure'.

Declare deptproc Procedure For deptroster

@rc = deptroster,

@deptno = :lDeptno,

@totsal = :dTotSal output,

@avgsal = :dAvgSal output using sqlca;

For example, the following will not select the desired font:

PrintDefineFont(Job, 1, "Courier 10Cpi", -18, 400, Default!, Decorative!, FALSE, FALSE)

The following does select the desired font (10cpi in lower case):

PrintDefineFont(Job, 1, "Courier 10cpi", -18, 400, Default!, Decorative!, FALSE, FALSE)

In 8.0 build 10691 and prior it had the old behavior as it did in 9.0.1 build 7196 and prior. But shortly after those builds the behavior changed.

no workaround

By contrast, if you modify the text property of the same checkbox column, the row that had focus, still has focus after the modify, and when you tab into the datawindow, it goes to the first column in that row and tabs from column to column in the dw.

Could be linked to CR368097.

file and then you try to open up the *.xls file, no data shows up in Excel.

If you try to open up the file in PB 9.0.2, you get a memory error. In PB 10,

it opens with no data inside. Works ok using Excel5!.

Save problem when trying to save to Excel8 from the datawindow or database painter.

In the datawindow painter, if you select File/Save Rows As and save to excel8, when

you try to open it no data shows up.

select convert(varchar(2),datepart(MM,getdate())) + substring('00',1,2 - length(convert(varchar(2),datepart(DD,getdate()))))+ convert(varchar(2),datepart(DD,getdate()));

The problem they have is that under certain conditions, because the datastore is primary and of_SetReqColumn does not effect the datastore, the dw focus can become "stuck" in a field with no error message and the subsequent attempt to sort fails.

There are a number of workarounds depending upon the full implementation. The simplest workaround is to use the datastore as the secondary and the datawindow as the primary datasource when using ShareData in combination with Required fields and the of_SetReqColumn method. In this customer's case, that workaround is unacceptable.

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".

Informix 9 driver, pb will crash with an access violation in the pbshr100.dll.

To get the actual argument names of a Webservice in the resulting wsdl requires the following server property to be set:

com.sybase.jaguar.server.jvm.options=-Djava.protocol.handler.pkgs=com.sybase.jaguar.net,-DSERVER_STUBS_DEBUG=true

The solution for the problem is to switch to Windows Classic View through Control panel.

Customer does not want to have to alter her control panel settings in order to get the Lowered borders to show up when running from the IDE. She has used the solution of deselecting "New Visual Style Control" in the project painter for her Executable. She would like a better solution for running within the development environment.

Workaround: export proxy and change the function manualy and import it again. As well complete the empty structure manualy.

Inconsitant behavior in PB9:

In PB9 OLE control (mscal.ocx) inside of a datawindow can display a 'ghost' image on the window, where it has been placed onto. PB will crash if user clicks on 'ghost' image.

Functionality would include a date column appearing to be a dropdown and when one clicks on the dropdown it opens the Microsoft control positioned right over the date column.

No errors in Jaguar.log file.

The user dump provided shows:

Stack overflow - code c0000fd

jvm!JVM_FindSignal

Customer is using jdk 1.4.2 hotspot (mixed mode).

Tested and reproduced with PB 9.0.1 7204, 7236 and 7275

Works fine with PB 9.0 with no EBFs

Workaround: Migrate to Windows 2000 or higher

Instead, it should allow a blank list of publications and return a ul_publication_mask of zero. -280 will still be returned if the user explicitly requests a publication that is not found.

The problem increases exponentially as the number of objects to add increases. Thus, if you try to add an entire target with 10+ PBLs, you will see noticable degradation. Add a target with 100 PBLs and you could hang forever or consume all available memory.

The performance problem is due to an error handling routine called CreateValidEnum() that was introduced in PB9 development. It tries to make sure that the .PBG file entries that are added only include objects that were successfully added to source control. A more efficient technique is needed.

EXCLUDE_CHECKOUT processing will issue two SccQueryInfo calls with an array of 500 file names.

Perforce OUTOFDATE processing also needs the SCC_STATUS_OUTOFDATE flag setting from SccQueryInfo. However, instead of saving the status indicators from the EXCLUDE_CHECKOUT request, PB9 must re-issues 1000 SccQueryInfo requests with array size of 1. This adds several minutes to time needed to complete the job.

This is fixed in PB10 and PocketBuilder 1.5.2. This CR documents the fact that the problem exists in PB9 and a customer has reported the problem on the newsgroup.

The log however (soaplog), shows the returned values ok.

PowerBuilder will incorrectly attach the submenu branch.

From observeration, wrong order and miss menu item may occur.

that the Distill method is not supported on unix.

The documentation describes Distill and XSL-FO. It mentions the following:

The XSL-FO option provides a platform-independent solution and offers the possibility of customizing the saved PDF file and printing it directly to a printer. Saving as PDF using XSL-FO is particularly useful for printing DataWindow objects in EAServer on a UNIX operating system.

------

It probably should just mention that Distill is not supported on unix.

-> Save of OLE binary information failed. Object must be resaved to preserve it.

No workaround

Getting error:

"PowerBuilder Accessibility Error" "Error loading library. Please check whether PowerBuilder Accessibility library can be located in the path."

This was solved by deploying PBACC100.DLL to the deployment machine. I do not find PBACC100.DLL listed as a deployment dll in the documentation.

Generates an error: The data type, 'gYear', is not supported.

percentage of a grid datawindow and then use getfullstate/setfullstate, one

of the column headers (City) is missing.

Tested and reproduced with:

PB 9.0.1.7204, 9.0.1.7236, 9.0.1.7275, 9.0.2.7509 and 10.0.0.5032

has a computed field, the text color will change.

Problem happens in the IDE and running an exe (when new XP style control is checked).

When you run without the XP Style (no pb90.exe.manifest) than the text color that

was assigned to the color shows up ok.

User B uses orcascript to refresh the target but chooses "incremental" build option

instead of "full" rebuild. Orcascript imports the source for the new object and performs phase 2 compile. However, the "incremental" rebuild phase does not detect the need to regenerate this new object, so it goes unregenerated.

From the IDE, it appears that the object was never added to the PBL and is therefore unusable.

column, the following error will result when you delete the values in that column

and then update it:

Error 257 (rc -1) : SQLSTATE = 42000

Microsoft OLE DB Provider for SQL Server

Implicit conversion from data type text to nvarchar is not allowed. Use the CONVERT function to run this query.

Problem only happens when Emptry String Is Null is checked for a column. The column is

defined to allow nulls.

In PB 8.0.4, the error happens on varchar and nvarchar columns. In PB 9, the error

only happens on nvarchar. In PB 10, the error only happens a varchar column.

The update to the database is being done thru a stored procedure.

The inner group is sorted correctly but the outer group is sorted in descending

order instead of the specified Ascending order.

on screen. Thus aligned objects with grid datawindow should be the same.

However, it is not the case when investigate with the repro. sample.

a customer sees a noticable performance difference between PB 5.0.4 and PB 9.0.2 (build 7509.

From the filemon utility, you can see there is noticable more I/O activity with PB 9.0.2

than 5. For example,

When you click on the lion.exe and then login to the application, you see alot more

I/O activity in PB9. You see read activity on the libjcc.dll, pbvm90.dll and pb.ini.

In PB 9.0.2, the following sequence is repeated twice for every pbd. Once it

query, open,etc for each pbd, it goes back and repeats the process in PB 9.0.2.

There is also a sequence where it reads each pbd and then repeats the process. This is

not happenning in PB 5.

In PB 5 (I/Os) In PB 9.0.2 (I/Os)

lionfinal.pbd: 7 60

common.pbd: 21 96

security.pbd: 11 63

l_courtesy.pbd: 10 53

insert into TSDATA.EMPLOYEE_T select * from TSDATA.EMPLOYEE;

select count(*) from TSDATA.EMPLOYEE_T;

select count(*) from TSDATA.EMPLOYEE_T;

The result from the first select count(*) is 76 as it should be (76 rows in the employee table are inserted into the temp table). But the result from the second select count(*) is 0.

Workaround: if possible use string value as parameter instead date and convert the string into a date in the calling component.

DataWindow Error

Line 10 Column 211: incorrect syntax.

The Progress tabpage in the Migration Information dialog shows:

"Error C0159 Conversion of impdw.pkl (d_graph.dwo) failed. Probable library file I/O error."

I checked the exact datawindow source for the error referenced and found it references the window property "plotnulldata="0". This property is disabled in PB10 and removed from the graph datawindow painter in PK 2.0. Thus, during import from PB10 to PK 2.0, it might have been an invalid syntax.

CGEN: Compiling 'c:\temp\11072859.c'

c:\temp\11072859.c(650) wide character string concatenated with a simple character string

Workaround: break up the single line string into more shorter strings.

how can you instantiate a java array with no elements in PB?

Sample: in java you can create an array without elements:

MyClass[] test = new MyClass[0];

the result of it is an existing array (not null) but empty (no elements)

not work on the PPC device (I have tried GIF and BMP). However, it does work

correctly in native mode from the PPB IDE.

of a column in a datastore, the following error results in the Jaguarhttpservlet.log:

Nov 02 08:20:06 2004: 060038-Error: Unable to service request for servlet: jspservlet.

Nov 02 08:20:06 2004: 060039-Error: ServletException contained the following root cause exception:

org.omg.CORBA.MARSHAL: offset (24) + length (4) exceeds message size (24) minor code: 0 completed: No

at com.sybase.CORBA.iiop.InputStream.read(InputStream.java:90)

at com.sybase.CORBA.iiop.InputStream.read_ulong(InputStream.java:195)

at com.sybase.CORBA.iiop.InputStream.read_string(InputStream.java:431)

at com.sybase.CORBA.iiop.Connection.read_string(Connection.java:4114)

The following code is used:

ds_test = Create Datastore

ds_test.dataobject = "d_test"

ls_dwObject = ds_test.Describe( "Datawindow.Syntax")

ds_test.DataObject = ""

li_ret = ds_test.Create(ls_dwObject )

ls_modify = ds_test.Describe("Test.Type")

ls_modify = ds_test.modify ("test.TabSequence = 10")

Return ls_modify

FUNCTION long ODBC_WriteDSN (ref s_dsn mydsn) library "pkodb10u.dll" alias for "ODBC_WriteDSN"

The references to "pkodb10u.dll" is archaic as the PK ODB driver library is now "pkodb20.dll". Thus, the function declaration should be updated to reflect the PK 2.0 ODB driver library.

EAServer 5.1 + PBVM 9.0.1_6533 on Sun Solaris

Windows 2000 Client: PB 9.0.2_7509

The error message produced by XMLParseString invocation is a "Exception: Bad runtime reference". The XMLParseString function works ok when invoked in EAServer 5.1 on Windows platform.

Workaround: use the search service for dddw in the PFC

is available in the folders "c:\program files\sybase\PocketBuilder 2.0\WinCE\sparm" and "c:\program files\sybase\PocketBuilder 2.0\WinCE\spx86".

This may be the desired approach since UltraLite is recommended for the SmartPhones...

function is called and it returns a structure where some of the elements in the structure

are unbounded arrays.

The function lookupcompletecodedconcept is define as:

lookupcompletecodedconcept(intf__conceptid in0) returns intf__completecodedconceptdescription

The inft__conceptid is defined as:

string codesystem_id

string concept_code

The inft_completecodedconceptdescription is defined as:

inft__conceptid concept_id

string conceptstatus_code

string codesystem_version

intf__conceptdesignation designatedby[]

intf__conceptproperty hasproperties[]

intf__conceptrelationship sourcefor[]

intf__conceptrelationship targetof[]

When viewing in the PB debugger, you will see the following:

intf_conceptdesignation designatedby[3]

[1]

boolean preferredforlanguage=false

powerobject classdefinition

string designation = "" <-- missing value

string language_code = "" <-- missing value

[2]

boolean preferredforlanguage=false

powerobject classdefinition

string designation = "" <-- missing value

string language_code = "" <-- missing value

[3]

boolean preferredforlanguage=false

powerobject classdefinition

string designation = "" <-- missing value here

string language_code = "" <-- missing value here

intf_conceptid concept_id

powerobject classdefinition

string codesystem_id = "ne=uri:iso:2.16.840.1.113883.6.2/DIAG,ra=HL7" <-- notice value

string concept_code = "001.9" <-- notice value

intf_conceptproperty hasproperties[4]

[1]

powerobject classdefinition

string language_code = "" <-- missing value

string mimetype_code = "" <-- missing value

string property_code = "" <-- missing value

string propertyvalue = "" <-- missing value

[2]

powerobject classdefinition

string language_code = "" <-- missing value

string mimetype_code = "" <-- missing value

string property_code = "" <-- missing value

string propertyvalue = "" <-- missing value

[3]

powerobject classdefinition

string language_code = "" <-- missing value

string mimetype_code = "" <-- missing value

string property_code = "" <-- missing value

string propertyvalue = "" <-- missing value

[4]

powerobject classdefinition

string language_code = "" <-- missing value

string mimetype_code = "" <-- missing value

string property_code = "" <-- missing value

string propertyvalue = "" <-- missing value

intf_conceptrelationship sourcefor[0]

intf_conceptrelationship targetof[3]

[1]

intf_conceptid sourceconcept_id

powerobject classdefinition

string codesytem_id = "" <-- missing value

string concept_code = "" <-- missing value

intf_conceptid targetconcept_id

powerobject classdefinition

string codesystem_id = "" <-- missing value

string concept_code = "" <-- missing value

powerobject classdefinition

string relationqualifiers = [0]

string relationship_code = ""

[2]

intf_conceptid sourceconcept_id

powerobject classdefinition

string codesytem_id = "" <-- missing value

string concept_code = "" <-- missing value

intf_conceptid targetconcept_id

powerobject classdefinition

string codesystem_id = "" <-- missing value

string concept_code = "" <-- missing value

powerobject classdefinition

string relationqualifiers = [0]

string relationship_code = ""

[3]

intf_conceptid sourceconcept_id

powerobject classdefinition

string codesytem_id = "" <-- missing value

string concept_code = "" <-- missing value

intf_conceptid targetconcept_id

powerobject classdefinition

string codesystem_id = "" <-- missing value

string concept_code = "" <-- missing value

powerobject classdefinition

string relationqualifiers = [0]

string relationship_code = ""

In the wsdl file, the function is defined as:

- <wsdl:operation name="lookupCompleteCodedConcept" parameterOrder="in0">

<wsdl:input message="impl:lookupCompleteCodedConceptRequest" name="lookupCompleteCodedConceptRequest" />

<wsdl:output message="impl:lookupCompleteCodedConceptResponse" name="lookupCompleteCodedConceptResponse" />

<wsdl:fault message="impl:UnexpectedError" name="UnexpectedError" />

<wsdl:fault message="impl:UnknownConceptCode" name="UnknownConceptCode" />

<wsdl:fault message="impl:UnknownCodeSystem" name="UnknownCodeSystem" />

</wsdl:operation>

The lookupCompleteCodedConceptRequest is defined as:

- <wsdl:message name="lookupCompleteCodedConceptRequest">

<wsdl:part name="in0" type="impl:ConceptId" />

</wsdl:message>

- <complexType name="ArrayOfConceptId">

- <complexContent>

- <restriction base="soapenc:Array">

<attribute ref="soapenc:arrayType" wsdl:arrayType="impl:ConceptId[]" />

</restriction>

</complexContent>

</complexType>

- <wsdl:message name="lookupCompleteCodedConceptResponse">

<wsdl:part name="lookupCompleteCodedConceptReturn" type="impl:CompleteCodedConceptDescription" />

</wsdl:message>

- <complexType name="CompleteCodedConceptDescription">

- <sequence>

<element name="concept_id" nillable="true" type="impl:ConceptId" />

<element name="conceptStatus_code" nillable="true" type="xsd:string" />

<element name="codeSystem_version" nillable="true" type="xsd:string" />

<element maxOccurs="unbounded" name="designatedBy" nillable="true" type="impl:ConceptDesignation" />

<element maxOccurs="unbounded" name="hasProperties" nillable="true" type="impl:ConceptProperty" />

<element maxOccurs="unbounded" name="sourceFor" nillable="true" type="impl:ConceptRelationship" />

<element maxOccurs="unbounded" name="targetOf" nillable="true" type="impl:ConceptRelationship" />

</sequence>

</complexType>

- <complexType name="ConceptDesignation">

- <sequence>

<element name="designation" nillable="true" type="xsd:string" />

<element name="language_code" nillable="true" type="xsd:string" />

<element name="preferredForLanguage" type="xsd:boolean" />

</sequence>

</complexType>

- <complexType name="ConceptProperty">

- <sequence>

<element name="property_code" nillable="true" type="xsd:string" />

<element name="propertyValue" nillable="true" type="xsd:string" />

<element name="language_code" nillable="true" type="xsd:string" />

<element name="mimeType_code" nillable="true" type="xsd:string" />

</sequence>

</complexType>

- <complexType name="ConceptRelationship">

- <sequence>

<element name="sourceConcept_id" nillable="true" type="impl:ConceptId" />

<element name="relationship_code" nillable="true" type="xsd:string" />

<element maxOccurs="unbounded" name="relationQualifiers" nillable="true" type="xsd:string" />

<element name="targetConcept_id" nillable="true" type="impl:ConceptId" />

</sequence>

</complexType>

The external function declarations have the ALIAS FOR ...;ansi clause added, but the behavior is the same without it.

Verified fixed in 10.0.1 build 6019.

or better support all encodings of the Unicode Standard Version 4.0.

This is most likely a regression caused by CR 366069. CR 366069 was fixed in PB 10 build 5046. Previous versions of PB worked without any problems e.g. PB 10 build 5041.

receiving the following error:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Using the following stored procedure syntax:

CREATE OR REPLACE procedure sp_vtest (id integer, val IN OUT CHAR) as begin val := 'Y'; end;

a html page with a codebase pointing to the cab file, the ocx is not registering on

the client machine.

The following error appears in the temp cache:

*** Code Download Log entry (08 Nov 2004 @ 11:24:09) ***

Code Download Error: (hr = 80040154) Class not registered

Operation failed. Detailed Information:

CodeBase: http://localhost/mycab.cab

CLSID: {99991304-9999-1000-8000-080009AC61A9}

Extension:

Type:

LOG: Setup Hook (null) was executed successfully.

--- Detailed Error Log Follows ---

LOG: Download OnStopBinding called (hrStatus = 0 / hrResponseHdr = 0).

LOG: URL Download Complete: hrStatus:0, hrOSB:1, hrResponseHdr:0, URL:(http://localhost/mycab.cab)

LOG: Setup Hook (null) was executed successfully.

LOG: Setup successful installing: mycab.inf to (null) destination code(0)

LOG: Reporting Code Download Completion: (hr:80040154, CLASSID: 99991304..., szCODE:(http://localhost/mycab.cab), MainType:(null), MainExt:(null))

RESOLUTION: Used the following format for the .INF file:

[version]

signature="$CHICAGO$"

AdvancedINF=2.0

[DefaultInstall]

CopyFiles=install.files

RegisterOCXs=RegisterFiles

[DestinationDirs]

install.files=11

pbvm80.dll=pbvm80.dll

libjcc.dll=libjcc.dll

[install.files]

PBRX80.ocx=PBRX80.ocx

pbvm80.dll=pbvm80.dll

libjcc.dll=libjcc.dll

[RegisterFiles]

%11%\PBRX80.ocx

[pbvm80.dll]

file-win32-x86=thiscab

FileVersion=8,0,4,10810

DestDir=11

[libjcc.dll]

file-win32-x86=thiscab

FileVersion=

DestDir=11

[PBRX80.ocx]

file-win32-x86=thiscab

FileVersion=8,0,4,10701

RegisterServer=Yes

DestDir=11

Used cabarc.exe to create the cab file:

cabarc.exe n mycab.cab mycab.inf pbrx80.ocx pbvm80.dll libjcc.dll

Used the following html syntax:

<OBJECT ID="PBRX1" CODEBASE ="http://localhost/mycab.cab#1,0,0,0" CLASSID ="CLSID:88881304-8888-1000-8000-080009AC61A9" NAME="PBRX1" WIDTH=720 HEIGHT=490 >

<PARAM NAME ="_Version" VALUE="65536">

<PARAM NAME ="_ExtentX" VALUE="15843">

<PARAM NAME ="_ExtentY" VALUE="9172">

<PARAM NAME ="_StockProps" VALUE="0">

<PARAM NAME ="PBWindow" VALUE="w_test">

<PARAM NAME ="PBApplication" VALUE="test">

<PARAM NAME ="LibList" VALUE="http://localhost/test.pbd;">

</OBJECT>

and you click on the column to open the pdf, it either doesn't launch Adobe to open

the file or you get the following error:

Adobe Reader

The document could not be saved. This operation is not permitted.

The first behavior where Adobe didn't launch when I doubleclicked on the database

ole blob column. I then upgraded the Adobe Reader from 6.0.1 to 6.0.2 and now I get

the document could not be saved error. After I click ok, than the pdf file will appear.

If I close out of the pdf and then double click on the column again, than I just see

the document could not be saved error again. Upgrading to 6.0.2 doesn't appear to resolved the issue since on another machine I just upgraded to 6.0.1 and saw the same behavior. Just upgrading Adobe appears to change the behavior within PB--that is PB not launching Adobe to Adobe displaying error messages and than opening the pdf file. The

error messages appear in the background and only by scrolling to the Adobe process

will the error message appear.

Resolution: Used workaround below and Adobe Reader 7.0:

// insert pdf into ole container and then update to table

blob lb_object

ole_1.InsertFile("C:\nmfs.pdf")

lb_object = ole_1.objectdata

UPDATEBLOB ole SET object = :lb_object

WHERE id = 'PDF File'

USING SQLCA ;

The issue seems to be related to an oledb connection, in this case SqlServer as ASE does not appear to have the problem. There are two fields that are failing within a crosstab datawindow. The problem fields are Char(3), Char(5). These two fields are fully populated with 3 characters and 5 characters of data. If you were to create a tabular datawindow you would get the complete result set back. With a crosstab datawindow these two fields are getting truncated by one character resulting in a field lenght of 2 and 4 rather then the 3 and 5.

This is not a bug and is expected behavior. If you use c++ code to call the pb application, there is no message loop and all posted events will not be executed. The way to solve this problem is to call PBNI function "ProcessPBMessage()" in the c++ code. When ProcessPBMessage() is called, a PB message is fetched from the queue and executed. If you use a console c++ application, you may need create a thread to call ProcessPBMessage() continuiously. If you you are using a window c++ application, you could call ProcessPBMessage() in your own message loop in OnIdle() methods.

The PowerBuilder Native Interface Programmer's Guide and Reference has details.

datawindow, PB will crash will a access violation in libcomn.dll.

The crash handler shows the following:

Exception code: C0000005 ACCESS_VIOLATION

File Name: E:\sql125\OCS-12_5\dll\libcomn.dll

Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

0244FEA4 0012C498 012C0000 0000002C 0012C4FC 00000400 0001:0002EEA4 E:\sql125\OCS-12_5\dll\libcomn.dll

0242DDA1 0012C8E4 00A099A0 0012CD48 012BFFE8 0012CDF8 0001:0000CDA1 E:\sql125\OCS-12_5\dll\libcomn.dll

024C24B4 0012C9F0 00A099A0 0012CD48 012BFFE8 0012CDF8 0001:000014B4 E:\sql125\OCS-12_5\dll\libcs.dll

10DC78AB 0012CFC0 012AD268 012AC3E8 0129D220 00000000 Syc5_ChangePasswordBoxProc+918B

10DA25B1 0012D01C 012AD268 0012D1BC 00000000 00000000 PB_DB_Rout+A11

10FE492C 00000001 00000000 00000000 00000000 00000000 0001:0000392C E:\pb10\Shared\PowerBuilder\pbTRA100.dll

xsl-fo on hpux.

When saving to pdf using xsl-fo, it taxes the cpu such that the overall system

performance degrades.

O84 native interface returns strange "square" characters in DB Painter resultset when selecting column with datatype as VARCHAR2.

O84 native returns the following error message:

Select error: Decimal conversion error. PowerBuilder only supports 18 decimal digits.

Data retrieved from univarchar columns using the SYJ interface is not properly converted.

This does not happen with SYC or ODBC(U) or with nvarchar columns.

PER DEVELOPMENT:

deploy pb.ini file to the tomcat server(on which pbvm and pbdwe run), add a switch like this:

[DataStore Behavior]

UseHwnd = no

Now the statements are all in lowercase.

Today we have the "Display Database Warnings" option that we can disable, but does not avoid the db connection.

Workaround for find function: Implement a dummy find with an empty string.

ll_row = dw_liste.find ( "column_name = ''", 1, dw_liste.rowCount() )

Reason is that dw can distinguish between 'ss' and 'sz' but keeps the wrong row result for some reason

will result in the following error:

SQL Error

ORA-06550

PLS-0221 F-BLOB is not a procedure or is 'undefined'

ORA-06550

PL/SQL: Statement ignored

The following is the function being called:

CREATE OR REPLACE function f_blob(p_dummy in int)

RETURN blob IS

v_value blob;

BEGIN

select b into v_value from t;

return (v_value);

END;

This application crashes when one instance of the application is being run and one closes the window without stopping the 'server' ( their dll) first or when a second instance of the 'server' is trying to start up. The 'server' does detect that the chosen port is in use and gives a friendly error message. This does not stop the PowerBuilder application from crashing.

Tried the same scenario with a C# application and the friendly error message is displayed but the crash does not occur.

The underlying C MessageBox function works with various flags set. If you experiment with the flag settings, you will see that if the parent form is set to TopMost then the message box appears on top of the window if either of the following is true:

a) The handle of the parent window is provided as the argument to MessageBox, versus the null handle.

b) The message box modality flag is set to MB_SYSMODAL.

While it's never worked this way before, I think this is a bug and not an enhancement request. I can't see the current behavior being what anyone would want or expect.

Either this is a bug or there should be some kind of a utility to reformat the HTML into a human readable form.

6/15/2005: This was determined to not be a bug by Engineering. The first line of a group must follow the group header closely, they must be in the same page and can't cross the page. This will leave what ever space is left at the bottom of a page. Each page is built independently and the space left over may not be the same on all pages.

Greek data stored in varchar columns don't properly retrieve or update in PowerBuilder 10.

This happened on Windows 2000 but not with PowerBuilder 10 on XP.

I also noted that when I change the child window type to popup, I can get the focus back on the popup window once I switch the application and come back, however when I manually click on the response window without closing the popup window, the popup freezes.

Workaround: convert string to blob and blob with ANSI encoding back to string

blob bl

getcommanddde(data)

bl = Blob(data)

data = String(bl,EncodingANSI!)

-> "Foreign application won't perform DDE method or operation"

No workaround

There should at least be a property on editable columns that could control if focus could be set or not: e.g. a "displayonlyprotect" property.

From online help,

Listing the objects in a project

After you have built your project, you can display a list of objects in the project.

To list the objects in a project:

Build your project.

Select Design>List Objects from the menu bar.

The List Objects dialog box displays listing the objects that PowerBuilder placed in the executable file and the dynamic libraries it created when it built the project.

What's in the report? The report is a grid DataWindow object with the following columns:

Column Meaning

Library Name Source library that contains the object

Object Name Name of the object

Object Type Type of object

The sheet will be moved towards (clipped) at the right hand side and at the bottom there will be a gap. (using ToolBarAlignment= AlignAtLeft!)

From the odbc trace for the odbc to sqlserver connection:

b90 a88-a48 ENTER SQLPrepare

HSTMT 02511778

UCHAR * 0x01268280 [ -3] "SELECT UPPER ( missing ) FROM missing_table \ 0"

SDWORD -3

pb90 a88-a48 EXIT SQLPrepare with return code 0 (SQL_SUCCESS)

HSTMT 02511778

UCHAR * 0x01268280 [ -3] "SELECT UPPER ( missing ) FROM missing_table \ 0"

SDWORD -3

pb90 a88-a48 ENTER SQLFreeStmt

HSTMT 02511778

UWORD 1 <SQL_DROP>

For the odbc trace connection to the EAS Demo DB:

b90 904-a74 ENTER SQLPrepare

HSTMT 02511988

UCHAR * 0x01268280 [ -3] "SELECT UPPER ( missing ) FROM missing_table \ 0"

SDWORD -3

pb90 904-a74 EXIT SQLPrepare with return code -1 (SQL_ERROR)

HSTMT 02511988

UCHAR * 0x01268280 [ -3] "SELECT UPPER ( missing ) FROM missing_table \ 0"

SDWORD -3

DIAG [S0002] [Sybase][ODBC Driver][Adaptive Server Anywhere]Table 'missing_table' not found (-141)

The Transaction management doesn't work consistently with multiple components.

- SetComplete may rollback a transaction after a previous DisableCommit

- DisconnectObject returns a 32767 error with option Leave Running when idle.

This request refers to the Date PowerScript function: Syntax 2 For strings

The current usage is: Date(string)

where string is any string containing a valid date (such as January 1, 1998, or 12-31-99) that you want returned as a date

Valid dates in strings can include any combination of day (1 to 31), month (1 to 12 or the name or abbreviation of a month), and year (2 or 4 digits). PowerBuilder assumes a 4-digit number is a year. Leading zeros are optional for month and day. The month, whether a name, an abbreviation, or a number, must be in the month location specified in the system setting for a date's format. If you do not know the system setting, use the standard datatype date format yyyy-mm-dd.

The enhancement request is to have an optional format argument, eg.

Date("01/02/2004", "DD/MM/YYYY")

which would always translate the date to be the 1st of February even though some system settings may be "MM/DD/YYYY"

PBWINAPI_(INT) PBORCA_SccResetRevisionNumber

( HPBORCA hORCASession,

LPTSTR lpszLibraryName,

LPTSTR lpszEntryName,

PBORCA_TYPE otEntryType,

LPTSTR lpszRevisionNum

);

To delete the revision number in the PBL, call this function with lpszRevisionNum set to NULL. This function does not require an ORCA SCC connection.

Users typically choose the same format every time they export source. So keeping track of the user's preferred encoding format makes the dialog more efficient.

that has multiple custom interfaces. I would like to either have this

verified or refuted by Sybase. They said their older product, MapObjects,

would work with PowerBuilder.

If a pooled stateless component is deactivated and sent back to the pool without releasing the connection then it still holds a connection open on the database plus possibly table locks.

[Edit Mask Behaviors]

AutocompleteDates=no

The following four scenarios describe what happens with various inputs. The primary complaint here is that he does not want PB to make any automatic changes to the values he types into the date editmask.

Scenario 1: If user enters 00/01/0000 (or 01/00/000) in the date field and tabs out, the itemchanged event does not fire and the date field has a displayed value of 00/00/0000. But if you click back in the field the value is still the value entered. Why does PB change it to 00/00/0000? Why is 00/00/0000 considered a valid date? If it is a valid date shouldn't the itemchanged event fire and the primary buffer get the value?

Desired behavior: Don't make any automatic changes to the value entered because the AutocompleteDates=no is set. Display a datawindow validation error message and fire itemerror when tabbing off because the 00/01/0000 value is not valid.

Scenario 2: If user enters 00/01/2000 in the date field and tabs out, PB changes it to 01/01/2000 and allows it, the itemchanged event fires. But if you click back in the field it is still 00/01/2000. If this is correct behavior why isn't the value in the primary buffer changed?

Desired behavior: Don't make any automatic changes to the value entered because the AutocompleteDates=no is set. A datawindow validation message should display and the itemerror event should fire because 00/01/2000 is invalid.

Scenario 3: If user enters 00/00/2000 in the date field and tabs out, you get a datawindow validation error message and the itemerror event fires. But the value displayed in the error message is 2000-01-00 and the value in the field is 00/00/2000. The data value passed into the itemerror event is also incorrectly 2000-01-00.

Desired behavior: Display the correct error message of 2000-00-00 and pass the 2000-00-00 value into the itemerror event.

Scenario 4: If user enters 01/00/2000 in the date field and tabs out, you get a datawindow validation error message and the itemerror event fires. This behavior seems correct and the correct value is displayed in the error message and passed to the itemerror event.

*) Add DataWindow control (no object, just a control)

*) Add button and script:

dw_1.AcceptText()

*) Run app and press button (run from within IDE)

PocketBuilder will crash

Customer would like to have possibility to ommit sender name in MailMessage object. Today, we don't have a property to ommit it.

start session

scc get connect properties "w.pbw"

scc connect

scc set target "Benchmark.pbt" "outofdate exclude_checkout"

scc refresh target "full"

build project "pbexbm.pbl" "p_benchmark_pcode"

scc close

end session

no Workaround

This worked fine in previous Ansi versions of PB.

Workaround:

Change the both registry keys to AMERICAN_AMERICA.WE8MSWIN1252 to make the Oracle client convert to cp1252.

The customer has been made aware of the workaround to set DisableBind=1 or to add an explicit CAST() (with whatever Oracle function is used) to the query.

ASE: 12.5.2 on Windows 2000

When calling stored procedure to raise custom error message using SYC, only the 1st letter of the error message is retrieved. Works fine in PB 9.0.2_7509.

Instead there is a runtimeerror.

This is a regression that occurs from PowerBuilder 8 Build 10691 and PowerBuilder 9 Build 7196.

exe was compiled with a pbr file, the wmf is not included in the application exe.

It works ok with a jpg file but not a wmf file.

shared library.

When running the following command to check the build number of a shared library,

the build number is not listed.

strings libpbvm90x.so | grep Version

For the other versions of the PBVM on unix, this information is available. For example

on solaris the following will appear:

Version 9.0.1.6533

Version Inconsistencies

Version: %s

getVersion

.

.

.

Failed Distributed Service Error: E13 Could not create object of class sedcsm/n_sedcsm (70C)

From the jaguar.log:

Dec 23 10:59:25 2004: 180287-Library: 'libpbjag90x.so' for component type 'pb90'

Dec 23 10:59:25 2004: AFLIB Message: 18011/11/0: DLL lookup for 'libpbjag90x.so' failed, OS Message: '/lib/i686/libpthread.so.0: version `GLIBC_2.3.2' not found (required by /bigred1/duquette/jag/EAServer/lib/libpbjag90x.so)'

Dec 23 10:59:25 2004: AFLIB Message: 18011/11/0: DLL lookup for 'libpbjag90x.so' failed, OS Message: '/lib/i686/libpthread.so.0: version `GLIBC_2.3.2' not found (required by /bigred1/duquette/jag/EAServer/lib/libpbjag90x.so)'

Dec 23 10:59:25 2004: DynamicLibrary::lookup: af_dll_lookup (libpbjag90x.so, new_JagComponent) failed

Dec 23 10:59:25 2004: 180286-CTS_JagComponent::load: failed to load component model library

Dec 23 10:59:25 2004: 180918-CTS_Component::load: failed for component 'sedcsm_pkg/n_sedcsm'

Dec 23 10:59:25 2004: SystemException: OBJECT_NOT_EXIST (sedcsm_pkg/n_sedcsm:Home/create - @10.18.43.234)

Dec 23 11:12:30 2004: 180287-Library: 'libpbjag90x.so' for component type 'pb90'

Dec 23 11:12:30 2004: AFLIB Message: 18011/11/0: DLL lookup for 'libpbjag90x.so' failed, OS Message: '/lib/i686/libpthread.so.0: version `GLIBC_2.3.2' not found (required by /bigred1/duquette/jag/EAServer/lib/libpbjag90x.so)'

Dec 23 11:12:30 2004: AFLIB Message: 18011/11/0: DLL lookup for 'libpbjag90x.so' failed, OS Message: '/lib/i686/libpthread.so.0: version `GLIBC_2.3.2' not found (required by /bigred1/duquette/jag/EAServer/lib/libpbjag90x.so)'

Dec 23 11:12:30 2004: DynamicLibrary::lookup: af_dll_lookup (libpbjag90x.so, new_JagComponent) failed

Dec 23 11:12:30 2004: 180286-CTS_JagComponent::load: failed to load component model library

SELECT TOP :NumRows * FROM DEPARTMENT

where NumRows is a retrieval argument of type number, you get the error:

"Error -674 Statements size limit is invalid"

If you do "SELECT TOP 3 * FROM DEPARTMENT" all is fine and it works. A PB trace shows that on the retrieval argument select the painter sends "SELECT TOP 0 * FROM DEPARTMENT" to the database. This causes the size limit error becasue a 0 is invalid. On the initial send of the syntax to the database, the painter needs to do a valid substitution for the retrieval argument.

The width of header column @col is to short.

The second problem is a datetime column that has an editmask of hh:mm and a spincontrol. The field is too narrow so you can't see all of the 4 digits. When you enter valid data you can see the format is changed and when you tab off, you get a validation error. In 8.0.4 the valid data was entered correctly and you could tab off with no validation error.

The problem can be corrected in 9.0.2 by making the field wider so that you can see all 4 digits.

For ODBC driver, Sybase ASE 12.5.x fail to return output string argment greater than 255 to PB

From the trace from PB 10, it shows the following:

ce1a40): EXECUTE:

(ce1a40): EXECUTE dbo.mpb_flp_batch_label @i_printer_id = 0, @i_printer_ut_id = 804, @i_printer_type = "SAM8400D", @i_header_user = "sa", @i_client_id = "PREPNISH", @i_client_unit_id = 804, @i_parm1 = 1, @i_parm2 = 804, @i_reprint_flag = "0", @o_return_code = a OUTPUT

(ce1a40): SRV 16 #207 Invalid column name 'a'. (0 MilliSeconds)

(ce1a40): SRV 16 #207 Invalid column name 'a'. (0 MilliSeconds) (60 MilliSeconds)

(ce1a40): Error 207 (rc -1) : Invalid column name 'a'.

Using Ribo, it shows the following:

LANGUAGE Token

Status [1]: UNUSED (0x00)

Text [313]: "DECLARE @o_return_code鐆/� char(1) EXECUTE dbo.mpb_flp_batch_label @i_printer_id = 0, @i_printer_ut_id = 804, @i_printer_type = "SAM8400D", @i_header_user = "sa", @i_client_id = "PREPNISH", @i_client_unit_id = 804, @i_parm1 = 1, @i_parm2 = 804, @i_reprint_flag = "0", @o_return_code = @o_return_code鐆/� output "

Capture Record Header

Source [4]: RESPONSE (0x00000002)

EED Token

Message Number [4]: 102

Message State [1]: 1

Message Class [1]: 15

SQL State [5]: "42000"

Status [1]: NO_EED (0x00)

Transaction State [2]: TDS_NOT_IN_TRAN (0x0000)

Message Text [27]: "Incorrect syntax near '/'."

Server Name [7]: "CATALPA"

Line Number [2]: 1

EED Token

Message Number [4]: 137

Message State [1]: 2

Message Class [1]: 15

SQL State [5]: "ZZZZZ"

Status [1]: NO_EED (0x00)

Transaction State [2]: TDS_NOT_IN_TRAN (0x0000)

Message Text [42]: "Must declare variable '@o_return_code鐆'. "

The sp is called from the n_cst_label_print/of_flp_main_execute. The setup of the

arguments is done from n_cst_label_print/of_flp_register_app.

not usable by "datawindow.create(string)"

1) release 8; should be release 9;

2) edit.inputeditmode=0 is not understood by PocketBuilder (though it

exports it)

that is checked out appears to be getting overwritten anyways.

When a target is checked out and then you add a pbl to the library list, once you

run the orcascript and then reopen PB you will notice that the pbl you had added is

no longer included in the library list.

Using the following script:

start session

scc get connect properties "C:\pse\pse-90\11101366\test1.pbw"

scc set connect property logfile "C:\pse\pse-90\11101366\recompile.log"

scc set connect property logappend "FALSE"

scc connect

scc set target "C:\pse\pse-90\11101366\test1.pbt" "outofdate exclude_checkout"

scc refresh target

scc close

end session

Problem happens when using PBNative. With PVCS the following dialog appears:

Confirm Overwrite Work File

A Writable "<targetname.pbt>" Exists. Check out anyway?

If you hit no, the target file does not get overwritten. But the log file shows the following:

/6/2005 09:55 Source Management Initialization...

Scc Provider: PVCS Source Control

UserID: duquette

Project Path: /PB_11013666?PVCS Version Manager?C:\Program Files\PVCS\vm\common\SampleDB?

Aux Project Path: ?PVCS Version Manager?C:\Program Files\PVCS\vm\common\SampleDB?

Local Project Path: c:\pse\pse-90\11101366

Connection to source control established

PBORCA_SccSetTarget: c:\pse\pse-90\11101366\test20.pbt

Target settings: REFRESH OUT OF DATE | EXCLUDE CHECKOUT

Non Specific Error performing SccGetLatest()

Unable to get latest version of c:\pse\pse-90\11101366\test20.pbt from SCC. Operation cannot continue.

PBORCA_SccClose

1/6/2005 09:55 Source control terminated

If you hit yes when the Confirm Overwrite Work File, than the target file does get overwritten (even though exclude_checkout is set). The log file shows the following:

/6/2005 09:57 Source Management Initialization...

Scc Provider: PVCS Source Control

UserID: duquette

Project Path: /PB_11013666?PVCS Version Manager?C:\Program Files\PVCS\vm\common\SampleDB?

Aux Project Path: ?PVCS Version Manager?C:\Program Files\PVCS\vm\common\SampleDB?

Local Project Path: c:\pse\pse-90\11101366

Connection to source control established

PBORCA_SccSetTarget: c:\pse\pse-90\11101366\test20.pbt

Target settings: REFRESH OUT OF DATE | EXCLUDE CHECKOUT

PVCS Source Control Info: /PB_11013666/test20.pbt Checked out revision 1.0.

App Name: test20 App Lib: c:\pse\pse-90\11101366\test20.pbl

Library List:

c:\pse\pse-90\11101366\test20.pbl

PBORCA_SccRefreshTarget. Full Rebuild

PVCS Source Control Info: /PB_11013666/test20.pbg Checked out revision 1.0.

Calling cm_rebuild_application(CM_REBUILD_FULL).

PBORCA_SccClose

1/6/2005 09:57 Source control terminated

RESOLUTION: At current,"Scc set target" will use .pbt file in the scc server. It will overwrite .pbt file in the local.

It is a good logic, because "Scc set target" can only rely on the file of server. Because at most of time .pbt file does not exist in the local.

If we want use local .pbt file ,we must check in it before invoke "Scc set target".

Exception code: C0000005 ACCESS_VIOLATION

File Name: C:\WINNT\system32\MSVCR71.dll

an access violation error in the pbvm90.dll. From the project painter, the crash

occurred while 'Inspecting application objects'.

The crash handler reported the following:

xception code: C0000005 ACCESS_VIOLATION

File Name: C:\pb\pb9\Shared\PowerBuilder\PBVM90.dll

File Version: 9.0.2.7559

Fault address=10C98169 Section:Offset=01:00197169

Registers:

EAX:00000000

EBX:00B7E7B0

ECX:00000000

EDX:0012E4E4

ESI:00B7E7B0

EDI:00000000

CS:EIP:001B:10C98169

SS:ESP:0023:0012E4D8 EBP:00000006

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

Flags:00010246

Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

10C98169 0012E4D8 00B7E7B0 00000000 0012E4F8 00000000 ob_destroy_rtinst+49

10C9D779 0012E4F0 00B7E7B0 00000000 06ED260C 00B7E7B0 ob_get_obinst_system_class+39

10BE47EC 0012E520 00B7E7B0 07966890 00000000 00000001 FN_CtlCreateAll+9C

10C867C6 0012E544 0000406B 07966890 046CAB88 00000000 ob_link_project+C26

10C86DB8 0012E564 00000058 0000DAC0 046CAB88 00000001 ob_link_project+1218

10C86FB0 0012E58C 00B702BC 04390C30 07930C34 046C9B88 ob_link_project+1410

10C86D5B 0012E5B0 0000001C 0000D890 046C9B88 00000001 ob_link_project+11BB

10C86FB0 0012E5D8 00B702B5 043DA794 03152794 05FE9768 ob_link_project+1410

10C86D5B 0012E5FC 00000010 0000D1B0 05FE9768 00000001 ob_link_project+11BB

10C86FB0 0012E624 00B7029F 043D463C 03FF07D4 05FE9208 ob_link_project+1410

10C86D5B 0012E648 0000000B 0000D110 05FE9208 00000001 ob_link_project+11BB

10C86FB0 0012E670 00B7029D 043D113C 03C51360 05FE91C8 ob_link_project+1410

10C86D5B 0012E694 00000001 0000D0C0 05FE91C8 00000001 ob_link_project+11BB

10C86FB0 0012E6BC 00B7029C 043CACA4 036C5748 05FE8FE8 ob_link_project+1410

10C86D5B 0012E6E0 00000008 0000D070 05FE8FE8 00000001 ob_link_project+11BB

10C86FB0 0012E708 00B7029B 06F27BB8 0683CFF8 00C3F208 ob_link_project+1410

10C86D5B 0012E72C 00000022 00000230 00C3F208 00000001 ob_link_project+11BB

10C86FB0 0012E754 00B70007 06F23978 068336D4 02E00528 ob_link_project+1410

10C86D5B 0012E778 00000013 000001E0 02E00528 00000001 ob_link_project+11BB

10C86FB0 0012E7A0 00B70006 06F22680 06F21DA8 02E02428 ob_link_project+1410

10C86D5B 0012E7C4 00000001 00000190 02E02428 00000001 ob_link_project+11BB

10C86FB0 0012E7EC 00B70005 06F20C00 06EF23C8 02EB4A48 ob_link_project+1410

10C86D5B 0012E810 00000001 00000140 02EB4A48 00000001 ob_link_project+11BB

10C86FB0 0012E838 00B70004 00BA6324 0688E62C 00C28D28 ob_link_project+1410

10C86D5B 0012E85C 0000000F 00000050 00C28D28 00C6FC20 ob_link_project+11BB

10C83881 0012E87C 00B7E7B0 00C6FC20 00BB057C 0000002B ob_create_appl_report+C1

1080BC22 0012E898 77D46AF8 00BA907C 0012F01C 00010011 CreatePBIGeneratorFactory+5482

1080BB8B 00BB057C 108104E0 00000002 00B7D644 0007079C CreatePBIGeneratorFactory+53EB

10810500 10810560 108069B0 108069E0 10806A20 10806A30 0002:00000500 C:\pb\pb9\Shared\PowerBuilder\PBAPL90.dll

1080699F 108068E0 C0681424 56108129 000007C7 C7E80000 CreatePBIGeneratorFactory+1FF

7C8B570C 24748B56 00000000 00000000 00000000 00000000 0001:0002470C C:\WINDOWS\System32\CLBCATQ.DLL

Error: Deployment JAR initialization failed. changerequest Deployed - 2 error(s), 0 warning(s)

When they are not connected to PVCS, deployment works fine.

Instead, the internal state of the object should hold this information and simply refuse to function (return an error).

using the System.Data.SqlClient Namespace in the DW Designer, once you reopen

the profile some of the properties are missing.

file, the file is not showing up in the browser.

When you move the npbdwe100.dll to the Netscape plugins directory, it showing it

with a application/datawindow9 mime type.

new tool "Cab configuration tool " in PocketBuilder2.0-->New-->Tool--> CAB Configuration Tool

Customer is seeing values for Sessions, Last Maximum Session, Peak Maximum session increment when there is only one client session involved. They want to know why this is happening.

Workaround is to remove the backslash at the end of the project path or upgrade to latest EBF of PBNATnn.DLL.

The text file could be imported fine in PowerBuilder 9.

Also a unicode text file imported fine in PowerBuilder 10

The customer reports that they always see the error when they have more than one PBL expanded and when they go expand more PBLS. As soon as a new PBL is expanded the objects all appear with "+"s against them. The customer believes that this was not a problem in PB8.0 and consequently should be working in PB9.0.2 as well.

10/27/2005 Customer upgraded to PVCS version 8.0.2.3 (Build 662) and problem went away.

you set a filter on a child dw, pb will crash when filter() is called.

The crash handler shows the following error:

Exception code: C0000005 ACCESS_VIOLATION

File Name: C:\pb\pb10\Shared\PowerBuilder\PBDWE100.dll

File Version: 10.0.1.6052

Fault address=107023B6 Section:Offset=01:001413B6

Registers:

EAX:00000000

EBX:0302473C

ECX:00000000

EDX:00000000

ESI:00C398AC

EDI:0000189B

CS:EIP:001B:107023B6

SS:ESP:0023:0012CECC EBP:00000587

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

Flags:00010246

Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

107023B6 00000587 00000000 00000000 00000000 00000000 dwTabSortCmp+6836

There must be some timing hole in the "FocusToPreviousInstance" system function.

into a datastore.

li_FileNum = FileOpen(file_xml,StreamMode! )

iret=FileRead(li_FileNum,string_xml)

iret = ids.importstring(XML!,string_xml,1,75,1,20,1)

fail with a return code of -4.

iret = ids.importfile(XML!,file_xml)

environment structure, the osType will return sol2! when running the PBVM on

linux.

OCX does not appear correctly in the most recent builds of PB, when it worked fine in earlier builds. (pre PB 9.0.2 7534+)

Name in the application project painter, the executable does not get created.

The following error results:

---------- Deploy: Deploy of p_pb10_unc_exe

Creating executable file...

Inspecting Application Dependencies...

Inspecting Application Dependencies...

Inspecting application libraries...

Create of executable file failed

---------- Finished Deploy of p_pb10_unc_exe

With this fix applied, the binary component generated by LibraryEntryExport should be identical to the binary component generated by the library painter "export" menuitem.

This actual fix for this problem is in PBVM90.DLL, not PBORC90.DLL. New PBVM90.DLL must be deployed for this fix to be seen.

Not a problem in PB10.

Paper Orientation = Landscape

Paper Size = Legal 8 � x 14

Then doing a SaveAs(PDF!) Distill! Method. When Printing the resulting PDF File, it is not using the correct paper size. No sure this is a PB problem. When you open up the PDF file in Adobe, it is displayed in landscape, and the document properties show a page size of 8 1/2 x 14. But when you print it shows portrait and 8 1/2 x 11 as the defaults. It prints in landscape but on 8 1/2 x 11 paper.

Tested and reproduced with PB 9.0.2_7554 and 10.0.1_7554. Works fine with PB 7.0.2

The display in PB 9 and 10 for number 2.91 becomes 0,002.91 and in PB 7 becomes 2.91 correctly.

-410 Prepare statement failed or was not executed.

The pbtrace log shows the following:

(c98610): SERVER=tbone@tbone_informix9(DBI_CONNECT)

(c98610): (DBI_CURSOR_CONNECTION)

(c98610): (DBI_SPECIAL_DECIMAL)

(c98610): (DBI_SPECIAL_DOUBLE)

(c98610): PREPARE:

(c98610): execute test_proc ( 100 ) (DBI_PREPARE)

(c98610): GET AFFECTED ROWS:(DBI_GET_AFFECTED_ROWS)

(c98610): ^ 1 Rows Affected

(c98610): GET NUMBER OF COLUMNS SELECTED:(DBI_GET_SELECT_ITEMS)

(c98610): ^ 0 Columns

(c98610): EXECUTE:(DBI_DYN_EXECUTE)

(c98610): *** ERROR -410 ***(rc -1) : SQL Error -410 : Unknown error message number '-410'

(c98610): CANCEL:(DBI_CANCEL)

(c98610): DISCONNECT:(DBI_DISCONNECT)

the following error will result:

(c98610): PREPARE WITH BIND VARIABLES:

(c98610): execute test_proc ( ? )

(c98610): INT Length=0 ID=?

(c98610): *** ERROR -11116 ***(rc -1) : SQLSTATE = S1003

[Informix][Informix ODBC Driver]Invalid application buffer type.

(c98610): CANCEL:

(c98610): DISCONNECT:

no workaround

no workaround

the data appears to be getting truncated.

The table is defined as:

create table testlong ("id" number 5,0) not null, "mydata" long);

alter table testlong add (constraint pk_long_id primary key ("id"));

blob mydata

SELECTBLOB mydata

INTO :mydata

FROM testlong

WHERE id = 1 ;

XP platform as described by CR 340943 and Release Bulletin PowerBuilder Enterprise 10.0.1 :

4.2 Window sizing change or change the solution of CR 340943.

The solution of CR 340943 has been modified.

This is undoubtedly because the PocketPC & SmartPhone menu handling is with AYGSHELL functions that don't exist on the "bare" WinCE platforms.

table1 has columns primekey and column_a

table2 has columns primekey and column_b

After running the code below on a PocketPC and checking the syntax generated, you will see that the datawindow column name is table1_column_b rather than table2_column_b as it should be.

the following sql error appears when executing the stored procedure:

Can't use the OUTPUT option when passing a constant to a stored procedure

reate PROCEDURE dbo.sp_test

@test_in tinyint,

@test_out tinyint OUTPUT

AS

BEGIN

SELECT @test_out = @test_in * 2

END

Text Color never changes for group box in StyleLowered! in Windows XP only.

generate a web dw, the column headings will display as follows on Netscape 7.2:

Department ID Department Name Manager ID

The xml that is generated in the _tmp directory is:

<band_header row="0">

<dept_id_t>Department&nbsp;ID</dept_id_t>

<dept_name_t>Department&nbsp;Name</dept_name_t>

<dept_head_id_t>Manager&nbsp;ID</dept_head_id_t>

</band_header>

Workaround: Use an other ODBC driver ( for instance "ODBC DATADIRECT 4.x SQL Server" driver) or the Native PB driver.

Another problem is that pocketpowerbuilder crashes when retrieving data in

tables with timestamp filled in (even when number of rows is low, 200 for

example)

When setting the timestamp null, the retrieve works fine.

The browser on the Web Generation property tab is set to Internet Explorer 4.0

datasource is a stored procedure and the stored procedure name has spaces in it,

the following error will result:

Cannot create Datawindow

SQLSTATE=42000

Microsoft OLEDB Provider for SQL Server

Line 1: Incorrect syntax near 'Expensive'

ASE 12.5.2 on Windows 2000 SP4

DBSM: SYC

Works ok with PB 9.0.2_7578 and 9.0.2_7544

dw.OLEActivate() does not invoke MS-Word when reading text column that contains a .doc as content. It seems that the Unicode factor in PB 10.0.1 is causing this issue to happen.

using Quick Select datasource, if you select a table that has a column or columns of data type bit, those columns do not show up in the list when the table is selected.

The columns will show up in the list if you select the Sql Select datasource.

syntax in the DB painter, the syntax will return the following when a table has

a column or columns of bit:

CREATE TABLE dbo.titleauthor (au_id ????? NOT NULL , title_id ????? NOT NULL , au_ord tinyint , royaltyper int , CONSTRAINT UPKCL_taind PRIMARY KEY (au_id, title_id) , CONSTRAINT FK__titleauth__au_id__0519C6AF FOREIGN KEY (au_id ) REFERENCES dbo.authors , CONSTRAINT FK__titleauth__title__060DEAE8 FOREIGN KEY (title_id ) REFERENCES dbo.titles ) ;

OS: Windows XP SP1 and SP2

When editing a window that has a ChartFX OCX control on it, PB hangs and locks the machine. This issue happens in XP only. Works fine in Win2000. Also works fine with PB 9.0.2_7509 on Windows XP.

where sorting and filtering were done. PB application is running on Citrix and using uniprint version 5.0 to convert a normal print job to a Adobe pdf file.

Using dw.print() and messagebox appears saying "Printing 1 of 4" and then the

application disappears.

No Dr. Watson dump is generated.

xception code: C0000005 ACCESS_VIOLATION

File Name: C:\WINNT\system32\ntdll.dll

File Version: 5.00.2195.6899

Fault address=77FCCA95 Section:Offset=03:00000A95

Registers:

EAX:030F01A0

EBX:00000005

ECX:7FFDE000

EDX:030F0608

ESI:FFFFFFF9

EDI:030F0000

CS:EIP:001B:77FCCA95

SS:ESP:0023:0012D4EC EBP:0012D6B8

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

Flags:00000297

Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

77FCCA95 0012D6B8 030F0000 00000000 00000020 00000000 RtlZeroHeap+1ACD

02CC7A67 0012D6D8 030F1E90 030F1E90 02CF00E8 02CF0000 0001:00006A67 C:\WINNT\system32\spool\DRIVERS\W32X86\3\acpdf209.dll

02CC894E 0012D710 030F1E90 02CF0138 00000000 00000000 0001:0000794E C:\WINNT\system32\spool\DRIVERS\W32X86\3\acpdf209.dll

02CC86DB 0012D764 02CF0000 02CF00E8 02CF010C 02CF0138 0001:000076DB C:\WINNT\system32\spool\DRIVERS\W32X86\3\acpdf209.dll

77F66C09 0012D7A8 0012E00C 0012D7C4 00000004 00512D70 GdiPrinterThunk+4AB

77E4178B 0012DFFC 0012E00C 00000038 00000038 00000017 DdeDisconnectList+1296

77F9FF57 0012E074 672102D7 B40402D3 00000005 FFFFFFFE RtlCreateTimer+EA

77E59FDD 0012E110 672102D7 00193BAC 0000000A 0012E224 CopyRect+13DE

77E42156 0012E148 672102D7 02AFD008 FFFFFFFF 0012E224 TabbedTextOutA+25

77E22BFB 0012E17C 672102D7 02AFD008 FFFFFFFF 0012E224 GetScrollRange+4E

1161F313 0287B13C 00000000 00000000 00030190 00000000 0001:0011E313 d:\Sybase\Shared\PowerBuilder\PBDWE90.dll

0287B944 00776470 00000000 00000000 00000000 00000000 0000:00000000

RESOLUTION: The problem is that having a dotted line, followed by a solid line confuses UniPrint and causes the application to crash. The error is not specific to PB.

ODBC, the following error will result in the Jaguar.log file:

cm__odbc_error: SQLError: -908, SQLState: 60 [Merant][ODBC driver][20101]

Attempt to connect to database server failed

no workaround

After I entered a trace file name and click OK, the next time I restart PocketBuilder, the trace file name field will be empty again.

of a psr report, when you click in the vertical scroll bar area the psr report

does not scroll down or up.

and there is no space after the array.

For example for a N-up datawindow:

ls_Ret = dw_1.Modify( "col_2.Width='100~tIF(mycol[1]=1,100,400)'" ) //fails

ls_Ret = dw_1.Modify( "col_2.Width='100~tIF(mycol[1] =1,100,400)'" ) //succeeds

- Can't use the OUTPUT option when passing a constant to a stored procedure

- incorrect syntax near 'int'

- Must declare variable '@rv'

The Read/Write bytecount is an integer - restricting the amounts to +/-32KB.

These should be either long or ulong.

getting an access violation in pbole100.dll.

The application is connected to mssql using oledb.

A user dump provided the following:

00 0012bfdc 14f35f3f 033eb3f8 00000000 00000000 pbole100!PBOLEDB_COMMAND::CreateInputParmBinding(struct DBI_INPUTBIND * pDBIInputBind = <Memory access error>, unsigned long i = <Memory access error>, int bReused = <Memory access error>)+0xacd (FPO: [EBP 0x00000000] [3,36,0]) (CONV: thiscall) [e:\pb10\db\oledb\command.cpp @ 6196]

01 0012c008 14f04cf1 00000001 0291afe4 036278b8 pbole100!PBOLEDB_COMMAND::BindWithInputParameters(int bFree = <Memory access error>)+0x18f (FPO: [EBP 0x00000000] [1,3,0]) (CONV: thiscall) [e:\pb10\db\oledb\command.cpp @ 5668]

Desired Change: Honor NLS_LANG Environment Variables settings and Windows Registry Settings.

The frame and the sheets all contain fairly sizeable menu's.

To work around the issue replace the menu of the deactivated sheets by a small dummy menu

by using the changemenu function in the deactivate and activate events of the sheets.

If necessary also write some code to preserve the state of the menu.

I also tried shrinking the width (makes it move over in "preview" mode) and set an expression for the width back to 233. But the end result is the same - I can not flush the object to the far left!

a) customer states that the incoming message ID is always zero.

b) when the message sent confirmation is requested (from the telco) the message we get is simply "Message Sent", whereas the messaging application displays "Message Sent" as the subject then the body being "The message was successfully sent to 123456789"

I don't know whether this is *generated* by the phones messaging application or whether this is in the body or other property someplace.

PER DEVELOPMENT: Incorrect usage:

//This won't work

l_task = l_root.GetChildElement ( 'Tasks' )

It should be

l_task = l_root.GetChildElement ( 'Tasks' , '', 'http://schemas.microsoft.com/project')

Because URI is not empty in the test xml, so the user must use another GetChildElement syntax to get the element.

foreign key, pb simply shuts down.

There is no error given in the odbc trace and the crash handler only reports the following:

---Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

6C13DC0F 0012AA4C 00000000 00000000 00010000 00200000 CLI_utlCheckIfBindNeeded+3FABF

RESOLUTION: Verify that expanding foreign key works ok with DB2 v7.2 fixpack 13 and PB 10.0.1. Customer upgraded to DB2 version fixpack 7 and it also works.

When entering the decimal point using the numeric keyboard in a stringmask, the decimal point gets entered twice or as ,. depending on the language settings.

Further, PB isn't going to write to any PBDs anyway during the compile, it shouldn't require that it be writeable.

of a long datatype into a blob variable results in a access violation in pbshr100.dll.

Problem happens using the o84 driver. Works ok using the o90 driver and using

selectblob of type long to a long variable.

From the user.dump generated the following is the result:

FAULTING_IP:

pbshr100!pbstg_huge_memcpy+19 [e:\pb10\shared\pbshr\pbstg.cpp @ 116]

10b7d3b9 8801 mov [ecx],al

EXCEPTION_RECORD: ffffffff -- (.exr ffffffffffffffff)

ExceptionAddress: 10b7d3b9 (pbshr100!pbstg_huge_memcpy+0x00000019)

ExceptionCode: c0000005 (Access violation)

ExceptionFlags: 00000000

NumberParameters: 2

Parameter[0]: 00000001

Parameter[1]: 00cb1000

Attempt to write to address 00cb1000

0xc0000005 - The instruction at "0x%08lx" referenced memory at "0x%08lx". The memory could not be "%s".

full screen when I create a new VGA window (exported window attached).

a dropdowndatawindow, if you drag the pb application to the secondary monitor and

then expand the dddw, it will display in the primary monitor.

[Edit Mask Behaviors]

AutocompleteDates=no

were fixed. This is one more similar behavior reported by the same customer.

If you enter a date with a 0000 year (01/01/0000) and tab off, PB accepts the date as valid and the itemchanged fires. But this is an invalid date, and instead the itemerror event and appropriate datawindow validation error message should occur.

From the repro. sample.

With HyperThreading ON - around 1 min to finish.

With HyperThreading OFF - take 1 - 2 seconds to finish

The workaround is for the user to explicitly code the following in PB.INI:

[library]

SccMultiCheckout=0 | 1

If the above PB.INI setting does not exist, we issue GetProcAddress for SccIsMultiCheckoutEnabled. If this is a valid exported function, we call it.

The Serena SCC logging utility exports SccIsMultiCheckoutEnabled, but there is no guarantee that the true SCC provider that it is connect to exports the function also. To avoid a GPF, explicitly set [library] SccMultiCheckout=0 in PB.INI.

EAServer to crash under load testing.

The last line in the Jaguar.log is:

Exception info: Unknown error, problem with SoapClient

When the pb component continuously calls the web service, the response time appears to be getting slower between receiving the Soap response and closing the Soap connection.

Several interesting dumps to look at. (See testcase for details).

In particular from cisnt81 Crash 03-07-05 12-13-36-15PM.zip:

PID-752_JAGSRV.EXE_1st_chance_AccessViolation_mni_09AC_2005-03-07_14-06-21-765_02F0.dmp

# ChildEBP RetAddr Args to Child

00 0b1bfc1c 77f82a8c 00230000 00230778 00000005 NTDLL!RtlpInterlockedPopEntrySList+0x16 (FPO: [0,2,0])

01 0b1bfc4c 77fcc1d0 00230778 77f82ad0 05494e70 NTDLL!RtlpAllocateFromHeapLookaside+0x40 (FPO: [Non-Fpo])

02 0b1bfe24 78001532 00230000 00000000 00000020 NTDLL!RtlAllocateHeap+0x12b (FPO: [Non-Fpo])

03 0b1bfe64 780014cf 00000020 780014b8 00000020 msvcrt!_heap_alloc+0xeb

04 0b1bfe6c 780014b8 00000020 00000000 00d925ac msvcrt!_nh_malloc+0x10 (FPO: [2,0,0])

05 0b1bfe78 00d925ac 00000020 0b1bffa4 0b1bfea0 msvcrt!malloc+0xf (FPO: [1,0,0])

06 0b1bfe88 00d91469 11a2bc1c 00000058 11a2bc00 libjtml!tml_cond_alloc(void ** cvpp = 0x11a2bc1c)+0x1c (CONV: stdcall) [Y:\calm\conn\itg\tmlib\generic\src\win32_synch.c @ 513]

07 0b1bfea0 00d915c7 0b1bfeac 00000000 00d92dcc libjtml!tml_thread_alloc(void ** threadp = 0x0b1bfeac)+0x79 (CONV: stdcall) [Y:\calm\conn\itg\tmlib\generic\src\tml_thread.c @ 26]

08 0b1bfeb4 00e5d161 00000000 00e5d17e 00000000 libjtml!tml_thread_create(void * threadp = 0x00000000, <function> * startfunc = 0x00e5d17e, void * arg = 0x00000000)+0x1b (CONV: stdcall) [Y:\calm\conn\itg\tmlib\generic\src\tml_thread.c @ 129]

09 0b1bfecc 00e5d0fd 01fd4f38 0b1bfee8 00e5cfec libjtcl!new_background_thread(void)+0x37 (CONV: stdcall) [Y:\calm\conn\itg\netlib\generic\iomodel\td_background.c @ 487]

0a 0b1bfed8 00e5cfec 01fd4f38 01fd4f38 0b1bfef8 libjtcl!enqueue_work(struct work_struct * work = 0x01fd4f38)+0x91 (CONV: stdcall) [Y:\calm\conn\itg\netlib\generic\iomodel\td_background.c @ 464]

0b 0b1bfee8 00e5cf20 00e5ec1b 050fd230 0b1bff54 libjtcl!background(<function> * function = 0x00e5ec1b, void * args = 0x050fd230)+0x32 (CONV: stdcall) [Y:\calm\conn\itg\netlib\generic\iomodel\td_background.c @ 214]

0c 0b1bfef8 00e5ed12 00e5ec1b 050fd230 0b1bff1c libjtcl!netp_background(void)+0x10 (CONV: stdcall) [Y:\calm\conn\itg\netlib\generic\iomodel\td_background.c @ 77]

0d 0b1bff54 00e5d253 050fd230 00e5ec1b 01fd4f38 libjtcl!netp_accept_mp_sync(void)+0xf7 (CONV: stdcall) [Y:\calm\conn\itg\netlib\generic\iomodel\td_serv.c @ 246]

0e 0b1bff6c 00d92ba7 00000000 05494e70 0b1bffb4 libjtcl!background_thread(void * unused = 0x00000000)+0xd5 (CONV: stdcall) [Y:\calm\conn\itg\netlib\generic\iomodel\td_background.c @ 287]

0f 0b1bff7c 780085bc 05494e70 77f82ad0 77fcc3d5 libjtml!tml__thread_start(void * threadp = 0x05494e70)+0xa7 (CONV: stdcall) [Y:\calm\conn\itg\tmlib\generic\src\win32_thread.c @ 104]

10 0b1bffb4 7c57b388 11a1a5b8 77f82ad0 77fcc3d5 msvcrt!_endthreadex+0xc1

11 0b1bffec 00000000 78008532 11a1a5b8 00000000 KERNEL32!BaseThreadStart+0x52 (FPO: [Non-Fpo])

From PID-752_JAGSRV.EXE_2nd_chance_UnknownException_full_09AC_2005-03-07_14-06-25-156_02F0.dmp:

# ChildEBP RetAddr Args to Child

00 06f4ecd4 00d22f49 00000000 00000001 00000000 KERNEL32!RaiseException+0x56 (FPO: [Non-Fpo])

01 06f4ecec 00d22f21 06f4ed44 00ee584e 00000000 libjcomn!com__abort+0x24 (CONV: stdcall) [Y:\calm\conn\itg\comnlib\nt386\src\dbgfuncs.c @ 230]

02 06f4ecf4 00ee584e 00000000 00f56aa4 000002bf libjcomn!com_chkptr+0x4c (CONV: stdcall) [Y:\calm\conn\itg\comnlib\nt386\src\dbgfuncs.c @ 188]

03 06f4ed44 014cb415 00000000 055a5ca0 00000022 libjct!ct_callback+0x15e (CONV: stdcall) [Y:\calm\conn\itg\ctlib\generic\ct\ctcback.c @ 705]

04 06f4eda0 004ef851 016aa9c8 054cf7f0 11a04d20 libjcm!cm__release_connection+0x4b5 (CONV: stdcall) [Y:\calm\conn\itg\jagsrv\generic\jagcm\cmrelconnection.c @ 260]

05 06f4edc8 00437a6d 016aa9c8 054cf7f0 11a04d20 libjdispatch!JagCmLink::cm__release_connection+0x26 (CONV: stdcall) [Y:\calm\conn\itg\jagsrv\generic\dispatch\JagCmLink.cc @ 199]

06 06f4edf0 00437c6f 016aa978 06f4ee1c 0041f778 libjdispatch!CDBResource::~CDBResource+0xbf (CONV: thiscall) [Y:\calm\conn\itg\jagsrv\generic\dispatch\DBResource.cc @ 161]

07 06f4edfc 0041f778 00000001 0aa2469c 0171107c libjdispatch!CDBResource::`scalar deleting destructor'+0xf (CONV: thiscall)

08 06f4ee1c 0041f024 0171107c 06f4f02c 00421d75 libjdispatch!CTS_Container::ReleaseConnList+0x63 (CONV: thiscall) [Y:\calm\conn\itg\jagsrv\generic\dispatch\CTS_Container.cc @ 562]

09 06f4ee28 00421d75 11a0a388 00000000 7ffb001c libjdispatch!CTS_Container::Deactivate+0x19 (CONV: thiscall) [Y:\calm\conn\itg\jagsrv\generic\dispatch\CTS_Container.cc @ 141]

0a 06f4f02c 00426019 06f4f9d0 00484d39 11a0a388 libjdispatch!ActualInvoke::invoke+0xc8e (CONV: stdcall) [Y:\calm\conn\itg\jagsrv\generic\dispatch\CTS_Object.cc @ 1360]

0b 06f4fb14 00441e47 01711584 028bb2f0 01711640 libjdispatch!CTS_Object::invoke+0x1d5f (CONV: stdcall) [Y:\calm\conn\itg\jagsrv\generic\dispatch\CTS_Object.cc @ 3549]

0c 06f4fe5c 004431dd 028bb2f0 028bb2f0 06f4fe80 libjdispatch!IIOP_messageHandler+0x1126 (CONV: stdcall) [Y:\calm\conn\itg\jagsrv\generic\dispatch\IIOPHandlers.cc @ 974]

0d 06f4fe6c 00dfeb90 028bb2f0 06f4fe88 028bb2f0 libjdispatch!IIOP_connectHandler+0x1d (CONV: stdcall) [Y:\calm\conn\itg\jagsrv\generic\dispatch\IIOPHandlers.cc @ 1563]

0e 06f4fe80 00dc2ea7 06f4fec0 00dc2e28 028bb2f0 libjsrv!srv__spawnfunc+0x41 (CONV: stdcall) [Y:\calm\conn\itg\srvlib\generic\src\procutil.c @ 994]

0f 06f4fe88 00dc2e28 028bb2f0 004431c0 028bb2f0 libjsrv!srv__bindspawn+0x74 (CONV: stdcall) [Y:\calm\conn\itg\srvlib\generic\src\conservice.c @ 43]

10 06f4fec0 00dc3077 11bebf38 050e98c8 00000000 libjsrv!srv__protocol_connect+0x268 (CONV: stdcall) [Y:\calm\conn\itg\srvlib\generic\src\conservice.c @ 155]

11 06f4fef4 00e5ed24 01fcd300 11bebf38 06f4ff10 libjsrv!srv__accept_upcall+0x1cc (CONV: stdcall) [Y:\calm\conn\itg\srvlib\generic\src\conservice.c @ 209]

12 06f4ff54 00e5d253 050fd230 00e5ec1b 01fd4f38 libjtcl!netp_accept_mp_sync+0x109 (CONV: stdcall) [Y:\calm\conn\itg\netlib\generic\iomodel\td_serv.c @ 248]

13 06f4ff6c 00d92ba7 00000000 0548df50 06f4ffb4 libjtcl!background_thread+0xd5 (CONV: stdcall) [Y:\calm\conn\itg\netlib\generic\iomodel\td_background.c @ 287]

connect to a sqlserver, the following error will result:

SQLSTATE - 08S01

Microsoft OLE DB Provider for SQL Server

[DBNETLIB][ConnectionWrite (send()).]General network error.

When generating the executable, a db connection is needed. The code in the application has a soap connection and embedded sql statement. Problem happens using either oledb

or odbc.

Adobe 7 Print driver, pb will crash.

The access violation appears to happen in the AD2KReGP.dll. But if you add a document name under the Print Specification tab on the DW properties, PB doesn't crash. The

following is the output of the crash handler:

Exception code: C0000005 ACCESS_VIOLATION

File Name: C:\WINDOWS\System32\spool\DRIVERS\W32X86\3\AD2KReGP.DLL

File Version: 7, 0, 0, 0

Fault address=70001CC7 Section:Offset=01:00000CC7

Registers:

EAX:00000000

EBX:00000000

ECX:77DD193B

EDX:00000000

ESI:022440C8

EDI:022440C8

CS:EIP:001B:70001CC7

SS:ESP:0023:0012C8A0 EBP:0012D0F8

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

Flags:00010246

Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

70001CC7 0012D0F8 022445A8 022440C8 0012D118 5E163870 0001:00000CC7 C:\WINDOWS\System32\spool\DRIVERS\W32X86\3\AD2KReGP.DLL

700024CA 0012DD48 022445A8 001E43A8 00000001 00000000 0001:000014CA C:\WINDOWS\System32\spool\DRIVERS\W32X86\3\AD2KReGP.DLL

5E1811C5 0012DD74 001F5C5C 001E65E0 00000001 00000000 0001:000201C5 C:\WINDOWS\System32\spool\DRIVERS\W32X86\3\PSCRIPT5.DLL

5E17BB00 0012DEB0 00000032 00000001 0012E778 001E65E0 0001:0001AB00 C:\WINDOWS\System32\spool\DRIVERS\W32X86\3\PSCRIPT5.DLL

5E177951 0012DF18 00000000 0012DF30 00000004 001D5320 0001:00016951 C:\WINDOWS\System32\spool\DRIVERS\W32X86\3\PSCRIPT5.DLL

77D6E16B 0012E768 0012E778 00000018 00000018 00000021 CreateSystemThreads+2C3

Only happens on certain machines.

On other machines the problem appears with object names longer than 186 characters.

Power Builder 9.0.1.7151 is all OK, but in Version 9.0.2.7554 and pb 10.0.1.6044 is other behaviour. Customer sent repro. Test1 : Press key sequence : minus 1 TAB. Test2 : Press key sequence : minus Backspace 1.

A point of interest; there are other objects in the datawindow; vertical lines between the fields, and horizontal lines at the bottom. These line objects use the rowheight() function in expressions to position them correctly. These lines are positioned correctly and you can see that the datawindow did apparently calculate the y position that the wide field should start at correctly as there is precisly the correct amount of room allocated at the bottom of the largest autosized field for the wide field. It's just that it isn't positioned at the bottom where it should be, it's up higher on top of other fields.

For example, the Motorola MPx device.

Definately a phone, PPC-2003-SE

The customer's application was migrated from PB8.0.4 and uses text columns to store ObjectData from an OLE Control (which embeds MS-Word documents). The ObjectData from an OLE control gives a blob which may contain non-printable characters. When they migrated the application to PB10.x and started using the OLE DB driver (MSS is no longer supported in PB10) the data from the server comes back garbled.

Sybase introduced a DBParm called BinTxtBlob for the SYC driver which permits one to read the contents of an ASE "text" column as binary rather than a Unicode string (CR 379643). We are asking for a similar fix for the OLE DB driver.

The CR Reverted the behavior of the PBSYB050 to work like it did in PowerBuilder 4, However Maintained the new Functionality of the PBSYCxx database driver.

The Customer would like to see the PBSYCxx drive behave in the same manner as the PBSYB50 driver does.

the preview pane is set in the default layout, PB will crash in the pbshr100.dll.

PB will also crash if you open the crosstab dw and then select preview (if its

not set in the default).

I opened the csv file as a binary file in Visual C++, and I see the problem. All the data values are enclosed in double quotes and are comma separated, but 2 data values have included within the quotes, 2 binary zero characters. The first one coincides with where PB truncates the ImportFile. So PB apparently thinks that it's done when it encounters the binary zero characters. Since the customer can't change how their csv file is generated and since other programs like Excel and Notepad have no problem reading the entire file, they are looking for a PB fix to the problem.

If you open the csv file in Notepad, Notepad apparently ignores the binary zero character and if you save the file even with no changes, the binary zero characters do not get written out, and the resulting csv file then works fine importing into PB.

For example, in MySql the table is defined as:

+---------------+--------------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+---------------+--------------+------+-----+---------+-------+

| Test_Id | bigint(20) | | PRI | 0 | |

| Test_Name | varchar(100) | YES | | NULL | |

| Test_Date | date | YES | | NULL | |

| Test_Time | time | YES | | NULL | |

| Test_Currency | decimal(8,2) | YES | | NULL | |

| Test_Text | text | YES | | NULL | |

| Test_Integer | int(11) | YES | | NULL | |

| Test_Datetime | datetime | YES | | NULL | |

| Test_Varchar | varchar(255) | YES | | NULL | |

| Test_Tinyint | tinyint(4) | YES | | NULL | |

+---------------+--------------+------+-----+---------+-------+

After you create the datawindow in PB, the column specification is listed as:

+---------------+--------------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+---------------+--------------+------+-----+---------+-------+

| Test_Id | decimal(0) | | PRI | 0 | |

| Test_Name | char(0) | YES | | NULL | |

| Test_Date | date | YES | | NULL | |

| Test_Time | time | YES | | NULL | |

| Test_Currency | decimal(2) | YES | | NULL | |

| Test_Text | char(0) | YES | | NULL | |

| Test_Integer | long | YES | | NULL | |

| Test_Datetime | datetime | YES | | NULL | |

| Test_Varchar | char(0) | YES | | NULL | |

| Test_Tinyint | long | YES | | NULL | |

+---------------+--------------+------+-----+---------+-------+

If the "Don't Optimize Column Width" is checked in the ODBC DSN, then

then when a datawindow is created the column specification will look like this:

+---------------+--------------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+---------------+--------------+------+-----+---------+-------+

| Test_Id | decimal(0) | | PRI | 0 | |

| Test_Name | char(100) | YES | | NULL | |

| Test_Date | date | YES | | NULL | |

| Test_Time | time | YES | | NULL | |

| Test_Currency | decimal(2) | YES | | NULL | |

| Test_Text | char(32766) | YES | | NULL | |

| Test_Integer | long | YES | | NULL | |

| Test_Datetime | datetime | YES | | NULL | |

| Test_Varchar | char(255) | YES | | NULL | |

| Test_Tinyint | long | YES | | NULL | |

+---------------+--------------+------+-----+---------+-------+

That still leaves a problem for datatype mappings of bigint,decimal,int,Tinyint and text.

MySQL defines the datatypes as follows: (file:///C:/mysql/Docs/manual.html#Column_types)

Tinyint - A very small integer. The signed range is -128 to 127. The unsigned range is 0 to 255.

BigInt - A large integer. The signed range is -9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615.

Int - A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295.

Text - A BLOB or TEXT column with a maximum length of 65535 (2^16 - 1) characters

Decimal - An unpacked floating-point number

RESOLUTION: Problem is covered under Cr's 354613 and 359632.

This seems like a pretty easy fix to make that would have a big impact on the usability of Web apps in PB and DW.NET.

differently.

The application uses a third party dll call pdfenc32.dll and creates a bar code bitmap. The bitmap is a different image in PB 10 than PB8.

The application calls some external functions from the pdfenc32.dll. It uses the pdfobj

structure. The structure gets populated differently in PB 10 than PB 8. The following functions that uses the pdfobj structure are MakeMemoryObject, MakeFilenameObject, PDFEncode and PDFMakeImage. PDFMakeImage function actually writes the bitmap to the file.

RESOLUTION: The solution is to use BLOB type instead of String type in MakeMemoryObject.

Workaround:

declare extern function:

FUNCTION boolean MakeMemoryObject (ref pdfobj lpObj, int ioDirection, ref Blob lpBase) LIBRARY "PDFENC32.DLL" alias for "MakeMemoryObject;Ansi"

string numstr

long lDpiScale

Blob Blb

Blb = Blob("123456", EncodingANSI!)

lDpiScale = (300 * 65536) + (3)

Pdfobj objin,objout

MakeMemoryObject(objIn, 1, Blb)

MakeFilenameObject(objOut, 2, "barcode.bmp")

PDFEncode(objIn, len(Blb))

PDFOutputAsDIBFile(lDpiScale, 0)

PDFMakeImage(objOut, 0)

return

This is dupe of CR 213368 and the request it to take another look at that behavior.

The only way I was able to use a different dynamicdescriptionarea than SQLDA was to code:

dynamicdescriptionarea my_sqlda

my_sqlda = create dynamicdescriptionarea

The above has limited uses since you are not able to customize the functionality of the dynamicdescriptionarea.

Worked fine with PB 8.0.4_10784

The edit mask control suppresses the decimal point when typing negative values, when using mask ###.00

running a PB SoapClient, it causes a soapexception.

Using the Weblogic MedRec sample and the FindPatientBySSn() function to populate the

__patientws structure. The structure isn't getting populated.

The proxy is generated using the WSDL location of: http://localhost:7001/ws_medrec/MedRecWebServices?WSDL

When the proxy is generated with the hardcode location it appeared to work ok:

file://C:\soft\bea\weblogic81\samples\server\medrec\src\clients\CSharpClient\Web References\localhost\MedRecWebServices.wsdl

From the Jaguar.log file, the retrieval argument doesn't appear to be getting passed in:

Mar 31 16:25:24 2005: HTMLDW: Entering SetSelfLink('test.jsp','')

Mar 31 16:25:24 2005: HTMLDW: Exiting SetSelfLink() = ''

In the datawindow painter, datawindow.htmlgen.selflinkargs is set to

projectid='projectid[1]'

PB 10.0.1 O90 interfaces can not display/insert UTF-16 data from/to NCHAR/NVARCHAR2 columns.

The Save event of the OLE object does not fire with Excel although it works with MSWord.

But now in builds 7509 and above, they can no longer switch to another application while the PB app is running. Something has changed in PB and it is not relinquishing the cpu as it used to.

The testcase simulates what they are doing. It opens a response window in a loop, the reponse window closes itself once it is open. In build 6053 while the PB app is running it is easy to switch to another app and work in it. But in build 7618, it is very difficult to switch to another app, you have to be very persistent and click many times before a click might be accepted. It's not an acceptable working environment. Adding in a yield in the main loop helps, but not much, it was much better in build 6053.

Engineering says this was an intentional change. External datawindows can't be retrieved so the retrievestart event should not fire. This change was made in conjunction with some others to improve performance.

SaveAs popup box when you optionally omit the filename.

If you use dw_1.saveas("",CSV!, True, EncodingANSI!), the SaveAs popup

box will appear. The saveas type and colheading properties are passed to the Saveas

popup box but not the encoding type.

However, it is observed that the ASCII type String function fail if change the User Regional Locale (currency , date format etc)to "US English" in DBCS OS (e.g. Tradtion Chinese W2K , XP).

then returns are still catched instead of going to an edit control.

Workaround

===========

Deploy the pages one at a time

- Regional settings Norwegian (BBokmal)

- Build 7578 or later (works in 7554)

- AutocompleteDates=no PB.ini setting

What is happening is that the last row you see on the first page is row 66, then on the next page you see the group column as you should, but the first row is 68. Row 67 is not displayed. Row 68 is the correct first row on page 2, and row 67 should be the last row displayed on page 1. But I think PB runs out of room because of the becasue of the y expression in the data colun, perhaps not taking it into consideration when calculating how many rows can be displayed per row... It's only off by one row, and there are several group columns displayed on page 1, so it's only one that's not being considered.

From Engineering: This can't be fixed. The reason is that an expression containing FirstRowOnPage is used to determine a rows y position. PB has to make multiple passes on the datawindow to display it properly, the first pass is to do paginating, where it calculates how many pages the dw will use, and the position of the every element in the DW.(It based on X, Y, Height & Width in property window). In the paginating process, the describe("DataWindow.FirstRowOnPage" ) is useless as the rows on each page are not known yet, so the default value of 1 is used. But then later during the actual display the correct FirstRowOnPage value is known, and the y position of a row may be changed. This conflicts with the pagination calculations and the result is the missing row. The recommendation is to use a group datawindow, a much easier way to get that type of display.

have buttons for navigation on a datawindow, those buttons don't appear to work when you generate html format. They appear to work ok when generating xhtml or xml.

In the lower left hand corner of browser the following error appears when you click on the yield sign:

Line: 9

char: 1

Error: Object doesn't support this property or method

Code: 0

The same testcase works ok using the PBVM 9 (build 7509) on solaris. Same testcase works ok on windows using PB 10.2 (build 8006).

ll_rv = table_datastore.settransobject(SQLCA)

ll_rv = table_datastore.setchanges(table_data)

if ll_rv = 1 then

ll_rv = table_datastore.update()

if ll_rv = 1 then

txnsrv.setcomplete()

else

txnsrv.setabort()

end if

else

txnsrv.setabort()

end if

It is observed on PB9 and PB10, under certain condition, the Composite datawindows cannot 100% display a Nested Report of Grid Style. When the problem happen, the last line of the data item may be totally disappear or be partially shown.

The failure point is pbvm90!fnSpace. The last know call without a memory access

error is pbsys90!PB_SysSwapAndRun.

string ls_string

ls_string = space (425853547) // will work on my machine

ls_string = space(536854528) // will crash PB on my machine

ls_string = space(2147483647) // maximum value

Cannot create new connection because in manual or distributed transaction mode

SQLOLEDB doesn't support concurrent commands like nested esql selects on the same transaction.

This is a driver limitation, see MS knowledge base article Q272358.

When switching to this driver a second transaction may be needed for such statements.

A crash can occur after accessing the returntype property of

a local variable scriptdefintion object

resultset, the char columns field length is increased by 1.

datastore ds, dt

resultset rs

ds = create datastore

dt = create datastore

ds.dataobject = "d_cust"

ds.generateresultset(rs)

mle_1.text = ds.Describe("DataWindow.Syntax")

dt = create datastore

dt.createfrom(rs)

mle_2.text = dt.Describe("DataWindow.Syntax")

PB Clients. PB Component inside just perform a dynamic call to Oracle stored procedure.

There no problem even with a lot multiple PB Client call when each Client only submit one

proceudre call. Problem will occur when each PB Client submit two separate different

procedure calls

Environ: PK 201 and 202 (eng) and ASA 9.0.2.3044

Sample Program: DWExam and DBPaint (code examples)

Problem:

When the phone is in "flight mode" - everything works hunky dorey.

When the phone is enabled - connecting to the database waits forever.

Looking at the running processes I see that dbsrv9.exe is NOT running.

This is very very odd because:

a) same phone as the Orange SPV M2000 which we do a lot of testing with.

b) there is still plenty of free memory and process slots

Consultlant provide a repro. sample and suspect that there is potential memory leakage

causing the crash. It will either core dump / fail with allocVM() in PBHeap.

which forces a rebuild of the crosstab, PB currently propagates the properties

of the first column to the new column or row.

Customer would like to see that when a new column or row is added that the

properties DON'T change for any of the columns or rows on a crosstab.

of several tables, the Crosstab Definition values get reset. You have to

add back in all the columns, rows and values.

If the datasource is only 1 table, the Crosstab Definition does not get reset.

"CreateWindow Error", "Cannot Find Window Class"

This is a handy feature because it allows the "Query By Example" and has no bad real-estate issues.

StarTeam 2005 anymore. PB 10.2 installs jdk 1.4.2_06 and StarTeam appears to

require 1.4.2_01.

When connecting using PB 10.2 jdk (1.4.2_06), it causes PB to crash with:

An unexpected exception has been detected in native code outside the VM.

Unexpected Signal : EXCEPTION_ACCESS_VIOLATION (0xc0000005) occurred at PC=0x805C61E

Function=frame::sender+0x9F

Library=C:\pb\pb10\Shared\PowerBuilder\jdk1.4.2_06\jre\bin\client\jvm.dll

Source file = D:/BUILD_AREA/jdk142-update/ws/fcs/hotspot\src\cpu\i486\vm\frame_i486.cpp : 341

Current Java thread:

at java.security.AccessController.getStackAccessControlContext(Native Method)

at java.security.AccessController.getContext(Unknown Source)

at java.lang.Thread.init(Unknown Source)

at java.lang.Thread.<init>(Unknown Source)

Tried modifying the StarTeamSDK70.ini and Java.ini to point to jdk 1.4.2_06

and that didn't work. Also tried to set the StarTeam jdk before PB jdk from Tools,Java, Set JDK Location, I get the error of:

The StarTeam SDK is not properly installed on this machine. The integration requires 70 of the StarTeam SDK. If the StarTeam SDK is installed you must first uninstall it. Then re-install this integration.

SELECT emp_lname FROM EMPLOYEE WHERE emp_id > 200

2) In SQL Painter, make the WHERE clause tab active and then convert to syntax mode.

3) Change the WHERE clause to read WHERE emp_id > 200 and emp_id < 800.

4) Convert to graphics. The new phrase "and emp_id < 800" is now missing.

Updating a varchar2 (4000) column with more then 2000 characters gives errors:

- "Row changed between retrieve and update"

- ORA-01461: can bind a LONG value only for insert into a LONG column

- ORA-12704: character set mismatch

To workaround it use DisableBind=1 or DisableUnicode=1

Calling an MSSQL stored procedure as a rpc with a PowerBuilder datetime argument

through a ODBC datacache gives an error:

[HY104] [Microsoft][ODBC SQL Server Driver]Invalid precision value

[HY000] [DataDirect][ODBC SQL Server driver][Microsoft SQL Server]Syntax error converting DATETIME from character string.

Set the DW RowFocusIndicator( Hand! ) or a picture control.

As you move up and down WITHIN a page, the previous row indicator is properly erased.

However -

When you hit the bottom of the window and you force the DW to scroll, the old picture (the previous row indicator) is not properly erased when the next (current) row is drawn.

This makes the RowFocusIndicator pretty much useless....

Inactive window behind an active window and then click on the upper left it will fire the double clicked event causing the window to close. Customers main application will gpf if this happens, however the sample app does not crash, but does fire the double clicked event.

Workaround: enable the auto vertical scrollbar to be able to insert more then 1024 characters in long column

The rectangle may move to the right when switching columns or under certain conditions on reopening the datawindow.

To fix the position, put the X-value in the expression box.

mysql = dw_1.Object.col1[i] + "," + ls_toto

Application crashes when reaching limit of allocated memory.

Workaround: split the code in two lines

mysql = dw_1.Object.col1[i]

mysql = mysql + "," + ls_toto

Unpredictable crashes with dbparm DisableUnicode=1 and the O84 interface.

and you click on that date column in IE, the dropdown calendar will sometimes

appear right over the column--obscuring the column.

The problem is reproducible from the dw painter and from a .Net WebForm. The problem

is noticeable when clicking on a date field at the bottom of the html page or asp page.

When deploying a component to EAServer, a server crash can occur if at the

same time a client application is trying to access the components and

there are no pooled components yet.

Customer would like that SCC PBNative log would also add and log the users that have been connected.

Works fine with PB 10 GA onwards

report is getting cut off.

From print preview, the report should fit on 11 x 17. When using the following

settings, the report is still getting cut off:

i_cust_width = 225

li_cust_length = 431

dw_1.Object.DataWindow.Print.Paper.Size = 256

dw_1.Object.DataWindow.Print.CustomPage.Length = li_cust_length

dw_1.Object.DataWindow.Print.CustomPage.Width = li_cust_width

From online help:

dw_1.Object.DataWindow.Print.CustomPage.Length = 254 // 10 inches

dw_1.Object.DataWindow.Print.CustomPage.Width = 190.5 // 7 inches

RESOLUTION: Although PB now support custompage.length and custompage.width, the print

driver needs to support this page size too.

I've just upgraded ASA/Ultralite 9.0.2.2451 in my machine and I got some

problem when creating an Ultralite Database in the database painter out of a

.usm file.

In the status bar of PocketBuilder at the bottom, a message with a RED

background reads "Error from ULCONV.EXE -5".

However, using the ASA 9.0.2 "ulconv create ....." command creates the .udb

file without a problem.

Just worrying about the compatibility between PocketBuilder 2.0.1.688 with

Ultralite 9.0.2.2451 after seeing this error.

After modifying the background.mode the field gets the value 00-00-0000

when clicking in it.

For all drivers, DelimitIdentifier is still a static DBParm that can only be set prior to the database connection.

When retrieving a datawindow, build upon a stored procedure that prints a large char value,

a crash occurs.

A print on a varchar did not crash.

Currently we only support the Simple MAPI interface for sending mail by script.

As a result PowerBuilder 10 can only sent mail using the local language setting in the control panel.

Workaround: Call the stored procedure using Declare, Prepare, Execute statements instead of as a remote function works fine.

SOLUTION: Set dbparm DBParm = ''Release='12.5.1' when connecting to ASE 12.5.1.

function will return -1 when you use a dw from PB 10.0.1 or older build.

dw_2.create(dw_1.describe("DataWindow.Syntax"))

If dw_1.sharedata(dw_2) = -1 Then

MessageBox("ShareData", "Failed to ShareData", StopSign!)

end if

QA testing determined that the stored procedure sp_webservices cannot be correctly executed when ASE has the quoted_identifier property turned on. Users may have SPs that use the double quote as a string delimiter. If so, those SPs won't execute if quoted_identifier is turned on. So it is reasonable to be able to modify this setting during a PB database connection. Hence the need for a dynamic DBParm for drivers that are frequently used with Sybase ASE.

With this fix applied, DelimitIdentifier will become a dynamic DBParm in PBSYC, PBJDB, and PBODB. It will also automatically issue a "set quoted_identifier {on | off}" to the ASE server if connected to Sybase ASE. The behavior in PBOLE, PBOR?, PBIN?,and PBDIR are not affected.

prefix (Terse means the error message should be SHORTER).

When MessageTerse= {'No' | 'FALSE' | 0} then errors should contain the SQLSTATE=nnnn

prefix (Not terse - hence longer error message).

The JDBC driver was behaving in exactly the opposite manner.

error results:

xxxx.wsdl is not a valid WSDL file

When using the WSDL trace, the log file shows:

INFO: StartElement: http://schemas.xmlsoap.org/wsdl/ part part

ENTER: WMMessagePartHandler::ReadAttributes

INFO: http://schemas.xmlsoap.org/wsdl/parttype=xsd1:com.medica.microp.security.logic.login.LoginRequest

ERROR: WMWebServicesDescFault raised:

ERROR: code: WSDL Schema Error

ERROR: string: Unresolvable namespace for attribute 'type' on element: 'message'

ERROR: Caught WMWebServicesDescFault in WMWSDLParser::LoadAndParseWSDLFile

LEAVE: WMWSDLParser::LoadAndParseWSDLFile (returned false)

ERROR: LoadAndParseWSDLFile returned false in WMSOAPWSDLClient::ParseFile

LEAVE: WMSOAPWSDLClient::ParseFile (returned false)

ERROR: Error::Cannot parse the WSDL file

LEAVE: PbProxyForWSDL::SetWsdlLocation (returned false)

INFO: WSDL Location: file://C:\pse\pse-90\11137767\LoginService.wsdl

ERROR: PbProxyObj.SetWSDLLocation returned false

LEAVE: ws_SetWsdlLocation (returned 0)

Yes will save the script and run the application.

No will stop the run and not save the script.

The customer believes the dialogue box could be a little clearer perhaps adding to the text of the messagebox to say "Selecting No will cancel the Run request."

In a large 3 tier application a crash occurs in an editmask in a difficult to explain situation.

The issue is possibly due to memory corruption.

The log files included in the testcase show the errors and tracing of web service proxy generation. The wsdl files reference urls that are behind customers firewall.

RESOLUTION: The bug was fixed.

that cell to a dw string column that has a editmask of #########, the paste will

not work in the dw painter. However if the cell has 7 digits and you copy

it to the dw painter, it will copy ok. But it appears that there are 2 trailing spaces.

This stems from the differing windowing concepts between the bare WinCE, newer WinCE.NET, and the layer provided by PocketPC and SmartPHone (Windows Mobile).

"PowerBuilder Fatal Error

Please contact Sybase supporting engineer."

These messages happen and then PB closes down. These type of messages are worse than no message at all. They give the impression that Tech Support knows how to solve the problem. But Tech Support was given no information on what causes these types of errors or what to tell the customer. The customer calls in expecting to have his problem solved in short order and Tech Support has nothing to tell them.

This is a strong request to PLEASE remove these kind of messages from the product. Replace them with meaningfull informational messages that will help identify what the problem is and how to rectify it.

This is a known 'limitation' that engineering is aware of and will have to address for PB 11. However, this problem is preventing sales of DW.NET 1.5. Product Management requested this be escalated on the basis of the customer's e-mail below:

"I've finally found a negative aspect to the rich functionality the

DW provides - my existing DWs contain SO much functionality that it makes it

nigh on impossible (at least from a commercial aspect) to redo them all

using less feature rich tools - hence why I was looking forward so much to

DW.Net 1.5. But alas, something as simple and as powerful as autosizing height on columns

does not work."

the filename length is greater than 102 characters, pb fails to create the application.

Wizard Error

Error generating c:\pb9\teststoragestoragestoragestoragestoragestoragestoaragestoragestoragestoragestoragestoragestoragestorage\genapp.pbl(genapp)

Reason is: General Failure

out an object when the debugger window is open, pb will crash with an access violation

at:

ACCESS_VIOLATION_pbvm90!rt_process_breakpoint+9a

FOLLOWUP_IP:

pbvm90!rt_process_breakpoint+9a [rtengine.cpp @ 2121]

10ceed8a 8b17 mov edx,[edi]

012edcc 10ceea10 pbvm90!rt_process_breakpoint(struct ob_this * rtthis = <Memory access error>, struct ob_class_hndl clshndl = struct ob_class_hndl, struct ob_pcode_node * pcode = <Memory access error>)+0x9a

0012eed4 10cdaa05 pbvm90!rt_exec_pcode(struct ob_this * rtthis = 0x00b3eda8, struct ob_class_entry * class_entry = 0x00b4c15a, struct ob_pcode_blk * pcode_blk = 0x00b64024)+0x2c0

0012eef0 1090a990 pbvm90!ot_eval_expr(struct ob_this * obthis = <Memory access error>, struct ob_group * group = <Memory access error>, struct ob_class_entry * class_entry = <Memory access error>, struct ob_pcode_blk * pcode_blk = <Memory access error>, struct ob_data * expr_result_buf = <Memory access error>)+0x75

0012ef78 1090aa7c pbcmp90!assign_vardecl(struct cm_this * cmthis = <Memory access error>, struct ob_data * lvalue = <Memory access error>, unsigned short lvalue_type = <Memory access error>, ob_group_types lvalue_grouping = <Memory access error>, struct ob_arraydef * lvalue_arraydef = <Memory access error>, int lvalue_is_const = <Memory access error>)+0x190

0012efac 109060f7 pbcmp90!cm_typevardecl_assign(struct cm_this * cmthis = <Memory access error>)+0x8c

0012efbc 10901a6c pbcmp90!cmscript_disp(struct cm_this * arg = <Memory access error>, int index = <Memory access error>)+0x47

0012f024 10906146 pbcmp90!gr_parse_basic(struct gr_this * grthis = <Memory access error>, void * cmthis = <Memory access error>, <function> * lexread = <Memory access error>, <function> * dispatch = <Memory access error>, <function> * syntaxerr = <Memory access error>)+0x88c

0012f040 1090df61 pbcmp90!gr_parse_cmscript(struct gr_this * grthis = <Memory access error>, struct cm_this * cmthis = <Memory access error>, <function> * getch = <Memory access error>, <function> * syntax_error_proc = <Memory access error>)+0x36

0012f068 1090e78f pbcmp90!cm_script_compile(struct cm_this * cmthis = <Memory access error>, <function> * getch = <Memory access error>)+0xd1

0012f0b0 10c84415 pbcmp90!cm_src_block_compile(struct cm_this * cmthis = <Memory access error>, unsigned short group_hndl = <Memory access error>, char ** source_blocks = <Memory access error>, void * pvsrctypes = <Memory access error>, unsigned int no_blocks = <Memory access error>, CM_COMPILE_TYPE compile_type = <Memory access error>)+0x1ef

0012f0d0 10c69cc9 pbvm90!ob_cm_src_block_compile(struct ob_this * obthis = <Memory access error>, unsigned short grouphndl = <Memory access error>, char ** source_blocks = <Memory access error>, void * srcloc = <Memory access error>, unsigned int no_blocks = <Memory access error>, CM_COMPILE_TYPE compile_type = <Memory access error>)+0x45

0012f134 10c697cb pbvm90!ob_compile_source_entry(struct ob_this * obThis = <Memory access error>, char * lpszLibraryName = <Memory access error>, char * lpszEntryName = <Memory access error>, CM_COMPILE_TYPE compile_type = <Memory access error>, int write_source = <Memory access error>)+0x4e9

0012f14c 10c6a023 pbvm90!ob_compile_lib_entry(struct ob_this * obThis = <Memory access error>, char * lpszLibraryName = <Memory access error>, char * lpszEntryName = <Memory access error>, int write_source = <Memory access error>)+0x1b

0012f16c 11e199ad pbvm90!ob_compile_lib_entry_3_pass(struct ob_this * obThis = <Memory access error>, char * lpszLibraryName = <Memory access error>, char * lpszEntryName = <Memory access error>)+0x43

0012f4c8 11e1766d pblib90!PL_UtilImportFile(struct tagThis * pbThis = <Memory access error>, struct shhashx * pLibraryHash = <Memory access error>, struct HWND__ * hWndParent = <Memory access error>, char * lpszFileName = <Memory access error>, char * lpszLibraryName = <Memory access error>, char * lpszEntryName = <Memory access error>, int iImportOption = <Memory access error>, int bDeleteTheFile = <Memory access error>, int bRegenIfNeeded = <Memory access error>)+0x62d

0012f68c 11e5edbd pblib90!PL_CompileImportPBObjects(struct tagThis * pbThis = <Memory access error>, struct shhashx * pLibraryHash = <Memory access error>, struct HWND__ * hWnd = <Memory access error>, int iNumPBItems = <Memory access error>, struct shlistx * pImportList = <Memory access error>, int iImportOption = <Memory access error>)+0x42d

0012fb58 11e4fbe0 pblib90!CPL_View::OnCheckOut(void)+0xc8d

0012fb64 11e6ea54 pblib90!CPL_View::OnCommand(unsigned int uId = 0x8bc35de5, struct HWND__ * hWndControl = 0x738bf85d, unsigned int uCode = 0x6f704)+0x150

0012fb74 11e6e6aa pblib90!CPL_TreeBrowserView::OnCommand(unsigned int uId = <Memory access error>, struct HWND__ * hWndControl = <Memory access error>, unsigned int uCode = <Memory access error>)+0x14

0012fba8 0041aa2c pblib90!CPL_TreeBrowserView::OnNotify(long lHint = <Memory access error>, void * pData = <Memory access error>, long * plReturn = <Memory access error>)+0xba

The code generated by the object model does not work inside a portlet. The sessions get lost. In a normal JSP without Portal it works fine.

Powerbuilder 10.2_8081, 10.2_7516, 10.0.1_6064.

When running sample application that calls external function to 3rd party Winio.dll, it works only after generating EXE. In interactive PB environment, the call always fails.

FileRead using LineMode!

We used to read in 1KB per read operation, now 32KB are read in even for very short lines.

The change is necessary for Unicode.

a Oracle Database with UTF8 as charset, error may occur

ORA-01460 : Unimplemented or unreasonable conversion requested.

When calling a stored procedure in ESQL ( DECLARE and EXECUTE ) with PBNewSPInvocation

DBParm a text variable gets truncated to 64000 characters.

Further information on this from:

<http://windowsxp.mvps.org/networkfile.htm>

The Customer has a Client that is not allowed to make any changes to the Client PCs, so if the EXE can be Digitally Signed with a Security certificate, the Security warning will only be displayed the First time the EXE is Run.

When they try to Sign a PowerBuilder EXE, that Executable will no longer Run.

Questions:

1) Can a PowerBuilder EXE be Digitally Signed?

2) Is this supported?

( *** Not NLS_CHARACTERSET = AL32UTF8 ***), and try to retrieve resultset

(with ASIAN characters inside e.g. chinese chars) for more than 301 rows,

the resultset will be messed-up with all ASIAN characters be turned into garbage.

A machine code application crashes on the following construction:

ls_string = MidA(ls_string, i + 1)

If the return value of MidA was captured into a different string, the problem did not occur.

The test application used to reproduce the problem is the standard sample application "poom_tests.pkl".

The problem described in this CR is similar in nature to CR382168 which has been resolved.

They find that when "User Objects" from the Task Manager reaches 10,000, it crashes

their application. (This happens, for example, if they have 9 instances of a window opened.)

Customer wants to know:

1) What is the relation between "User Objects" and "Handles" from PowerBuilder's

perspective? In customer's case, they find that a very small number of Handles used (less than 200) when their app reaches the 10,000 User Object point and crashes.

2) Need more details on how controls and fonts influence the number of User Objects and what exactly what causes User Objects to be created/consumed?

3) If we use non-visual objects other than datastores, does that contribute in

consuming "User Objects"?

Customer was sent the following information:

For more info, please read the "User Object Handles" section in the following document from : http://www.sybase.com/detail?id=1019174

For cross-reference , please refer to the following docs from Microsoft : http://support.microsoft.com/default.aspx?scid=kb;en-us;326591

http://support.microsoft.com/default.aspx?scid=kb;en-us;327699

"ORA-01461 - can bind a LONG value only for insert into a LONG column"

if do an update on database with an non unicode charset (WE8ISO3359P1).

software express, installs an incorrect version of the help file.

When installing the EBF on the following screen displays:

PowerBuilder 10.X Maintenenance Setup

Help

Main help files

Compiled HTML

After the install, when you select Help, Welcome to PowerBuilder 10.0.

It only list the new features for PB 10. It should be listing the new features for

PB 10, PB 10.0.1 and PB 10.2.

with multi-clients request (e.g. 20) within a short period (e.g. 20 mins) to invoke

series of PB Components. With the help from windbg, it is observed that a kind of Access

Violation occur at certain thread with Oracle Client call .

(D:\oracle\ora92\bin\oraclient9.dll - oraclient9!xaolog+0x31021:)

Problem appears to happen if you set the connecttopad property to 'always'.

RESOLUTION: Thirdparty problem

that that the application CRASH intermittenly. With the WinDbg, it is observed that the

problem is related PB Heap management. (PBVM90!PbHeap_panic)

A customer was unable to find this dll. This is no longer a requirement. It was a support library for DBTOOLS. It is no longer required as it has been consolidated into other deployment DLLs.

This is a new feature request only. Today, when building an stored procedure based dw, if we change the stored procedure data source, we then need to manually add the new columns from respective new resultset. Customer would like it to be automatically.

any an_anyarray[]

string s_stringarray[]

long l_tmp = 3, l_from_stringarray

an_anyarray[1] = l_tmp

s_stringarray[] = an_anyarray[]

// crashes PB !!!!

l_from_stringarray = long( s_stringarray[1] )

In PB 6.5, the last reports used to come just after the first one but since PB8 a large space is left between the 2 reports

"PowerBuilder Fatal Error

Please contact Sybase supporting engineer."

As per Engineering when this happens, the PbDumpOnUnExpectedException=TRUE should be set, and PB will generate a minidump in the first time, which provide evidence to locate the root cause. The customer did this and the dump file is provided.

past the left border to make the column 'hidden'.

In PB 8.0.4, you can select the right border and move it over past the left

border and drop it. The column is hidden. In PB 9.0, 9.0.2, 10.2, if you

do it, the column does not resize at all. You can move it in increments to

decrease the column width but the column will not resize to zero width.

Problem started in PB 9.0 (build 5507). Works ok in PB 8.0.4.

"Could not open query 'q_test'.

Makes sure your database is correct."

the setremote command appears to be called twice.

The following is the ddespy trace from 8030:

Task:0xdf4 Time:13266736 hwndTo=0x24087c Message(Posted)=Poke:

hwndFrom=0x1f0864, status=2000(fRelease ) fmt=0xd("CF_UNICODETEXT")

Data= U"TEST4.FM"

Item=0xc06f("ImportFile")

Task:0x594 Time:13266856 hwndTo=0x3b0952 Message(Posted)=Poke:

hwndFrom=0x2308fa, status=2000(fRelease ) fmt=0xd("CF_UNICODETEXT")

Data= U"TEST4.FM"

Item=0xc06f("ImportFile")

Task:0xd94 Time:13266966 Callback:

Type=Poke, fmt=0xd("CF_UNICODETEXT"), hConv=0x3000901, hsz1=0xc000("TEST3.FM")

hsz2=0xc001("ImportFile"), hData=0x4000f01, dwData1=0x0, dwData2=0x0

return=0x0

Input data=

U"TEST4.FM"

...

Task:0xd94 Time:13267077 hwndTo=0x2308fa Message(Posted)=Ack:

hwndFrom=0x3b0952, App=* or status=0()

Topic=Item=0xc06f("ImportFile")

Task:0x594 Time:13267127 hwndTo=0x1f0864 Message(Posted)=Ack:

hwndFrom=0x24087c, App=* or status=0()

Topic=Item=0xc06f("ImportFile")

The following is the ddespy trace from 8035:

Task:0x72c Time:13686990 hwndTo=0x27087c Message(Posted)=Poke:

hwndFrom=0x4208e4, status=2000(fRelease ) fmt=0xd("CF_UNICODETEXT")

Data= U"TEST4.FM"

Item=0xc06c("ImportFile")

Task:0x594 Time:13687060 hwndTo=0x2508c0 Message(Posted)=Poke:

hwndFrom=0x3d0952, status=2000(fRelease ) fmt=0xd("CF_UNICODETEXT")

Data= U"TEST4.FM"

Item=0xc06c("ImportFile")

Task:0x488 Time:13687151 Callback:

Type=Poke, fmt=0xd("CF_UNICODETEXT"), hConv=0x3000901, hsz1=0xc000("TEST3.FM")

hsz2=0xc001("ImportFile"), hData=0x4000f01, dwData1=0x0, dwData2=0x0

return=0x0

Input data=

U"TEST4.FM"

...

Task:0x488 Time:13687301 hwndTo=0x3d0952 Message(Posted)=Ack:

hwndFrom=0x2508c0, App=* or status=0()

Topic=Item=0xc06c("ImportFile")

Task:0x594 Time:13687361 hwndTo=0x4208e4 Message(Posted)=Ack:

hwndFrom=0x27087c, App=* or status=0()

Topic=Item=0xc06c("ImportFile")

Task:0x72c Time:13687431 hwndTo=0x27087c Message(Posted)=Poke:

hwndFrom=0x4208e4, status=2000(fRelease ) fmt=0x1("CF_TEXT")

Data= "TEST4.FM"

Item=0xc06c("ImportFile")

Task:0x594 Time:13687491 hwndTo=0x2508c0 Message(Posted)=Poke:

hwndFrom=0x3d0952, status=2000(fRelease ) fmt=0x1("CF_TEXT")

Data= "TEST4.FM"

Item=0xc06c("ImportFile")

Task:0x488 Time:13687561 Callback:

Type=Poke, fmt=0x1("CF_TEXT"), hConv=0x3000901, hsz1=0xc001("TEST3.FM")

hsz2=0xc000("ImportFile"), hData=0x5000f01, dwData1=0x0, dwData2=0x0

return=0x0

Input data=

"TEST4.FM"

...

Task:0x488 Time:13687691 hwndTo=0x3d0952 Message(Posted)=Ack:

hwndFrom=0x2508c0, App=* or status=0()

Topic=Item=0xc06c("ImportFile")

Task:0x594 Time:13687761 hwndTo=0x4208e4 Message(Posted)=Ack:

hwndFrom=0x27087c, App=* or status=0()

Topic=Item=0xc06c("ImportFile")

Issue #1 concerns a stored procedure in an MS SQL Server database that does an update that affects no rows. If the sp is called from PB then transaction object SQLCode indicates a 0 which is correct. But if the sp is called from a PB component deployed to EAServer then SQLCode indicates a -1. The customer claims this worked fine in EASever 4.2.3. We verified it is failing when using 4.2.4 and 4.2.5. A couple of interesting points: Executing the update sql in the component works, and doing a set nocount on in the sp also returns the correct 0 return value.

Issue #2 is a component using dynamic SQL Format 2 to insert into a table. The insert has a subquery that finds no rows and the same problem results, it returns a -1 when called from a PB component deployed to EAServer 4.2.4 or 4.2.5. As the above case, it works when issuing a set nocount on. Then the SQL returns the correct 0 return value.

When access it manually or with a script,it returns value 00/01/0000 instead of 00/00/0000

Workaround: Assign an empty string or use setnull() function.

or like in 374330.

add this to the pb.ini

[Edit Mask Behaviors]

AutocompleteDates=NO

No crash occurred when calling sharedataoff first.

The problem is reproducible in PB 10.2.0 Build 8035 but not in 8021.

closing an application that contains the IBSImageTool.ocx.

The application opens a window (w_test). On the window, you then open the w_image

which opens an userobject (iuo_image). In the constructor of iuo_image, a call is

made to getnativepointer. In the constructor event of the ocx control, a post

call is made to of_load_file which calls the IBS_OpenImage and returns the text.tif file.

The problem happens when closing the application. In the w_image, a messagebox is

displayed and then the iuo_image.event ue_test is called. This event calls the releasenativepointer. Next the iuo_image userobject is closed and garbagecollect is

called.

When the user clicks on the ocx control to change the picture and the messagebox is

called, PB will crash when the app is closing. If you don't click on the ocx control

and then the messagebox is called, app is ok or vice versa. If you click on the ocx control but don't call a messagebox, app works ok. Tried changing focus programmically, that didn't work. If you put a cb on the iuo_image and click on the

cb before you close out of the app, it works ok. However, when you try to trigger

the click event or setfocus programmically to the cb, app will still crash.

The crash handler shows the following:

Exception code: C0000005 ACCESS_VIOLATION

File Name: C:\WINDOWS\system32\MSVBVM60.DLL

File Version: 6.00.9782

Fault address=6605208D Section:Offset=01:0005108D

Registers:

EAX:00000040

EBX:02F81CD4

ECX:00000000

EDX:00000001

ESI:00000040

EDI:0012ED20

CS:EIP:001B:6605208D

SS:ESP:0023:0012EC54 EBP:0012EC64

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

Flags:00010212

Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

6605208D 0012EC64 02F81CD4 02F8189C 02F582D8 0000000C IID_IVbaHost+2379D

660524FC 0012ED44 02F81CD4 02F8189C 02F582D8 0000000C IID_IVbaHost+23C0C

660528E7 0012ED68 02F81CD4 0000000C 00000000 00000002 IID_IVbaHost+23FF7

6605E222 0012EDCC 02F582D8 00000000 0000100E 0000000C IID_IVbaHost+2F932

660B384A 0012EE0C 02F81CD4 00000000 0000100E 0000000C DllCanUnloadNow+13C8C

6605D0C6 0012EE34 02F81CD4 00000000 0000100E 0000000C IID_IVbaHost+2E7D6

6604D4EB 0012EE78 00000000 660077EF 00000000 0012EEB8 IID_IVbaHost+1EBFB

6601B805 0012EE8C 004905FC 00001052 00000000 02F897E0 _vbaStrComp+73F

77D48734 0012EEB8 660077EF 004905FC 00001052 00000000 GetDC+6D

77D48816 0012EF20 00000000 660077EF 004905FC 00001052 GetDC+14F

77D489CD 0012EF80 0012EFA8 00000001 0012F038 10BF8F68 GetWindowLongW+127

77D496C7 0012EF90 0012EFA8 00B82498 00B6F450 00000000 DispatchMessageA+F

10BF8F68 0012EFC0 0012F01C 0012F074 00000000 00B6F9D0 RT_StandardDispatchHandler::HandleSingleMessage+118

10C6D706 0012F038 00B6F450 00B6F9D0 00000000 00000001 executeOneRequest+186

10C6D360 0012F06C 00000000 00000000 00000000 00B6F450 ob_start_of_seperate_thread+170

10BFA41C 0012F08C 00B6F450 00B7571C 7C823053 00B6CE08 FN_PluginStart+18C

10BF908B 0012F0A8 00000001 10000000 00000000 00B7571C FN_RunApplication+DB

10613FE7 0012F444 00B6CE08 00000001 00000400 00D27488 PB_RunApplication+387

1061A4C2 0012F4B4 00B6B0D8 00B6CE08 00000000 00B6F228 SysRunCmd+222

1061815B 0012FD60 003E04F0 00000111 00000400 00000000 PB_FrameWnd+D1B

77D48734 0012FDC8 00000000 00000000 00000000 0012FDA8 GetDC+6D

FROM bplomo LEFT OUTER JOIN bdepo ON bplomo.cplomo = bdepo.cplomo AND ( bdepo.ctmoneda = 1 ), bcajerotira

WHERE ( bplomo.ctira = bcajerotira.ctira ) and

( ( bcajerotira.cbanco = 36 ) AND

( bcajerotira.cturno = 2 ) AND

( bcajerotira.ftira between "04/18/2005" and "04/18/2005" ) AND

( bcajerotira.ctserv = 1 ))

Today, the graphical interface in query painter (for ANSI outer joins) allows only the following possibility:

FROM bplomo LEFT OUTER JOIN bdepo ON bplomo.cplomo = bdepo.cplomo,

bcajerotira

WHERE ( bplomo.ctira = bcajerotira.ctira ) and

( ( bplomo.cbanco = 36 ) AND

( bcajerotira.cturno = 2 ) AND

( bcajerotira.ftira between "04/18/2005" and "04/18/2005" ) AND

( bcajerotira.ctserv = 1 ) AND

( bdepo.ctmoneda = 1 ) )

Both queries are correct, but the current ability results in one row less in query resultset.

The external function is called from a DW event. The external function then sends a Windows Message back to the calling window that triggers the same DW event.

The second time the DW event is triggered, the external function is not called.

The DW event returns, the external function returns, the DW event returns without problem.

It is when the calling event/function returns that the crash occurs.

string s1

s1 = "10000000000000000000000000000000"

Strings of the same length, but different characters don't cause a crash... The crash does't happen on some machines.

The SRD is referring to the button property "enabled" which must be new with PB9.

painter and signed the app with "PocketBuilder Test Privileged Code Signing".

The error message i received on the Smartphone end is "Error: Security Signature for PKVM20.DLL was not accepted."

The previous PK2.0.2 Build 821 did not display this error.

Reason -

PocketBuilder files are signed with a certificate which needs to be renewed every year.

When it was renewed this time, we forgot to update the "PK_AddCerts.XML" which adds the updated certificate to the device.

Solution -

PocketBuilder provides an XML file (PK_AddCerts.xml in the PocketBuilder Support>TestCertificates directory) that it assigns as the default source to install to a connected device when the Install PocketBuilder Default Certificates option is selected. Clicking the Install Certificates button deploys this XML file which contains references to all the default PocketBuilder test certificates.

where the executable file name is on a mapped network drive that includes the

domain name, the following error appears in the project painter:

---------- Deploy: Deploy of p_pb10_unc_exe

Creating executable file...

Inspecting Application Dependencies...

Inspecting Application Dependencies...

Inspecting application libraries...

Create of executable file failed

---------- Finished Deploy of p_pb10_unc_exe

From the project painter, it you click on the browse next to the Executable File Name sle,

you can browse to that folder ok.

error results:

Wizard Error

Error generating \\machinename.sybase.com\testunc\testpb10unc.pbl(testpb).

Reason is: General Failure

Able to open an existing workspace and target in this location--able to modify

objects ok. Cannot create new application, template, easerver, com, automation server or jsp. Able to create existing application target ok.

PER DEVELOPMENT: The crash occurs in a StarTeam dll which should not remain in memory after the failed connection. It cannot be controlled from the PowerBuilder side. If the connection fails, the StarTeam client ought to be handling this.

the interval datatype column doesn't retrieve the value when using embedded sql or

it returns a incorrect value in a datawindow.

Works ok using the odbc (IBM 3.82.000 2.81 TC3) driver. Embedded sql problem

happens for PB 8.0.4, PB 9.0.2 and 10.2. DW problem happens only in PB 10.2. Retrieves ok in PB 8.0.4 and 9.0.2.

To work around this limitation, the user should choose 1 table and hit OK. Then CANCEL out of the "Column Values" dialog and click the "Tables" toolbar item to return to the "Choose Tables" dialog. Choose additional tables for the FROM list and hit OK.

This error occurs when trying to insert a singe char into a table using an RPC call in PowerBuilder 10.

lArrayBounds = lVariableCardinalityDefinition.ArrayDefinition

triggered twice when both of condition occurs

1) the column is dropdown datawindow

2) the Itemchanged event inside use some javascript function that get focus

e.g. alert(), prompt(), confirm

application crashes intermittently.

Customer experiencing intermittent failures that they cannot diagnose.

pbvm90!PbHeap_panic(void * ptr = 0x011645f0)+0x23c

pbvm90!PbHeap_sizeEx(void * ptr = 0x10dabeb3, unsigned int * oldSize = 0x00000000, unsigned int * minSize = 0x011645f0, unsigned int * maxSize = 0x011f7698)+0x68

pbvm90!print(void * ptr = 0x10dabeb3, unsigned char * label = 0x00000000 "")+0x29

pbvm90!PbHeap_panic(void * ptr = 0x00000000)+0x193

pbvm90!PbHeap_free(void * ptr = 0x011645f0)+0x73

pbvm90!MemFreePtr(void * ptr = 0x011f7698)+0x11

pbvm90!pbstg_fee(struct stg_anchorS * pthis = 0x011f7698, void * stg = 0x011f7698)+0xe

pbvm90!ot_free_val_ptr(struct ob_this * obthis = 0x011f7698, struct ob_data * node = 0x011f7698)+0x6c

pbvm90!ot_free_out_node(struct ob_this * obthis = 0x011f7698, struct ob_data * data_node = 0x011f7698)+0x6c

pbvm90!ob_clear_looksym_values(struct ob_this * obthis = 0x011f7698, struct ob_look_symtab * looksym = 0x011f7698)+0xa7

pbvm90!ob_del_routine_copy(struct ob_this * obthis = 0x00000000, struct ob_routnode * routine = 0x018cedf8)+0x14

pbvm90!ob_pop_routine(struct ob_this * obthis = 0x00000000)+0x9b

pbvm90!ob_close_routine_inst(struct ob_this * obthis = 0x00000000)+0x35

pbvm90!OB_RUNTIME_CLASS::invoke(struct ob_this * obthis = 0x00000000, class OB_OBJECT * object = 0x018cedf8, unsigned short vtable_id = 0x30c0, char * func_name = 0x00320010 "", OB_ROUT_TYPE rout_type = 11 (No matching enumerant), unsigned short numArgs = 0xdd60, struct ob_data * args = 0x01f8dd28, int bConvert = 0, int bDuplicate = 34951216, struct ob_data * pResult = 0x0214e238)+0x8e1

pbvm90!OB_RUNTIME_CLASS::invoke(struct ob_this * obthis = <Memory access error>, class OB_OBJECT * object = <Memory access error>, unsigned short vtable_id = <Memory access error>, unsigned short numArgs = <Memory access error>, struct ob_data * args = <Memory access error>, struct ob_data * pResult = <Memory access error>)+0x1f0

pbvm90!OB_OBJECT_LOCAL::invoke(class OB_RUNTIME_CLASS * context = <Memory access error>, unsigned short vtable_id = <Memory access error>, unsigned short numArgs = <Memory access error>, struct ob_data * args = <Memory access error>, struct ob_data * pResult = <Memory access error>)+0x2d

pbvm90!OB_OREQ_INVOKE::Execute(struct ob_this * obthis = <Memory access error>)+0x14b

pbvm90!executeOneRequest(struct ob_this * obthis = 0x011f7698, class OB_REQUEST_QUEUE * pObjMgrQueue = 0x011f7c38, OB_REQUEST_QUEUE::REQUEST_SCOPE requestScope = ALL (0), int bHandleWindowsMsgs = 1, int * pbMoreMessages = 0x0012eb44, int * pbExitLoop = 0x0012eb1c)+0xf7

pbvm90!ob_execute_single_message(struct ob_this * obthis = <Memory access error>, int bLocalMessagesOnly = <Memory access error>, int bHandleWindowsMsgs = <Memory access error>, int * pbMoreMessages = <Memory access error>)+0x35

pbvm90!fnYield(struct ob_this * rtThis = <Memory access error>, unsigned int nArgs = <Memory access error>)+0x27

Once migrated the application can successfully do a Full Rebuild if it is not yet connected to source control. Customer is using Version Manager 8.x but the problem is also reproducible using PBNative. Once connected to version control with all the objects added if one tries to do a Full Rebuild PowerBuilder will crash.

randomly.

The crash is happening in the ntoskrnl.exe. The following is the from dump file:

BAD_POOL_CALLER (c2)

The current thread is making a bad pool request. Typically this is at a bad IRQL level or double freeing the same allocation, etc.

Arguments:

Arg1: 00000007, Attempt to free pool which was already freed

Arg2: 00000cd4, (reserved)

Arg3: 00180016, Memory contents of the pool block

Arg4: 83299c38, Address of the block of pool being deallocated

Debugging Details:

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

POOL_ADDRESS: 83299c38 Nonpaged pool

FREED_POOL_TAG: File

BUGCHECK_STR: 0xc2_7_File

DEFAULT_BUCKET_ID: DRIVER_FAULT

LAST_CONTROL_TRANSFER: from 8054b741 to 8053331e

STACK_TEXT:

f7c389c4 8054b741 000000c2 00000007 00000cd4 nt!KeBugCheckEx+0x1b

f7c38a14 804f2d6e 83299c38 00000000 00000000 nt!ExFreePoolWithTag+0x2be

f7c38a2c f76236a2 8257a2b0 f7c38a88 f7c38a60 nt!ExDeleteResourceLite+0x4e

f7c38a3c f7650517 8257a2b0 83736260 e304f0d0 Ntfs!NtfsFreeEresource+0x6b

f7c38a60 f762357a 82569178 f7c38a88 f7c38a93 Ntfs!NtfsDeleteFcb+0x67

f7c38aac f7644d00 82569178 83736100 e3165520 Ntfs!NtfsTeardownFromLcb+0x1fd

f7c38b04 f761f759 82569178 e31655e8 e3165780 Ntfs!NtfsTeardownStructures+0x125

f7c38b30 f76426eb 82569178 011655e8 e3165780 Ntfs!NtfsDecrementCloseCounts+0x9e

f7c38bb4 f764248a 82569178 e31655e8 e3165520 Ntfs!NtfsCommonClose+0x397

f7c38c54 804e37f7 83736020 827b62a8 837d1e20 Ntfs!NtfsFsdClose+0x21f

f7c38c64 f76c1459 f7c38d28 804e37f7 837cfa88 nt!IopfCallDriver+0x31

f7c38c6c 804e37f7 837cfa88 827b62a8 f7c38cc4 sr!SrPassThrough+0x31

f7c38ce0 804e37f7 834c1020 827b62a8 827b62a8 nt!IopfCallDriver+0x31

f7c38cf0 8056a701 8250e568 00000000 00000000 nt!IopfCallDriver+0x31

f7c38d28 805638f7 0050e580 8250e568 00000000 nt!IopDeleteFile+0x132

f7c38d44 804e36d5 8250e580 00000000 806ed03c nt!ObpRemoveObjectRoutine+0xdf

f7c38d68 804f33d1 8055eab8 8269cd20 806ed070 nt!ObfDereferenceObject+0x5f

f7c38d8c 804fee2c e2dd9720 00000000 837c52c8 nt!MiSegmentDelete+0xdd

f7c38dac 8057be15 00000000 00000000 00000000 nt!MiDereferenceSegmentThread+0x9e

f7c38ddc 804fa4da 804fed96 00000000 00000000 nt!PspSystemThreadStartup+0x34

00000000 00000000 00000000 00000000 00000000 nt!KiThreadStartup+0x16

PROCESS_OBJECT: e56c6946

FOLLOWUP_IP:

nt!ExFreePoolWithTag+2be

8054b741 83f801 cmp eax,0x1

SYMBOL_STACK_INDEX: 1

FOLLOWUP_NAME: MachineOwner

SYMBOL_NAME: nt!ExFreePoolWithTag+2be

MODULE_NAME: nt

IMAGE_NAME: ntoskrnl.exe

DEBUG_FLR_IMAGE_TIMESTAMP: 42250ff9

STACK_COMMAND: kb

FAILURE_BUCKET_ID: 0xc2_7_File_nt!ExFreePoolWithTag+2be

BUCKET_ID: 0xc2_7_File_nt!ExFreePoolWithTag+2be

When pasting SQL from the painter then the pasted statement can be incomplete as part

of the where clause may be missing.

Before returning to the script painter perform an extra tab.

PowerBuilder 9 generates structures without attributes for certain complex types.

PowerBuilder 10 is able to generate the appropriate structures.

is specified in the rte properties, pb will crash.

In PB 9.0.2, a message returns

PowerBuilder Fatal Error

Please contact Sybase Support Engineer

In PB 10.2, I was able to get a crash handler report:

Exception code: C0000005 ACCESS_VIOLATION

File Name: C:\WINDOWS\System32\spool\DRIVERS\W32X86\3\AD2KReGP.DLL

File Version: 7, 0, 0, 0

Fault address=70001CC7 Section:Offset=01:00000CC7

Registers:

EAX:00000000

EBX:00000000

ECX:77DD6A51

EDX:00000000

ESI:00A9D090

EDI:00A9D090

CS:EIP:001B:70001CC7

SS:ESP:0023:0012A044 EBP:0012A89C

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

Flags:00010246

Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

70001CC7 0012A89C 00A9D140 00A9D090 0012A8BC 5E163844 0001:00000CC7 C:\WINDOWS\System32\spool\DRIVERS\W32X86\3\AD2KReGP.DLL

700024CA 0012B4EC 00A9D140 00201AE8 00000001 00000000 0001:000014CA C:\WINDOWS\System32\spool\DRIVERS\W32X86\3\AD2KReGP.DLL

5E182392 0012B518 001FDCA4 001FEE60 00000001 00000000 0001:00021392 C:\WINDOWS\System32\spool\DRIVERS\W32X86\3\PSCRIPT5.DLL

5E17C9BE 0012B5C4 00229F90 00000010 0012B66C 5E187CBE 0001:0001B9BE C:\WINDOWS\System32\spool\DRIVERS\W32X86\3\PSCRIPT5.DLL

5E187EDB 00229F90 5E17DD5A 5E17DD83 00000000 5E17DDB4 0001:00026EDB C:\WINDOWS\System32\spool\DRIVERS\W32X86\3\PSCRIPT5.DLL

5E17DD46 5E17DD37 5E161170 830008C2 0004247C 74FF0A74 0001:0001CD46 C:\WINDOWS\System32\spool\DRIVERS\W32X86\3\PSCRIPT5.DLL

15FF006A 042474FF 00000000 00000000 00000000 00000000 0000:00000000

Performance problem with DataWindow SaveAs to a file on the network

as the file is written in many FileIO operations.

http://sybooks.sybase.com/onlinebooks/group-pb/pbg1000e/pbgs/@ebt-link;pt=6354?target=%25N%14_7000_START_RESTART_N%25

The second paragraph is as follows:

You must now change some code in the Script view. The first drop-down list box in the Script view displays the window name, m_master_detail_ancestor.

Correction required:

m_master_detail_ancestor should be replaced with w_master_detail_ancestor

The Asending order for dw sorting of US Win2000 is : 1, 2, [

Whereas the Asending order for dw sorting of T-Chinese Win2000 is : [, 1, 2

This is with Oracle 9 (o90) driver and also in the 10g driver.

are called with null parameter, the memory in use will increase by 24 bytes. But

if calling these functions with empty string as parameter, no memery will be

used.

PowerBuilder Application Execution Error R0094; CORBA_TRANSACTION_ROLLEDBACK

After the fix for CR 389304, there is still a crash on Hot Deployment.

Per Engineering this is not a leak. The testcase is a tight loop doing the dot notation. PB is using memory to do this. The memory is not released back to the os, so you see it going up. But it is available to PB and it is re-used. You can see this if you change the test case to do a set number of iterations and then stop. The first time you run it memory increases as it runs. But when you re-run the memory stays where it is.

You can put a garbagecollect() in the loop and the memory bounces around a little but does not increase.

SOLUTION:

This is a known Oracle bug that was fixed in 9.2.0.3 or above. The root cause of the crash is the first procedure in the package has no parameters.

PB 10.2 build 8050 gpf. In PB 10.2 build 8035 works fine.

any la[]

if isnull(la) then messagebox("ISNULL","Calling isnull function")

Works OK (it doesn't crash) in PB 9.0.

Workaround: this can be implemented in code by manually setting the current item as follows: (For each corresponding menu clicked event script)

m_ancestor lm_menu

lm_menu = w_frame.menuid

lm_menu.m_menucascade.currentitem = lm_menu.m_menucascade.m_menuitemX

But when an update to a row is made and one or more of these columns is affected, the string that gets updated to the database is always the three columns of the last row in the datawindow, not the row that is getting updated. Other columns that are mapped one to one to the update stored procedure update correctly for the rows with changes. The problem is the expression is always evaluating the values for the last row in the dw. It has 'lost' the context of the update row somehow.

The following editmask is being used in the test case:

###-###-####

This feature worked in builds earlier than 9.0.2 build 7653 and in earlier PB 10 builds.

Call the SP directly in PB without EAS returns the correct value in all versions. It is an MS SQL Server database and connection is via ODBC.

The multiline column is a char column, background color defaults to transparent and autosize height is set to false and has the following dw expression on the background color:

if ( id = 101, 16777215, 80269524 )

Any row where the id is not 101, the multiline column will be grey. When selecting the row where the id is 101, the first line of the column stays transparent that has text

but the other lines in the column turn to grey.

Cursor jumps on wrong position if pressing the delete key.

Wrong behavior of edit mask ###-###-####:

123- 45|6-7890 => delete key => 123- 45 -|7890 => insert 6 => 123-45-6|890.

Normal behavior should be:

123- 45|6-7890 => delete key => 123- 45| -7890 => insert 6 => 123-456-|7890.

following error returns:

Error calling method of "PBNI object".

The call to the webservice is as follows:

itemsearchresponse = amazon.itemsearch( subscriptionid, associatetag, "Single", "False", itemsearchrequest, unused, operationrequest )

The soap log shows the following:

<?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"

xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"

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

xmlns:xsd="http://www.w3.org/2001/XMLSchema"><SOAP-ENV:Body><ItemSearchResponse xmlns="http://webservices.amazon.com/AWSECommerceService/2005-03-23"><OperationRequest><RequestId>17RP2JNHP22XFWC02W48</RequestId><RequestProcessingTime>0.0337121486663818</RequestProcessingTime></OperationRequest><Items><Request><IsValid>False</IsValid><Errors><Error><Code>AWS.InvalidResponseGroup</Code><Message>Your ResponseGroup parameter is invalid. Valid response groups for requests include Request

Transfer is Chunked!

GetChunkLength: 4f2 = 1266

, ItemIds, Small, Medium, Large, Offers, OfferFull, OfferSummary, VariationMinimum, VariationSummary, Variations, ItemAttributes, Tracks, Accessories, EditorialReview, SalesRank, BrowseNodes, Images, Similarities, Subjects, Reviews, ListmaniaLists, SearchInside, PromotionalTag, SearchBins.</Message></Error><Error><Code>AWS.ParameterOutOfRange</Code><Message>The value you specified for Count is invalid. Valid values must be between 1 and 25.</Message></Error></Errors></Request></Items></ItemSearchResponse></SOAP-ENV:Body></SOAP-ENV:Envelope>Connection Disconnected

CLOSED

REQUEST:

CLOSED

POST /onca/soap?Service=AWSECommerceService HTTP/1.1

ontent-Type: text/xml; charset=UTF-8

457

<?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"

xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"

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

xmlns:xsd="http://www.w3.org/2001/XMLSchema"><SOAP-ENV:Body><ItemSearchResponse xmlns="http://webservices.amazon.com/AWSECommerceService/2005-03-23"><OperationRequest><RequestId>1E8W10VZZ0NKAG2G29CF</RequestId><RequestProcessingTime>0.0119731426239014</RequestProcessingTime></OperationRequest><Items><Request><IsValid>False</IsValid><Errors><Error><Code>AWS.InvalidResponseGroup</Code><Message>Your ResponseGroup parameter is invalid. Valid response groups for requests include Request

Transfer is Chunked!

GetChunkLength: 457 = 1111

, ItemIds, Small, Medium, Large, Offers, OfferFull, OfferSummary, VariationMinimum, VariationSummary, Variations, ItemAttributes, Tracks, Accessories, EditorialReview, SalesRank, BrowseNodes, Images, Similarities, Subjects, Reviews, ListmaniaLists, SearchInside, PromotionalTag, SearchBins.</Message></Error></Errors></Request></Items></ItemSearchResponse></SOAP-ENV:Body></SOAP-ENV:Envelope>Connection Disconnected

CLOSED

REQUEST:

CLOSED

POST /onca/soap?Service=AWSECommerceService HTTP/1.1

<?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"

xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"

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

xmlns:xsd="http://www.w3.org/2001/XMLSchema"><SOAP-ENV:Body><ItemSearchResponse xmlns="http://webservices.amazon.com/AWSECommerceService/2005-03-23"><OperationRequest><HTTPHeaders><Header Name="UserAgent" Value="EasySoap++/0.6"></Header></HTTPHeaders><RequestId>0YG7810Y3NRJC0K5VD73</RequestId><Arguments><Argument Name="Service" Value="AWSECommerceService"></Argument></Arguments><RequestProcessingTime>0.00455307960510254</RequestProcessingTime></OperationRequest><Items><Request><IsVa

Transfer is Chunked!

GetChunkLength: 3d7 = 983

lid>False</IsValid><Errors><Error><Code>AWS.MissingParameters</Code><Message>Your request is missing required parameters. Required parameters include SearchIndex.</Message></Error></Errors></Request></Items></ItemSearchResponse></SOAP-ENV:Body></SOAP-ENV:Envelope>

CLOSED

REQUEST:

CLOSED

POST /onca/soap?Service=AWSECommerceService HTTP/1.1

a full or incremental rebuild should be performed on ebayapi.

If you generate a full rebuild on ebayapi, a message returns that having a problem

with the full rebuild and C0001: Illeal datatype: ns_buyingsummarytype

If you use the PB Paste function it works okay, or if you double click the Excel cell first to highlight/select the text, then it also works. However, if you just move to a cell and copy by either using the Copy menu in Excel or the Ctrl-Insert key combination, and then try to Paste into a PB datawindow using shift-insert, nothing is pasted. The text is in the clipboard, though, which can be verified either using the Paste() or Clipboard() function in PB.

SOLUTION: This turns out to be a problem with the Microsoft MultiLine edit control. The problem can be reproduced using Visual Basic. ( VB ) If the edit control is not high enough to hold 2 lines, the paste fails. The dw edit control is inherited from the MS multiline edit control.

There are two workarounds available

1. Use editmask instead.

2. Let the column be high enough to hold two lines.

That is, the component will have a different name than the NVO.

It would be good if this functionality could be extended to allow this to be case sensitive, and also to change the names of:

Package

Component

Method

Argument

The reason for this request is that currently all PB component names will be in lower case on the server.

In order to follow naming conventions in WebServices etc, it would be good to be able to have CamelCase naming for PB components as well.

Currently, the only way is to manually modify all the IDLs before exposing as web service.

by reference.

Getting an error on StringSeqHolder not found in interface.

Problem:

f_load_server_list had two arguments

reference string as_edb_server_list[]

reference string as_last_server

RESOLUTION:

Use the following:

org.omg.CORBA.StringHolder PArray = new org.omg.CORBA.StringHolder();

StringSeqHolder PbArray = new StringSeqHolder();

try {

li_rc = iJagComponent.f_load_server_list(PbArray, PArray);

as_edb_server_list = PbArray.value;

}

StringSeqHolder is case sensitive. Look at $JAGUAR\java\classes\packagename to see

how StringSeqHolder was generated. (That is: StringSeqHolder.class or STRINGSEQHolder.class).

Use StringSeqHolder to pass a string array by reference. Use StringHolder to pass a string by reference.

The PocketBuilder exe crashes and disppears upon the calls.

Passing complex datastructures, many containing arrays of chars cause

Application execution error R0015: Error external function call %s at line xx in function

When retrieving the table list and column lists, the calls behind the scenes have changed between PowerBuilder 10.0 and 10.1

Version 4.21.1088 (Build 14260.2.0.5) update from the Dell website. Since applying the flash update, he cannot run PocketBuilder apps that access the database, including our PK sample applications such as dwexam. There is no message, just a silent failure.

creates registry entries under 11.0.

HKEY_CURRENT_USER\Software\Sybase\PowerBuilder\11.0

HKEY_LOCAL_MACHINE\Software\Sybase\PowerBuilder\11.0

RESOLUTION: From the readme.txt, for this Beta 1 release, some registry entries are made in PowerBuilder

registry keys with the version number 11.0. The version number included

in the name of files, including the executable file, DLLs, and Help

files, is 110. All version numbers will be changed to 10.5 or 105 for

Beta 2.

as pbxxx110.dll. The executable for PB 10.5 beta 1 is pb110.exe.

RESOLUTION: From the readme.txt,

For this Beta 1 release, some registry entries are made in PowerBuilder

registry keys with the version number 11.0. The version number included

in the name of files, including the executable file, DLLs, and Help

files, is 110. All version numbers will be changed to 10.5 or 105 for

Beta 2.

Using 3rd party FieldSoftware Printing API.

The datawindow print function with argument " showprintdialog = true "

sets a datawindow in printpreview mode back into normal mode.

that is longer than 32K, the following error will result:

DataWindow Wizard

Cannot create DataWindow

'Unclosed quote before the character string"".

In the pbtrace.log, the following is listed:

(b5b3c4): SRV 15 #105 Unclosed quote before the character string '"'.

(b5b3c4): SRV 15 #102 Incorrect syntax near '"'.

(b5b3c4): *** ERROR 105 ***(rc -1) : Unclosed quote before the character string '"'.

From Engineering: Not a bug. CSV files are comma delimited text files. Each data value may be enclosed in double quotes when written if the string contains characters that might cause problems. Like a comma for instance. So the data value abc is written as abc, but a,b,c is written as "a,b,c". When reading a CSV file if a data value is enclosed in double quotes, the quotes are removed. So when reading abc you get abc, and when reading "a,b,c" you get a,b,c. You can see this behavior in PB reading and importing CSV files and other applications like Excel. So the customer needs to follow similar rules when writing his CSV file if using PB to read it, double quotes enclosing a data value will be removed on import. If you want "xxx" as the data value, you need """xxx""" in the csv file.

pArrayItemCount = m_pSession->GetArrayLength(m_filetypes) ;

using the wrong decimal separator, dependant on control panel settings.

RESOLUTION: The following events have been added to the datawindow control and user-defined events - pbm_dwnexpanded, pbm_dwnexpanding, pbm_dwncollapsing, pbm_dwncollapsed.

on the toolbar menu or are not transparent on the toolbar for contemporary

and flatbar menus and toolbars.

For traditional menu, the image is either particially cut off or is greyed out.

The detailband slides up too much, overlapping columns.

a number to a decimal variable, the decimal variable is truncated.

Problem happens using the O84 driver with Oracle 8.1.7 client and Oracle 9.1 server.

Other problems seen:

Using Oracle 9 client and Oracle 9 server and the O10 driver - value returns 0 instead of 12345

Using Oracle 8.1.7 client and the Oracle 9 server and the O90 driver - value returns 0 instead of 12345

RESOLUTION: Use disableunicode=1 when using the O84 driver.

DataWindow Decimal column with editmask '+++000/0000/0000+++' does not allow proper input.

Engineering states this is because these functions and events only work in the detail band, and only the lowest treeview level (the leaf level) is in the detail band. Some new functions are being considered to address this issue.

The syntax that is used is:

dw_1. describe("columnname.Type")

the following error will result:

Powerbuilder Application Execution Error (R0039)

Application terminated

Error: Error accessing external object propertly name at line 4

If the first two characters of ANSI text file are equal to HA, these letters are skipped in the import.

dw_1.Find ("decimal_id IN (561, 562, 563)", 1, dw_1.rowcount())

And it is returning "Invalid expression" in PB 10.5. It was fine in 10.2. decimal_id is a decimal{0} column. A similar Filter criteria also returns "Invalid Expression".

For PFC apps that are migrated to PB 10.5 it is causing a conflict as the pfc_u_em object has a flags argument in it's pfc code and that conflicts with the new editmask flags property.

So if the new flags property needs to be there, fine. But lets document it. Please assign the resolution to PB Documentation if this is so. If it does not need to be there, let's get rid of it so we don't cause problems for PFC users.

PFC user's can change the name of the flags argument in the pfc_u_em object every where it is used to avoid the conflict.

This worked okay in PB 8. Customer reported this worked in PB 9, but in build 8511 it crashes. Latest build of PB 8 does not crash.

SOLUTION: The fix for this is to raise a runtime error instead of crashing. Type checking has been increased in PowerBuilder so there are certain things you used to be able to 'get away with' that no longer work. The solution for this customer was to add more type checking in their case statement in order to prevent the situation from occurring.

SetDataDDE still fail to return data in event RemoteSend to VB6 DDE Client.

A datawindow with a date column with both format and editmask set,

shows an incorrect format after choosing a date from the calendar.

Inputting a date with the specified format in the dw in the browser causes a validation error.

printer. The Print() function doesn't return any value, it crashes in the

Print() call.

Workaround:

The PrintOpen() was returning the error handle of -1.

The customer code should be checking this return value before continuing (since the printer has not been opened.)

So problem 1 is why is FileRead in PB 10 getting different results than PB 8, reading the same file? Problem 2 is why isn't FileRead and FileReadEx getting the same results in PB 10 reading the same file?

The text file does have binary 0 characters (nulls) in it. The help in both 8 and 10 say the eof character is a null, and if one is encountered, PB thinks it is the end of file. That looks like what is happening to FileReadEx, but FileRead is getting messed up by the nulls and reading too much per line. But the PB 8 FileRead reads this file perfectly, it has no problem with the nulls. The PB 10 FileRead (and the FileReadEx) should be doing the same as PB 8, and getting the same results reading this file.

The only thing I could do to inhibit the retrieval argument dialog was to insert a blank row in the dddw and save it with that blank row, But that's whats in the criteria drop down as well, just a blank row, no values to pick from.

So this is a request to somehow use the instance of the dropdown datawindow in the main datawindow for the criteria, not a brand new instance. Maybe do a sharedata from the main datawindoiw instance to the criteria instance. I would do that but have no way to get a reference to the dddw used by the criteria.