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

ex:
If na and nb are numeric columns and compute_1 is made up of 'na+nb' and na and nb are null, the computed field will turn from NULL (blank) to zero when the expression is changed to "na". It should remain NULL since one or both of the columns is null.

Datawindow with string/character colum with an editmask. Highlight value in column and press the Delete key. When user tries to reenter data the first character input is ignored and does not appear. All subsequent characters are fine.

As an example if a character column has an editmask on it and the string is 'ABCD'. Highlight the entire string and hit the delete key. Try reentering 'EFGH' and you will only see 'FGH'.

Appears to work fine in 7.0 builds > 8025

Map the pbm_paint in the window and place following script in the event:
dw_1.setredraw(FALSE)
dw_1.visible = FALSE
dw_1.setredraw(TRUE)
dw_1.visible = TRUE

Rich Text Datawindows also leak when printing - about 2MB for 10 pages (with metafile)

The dialog comes up but the selections does not apply after closing the dialog

--> This problem is not going to be fixed due to 16-bit PB6.5 version is nearing end of life.

If you don't do a Library Painter/Full Rebuild (regenerate) on ALL the client objects - esp the proxy object - before re-running the client application AFTER RE-DEPLOYING COMPONENTS WITH NO INTERFACE CHANGES TO JAGUAR - you will GPF on the CLIENT or HANG at the first remote function call.

After regenerating the client application, the client will immediately begin working again.

in development or runtime (p code and machine code), when isnull

is used with the any datatype.

The test case has a do while loop that runs with 10000 iterations

any test_string

do while myint < long(sle_1.text)

isNull(test_string)

myint ++

loop

Memory usage goes up as follows for a pcode exe:

Memory VM Size

1. 4488 2456

2. 4572 2540

3. 4652 2620

4. 4728 2696

On the other hand, it works perfectly for large amount of data when using Jaguar 3.5 on Win NT accessing the same ASE database on SUN Solaris.

Easy WA:
Just code: (Example)
IF m_genapp_sheet.m_edit.Visible THEN
m_genapp_sheet.m_edit.PopMenu(1024,384)
END IF

This has been reproduced in ODBC and SYC which rules out some ODBC interaction with owner in PBODB70.ini.

CR207744 was a GPF building a crosstab. Fixed in 7.0.2 8011 or so.

This fix requires at least PBWIZ70.DLL and PBDWE70.DLL.

DBMS or8 oracle 8.0 is not support in your current installation.

Works ok when using oracle 8.0.3 client. Works ok using oracle 7.3 and the o73
driver.

Also, in the script painter, right -mouse/paste special/instance also shows all instance variables defined in the ancestor object or in the CURRENT descendant object in lower case.

Developers Comments:
This is not a bug. This doesn't work because of the close in ue_retrieve of w_cancel. The doc indicates that the post messages are written to a different queue from the window's message queue, therefore you don't have control over either message. What is happening is that the return of w_cancel is not occuring until after w_info has been opened. If you had script following the OpenwithParm of w_cancel, you would see that this isn't occuring until after w_info is closed and there is nothing in the message object because the OpenWithParm for w_info cleared the message object.

This problem happens for PB SQL painter regarding ODBC connection to DB2 on MVS. The 2 join selections unsupported are :-
= table1.id = table2.id and rows from table1 that have no table2
= table1.id = table2.id and rows from table2 that have no table1

PowerBuilder ODBC to DB2 UDB on NT is OK.

This might be because the script painter is slightly different for global functions. They only have

f_test
(Declare)

in the listbox and (Declare) only has Global Variables and Global External Functions. A user object would have:
uo_test
(Functions)
(Declare)
and (Declare) would have 5 different items, (Global, Instance,Shared variables, Global, Local External Functions)

7.0 GA build 5031 and 7.0.1 build 6012 have this problem. 7.0.2 (build 8003) or higher seems to work fine.

The WHERE Tab has the columns "Column, Operator, Value". You used to be able to right mouse on the "Value" column in an EDITABLE field and get the popup menu containing:

Columns...
Functions...
Arguments...
Value...
Select...
Clear

In 7.0.2 8033, the menu does appear but only when on the 'Header' part of the tab (when placed over the header label "Value" in the value column.).

Appears fine in versions 6.5.1 620 and 7.0.1 6012.

Note: This could also happen in InfoMaker in the report painter or in a runtime executable since it's always in print preview mode.

The default behavior causes the where clause to produce a scientific notation for a numeric (integer or long) retrieval argument.

Ex: where id = 1.3e1

which can often cause table scans if the numeric retrieval argument is large. There is no way for the average developer (or InfoMaker end user) to know the effect of this DBPARM default value on their queries.

I have three objects A, B, C. C is inherited from B and B is inherited from
A. I delete B and create a new object D, inherited directly from A.
A this point, I have object A and object an object C that is no longer
valid - the object it is inherited from, B, no longer exists.
If I try to save the new object D with the same name as object C,
overwriting C, PB GPFs.
In previous versions the new object would be saved without a problem and would overwrite the object with the missing ancestor.

Workaround:
Use Round(Truncate((( sj_b_npric * ssj_sh_qty) + 0.000001),4),2).

Happens in NT and Win98 (suspect Win95 too). Also, PowerBuilder 5.0 and 6.x have this behavior but 7.0 does not.

In PB 6.5.1 if you try to choose a descendant ot inherit from that has a missing ancestor you will get the standard Inherit of 'xxxx; failed Possible causes 1- Object does not exist"

Let's say you have a base menu 'm_base' and create a descendant called 'm_level2' and then inherit 'm_level3' from 'm_level2'. Now delete 'm_level2' and try to open 'm_level3'. You will get the standard: Open of menu 'm_level3' failed. Possible causes: 1 - Object does not exist, etc. You will also get this error message if you try to inherit from this menu in PB 6.5.1 but in all versions of PB 7.0 tested when you try to inherit from this menu with a missign ancestor you will crash.

5.0.04 - 04 25 2000 07:05:21 (1543) 2000 07:05:21
6.5 - 04 25 04 25 2000 07:05:21 (1543) 2000 07:05:21
7.0.2 - 04 25 04 25 (1543) 2000 07:05:21

Ex:
convert(varbinary(1),:ts_1) +
convert(varbinary(1),:ts_2) +
convert(varbinary(1),:ts_3) +
convert(varbinary(1),:ts_4)

Workaround is to use Disablebind=1 in the DBPARM (Profile painter, transaction tab)

If the editmask is ###.00 the behavior is the same in both PB 7.0 and 8.0 in that you can get past the decimal point ( which may be an intended change in behavior in both PB 7 and 8 but I could not find it documented), but the data entered into the column is correct.

Development: We made a conscious decision in 7.0 to expose the datawindow syntax as much as possible (consider it a way for the user to learn syntax ) .. and .. ResetPageCount is the syntax (property) for what was once "Reset Page Number on Group Break".

Work-around is to export the datawindow and change the column type from real to number.

External function is user defined. Generated in c++ and calling
the java jvm. Using jdk/jre 1.2.1. PB crashes in development and runtime when
calling.

Problem only happens on win95. Ran a test on win95a,win95b and problem
happens on both. Also installed dcom95 and checked the security and problem
still happens. It appears to be environmental because on one win95 machine,
problem doesn't happen. Both machines are running dcom95 and pb 7.0.2
8026. Also ran msinfo32 and both machines are using the same system dll's.

Need to know what conditions pb is checking for a com/mts project/select objects.

The dw is using a sp and is set to updateable from rows/stored
procedure update. When you call that component from a pb client,
the component fails on the settransobject only on jaguar on solaris.
Works ok on nt. If the sp update is reset from rows/stored procedure update
so that it isn't updatable, than the data is retrieved back to the client. No problems.

Happens for an ASE stored procedure and Oracle. Doesn't appear to be
db specific.

Works up through 7.0.2 8003.

In Powerbuilder 7, empty names for nested reports within a composite DW are not allowed anymore.
Then, during migration, any nested report is renamed with the syntax dw_{x} (based on the Design/Options/Prefixes setting for a nested report) if it was created without a name in a prior version.

If you happen to use a name similar to the dw_{x}, you could get into trouble.

For example, if a composite datawindow had 4 nested reports (in PB 6.x) named :
dw_1 / <empty name> / my_nested_1 / dw_2

After the migration (from PB 5 to 7 or PB 6 to 7), the names are automatically changed to :
dw_1 / dw_2 / my_nested_1 / dw_3

So any script reference to the nested report dw_2 now refers the second nested report while it refered the fourth one before the migration. (You'll get strange behavior with GetChild(), perhaps with dot notation, etc).

Workaround:
The collision is caused by the naming conflict. The user might go in ahead of time and change the default 'datawindow' naming prefix from 'dw_' to 'dwn_' before migration.

With 7.0 build 8026 the crash is.
"Instruction at 0x1133d5d4 ref'd memory at 0x00000000...could not be READ."

char charvar
charvar = lds_tmp.Object.a[1] // Crashes

Only PB6.5.1 does not exhibit this problem. From this analysis, I believe PB6.5.1 produces the correct result and the other builds have regressed with respect to the functions SUM() and COUNT() ;

PowerBuilder goes down faster than the NASDAQ on a bad day.. (SYC, MSS) are affected. All other drivers seem to be OK.

There are several other ways to get this GPF, all related to the profile NOT having a database specified. In these cases, if the "Change Database" dialog comes up and you choose to Cancel out of the dialog without selecting a database, PowerBuilder will GPF. Here are some scenarios (anywhere there is a connection tried):
1. Last connection is one without a database specified in the database profile. Go into PB and open a datawindow but cancel out of the "Change Database" dialog. You will soon GPF (DW Painter)
2. Script painter with embedded SQL. When you save script and are not connected to a database, the IDE will attempt to connect - "Change Database" dialog comes up - cancel out - GPF.
3. Compiling a script manually (Control-L) and cancelling out of the dialog "Change Database".
4. Opening the database painter (same scenario)
5. Creating a new datawindow.
6. Data Pipeline

Workaround:
use PowerBuilder Units

The actual SQL in the PBODB70.ini that the native driver uses is below (where &objectname is something like 'PROC1' and &ObjectOwner would usually be 'SYS'

[Oracle 7] or [Oracle 8] section of PBODB70.ini
PBSelectProcSyntax='SELECT TEXT FROM SYS.ALL_SOURCE WHERE NAME =

''&ObjectName'' and OWNER = ''&ObjectOwner'' ORDER BY

SYS.ALL_SOURCE.LINE'

When placed in the PBODB70.ini, it doesn't seem to work.

This problem occurs for "user" object functions. When a library pbl is incrementally
rebuilt as machine or pcode, the minor changes in the source code of
"user" object functions causes an incorrect runtime display ;

I tested this with small changes to function scripts e.g. comment lines, code lines etc. and
NOT argument interference like datatype(s) which are factors necessitating a full rebuild'.

I verified that "window" and "menu" object functions are not affected by this behaviour.

Analysis:-
====================
a)Why has PB made differences in the export order syntax ?

b)Can this influence be removed so as to revert to PB6 behaviour ?
If "No" then PB documentation needs to be changed from "Building individual dynamic library"
to "Necessary for full application recompile".
See PB7 'Application Techniques' Manual.
Page 724: Building individual dynamic libraries.

There are 4 workarounds which will help to deploy "individual" pbds.

"You do not have the required version of 7.0 or 7.0.1 Enterprise installed on your machine. Please install those products and then run PowerBuilder 7 maintenance setup again."

Resolution:
The artwork on the CDs is wrong. PB Professional and Desktop customers and InfoMaker customers can download the "PowerBuilder 7.0.2 EBF#2" from "MySybase". These customers must already be using PB 7.0x in order to apply this EBF (PB 6.x customers need to upgrade to version 7).

Seems to be a similar problem to the composite wizard slowdown CR214970. It appears to hang.

When the classpath and ld_library_path point to jdk 1.22 the error occurs.
If the classpath and ld_library_path point to jdk 1.1 then no error.

In 7.0.2, the output of some of these migrated datawindows are displaying the wrong width (too wide) causing bad rendering of tabular data in Internet Explorer vs Netscape.

(Generally, the behavior causes data that fit in the page width to now widen beyond the page)

Discussion: With the recent fixes to the HTML generator to help Netscape positioning, it's possible old workarounds useful in PowerBuilder 6.5 using "SaveAs(HTMLTable!)" don't work. One trick was the addition of fields containing just spaces to help 'space out' tabular data. These are so-called placeholder fields helped to better position and size the real columns but in 6.5 and 7.0.1 they did not get rendered as actual HTML table elements. In 7.0.2, these placeholder columns now become table elements and cause the HTML to "Space out" the data causing the output to look wrong. Users using this method should review their tabular datawindows and take out the placeholder columns.

Here is an example:

[column] [ placeholder ] [ column] [placeholder] [column]

The 'placeholder' fields would just contain 5 or 10 spaces. In 7.0.2, these become table elements so instead of having 3 columns of tabular data, you have 5 columns of data.

Workaround :
Problem can be workaround by export dw object and change relatedt NUMBER or REAL datatype to DECIMAL(5) and reimport into the dw object.

This was broken around 6.5 1189 and 7.0.2 8030.

SmartHeap error handler recursively reentered
Abort, Retry

The following error appears in the srv.log file:
May 17 08:40:48 2000: HTMLDW: Entering SetSelfLink('testjdsbonnoamt.htm','')
May 17 08:40:48 2000: HTMLDW: Entering SetWeight()
May 17 08:41:00 2000: SIGABRT 6* abort (generated by abort(3) routine)
May 17 08:41:00 2000: si_signo [6]: SIGABRT 6* abort (generated by abort(3) routine)
May 17 08:41:00 2000: si_errno [0]: Error 0
May 17 08:41:00 2000: si_code [-1]: SI_LWP [pid: 14648, uid: 1001]

mem_bad_mem pool error
abort, retry

The following errors appear in the srv.log:
May 17 09:53:03 2000: HTMLDW: Entering Generate()
May 17 09:53:21 2000: SIGABRT 6* abort (generated by abort(3) routine)
May 17 09:53:21 2000: si_signo [6]: SIGABRT 6* abort (generated by abort(3) routine)
May 17 09:53:21 2000: si_errno [0]: Error 0
May 17 09:53:21 2000: si_code [-1]: SI_LWP [pid: 15309, uid: 1001]
May 17 09:53:21 2000: stackbase=0, stackpointer=CCA11B4C

Per Development:
Made the following change to testhtml.htm and problem went away:
I found that the following line in the .htm file maybe the cause that hangs the server:
dwMine = new PSDataWindowClass("htmlDW", true, jagConn, dwCource, dbConn);
You should change this to the following and have a try:
dwMine = new PSDataWindowClass("htmlDW", false, jagConn, dwCource, dbConn);
With the second parameter set to "false", a SetComplete() will happen after the Generate() method (of the HTML Generator) is called. This allows the HTML generator to be deactivated and pooled.

This was caused by the to CR208886 in 7.0.2 8025, after this, several behaviors are noticed:
1. A partial value "123" in a 10 character phone editmask now shows "(123" without the closing paren ")"
2. Gettext() and/or dwo.data for the char(10) field with 3 characters (not completely filled field) returns only 3 characters.

Also, in the past, if you entered "123" in char(10) field, The datawindow would put "123<7 padded spaces> in the buffer so with Update() and subsequent retrievals, the mask was always "Filled" to 10 characters.

In other words, in the past, no matter how many characters were in the char(10) column buffer, Gettext() ALWAYS padded the data in the past.

This is not a PowerBuilder bug but is being noted since a lot of customers will hit this upgrading from prior versions of PB (4.0-6.5) to PB 7.0 and using the SQL Server 7.0 ODBC driver "SQLSRV32.DLL" version 3.70.06.23 against SQL Server 6.5 databases and ODBC version 3.51. This is not a problem in prior versions of PowerBuilder.

To tell what service packs (if any) are installed in SQL Server 6.5:
Issue the following in the ISQL_W tool for SQL Server or in the database painter, ISQL view

Select @@version

You should get back a version string... Here's the decoding:
6.50.201 - Original SQL Server release.
6.50.258 - Service Pack 3

An ODBC trace might reveal:
DIAG [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]The ODBC catalog stored procedures installed on server <XYZ> are version 6.50.193; version 07.00.0523 or later is required to ensure proper operation. Please contact your system administrator. (0)

We also made updates to the pbodbxx.ini files for the newer driver:
(an ODBC trace will identify this driver as "Microsoft SQL Server" - which will be used to look up a section in the pbodb70.ini.

Original pbodb70.ini
=================
[Microsoft SQL Server]
PBDateTime='DEFAULT_DATETIME'

[DEFAULT_DATETIME]
PBDateFmt=''{d '\'yyyy-mm-dd\'' }''
PBTimeFmt=''{t '\'hh:mm:ss\''}''
PBDateTimeFmt=''{ts '\'yyyy-mm-dd hh:mm:ss.ffffff\''}''

New pbodb70.ini
==============
[Microsoft SQL Server]
PBDateTime='MSSQLSERVER_DATETIME'

[MSSQLSERVER_DATETIME]
PBDateFmt='\'yyyy-mm-dd\''
PBTimeFmt='\'hh:mm:ss\''
PBDateTimeFmt='\'yyyy-mm-dd hh:mm:ss.fff\''

Solution: Upgrade you SQL Server 6.5 to at least service pack 3 and check your PBODB70.ini for compatibility.

May 18 12:16:20 2000: DEBUG: ravitest/n_pbsolarisbug1 (constructor)
May 18 12:16:20 2000: DEBUG: ravitest/n_pbsolarisbug1/$Activate (bind)
May 18 12:16:20 2000: DEBUG: ravitest/n_pbsolarisbug1/solarisbug__N
May 18 12:16:20 2000: DEBUG: ravitest/n_pbsolarisbug1/$Deactivate (unbind)
May 18 12:16:20 2000: DEBUG: ravitest/n_pbsolarisbug1 (remove container 686)
May 18 12:16:20 2000: DEBUG: ravitest/n_pbsolarisbug1/$CanBePooled (poolable)
May 18 12:16:20 2000: DEBUG: ravitest/n_pbsolarisbug1 (destructor)
May 18 12:16:26 2000: SIGABRT 6* abort (generated by abort(3) routine)
May 18 12:16:26 2000: si_signo [6]: SIGABRT 6* abort (generated by abort(3) routine)
May 18 12:16:26 2000: si_errno [0]: Error 0
May 18 12:16:26 2000: si_code [-1]: SI_LWP [pid: 19008, uid: 1001]
May 18 12:16:26 2000: stackbase=0, stackpointer=ECD21F0C
May 18 12:16:26 2000:

The following are the results of the build in pb:

---------- Deploy: Deploy of p_testcrash6
Performing Incremental Rebuild of Objects
Parsing User Object uo_testcrash6...
Beginning generation...
Generating IDL file...
Generating IDL file...
Generating Type Library...
Generating the PB COM Server
Generating GUID source file...
Generating Interfaces header...
Generating Classes header...
Generating Server Data source file...
Generating Classes source...
Generating server resource file...
Compiling GUID Source File ..
Compiling PB COM Object Source File ..

Compiling PB COM Server Source File ..

Linking PBCOM Server object files

Generation Results:
OBJECT INSPECTION RESULTS:
uo_testcrash6
Instance variables:
Instance Variables: PASSED

Functions:
Functions: PASSED
BUILD RESULTS:
IDL File Generation: succeeded
Component Server Build: failed
---------- Finished Deploy of p_testcrash6

Possible Workaround:
Start specifiying the query in row 1 of the dw.

When the frame is put back so that both activex controls are showing than
triggerpbevent works.

This is not a bug but a behavior change due to starting to use the Micrsoft native listview (also treeview) starting in 7.0. PFC and the PFC examples are not affected as there is no code in the itemchanging, and itemchanged events. Customers that have code in either of those two events may be affected and should review the code in light of the behavior change. This CR has a good description and a table of the change in the number of times times the events fire and the arguments passed to them. A possible workaround is to declare an instance variable for each event and save the value of the index argument as the last thing in each event. At the start of the event compare the passed index to the instance variable to determine if an item has changed.

This has been fixed in builds beyond May 24, 2000. (pbvm70.dll)

New function should be provided or Dec(string) should only interpret numbers in a string with the syntax we use in PowerScript if you declare a decimal value.
Example:

DEC does not return 0 for a failue if decimal sep = "," and group sep = "." with a group length of 3
String is for example:
"123.2.2.3,123" -> 123223,123
"1.2.3.4" -> 1234
There the DEC fucntion should return 0 becuase it is not a legal decimal value.

ds_1.saveas() works fine if the Jaguar 3.5 is on NT, but fails if Jaguar 3.5 is on Solaris.
A empty file is created.

I also verified that the saveas powerscript function worked by creating a standalone application with the Solaris version of PowerBuilder 6.5

If you want to CREATE a group datawindow with a group by, say, Month(Birth_date) - and this is important - UP FRONT - you can't do this. You have to use "birth_date" only (which puts it in sort & group expressions) but you then have to remember to GO BACK and edit the sort and group expressions or your result set will get all messed up.

SQLSTATE IM002 - [Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified.

Workaround: Set "Connect type" to the default "SQL_DRIVER_COMPLETE".

When Error occur, following symptom may be observed :
a) occur on browser -
request from browser never come back from webserver, Jaguar server failed to respond HTMLDW request.

b) occur on Jaguar Manager : Runtimes Monitoring : Datawindow : All Component
no. of INSTANCES ACTIVE will be raised up and used up all INSTANCES POOLED. i.e. each additonal HTMLDW request will add one more ACTIVE instance. And all ACTIVE instance will not release back to system or instance pool.

