PFC 7.0 Changes

Don't miss PowerTimes PFC Place article entitled PFC 7.0 Highlights, by Boris Gasin

PFC 7.0 basically contains:

* Many bug fixes
* Support for the new Windows controls in PB 7.0
* Obsolete code removed (Wintel-16 and Mac)
* No more local structure warnings

See Faxback#47870 entitled "PowerBuilder Foundation Class Library Support"

**********************************************************************
PowerBuilder Foundation Class Library Version 7.0
R E L E A S E N O T E S

Copyright © 1996-1999 Sybase, Inc. and its subsidiaries.
All rights reserved.

Last Updated: 1/21/99
**********************************************************************

Please take a few minutes to review this file for changes that
have been made to the libraries.

Contents of this file:
=========================================
CHANGED PFC OBJECTS
NEW PFC/EXTENSION OBJECTS
OBSOLETE PFC/EXTENSION OBJECTS
MIGRATION NOTES
BUGS FIXES
=========================================

**********************************************************************************
CHANGED PFC OBJECTS
**********************************************************************************
In Version 7.0 of PowerBuilder, object structures declared as instance variables
must be explicitly declared as private. The following PFC objects were using object
structures. In order to preserve the extendibility of PFC, these object structures
have been changed to nonvisual attribute classes, as follows:

Library pfcdwsrv.pbl:
=====================
Object: Obsolete Structure: Replacement Class:
-------------------------- ---------------------- --------------------------------
pfc_n_cst_dssrv_multitable os_updcharacteristics pfc_n_cst_dssrv_multitableattrib
pfc_n_cst_dwsrv_dropdownsearch os_columns pfc_n_cst_dwsrv_dropdownsearchattrib
pfc_n_cst_dwsrv_multitable os_updcharacteristics pfc_n_cst_dwsrv_multitableattrib
pfc_n_cst_dwsrv_querymode os_querymodeinfo pfc_n_cst_dwsrv_querymodeattrib
pfc_n_cst_dwsrv_resize os_resize pfc_n_cst_dwsrv_resizeattrib

Library pfcwnsrv.pbl:
=====================
Object: Obsolete Structure: Replacement Class:
-------------------------- ---------------------- --------------------------------
pfc_n_cst_winsrv_statusbar os_dwobjects pfc_n_cst_winsrv_statusbarattrib
pfc_n_cst_resize os_resize pfc_n_cst_resizeattrib
pfc_n_cst_winsrv_sheetmanager os_sheet pfc_n_cst_winsrv_sheetmanagerattrib
pfc_w_toolbars os_toolbar pfc_n_cst_toolbarattrib

Library pfcapsrv.pbl:
========================
Object: Obsolete Structure: Replacement Class:
-------------------------- ---------------------- --------------------------------
pfc_n_cst_dwcache os_cachelist pfc_n_cst_dwcacheattrib
pfc_n_cst_trregistration os_transentry pfc_n_cst_trregistrationattrib

Library pfcmain.pbl:
========================
Object: Obsolete Structure: Replacement Class:
-------------------------- ---------------------- --------------------------------
pfc_u_tv os_datasource pfc_n_cst_tvattrib

**********************************************************************************
NEW PFC/EXTENSION OBJECTS
**********************************************************************************
The new extension objects should be included in your customized extension PBLs.
For more information or help on retaining customizations to your extension levels
when upgrading to a new release of PFC, please refer to Powersoft Faxline # 44505.
If you are not using the 7.0 PFE, you should copy the new extension objects to your
customied PFE layer.

Library: PFC Object / Extension Object
============== =======================================================================
pfcdwsrv.pbl pfc_n_cst_dssrv_multitableattrib / n_cst_dssrv_multitableattrib
pfcwnsrv.pbl pfc_n_cst_winsrv_statusbarattrib / n_cst_winsrv_statusbarattrib
pfcapsrv.pbl pfc_n_cst_dwcacheattrib / n_cst_dwcacheattrib
pfcdwsrv.pbl pfc_n_cst_dwsrv_dropdownsearchattrib / n_cst_dwsrv_dropdownsearchattrib
pfcdwsrv.pbl pfc_n_cst_dwsrv_multitableattrib / n_cst_dwsrv_multitableattrib
pfcdwsrv.pbl pfc_n_cst_dwsrv_querymodeattrib / n_cst_dwsrv_querymodeattrib
pfcdwsrv.pbl pfc_n_cst_dwsrv_resizeattrib / n_cst_dwsrv_resizeattrib
pfcwnsrv.pbl pfc_n_cst_resizeattrib / n_cst_resizeattrib
pfcapsrv.pbl pfc_n_cst_trregistrationattrib / n_cst_trregistrationattrib
pfcwnsrv.pbl pfc_n_cst_winsrv_sheetmanagerattrib / n_cst_winsrv_sheetmanagerattrib
pfcmain.pbl pfc_n_cst_tvattrib / n_cst_tvattrib
pfcmain.pbl pfc_u_hpb / u_hpb
pfcmain.pbl pfc_u_vpb / u_vpb
pfcmain.pbl pfc_u_htb / u_htb
pfcmain.pbl pfc_u_vtb / u_vtb
pfcmain.pbl pfc_u_phl / u_phl
pfcmain.pbl pfc_u_sth / u_sth

**********************************************************************************
OBSOLETE PFC/EXTENSION OBJECTS
**********************************************************************************
The following objects have been obsoleted because the platforms are no longer
supported by PowerBuilder.

Library: Obsolete PFC Object / Extension Object
======== ==========================================================
pfcapsrv.pbl pfc_n_cst_filesrvwin16 / n_cst_filesrvwin16
pfc_n_cst_filesrvmac / n_cst_filesrvmac
pfc_n_cst_platformwin16 / n_cst_platformwin16
pfc_n_cst_platformmac / n_cst_platformmac

**********************************************************************************
MIGRATION NOTES
**********************************************************************************
If you have made references in your libraries to any of the structures that were
described in the changed objects section, you will need to change then datatype
for your references. ( Please refer to the Faxline Migration document if you need
further assistance migrating PFC from previous versions )

(Note: An additional obsolete variable using the new datatype BUT the
old istr_ variable name has been added to each of these objects for the
purpose of assisting migration. These variables will be removed in
a later release and should not be used.)

The following is a list of the references that have changed:

