ProvideX v7.50 & v8.00 Overview

1. ProvideX v7.50 & v8.00 Overview Presented by: Brett Condy

2. Presentation Outline • Overview • V7.50 & V8.00 Enhancements • Core language Features & Enhancements • NOMADS Enhancements • Data Dictionary Improvements • Report Writer Enhancements • ODBC Version 4.20 • ProvideX Plug-in for Eclipse

3. Alternate Keys on *Memory* Files OPEN (ch)"*Memory*;KEYDEF=<key_def>" • Similar to regular multi-keyed files • Faster than standard *Memory* files • KEYED file access only • Original *Memory* files still available if INDEXED access is required

4. RENAME CONTROL RENAME CONTROL old TO new [HIDE|SHOW|RESTORE] RENAME CONTROL FromTo$ [HIDE|SHOW|RESTORE] • Changes CTL value for a control • Allows Hiding, Showing or Restoring visual aspect of a control • Used in NOMADS to allow preserving a control's contents • Can rename multiple controls with a single instruction resulting in a single packet when using WindX

5. GET_FILE_BOX DIRECTORY GET_FILE_BOX DIRECTORY path$, dir$, title$, root$ • Allows selection of a Directory / Folder • Ability to limit root directory to search

6. GET_FILE_BOX READ LIST GET_FILE_BOX READ LIST path$, dir$, title$, ext_list$, def_ext$ • Allows selection of multiple files • Returns directory name plus a SEP & a comma separated list of selected files

7. Notification / System Tray Control • Created by specifying OPT="Y" on a BUTTON, CHECK_BOX or TRISTATE_BOX • Supports up to three Icons • 'Tip$ or ,TIP= specifies tip text • 'Msg$ or ,MSG= identifies Balloon text with an optional Icon • Balloon activated with BUTTON ON • 'MenuCTL or ,MNU= provides right-click menu support • 'Value=1-3 identifies visible Icon

8. Debugging Enhancements • Support for Breakpoint and Watch Value windows in a WindX environment • New 'Host Breakpoints' and 'Host Watch' options within Debugging Environment • New 'OPTION'("DebugWindow", Option$) • Allows Debug Windows to be controlled within the application • For example: PRINT 'OPTION'("DebugWindow", "Trace Enable"), SETTRACE PRINT "Add an entry to Trace window" PRINT 'OPTION'("DebugWindow", "Copy"), CLIP_BOARD READ ContentsOfTraceWindow$