c) occur on Jaguar Console -
MEM_BAD_POINTER Abort or Retry ?
or
BAD_MEM_POOL Abort or Ignore ?
If choose ABORT, Jaguar will stop and trap all context information of each thread into srv.log.

d) occur on Jaguar Console -
SmartHeap Error Handler

WORKAROUND:
Set the component (DataWindow/HTMLGenerator) property using Jaguar Manager to disable the "Concurrency" item on Instances Tab.

With the Edit Labels property checked a user can edit a label at runtime but when pressing <Esc> nothing happens. Not able to capture the escape key once a treeview item is being edited.

Ct needs the standard Windows functionality supported in PB 7 treeviews so that when the ESC-key is pressed the old value is recovered

Fixed around 7.0.2 9012.

http://localhost:8080

for Jaguar 3.5 and 3.6. This is not in the Sybase menu.

Development has indicated that this is not a bug with the following statenment:

GetChanges()/SetChanges() are designed to work in symmetry. When you do a getChanges() from a client, a set changes on the server is assumed, followed by an update and get changes on the server and SetChanges() on the client().

The first getchanges() leaves behind markers indicating .. we've sent some data for remote update and the expectation is that we will hear back from the server that the updates completed, at which point the markers are cleared.

The first GetChanges() loads the data into the blob to be sent and sets the flags indicating "remote update pending".. A second get changes on the client sees those flags and acts accordingly.

It is important to remember that client->getchanges..server->setchanges..server->getchanges... client->setchanges is one logical operation and should be done in this order to succeed.

Development: This appears to be a Microsoft bug. The information they are given when they do not
enable the scroll bar is exactly the same information they are given when the user resizes the window and they enable the scroll bar. it appears to somehow be related to timing.

Believe it's related to CR215513 and CR214817.

No file is created.

Per PB Product Management, this is not a bug (This issue has been submitted as a New Feature Request/Enhancement Request, CR 224087):

The following information is from the PB 7.0.3 Maintenance Release "readme":

The PowerBuilder 7.0.3 version of the PowerBuilder VM must be available on the server.
The PowerBuilder VM includes PBVM70.DLL, PBJAG70.DLL, PBDWE70.DLL, and other
PowerBuilder files required at run time.

On UNIX, the shared libraries are called libpbvm70x.ext, libdwe70x.ext, and so forth, where
ext is the shared library extension for each UNIX platform. These runtime libraries do not
provide support for Windows API calls or graphical operations, including printing. If you deploy
a PowerBuilder component to an EAServer host running on UNIX, the component can have
neither graphical dependencies nor dependencies on the Windows application programming
interface.

This happens in development or at runtime using SQLCA.DBMS="TRACE <any driver>" in script.

Observed around build 6.5 1195, 7.0.2 8037.

6.5 1195 - Error. "Could not load database interface". OK in 6.5 1191.
7.0.2 8037 - Error. "DBMS not supported in the current installation".

Exception code: C0000005 ACCESS_VIOLATION
File Name: d:\pb70\shared\powerbuilder\PBVM70.dll
File Version: 7.0.2.8037
Fault address=11318EFE Section:Offset=01:00177EFE

Fonts affected most: Arial, Tacoma, Times New Roman

The Arial.TTF from Office 2000 is dated 10/16/1998. The one that does not exhibit the leading space is dated 11/18/1999.
The Tacoma.TTF that exhibits the bad behavior is dated 11/18/1999 exhibited the problem.
The Times.TTF that exhibits the bad behavior is dated 10/16/1998. The 11/18/1999 version seems to be OK.

In summary, it appears users should get the 11/18/1999 fonts - EXCEPT FOR Tacoma.TTF.

To see what version you have for Arial, go to \winnt\fonts and doubleclick on arial.ttf.
- bad version 267KB, Version 2.50 dated 10/16/1998
- good version 148KB, Version 2.50 dated 11/18/1999
Arialbi.ttf, ariali.ttf, arialbd.ttf are the others of the arial family.

filename - A string whose value is the name of the file you want to open. If filename is not on the current directory's **relative search path**, you must enter the fully qualified name.

#######-xxxxxxxxxxxxxxxxxxxxxx

is initialized with em_1.text='0000000'. In older builds, this would produce:
0000000-

now it produces 0000000 without the '-' and you can't finish or type into it.

SQLSTATE 37000 [Sybase][ODBC Driver][Adaptive Server Anywhere] syntax error or access violation.

If you've downloaded the 7.0.2 ebf builds after May 2000 (after 7.0.2 maintenance) and you still get this error, it might be the ODBC driver versions you're using. Make sure you're using 3.5 ODBC (ODBC32.DLL, etc of 3.51).

To test if this is the issue, connect to EAS Demo DB V3 and create a stored procedure source datawindow with the stored procedure 'sp_sales_orders'.

I instantiated a second datastore lds_store.

lds_store.rowcount() returns inconsistent results from Jaguar on Solaris, but works fine on Jaguar for NT
The rowcount is correct sometimes and 0 is returned at other times, there is no consistent pattern.

####0 causes this problem on a window mask or datawindow mask on a numeric column with no decimal part.

6.5 1141 was OK
7.0.2 8003 was OK, 8011 broken.

Workaround: If possible, turn autosizeheight ON for the detail band. (on some designs, this might not be possible.)

The following appears in the srv.log:
Exception 'CosNaming::NamingContext::NotFound' in Session::lookup for
component 'Cust1Pkg/n_cust_balance'
SystemException: OBJECT_NOT_EXIST (Session/lookup - jagadm)

On nt when the same scenerio is run, the following appears in the srv.log:
PowerBuilder Application Execution Error (R0002) Application terminated.
Error: Null object reference at line 30 in function cust_txn of object n_cust_txn.
Jun 09 15:30:20 2000: DEBUG: CustomerPkg/n_cust_txn (insert container 409)

The server does not crash on nt. The following error appears in the pb client:
Unknown System Error/Exception
ErrorNo: 20502, Text:Null Object Reference

- go into 7.0.2 ebf into any script. Right mouse. Design/Options. Pull font tab forward.
- Select Small Fonts and size 7 points. Notice the font used in the script shrinks but is OK from a readability standpoint.
- Change the font size from 7 to 8 or 9 (keeping Small Fonts). Notice the blotchy, block font you see that is bold and unreadable. This is what a user is seeing in Windows 2000 on SOME machines for the font used in some system views (titlebars) and in the library painter.

PB 7.0.2 will have the blocked fonts until you use the workaround in article "Q198389 - WD2000: Dialog Box Text Truncated" which basically says set your SYSTEM font to SMALL FONTS from LARGE FONTS using the desktop properties.

The print cb calls the pfc_print from pfc_u_dw. The pfc_print calls the pfc_printdlg.
The pfc_printdlg calls the pfc_n_cst_platformwin32. This object has an external
function called:
pfc_printdlg(ulong hwnd, ref s_printdlgattrib printstruct) library pfccomm32.dll.

Per PB Development:
This is not a PB bug. The people who write the printer drivers have the option of following the pre-defined tray-designations, or coming up with their own driver-defined tray designations.

Workaround: Use a third party utility to determine the tray numbers. One example:
http://www.powerwhizz.com/

Users might see "blank space" areas due to this bug.

I have tested with minimal database parameter settings i.e. None/nothing, dbparm=''
for an ASE11.92 database for native and ODBC interface.

This memory leak appears to be for PB7.x release only.
PB651.x has some memory leak for PB native ASE driver.

7.0.2 8003 worked OK but 8011 exhibited the problem.
7.0.2 8025 and above is where this is fixed.

com objects can take arguments that use datatypes of:

- Standard OLE automation data types

- Custom class (nonvisual) user objects

However when trying to pass com objects registered thru MTS, i.e.

an intercomponent com object passing an nvo by reference,

will give the following error:

Error Number: 20535

Error Text: Error calling external object function im_method2

Error Object: n_mtscomp1

Error Script: im_method1

Error Line: 23

Acording to Development:

Passing NVOs by reference with intercomponent com objects is not currently supported.

However, passing NVOs by value should work but does not.

Passing nvo's to client applications is never supported by the COM/MTS project because they would not be in the same thread.

Broken in 6.5 1197 and 7.0.2 8030.

Ocx name = Netronic varchart xgannt. Vendor = Netronic. http://www.netronic-us.com/

In the sample using PB 7 if you use the Browser all the OCX's event look fine. Some events fire and some don't. The ones that fire are standard clicked, doubleclicked the ones that don't are the OCX's events like "ondatelinemodify", : "onnodelete" and "onnodecreate".

Exception code: C0000005 ACCESS_VIOLATION
File Name: E:\Builds\PB 7.x\PB7Latest\pbO8470.dll
File Version: 7.0.2.8037
Fault address=02F6492F Section:Offset=01:0000392F
(full file in 20208129.zip)

Choose sp_addlogin and you'll see it truncated to 4000 bytes - even if DBTextLimit is set. The datatype for the stored procedure text column is nvarchar in the DB Painter.

SQL Painter. Cannot switch from design to SQL mode in datawindow painter when the user is not logged on as 'sa'. If you create a datawindow as "sa" (dbo) and the select looks like Select au_id from authors (pubs database) in Microsoft or Sybase SQL Server and then log on later as "user" with access to authors, when you click on the SQL button in the datawindow painter, you get "Could not reconstruct the statement graphically. Do you want to continue in graphic mode?"

You can RUN the datawindow as non-dbo "user" but the SQL painter won't let you edit it.

NOTE: Using 'Select au_id from authors' works in Microsoft SQL Server's ISQL tool without using dbo prefixing when logged in as "user".

Workarounds:
1. Create an alias for "user" called "dbo" for the database (pubs in this case)
2. Prefix all SQL with dbo (Select dbo.au_id from dbo.authors)

This was fixed in later builds and works fine in 7.0.2 8045.

Workaround: use standard component instead of service component

WA:
place another "empty dummy" nested report in the right corner of the dw ie. if your columns extends across 3 pages horizontally put a nested report at the top right position.Make it invisble with adjusting the background color to the col. of the base dw

The return value is correct for PB7.x when the "cancel" cmdbtn has been clicked i.e. li_ret = -1 ; because the print job is aborted by the user.

The impact of different PB version return values is confusing to the system developer because of the inability to successfully react to whether the end user has aborted the print.

PB7 is erroneously displaying a picture for some treeview items even though the row item properties have been set to 'none' i.e.
PictureIndex = 0 , SelectedPictureIndex = 0

With a simple scenario:-
Treeview
Root
|--->A(1)
|--------->C(1.1)
|--------->D(1.2)
|--------->V(1.3)
|--->B(2)

The result is that :
Level 1.2(i.e. D) AND siblings (except for 1.1)
Level 2.0(i.e. B)
will display the picture assigned to PictureName #2 ;

The message of "No such file or directory" also appears on the jaguar server
console.

If no dddw is included in the dw on the client side, than no problem.

This works in 7.0.2 8003 but fails in builds 8033 and above including 7.0.2 8046 C3.

Workaround: Create a user event on the OLE control called
"SaveObject()" with no arguments and no return type (None). Add just a comment line in the event.
This feature was added by customer requests, and is a full-fledged event in PowerBuilder 8.0.
Typical logic for this event would be to retrieve the blob "ObjectData" and save it
away someplace.

This has actually never worked in any build of PowerBuilder 6.x or 7.x

Fixed in 6.5 EBF and above in builds after 7/27/2000.

Work-around : print the function from the library painter or copy paste it the scrip to a file editor

A new row is inserted and populated with data on a pb client app. A getfullstate
is done and that blob is sent to a pb jaguar component. A setfullstate populates
the datastore and a getitemstatus returns the item status. The item status from
DWItemStatus RowStatus
shows NotModified!

Workaround: Always use sharedataoff() before destroying the secondary datastore or datawindow in the sharedata. The secondary datastore/datawindow might be destroyed explicitly with DESTROY or implicitly when an object or sheet is closed. For the case of a sheet close, the sharedataoff() is typically coded in the close event of a sheet (if the secondary datawindow in the sharedata is visible).

When you have a typical tabular with autosizeheight on all columns and slide up directly above, it appears the last row or couple or rows are being hidden and can't be scrolled to. This sometimes requires higher resolutions to see but the example supplied shows the problem at 800x600.

In PB7, this property can be set in the DB Admin painter (by selecting the appropriate column, and setting the 'Initial' property on the Validation tab to a value) or set using pb script.

IN 8003, 8011, and 8046 you get....
Application Execution Error [R00006]
Application terminated.
Error: Invalid DataWindow row/column specified at line 5 in doubleclicked event of object dw_rows of k13_definition.

This works correctly in 7.0.2 9012.

Problem was not happened on PB 7.02 #8011, #8025, #8037
Affected version PB 7.02 #8045.

Check out this Microsoft.com article...(mentions changing a registry entry to fix it)
Slow Network Performance with Service Pack 4, 5, 6, or 6a
http://support.microsoft.com/support/kb/articles/q249/7/99.asp?LN=EN-US&SD=gn&FR=0

Workaround: Insert only one new row / avoid that several new rows are inserted.

According to the "PowerBuilder Year 2000 primer - A practical guide for detecting Year 2000 (Y2K) coding and date ambiguity problems" on Sybase's website the following is how partial editmasks should be handled.

April 24, 1998 12:15:35 - or today's date after the UPDATE.

When a partial editmask is used for input to a date, time or date time field we will set the NON MASKED portions of the field to DEFAULT values. PowerBuilder will make no attempt to preserve any database values for portions NOT represented in the editmask.

Examples of defaults:
YYYYY with value 1970 will result in January 1, 1970, 0:0.0000
MM/YYYY with value 04/1970 will result in April 1, 1970, 0:0.0000
MM/DD/YYYY with value 04/02/1998 will result in April 2, 1998, 0:0.0000
HH:MM with value 2:45 will result in January 1, 1900, 2:24.0000
HH:MM with a retrieved date of 1947 will send back January 1, 2000 2:24.0000

BUT, according to CR 213449 this may have changed since then. The following note is extracted from CR 213449:

Note:
With the fix made in this CR, there will be an impact for other customer applications.
This concerns date display controls where the editmask is of DATE datatype though not neccessarily displaying the full date for user-entry.
E.g. Editmask of DATE datatype : Mask is mm/yyyy -
Error does not pass validation test because PB will validate for day = 00, mm = user-entry, yyyy = user-entry.
Editmask of DATE datatype : Mask is yyyy -
Error does not pass validation test because PB will validate for day = 00, mm = 00, yyyy = user-entry.

Is this the new correct behavior? If so, then are partial editmask in the datawindow are no longer allowed? Why do they still work with an editmask control, shouldn't they be consistent:?

The problem appears when the dw edit control data cannot scroll to the right if column alignment property is 'Right', edit tab - Auto Horz scroll: ON, control is sized shorter on the dw than the actual length of the control.
E.g. column "phone" might be length char(10) and the visual display might be
allow char(6) for the window font and screen resolution etc.
The scroll will stop at position char(6) when in fact there are more chars after that.

Related to CR221556.

Fixed in 7.0.2 9012 PBVM70.DLL. Need 7.0.2 8046 C3 + PBVM70.DLL from build 9012.

After itemchanged event has fired once, this code prevents the event from getting fired again.

2 workarounds:
1. Use the {oj ..... } syntax to surround the LEFT OUTER JOIN.
2. Enclose the entire LEFT OUTER JOIN clause in parenthesis (parens) ( )

This should allow you to edit the statement in syntax mode.

Ex: This statement gives a "Database Error:

SELECT customer.company_name, sales_order.id, sales_order.order_date
FROM customer LEFT OUTER JOIN sales_order ON customer.id = sales_order.cust_id

Workarounds:
SELECT customer.company_name, sales_order.id, sales_order.order_date
FROM
{oj
customer LEFT OUTER JOIN sales_order ON customer.id = sales_order.cust_id
}

or

SELECT customer.company_name, sales_order.id, sales_order.order_date
FROM
(
customer LEFT OUTER JOIN sales_order ON customer.id = sales_order.cust_id
)

However in PB6x, it is possible to select Declare User Event dialog and modify the name of an existing event.

Print preview shows all the pages - this is a printing problem only.

This is a generalized problem with HP PCL and Postscript printers under Windows 95 and Windows 98.
The postscript printer starts it's blank pages at page 12 or 13.

Started with 7.0.2 8033. (5/10/2000)
6.5 builds affected should be 6.5 1191 and up through 1209. Builds after July 17th, 2000 should have the patch.

You can see this using the PB Examples Treeview Drag/Drop in PowerBuilder 6.x and 7.0

Workaround: The problem can be fixed in the Code Examples by adding a call to SetDropHighlight(0) in the dragdrop event.

Problem started in 7.0.2 8033. In builds prior to 8033, this property wasn't written to Jaguar at all and thus defaulted to TRUE for new components, and left this property unchanged for existing components ( leaving it at whatever it was set at).

In the script painter you cannot navigate to an event by typing its full name in the event listbox. This was possible up until the new PB 7GUI.

Although this is possible using the event view you must still use the mouse to select the event (the enter key does nothing).

Can also press the same letter various times to scroll through all the events beginning with that letter but this is not so good if all the the events begin with 'U_' or 'pfc_'

WORKAROUND:
Step 1: Create a user defined JS file that includes a method that will place focus on the column with the <BR> tag.
Ie:
function setFocus()
{
document.htmlDW_dataForm.lname_0.focus();
}

Step 2: Set the following properties either in the htm file or in the HTMLGenerator component:
DataWindow.HTMLGen.ResourceBase=<url>
DataWindow.HTMLGen.UserJSFile = <file.js>

Step 3: Call the method after the Generate().

Workarounds exists but as this is not the same behaviour as other drivers eg tested in O84, ODBC (with ASA & ASE), MSS etc the ct would like to see PBSYC reset textsize

Problem happens in the n_data/f_get_data (n_ds ds_data[ ],s_data s_data) routine:
integer i,dwcount,rc
blob initblob
dwcount=upperbound(dw_data[])
for i = 1 to dwcount
s_data.datablob[i]=initblob
rc=dw_data[i].getfullstate(s_data.datablob[i])
s_data.windowname[i]=""
next

The s_data structure is:
blob{188614692} datablob[]
string dberr[]
string windowname[]

The problem happens in the n_risk_position/f_risk_position routine. The
last line that is processed is f_select_currency_position. Using that to
remote debug n_position/f_select_currency_position it calls the f_get_data.
You can see it goes to the deactive event in remote debugging.

Note: this happens for all databases that support datetime. Oracle native driver O84, Microsoft SQL Server 6.5, 7.x Native driver MSS and Sybase.

Works fine in 5.0.04, 6.5 gold (build 444) and above and 7.0.1 6012 and above.

Powerbuilder Application Execution Error (R0094)
Application Terminated
Error: Corba System Exception
CORBA_COMM_FAILURE at line 66 in e_select event of w_risk_position

The pb client calls the n_risk_position/f_risk_position component. This is
the entry point. It then calls the n_position/f_set_price_profile nvo. This
nvo calls the n_retrieve/f_retrieve(s_data lstr_data,s_criteria s_criteria,string additionalwhere, boolean append) returns s_data. (The f_set_price_profile has a for/next loop. It's in the third iteration
that calls the f_retrieve where the error happens.)

The problem appears to be in:
rc=retrieveds.getfullstate(lstr_data.datablob[i])

This happens most often when Client/Server nvos are ported to run in Web.PB. (See example)

Function Of_setsomething (ref as_stringarg string)
string ls_sql
ls_sql = 'test - made it past assignment'
as_stringarg = ls_sql
return ls_sql