Object / Variable Changed to
================================= ===========================================
pfc_n_cst_dssrv_multitable:
os_updcharacteristics istr_newupdate n_cst_dssrv_multitableattrib inv_newupdate
------------------------------------------------------------------------------------------
pfc_n_cst_winsrv_statusbar:
os_dwobjects istr_dwobjects n_cst_winsrv_statusbarattrib inv_dwobjects
------------------------------------------------------------------------------------------
Object: pfc_w_toolbars:
os_toolbar istr_toolbar n_cst_toolbarattrib inv_toolbar
istr_toolbar.w_owner n_cst_toolbarattrib inv_toolbar.iw_owner
------------------------------------------------------------------------------------------
Object: pfc_n_cst_dwcache:
os_cachelist .istr_cachelist n_cst_dwcacheattrib inv_cachelist
------------------------------------------------------------------------------------------
Object: pfc_n_cst_dwsrv_dropdownsearch:
os_columns.istr_columns n_cst_dwsrv_dropdownsearchattrib inv_columns
------------------------------------------------------------------------------------------
Object: pfc_n_cst_dwsrv_multitable:
os_updcharacteristics.istr_newupdate n_cst_dwsrv_multitableattrib inv_newupdate
------------------------------------------------------------------------------------------
Object: pfc_n_cst_dwsrv_querymode:
os_querymodeinfo.istr_querymodeinfo n_cst_dwsrv_querymodeattrib inv_querymodeinfo
------------------------------------------------------------------------------------------
Object: pfc_n_cst_dwsrv_resize:
os_resize.istr_registered n_cst_dwsrv_resizeattrib inv_registered
------------------------------------------------------------------------------------------
Object: pfc_n_cst_resize:
os_resize.istr_registered n_cst_resizeattrib inv_registered
------------------------------------------------------------------------------------------
Object: pfc_n_cst_trregistration:
os_transentry.istr_trans n_cst_trregistrationattrib inv_trans
------------------------------------------------------------------------------------------
Object: pfc_n_cst_winsrv_sheetmanager:
os_sheet.istr_sheet n_cst_winsrv_sheetmanagerattrib inv_sheet
------------------------------------------------------------------------------------------
Object: pfc_u_tv:
os_datasource.istr_ds n_cst_tvattrib inv_ds
------------------------------------------------------------------------------------------

**********************************************************************************
BUGS FIXES
**********************************************************************************
============================================================================================
Object: d_calculator Drop Down Calculator
Fix: Changed button background color to buttonface.
============================================================================================
============================================================================================
Object: d_calendar Drop Down Calendar
Fix: Changed button background color to buttonface.
============================================================================================
============================================================================================
Object: f_setfilesrv File Services Create/Destroy
Fix: Removed logic to create Macintosh or 16-bit Windows file services
============================================================================================
============================================================================================
Object: f_setplatform Platform Services Create/Destroy
Fix: Removed logic to create Macintosh or 16-bit Windows platform services
============================================================================================
============================================================================================
Object: pfc_m_master PFC Master Menu
CR156985 Fix: The PFC "vcr" menu items were not layed out like a vcr.
Changed the order to "first, previous, next, and last"
============================================================================================
============================================================================================
Object: pfc_n_cst_datetime DateTime Service
CR169790 Method: of_lastdayofmonth
Fix: Removed a loop which relied on an invalid date.
Added an array containing the mumber of days in each month.

CR162134 Method: of_relativemonth
Fix: Removed a loop which determined the last day in month.
The loop was relying on the of_IsValid(date) function to
find an invalid date. In PB 5.0.03+ a date variable can
only contain a Null or a valid date.

CR188246 Method: of_relativeyear
Fix: Removed a loop which determined the last day in month.
The loop was relying on the of_IsValid(date) function to
find an invalid date. In PB 5.0.03+ a date variable can
only contain a Null or a valid date.
============================================================================================
============================================================================================
Object: pfc_n_cst_dropdown Drop Down Service
Method: of_position
Fix: Changed the li_rowsafterfirst to long (ll_rowsafterfirst).
============================================================================================
============================================================================================
Object: pfc_n_cst_dssrv Base Datastore Services
CR183729 Method: of_GetItem / of_GetItemAny
Fix: Change to treat computed columns like normal columns

CR162591 Method: of_GetItem
Fix: Don't LookUpDisplay for Original! values

CR184494 Method: of_GetItem
Fix: Formats containing expression will use default format

internal Method: of_BuildExpression
Fix: Added "char" datatype to case statement

internal Method: of_BuildComparison
Fix: Added "char" datatype to case statement
============================================================================================
============================================================================================
Object: pfc_n_cst_dssrv_multitable
internal Method: of_update
Fix: Local variable datatype changed from os_updcharacteristics to
n_cst_dssrv_multitableattrib type

internal Method: of_restoreupdatesettings
Fix: Argument datatype changed from os_updcharacteristics to
n_cst_dssrv_multitableattrib type

internal Method: of_storeupdatesettings
Fix: Argument datatype changed from os_updcharacteristics to
n_cst_dssrv_multitableattrib type
============================================================================================
============================================================================================
Object: pfc_n_cst_dssrv_report Datastore Report Service
CR159631 Method: of_SetColor
Fix: Allow for expressions in color values to be restored.

CR159631 Method: of_SetBorder
Fix: Allow for expressions in border values to be restored.
============================================================================================
============================================================================================
Object: pfc_n_cst_dwcache Caching service
CR171947 Method: of_refresh (string as_id)
Fix: Changed the li_rows variable to Long (ll_rows) to allow for > 32K Rows.
============================================================================================
============================================================================================
Object: pfc_n_cst_dwsrv Base DataWindow Services
CR183729 Method: of_GetItem / of_GetItemAny
Fix: Change to treat computed columns like normal columns

CR162591 Method: of_GetItem
Fix: Don't LookUpDisplay for Original! values

CR184494 Method: of_GetItem
Fix: Formats containing expression will use default format

internal Method: of_BuildExpression
Fix: Added "char" datatype to case statement

internal Method: of_BuildComparison
Fix: Added "char" datatype to case statement