9. Debugging Enhancements (Cont'd) • New Find option in Program Trace Debug Window • Case sensitive option • Search Forward or Backward • Single Step through Directives • Single or multiple directives • LIST highlights next directive

10. Debugging Enhancements (Cont'd) • Enhanced Timed Trace • 'TT' System Parameter options include: • Prefix line with full program name • Suppress program statement (leaving only line #) • Prefix line with Stack Depth • Integrated Debugging within the ProvideX Plug-in for Eclipse

11. Global option for GUI controls • New ,OPT="G" for all GUI controls • Allows a control to remain active when focus is on a different window • Previously available for BUTTONs only • Used in redesign of NOMADS interface

12. Multi_line Auto Resize on Focus • Size of MULTI_LINE automatically changes when it receives or loses focus • Controlled by two new properties: • 'OnFocusCols and 'OnFocusLines • Also supported within NOMADS

13. Vista Compatibility • All EXE and DLL's are digitally signed • Manifest built directly into EXE's and DLL's • Pvxwin32 is manifested to execute "asInvoker" if Admin privileges are necessary • Pvxwactv is manifested as "requireAdministrator" • No Vista File or Registry Virtualization for ProvideX Apps • Due to manifest being included in EXE's and DLL's

14. Vista Compatibility • Activation file can be stored outside of Program Files directory for UAC compliancy • INI search rules updated • New INVOKE CONTROL allows invocation of external program to "Run as Administrator" • INVOKE HIDE will launch without Admin rights but will auto-elevate to "Run as Administrator" if OS indicates elevation is required • Improved '4D' Look and Feel for Vista

15. Increased File & Command Line Lengths • File names increased to 511 characters • Command Line lengths increased to 32K for compatible Operating Systems • ARG( ) function extended: • ARG(-1) - INI file in use • Returns "" on UNIX/Linux systems • ARG(-2) – ProvideX LIB directory name • ARG(-3) – Activation Key directory name • ARG(-4) – Command line used to start ProvideX

16. COM / OLE Improvements • New ;Finalize={Method} for object clean up • E.g. Def Object w,"Word.Application;Finalize=Quit" • New 'PvxDoVerb() method for accessing common functions such as Open, Hide & Show • New [GetObject] identifier allows binding to running instance of a named object • New [Picture] identifier for IPicture objects • New 'PvxConstants property and internal *Constants object for loading / exposing enumerated type library constants • New 'PvxForEach property and internal iterator object type *ForEach for collection handling • Includes 'Next(), 'Reset() and 'Data[$]

17. COM / OLE Improvements • *Variant enhanced to handle string data that should not be converted from Ansi to Unicode • New LenB$ and ValB$ properties and AddB() method • Extended Invocation Hints .GetB and .CallB • *VarArray can now create Safe Arrays of any OLE data type • ArrayType$, OleArray, PassByRef • CreateByteArray(), CreateEx(), GetDataEx() • Ability to DROP OBJECT of an Event object within its own Event Handler • Extended list returned by '* when object does not expose type info

18. Automated QA Integration • Allows external QA products / Automation Tools to interact with ProvideX based Applications • Utilizes Microsoft Active Accessibility (MSAA) Interface • Graphical control names are identified using ,OWN= syntax • Integrated into NOMADS • Initial implementation using MFC for Compuware's TestPartner product • See Improving QA with Automation Tools Presentation

19. GRID Improvements • New Grid properties: • 'AutoTrack • Allows smooth scrolling • 'NUL$ • Same functionality as MULTI_LINE'NUL$ • 'Sort • Allows sorting ascending or descending by column number or name • 'SortOnHdrClick • Enable or Disable Sorting via column header • Also supported with List View control • 'SortStyle • Allows Excel-like sorting

20. Graphical / Windows only Changes • Improved performance for Standard and Formatted List Boxes • New properties for Tree View controls • 'LineColour$ / 'LineColor$ • 'TextColour$ / 'TextColor$ • Ability to override Mouse Cursor • INI setting: Cursor#=<value> • Cursors #5 & #6 (Hand & Hand in crossed circle) updated to more closely resemble standard Windows cursors

21. Graphical / Windows-only Changes • New 'AW' System Parameter • Alternate WINPRT_SETUP LIST • Limits list of Printers returned in Terminal Services environment to current user • Added Ability to override the standard Cut / Copy / Paste / Delete POPUP_MENU options • DEF MSG(136)=”Supprimer,Coller,Copier,Couper,”

22. UNIX / Linux Changes • High Resolution Timer • Same precision as ProvideX for Windows • FacetWin recognition • Allows multiple FacetWin sessions to occupy a single ProvideX user slot • Improved interface to pvxactv • More user friendly • Extended information using TCB( ) Result$ = TCB( Keyword$, Argument$) Where: Keyword$ includes: OS_GetUserUID, OS_GetUserGID, OS_GetUserName, OS_GetUserHome and OS_GetUserShell

23. Pipe Processing Improvements • Wait for Pipe on Close • New 'WP' System Parameter • Determines whether to wait until the child process completes • Ability to specify a negative SIZ= • Allows reading up to a specified number of characters

24. [ODB], [DB2] & [OCI] Improvements • [ODB] Support now available on selected UNIX/Linux platforms • Support for CONNECT= option on UNIX/Linux for [ODB] and [DB2] • Ability to specify DIR=-1, 0 or 1 for [ODB] files • Ability to use Prepared Statements when the key contains a date • Support for FACTS date format • Added Date Format of KKMMDD where K0 = 2000

25. TCP/IP Improvements • Improved Error Reporting • More error codes trapped and MSG(-1) set more often • Improved Performance when using SSL in the Windows environment

26. Miscellaneous Changes • Keyword Help for *IT • Directives, Functions, Mnemonics, Properties, System Variables & Parameters • ZLib Compression for WindX • Controlled with the 'WZ' System Parameter • SELECT Key Segment Padding SELECT * FROM File$ BEGIN A$:B$ END C$:D$ • Pads A$ and C$ to their defined length • DEF UID Improvements • Allows changing UID / WHO values for the current session in Windows environment

27. NOMADS v7.50 Enhancements • Preserve Folder Controls • Controls no longer destroyed and redrawn when switching folder tabs • Improves overall performance by not having to reload contents of controls • File Maintenance Objects • Supports Generic or Custom Objects

28. NOMADS v7.50 Enhancements • Embedded Panels Enhancements • Panel Header Logic and Default Program carried forward • Library Default Menu Colours • Ability to set Text Background & Left Edge Colours

29. NOMADS v8.00 Enhancements • New Panel Designer Interface • New Look and Feel • Completely Redesigned • New Properties Window • Grouped by Categories • Category Display Order can be changed

30. Toolbar Your Panel Controls Toolbox Properties Window NOMADS v8.00 EnhancementsNew Designer Interface

31. NOMADS v8.00 Enhancements • New Format Definition for Grids and List boxes

32. NOMADS v8.00 Enhancements • Updated Designer Utilities • Bulk Edit • Drag and Drop • Dependency Definition • New Control Properties • QA Automation Support • See NOMADS v7.5 and v8.0 Enhancements Presentation

33. Data Dictionary Enhancements • V7.50 • Element Name Restriction • V8.00 • Dictionary Print Utility can now output reports to PDF and the ProvideX Viewer • New command line shortcut ‘DD’ to invoke Data Dictionary Maintenance >DD Invoke DD Maintenance >DD TableName Invoke DD Maintenance and load the table definition • Eclipse Integration

34. Report Writer Enhancements Version 7.50 Enhancements • Field descriptions • Easy Row/Column selection • Deleting report definitions • Sort order case sensitivity • Calculated fields • Locked footers • Filler line • Enhanced font • User-interface for parameters

35. Report Writer Enhancements Version 8.00 Enhancements • File History • Scale-to-fit • Update tracking • Bulk edit cell attributes • Row/column adjustment • Report Header and Trailer • Access to Views Maintenance • Enhanced menus and cell selection • Designer options • Paper size option • Translation fields • See Report Writer v7.5 and v8.0 Enhancements Presentation

36. ODBC Version 4.20 • Views Support on UNIX / Linux • Improved performance for C/S • ZLib compression support • For ProvideX data files • With Client/Server Communication • File Server for SCO OpenServer 6 • Microsoft Windows Vista compatibility

37. ProvideX Plug-in for Eclipse

38. ProvideX Plug-in for Eclipse • Eclipse is an open source community focused on building a development platform • Brief background information • Originally created by IBM • Borland, IBM, MERANT, QNX Software Systems, Rational Software, Red Hat, SuSE, TogetherSoft and Webgain formed the initial eclipse.org Board of Stewards in November 2001 • Eclipse today • Now more then 150 member consortium • See: http://www.eclipse.org

39. ProvideX Plug-in for Eclipse • Eclipse Framework provides: • Integrated Development Environment • Source Code Management • Extensibility using Plug-ins • Roughly 1,000 Plug-ins available on Eclipse Central • 43 for Team Development including: • CVS, Sub-version and MKS • Other categories include: • Documentation (14), Editors (51), Testing and Automation (55), UML (33), XML (18) and many more • See: http://eclipseplugincentral.com/

40. ProvideX Plug-in for Eclipse • The ProvideX Plug-in adds: • C style comments • Include Files • EditorFeatures include: • Content Assist • Shows a drop down list of available directives, functions and mnemonics as you are typing • Integrated Online Help / Language Reference • Bracket Matching • Code Folding • Coloured Syntax

41. ProvideX Plug-in for Eclipse • NOMADS – Data Dictionary • Embedded data dictionary information for a file • Access to Dictionary Maintenance for file from the view

42. ProvideX Plug-in for Eclipse • NOMADS – Libraries • Maintain system defaults

43. ProvideX Plug-in for Eclipse • NOMADS – Designer • Create / Maintain / Test objects from view

44. ProvideX Plug-in for Eclipse • Extending the Plug-in • The ProvideX Plug-in includes several mechanisms for developers to add new functionality: • Adding customized logic to be executed before or after each primary action • Add a stand-alone tool that can be accessed from the “ProvideX / Contributed Tools” menu

45. ProvideX Plug-in for Eclipse • Contributed Tools: • XML Converter for ProvideX KEYED files • PVX Docs • Generates HTML documentation from information in class definition

46. ProvideX Plug-in for Eclipse • Contributed Tools: • Enhanced Search Capability • Coming in version 1.5

47. Debugging Enhancements (Cont'd) • Integrated Debugging with the ProvideX Plug-in for Eclipse

48. ProvideX Plug-in for Eclipse • Debugging ProvideX – Program Stack • The program stack for the application is displayed in the “Debug” view.

49. ProvideX Plug-in for Eclipse • Debugging – Variables • The variables for the selected program in the stack are displayed with values. • See ProvideX Development with Eclipse Presentation

50. End of Presentation THANK YOU!