Also, if you use machine code and a variable of type DECIMAL instead, there is no problem.

Project 'Optimization' settings don't make a difference (Speed, Space, No Optimization)

For example, the "slash" in the date or the $ and decimal separator in the currency or numeric editmask would be deleted.

The component has instance pooling, auto demarcation/deactivation off but a SetComplete() to return the instance back to the pool.

NOTE: This works fine with the Oracle 8.0.5 client but DOES NOT WORK with the Oracle 8.1.x client (Specifically the 8.1.5)

Fixed in PB 7.0.2 9012 in PBO8470.DLL so it now works under both Oracle 8.0.5 and Oracle 8.1.5. You will need the Jag 3.5 and PowerBuilder C3 releases (PB 7.0.2 8046) plus PBO8470.DLL from 7.0.2 9012. libjcm.dll is required for Jaguar and is part of the C3 patch.

For example the conditional expression for property background.color ...
IF (salary > 200, 255,0)
Will give the following crash in build 8046
0x77f2ba00 referenced memory at 0x695f656e (memory could not be read)

According to development , this behavior occurs when the datawindow designed by the user does not have enough room to display the following on one page:

Report Header band
all group headers
all group trailers
summary band
footer band.

To remedy the problem you must either modify the datawindow design or increase the height of the datawindow control.

Powerbuilder Application Execution Error (R0094)
Application Terminated
Error: Corba System Exception
CORBA_COMM_FAILURE at line 66 in e_select event of w_risk_position

The pb client calls the n_risk_position/f_risk_position component. It then calls
the f_select_oil_position. This component calls the nvo_data/f_set_data.
The f_set_data(n_ds n_ds[ ], s_data s_data) return integer has the following
routine:
integer i,dwcount,rc
blob initblob
dwcount=upperbound(dw_data[ ])
for i = 1 to dwcount
s_data.datablob[i].initblob
rc=dw_data[i].getfullstate(s_data.datablob[i])
next

The column being changed above is correctly defined as char (10) in the dw. When retrieving the new SQL the NULL is described as LONG hence the above error.

However the same code with O84, SYC, ODBC, MSS drivers does not cause this error. The new hardcoded NULL remains correctly described as CHAR.

This same code with oledb and, for example ASA via oledb, also gives the same error so this is not just a MSSQLServer issue

The column data is compared to "match string" that can include special
symbol "%". This symbol is supposed to match any string of zero or more chars.
E.g.
Branch.county LIKE "%" -> Should return all rows
Branch.county LIKE "L%" -> Should return rows where "county" begins with "L"
Branch.county LIKE "%e%" -> Should return rows where "county" has letter "e" in it

The example shows the following...

my_corbaobj._narrow(my_account,"n_Bank_Account")

This will not work for EJBs if the the java package name follows the domain-name.package name format which the EJB/PJ docs recommend.

It works fine if the java package name is the same as the Jaguar package name. The only way it works is by passing the classpath and home interface to the _narrow method - e.g. myexample/simplebeanpackage/simplebeanhome (where the EJB package is created as myexamples.simplebeanpackage -> this creates directory structure in %JAGUAR%\html\classes called myexamples\simplebeanpackage containing all the classes )

So calling the ejb this way...
my_corbaobj._narrow(lnv_cmhome,"SBean/SimpleBean")
//Component name or Package/Component name does not work, whereas this does...

my_corbaobj._narrow(lnv_cmhome,"myexample/simplebeanpackage/SimpleBeanHome")

This needs changing for the _Narrow() function and also for the example for String_To_Object function

Application Terminated
Error: Cannot convert any in Any variable to a string. Possible cause of uninitialized value
at line 17 in clicked event of object cb_2 of w_test

This display problem does not occur when the vscrollbar arrows are clicked using the up/ down arrows on the vertical scroll bar.

Functions may only be nested to level 10
Msg xxx, Level 15, State 1

Memory is allocated and never released during a batch process which utilises this method.
Could not see a problem with the RowsCopy method because when isolated, the memory is allocated and deallocated in a consistent manner. Whereas with the RowsCopy method, memory is incrementally allocated and never released. For example in a batch process, this will mean the computer will eventually run "out of memory" if the method is used.

Since the output shows some numbers and some (maybe most) nulls, it could be confusing.
Most users want either a number shown or zero for a null (no records).
The default crosstab behavior is to have "blank" for no "val" return from the crosstab query.

(take the simple crosstab from imtutor.pbl and you'll see the blank areas - emp_count_by_salary_and_dept - it's a salary crosstab that shows that many ranges of salaries have no employees at that range)

The easiest way to put a zero in these null fields is to add a FORMAT to the "val" field.
- Click on the Val field. Look at it's properties.
- Pull the format tab forward in the property sheet
- Change [General] to something like ###0;###0;0;0

<positive>;<negative>;<zero>;<null>

is the format of the FORMAT expression. Since we tell it to represent nulls as "0" (the 4th expression), it fills in the nulls (blanks) with zeros.

What you see is the RIGHTMOST vertical grid line describing the outer boundary of the grid datawindow disappears and reappears at different times while scrolling with holding the thumb. As soon as the insertrow() is invoked, you can see the grid line disappear in the visible screen. Internal grid lines between the columns also are gone. The printout seems fine in 6.5 EBF and 7.0.2 C3 even when the screen display is bad so this is a display problem only.

(6.5.1 and 7.0.2 8003-8045 worked fine)

Workaround: Setredraw(true) doesn't seem to work. Filter() works but won't work in all cases depending on program logic flow.

A better workaround is:
dw_1.object.datawindow.print.preview='no'

Place this after the insertrow(n) statement. It does the job and doesn't influence the display (it's not in print preview anyway if you're doing inserts).

This is only a problem if more than one table is involved. The expression generated by PowerBuilder is invalid, after you correct the expression and try to create the DW, PowerBuilder will give you an application error.

There should not be an empty item 1. Works fine in 7.0.2 8046 C3.

code in VB works fine
Private mc As New GeoPres2.MapController
Private Sub Form_Load()
Set mc.Map = Map1
mc.ShowMap mc.MapGroup.DefaultMap, Nothing, Nothing
End Sub

sometimes causes it to jump up from under the mouse
- large blank areas appearing when dragging slowly back-and-forth across PrintPreview page

breaks

workaround is to use variable datatype decimal{4} instead of decimal for info for GetItemDecimal

to your existing target, the browse button on the "set library search path"

is not easy to find or see.

Related problem in 6.5 EBF/7.0 5031/6012 - Typing "23" shows 2%3. You should never be able to type past the percent sign.

Works OK in 5.0.04, 6.5 444, build 1253 and 7.0.2 8003, 8046 C3.

Workaround : After creating the project object , open the properties dialog within the project painter and re-type the password. Build the project and this time it will be successfull.

There are 2 side effects that can be seen.
1. If you SelectAll/Cut and save the function, the function is deleted.
2. If you SelectAll/Cut and switch to the event tab and select an event of_exporttostring(), you'll get a GPF in PBVM70.DLL and it appears it dies trying to delete the function you came from when switching to the event tab..

If you connect to SQL Server 6.5, everything works fine. ODBC will work fine without the network client installed.

Resolution: Third Party Problem (Microsoft)
Refer to the following Microsoft article which specifically mentions PB and includes a workaround:
PRB: Legacy DB-Library Application May Fail to Connect After You Install SQL Server Client Tools
http://support.microsoft.com/support/kb/articles/Q254/3/41.ASP
NOTE: The information from this Microsoft article is intentionally not being copied and pasted here just in case MS makes any changes to it. Please use the URL above to see the actual article.

RESOLUTION: Not a bug but a syntax error in testcase. Executing Oracle stored procedures are different from executing ASE stored procedures. Refer to PB HELP / Declare Procedure/ORACLE Declare and Execute.

Customer sample shows where he is sharing a datastore with datawindow and then retrieving, when he resets datawindow, rowfocuschanged does not get fired.

Question was asked of development to determine the correct behavior and it is as follows and is now consistent in all current builds of PB 6.5.1( build 1219),
PB 7.0.2 ( build 9023) and PB 8.0 beta (build 1313)

Per Development - This is not a bug and is this is the expected behavior.

Click normal retrieve of DW - Rowfocuschanged fires and the current row is 1
Click Reset CB - RowFocuschanged fires and the current row is 0
Click Sharedata and then retrieve CB - Rowfocuschanged fires and the current row is 1
Click Reset CB - RowFocuschanged does not fire

Explanation for this behavior is that when DataWindows are shared, ALL activity is routed through the Primary, Parent DW. For example if you do an
insert row on a shared DW, we take the message and reroute it to the parent for actual processing, when it is processed, we will then synchronize
ALL the shared children to the state of the parent.

When a dw_x.reset is done and dw_x has some shared DW children, sharing is turned off so we can cleanly release dw_x's storage.
When the reset is complete for dw_x, sharing is reinstated for all the shared DW children. The effect is the same as if sharing is not turned off, the
parent DW and all the shared children turn up empty.

The reason you do not see a RowFocusChanged when you reset when the share is in effect is because you are sharing a DataStore to the DW
and (momentarily) the DW is not shared during the reset.

Works ok on nt using jaguar 3.5 (build 35042) and pb 7.0.2 (build 8046).

The srv.log shows the following:
/export/home/duquette/jaguar35/bin/jagsrv: fatal: relocation error:
file /export/home/duquette/jaguar35/jdk/jdk1.1.8/lib/sparc/native_threads/libawt.so:
symbol NameAndTypeToHash: referenced symbol not found (libawt.so)

Aug 18 13:23:35 2000: DWObject Error: load: invalid number of columns: got 50331647 instead of 2

You can see the behavior clearly by watching the taskbar in Wintel systems. The validation messagebox should not appear on the taskbar - it should be tied to the parent sheet.

Workaround: Use a response window instead of the system messagebox in the ItemError event.
- Make sure the response window Open() call specifies a parent window.
- Return 1 in the ItemError to suppress the system messagebox.

// Simple case - datawindow on a window
Open(w_resp, parent)
Return 1

When the checkbox "Prompt for database information" option is selected on "Connection" tab. In Powerbuilder 7.x, the result is a gpf when attempting to connect to db.

If a user picks a library from the Select Application [Browse...] dialog, you will always get the drive letter case (upper) and path F:\CRs\cr200000\test.pbl; pasted EXACTLY as it shows in Explorer. If the user TYPES IN the library list (or part of the library list) such as f:\crs\cr200000\test.pbl, the same object will show up TWICE on the recent objects list (you must exit PB, etc first)..

The dwcontrol.print function does not print the contents of a DataWindow control or DataStore as a print job. The return value for this function is +1 (successful). However, the print job:
-does not print preview(option set ON the actual printer properties)
-does not appear in the printer queue
-does not display any errors

However a possible workaround is to use the PrintDataWindow() function to send data to the printer (though this method is normally used for printing multiple datawindows to send as one print job rather than printing 1 dw).

causes appearance of a white box at the corner of the desktop.

The DDLB, a similar edit style allows case selection even if the field is read only (Allow Editing OFF)

When you click on a column with this editmask and format value null,
the displayed value changes from 'null' to' 00/00/0000'.
However when you click on the same column in a different row the displayed value
stays '00/00/0000' and does not revert back to 'null' as it should.
The problem does not occur when tabbing to a different column.

Workaround: post an event in the rowchanging event and then set the
focus to a different column and back in the posted event.

Typical errors you get:
SQL Anywhere - S1002 [Sybase][ODBC Driver][Adaptive Server Anywhere]Table or view not found: table 'department_a' not found
Sybase SQL Server - Select Error: dialog that is empty.
Oracle (native) - Select Error: ORA-00942 Table or view does not exist.
Informix - SQL error -206: The specified table (department_a) is not in the database. ISAM error -111 error, no record found
MS SQL Server - Select Error: invalid object name "department_a"

Java Exception: Unable to find java PbjdbcSession class. Check CLASSPATH.

If you're using JDK 122 on your CLASSPATH, JDK122 doesn't have the javai.dll in it and that is what we use for the JDS driver.

Workaround: Switch CLASSPATH to use JDK117 or JDK118.

The response window works correctly in the clicked event, for example - not allowing any script execution after the Open() until the user closes the response window.

This has been the behavior back through 5.0.04.

Edit a script (but don't save)
Switch to functions or declare (tear off tab) without doing anything.
Switch back to script you were editing and save script.
Switch to (functions) using the script pane dropdown list which contains (Functions),(Declares), etc
GPF in PBVM70.DLL

Install crashes
Copying Powersite client program files
75%
ComponentMoveData Error Information
Setup encountered the following error:
MediaName: data
Component Client Install (Powersite)\Program Files
File Group DLLs (ps)
File:
Error Number: -145

c:\winnt keyHH.exe 7/17/00
c:\winnt\system32 KeyHH.exe 1/6/99

We should issue a warning (Example ClassName()):
You are overriding a PowerBuilder SYSTEM FUNCTION "Classname()" . If you choose to continue, the object level function you're creating will run instead of the SYSTEM FUNCTION and you will not be able to execute the system level function. Do you want to continue? <YES><NO><Cancel>

As per Development this is not a bug :
"The reason there is an increase in time for a full rebuild to complete is a result of many changes that were put in over a 3 to 4 year period. Features have been added to increase functionality, along with fixes to reach the goal of accuracy which all combine to make PB a more robust tool. The cost of this unfortunately is that things will take longer.

You will notice the performance increase between 5 and 6 was not far from the increase between 6 and 7. The total increase from 5 to 7 does appear to be large, however, it has been done over time. Hence this is not considered to be a bug and does not cause a Full Rebuild or something else to fail in PB."

Workaround:
Using a odbc connection to the ASE Server.
Example:
jagObject.settrans("ODBC", "ConnectString='DSN=ASEODBC;UID=sa;PWD='", "", "", "", "", "");

Workarounds include doing a dw_1.insertrow(0) in the open script to insert a row into the datawindow or saving the datawindow with a dummy row.

Update from Development: Not a bug. This turned out to be user scripting errors when using OLE functionality.

PBODB80.DLL is actually installed though, so it's not a big deal, but the list of drivers in the summary (Direct Connect? but not ODBC) doesn't seem logical for a COMPACT install.

suggest doing a global search in the Install scripts, etc. to see that we caught all these.

"Show start dialog at startup with no workspace" | If both are checked then
"Reopen Workspace on Startup" | this one is the one that is executed.

Creating a column in an external dw which contains a blank space in the name will crash PB as soon as you click the finish button.
With 7.0.2 build 9010 - Gives error in pbdwp70.dll - Instruction @ 0x10847f96 referenced memory @ "0x00000000" - memory could not be read
In PB 6.5 and earlier an error message appeared and user was forced to change the name

Possible error message "waiting for an object" when trying to update date field.

a function :-

DW_dayOfYear() does exist in the script file.

However function day_of_year() does not exist and is referenced in DW_dayOfCentury() ;

The correct function call should be made to DW_dayOfYear() ;

Possible error message "waiting for an object" when trying to update date field.

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

PB8 Beta1: Migration of large app from 6.5 to 8.0 completes successfully, but GPFs when run in development mode. 6.5 to 7 migration runs OK. 7.0 to 8.0 migrations fails in the same way.

From the PB 7.0 release notes, version 7.0 will be the final
release of Powerbiulder which will incorporate Distributed Powerbuilder functionality.

DPB app should return errors during migration. You should not be allowed to migrate it.

Please remove them from the build!!

The dlls that should be removed from PB 9.0 are:

pbcgi90.exe

pbisa90.dll

pbns190.dll

pbns290.dll

pbns390.dll

pbo7390.dll

The webpb dlls are included in the pb 8.0 beta 1 install.

From the Powerbuilder 7 release notes, version 7.0 will be the final release of

Powerbuilder which will incorporate Distributed Powerbuilder functionality.

Please remove the following dll's from the install:

pbcgi80.exe

pbisa80.dll

pbns180.dll

pbns280.dll

pbns380.dll

1. The transport object appears in the ddlb under
pb objects/standard class.
2. Transport object appears in the browser under the system tab

From the pb 7.0 release notes, version 8.0 will be the final release of
Powerbuilder which will incorporate Distributed Powerbuilder functionality.

This only happens in the function object painter.

In the treeview control RightClicked event, REPLACE il_tvitemhandle = handle WITH il_tvitemhandle = this.selectitem(handle) to get the actual handle of the specified item.

Update from Development:
For pb7.0.3 and PB8 this flag has been exposed in the UI to the user. By default in pb7.0.3 standard components can have thread.safe=true and false... For Service and shared components thread.safe is set to false and cannot be modified by the user.

For pb8 there is a slight diff in behavior...
Standard comps... thread.safe=true/false
Shared comps... thread.safe=false
Service comps 1 instance(default) thread.safe=false
Service comps. more than one instance thread.safe=true/false

PB error appears regardless of dbparm setting DisableBind = 0 or 1 ;

The test case is creating a datastore and then associating a psr file. It then uses the print() powerscript function to print out the datastore.

Per PB Product Management, this is not a bug. This CR has been submitted as a New Feature Request/Enhancement Request:

The following information is from the PB 7.0.3 Maintenance Release "readme":

The PowerBuilder 7.0.3 version of the PowerBuilder VM must be available on the server.
The PowerBuilder VM includes PBVM70.DLL, PBJAG70.DLL, PBDWE70.DLL, and other
PowerBuilder files required at run time.

On UNIX, the shared libraries are called libpbvm70x.ext, libdwe70x.ext, and so forth, where
ext is the shared library extension for each UNIX platform. These runtime libraries do not
provide support for Windows API calls or graphical operations, including printing. If you deploy
a PowerBuilder component to an EAServer host running on UNIX, the component can have
neither graphical dependencies nor dependencies on the Windows application programming
interface.

Development: This dialog is resizable though it looks like it's a modal, non-resizable dialog.

1. Page 90 - Unicode reference and references to PBO8470U.DLL, PBO7370U.DLL and PBOR870U.DLL should be deleted.

2. Page 96 - #5 Titled "Powerbuilder for Unicode Only" should be deleted.

3. Page 110 - Reference to Unicode and PBSYBC70U.DLL (not shipped with product) should be deleted in chart

Note: This is different behaviour to e.g.
-Grid or tabular datawindow (with NO group breaks), performs scroll by row.

when setting data in a datawindow control via a datastore. If I assign the dataobject to the

control at runtime and do a insertrow, then try tabbing into the nested dw's and using the

arrow keys it works fine.

Workaround :
Set an initial value for the dddw so that it gets populated automatically.

According to the documentation, changing a column status is simple.

Exception code: C0000005 ACCESS_VIOLATION
File Name: E:\pb80\PBUDO80.dll
File Version: 8.0.00.1313
Fault address=1275BFE0 Section:Offset=01:0005AFE0

Registers:
EAX:00000000
EBX:80020002
ECX:00000091
EDX:00000000
ESI:000040F8
EDI:02E83CC8
CS:EIP:001B:1275BFE0
SS:ESP:0023:0012D868 EBP:80020002
DS:0023 ES:0023 FS:0038 GS:0000
Flags:00010246

Call stack:
Address Frame Param0 Param1 Param2 Param3 Function Name
1275BFE0 80020002 00000000 00000000 00000000 00000000 PBWS_DlgCLDebugProc+1F10

OS version:
Windows NT 4.0, Build Number: 1381, Service Pack 5

Memory Status:
Total physical memory: 196024K
Available physical memory: 113084K
Total virtual memory usage: 146620K / 410744K
PowerBuilder virtual memory usage: 103156K / 2097024K

Add the possibility to use the Windows regional settings format instead of the US notation in numeric datawindow expressions.
If "comma" is specified as decimal separator, then numeric expressions accept european format ( eg 12,34.)
If "period" is specified, it accepts US format (eg 12.34)

Workaround:
Use Modal Form

select 42.19 / 2.42 from department;

Works correctly in the DBA administrator (datawindow) and returns 17.43388429752066 in PBIN7070.DLL and ODBC but this doesn't work in embedded SQL with:

decimal deci
select 42.19 / 2.42 into :deci from department;

will truncate "deci" at "17" (an integer)

Workaround: Use double datatype.

This behavior no longer happens in 7.0.2 C3.
6.5 builds > 1220 have this behavior.

Ex : SELECT TONE_ID AS alias1,TTWO_ID AS alias2
FROM TABLE_ONE,TABLE_TWO
WHERE TONE_ID = '12345'

2) add a RMB option to "go to" the object causing the error. Edit and Edit course are great, but just being able to go to the object in question would be real helpful as well.

For this particular example, this is not the crux of the problem; however, the GUI could handle it much nicer. I believe that adding an exception that is not defined on the 'ancestor' function should get the same type of error as trying to override a function and changing only the return value. The compiler catches the later case and probably should catch the similar case with exceptions.