============================================================================================
============================================================================================
Object: pfc_n_cst_dwsrv_dropdownsearch DataWindow Drop Down Search Service
CR162652 Method: pfc_itemfocuschanged
Fix: Due to an invalid test for ls_editstyle = 'dddw' the service was
unable to recover the child handle. Changed the test from
ls_editstyle <> 'dddw' to ls_editstyle = 'dddw'

internal Method: of_deleteitem
Fix: Local variable datatype changed from os_columns to
n_cst_dwsrv_dropdownsearchattrib type

internal Method: of_unregister
Fix: Local variable datatype changed from os_columns to
n_cst_dwsrv_dropdownsearchattrib type
============================================================================================
============================================================================================
Object: pfc_n_cst_dwsrv_find DataWindow Find Service
Method: of_find
Fix: Changed the datatype of li_rowfound to long to provide support for
> 32K rows
============================================================================================
============================================================================================
Object: pfc_n_cst_dwsrv_linkage Linkage Service
CR186541 Method: of_register
Fix: Allow non-column detail arguments to be registered. Arguments on the
on the master must be actual columns.
171023
============================================================================================
============================================================================================
Object: pfc_n_cst_dwsrv_multitable
internal Method: of_update
Fix: Local variable datatype changed from os_updcharacteristics to
n_cst_dwsrv_multitableattrib type

internal Method: of_restoreupdatesettings
Fix: Argument datatype changed from os_updcharacteristics to
n_cst_dwsrv_multitableattrib type

internal Method: of_storeupdatesettings
Fix: Argument datatype changed from os_updcharacteristics to
n_cst_dwsrv_multitableattrib type
============================================================================================
============================================================================================
Object: pfc_n_cst_dwsrv_querymode DataWindow QueryMode Service
CR171023 Method: of_SetEnabled
Fix: Trigger pfc_rowchanged event when QueryMode is turned off
============================================================================================
============================================================================================
Object: pfc_n_cst_dwsrv_report DataWindow Report Service
CR159631 Method: of_SetColor
Fix: Trigger pfc_rowchanged event when QueryMode is turned off
Fix: Allow for expressions in color values to be restored.

CR159631 Method: of_SetBorder
Fix: Allow for expressions in border values to be restored.
============================================================================================
============================================================================================
Object: pfc_n_cst_filesrv Base File Services
Method: of_deltree
Fix: Changed datatype of li_Cnt, li_Entries from int to long

Method: of_sortdirlist
Fix: Change datatypes from int to long
============================================================================================
============================================================================================
Object: pfc_n_cst_filesrvaix AIX File Services
CR155331 Fix: Changed external function declarations to library libkernel42.so

CR168832 Method: of_dirlist
Fix: Changed return datatype from int to long
============================================================================================
============================================================================================
Object: pfc_n_cst_filesrvhpux HPUX File Services
CR155331 Fix: Changed external function declarations to library libkernel42.sl

CR168832 Method: of_dirlist
Fix: Changed return datatype from int to long
============================================================================================
============================================================================================
Object: pfc_n_cst_filesrvsol2 Solaris File Services
CR155331 Fix: Changed external function declarations to library libkernel42.so

CR168832 Method: of_dirlist
Fix: Added, not previously implemented
============================================================================================
============================================================================================
Object: pfc_n_cst_filesrvunicode Unicode File Services
CR168832 Method: of_dirlist
Fix: Changed return datatype from int to long
============================================================================================
============================================================================================
Object: pfc_n_cst_filesrvwin32 WIN32 File Services
CR168832 Method: of_dirlist
Fix: Changed return datatype from int to long
============================================================================================
============================================================================================
Object: pfc_n_cst_luw Logical Unit of Work Service
CR187510 Method: of_GetType
Fix: Added support for new controls: vprogressbar, vtrackbar,
hprogressbar, htrackbar, picturehyperlink, statichyperlink.
============================================================================================
============================================================================================
Object: pfc_n_cst_lvsrv_datasource Listview Datasource Service
Method: of_retrieve
Fix: Changed the datatypes of local "row" related varibles from int to long.

CR156436 Method: of_InsertItem
Fix: Performance Improvements: Removed extraneous rowcounts, and ArrangeAll
============================================================================================
============================================================================================
Object: pfc_n_cst_lvsrv_sort Listview Sort Service
Method: pfc_columnclick event
Fix: Added "char" datatype to case statement

Method: pfc_sort event
Fix: Added "char" datatype to case statement
============================================================================================
============================================================================================
Object: pfc_n_cst_platform Base Platform Services
CR187249 Method: of_SetFindWindowClasses(new)
Fix: Allow specification of non-default class names.

CR188667 Method: of_GetActiveWindowBorder(new)
Fix: Refined calculation of border size, for statusbar service
============================================================================================
============================================================================================
Object: pfc_n_cst_platformaix AIX Platform Services
CR155331 Fix: Changed external function declarations to libraries libkernel42.so,
libuser42.so, libgdi42.so

CR187249 Method: of_FindWindow
Fix: Moved the class names into an instance array.
Allow for multiple class names.

CR188667 Method: of_GetActiveWindowBorder(new)
Fix: Refined calculation of border size, for statusbar service
============================================================================================
============================================================================================
Object: pfc_n_cst_platformhpux HPUX Platform Services
CR155331 Fix: Changed external function declarations to libraries libkernel42.sl,
libuser42.sl,libgdi42.sl

CR187249 Method: of_FindWindow
Fix: Moved the class names into an instance array.
Allow for multiple class names.

CR188667 Method: of_GetActiveWindowBorder(new)
Fix: Refined calculation of border size, for statusbar service
============================================================================================
============================================================================================
Object: pfc_n_cst_platformsol2 Solaris Platform Services
CR155331 Fix: Changed external function declarations to libraries libkernel42.so,
libuser42.so,libgdi42.so

CR187249 Method: of_FindWindow
Fix: Moved the class names into an instance array.
Allow for multiple class names.

CR172404 Method: of_GetComputerName
Fix: Datatype of size argument should be ulong

CR188667 Method: of_GetActiveWindowBorder(new)
Fix: Refined calculation of border size, for statusbar service
============================================================================================
============================================================================================
Object: pfc_n_cst_platformunicode Unicode Platform Services
CR187249 Method: of_FindWindow
Fix: Moved the class names into an instance array.
Allow for multiple class names.

