New Integrated Foundation Classes (2018R1) Released!

** Hot News **

  New Integrated Foundation Classes (2018R1) Released!

 "THE" Framework for Appeon PowerBuilder & PowerServer!

(v2018.1.0.95 - February 14, 2018)

Integrated logging

        Software Tool & Die Inc (STD) are very pleased to announce that they have just released a new version 2018R1 (build 2018.1.0.95) of their Integrated Foundation Class library framework for PowerBuilder 2017R2, PowerServer 2017 Web and PowerServer 2017 Mobile!

  

     STD are also super excited as this release represents one of most significant enhancements to the Integrated framework that really exposes the power of Appeon PowerBuilder 2017R2! The new framework combined with PB2017R2 (Revision #2) really positions developers to take advantage of today's Agile and DevOps methodologies plus put a complete new GUI "punch" in your Native, Web and Mobile Apps  without buying expensive add-on products.

     For a summary of the previous framework version's feature set, please follow this link - 2017R3.
  

   The following are some of the highlights of the new combined framework and Appeon PowerBuilder 2017R2 versions at work, as follows:
  

Floating Toolbars

 

New MDI Child & Dockable window floating Toolbars

Database Heartbeat

New Transaction Object Heartbeat feature!

Tracked Windows

New Tracked Dockable Child Windows

   The latest Integrated framework version contains the following updates and has been tested with MS-Windows 10 O/S (Creator Edition), PB 2017R2 build #1756 and the PowerServer 2017 (build 1689). Testing inside of PB included Win32 (both P-code & M-code) and Win64 ( P-code) deployments. Testing inside of PowerServer Web & Mobile included latest Web Browsers, latest Apple Tablet/Smart Phone and Android Tablet/Smart Phone  deployments.

Note: All the STD frameworks are free and can be downloaded from its STD Foundation Classes SourceForge project website..

Release 2018.1.0.95 - Major Release (2018R1) - change highlights ...

• Migration of entire framework from PB2017MR01 to PB2017R2.
• Added code to "fn_open_sheet_window" to track Dockable sheets
• Added code to "fn_open_sheet_window_withparm" to track Dockable sheets
• Moved SHBrowseForFolder 64bit API in "nc_app_controller_master" to nc_app_controller64_master object
• Added new variable to indicate the App is an IWA application in "nc_app_controller_master".  
• Revised code to set IWA switch & log status if in DEBUG mode in "nc_app_controller_master".
• Added new public function "of_is_iwa_app" in "nc_app_controller_master".
• Added new public function "of_set_dockable_mode" in "nc_app_controller_master".
• Added new public function "of_is_dockable_app" in "nc_app_controller_master".
• Added code to the RetrieveEnd event of "vs_dc_graph_master" to handle graph creates in PowerServer Web & Mobile.
• Added new public function "of_get_document_windows" in "nc_app_controller_master".
• Added new public function "of_get_tabgroup_windows" in "nc_app_controller_master".
• Added new public function "of_get_docked_windows" in "nc_app_controller_master".
• Added new public function "of_get_sheet_windows" in "nc_app_controller_master".
• Removed all extraneous code. Added instance Window PTR in "wn_debug_list_master".
• Changed code to use save Instance Window PTR in "wn_debug_list_master".
• Added code to resize the mle_windows control in "wn_debug_list_master".
• Added code to Loop through the tracked windows & list them in the MLE in "wn_debug_list_master".
• Added Trace Model tab page to "wn_debug_list_master".
• Revised the code to fix the report type if Sheet is also dockable in "wn_main_master" of_get_window_open_type method.
• Added boolean indicator for tracking being the current Active window in "wn_main_master".
• Added new public function "of_get_sheet_windows" in "wn_master".
• Added code to the Activate Event to Set Active Window indicator on focus in "wn_master".
• Added code to the DeActivate Event to  Set the Active Window boolean to false when losing focus in "wn_master".
• Added code to Fix for PowerServer Web bug SelectText in "wn_messagebox_master".
• Revised GUI to present better on W10 & newer O/S versions in "wn_zoom_master".
• Added code to mark the open state as SHEET for MAIN window types being opened in "fn_open_sheet_as_document".
• Added code to mark the open state as SHEET for MAIN window types being opened in "fn_open_sheet_docked".
• Added code to mark the open state as SHEET for MAIN window types being opened in "fn_open_sheet_in_tabggroup".
• Added code to mark the open state as SHEET for MAIN window types being opened in "fn_open_sheet_withparm_as_document".
• Added code to mark the open state as SHEET for MAIN window types being opened in "fn_open_sheet_withparm_docked".
• Added code to mark the open state as SHEET for MAIN window types being opened in "fn_open_sheet_withparm_in_tabggroup".
• Moved 64bit code to the 64bit App Controller object class "nc_app_controller64_master" from "nc_app_controller_master".
• Added new "ns_http_client_master" base class for the new HTTPCLIENT object class.
• Added new "ns_json_generator_master" base class for the new JSON Generator object class.
• Added new "ns_json_parsor_master" base class for the new JSON Parsor object class.
• Added new "ns_restful_client_master" base class for the new RESTFul Client object class.
• Added new "of_set_transobject" method to the "ns_ds_master" object class.
• Added new "of_get_transobject" method to the "ns_ds_master" object class.
• Added new variables to support "heart beat" feature    in the "ns_sqlca_master" object class.
• Added new "oe_heart_beat" event to the "ns_sqlca_master" object class.
• Revised the "of_Connect" and "of_disconnect" methods in "ns_sqlca_master" class for the new Heartbeat feature.
• Added new "of_set_heartbeat_time" method to the "ns_sqlca_master" object class.
• Added new "of_set_heartbeat" method to the "ns_sqlca_master" object class.
• Added code to control the HeartBeat feature if active SQL is found in the SQLPreview event of "ns_sqlca_master".
• Added Transaction Object pointer and Get/SetTransObject methods to support Parent class pointer.    
• Revised the "oe_resize" event code in "vs_tc_master" to fix resizing issue.
• Revised the "resize" event code in "wn_log_viewer_master" to fix resizing for Dockable windowed App .

    The OrderEntry example application has also been updated to the new Integrated Foundation class framework version. You can download the example application from here. Also, check out the online "getting started" video series to accelerate your assimilation of the best framework for PowerBuilder & PowerServer!
   STD would also like to thank Novalys Corporation for their support of the Foundation Classes by supplying the VisualExpert product for the framework's documentation.


Enjoy!  

Regards ... Chris

Visual Expert for SQL Server

** Hot News **

Visual Expert for SQL Server

   The official release of Visual Expert for SQL Server is now available.  It includes the same features as Visual Expert for Oracle and PowerBuilder.

• Explore Transact SQL Code and SQL Server Schemas.
• Run Impact Analysis and check Cross-references
• Generate a CRUD matrix to find which code is using your SQL Server data, and how.
• Source Code documentation
• Code Review
• Code Comparison
• etc.

 

For more information - click here!

To try Visual Expert for SQL Server - click here!


Regards ... Chris

PowerBuilder Seminar in Italy

** Hot News **

PowerBuilder Seminar in Italy

    Software Product Italian (SPI) Corporation will be hosting their annual seminar on March 20-21, 2018 at the Boscolo Astoria Hotel in Florence.

   Appeon CEO, Armeen Mazda, and Appeon MVP, Marco Meoni, will share with the attendees the updated PowerBuilder road-map and the technical details in the latest PowerBuilder R2 release.

  Please join SPI in Florence to have a face-to-face communication with Appeon and their local partner in Italy.

For more information ... click here!

Regards ... Chris

PowerBuilder Seminar in Japan

** Hot News **

PowerBuilder Seminar in Japan

Nippon Computer Systems (NCS) Corporation will host their annual PowerBuilder seminar to celebrate the release of PowerBuilder 2017 Japanese version on February 20, 2018 in Tokyo.

Appeon CEO, Armeen Mazda, will share with the attendees the updated road map for PowerBuilder including the key new features of PowerBuilder 2017 R2, released on January 31, 2018. In addition, NCS also share more PowerBuilder 2017 technical details.

For more information ... click here!

Regards ... Chris

Hands-on Look at PowerBuilder 2017 R2

** Hot News **

Hands-on Look at PowerBuilder 2017 R2

Upcoming Webcast

 

January 31, 2018 - 9:00 AM PST (SAN FRANCISCO)

    In this official Appeon Webcast, Appeon will share with you how PowerBuilder has been changed over the last 6 months, and update you on our direction.  This will be followed by a hands-on look and quick tutorial of new features in PowerBuilder 2017 R2.  Join us live to get the first-hand new features in the product and a chance to communicate with Appeon Stuff.

    Recording of the Webcast will be sent to all registrants, so we recommend you register even if you can’t attend. 

Presenters: Armeen Mazda, Chris Pollach

Register Now

New Integrated Foundation Classes (2017R3) Released!

** Hot News **

  New Integrated Foundation Classes (2017R3) Released!

 "THE" Appeon PowerBuilder & PowerServer framework!

(v2017.3.0.90 - December 10, 2017)

 

New Dockable Application Style!

    Software Tool & Die Inc (STD) are very pleased to announce that they have just released a new version 2017R3 (build 2017.3.0.90) of their Integrated Foundation Class library framework for PowerBuilder 2017MR01, PowerServer 2017 Web and PowerServer 2017 Mobile!
  

     STD are also super excited as this release represents one of most significant enhancements to the Integrated framework that really exposes the power of Appeon PowerBuilder 2017! The new framework combined with PB2017 really positions developers to take advantage of today's Agile and DevOps methodologies plus put a complete new GUI "punch" in your Native, Web and Mobile Apps  without buying expensive add-on products.
  

   The following are some of the highlights of the new combined framework and Appeon PowerBuilder 2017 versions at work, as follows:
  

Application GUI

From this

To this (with two lines of framework code)

Graphs

From basic to WOW!

Menus

From plain to Amazing!

Intelligent Drag & Drop

Just like in the Visual Studio IDE!
 

and Much, Much More!

    

  The latest Integrated framework version contains the following updates and has been tested with MS-Windows 10 O/S (Creator Edition), PB 2017 build #1681 and the PowerServer 2017 (build 1689). Testing inside of PB included Win32 (both P-code & M-code) and Win64 ( P-code) deployments. Testing inside of PowerServer Web & Mobile included latest Web Browsers, latest Apple Tablet/Smart Phone and Android Tablet/Smart Phone  deployments.

Note: All the STD frameworks are free and can be downloaded from its STD Foundation Classes SourceForge project website..

Release 2017.3.0.90 - Major Release (2017R3) - change highlights ...

• Migration of entire framework from PB 2017 to PB 2017MR01.
• Changed function fn_number_to_words_cheque to fn_number_to_words.
• Added new variables for O/S version and build to nc_app_controller_master
• Revisd the code to now retrieve & include O/S build & platform number in of_check_os_version
• Changed the script to always write the App's bitness to the log in of_set_pb_environment_info
• Added SetCapture() & ReleaseCapture() declarations for better mouse control    in nc_app_controller_master
• Added of_is_64bit_os function to  nc_app_controller_master
• Created a 64bit Structure for the support of 64bit App's in of_browse_for_folder of nc_app_controller_master
• Removed deprecated code in of_write_event of nc_app_controller_master
• Created new function of_is_64bit_app in nc_app_controller_master
• Created new function of_is_64bit_processor in nc_app_controller_master
• Created new function of_check_fc_version in nc_app_controller_master
• Added ib_check_fc_version switch to check for STD Framework version at start-up in nc_app_controller_master
• Added ii_keyboardtype for PB2017 Universal compliance in vs_dc_master
• Added new variables for new PowerServer Mobile features in PB 2017 Universal in vs_em_master
• Added recognition timer variable for PB2017 Universal compliance in vs_ip_master
• Moved Hint Text support to oe_postconstructor in vs_sle_master
• Revised the code to use of_sethinttext from the AWS object vs appeonextfuncs in vs_sle_master
• Added ii_vertical variable for compatibility with PB 2017 Universal in vs_st_master
• Revised mouse pointer handling in fn_print_screen
• Created new fn_print_window global function
• Added DataStore to collect Menu activity statistics in mu_master
• Added GetMenuString() & GetMenuItemInfo() method for menu activity capture in nc_app_controller_master
• Added code to fire the RowFocusChanged if row highlighting is in effect in vs_dc_list_master
• Added the ability to show a print dialogue in in vs_dc_master
• Revised the code to print more effectively under W10 and also with Cancel dialogue in wn_master
• Added new oe_print_screen event in wn_master
• Added code to fire the "oe_preDestructor" menu event in wn_master
• Removed the "pc_icon" & "st_msg" controls as the DWO now handles this in wn_messagebox_master
• Revised default control properties for PB2017MR01 optimization vs_rte_master
• Revised to allow the TXT file to created dynamically via DWO's default primary buffer in wn_tracing_options_master
• Moved the code from the Constructor to the Post Constructor of the DC in wn_tracing_options_master
• Revised to allow the TXT file to created dynamically via DWO's default primary buffer in wn_tracing_options_master
• Revised code to mark the window as now being used as an MDI Sheet in fn_open_sheet_window
• Added code to indicate that the window was opened as a Sheet (MDI Child) in fn_open_sheet_window_withparm
• Added code to record the fact that the user clicked this enu item in mu_application_master
• Added menu and menu item pointers in mu_master
• Added new function of_set_controller_window_class to nc_app_controller_master
• Over-Rode the Ancestor to stop annoying messages in wn_log_viewer_master
• Added new of_get_document_state function in wn_main_master
• Added new of_get_tabgroup_state function in wn_main_master
• Added new of_get_docked_state function in wn_main_master
• Added new of_set_docked_state function in wn_main_master
• Added new of_set_document_state function in wn_main_master
• Added new of_set_sheet_state function in wn_main_master
• Added new of_set_tabgroup_state function in wn_main_master
• Added new of_get_sheet_open_state function in wn_main_master
• Added new of_get_window_open_type function in wn_main_master
• Added code to set the open state tracking indicator    in fn_open_sheet_as_document
• Added code to set the Document state indicator in fn_open_sheet_docked
• Added code to set the TabGroup state indicator in fn_open_sheet_in_tabggroup
• Added code to set the document state indicator in fn_open_sheet_withparm_as_document
• Added code to set the Docked state indicator in fn_open_sheet_withparm_docked
• Added code to set the Tab Group state indicator in fn_open_sheet_withparm_in_tabggroup

Debug Tracing

Debugging & tracing options increased from 21 to 130!

 
    The OrderEntry example application has also been updated to the new Integrated Foundation class framework version. You can download the example application from here. Also, check out the online "getting started" video series to accelerate your assimilation of the best framework for PowerBuilder & PowerServer!

   STD would also like to thank Novalys Corporation for their support of the Foundation Classes by supplying the VisualExpert product for the framework's documentation.


Enjoy! 

Regards ... Chris

PB / IM 2017R1 - Localized Run-times

** Hot News **

Localized run-times for PB 2017R1

 

    Appeon have now just released the Localized Run-time Files for both the PowerBuilder and InfoMaker 2017 revision #1 (PB/IM2017R1) products. This distribution of localized run-time files is targeted for use only with build 1681 of the PowerBuilder and InfoMaker products. The localized run-time files are for all the product editions though, which are: Standard, Cloud, and Universal.

        The localized run-time files are provided for French, German, Italian, Spanish, Dutch, Danish, Norwegian, and Swedish languages. With these localized run-time files, PowerBuilder / InfoMaker developers can now deploy applications with standard run-time dialog boxes in the local language of their Windows installation.

        You can download the localized files from the Appeon Download Portal.

Regards ... Chris

SQL Extract - Appeon PowerBuilder

** Hot News **

New SQL Extract version 17 

for Appeon PowerBuilder 2017

 

    Software Tool & Die Inc. (STD Inc) have just released a new version of the SQL Extract utility (version 17.0.0.35) that can reverse engineer Appeon PowerBuilder's proprietary SQL format known as a PBSELECT into either ANSI, PL/SQL or T-SQL format from within any DataWindow (TM) object. The new version of the SQL Extract utility was designed to allow it to forward & reverse engineer the DataWindow source code from any Unicode based PowerBuilder library. This means that DataWindow source from PowerBuilder version 10 through PB 2017 can be parsed & the SQL run-time generated from a PBSELECT - just like when your DataWindows are actually running under control of your PowerBuilder based production applications! The utility will also identify DataWindows that are not using a PBSELECT format that may be already causing performance, migration or cross-DBMS issues.

 
    The output of SQL Extract is a textual based .SQL file that can be input directly into SQL syntax analysis  products like: SQL Parser; SQL Doctor; Aqua Data Studio; DB Optimizer; etc (to name a few products) for further SQL analysis, formatting, & tuning. STD successfully tested the new version of SQL Extract with SAP's latest SQL Anywhere 17 & ASE 16 as well as the Microsoft SQLServer 2017 DBMS system. SQL Extract can also handle other DB access mechanisms, such as: OLE-DB, ADO.net, JDBC, OData. Support for the ODBC db driver is still standard, but the native db drivers are fully supported as per the Appeon PB 2017R1 product feature set. For older ASE databases, SQL Extract also supports the Open Client (SYC) native DB driver access mechanism.

    The new version of the SQL Extract utility will also work with Appeon's InfoMaker 2017 & PowerServer 2017 development tools as well, as those products also utilize DataWindow technology. The new features of SQLXTract v17 are as follows:

• Migrated the App code to PB2017R1 - version 17.0.0.1681.
• Revised SQL extraction logic to support "on the fly" DataWindow source conversion to PB2017R1 syntax
• Tested SQL Extract with SA 17 and the new "PB Demo DB V2017" database
• Removed the WinForm Target (now an obsolete PB feature)
• Added new Project for 64bit deployment
• Added support for the Informix DBMS & client
• Added oData DB client support
• Added JDBC DB client support
• Added client support for the SAP ASE v15/16 DBMS
• Added client support for the MS-SQLServer 2016/2017 DBMS
• Added client support for the Oracle 12C DBMS
• Tested SQL Extract with ASE 16 & SS 2017 DBMS

 

    The SQL Extract utility application is open source and thus royalty free to use. You can download the SQL Extract application source code from its current location on the SourceForge website.

Enjoy!

Regards ... Chris

PowerBuilder 2018

** Hot News **

PowerBuilder 2018 - Sneak Preview

      Appeon is now working hard on the new PowerBuilder 2018 release for next year. At this years fall 2017 Elevate Conference, Appeon demonstrated to the attendees the new PowerBuilder 2018 the .NET C# Compiler and new C# Web API target now integrated right inside the PowerBuilder IDE! Appeon has just released a video to the public today so that all PB Developers can have a sneak peak at this new "kool" feature. So you too ... can check out this feature coming to PB2018 next year - click here to view! - and also see PB handle the new .NET Core technology as well in stride!

      If you also missed the amazing Elevate 2017 Conference, Appeon has now published the conference materials online on their website for everyone to access. For a full exposure to what you missed at the conference or a recap of the events from the attendee's perspective, please click here!

Enjoy!

Regards ... Chris

PowerBuilder 2017 Universal Edition - MR02 released

** Hot News **

PowerBuilder 2017 - New Maintenance Release (MR02)

    Appeon have announced on October 31, 2017 that a new Maintenance Release (“MR”) #1689 for the Appeon PowerBuilder 2017 Universal Edition is available to download. This MR is targeted for PowerServer Mobile within the PB Universal Edition only and includes important bug fixes plus,  adding support for the iOS 11.x and Android 7.x operating system versions.  

Install the Maintenance Release

• PowerBuilder Standard and Cloud subscribers should skip this MR. 
• PowerBuilder Universal subscribers, if you’ve already installed the General Availability (“GA”) version, then you can directly install the new MR from the Downloads section from your User Center on the Appeon website.
• For PowerBuilder Universal subscribers, if you have not yet installed PowerServer Mobile (PB Edition), you should first download the GA version of PB2017 and then apply MR #1689 from the Downloads section in your User Center.

Update your Apps

• Make sure that you the re-deploy (full build) of your mobile apps with this latest PowerServer Mobile (PB Edition) once the MR is applied. 

Regards ... Chris