This is not a problem with PB 7.0.2.

The exception unknown software exception (0xc00000fd) occured in the application at location 0x1134d95c.

Customer reported this as a regression but further testing revealed that the problem was in previous builds of 7.0 but that a recently fixed CR 216105 changed the size of the actual arrows which resulted in this customers editmask being too small. Other spin controls with other data types did not seem to have the problem.

Also when run in PB 8.0 beta the application error did not occur although the edit mask was unusable as it simply blanked out.

Simple workaround is to simply increase the size of the control.

Refer to CR 216105 for an explanation of that fix.

The SSLCallback object was created to allow SSL connections to EAServer. The functions provided on this object are getPin, getCertificateLabel, getCredentialAttribute, and trustVerify. The first three of these functions are supposed to throw a userabortedexception to cancel the SSL request; however, since the PB SSLCallback object functions do not have these exceptions defined on them, it is impossible (by design) in the painters to override the function to add a throws clause. Because of that it is impossible to cancel an SSL request once it has begun.

The other methods on the PB SSLCallback and SSLServiceProvider object also do not throw exceptions and so would need to be investigated as well.

can give the following error:

Select error: ORA-1790: expression must have same datatype as corresponding expression

Work-around is to enclose the retrieval arguments in an expression, e.g. to_number function.

Works fine if you paste ONE at a time.

The lenght of data being retrieved into a string in PB 5 and 6 is about 196K where as the dw
has data of about 248K+. The complete data does get retrieved into the string variable in PB 7 or later. I have tried the retrieve into a blob but it is the same thing, I think it is the retrieve itself that is not working.

1) make the driver property optional
2) update errcodes to be more EAServer friendly - usually all we get is a 50 or 57 which isn't too descriptive
3) let the trace property specify a file that the IIOP client trace will get written to... the existence of this property would trigger PB to automatically set ORBLogIIOP and ORBLogFile when initializing the ORB

The EAServer connection dialog could be extended to include these ORB initialization properties so that the options string would be built automatically when picking an EAServer connection in the connection object wizard. With a Preview tab, like on the database connection, customers would also be able to paste complete EAServer connection code directly into their application.

It's apparently colliding with some reserved word in PB or Jaguar, and it fails to create the correct IDL. This is a problem for the Web Datawindow component that is shipped with Jaguar, in that this PB component does have a function named create() and it does have the correct IDL. So if a developer makes any changes to the Web DW component (a likely senario) and then redeploy's it, the create() function is no longer in the IDL.

In my case, after successfully opening 6 dws, the following warning popped - up from the resource monitor:

"Low Resources: Ninety percent or more of your system resources are in use. To free up system resources, quit any programs that you are not using. If you do not, your computer may stop responding".

This can be confirmed after clicking "OK" to the above warning and checking the resource meter. If you now try to open yet another dw, crash handler message comes up and PB crashes.

Additional Observations
==================

Closing the datawindows doesn't seem to return all of the resources, but closing PB8 and restarting it does - I closed dws one by one and saw resources recoup ( all the three - System\User\GDI)

This happens only when one clicks on editmask control, if you tabs to the control and then enter data eveything works fine.

Problem does not occur on Win NT 4.0 but only on Win95/98.

Using the 'File, Select Library, Browse' also has the 'hang' issue.

From PB Engineering: This is not a PB bug. If I bring up winfile and one of my drives is inaccessable, it takes a lot more time than if all the drives are accessable just as PB does. Also Win NT does not mark inaccessable drives with an X so PB is doing just what NT does.

DBMS o84 orcle 8.0.4 is not supported in your current installation

When trying to connect to a o73 server with oracle 8.1.6 client, a message
appears that it cannot load the libpbo8460.so.

Works ok using the oracle 8.1.5 client software and the workaround listed
in tech doc 1002125. The workaround for 8.1.5 client is

ln -s libclntsh.so.8.0 libclntsh.so.1.0

"Is there anyway you can add a Java target to the PB8 environment? I'm
not talking about including PowerJ as part fo the IDE, but more like the
file painter with a compile and possibly a deploy to EAS capability."

But for the purposes of PowerBuilder and the Powersite functionality now included, it's reasonable to include a mechanism to generate and compile Java stubs from EAServer components. Currently in order to build a Dynamo page accessing EAServer, you have to access Jaguar Manager to first generate the stubs and then a separate DOS window to compile the stubs. EAServer 4.0 is supposed to have a wizard approach to doing this and at some point there will be a command line interface to EAServer to accomplish this (3.6.1 timeframe?). If at all possible this should be considered for GA .

According to microsoft knowledge base article q25317 - Getting MAPI read
receipt functionality over the Internet Mail Service, Outlook Express uses a different
mail message property for read receipts and simply ignores the property used by
Outlook MAPI client. Outlook Express uses this property for read receipt requests:
Disposition-Notification-To:

Outlook uses this property for read receipt requests:
Return-Receipt-To:

If this is the case, than Powerbuilder should accommodate Outlook Express.

If you go to 'Rows - Sort' - the computed column is still there under 'columns' and remains checked for 'Ascending'. I think it shouldn't even be there. If you uncheck it - same sequence of errors.
However, if you drag the computed column into 'Source Data', it successfully disappears and you're back in business.( a workaround)

With everything going the way it is, (JSP's J2EE etc), would it be
possible to add a Java Class as a web target? What I found is that I can
use the PB8 file editor to edit my java classes easily enough, which
allows me to use such features as indenting, block commenting, etc. Nice
features in the PB editors. When I create a Script file in a web target,
and I import my java code, it color codes some of the java stuff for me
(recognizing enough from the javascript capabilities it has no doubt).
But this editor does not have the block indenting/commenting
capabilities of the PB script painters (not needed for javascript etc).
Also, if I save this file with a Java extension, it appears in the
treeview under my web target, which is great, but if you then
double-click on it to open it, it tries to open Wordpad, my default
.java association, instead of using the script painter inside of PB.

I know it sounds more and more like PowerJ integration, but I leave
PowerJ to do things like EJB's which it is well suited for. For simpler
stuff, I would ordinarily use Wordpad or the PB File Editor. Now that
I've seen the javascript script painter in there, it seems like it would
not be too much to allow .java files to be included in that list.

I expect this window to grow steadily in content, and it
would be great if I could easily categorize the things I put in there.
Use of Tabs, Treeview or even multiple clip windows would be great.

Powerbuilder crashes with the following error:
Exception code: C0000005 ACCESS_VIOLATION
File Name: D:\pb70\Shared\PowerBuilder\PBSQL70.dll

DB/DLL: PBIN7, PBIN9 for PBs 6,7 and 8
=====================================================
Comments:
Extended Attributes from pbcatcol are not getting picked up by IN7 or IN9 drivers when connecting to an
Informix ANSI db and creating a new datawindow.

Works fine with:
- ODBC
- non-ANSI db
- Extended attributes from other pbcatxxx tables (eg fonts, validations etc)
- The same pbcatcol attributes can be seen correctly in the table using db painter (click the
table->column->properties)
- The same pbcatcol attributes can be seen correctly in the dw wizard.

But
- the extended attributes from pbcatcol are NOT applied to the final datawindow
- Pipeline (with 'include extended attributes' checked) also ignores the pbcatcol attributes

Rebuild still happens if you look in the output window.

Call the GetCurrentDirectoryA before and SetCurrentDirectoryA after the DirList function call of the listbox.

GetCurrentDirectoryA(l_buf, ls_curdir)
listbox.DirList ( "path" , 16 )
SetCurrentDirectoryA(ref ls_curdir)

Error: Retrieve Failed = -1
Select error: SQLSTATE = 37000 [Sybase][ODBC Driver][Adaptive Server
Anywhere]Syntax error or access violation: near 'date' in ...webdw.id,webdw.[date]

The error happens when the column name is "date". Problem is only on
solaris. Works ok on nt. Using a date field that has a different column name results
in the following error :
[Javascript Application] Item '??3????' does not pass validation test error.

Problem happens only with htmldw on solaris. Works ok when a date field
does not have the column name of date with pb components on solaris.

The error you get is:

SQLSTATE 08004 [Sybase][Adaptive Server Anywhere] Database Server rejected connection: Database Creation failed.

This happens when using the Profile Painter/ODBC section/Create ASA Database dialog with leaving the "Collating Sequence" as <Default>. Once you pick a codepage, the database is created fine.

If this is not considered a bug then it needs to be changed to an Enhancement Request.

If you change the unbounded array to a bounded array than it works ok.

Exception code: C0000005 ACCESS_VIOLATION
File Name: D:\pb70\Shared\PowerBuilder\PBVM70.dll
File Version: 7.0.2.9028
Fault address=11362518 Section:Offset=01:00161518

Registers:
EAX:00000000
EBX:01804A30
ECX:026F0500
EDX:00002000
ESI:00000064
EDI:01223C10
CS:EIP:001B:11362518
SS:ESP:0023:0012F538 EBP:01804A48
DS:0023 ES:0023 FS:0038 GS:0000
Flags:00010246

Call stack:
Address Frame Param0 Param1 Param2 Param3 Function Name
11362518 0012F544 01223C10 026F0500 026E0F60 01223C10 ob_copy_rtinst+D8
1136119A 0012F568 01804930 026E0F60 01860ED0 01223C10 ob_get_group_instlist_as_shlist+37A
1135BD47 0012F584 01223C10 00000000 011C04CE 000003E8 ob_run_garbage_collection+197
1132CBF1 0012F6A8 011C04CE 00000111 000003E8 021F04FE fn_txnservice_create_instance+42A1
112CDC7E 0012F714 011C04CE 00000111 000003E8 021F04FE FN_WindowWnd+8FE
77E727FE 0012F750 112CD380 011C04CE 00000111 000003E8 IntersectRect+54
1126A50F 0012F778 011C04CE 00000111 000003E8 021F04FE PBC_MainProc3D+1AF
77E71FF1 0012F7A4 008ECA30 00000111 000003E8 021F04FE _IsWindowVisible+37
77E73122 00000111 00000000 00000000 00000000 00000000 WCSToMBEx+64

The crash handler reports the following:
Exception code: C0000005 ACCESS_VIOLATION
File Name: C:\WINDOWS\SYSTEM\COMCTL32.DLL
File Version: 5.80
Fault address=BFC0AC43 Section:Offset=01:00009C43

The effect in a simple 4-UP datawindow shows the first 4 rows (the N-UPs first horizontal row) is completely gone.

PB crashes as follows:
Exception code: C0000005 ACCESS_VIOLATION
File Name: D:\pb70\Shared\PowerBuilder\PBVM70.dll

For example, a test case that is just connecting and disconnecting shows
the following thru the task manager:

mem usage vm size
7436 5308
154592 202172
158756 202172
159716 202172
74476 103768

Memory is release from time to time but if its not released in time, the
following error can appear on your machine:
System Process Out of Virtual Memory
Your system is running low on virtual memory. Please close some
applications.

the control is blank, when going against the Access db.
PB 7.03.10007, 8.0.2055 :
Access DB using ODBC Driver - crashes(Crash handler for 7.03.10007 file is attached

pb70.txt)
ASA (EASDemodb) using ODBC Driver, does not crash but returns -1
Oracle (tbone server) using O84 driver - crashes.
ASE (11.9.2 server on tbone) using SYC driver - works fine.

When using a standard class Message user object in place of the system Message object the Constructor event of this user object does not get fired when the application is run from the development environment and after a PB application runtime error has occurred.
If PB is rebooted the Constructor event will fire correctly again.
The problem seems to be how the Constructor event is called. If the source code for the user object is exported
and the following line of code is changed then the problem no longer occurs...
change...
TriggerEvent (this, "constructor")
for...
this.Trigger Event Constructor()

This is a regression problem in PB 7.x ;

a_structure = lstr_structure
a_structure = lstr_structure

The second assignment causes the error :
"PowerBuilder Application Execution Error (R0023). Application terminated. Error: Cannot

assign object of type a_structure to variable of type window at line 6 in function

function_3 of object w_window"

This is probably due to the different editor used here, but hopefully we can get some better consistency

When using the delete key in the clip window, it should
delete the item clip window as well as what is in the script painter. It now
only deletes whats in the script painter.

Happens with PB 8.0 (build 1313 and 2051)

NOT A PB BUG, Cannot reproduce it inhouse with PB 7.03. In the customer's situation it turned out to be a privelege issue. Once they used the correct userid, they did not have any problems.

In PB 6.5.1, if the argument is type "array" the argument will not show up under
the arguments tab. From cr 159615, the array type arguments are not offered
for nested report. The argument should not show up in the list.

Out of memory
Abort, Retry?

If you hit abort, the message of "Insufficient memory to continue" appears.
From the task manager, the vmsize of the pb70.exe doesn't appear to go up
dramatically.

2) Allow the ability to rename the targets in my workspace using an interface similar to explorer. (Click on the target, use F2 or a second click to allow the name to be modified).

PB Version: From 6.5.1 Build 620 -> Build 1236 (OK in 6.5 build 444), all PB 7 builds and PB 8 betas

Comments:

If the SQL syntax is edited by hand in pipeline painter (SQL -> convert to syntax) then the next time you view the syntax using the 'convert to syntax' option all the carriage returns are lost and SQL appears in one long line.

If same is attempted in the dw painter no formatting is lost.

Converting to graphics (and back to syntax ) will recover the formatting.

PB 7.02 build 8046 & Jag 3.5 build 35042

A mail component is deployed to jaguar and is being called from a PB client. If the jaguar server is running as a service then the mSes.mailLogon(as_profile,"",mailNewSession!)

returns an error. If I shutdown the service and start Jaguar from a shortcut then the same call is successfull and can successfully send mail

When Jaguar is running as a service the password box for MailLogon does not pop up (might be linked to the cause of the failure). Even started the Jaguar service with Administrator's userid but still no difference.

painter.
If I have a editmask of type "###-##-###" then I cannot enter more than 3 numbers in the

editmask in the window painter. If I have a similar editmask on a dw column the insert is

fine. One is able to insert numbers until one reaches a delimiter this could be a '-', '

','/' etc. Happens only if you have a number on a stringmask, if you have a alphanumeric or any character it is fine no problems.

Workaround:
If background color is set to White or Transparent it works fine.

When "rows as needed" option is NOT checked, the following error message
appears:
Database Error
Error Code: 208 Error message: Select error: t41074381 not found. Specify owner.objectname
or use sp_help to check whether the object exists (sp_help may produce lots of
output).

Datawindow Error
Select error: t41074381 not found. Specify owner.objectname or use sp_help to check
whether the object exists (sp_help may produce lots of output).

When "rows as needed" option is checked, the following error message appears:

Database Error
Error Code: 0 Error Message: Select error:

Datawindow Error
Select error:

Problem is not db specific. Problem happens using dot notation too of:
dw_1.Object.DataWindow.Retrieve.AsNeeded = "yes"

it should allow you to tab to insert a new row.

This was determined to be a Microsoft issue according to the customer:
This was a known but yet unpublished defect in SQL Server 7.0. The locking was related to the new prefetch access during certain nested loop inner joins.

workaround:
1. export the dw
2. edit the dw and set the major gridline property in the exported file to the right value.
3. import the dw
4. create the executable without touching the dw

The customer would like the ability to link the system treeview and the listview of the library painter so that when you click on a PBL in the system tree, the list view shows its contents. You can drag the objects into the listview but customer finds that rather inconvenient.

From the online help, the text size limit is 32765. Anything less than this size should
return a sqlcode of 0.

PB will crash when you try to view spin control edit mask in the db painter. This only occurs with certain dbms and always when using ODBC. There is no database activity when the crash occurs as the data is already cached in memory so this is not strictly a dbms issue but a problem of how the dw/db painters are interpreting that data.

Reproduced with the following combination of PB/DBMS/ODBC driver
PB 6.5, PB 7.02.9028 and earlier & 7.03.10007
Not able to reproduce in PB 8
Reproduced with DB2 using ODBC driver supplied by IBM (DB2CLI.DLL Ver 5.02). Also with...
Informix 7 using ODBC drivers from Merant and Informix
Informix 9 using Merant ODBC
ASE 12 + Merant ODBC
Not reproduced with Oracle and ODBC or with ASA and ODBC (yet)
Not reproduced using any native drivers

The test case is using powerdynamo 3.5 and netscape 3.6 web server on
solaris. Also the cgi helper (csrv03) and the dycgi03 in the cgi-bin
directory of the web server. The test case is using a dynamo dynamic file base
setup too.

The following messages appear on the browser too:
There was a problem performing the action: SetDWObject. Error code: 0
There was a problem performing the action: SetHTMLObjectName. Error code: null
There was a problem performing the action: SetSelfLink. Error code: null
null
Nov 8 12:57:17 2000: HTMLDW: Remote DataWindow Component logging enabled
Nov 8 12:57:17 2000: HTMLDW: Default Library List = 'pbdwr70.pbd'
Nov 8 12:57:17 2000: HTMLDW: Loaded component properties:
Nov 8 12:57:17 2000: HTMLDW: sourceFileName = ''
Nov 8 12:57:17 2000: HTMLDW: dwObjectName = ''
Nov 8 12:57:17 2000: HTMLDW: HTMLObjectName = ''
Nov 8 12:57:17 2000: HTMLDW: modifyString = ''
Nov 8 12:57:17 2000: HTMLDW: fixed = 'no'
Nov 8 12:57:17 2000: HTMLDW: serverSideState = 'no'
Nov 8 12:57:17 2000: HTMLDW: trans.dbms = ''
Nov 8 12:57:17 2000: HTMLDW: trans.dbparm = ''
Nov 8 12:57:17 2000: HTMLDW: trans.lock = ''
Nov 8 12:57:17 2000: HTMLDW: trans.logid = ''
Nov 8 12:57:17 2000: HTMLDW: trans.logpass = ''
Nov 8 12:57:17 2000: HTMLDW: trans.database = ''
Nov 8 12:57:17 2000: HTMLDW: trans.servername = ''
Nov 8 12:57:17 2000: HTMLDW: serverServiceClasses = ''
Nov 8 12:57:17 2000: HTMLDW: Activate()
Nov 8 12:57:17 2000: HTMLDW: Entering SetDWObject('tsdw.pbl','d_psafdc10_2block_ase')
Nov 8 12:57:17 2000: HTMLDW: Doing PBL/PBD
Nov 8 12:57:17 2000: HTMLDW: SetLibraryList(pbdwr70.pbd,tsdw.pbl) = 1
Nov 8 12:57:17 2000: HTMLDW: Entering Modify('DataWindow.htmldw='yes' DataWindow.NoUserPrompt='yes'')
Nov 8 12:57:17 2000: HTMLDW: Exiting Modify() = ''
Nov 8 12:57:17 2000: HTMLDW: EnableCommit()
Nov 8 12:57:17 2000: HTMLDW: Entering of_initializeFromDeclarative()
Nov 8 12:57:17 2000: HTMLDW: Exiting of_initializeFromDeclarative() = 1
Nov 8 12:57:17 2000: HTMLDW: Exiting SetDWObject() = 1
Nov 8 12:57:17 2000: HTMLDW: EnableCommit()
Nov 8 12:57:17 2000: HTMLDW: Entering SetTrans()
Nov 8 12:57:17 2000: HTMLDW: Exiting SetTrans() = 1
Nov 8 12:57:17 2000: HTMLDW: EnableCommit()
Nov 8 12:57:17 2000: HTMLDW: Entering SetWeight()
Nov 8 12:57:17 2000: HTMLDW: Exiting SetWeight() = ''
Nov 8 12:57:17 2000: HTMLDW: EnableCommit()
Nov 8 12:57:17 2000: HTMLDW: Entering SetHTMLObjectName('htmlDW')
Nov 8 12:57:17 2000: HTMLDW: Exiting SetHTMLObjectName() = ''
Nov 8 12:57:17 2000: HTMLDW: EnableCommit()
Nov 8 12:57:17 2000: HTMLDW: Entering SetBrowser('Mozilla/4.7 [en] (WinNT; U)')
Nov 8 12:57:17 2000: HTMLDW: Exiting SetBrowser() = ''
Nov 8 12:57:17 2000: HTMLDW: EnableCommit()
Nov 8 12:57:17 2000: HTMLDW: Entering SetSelfLink('PSAC-2TEST.htm','')
Nov 8 12:57:17 2000: HTMLDW: Exiting SetSelfLink() = ''
Nov 8 12:57:17 2000: HTMLDW: EnableCommit()
Nov 8 12:57:17 2000: HTMLDW: Entering Retrieve()
Nov 8 12:57:17 2000: Server Message: - 2409/11/2/ZZZZZ: Cannot find the requested character set in Syscharsets: name = 'utf8'.