CR188667 Method: of_GetActiveWindowBorder(new)
Fix: Refined calculation of border size, for statusbar service
============================================================================================
============================================================================================
Object: pfc_n_cst_platformwin32 WIN32 Platform Services
CR187249 Method: of_FindWindow
Fix: Moved the class names into an instance array.
Allow for multiple class names.

CR188667 Method: of_GetActiveWindowBorder(new)
Fix: Refined calculation of border size, for statusbar service
============================================================================================
============================================================================================
Object: pfc_n_cst_resize Resize Service
CR187510 Method: of_TypeOf
Fix: Added support for new controls: vprogressbar, vtrackbar,
hprogressbar, htrackbar, picturehyperlink, statichyperlink.
============================================================================================
============================================================================================
Object: pfc_n_cst_security Security Service
CR187510 Method: of_SetControlStatus
Fix: Added support for new controls: vprogressbar, vtrackbar,
hprogressbar, htrackbar, picturehyperlink, statichyperlink.
============================================================================================
============================================================================================
Object: pfc_n_cst_sql SQL Service
CR163154 Method: of_parse
Fix: Parse for UNION cannot include data from WHERE CLAUSE
============================================================================================
============================================================================================
Object: pfc_n_cst_string String Service
CR161099 Method: of_arraytostring ( as_source[], as_Delimiter, ab_processempty, as_ref_string )
Fix: Overloaded an existing of_arraytostring function to optionally allow
processing of empty string arguments.

CR159859 Method: of_WordCap
Fix: Don't capitalize the next character after apostrophe
============================================================================================
============================================================================================
Object: pfc_n_cst_trregistration
internal Method: of_unregister
Fix: Local variable datatype changed from os_transentry to
n_cst_trregistrationattrib type
============================================================================================
============================================================================================
Object: pfc_n_cst_tvsrv Base Treeview Service
CR183576 Method: of_SearchChild
Fix: Array Boundary error on empty tree. ============================================================================================
============================================================================================
Object: pfc_n_cst_tvsrv_levelsource Treeview Level Service
CR162735 Method: of_Retrieve
Fix: Fix call to of_BuildExpression, requires string argument
============================================================================================
============================================================================================
Object: pfc_n_cst_winsrv_preference Window Preference Service
CR159688 Method: of_restore ( ab_UseRegistry, as_KeyOrIni, as_IniSection )
Fix: Add logic to restore the window state to maximized or normal
PTrack Issue#: 474311
============================================================================================
============================================================================================
Object: pfc_n_cst_winsrv_sheetmanager
internal Method: of_setcurrentstate
Fix: Local variable datatype changed from os_sheet to
n_cst_winsrv_sheetmanagerattrib type
============================================================================================
============================================================================================
Object: pfc_n_cst_winsrv_statusbar Window StatusBar
CR182367 Method: of_createdwobject
CR160301 Fix: Updated datawindow syntax for current version

CR187510 Method: of_RestoreFocusPoint
Fix: Added support for new controls: vprogressbar, vtrackbar,
hprogressbar, htrackbar, picturehyperlink, statichyperlink.
============================================================================================
============================================================================================
Object: pfc_n_tr Transaction Service
CR155693 Method: of_SetUserIdAndPassword
Fix: Added new method to set UserID and DBPass attibutes
of transaction object for non-ODBC logons.

CR155693 Method: of_SetLogidAndPassword
Fix: Added new method to set LogID and LogPass attibutes
of transaction object for non-ODBC logons.
============================================================================================
============================================================================================
Object: pfc_u_calendar Drop Down Calendar
CR162134 Method: of_drawmonth
CR184373 Fix: Did not redraw date of 1/1/1900. Removed an invalid comparison
to date(‘50/50/1900’)). The comparison is no longer needed.
Post 5.0.03 PowerBuilder date type cannot contain an invalid date
with an exception of a null value.

CR162134 Method: of_setdate
CR184373 Fix: Add code to always redraw for date matching 1/1/1900 to allow date
display for January 1900. Previously the calendar did not redraw
since the initial value of the previous date was also 1/1/1900.

CR162134 Method: of_reset
CR184373 Fix: If the date is invalid set the calendar date to today's date.
============================================================================================
============================================================================================
Object: pfc_u_cbx PFC Checkbox Control
CR162743 Fix: Changed the text color from black to WndText.
============================================================================================
============================================================================================
Object: pfc_u_dw PFC DataWindow
CR162625 Method: clicked
Fix: Do not bypass the sort and rowselection processing on linkage failure.
Only do so when linkage specifically returns PREVENT_ACTION

CR162625 Method: pfc_addrow
Fix: Posted a new pfc_postinsertrow event

CR162625 Method: pfc_insertrow
Fix: Posted a new pfc_postinsertrow event

CR162625 Method: pfc_postinsertrow (new)
Fix: Add new event

CR171023 Method: pfc_insertrow, pfc_addrow, pfc_rowchanged, pfc_prerestorerow,
clicked, rowfocuschanged, itemfocuschanged, itemchanged, rowfocuschanging
Fix: Disable calls to linkage service while querymode is enabled
============================================================================================
============================================================================================
Object: pfc_u_em PFC Editmask Control
CR162743 Fix: Changed the text color from black to WndText and the
background color from white to WndBkgd.
============================================================================================
============================================================================================
Object: pfc_u_gr PFC Groupbox Control
CR162743 Fix: Changed the text color from black to WndText.
============================================================================================
============================================================================================
Object: pfc_u_lb PFC Listbox Control
CR162743 Fix: Changed the text color from black to WndText and the
background color from white to WndBkgd.
============================================================================================
============================================================================================
Object: pfc_u_lvs Service Listview Control
CR156436 Method: pfc_addall event
Fix: add Arrange(), deferred from pfc_n_cst_lvsrv_datasource.of_InsertItem
============================================================================================
============================================================================================
Object: pfc_u_mle PFC Multilineedit Control
CR162743 Fix: Changed the text color from black to WndText and the
background color from white to WndBkgd.
============================================================================================
============================================================================================
Object: pfc_u_rb PFC Radiobutton Control
CR162743 Fix: Changed the text color from black to WndText.
============================================================================================
============================================================================================
Object: pfc_u_sle PFC Singlelineedit Control
CR162743 Fix: Changed the text color from black to WndText and the
background color from white to WndBkgd.
============================================================================================
============================================================================================
Object: pfc_u_st PFC StaticText Control
CR162743 Fix: Changed the text color from black to WndText.
============================================================================================
============================================================================================
Object: pfc_u_tv Treeview Control
CR162228 Method: of_GetArgs
Fix: Changed the li_row datatype to long (ll_row).

CR162228 Method: of_DeleteItem
Fix: Changed the li_row datatype to long (ll_row).
============================================================================================
============================================================================================
Object: pfc_w_filterextended Extended Filter Dialog
internal Method: tab_1.tabpg_values.dw_values doubleclicked event
Fix: Added "char" datatype to case statement
============================================================================================
============================================================================================
Object: pfc_w_filtersimple Simple Filter Dialog
internal Method: of_BuildFilterString
Fix: Added "char" datatype to case statement
============================================================================================
============================================================================================
Object: pfc_w_find Find Service
CR163032 Method: pfc_default event
Fix: FindIndex starts with 1. Should be 0.
============================================================================================
============================================================================================
Object: pfc_w_master PFC Master Window
CR185691 Method: pfc_help event
Fix: If help type id is not specified open the top-level contents topic

CR158935 Method: resize event
Fix: Change to not resize when window is being restored from a minimized state
============================================================================================
============================================================================================
Object: pfc_w_sortdragdrop Sort Dialog
CR167821 Method: open event
Fix: Added Modify to left-hand datawindow so we can scroll to long
column names. Also added HScrollBar to datawindow
============================================================================================
============================================================================================
Object: pfc_w_statusbar Window StatusBar
CR182367 Method: of_getsystemsettings
CR160301 Fix: Changed calculation of border height

CR182367 Method: open
CR160301 Fix: Added InsertRow to StatusBar dw

CR187510 Method: of_RestoreFocusPoint
Fix: Added support for new controls: vprogressbar, vtrackbar,
hprogressbar, htrackbar, picturehyperlink, statichyperlink.
============================================================================================
============================================================================================
Object: pfc_w_zoom Print Zoom
CR159962 Method: open event
Fix: Allow for dynamically created datawindows
============================================================================================
============================================================================================
Object: all descendant autoinstantiate nonvisual objects
CR167852 Fix: Resave descendant autoinstante objects to force PB to
generate correct sourcecode
============================================================================================
============================================================================================

[Back to Top] [Sybase Downloads]

What's New in PB 7.0 ?

[How to fix AutoInstantiated Objects]

PB 7.0 FAQ: http://www.justpbinfo.com/techdocs/pb7faq.asp

Nice List of What's New: http://www.justpbinfo.com/techdocs/pb7feat.asp

PB 7.0 Release Press Release: http://dynamic.sybase.com/press_releases/press_releases/ExternalItem/0,1099,19300,00.html

News on PB 7.0: http://www.sybase.com/products/powerbuilder/
PB 7.0 Press Release: http://dynamic.sybase.com/press_releases/press_releases/ExternalItem/0,1099,14000,00.html

A View from the Vineyard - Enterprise Application Studio 3.0:

Release Notes for PowerBuilder[TM] Version 7.0 (Wintel)

(c) 1991-1999 Sybase, Inc. and its subsidiaries. All rights reserved.
Updated 03/25/99

************************************************************************
If you are viewing this file in Wordpad, please use the word-wrap option
************************************************************************

Thank you for choosing PowerBuilder as your development tool! Please read this document to learn about last minute updates to the product and documentation.

************************************************************************
BEFORE INSTALLING:
MAKE SURE THAT THE ADAPTIVE SERVER ANYWHERE DATABASE IS NOT RUNNING
************************************************************************

Section I: Support Statements
Section II: General Information
Section III: Known Issues

===============================
Section I: Support Statements
===============================

* Limited Win-OS2 support

PowerBuilder is built and tested on several standard operating systems: Microsoft Windows, Sun Solaris, HP-UX, and IBM AIX. While our development and testing process focuses on these operating systems as the primary development and deployment platforms, Sybase will make best attempts to resolve or work around any compatibility problems encountered while running PowerBuilder applications with IBM Win-OS2 provided the issue is reproducible under Microsoft Windows as well. As with any bug, it must be reproduced and documented so that it can be assigned a case number.

* Limited Exceed PC X-Server support

PowerBuilder is built and tested on several standard operating systems, Microsoft Windows, Sun Solaris, HP-UX, and IBM AIX. While our development and testing process focuses on these operating systems as the primary development and deployment platforms, Sybase will make best attempts to resolve or work around any compatibility problems specific to PowerBuilder applications encountered while running an Exceed v6.0 PC X-Server, provided it does not adversely affect cross-platform consistency or capabilities, including all Enterprise development and deployment aspects of PowerBuilder. Other PC X-Servers would be addressed only if the issue is reproducible on the platform's primary graphics head. As with any bug, it must be reproduced and documented so that it can be assigned a case number.

================================
Section II: General Information
================================

Beta or Release Candidate Installed
------------------------------------
If you have PowerBuilder 7.0 Beta or Release Candidate installed, please UNINSTALL these versions prior to installing PowerBuilder 7.0 GA. Also verify HKEY_CURRENT_USER \ Software \ Sybase \ PowerBuilder \ 7.0 is deleted from the registry prior to installing PowerBuilder 7.0 GA.

General Installation
--------------------
The DataWindow Web ActiveX will not be registered during the PowerBuilder 7.0 installation. To register the DataWindow Web ActiveX for use in development, you can use the following sample syntax at a command prompt:

<WINSYSDIR> regsvr32.exe <TargetDir>\Shared\PowerBuilder\psdwc70.dll

Installing on NT4.0
-------------------
You must have Administrator privileges to fully install this product on NT 4.0.

If you select to install the Window ActiveX under NT 4.0, the registration of the ActiveX may not succeed during normal installation. The files pbrx70.ocx and pbrxs70.ocx (secure version) are found in the WinSYS directory (e.g. Winnt\System32) and can be registered manually by the following command:

<WINSYSDIR> regsvr32.exe pbrx70.ocx {or}
<WINSYSDIR> regsvr32.exe pbrxs70.ocx