Nov 8 12:57:17 2000: Server Message: - 2411/10/1/ZZZZZ: No conversions will be done.

Nov 8 12:57:17 2000: HTMLDW: Exiting Retrieve() = 88
Nov 8 12:57:17 2000: HTMLDW: EnableCommit()
Nov 8 12:57:17 2000: HTMLDW: Entering Generate()
Nov 8 12:57:18 2000: HTMLDW: Exiting Generate(), length = 813392
Nov 8 12:57:18 2000: HTMLDW: SetComplete()
Nov 8 12:57:18 2000: HTMLDW: Entering Deactivate()
Nov 8 12:57:18 2000: HTMLDW: resetting state
Nov 8 12:57:18 2000: HTMLDW: Exiting Deactivate()
Nov 8 13:01:51 2000: HTMLDW: Activate()
Nov 8 13:01:51 2000: HTMLDW: Entering SetDWObject('gates_web.pbl','d_html_ma_query')
Nov 8 13:01:51 2000: HTMLDW: Doing PBL/PBD
Nov 8 13:01:51 2000: HTMLDW: SetLibraryList(pbdwr70.pbd,gates_web.pbl) = 1
Nov 8 13:01:51 2000: HTMLDW: Entering Modify('DataWindow.htmldw='yes' DataWindow.NoUserPrompt='yes'')
Nov 8 13:01:51 2000: HTMLDW: Exiting Modify() = ''
Nov 8 13:01:51 2000: HTMLDW: EnableCommit()
Nov 8 13:01:51 2000: HTMLDW: Entering of_initializeFromDeclarative()
Nov 8 13:01:51 2000: HTMLDW: Exiting of_initializeFromDeclarative() = 1
Nov 8 13:01:51 2000: HTMLDW: Exiting SetDWObject() = 1
Nov 8 13:01:51 2000: HTMLDW: EnableCommit()
Nov 8 13:01:51 2000: HTMLDW: Entering SetHTMLObjectName('dw')
Nov 8 13:01:51 2000: HTMLDW: Exiting SetHTMLObjectName() = ''
Nov 8 13:01:51 2000: HTMLDW: EnableCommit()
Nov 8 13:01:51 2000: HTMLDW: Entering SetBrowser('')
Nov 8 13:01:51 2000: HTMLDW: Exiting SetBrowser() = ''
Nov 8 13:01:51 2000: HTMLDW: EnableCommit()
Nov 8 13:01:51 2000: HTMLDW: Entering SetTrans()
Nov 8 13:01:51 2000: HTMLDW: Exiting SetTrans() = 1
Nov 8 13:01:51 2000: HTMLDW: EnableCommit()
Nov 8 13:01:51 2000: HTMLDW: Entering SetSelfLink('matab.htm','apoe_apc='"null"'|apod_apc='"null"'')
Nov 8 13:01:51 2000: HTMLDW: Exiting SetSelfLink() = ''
Nov 8 13:01:51 2000: HTMLDW: EnableCommit()
Nov 8 13:01:51 2000: HTMLDW: Entering SetAction('InsertRow')
Nov 8 13:01:51 2000: HTMLDW: Exiting SetAction() = 1
Nov 8 13:01:51 2000: HTMLDW: EnableCommit()
Nov 8 13:01:51 2000: HTMLDW: Entering SetAction('null')
Nov 8 13:01:51 2000: HTMLDW: Exiting SetAction() = -5
Nov 8 13:01:51 2000: HTMLDW: EnableCommit()
Nov 8 13:01:51 2000: HTMLDW: Entering Generate()
Nov 8 13:01:51 2000: HTMLDW: Exiting Generate(), length = 80493
Nov 8 13:01:51 2000: HTMLDW: SetComplete()
Nov 8 13:01:51 2000: HTMLDW: Entering Deactivate()
Nov 8 13:01:51 2000: HTMLDW: resetting state
Nov 8 13:01:51 2000: HTMLDW: Exiting Deactivate()
Nov 8 13:02:00 2000: HTMLDW: Activate()
Nov 8 13:02:00 2000: HTMLDW: Entering SetDWObject('gates_web.pbl','d_html_ma_query')
Nov 8 13:02:00 2000: HTMLDW: Doing PBL/PBD
Nov 8 13:02:00 2000: HTMLDW: SetLibraryList(pbdwr70.pbd,gates_web.pbl) = 1
Nov 8 13:02:00 2000: HTMLDW: Entering Modify('DataWindow.htmldw='yes' DataWindow.NoUserPrompt='yes'')
Nov 8 13:02:00 2000: HTMLDW: Exiting Modify() = ''
Nov 8 13:02:00 2000: HTMLDW: EnableCommit()
Nov 8 13:02:00 2000: HTMLDW: Entering of_initializeFromDeclarative()
Nov 8 13:02:00 2000: HTMLDW: Exiting of_initializeFromDeclarative() = 1
Nov 8 13:02:00 2000: HTMLDW: Exiting SetDWObject() = 1
Nov 8 13:02:00 2000: HTMLDW: EnableCommit()
Nov 8 13:02:00 2000: HTMLDW: Entering SetHTMLObjectName('dw')
Nov 8 13:02:00 2000: HTMLDW: Exiting SetHTMLObjectName() = ''
Nov 8 13:02:00 2000: HTMLDW: EnableCommit()
Nov 8 13:02:00 2000: HTMLDW: Entering SetBrowser('')
Nov 8 13:02:00 2000: HTMLDW: Exiting SetBrowser() = ''
Nov 8 13:02:00 2000: HTMLDW: EnableCommit()
Nov 8 13:02:00 2000: HTMLDW: Entering SetTrans()
Nov 8 13:02:00 2000: HTMLDW: Exiting SetTrans() = 1
Nov 8 13:02:00 2000: HTMLDW: EnableCommit()
Nov 8 13:02:00 2000: HTMLDW: Entering SetSelfLink('matab.htm','apoe_apc='"null"'|apod_apc='"null"'')
Nov 8 13:02:00 2000: HTMLDW: Exiting SetSelfLink() = ''
Nov 8 13:02:00 2000: HTMLDW: EnableCommit()
Nov 8 13:02:00 2000: HTMLDW: Entering SetAction('InsertRow')
Nov 8 13:02:00 2000: HTMLDW: Exiting SetAction() = 1
Nov 8 13:02:00 2000: HTMLDW: EnableCommit()
Nov 8 13:02:00 2000: HTMLDW: Entering SetAction('null')
Nov 8 13:02:00 2000: HTMLDW: Exiting SetAction() = -5
Nov 8 13:02:00 2000: HTMLDW: EnableCommit()
Nov 8 13:02:00 2000: HTMLDW: Entering Generate()
Nov 8 13:02:00 2000: HTMLDW: Exiting Generate(), length = 80493
Nov 8 13:02:00 2000: HTMLDW: SetComplete()
Nov 8 13:02:00 2000: HTMLDW: Entering Deactivate()
Nov 8 13:02:00 2000: HTMLDW: resetting state
Nov 8 13:02:00 2000: HTMLDW: Exiting Deactivate()
Nov 8 13:02:03 2000: HTMLDW: Activate()
Nov 8 13:02:03 2000: HTMLDW: Entering SetDWObject('gates_web.pbl','d_html_ma_query')
Nov 8 13:02:03 2000: HTMLDW: Doing PBL/PBD
Nov 8 13:02:03 2000: HTMLDW: SetLibraryList(pbdwr70.pbd,gates_web.pbl) = 1
Nov 8 13:03:13 2000: SIGABRT 6* abort (generated by abort(3) routine)
Nov 8 13:03:13 2000: si_signo [6]: SIGABRT 6* abort (generated by abort(3) routine)
Nov 8 13:03:13 2000: si_errno [0]: Error 0
Nov 8 13:03:13 2000: si_code [-1]: SI_LWP [pid: 2166, uid: 1001]
Nov 8 13:03:13 2000:
Full thread dump:
Nov 8 13:03:13 2000: "Thread-8"
Nov 8 13:03:13 2000: (TID:0xd3216588
Nov 8 13:03:13 2000: , sys_thread_t:0x1c8fe18
Nov 8 13:03:13 2000: , state:R
Nov 8 13:03:13 2000: , thread_t: t@34
Nov 8 13:03:13 2000: , sp:0xcc923b98 threadID:0xcc923de0
Nov 8 13:03:13 2000: , stack_base:0x0, stack_size:0x42000
Nov 8 13:03:13 2000: )
Nov 8 13:03:13 2000: prio=5
Nov 8 13:03:13 2000:
Nov 8 13:03:13 2000: "Thread-7"
Nov 8 13:03:13 2000: (TID:0xd3217c20
Nov 8 13:03:13 2000: , sys_thread_t:0x9c1e90
Nov 8 13:03:13 2000: , state:R
Nov 8 13:03:13 2000: , thread_t: t@32
Nov 8 13:03:13 2000: , sp:0xcc9c34d0 threadID:0xcc9c3de0
Nov 8 13:03:13 2000: , stack_base:0x0, stack_size:0x42000
Nov 8 13:03:13 2000: )
Nov 8 13:03:13 2000: prio=5
Nov 8 13:03:13 2000:
Nov 8 13:03:13 2000: "Thread-6"
Nov 8 13:03:13 2000: (TID:0xd3222d30
Nov 8 13:03:13 2000: , sys_thread_t:0x9c2ca8
Nov 8 13:03:13 2000: , state:R
Nov 8 13:03:13 2000: , thread_t: t@25
Nov 8 13:03:13 2000: , sp:0xccbf2bb8 threadID:0xccbf3de0
Nov 8 13:03:13 2000: , stack_base:0x0, stack_size:0x42000
Nov 8 13:03:13 2000: )
Nov 8 13:03:13 2000: prio=5
Nov 8 13:03:13 2000:
Nov 8 13:03:13 2000: "Thread-5"
Nov 8 13:03:13 2000: (TID:0xd3223310
Nov 8 13:03:13 2000: , sys_thread_t:0x99b248
Nov 8 13:03:13 2000: , state:CW
Nov 8 13:03:13 2000: , thread_t: t@10
Nov 8 13:03:13 2000: , sp:0xedd31d18 threadID:0xedd33de0
Nov 8 13:03:13 2000: , stack_base:0xedd32460, stack_size:0x42000
Nov 8 13:03:13 2000: )
Nov 8 13:03:13 2000: prio=5
Nov 8 13:03:13 2000:
Nov 8 13:03:13 2000: com.sybase.jaguar.servlet.ServletEngine.run(ServletEngine.java:1082)
Nov 8 13:03:13 2000: com.sybase.jaguar.servlet.ServletServiceImpl.run(ServletServiceImpl.java:278)
Nov 8 13:03:13 2000: com.sybase.jaguar.servlet._sk_JaguarServlet_ServletService.invoke(_sk_JaguarServlet_ServletService.java:500)
Nov 8 13:03:13 2000: "Thread-4"
Nov 8 13:03:13 2000: (TID:0xd321a870
Nov 8 13:03:13 2000: , sys_thread_t:0x9aa4e8
Nov 8 13:03:13 2000: , state:R
Nov 8 13:03:13 2000: , thread_t: t@31
Nov 8 13:03:13 2000: , sp:0xcca121f8 threadID:0xcca13de0
Nov 8 13:03:13 2000: , stack_base:0x0, stack_size:0x42000
Nov 8 13:03:13 2000: )
Nov 8 13:03:13 2000: prio=5
Nov 8 13:03:13 2000:
Nov 8 13:03:13 2000: "Thread-3"
Nov 8 13:03:13 2000: (TID:0xd31a18f0
Nov 8 13:03:13 2000: , sys_thread_t:0x97c3d8
Nov 8 13:03:13 2000: , state:R
Nov 8 13:03:13 2000: , thread_t: t@30
Nov 8 13:03:13 2000: , sp:0xcca63ba8 threadID:0xcca63de0
Nov 8 13:03:13 2000: , stack_base:0x0, stack_size:0x42000
Nov 8 13:03:13 2000: )
Nov 8 13:03:13 2000: prio=5
Nov 8 13:03:13 2000:
Nov 8 13:03:13 2000: "Thread-2"
Nov 8 13:03:13 2000: (TID:0xd319c238
Nov 8 13:03:13 2000: , sys_thread_t:0x8861a8
Nov 8 13:03:13 2000: , state:R
Nov 8 13:03:13 2000: , thread_t: t@23
Nov 8 13:03:13 2000: , sp:0xeccd3ba8 threadID:0xeccd3de0
Nov 8 13:03:13 2000: , stack_base:0x0, stack_size:0x42000
Nov 8 13:03:13 2000: )
Nov 8 13:03:13 2000: prio=5
Nov 8 13:03:13 2000:
Nov 8 13:03:13 2000: "SIGQUIT handler"
Nov 8 13:03:13 2000: (TID:0xd31982a0
Nov 8 13:03:13 2000: , sys_thread_t:0x7ad2b0
Nov 8 13:03:13 2000: , state:R
Nov 8 13:03:13 2000: , thread_t: t@22
Nov 8 13:03:13 2000: , sp:0xecd23af0 threadID:0xecd23de0
Nov 8 13:03:13 2000: , stack_base:0xecd23d74, stack_size:0x22000
Nov 8 13:03:13 2000: )
Nov 8 13:03:13 2000: prio=0
Nov 8 13:03:13 2000:
Nov 8 13:03:13 2000: "Finalizer thread"
Nov 8 13:03:13 2000: (TID:0xd3198088
Nov 8 13:03:13 2000: , sys_thread_t:0x7ad220
Nov 8 13:03:13 2000: , state:CW
Nov 8 13:03:13 2000: , thread_t: t@21
Nov 8 13:03:13 2000: , sp:0xed6b3a30 threadID:0xed6b3de0
Nov 8 13:03:13 2000: , stack_base:0xed6b3d74, stack_size:0x22000
Nov 8 13:03:13 2000: )
Nov 8 13:03:13 2000: prio=1
Nov 8 13:03:13 2000:
Nov 8 13:03:13 2000: "main"
Nov 8 13:03:13 2000: (TID:0xd31980b0
Nov 8 13:03:13 2000: , sys_thread_t:0x76fcc8
Nov 8 13:03:13 2000: , state:R
Nov 8 13:03:13 2000: , thread_t: t@1
Nov 8 13:03:13 2000: , sp:0xefffee60 threadID:0xa03b0
Nov 8 13:03:13 2000: , stack_base:0x0, stack_size:0x800000
Nov 8 13:03:13 2000: )
Nov 8 13:03:13 2000: prio=5
Nov 8 13:03:13 2000:
Nov 8 13:03:13 2000: Monitor Cache Dump:
Nov 8 13:03:13 2000: <unknown key> (0x99b248):
Nov 8 13:03:13 2000: <unowned>
Nov 8 13:03:13 2000: Waiting to be notified:
Nov 8 13:03:13 2000:
Nov 8 13:03:13 2000: "Thread-5"
Nov 8 13:03:13 2000: (0x99b248)
Nov 8 13:03:13 2000: Registered Monitor Dump:
Nov 8 13:03:13 2000: Thread queue lock:
Nov 8 13:03:13 2000: <unowned>
Nov 8 13:03:13 2000: Name and type hash table lock:
Nov 8 13:03:13 2000: <unowned>
Nov 8 13:03:13 2000: String intern lock:
Nov 8 13:03:13 2000: <unowned>
Nov 8 13:03:13 2000: JNI pinning lock:
Nov 8 13:03:13 2000: <unowned>
Nov 8 13:03:13 2000: JNI global reference lock:
Nov 8 13:03:13 2000: <unowned>
Nov 8 13:03:13 2000: BinClass lock:
Nov 8 13:03:13 2000: <unowned>
Nov 8 13:03:13 2000: Class loading lock:
Nov 8 13:03:13 2000: <unowned>
Nov 8 13:03:13 2000: Java stack lock:
Nov 8 13:03:13 2000: <unowned>
Nov 8 13:03:13 2000: Code rewrite lock:
Nov 8 13:03:13 2000: <unowned>
Nov 8 13:03:13 2000: Heap lock:
Nov 8 13:03:13 2000: <unowned>
Nov 8 13:03:13 2000: Has finalization queue lock:
Nov 8 13:03:13 2000: <unowned>
Nov 8 13:03:13 2000: Finalize me queue lock:
Nov 8 13:03:13 2000: <unowned>
Nov 8 13:03:13 2000: Waiting to be notified:
Nov 8 13:03:13 2000:
Nov 8 13:03:13 2000: "Finalizer thread"
Nov 8 13:03:13 2000: (0x7ad220)
Nov 8 13:03:13 2000: Monitor registry:
Nov 8 13:03:13 2000: <unowned (mutex held)>

The above should be appended to the migration info not overwritten.

In PB 8 build 3009 if I connect to ver 5.1.1, SCC connection is successfull, but one is unable to add objects to Source control from PB. The project I try to add from pb is a valid project and I can add file to the project from Version Manager successfully.
If we do not support the version then we need to document the versions we support

3. Click continue - next - next until you reach 'Start Copying Files' screen which gives you a summary of the options you chose to install.
Under Native Database Interfaces you will find
" Oracle 8.x Interface (O84)
Oracle 8.0.4/8.0.5"
This is a repetition.

This scenario has a script which causes the SECOND level sub menu item to lose focus e.g. messagebox(). On Win98 operating system, PB will gpf in USER.EXE (in development environment and runtime);
On NT4, this scenario does not gpf.
[ From PB help:-
Because MessageBox grabs focus, you should not use it when focus is changing... ]
The gpf on Win98 does not occur if the sub menu script keeps focus.

PB will not crash if atmost 2 ole controls are populated in the dw(parent window of the window containing dw is Response!). OR if the window is of type Main! then there is no problem with the number of OLE Controls being populated. Looks like there is some kind of limit when using a Response window in terms of memory cache, which does not get released at the appropriate time.

This is NOT a PB BUG :
" When a child window of a Response! window is closed, the child window's "garbage" (unused objects) are "piled onto" the garbage bin of the parent Response! window. If the parent window is not a Response! window, then garbage collection is performed when the child window is closed. "
You should force GarbageCollect() in the close event of the child window.

e.g. Window painter, UO painter, Menu painter.

For example, in any of the object painters (mentioned above), there is a "Script pane" there are 3 dropdownlistboxes :-

- Object/Functions/Declares

- Script/Declare Type

- Ancestor/Descendant

The "Ancestor/Descendant" ddlb is disabled after the save object operation.

This failure happens for ALL objects which ARE inherited and OVERRIDE ancestor functions:-

-Menu

-Window

-User object

The impact is that the PB developer cannot switch to ancestor nor descendant script.

PB6.x: N/A, feature not available in this release.

ls_ns = "datawindow.htmlgen.NetscapeLayers='yes'"
ls_ret = dw.Modify( ls_ns )

A 'topline' would make summary fields easier to differentiate (as a separator from rest of the fields) - e.g, totals or any other computed fields.

this.m_tools.m_pencil.visible = false
this.m_tools.m_pencil.enabled = false
this.m_tools.m_pencil.toolbaritemvisible = false

The tool bar item still appears when running app. As soon
as you select another item, than that toolbar item
can no longer be seen. If you physcially move pencil
after glasses and rerun app, than pencil doesn't show up.

workaround:
add the datavalue after translation again

RMB the workspace and select 'New - Target - Existing application'. You will see this button in "Set library search path" screen. If you don't look carefully you could easily miss that it is even there. Please replace with a Browse button so that it is easier to use.

Dropdown pick lists in IDE are limited in width to the control, but that obscures some of the information in the list... The lists should be allowed to be wider when expanded (like we allow for dddws)

This behavior occurs throughout the IDE, so it would be a big effort to locate all occurrences but all occurences should be addressed.

This is because all the object properties are of type integer. The customer feels that the fields in the
properties view should only accept valid input and not revert to this value if larger numbers are entered.

OS: Any
Version and Build #: 8.0 2051
16 bit/32 bit: 32
Database/Driver File/Version: N/A

Comments:
When viewing the source, it appears the <P align=center> tags are in the right place, but they don't seem to be interpreted by Navigator 4.7 correctly. Could be considered a navigator bug, but we might be safer using a DIV tag which does work for both IE and Netscape

Step-By-Step Instructions:
1. Add Target1.pbt target to an existing workspace
2. Configure a deployment for the target to a dynamo website
3. Deploy the target
4. View the page untitled.html in an IE browser and in Netscape and you'll notice how all the controls except for the static text are NOT centered.

Test Case (zip file) Name: 41075700.zip