PowerBuilder Tutorial
---------------------
New rows will be added to the database each time you complete the tutorial. Certain steps in the tutorial will reference specific data in the database. If you plan to run the tutorial more than once, you will need to refresh the sample database using the following steps:
1) Shutdown the ASA database engine
2) Delete the easdemodb.log file, located in c:\Program Files\Sybase\Shared\PowerBuilder directory (or custom install directory)
3) Copy the original database file from the \Support directory on Install Disk 2 from \support\easdemodb.db to c:\Program Files\Sybase\Shared\PowerBuilder directory (or custom install directory).

PowerBuilder Help
-----------------
The hypertext links to online book topics have been replaced by links to HTML versions of the books. These links display a "question mark" icon. This icon launches the topic in the form in which it is installed on your machine: a compiled HTML Help file or an individual HTML file displayed in your system's preferred Web browser.

If Setup installs the HTML Help files, they will be displayed in an HTML Help viewer, which uses components of Internet Explorer.

If Setup installs the collections of individual HTML files on your machine, they will be displayed by the executable that is associated with the HTM file extension on your machine.

In most cases only one form of the HTML books will be installed, depending on whether Setup detects Internet Explorer 4.0 or higher on your machine. If Internet Explorer is already installed, Setup will install the HTML books in the form of compiled HTML Help files in a Typical installation, and default to the compiled HTML Help files in a Custom installation. If Setup does not detect Internet Explorer on your machine, it will not allow you to install the compiled HTML Help files, and will instead install the collections of individual HTML files that cover the same content.

PowerBuilder Documentation
--------------------------
The complete PowerBuilder documentation set is still provided in the form of DynaText online books and on the Web.

Dynatext requires ctl3d32.dll, which is located in the Support\Online books folder of the Install CD. If you receive an error message about ctl3d32.dll when you start Dynatext, copy ctl3d32.dll from the Support\Online books folder on Disk 2 of the Install CD to your Windows System folder (e.g. winnt\system32).

Page 738 of the hardcopy Application Techniques manual incorrectly states that the Adaptive Server Anywhere runtime engine is installed on your computer when you install the EAS Demo DB or the tutorial. The ASA Restricted Runtime program is a restricted standalone database engine that you can distribute with PowerBuilder and InfoMaker applications that use ASA. You can install the ASA Restricted Runtime program and supporting files on users' computers using the setup program available in the \Support directory on DISK 2.

Chapter 1 of Application Techniques incorrectly states that the EAS Demo DB is installed in the Demo DB directory. The EAS Demo DB is installed in the Sybase\Shared\PowerBuilder directory.

Distributed PowerBuilder and Web.PB
-----------------------------------
Sybase's strategic product plan for PowerBuilder includes use of the Sybase Enterprise Application Server (EA Server) in place of Distributed PowerBuilder for distributed and Web applications. No new functionality for Distributed PowerBuilder and Web.PB has been added to this release.

Please note that version 7.0 will be the final release of PowerBuilder which will incorporate Distributed PowerBuilder functionality. We strongly recommend current Distributed PowerBuilder applications are converted to EA Server applications using PowerBuilder 7.0, and that all new Web and distributed applications take advantage of the distributed capabilities of EA Server.

More information about how Sybase can support your transition from Distributed PowerBuilder to EA Server can be found at the Sybase Developer Network Web site at http://sdn.sybase.com/sdn.

PowerBuilder Companion Product Source Availability
--------------------------------------------------
Some companion products have become obsolete or incorporated into PowerBuilder 7.0, and have not been provided with PowerBuilder. We have made available for download the complete source code for the following companion products and utilities:

Previously Shipped with PB 6.5
------------------------------
1. Advanced Developers Toolkit
A. Advanced PowerBuilder Utilities
- Cross Reference
- DataWindow Extended Attribute Synchronizer (DWEAS)
- DataWindow SQL Verifier
- Object Search
- PowerBuilder Extended Attribute Reporter (PEAR)
- Stored Procedure Update
B. PowerBuilder Library for Lotus Notes
C. Synchronizer

2. Distributed PowerBuilder Examples
3. Distributed PowerBuilder Name Server Example
4. Web.PB class library and examples
5. PowerJ Web.PB to Java Sample

Previously Shipped with PB 6.0
------------------------------
6. Picture Viewer

The source code provided can be found on the Sybase Developer Network Web site at http://sdn.sybase.com/sdn. Given their general availability, Sybase will not support or maintain the products listed above.

Using Arrays and NULL values with Jaguar Components
---------------------------------------------------
For PowerBuilder user objects implemented as Jaguar components that declare arrays with a 'TO' clause, for example Int ar1[5 TO 10], the proxy generated for this user object will only represent a single value and not the range, in this example Int ar1[6], with [6] representing the number of array elements. The rules of the IDL language mapping convert the translation of the bounds information into a single value instead of a range. Therefore, a PowerBuilder component using [x TO y] will require using a proxy with a single [x] value as an argument.

Support for NULL values is implemented for simple datatypes only. If method arguments are structures or arrays, then null values for individual elements will not be maintained.

PowerBuilder connectivity to Jaguar Components
----------------------------------------------
This feature is complete with the following known issues:

Passing enums is not supported.

The SSLCallBack is not working properly. In order to use SSL, you MUST configure your SSL connection so that the callback object is not required.

Using Proxies for Jaguar Components
-----------------------------------
When you generate a proxy for a non-PowerBuilder Jaguar component, the name of any methods in the component that use a PowerBuilder reserved word will be changed. The name exposed will be the method name with an underscore character prefix. So if the component has a method with name "destroy", this method will be exposed as "_destroy".

Jaguar Service Components
-------------------------
PB NVO(s) deployed to Jaguar server as "Service Components" using Jaguar Component Deployment project are not added to the Jaguar server's list of services. These new service component(s) need to be added to the list by hand. Please refer to Chapter 10 (Creating Service Component) section "Install the Component as a Jaguar Service" in the Jaguar Programmer's Guide for information on how to add a new component to the list of services.

PowerBuilder Language
---------------------
Two new system functions, SetLibraryList and GetLibraryList, were added after the PowerBuilder documentation was complete. GetLibraryList will return the current library list as a semicolon-separated string. SetLibraryList is identical to the application function SetLibraryList. It was added as a system function to make it consistent with GetLibraryList and so you did not have to prefix the call with the application object.

Two new overloaded versions of the Start() function have been added to the Pipeline object. These are the same as the existing Start( ) functions, but they take a datastore argument in place of the datawindow argument. The main reason for this was to allow for use of the pipeline object within Jaguar where the DataWindow is not supported.

Non-Visual Object List View
---------------------------
The Non-Visual Object List view is a list of nonvisual objects that have been inserted in an Application object, Window, or User Object. If you happen to close the Non-Visual Object List View, you will not be able to insert a new object into an application, window, or user object. The Non-Visual Object List View needs to be open in order to select an object from the Insert>Object menu of the painter.

COM Generator
-------------
The COM generator has been changed to optionally allow the passing of reference arguments as variants for type-unsafe environments like ASP.

HTML Generation
---------------
In PB 6.5, you could embed HTML as a data value in a column. This worked because we were not escaping special characters properly. Therefore, if the data value contained <, > or &, the rendering of the HTML would get corrupted. This was a bug and it has been fixed. This fix breaks the ability to embed HTML as a data value in a column. Since we believe that it is important to have the capability to embed HTML data, a new property will be added to text, compute and column objects in a future release to enable this.

Database Information
--------------------
For Extended Attributes maintenance in the Database Painter, selecting the Edit Style properties will prompt a modal dialog instead of displaying the properties in the Object Details View. Validation Rules and Display Format properties can be modified from the Object Details View of the Database Painter.

Adaptive Server Anywhere 6.0.1 is available for use with PowerBuilder 7.0 and can be installed separately from the Install CD.

JDBC
----
In order to use either the Sun (PBJDS70) or Microsoft (PBJDM70) JDBC drivers with PowerBuilder 7.0, you need to update the CLASSPATH environment variable to include classes.zip file. This file can be found under the installed folder \Program Files\Sybase\Shared\PowerBuilder, assuming all default paths were selected during the install.

For example:
If you wish to use the JDS driver(Sun) with jConnect JDBC driver, then CLASSPATH will require
<jdk 1.1x classes.zip> + <jConnect classes> + <PB JDBC classes>

If you wish to use JDM driver (Microsoft) with jConnect JDBC driver then CLASSPATH will require
<jConnect classes> + <PB JDBC classes>

Note: JDK classes are not required for the Microsoft Java VM as they can be found using the system path.

OLE DB
------
This release includes the Microsoft Data Access Components (MDAC) 2.0, which includes ODBC version 3.5 and OLE DB version 2.0. MDAC 2.0 is required in order to use the PowerBuilder OLE DB interface. The installer, MDAC_MIN.EXE, can be found in the \Support directory on the Install CD Disk 2.

The PowerBuilder OLE DB interface (PBOLE70.DLL) can be installed during the Custom install. The primary OLE DB providers extensively tested with PowerBuilder are SQLOLEDB for use with MS SQL Server 7.0 and Intersolv Sybase OLE DB. The Intersolv OLE DB providers will be installed when the OLE DB interface is selected during the custom install. The Microsoft providers, such as SQLOLEDB, will be installed when MDAC_MIN.EXE is run. The following is a list of all the Intersolv and Microsoft OLE DB providers shipped with PowerBuilder.

OLE DB Provider Database Installed from
=============== ======== ==============
SQLOLEDB MS SQL Server 7.0 MDAC_MIN.EXE
MSDASQL ODBC MDAC_MIN.EXE
Intersolv Informix7 Informix 7.x OLE DB custom install
Intersolv Informix9 Informix 9.x OLE DB custom install
Intersolv Oracle7 Oracle 7.x OLE DB custom install
Intersolv Oracle8 Oracle 8.x OLE DB custom install
Intersolv Sybase Sybase OLE DB custom install

Use the Intersolv OLE DB Administrator, PBADMIN.EXE, to create data sources for the Intersolv OLE DB Providers. This file can be found under the installed folder \Program Files\Sybase\Shared\IntersolvOLEDB, assuming all default paths were selected during the install.

OLE DB Documentation
--------------------
The OLE DB documentation incorrectly states that many OLE DB vendors ship data providers that include the necessary client software. OLE DB vendors DO NOT ship the necessary client software. To determine client software requirements, see your database vendor's documentation.

The OLE DB documentation currently states that PB includes INTERSOLV's DataDirect Reflector to support connections to non-SQL-based data. Reflector is NOT being shipped with PowerBuilder 7.0 GA.

The OLE DB documentation incorrectly states that both PowerBuilder 7.0 Enterprise and Professional support OLE DB. The correct statement is only PowerBuilder 7.0 Enterprise provides support for OLE DB. PB Professional and Desktop editions of PowerBuilder 7.0 do not include support for OLE DB.

ODBC
----
The following are the ODBC 3.5 drivers fully tested with PowerBuilder 7.0 and may be selected during a Custom install:

PB INTERSOLV OEM 3.11 32-BIT Btrieve (*.dta)
PB INTERSOLV OEM 3.11 32-BIT DB2
PB INTERSOLV OEM 3.11 32-BIT dBASEFile (*.dbf)
PB INTERSOLV OEM 3.11 32-BIT ExcelWorkbook (*.xls)
PB INTERSOLV OEM 3.11 32-BIT ParadoxFile (*.db)
PB INTERSOLV OEM 3.11 32-BIT TextFile (*.*)

Other INTERSOLV 3.11 ODBC drivers now available during a Custom install:
INFORMIX 9
OpenIngres 2.0
Oracle 7
Oracle 8
PROGRESS
SQLBase
Microsoft SQL Server
Sybase SQL Server

Available Database Interfaces and Install Options
-------------------------------------------------
Informix 9.x Typical
MS SQL Server 6.x(MSS) Typical
Oracle 8.0.4 and 8.0.5 (O84) Typical
Sybase Adaptive
Server Enterprise(SYC) Typical
Direct Connect (DIR) Typical

Informix 7.x Custom only
Oracle 7.3 Custom only
Oracle 8.0 (OR8) Custom only
ASE Jaguar (SYJ) Custom only
JDBC (Sun and Microsoft) Custom only
OLE DB (see above) Custom only
ODBC (see above) Custom only

With PB 7.0, the Sybase interface will look for a stored procedure called sp_pbtables70. Unless each Adaptive Server Enterprise site runs the scripts to create the 7.0 version of these stored procedures, features in the database painter will fail. For Adaptive Server Enterprise, these scripts are called pbsyc.sql and pbsyc2.sql and can be found in the \Server directory on the install CD.