The applname argument for the function is null in that case everytime this code is executed a new handle number is returned into ll_ret instead of a -1 or some other error.

See online help:
PowerScript reference>Statements, Events and Functions>Powerscript Functions
for a list of all the functions.

Suggestion that this option could use the 'ESC' key or perhaps the 'Ctrl-C' combination.

scroll bar created at runtime.
The problems seems to be only if you have HorizontalSplitScroll + Grid/Tabular combination.
If it is grid then complete data is not seen in its entirity, if it is tabular then you see

an extra row half visible at the bottom of the control.
On unchecking the HSplitScroll box repaint is ok.

If the horizontal scroll is not there on the dw control because there is not enough data

horizontally to scroll in the control, then you will see the repaint problem and the tag to

pull the split scroll cannot be clicked to create a split in the control.

Workaround:
add "editmask.UseFormat=yes" in datawindow syntax created by the describe() funktion
or
set the property dynamicly before retrieving -> dw.object.colomnname.editmask.UseFormat='yes'

The following functions:
-ChangeDirectory
-CreateDirectory
-DirectoryExists
-FileCopy
-FileMove
-GetCurrentDirectory
-RemoveDirectory
are listed under What's New>Miscellaneous>New PowerScript Functions
under the heading:
New File System Functions
they also need to be added to the Help under:
System Functions by Category>File Functions
Same is true for all the other functions listed under the "What's New" section.

Enhancement request for GetFileOpenName function: Add the following functionality:
- start-in directory
- setting the default file name to use
- multi-file selection cap

Assuming the WIndows Explorer list view paradigm, this is a capability provided there so we should be following tthe standard behavior.

When migrating there are two separate points in the wizard where you can enter a library list? Can one be eliminated?

The two screens allowing you to do this have separate purpose, I think. One is for an existing application (which may or may not require migration) and the other is for specifically migration. However, in the case you do require migration from an existing application, it seems redundant and it should 'know' that it's already asked for library list info.

If it is not supported to delete entire directories then the option should not come up and this should be documented.

Individual pbls are successfully deleted when deleted this way but not directories.

Now you have to add this event manually to get the intellimouse to work.

From development on why the move event doesn't work with intellimouse:
Thumbwheels generate the same WM_HSCROLL/WM_VSCROLL
message but with a diffierent notification code as opposed to the
situation where the mouse button is used. The notification code is
stored in the low word of the WPARAM that comes with the Windows
message.

When the mouse button is used to drag the horizontal/vertical
scroll box, the windows message WM_HSCROLL/WM_VSCROLL
is sent to the scroll bar control with the notification code
SB_THUMBTRACK (value 5).

This notification is mapped by PowerBuilder to pbm_sbnthumbtrack.
Thus, if an event-handler function for pbm_sbnthumbtrack is
defined, it will be fired.

When the intellimouse's thumbwheel is used, the windows
message WM_HSCROLL/WM_VSCROLL is sent to the scroll bar
control with the notification code SB_THUMBPOSITION (value 4).

This notification is mapped by PowerBuilder to pbm_sbnthumbposition.
In the current example, no event-handler function for pbm_sbnthumbposition
exists. Therefore, the expected behaviour did not occur.

The new event will also need the following code:
dw_1.Object.DataWindow.Zoom = scrollpos
dw_1.Title = "Zoom is " + String ( this.Position ) + "%"

Once a new event is generated automatically for vtrack and htrack (see 228957) than only
the following code will need to be added from above.

If you look at the pbdwrmt.pbl thru windows explorer, it shows up in lowercase.
If you select the pbl thru pb, it shows up in upper case. The ms-dos name
is in upper case.

Workaround:Modify the librarylist under the HTMLGenerator component
and change PBDWRMT.pbd to pbdwrmt.pbd

Using a pb component in jaguar that retrieves data to a datastore. Data
retreived from datastore is 1 row. A getfullstate returns a blob to a pb client.
A setfullstate shows the data in the dw. Happens when Oracle 8.1.5 and 8.1.6
client is used. Used the libpbo8470x.so.

PrintSetPrinter will change printers; however, customer would like capability to detect the fact that a UNC encoded printer path is not installed on the machine and have it automatically download the drivers and set up the printer defintion for you.

His rationale follows:

On WinNT and W2K, you can dynamically define a printer connection (the
related Windows API call is AddPrinterConnection):

http://msdn.microsoft.com/library/psdk/gdi/prntspol_7hgu.htm

All you pass is the name of the server and printer share. If the WinNT
or W2K machine doesn't have the printer drivers, it downloads and installs
them automatically from the machine hosting the share.

I don't believe that this is particularly important for client
applications. However, it would be an important feature for server based
applications, either native PB or EAServer hosted objects. A developer
shouldn't be required to create a local profile on the server for every
possible printer that a server based application may need to print to.

What I'm looking for is a version of the PrintSetPrinter function that
would take a UNC formatted servername/sharename argument, and dynamically
create a profile for that printer if one doesn't already exist, and of
course then make it the default. And, of course, if this call was made
from a Win9x client it should simply return an error.

Comments:
Only happens with machine code.
Also reproduced with user events (posting or triggering)
Worked in PB 5, broken in PB 6.5
Workaround - Call Yield just before calling Trim

On 7.02 Build 9028 it gives the following crash in PBVM
0x1139F134 - 0x00000004 - Read error

On PB 8 Build 3033
0x10CNBF3c4 - 0x00000004 - Read error

Step-By-Step Instructions: This is how it works;
You have to first create a project object and specify all options such as the exe name, machine code etc. Save the object in the pbl. RMB the target and under 'Deploy' tab make sure that this project object is
checked.
Finally, now when you run the commandline, PB starts up - deploys the project - shuts down.

The calling component (A) hangs after the call to the second component (B) tries to return control to the calling component method. The method is executed correctly and deactivate and destructor events are correctly fired in the second component (B) but component A never regains control.

As component A is frozen, component B is no longer called from component A but component B can still be called again from other components/clients. The problem is that component A can no longer be called from other clients. Jaguar must be restarted to use the component again

The component being called (B) must have the following properties to reproduce the problem:

- Automatic demarcation/deactivation selected

- Bind thread selected (Note that the same component called from a PB client app works)

Also component (A) must not be pooled.

I have only reproduced the problem when both components have ONLY the same properties (as described above for component B) checked.

WA: make the columns very slim (in height) and then adjust the detail band to the columns ie. to a height of eg. 4.

Several workarounds possible:

Change the HTML output from the generate method on the fly:

1. Change the BORDER attribute to BORDER=0

2. Insert a CSS information for the dw on the page.

Attached is the crash handler dump.

Exception code: C0000005 ACCESS_VIOLATION
File Name: E:\Program Files\Sybase\Shared\PowerBuilder\PBVM70.dll
File Version: 7.0.3.10009
Fault address=1137B1B6 Section:Offset=01:0017A1B6

Registers:
EAX:FFFFFFFF
EBX:00000000
ECX:0012FAEC
EDX:04780300
ESI:00000000
EDI:01123C10
CS:EIP:001B:1137B1B6
SS:ESP:0023:0012FADC EBP:00000000
DS:0023 ES:0023 FS:0038 GS:0000
Flags:00010246

Call stack:
Address Frame Param0 Param1 Param2 Param3 Function Name
1137B1B6 00000000 00000000 00000000 00000000 00000000 0001:0017A1B6 E:\Program Files\Sybase\Shared\PowerBuilder\PBVM70.dll

OS version:
Windows NT 4.0, Build Number: 1381, Service Pack 5

Memory Status:
Total physical memory: 261168K
Available physical memory: 123900K
Total virtual memory usage: 139712K / 516224K
PowerBuilder virtual memory usage: 99048K / 2097024K

Loaded Modules:
E:\Program Files\Sybase\Shared\PowerBuilder\PB70.EXE 7.0.3.10007
C:\WINNT\System32\ntdll.dll 4.00
E:\Program Files\Sybase\Shared\PowerBuilder\PBSYS70.dll 7.0.3.10009
E:\Program Files\Sybase\Shared\PowerBuilder\PBCMP70.dll 7.0.3.10009
E:\Program Files\Sybase\Shared\PowerBuilder\PBVM70.dll 7.0.3.10009
E:\Program Files\Sybase\Shared\PowerBuilder\libjcc.dll
C:\WINNT\system32\WSOCK32.dll 4.00
C:\WINNT\system32\KERNEL32.dll 4.00
C:\WINNT\system32\WS2_32.dll 4.00
C:\WINNT\system32\MSVCRT.dll 6.10.8293.0
C:\WINNT\system32\USER32.dll 4.00
C:\WINNT\system32\GDI32.dll 4.00
C:\WINNT\system32\ADVAPI32.dll 4.00
C:\WINNT\system32\RPCRT4.dll 4.00
C:\WINNT\system32\WS2HELP.dll 4.00
C:\WINNT\system32\comdlg32.dll 4.00
C:\WINNT\system32\SHELL32.dll 4.00
C:\WINNT\system32\COMCTL32.dll 5.81
C:\WINNT\System32\WINSPOOL.DRV 4.00
C:\WINNT\system32\ole32.dll 4.00
C:\WINNT\System32\OLEPRO32.DLL 5.0.4514
C:\WINNT\system32\OLEAUT32.dll 2.40.4514
C:\WINNT\system32\VERSION.dll 4.00
C:\WINNT\system32\LZ32.dll 4.00
C:\WINNT\System32\oledlg.dll 1.0
E:\Program Files\Sybase\Shared\PowerBuilder\PBDWE70.dll 7.0.3.10009
E:\Program Files\Sybase\Shared\PowerBuilder\PBDTS70.dll 7.0.3.10009
E:\Program Files\Sybase\Shared\PowerBuilder\PBDWP70.dll 7.0.3.10009
E:\Program Files\Sybase\Shared\PowerBuilder\PBSQL70.dll 7.0.3.10009
E:\Program Files\Sybase\Shared\PowerBuilder\PBLIB70.dll 7.0.3.10009
E:\Program Files\Sybase\Shared\PowerBuilder\PBDEV70.dll 7.0.3.10009
E:\Program Files\Sybase\Shared\PowerBuilder\PBORC70.dll 7.0.3.10009
E:\Program Files\Sybase\Shared\PowerBuilder\PBAPL70.dll 7.0.3.10009
E:\Program Files\Sybase\Shared\PowerBuilder\PBUDO70.dll 7.0.3.10009
E:\Program Files\Sybase\Shared\PowerBuilder\PBSCR70.dll 7.0.3.10009
E:\Program Files\Sybase\Shared\PowerBuilder\PBWED70.dll 7.0.3.10009
E:\Program Files\Sybase\Shared\PowerBuilder\PBDPP70.dll 7.0.3.10009
C:\WINNT\System32\ettmr40.dll 4.2.0.2
C:\PROGRA~1\Logitech\MOUSEW~1\SYSTEM\LgMousHk.dll 9.10.53
C:\WINNT\system32\MSIDLE.DLL 5.50.4134.600
C:\WINNT\System32\mpr.dll 4.00
C:\WINNT\System32\NOVNPNT.DLL v4.11a PTF (980408) PTF
C:\WINNT\system32\NETAPI32.dll 4.00
C:\WINNT\system32\NETRAP.dll 4.00
C:\WINNT\system32\SAMLIB.dll 4.00
C:\WINNT\System32\CALWIN32.DLL 5.1.0
C:\WINNT\System32\CLNWIN32.DLL
C:\WINNT\System32\LOCWIN32.DLL
C:\WINNT\System32\NCPWIN32.dll
C:\WINNT\System32\NETWIN32.DLL
C:\WINNT\System32\CLXWIN32.DLL
C:\WINNT\System32\NLS\ENGLISH\NOVNPNTR.DLL v4.11 (970501)
C:\WINNT\System32\MSVCRT40.dll 4.20 - OS use only. DO NOT DISTRIBUTE
C:\WINNT\System32\MSVCIRT.dll 6.00.8168.0
C:\WINNT\System32\ntlanman.dll 4.00
C:\WINNT\System32\NETUI0.dll 4.00
C:\WINNT\System32\NETUI1.dll 4.00
C:\WINNT\System32\rpcltc1.dll 4.00
E:\Program Files\Sybase\Shared\PowerBuilder\pbwep70.dll 7.0.3.10009
E:\Program Files\Sybase\Shared\PowerBuilder\pbwei70.dll 7.0.3.10009
C:\WINNT\System32\ntshrui.dll 4.00
C:\WINNT\System32\IMAGEHLP.DLL 4.00
C:\WINNT\System32\psapi.dll 4.00

Customer request the ability to lock any listview in the library painter so that it does not refresh to any changes in the treeview. Customer wants some sort of locking mechanism that can be turned on\off so that he can make one or more listviews 'static' so that changes in the Tview do not refresh them.

The idea is to be able to get the directory list information without having to resort to a listbox. It would be a System function, like the other new directory System functions (CreateDirectory, ChangeDirectory, DeleteDirectory).
Compare to of_dirlist in the n_cst_filesrv_win32 object. That one takes an array of n_cst_dirattrib by reference to
pass the data back.
Instead of:
n_cst_filesrv inv_filesrv
f_SetFileSrv(inv_filesrv, TRUE)
inv_filesrv.of_dirlist ( yada, yada, yada )
f_SetFileSrv(inv_filesrv, FALSE)

I would just use:
DirList ( yada, yada, yada )

from the externalexception and error events will be propagated to a runtimeerror object.

The source and description fields from externalexception are not accessible

via the try/catch mechanism. These two fields contain useful diagnostic

information by the ocx vendor.

Problem was originally reported on PFC base project. But it was finally be isolated that is caused by the classdefinition object function - FindMatchingFunction.

on a simple example provided can see the leakage by NT Task Manager :

lcd_obj1 = dw_1.classdefinition
for i = 1 to 100
sd = lcd_obj1.findmatchingfunction("Accepttext", ls_args)
sd = lcd_obj1.findmatchingfunction("Accepttext", ls_args)
sd = lcd_obj1.findmatchingfunction("Accepttext", ls_args)
:
:
:
//repeat 12 time here -> overall 1200 call on each button click
next

Capture the follow from Window Task Manager for reference :

No. Mem Usage Diff VM Usage Diff
1 8572K ------ 5772K -----
2 8832K 260K 5900K 128K
3 8952K 120K 6028K 128K
4 9076K 124K 6156K 128K
5 9196K 120K 6284K 128K
6 9320K 124K 6348K 64K
7 9440K 120K 6476K 128K
8 9568K 128K 6604K 128K

According to Knowledge Base article, Q199805:
As of Internet Explorer 5, the browser does not refresh pages when the Forward and Back buttons are used.
The behavior of Back and Forward was changed to conform to section 13.13 of the HTTP 1.1 specification, which states the following:

User agents often have history mechanisms, such as "Back" buttons and history lists, which can be used to redisplay an entity retrieved earlier in a session.

From Q234067:
Cache-Control META HTTP-EQUIV tags are ignored and have no effect in
Internet Explorer versions 4 or 5.
<META HTTP-EQUIV="Pragma" CONTENT="no-cache">

Comments:
String editmask of upper case /lower case /number etc are ignored by datawindow when data is entered by pasting from clipboard or when retrieved by the datawindow. The same data if entered via edit control has the edit mask applied.
The desired behaviour can be seen in all builds of PB 7 ie the mask is applied to the data pasted from the clipboard or when retrieved from db.

The pbvm's are the same version. If you start pb70.exe from the Powerbuilder
directory and not from the shared directory than no problem.

The following is the crash handler output:
Exception code: C0000005 ACCESS_VIOLATION
File Name: �,鵺p伫w����8�
File Version:
Fault address=02BB001F Section:Offset=00:0012F494

Registers:
EAX:01220124
EBX:BC000002
ECX:0122A8D8
EDX:01112218
ESI:01111E28
EDI:10A61610
CS:EIP:001B:02BB001F
SS:ESP:0023:0012F954 EBP:00000000
DS:0023 ES:0023 FS:0038 GS:0000
Flags:00010A82

Call stack:
Address Frame Param0 Param1 Param2 Param3 Function Name

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

Memory Status:
Total physical memory: 196024K
Available physical memory: 72440K
Total virtual memory usage: 149572K / 377164K
PowerBuilder virtual memory usage: 76516K / 2097024K

Loaded Modules:
E:\pb70\PowerBuilder 7.0\Pb70.exe 7.0.2.8037
C:\WINNT\System32\ntdll.dll 4.00
e:\pb70\Shared\PowerBuilder\PBSYS70.dll 7.0.3.10039
e:\pb70\Shared\PowerBuilder\PBCMP70.dll 7.0.3.10039
C:\WINNT\System32\PBVM70.dll 7.0.3.10039
e:\pb70\Shared\PowerBuilder\libjcc.dll
C:\WINNT\system32\WSOCK32.dll 4.00
C:\WINNT\system32\KERNEL32.dll 4.00
C:\WINNT\system32\WS2_32.dll 4.00
C:\WINNT\system32\MSVCRT.dll 6.10.8293.0
C:\WINNT\system32\USER32.dll 4.00
C:\WINNT\system32\GDI32.dll 4.00
C:\WINNT\system32\ADVAPI32.dll 4.00
C:\WINNT\system32\RPCRT4.dll 4.00
C:\WINNT\system32\WS2HELP.dll 4.00
C:\WINNT\system32\comdlg32.dll 4.00
C:\WINNT\system32\SHELL32.dll 4.00
C:\WINNT\system32\COMCTL32.dll 5.81
C:\WINNT\System32\WINSPOOL.DRV 4.00
C:\WINNT\system32\ole32.dll 4.00
C:\WINNT\System32\OLEPRO32.DLL 5.0.4277
C:\WINNT\system32\OLEAUT32.dll 2.40.4277
C:\WINNT\system32\VERSION.dll 4.00
C:\WINNT\system32\LZ32.dll 4.00
C:\WINNT\System32\oledlg.dll 1.0
e:\pb70\Shared\PowerBuilder\PBDWE70.dll 7.0.3.10039
e:\pb70\Shared\PowerBuilder\PBDTS70.dll 7.0.3.10039
e:\pb70\Shared\PowerBuilder\PBDWP70.dll 7.0.3.10039
e:\pb70\Shared\PowerBuilder\PBSQL70.dll 7.0.3.10039
e:\pb70\Shared\PowerBuilder\PBLIB70.dll 7.0.3.10039
e:\pb70\Shared\PowerBuilder\PBDEV70.dll 7.0.3.10039
e:\pb70\Shared\PowerBuilder\PBORC70.dll 7.0.3.10039
e:\pb70\Shared\PowerBuilder\PBAPL70.dll 7.0.3.10039
e:\pb70\Shared\PowerBuilder\PBUDO70.dll 7.0.3.10039
e:\pb70\Shared\PowerBuilder\PBSCR70.dll 7.0.3.10039
e:\pb70\Shared\PowerBuilder\PBWED70.dll 7.0.3.10039
e:\pb70\Shared\PowerBuilder\PBDPP70.dll 7.0.3.10039
C:\WINNT\system32\MSIDLE.DLL 5.50.4522.1800
C:\WINNT\System32\mpr.dll 4.00
C:\WINNT\System32\ntlanman.dll 4.00
C:\WINNT\System32\NETUI0.dll 4.00
C:\WINNT\System32\NETUI1.dll 4.00
C:\WINNT\system32\NETAPI32.dll 4.00
C:\WINNT\system32\NETRAP.dll 4.00
C:\WINNT\system32\SAMLIB.dll 4.00
C:\WINNT\System32\rpcltc1.dll 4.00
C:\WINNT\System32\ntshrui.dll 4.00
C:\WINNT\System32\LinkInfo.dll 4.00
C:\WINNT\System32\IMAGEHLP.DLL 4.00
C:\WINNT\System32\psapi.dll 4.00

This property is greyed out in PB 8.0 as reported in CR 228888 so cannot test.

In database painter, open a table, edit data, then go to Rows>Import.
The only formats offered are .dbf and .txt, which must be a tab-separated file.
Customer asks that other formats be made available, such as a text format based on comma separated values....

ref to CR# 151102 this was reported as an enhancement request with PB 4.0 but has not been implemented.

The 'Extend ancestor script' setting is disabled if ddlb 'Objects,Functions or Declares' is toggled.
This failure happens for ALL objects which ARE inherited and EXTEND ancestor functions:-
-Menu
-Window
-User object

This failure happens when toggling object scripts using the 'Objects,Functions or Declares' ddlb.
If the PB object is doubleclicked/ chosen/ toggled from either of the places below, the problem described
does not occur:
- Control list pane/ tab
OR
- Layout pane/ tab

Suspecting the delay is due to number of remote drives being searched, if this can't be helped at least the cursor should change to hourglass

Second time I simply changed the drive from C: to D: and during the install received a different error as follows.

SQL Anywhere 7 Install

An error occured during the move data process -2147024909
Component: Script Component
File Group: dbtool_scripts
File:

When I reinstalled taking all the defaults it installed just fine.

The web page is using dynascript. Using the geturl(), the arguments
show up on the web page. With posturl, it appears as if the dynascript
isn't being processed. The arguments don't appear on the web page
after being called.

The stm page being called from Powerbuilder is as follows:
<HTML>
<TITLE>PostURL Test</TITLE>
<BODY>
<H1>PostURL Test</H1>
<!--SCRIPT
var szUser;
var szPwd;

if ( exists( document.value.user ) )
{
szUser = document.value.user;
document.writeln( "User: " + szUser + "
" );
}
if ( exists( document.value.pwd ) )
{
szPwd = document.value.pwd;
document.writeln( "Password: " + szPwd + "
" );
}
-->
<form id="myForm" action="posturl.stm" method="POST">
<table border="0" width="150">
<tr>
<td>User:</td>
<td><input name="user" type="text" size="25"></td>

</tr>
<tr>
<td>Password:</td>
<td><input name="pwd" type="text" size="25"></td>
</tr>
<tr>
<td colspan="2" align="center"><input type="Submit" value="Submit"></td>
</tr>
</table>
</form>
</BODY>
</HTML>

Workaround :
Add code in the generate()
long position1
string ls_TD="<TD></TD>"
DO
position1 = pos(ls_result, ls_TD)
if position1 > 0 then
ls_result = Replace ( ls_result, position1, 9, "")
end if
LOOP UNTIL (position1 = 0)

The behavior now after the fix was made is, the warning message appears
"Ignore compliation warnings and lose changes". If you say yes, the
changes don't take effect. (Which is what you want it to do.). If you say no,
the compilation warning now becomes a syntax error.

encrypted. When connecting thru the development environment,

pb will decrypt the password.

When running a pb application at runtime, there is no mechanism

to decrypt the password.

Customer would like to have a option in the db profile so that you

set if you want a application at runtime to automatically decrpyt

the db password. If the option is not set, than pb will not decrypt

and the user will get a db error.

You cannot edit this asp script. If you do and then save it, close
out of pb and open pb again, the changes did not save.

This is not a big deal to work around, but I don't think it's correct behavior. If we can't address this with a fix, can we document the behavior?

When trying to create thte New Dynamo Website Target the Next button will be greyed out and you will notice that there is a message at the bottom of the wizard window that states : "Dynamo is not installed on this system. Install PowerDynamo and try again." If you change the regional setting to the United States default you will see that this works fine.

Only occurs on objects that are not direct ancestor/descendants but rather have another level between them; does not occur in PB 6.

Pressing the Escape key or clicking in the script area should make the frame close.

If using just-in-time debugging, execution stops when an exception or runtime error is encountered, even if that error is caught and processed via a TRY-CATCH block

This may be pretty tough to do, since you really don't know if the exception is being caught until you get to the CATCH block, and since we're interpreting code here, we'd have to look ahead to determine this.

In pb 7.0.3 versions 8046 and 9028, the problem was restricted to the header
band of the dw. The data column showed in the header and the display
column showed in the detailed. The problem has regressed where the
data column shows up in the detail and the header band even though the
property is set to show the display column.

When installing PB8, both Custom and Compact tested, about 80% through, it starts installing 'Powersite' stuff and the InstallShield dialog says 'Copying Powersite files..." Others may have flashed quickly but these were noted.

Installing PowerSite Program Files
PowerSite Self-Registering DLLS
PowerSite Self Registering Active Xs and
PowerSite Help files.

When you click on the treeview, the root item returns the correct handle. You
then click on the child and it returns the incorrect handle number the first
time you click on it. You click again and it returns the correct handle.

long ll_handle
ll_handle = tv_1.FindItem(CurrentTreeItem!, 0)

Customer has a PB 6.5.1 application that when run on WIN 95 connected to a HP950C local printer causes a gpf in in a print driver dll( HPF9XDRO.DRV). The gpf occurs when there is a picture object on the datawindow and the bitmap has been reduced in size. Size of actual bitmap seems to be an issue here.

Problem does not occur on NT 4.0 or on WIN95 with PB 7.0.3.

To duplicate:

1. Run the provided application within PowerBuilder. The NVO uo_hello is currently NOT autoinstantiated and the code in the app open event simple CREATEs an instance and calls a method. You should see a Hello, World message box when running it.

2. Open uo_hello and check autoinstantiate on the property sheet.

3. Do a full rebuild - you should get an error indicating Autoinstantiated class illegal for CREATE (this is correct)

4. Now try to run the application, it crashes PB

5. Reopen PowerBuilder and now try to open the workspace/target - you get presented the migration dialog. Migration, however, will fail beacuse of the error in step 3, and you end up in an infinite loop of migration requests.

6. The only way I've been able to 'fix' it is to add the PBL to another existing target, export the uo, delete the autoinstantiate tag, reimport and remigrate the original target. Doing this 'wrong' though seems to cause PB to crash quite a bit.

Alternatively, don't run the application in PB as in step 4, but just close the workspace and try to reopen it, you'll still see the infinite loop of migration requests.

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

Per Development: the library painter is not supposed to display the most recent object on startup.
What the library painter will do is have the same root at startup for the tree view.

The following is the crash handler results:
Exception code: C0000005 ACCESS_VIOLATION
File Name: E:\pb80\Shared\PowerBuilder\PBAPL80.dll
File Version: 8.0.00.3113
Fault address=1080B5D8 Section:Offset=01:0000A5D8

Registers:
EAX:00000001
EBX:01204F6C
ECX:01620034
EDX:00000000
ESI:01620034
EDI:00000000
CS:EIP:001B:1080B5D8
SS:ESP:0023:0012DE8C EBP:01204F54
DS:0023 ES:0023 FS:0038 GS:0000
Flags:00010296

Call stack:
Address Frame Param0 Param1 Param2 Param3 Function Name
1080B5D8 01204F54 00000000 01200034 00000000 00000000 0001:0000A5D8 E:\pb80\Shared\PowerBuilder\PBAPL80.dll
00000000 01204F6C 00000000 01200034 00000000 00000000 0000:00000000
00000000 01204F84 00000000 01200034 00000000 00000000 0000:00000000

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

Memory Status:
Total physical memory: 196024K
Available physical memory: 66472K
Total virtual memory usage: 158284K / 377140K
PowerBuilder virtual memory usage: 179520K / 2097024K

Loaded Modules:
E:\pb80\PowerBuilder 8.0\pb80.exe 8.0.00.3050
C:\WINNT\System32\ntdll.dll 4.00
E:\pb80\Shared\PowerBuilder\PBSYS80.dll 8.0.00.3113
E:\pb80\Shared\PowerBuilder\PBCMP80.dll 8.0.00.3113
E:\pb80\Shared\PowerBuilder\PBVM80.dll 8.0.00.3113
E:\pb80\Shared\PowerBuilder\libjcc.dll
C:\WINNT\system32\WSOCK32.dll 4.00
C:\WINNT\system32\KERNEL32.dll 4.00
C:\WINNT\system32\WS2_32.dll 4.00
C:\WINNT\system32\MSVCRT.dll 6.10.8293.0
C:\WINNT\system32\USER32.dll 4.00
C:\WINNT\system32\GDI32.dll 4.00
C:\WINNT\system32\ADVAPI32.dll 4.00
C:\WINNT\system32\RPCRT4.dll 4.00
C:\WINNT\system32\WS2HELP.dll 4.00
C:\WINNT\system32\comdlg32.dll 4.00
C:\WINNT\system32\SHELL32.dll 4.00
C:\WINNT\system32\COMCTL32.dll 5.81
C:\WINNT\System32\WINSPOOL.DRV 4.00
C:\WINNT\system32\ole32.dll 4.00
C:\WINNT\System32\OLEPRO32.DLL 5.0.4277
C:\WINNT\system32\OLEAUT32.dll 2.40.4277
C:\WINNT\system32\VERSION.dll 4.00
C:\WINNT\system32\LZ32.dll 4.00
C:\WINNT\System32\oledlg.dll 1.0
C:\WINNT\System32\IMM32.dll 4.00
C:\WINNT\System32\MSVCIRT.dll 6.00.8168.0
E:\pb80\Shared\PowerBuilder\PBDWE80.dll 8.0.00.3113
E:\pb80\Shared\PowerBuilder\PBDTS80.dll 8.0.00.3113
E:\pb80\Shared\PowerBuilder\PBDWP80.dll 8.0.00.3113
E:\pb80\Shared\PowerBuilder\PBSQL80.dll 8.0.00.3113
E:\pb80\Shared\PowerBuilder\PBLIB80.dll 8.0.00.3113
E:\pb80\Shared\PowerBuilder\PBDEV80.dll 8.0.00.3113
E:\pb80\Shared\PowerBuilder\PBORC80.dll 8.0.00.3113
E:\pb80\Shared\PowerBuilder\PBAPL80.dll 8.0.00.3113
E:\pb80\Shared\PowerBuilder\PBUDO80.dll 8.0.00.3113
E:\pb80\Shared\PowerBuilder\PBSCR80.dll 8.0.00.3113
E:\pb80\Shared\PowerBuilder\PBWED80.dll 8.0.00.3113
E:\pb80\Shared\PowerBuilder\PBDPP80.dll 8.0.00.3113
E:\pb80\Shared\PowerBuilder\PBEAS80.dll 8.0.00.3113
E:\pb80\Shared\PowerBuilder\pbweb80.dll 8.0.00.3113
E:\pb80\SHARED~2\Web Targets\WtGenericServ80.dll 1, 0, 0, 1
C:\WINNT\system32\WININET.dll 5.50.4522.1800
C:\WINNT\system32\SHLWAPI.dll 5.50.4522.1800
C:\WINNT\system32\TAPI32.dll 4.00
C:\WINNT\System32\mpr.dll 4.00
C:\WINNT\System32\ntlanman.dll 4.00
C:\WINNT\System32\NETUI0.dll 4.00
C:\WINNT\System32\NETUI1.dll 4.00
C:\WINNT\system32\NETAPI32.dll 4.00
C:\WINNT\system32\NETRAP.dll 4.00
C:\WINNT\system32\SAMLIB.dll 4.00
C:\WINNT\System32\rpcltc1.dll 4.00
E:\pb80\SHARED~2\Web Targets\WtViewSrvc80.dll 1, 0, 0, 1
E:\pb80\SHARED~2\Web Targets\WtDataObj80.dll 1, 0, 0, 3050
E:\pb80\SHARED~2\Web Targets\pswedit70.dll
C:\WINNT\System32\MFC42.DLL 6.00.8168.0
C:\WINNT\System32\ODBC32.dll 3.510.4202.0
C:\WINNT\System32\MSVCP50.dll 5.00.7051
C:\WINNT\System32\ATL.DLL 3.00.8449
C:\WINNT\System32\odbcint.dll 3.510.4202.0
E:\pb80\SHARED~2\WEBTAR~1\WTCURR~1.DLL 1, 0, 0, 3050
E:\pb80\SHARED~2\WEBTAR~1\WtLang80.dll 1, 0, 0, 3050
E:\pb80\SHARED~2\WEBTAR~1\WTCOMP~1.DLL 1, 0, 0, 3050
C:\WINNT\System32\msjava.dll 5.00.3316
C:\WINNT\System32\VMHELPER.DLL 5.00.3316
C:\WINNT\System32\JIT.DLL 5.00.3316
C:\WINNT\System32\javart.dll 5.00.3316
C:\WINNT\system32\MSIDLE.DLL 5.50.4522.1800
C:\WINNT\System32\ntshrui.dll 4.00
C:\WINNT\System32\IMAGEHLP.DLL 4.00
C:\WINNT\System32\psapi.dll 4.00

predicate must have string datatype.
Error happens in developement and runtime.
Happens when retrieve is based on a argument and using a LIKE clause. If you hardcode the

value in the LIKE clause there is no error.

This is indeed an IQ bug : ASIQ 12.4.2 does not support using a parameter for the pattern of a "Like" predicate in the Where clause - in 12.4.2 this is required to be a constant. Support for using a parameter in this part of the SQL grammar has been added in 12.4.3.

While trying to create the column alias and you try to tab to the alias field,
pb won't let you and you cannot enter anything in the field.

Problem happens for syc,o84 and mss.

For example, select a window/properties/position. In pb 6.x, there was a graphical display to increase the
size of a window. When it was increased, it automatically increased the size of the x and y coordinates.
Customer would like to see this feature in pb 8.0.

Workaround:
add "dummy assignment"
ldwo_test = dw_1.Object.d_nest.Object.dept_name
ss = ldwo_test.primary[1]
dw_1.print()

For example, the html page has setweight(true,true,true,true,true) set. A column
has a format of #,#00 set. When you alt tab to another application and then
alt tab back into the browser and then click on another field to give focus back
to the browser, a validation error will appear.

If you just call up the the page and tab thru the fields, than no problem. No validation
errors will appear.

If you set the setweight to (true,true,true,true,false), than no problems. The inconsistency
appears to be in the clientformatting property.

Many utility programs, read the library
list from the pb.ini file. The workspace and target files use relative
paths so determining the exact full path of a file would take a lot of code.

I would like to suggest adding two new functions. One would take the
argument of a workspace filename. It would return a string array with the
full path name of pb target files. Another function would take the
argument of a target filename. It would return the full path library list
in a string just like the pb.ini file has in earlier versions.

ls_sql = "SELECT DISTINCT " + &
" gminfo.contact_fname_s , " + &
" gminfo.contact_lname_s , " + &
" gmcmpany.company_name_1_s , " + &
" gmin_mngr.act_code , " + &
" gmin_mngr.numb_ , " + &
" gmin_addr.state , " + &
" gmin_addr.tz_code , " + &
" gmin_mngr.recordid , " + &
" gmcmpany.comp_code " + &
" FROM " + &
" {oj {oj gmin_mngr LEFT OUTER JOIN gmin_addr ON gmin_mngr.recordid = gmin_addr.recordid}, " + &
" {oj gmin_mngr LEFT OUTER JOIN gminfo ON gmin_mngr.recordid = gminfo.recordid} " + &
" LEFT OUTER JOIN gmcmpany ON gmin_mngr.comp_code = gmcmpany.comp_code} "

f_sqlca_from_ini("onc7",SQLCA)
connect using SQLCA;

string presentation_str
presentation_str = "style(type=grid)"
ls_syntax = SQLCA.SyntaxFromSQL(ls_sql, presentation_str, ls_error)

**** Mon Jan 22 12:13:05 EST 2001 *** tcapadou ****
This is a known bug or designed behaviour (you decide) in browsers today. Layers can not be placed on top of system GUI (like form elements). They will always shine through. netscape and msie implement somewhat different but both has basically same issue. even n6 let text inside elements (but atleast nolonger the element themselves) shine through.

You should swap your form elements in div tags and when activating the pull down menus you should make a function call to a function which hides the div tags holding the form elements. When the menus are later hidden the same should take place and the div tags holding the form elements should be shown again.

Please refer to newsposting from www.htmlforums.com at the following link:
http://www.htmlforums.com/showthread.php?threadid=1065

Using the AND operator, PowerScript should evaluate its right-hand operand only if the value of its left-hand operand is true

Problem happens using sqloledb,mss and odbc.

blob testblob

selectblob idcol into :testblob
from testuniqueidentifier
using sqlca;

messagebox("heres the blob field",string(testblob))

CREATE TABLE tsmaint.TestUniqueIdentifier (IDCol ????? NOT NULL,

Problems happens for mss works ok for odbc to sql server.

Cannot create datawindow
This column's datatype (xxxx) requires the use of an embedded sql statement

See cr 232292 because using embedded sql doesn't work either. Tried
inserting an ole database blob column but the column with the uniqueidentifier
doesn't retrieve for oledb and mss. Using the oledb driver and inserting the ole database blob
column will result in the following error:

Select error:
Microsoft OLE DB Provider for SQL Server
An object was open

When typing the MicroHelp for one menu item and clicking with the mouse on
a different item in the WYSIWYG Menu view, looses the text just entered in the MicroHelp property.
When switching back to the original item, the editing changes are gone.

This does not happen when selecting menu item in the Tree Menu View.

2. When you press the New DataWindow expression function link, the resulting screen shows ACos and ASin concatenated

3. Under the New DataWindow properties link

a. DefaultPicture isn't what's changed, it's PictureName that now accepts GIF's and JPGs (cf. issue 41079659)
b. HTML.ValueIsHTML was introduced in 7.0.3 (the DBParm section specifically calls out Parms introduced previously, not sure if this section should as well)
c. HTML.AppendHTML is not included, what's done with HTML.ValueIsHTML should be done for AppendHTML
d. the HTMLGen options for Javascript caching are not included. Those were also introduced in 7.0.3 along with ValueIsHTML and AppendHTML

4. Under DBParms added since 7.0, should we add AtAtIdentity for MSS?

Pictures using HTML datawindow are not displayed properly because the HTML generated for Netscape does not contain size attributes.
The same HTML DW is properly displayed with IE, because IE supports StyleSheet sizing for pictures.

There is a Ctrl+shift+P but is more restrictive than the ctrl+shift+w.
It previews only the window that is active. Ctrl+shift+w provides
more functionality than ctrl+shift+p for a developer.

Also, the return type should be a PowerBuilder Long, not an Integer, as it is currently. With a return type of integer (short or integer(16) in EA Server) you will run into an error if a large number of rows, eg 49000, is retrieved.

This is working in 7.0.3 build 10048.

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

Add a new feature in PowerBuilder 8 IDE : Be able to open each object in Read-Only mode

Simple reproduction of problem with an External datawindow. Assign some values programatically using win_1.dw_1.object.data[1,1] = "123", etc. Bring focus to first field. Content of this field will vanish. Change focus to 2nd field, content will comeback. This is wrong. Assign value with SetItem and the problem does not exist.

This code is provided in the automatically generated MDI template.

/* Populate SQLCA from current PB.INI settings */

SQLCA.DBMS = ProfileString("pb.ini", "database", "dbms", "")
SQLCA.Database = ProfileString("pb.ini", "database","database", "")
SQLCA.Userid = ProfileString("pb.ini", "database", "userid", "")
SQLCA.DBPass = ProfileString("pb.ini", "database", "dbpass", "")
SQLCA.Logid = ProfileString("pb.ini", "database", "logid", "")
SQLCA.Logpass = ProfileString("pb.ini", "database", "LogPassWord", "")
SQLCA.Servername = ProfileString("pb.ini", "database", "servername", "")
SQLCA.DBParm = ProfileString("pb.ini", "database", "dbparm", "")

CONNECT;

There exists a native driver for ASA7 OLEDB connection.
Verfified that ASA connection using Microsoft OLEDB is a problem too - see test 2 ;
Note: At this time, there is no native driver from PB to ASA 7 (or previous versions).

There exists a native driver for ASA7 OLEDB connection.
Verfified that ASA connection using Microsoft OLEDB is a problem too - see test 2 ;
Note: At this time, there is no native driver from PB to ASA 7 (or previous versions).

This is a duplicate of CR 232424. Both DefaultPicture and PictureName were added to the Help. There is a precedent for the label and the property name being different on the same page (Horizontal and Vertical Alignment versus HTextAlign and VTextAlign). Picture File actually descibes the setting more accurately.

1. Clip window: when a clip is deleted, using the delete (x) button, the next/previous item is not selected after the item is deleted, This slows the deleting of clips.

2. When changing workspaces the clip window retains clips rather than being workspace specific. Can the clips be associated to a workspace rather than being independent. I have a workspace for a PowerTool App and a workspace for a PFC App, when I change workspaces the clip window retains clips. The clips shuld be associated to a workspace rather than PowerBuilder itself.

Using Oracle 8.1.6 and o84 driver.

Workaround:
1. comment the declaration of the Oracle stored procedure.
2. add your script and compile and save the script.
3. export the object and edit it with an editor
4. uncomment the stored procedure
5. import the object

Workaround:
Add symbolic link to pbjag70.so:

lrwxrwxrwx 1 pbtest staff 16 Mar 7 16:02 pbjag70.so -> ./libpbjag70x.so

The key to making this work is the symbolic link. This can be created as follows while in the $JAGUAR/lib directory:

ln -s ./libpbjag70x.so pbjag70.so

First you must remove the existing file pbjag70.so if it exists and you should end up with the following output from a ls -l

lrwxrwxrwx 1 pbtest staff 16 Mar 7 16:02 pbjag70.so -> ./libpbjag70x.so

The font mappings in PBFNTxx.INI are always used even if the font to be substituted exists on the PC the application is running on. The PB documentation implies that PB only looks in this ini file if the required font is not found on the machine. It seems PB always looks there first and if there is an entry for that font then it uses it as a substitute without checking if the original font is on the machine.

The PB App techniques manual (Chap 31 p661 PB 7 version) states:

"...When an application uses a screen or printer font that is unavailable, PowerBuilder looks in
the [FontSubstitutes] section of this file for a mapping..."

Workaround: If you cannot turn off staticbind, then you can export the datawindow and change the column datatype from decimal(n) to number.

PowerBuilder Application Execution Error (R0023):
Application Terminated. Canot assign object of type
tab_1 to variable of type base_wizard at line 8 in help event of object
base_multilineedit.

After hitting ok and you go to help/about--"none" will appear
in the box.

1. Backspace does not work properly when deleting the value 12345 from right to left
2. Impossible to key properly into editmask field with decimal places when text was fully selected.
3. SelectText did not highlight the column, when called from the rowfocuschanged event.
This last problem can be circumvented by posting the SelectText function.

Comments:
Previous autoscripting (PB 7.x) behaviour 'switched off' autoscripting as soon as the user types the first parenthesis of a function.

PB 8 continues autoscripting at this point (that's OK) and shows all the arguments for that function. But if the user types the complete function and closes the parenthesis the autoscripting remains on. The problem occurs when the user then hits enter key. If the length of the string typed in the args list is shorter than the autoscripted list then PB pastes/appends the remaining autoscript text on the end of the code just typed in by the user.

The user can just hit the escape key which is probably OK at any point before the last parenthesis but once the user closes the parenthesis the autoscripting should switch itself off

When building an EXE the project painter, with its new Version information section, is too large to be displayed in a 640x480 - if you get rid of the toolbars and output window, you can just see part of the first PBL/PBD in the library list

When the bitmap is excluded from the rich text format document, the document is inserted correctly.
However when a bitmap is included, the application will crash.

The workaround is to remove the bitmap from the rich text format document :-
E.g.
a)Use "InsertDocument() to load the rtf file(exclude bitmap from doc).
b)Use the powerscript function "InsertPicture()" to insert the bitmap into the rte control.

The effect will be that the NULL value is displayed as a 0 (zero) value.

Here's the code:
//systemerror event
clipboard (error.text)

//clicked event of cb:
long ll_Handle
treeviewitem ltvi_Item

ll_Handle = tv_1.FindItem (RootTreeItem!, 0)
IF ll_Handle > 0 THEN
IF tv_1.GetItem (ll_Handle, ltvi_Item) = 1 THEN
st_2.text = "About to check the data of the treeview item"
IF IsValid (ltvi_Item.data) THEN
messagebox("Data Item Checked Out","")
ELSE
messagebox("Data item is invalid","")
END IF
ELSE
st_2.text = "GetItem failed"
END IF
ELSE
st_2.text = "FindItem failed"
END IF

From the code above, the clipboard will show the error but the pb will
not process the code after the isvalid function. In this case the message
of "Data item is invalid" doesn't appear.

In pb 7.0.3, running the same code, pb will process the next line of
code after the isvalid. The message of "Data item is valid" does appear.

Per Development, this is an intended behavioral change in PB 8.0:
PB 8.0 no longer behaves like PB7.0. It works BETTER! Engineering implemented a new BOOL IsValid( any argument) function to test if any argument is a PowerObject. Instead of throwing a system exception (like PB 7.0 does), this new function returns FALSE. Therefore, with PB 8.0, this test case will no longer invoke the systemerror event. Debug through the CLICKED event on the button and you'll see the difference. Much more intuitive.

Try to delete a PBL that is not in the current applications search path in the library painter. It tells you that "There must be an open workspace with PowerBuilder targets to complete this operation". There is one opened. If you delete at the folder level it allows you to delete and gives messagebox confirming each delete.

On the dialog in the library painter to confirm deletion of multiple objects, there are four buttons 'Yes', 'Yes To All', 'No' and 'Cancel'. If you try to cycle through them using either right or left arrow keys, you get 'stuck' moving from 'Yes to All' to 'No' (forwards) and vice versa (backwards).

PER DEVELOPMENT:
This will not be addressed; and if you do this, your application will not be supported.

The error received is "Array boundary exceeded at line 29 in function of_convert_value of object nv_retrieval_arg". The method assumes a time will be supplied and attempts to parse the time starting at a position in the array that does not exist.

When the user object function name is selected from the PB object "Browser", then RightMouseButton (RMB) click and select "copy", PB will gpf.

This is fixed in 9.0.2 build 7697 and 10.2 build 8065.

Step-By-Step Instructions:
1) Open Browser, go to System tab
2) RMB on the SSLCallback object and select help from the popup menu