Please refer to the PB 7.0 documentation, Chapter 5 of Connecting to Your Database, under the topic "Installing PowerBuilder Stored Procedures in Adaptive Server Enterprise Databases" for more information.

Source Control
--------------
Source Control Checkout does not work with MKS Source Integrity 7.3 or earlier. MKS Source Integrity will not be able to properly checkout PowerBuilder 7.0 objects without using the latest version of MKS SI. The fix was made in MKS SI 7.3e Integrations SP1.

ORCA for PowerBuilder 7.0
-------------------------
The files and documentation for this functionality is provided to Sybase partners and is made available on Sybase's Partner.net web site. Please refer to http://www.sybase.com/partners/ for access to Partner.net or becoming a Sybase partner.

Deployment Information
----------------------
Complete application deployment information has been made available on the Sybase Developer Network website. Please refer to http://sdn.sybase.com/sdn/ for more information.

Introducing the HTML DataWindow
--------------------------------
Have you ever wished for DataWindow functionality without having PowerBuilder DLL's on the client? PowerBuilder 7.0 introduces a pure HTML DataWindow control that provides a complete thin solution for accessing your data from a browser client. Please refer to the documentation or run the sample provided for more details.

For ease of scripting, you may use the PowerSite HTML DataWindow DTC included during the PowerSite install.

PowerBuilder Foundation Class Library (PFC)
-------------------------------------------
Numerous fixes for reported issues were completed and support for new Windows controls were added. Please refer to the PFC readme.txt for more information regarding the PowerBuilder 7.0 PFC changes.

PowerBuilder Code Examples
--------------------------
The Code Examples pipeline objects point to Powersoft Demo DB V6. They should point to EAS Demo DB V3.

ASA and ASIQ Installed Together
-------------------------------
When Adaptive Server Anywhere (ASA) and Adaptive Server IQ (ASIQ) are installed on the same computer, you may run into the following error: "Port DLL build number mismatch". For more information regarding this error, please see the ASA readme.txt found in the ASAnywhere6 directory on the Install CD (section 2.6 Interoperability between ASA and ASIQ)

Microsoft COMCTL32.DLL
----------------------
The Microsoft COMCTL32.DLL has been updated to address known Year 2000 issues on the Windows 95, Windows 98 and Windows NT 4 platforms.

It is highly recommended to have installed COMCTL32.DLL version 4.72 or greater on your system, otherwise you may experience general instability issues while using PowerBuilder 7.0. We have provided the Internet Explorer 4.01 SP1 Setup, which includes an update to COMCTL32.DLL, located in \Support\Internet Explorer directory on Disk 2 of the Install CD.
Optionally, to specifically update COMCTL32.DLL, you may use the self-extracting archive (401COMUPD.EXE) found in the \Support\COMCTL32 directory on Disk 2 of the Install CD.

Microsoft DLL Versions
----------------------
Because of ongoing Microsoft enhancements, different versions of COMCTL32.DLL and SHELL32.DLL implement different features. The following table outlines the different DLL versions, and the distribution platform.

Version Distribution platform
4.00 Microsoft® Windows® 95/Windows NT® 4.0
4.70 Microsoft® Internet Explorer 3.x
4.71 Microsoft® Internet Explorer 4.0
4.72 Microsoft® Internet Explorer 4.01
5.00 Microsoft® Windows 2000 and Internet Explorer 5.0

Note: With the exception of Version 5.0, The Microsoft Shell and Common Control version should be the same. Do Not install the COMCTL32.DLL manually. Please run the Internet Explorer 4.01 SP1 Setup provided or 401COMUPD.EXE both available from the \Support directory on Disk 2 of the Install CD.

For more information about the self-extracting archive, please visit http://msdn.microsoft.com/developer/downloads/files/40comupd.htm

========================
Secion III: Known Issues
========================

OLE DB Interface
----------------

1. PowerBuilder Catalog Tables
All providers except for SQLOLEDB do not support the ITableDefinition interface which is necessary to create tables. For this reason, if you are connecting to a database, which does not have the PowerBuilder Catalog tables, the OLE DB interface will try to create them. If the ITableDefinition is not supported for the specific provider, you will get the following error message upon connecting to the database:

"The current provider does not support the ITableDefinition interface which is used to create/drop/alter tables" followed by "Catalog Tables could not be created and are not available for use".

To work around this problem, simply connect with the PowerBuilder native drivers first to create the catalog tables and then connect with the OLE DB interface.

2. Data type mapping issues
Since OLE DB is not returning the data type name for the specific database but rather the generic OLE DB data type name, there are data type mapping issues. This problem is apparent in areas that display the data type of a column such as the Database Painter, Pipeline painter and Datawindow Painter.

3. Export table syntax is not working properly

DataWindow Stored Procedure Update
----------------------------------
CR 192666 The syntax generated for datawindows with stored procedure update has a leading space before the name of the method. This is causing some drivers (MSS, for example) not to recognize the stored procedure name. When you try to use an Update/Insert/Delete procedure, you get a message that the stored procedure < procedurename> is not found. To work around this, export the datawindow, remove the leading space from method syntax such as: delete.method=" dbo.sp_del_dept", and reimport the datawindow.

Enterprise Application Server
-----------------------------
CR 193120 A method which has a structure as one of its arguments generates an error when attempting to deploy it to a Jaguar Server. This is a known problem that applies ONLY to methods which have an internal UO structure. The simple workaround is to use a global structure rather than an internally defined User Object structure.

CR 193579 IsCallerInRole() will work correctly from a MTS component, but will always return FALSE from a Jaguar component.

**********************************************************************
(c) 1991-1999 Sybase, Inc. and its subsidiaries. All rights reserved. Sybase, Inc. and its subsidiaries ("Sybase") claim copyright in this Program and documentation as an unpublished work, versions of which were first licensed on the date indicated in the foregoing notice. Claim of copyright does not imply waiver of Sybase's other rights. See Notice of Proprietary Rights.

NOTICE OF PROPRIETARY RIGHTS
This computer program and documentation are confidential trade secrets and the property of Sybase, Inc. and its subsidiaries. Use, examination, reproduction, copying, disassembly, decompilation, transfer and/or disclosure to others, in whole or in part, are strictly prohibited except with the express prior written consent of Sybase, Inc. and its subsidiaries.

[Back to Top] [Sybase Downloads]