The customer has also reported crashing when simply running and closing the debugger which I have not been able to reproduce, but this may be related to the above.

It appears that the scrollbar will display if the first line of the query is longer than the view.
It will also appear if you do a cut and paste from a file.

Exception code: C0000005 ACCESS_VIOLATION
File Name: E:\pb70\Shared\PowerBuilder\PBDWE70.dll
File Version: 7.0.3.10047
Fault address=106DDA60 Section:Offset=01:0011CA60

With an edit mask control of type datemask! of type dd/mm/yy and dd/mm/yyyy

When the value in the editmask is the last day of the month, then the cursor errornously
jumps to the month within the mask when pressing the '3' or in case of February the '2'.

Work-around: use the right arrow key.

When using a argument of a function or event it should also be able to be used for autoscripting as it is possible for r "normal" variables.

Enhancement 2: Autoscript should display the events and functions of an object when script start to declare a function/event using the "post" / "event" keyword

AppendRow -> a new empty row added
Add some data -> 1 row of data in dw (leave key col empty)

DW looks like this...

Key Col Data col2 Data col2
-------- ---------- ----------
[empty] 11111 11111

AppendRow -> a second empty row added under the previous new row
Add some data - 2 rows of data in dw, row 1 followed by row 2
DW looks like this...

Key Col Data col2 Data col2
-------- ---------- ----------
[empty] 11111 11111
[empty] 22222 22222

So far everything works as expected, now...

AppendRow -> First row disappears. What was added to the second row now appears as the first row
followed by 2 empty rows

Key Col Data col2 Data col2
-------- ---------- ----------
[empty] 22222 22222
[empty] [empty] [empty]
[empty] [empty] [empty]

First row has gone.

This problem is more obvious when using AppendRow but it is also reproduceable with InsertRow or even DeleteRow etc if used after the first 2 calls using AppendRow. The problem is with the 3rd trip back to the server after appending 2 new rows at the end of the dw without providing key values.

Workaround:
Add symbolic link to pbjag70.so:

lrwxrwxrwx 1 pbtest staff 16 Mar 7 16:02 pbjag70.so -> ./libpbjag70x.so

The key to making this work is the symbolic link. This can be created as follows while in the $JAGUAR/lib directory:

ln -s ./libpbjag70x.so pbjag70.so

First you must remove the existing file pbjag70.so if it exists and you should end up with the following output from a ls -l

lrwxrwxrwx 1 pbtest staff 16 Mar 7 16:02 pbjag70.so -> ./libpbjag70x.so

Using the following stored procedure:
create PROCEDURE sp_test_text ( @P1 VarChar(5000) ) AS SELECT DATALENGTH( @P1 ) Data_Len

Using the following script:
str = fill( "X", 256 )
DECLARE sp_test_text PROCEDURE FOR sp_test_text @P1 = :str ;
EXECUTE sp_test_text ;
FETCH sp_test_text INTO :ret_val ;

HTMLDW does not respect positioning of jpg images when using Netscape layers with Netscape 4.x (Datawindow.HTMLGen.NetscapeLayers = 'YES'). The jpgs all slide to the left edge of the page.
The same page does work in Netscape 6, which would suggest that this is a Netscape problem. However, given that there are so many 4.x in use, the HTMLDW could detect the version of the browser and either workaround the problem for 4.x or turn off Netscape layers property ??

"Certain functionality in a Netscape browser using absolute positioning may not be identical to the functionality available with Internet Explorer. For example, you cannot tab between DataWindow columns using a Netscape browser on an NT machine (although you can do this using a Netscape browser on a Solaris machine)."

This makes the htmldw 'readonly' when used with Netscape layers. No CR found for this so this is to track the problem.

Customer has old application that has been successfully migrated to PB 7.0. Full rebuild, regeneration and optimization do not result in any errors but do show warnings on obsolete functions.

On one particular window that opened fine up until build 9028 in all newer builds it crashes when trying to open from the library painter. The ancestor opens just fine.

For example, \\print-waterloo\pr-wat-04 shows the following:
Upper tray = 256
Lower Tray = 257

\\print-concord\pr-con6-09 shows:
Upper tray = 1
Lower tray = 2

The problem is that if the paper tray values are non standard (as for the pr-wat-04 printer) and not listed
in the documentation, customers are on there own to figure this info out.

Per PB Development:
This is not a PB bug. The people who write the printer drivers have the option of following the pre-defined tray-designations, or coming up with their own driver-defined tray designations.

Workaround: Use a third party utility to determine the tray numbers. One example:
http://www.powerwhizz.com/

Steps to reproduce:
1. Create a new UO
2. Select View-> Default -> default layout
3. close "Constuctor tab" script frame and then 'Declare Instance Variables' frame:
only 'Event list' and 'Function list' remain
-> Paste Function , Comment , Uncomment , Compile , etc icons still enabled.
Nothing happens if you click on them

Comments:

Keyboard Shortcuts.
If a shortcut key (or combination) is duplicated for another menu item then that same menu shortcut key will also appear as the shortcut for File -> Recent Connections -> Recent Connection 8 in the following circumstances...

1) One of the keyboard shortcuts is assigned to Window -> 'Close All'
2) After assigning the same shortcut a second time to another menu item the 'Keyboard shortcuts' dialog is closed

Although it is true that PB displays a warning to the user, if the user tries to go back and remove one of the dup shortcuts but leaves the 'Close All' shortcut then the dup shortcut for Recent Connection 8 does not go away.

Declare a instance variable: string is_a = "abc"

In a function use the variable: messageBox("test", is_a)

Save the object.

Change the name of the instance variable into is_B

Save the object. There is an error in the OUTPUT window. (Error C0015...Undefined variable is_a.)

Correct the error, and compile

messageBox("test", is_B).

Save the object. The output window still contains the previous error. It is confusing. I can save the object, but I see errors messages in the output window.

Per PB Engineering, not a bug:

Compiler errors go to the error window, not the output window. Error window errors ARE cleared when doing a compile.

CORBAObject my_corbaobj
JaguarORB my_orb
NamingContext my_nc
NameComponent the_name[]
Factory my_Factory
n_jagcomp my_jagcomp

my_orb = CREATE JaguarORB

// Enclose the name of the URL in single quotes

my_orb.init("ORBNameServiceURL='iiop://server1:9000'")
my_orb.Resolve_Initial_References("NameService", &
my_corbaobj)
my_corbaobj._narrow(my_nc, &
"omg.org/CosNaming/NamingContext")
the_name[1].id = "mypackage/n_jagcomp"
the_name[1].kind = ""

TRY // ************** ADD THIS LINE
my_corbaobj = my_nc.resolve(the_name)

my_corbaobj._narrow(my_Factory, &
"SessionManager/Factory")

my_corbaobj = my_Factory.create("jagadmin","") // ***** DELETE SEMI COLON FROM END OF LINE
my_corbaobj._narrow(my_jagcomp,
"mypackage/n_jagcomp") // ***** DELETE SEMI COLON FROM END OF LINE

my_jagcomp.getdata()

CATCH (Exception e) //**** ADD THIS AND ALL FOLLOWING LINES
MessageBox("Exception Raised!", e.getMessage())
END TRY

psstatic.db stores much of the data that populates the languages tab of the system tree. Request is to provide username and password of the database to that those inclined could extend the functionality here. According to engineering, there is also a utility program used to update the database with this information. That utility could be provided as well.

Version and Build #: 8.0 4019

16 bit/32 bit: 32

Database/Driver File/Version: N/A

Comments:

Step-By-Step Instructions:

1) Open the script painter to any script of any object

2) You'll need to resize the script view or increase the font size to force a horizontal scroll bar to appear

3) Place the cursor at the end of a long line - causing the scroll bar to be extended all the way to the right (and so the beginnings of lines do not show in the left part of the window)

4) Do a search (Edit->Find) for a few characters that appear at the very LEFT of the script, to force the script view to scroll back to the left. Note that it does scroll, but only to include the last character of the search string - it should scroll further to show the beginning of the selected text.

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

Workaround:
Instead of:
x /= 3
Code:
x = x / 3

OR: do an IsNull check before the statement and if the variable is Null, don't do the assignment.

Works : using MSS driver from PB, using PB Intersolv driver (PBSS613.dll ver 3.11), works in ODBCTest
Does not work from PB using either MS ODBC driver or PB Merant Driver (PBMSSS15.dll ver 3.60.00.13)

The example code follows:
Factory my_Factory
n_Bank_Account myaccount
long ll_result

ll_result = myconnect.lookup(my_Factory,"Bank/n_Bank_Account")
my_account = my_Factory.create()
my_account.withdraw(100.0)

This is incorrect, because the Factory.create() will return a CORBAObj, not a n_Bank_Account. If you try to make this assignment, you'll get a runtime error. The object returned by my_Factory.create() must be narrowed to the appropriate interface. I suggest rewriting the line my_account = my_Factory.create() to

my_Factory.create()._Narrow(my_account, "Bank/n_Bank_Account")

to fix this.
You can also look at "Examples for Resolve_Initial_References PowerScript function" for usage of _narrow.

The variable tab in the script painter will always open into the Instance Variable pane rather then the place where it was set last (global variables) for instance.

Request is to have it open to where the variable was last set.

Per Development, this is not a PB bug.
This statement already appears in the online Help and in the documentation for the Source editor:
You cannot open an object in the Source editor that is already open in a painter.

The issue here is with crosstab datawindows. A datastore is created and
retrieves data. A rowcount is called and returns 25 rows.
A getfullstate is issued. A second
datastore is created and a setfullstate populates the datastore with the blob
from getfullstate. When a rowcount is called it will intermittently return 0.

To work-around it, add to the script:
<window>.controlmenu = true

"thesessioninfo" type corbaobject passed by value
"timedout" type boolean passed by value
a return type of string and a throwable of "userabortedexception

you cannot save the object. PB does not display any errors. If you hit save, nothing happens. If you
hit nosave, then the function is not saved.

a) Enhancement Request for up to 18 decimal precision OR

b )Documentation change to reflect that precision is up to 15 only

The above errors can occur when using Dynamic SQL Format 4 using ODBC in PB7 but not in PB6.5.
Work-around is to use disablebind=1.

Update:
This issue was closed because it could no longer be reproduced with PB 7.0.3 EBF builds 10089 or greater.

PER DEVELOPMENT:

For MS SQL SERVER , the accuracy of datetime is 1/300 s ( about 3.33 ms), you can run the syntax in "Query Analyzer" to verify the result:

UPDATE ts_datetime SET wdt = {ts '2001-03-01 16:52:04.219'} WHERE id = '1 '

select * from ts_datetime

The following is extracted from "Books Online" of MS SQL SERVER :

datetime

Date and time data from January 1, 1753 through December 31, 9999, to an accuracy of one three-hundredth of a second (equivalent to 3.33 milliseconds or 0.00333 seconds). Values are rounded to increments of .000, .003, or .007 seconds, as shown in the table.

Example Rounded example

01/01/98 23:59:59.999 1998-01-02 00:00:00.000

01/01/98 23:59:59.995,

01/01/98 23:59:59.996,

01/01/98 23:59:59.997, or

01/01/98 23:59:59.998 1998-01-01 23:59:59.997

01/01/98 23:59:59.992,

01/01/98 23:59:59.993,

01/01/98 23:59:59.994 1998-01-01 23:59:59.993

01/01/98 23:59:59.990 or

01/01/98 23:59:59.991 1998-01-01 23:59:59.990

Microsoft� SQL Server? rejects all values it cannot recognize as dates between 1753 and 9999.

Workaround: use and map userevent pbm_dwnkey add the following script and remove the other userevents pbm_dwntabdownout and pbm_dwntabupout.
IF KeyDown(KeyDownArrow!) then
if ( getrow() = rowcount ()) THEN ll_row = this.InsertRow(0)
this.SetItem( ll_row, "cola" , "tabdownout" )
ScrollToRow( ll_row + 1)
end if
IF KeyDown(KeyupArrow!) then ...

From TSE analysis, they believe the problem is that the logic in JAG_ConnectionClient::CreateInstance within the PB code though requires a / in this lookup name. If one is not there, it attempts to create one by concatenating the connection object's application property to the value that is provided in that second argument to CreateInstance. If no application property is defined for the connection object, an SMI_MISSING_PROPERTY error is returned and the lookup is never performed.

The logic should be rewritten such that the requirement for the existence of a "/" within this second argument is eliminated. This appears the only thing preventing instantiation of an EJB via the connection object, as it's working now if the bind.naming property contains the "/".

Per development: the dialog appears because the user is allowed to change the function name at this point.

Per development: This will not be fixed. This cr could be reproduced only when you haven't changed the "DashInIdentifiers" property before. Because there isn't a item in pb.ini corresponding to it pb is first built. This bug exists in both PB70 & PB80 Debug Version. But in the installation version, there really exists a item named "DashInIdentifiers", so it works well. WORKAROUND: When PB7 & PB8 is in first run, just add item mentioned above to pb.ini manually or change this property in tab pages and sanve change.

Out Of Memory errors in pb 8, execute is successfull in pb 7 using OLE DB driver.

workaround: use unbounded arrays

You can do a File => Open File once the File Editor is open and open all files but as you get the option to open All Files(*.*) when you have a Web Target but not PB. For consistency please add this to the dropdown.

The file editor file open dialog appears tied to the target type. If the target is PB, I can only open PB objects. If the target is a web target, I can open up just about anything.

The File Editor should allow this option regardless of type of target. What if you want to open .ini\txt etc, while in a PB target?

RESOLUTION: The first part of the problem is fixed.

The second part of the problem which says that EJBHome name could be looked up by PB at runtime is not addressed as this will considerably slow down the lookup at runtime. PB generally does not use the Jaguar repository service at runtime. If uses the repository service at design time, to deploy components etc.

Workaround:
1.) Instead of using the PS object model based html page use the "normal"
java.CreateComponent server side script to create the html datawindows.
(this is in case you hare working with PowerSite etc.)

2.) Use the Mozilla/4.x (Netscape 4) setting in the painter or set it in
the server side script using dw.SetBrowser("Mozilla/4.x (");

3.) Then the tabbing will behave the same on IE and NS (but will have a
slightly different look and feel).

4.) For a test you could use the script from the example (here displays e.g..
the department list from the surfside video example two times).
In the datawindow painter set the Browser property to Netscape
settings, but when you leave this you can set it with the SetBrowser call
in the code (easier).

<HTML>
<HEAD>
<TITLE>Using Two Updateable WebDWs on Same Page</TITLE>

<SCRIPT>
/* Before submit of DeptEmp, include context for EmpDetail dw too */
function dw_depts_OnSubmit() {
dw_depts_submitForm.dw_emps_context.value = dw_emps.GetFullContext();
dw_depts_submitForm.dw_emps_action.value = "";
}

/* Before submit of EmpDetail, include context for DeptEmp dw too */
function dw_emps_OnSubmit() {
dw_emps_submitForm.dw_depts_context.value = dw_depts.GetFullContext();
dw_emps_submitForm.dw_depts_action.value = "";
}
</SCRIPT>

</HEAD>
<BODY>
This page contains example client-side and server-side script to handle two
updatable WebDW controls on the same page
<P>

<!--SCRIPT
/* Function to test whether page parameters are defined */
function f_getParam( envparam ) {
if( exists(document.value[envparam] ) ) {
return document.value[envparam]
}
return ""
}

/* Function to test for failed function calls */
function f_testError(retVal, method_called)
{
if (retVal < 0) {

document.writeln("<P><H3>Error calling: " + method_called + "<BR>" +
dw.GetLastErrorString() + "</H3><P>");
exit;
}
}

/* Function to create and initialize proxy for the WebDW component, then
generate output */
function f_createDW(arg_pbl, arg_dwo, arg_objectName, arg_retrieveArg,
arg_otherDW)
{
dw = java.CreateComponent("DataWindow/HTMLGenerator",
"iiop://kirchner-nt4:9000", "jagadmin", "" ,"DataWindow/HTMLGenerator")