Search My Blog

Wednesday, December 13, 2017

An Appeon Christmas

Twas the Night Before Production
adaptation by Chris Pollach
'Twas the night before Production, when all through the Appeon house
Not a creature was stirring, not even Armeen’s mouse;
The stockings were hung by the developers chimneys with care,
In hopes that St. Nick’s software would
soon be there;

The PowerServers were nestled all snug in their racks,
While Light backed-up their data, oh there was stacks;
The marketing manager Sally
in her 'kerchief, and I in my cap,
Had just settled down for a long tester's nap,

When out in the hall there arose such a clatter,
I sprang from my Tablet to see what was the matter.
Away to the Appeon WorkSpace I flew like Macromedia flash,
Opened the Browser and enjoyed the animations splash,

Engineering's build of PowerBuilder R2 was like the new-fallen snow,
It gave promise of so many new features - listed below,
When, what to my wondering eyes - Santa did appear,
Riding in his sleigh pulled by eight tiny reindeer,

With a little native database driver, so lively and quick,
I knew in a moment that DBMS was designed by St. Nick.
More rapid than streaming electrons the datum they came,
And he whistled, and shouted, as he categorized them by name;

"Now, Purple! now, John! now, Hill!
and VIXEN!
On, Julie
! on Steven! on, Danny and BLITZEN!
To the edge of the ISP! Through the Appeon fire-wall!
Now process away! Process away! Process away all!"

As the new applications under PowerServer 2017 did fly,
When they met with a user their new features they did try,
So up to the Browser menu the mouse pointers they flew,
To display a full load of new data, images, and animations too!

And then, in a twinkling, I heard on the tablet - mystified,
A message signaling a new Mobile App had just arrived.
As I pointed my device to the new QR Code, and was turning around,
A message alerted me that the new application was ready … it looked sound.

The project manager was dressed all in fur, from her head to her feet,
And the red robe was all polished, and she even had someone to meet;
A bundle of Web & Mobile applications she had flung on her back,
Most of the programmer’s had agreed, so a DataWindow she also did pack.

The Engineers faces -- how they twinkled! Their dimples how merry!
Their cheeks were like roses, their noses like a cherry!
One droll little mouth was drawn up like a bow,
The “Technical Architect” his beard on his chin was as white as the snow.

The Logs from the PowerServer he held tight in his teeth,
New ideas for PowerBuilder & InfoMaker encircled his head like a wreath.
He had a broad face and a black belt round his belly,
Using moves he learned in TaeKwonDo, the guards shook like jelly.

The “release guy” was chubby and plump, a right jolly old elf,
And I laughed when I saw him, in spite of myself.
A wink of his eye and a twist of his head,
Soon gave me to know I had nothing to dread.

He spoke not a word, but went straight to his work,
And deployed all the new applications; then turned with a jerk,
And laying his finger aside of his nose,
And giving a nod, up all the PowerServers rose;

He sprang to his laptop, to his development team gave a whistle,
And away they all flew, for a beer at the pub “The English Thistle”.
But I heard him exclaim, ere he drove out in the night,

Merry Christmas from everyone at Appeon!

Regards ... Chris

Sunday, December 10, 2017

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)


From basic to WOW!


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.


Regards ... Chris

Thursday, November 30, 2017

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

Wednesday, November 29, 2017

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 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,, 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
  • 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.


Regards ... Chris

Friday, November 3, 2017

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!


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

Tuesday, October 24, 2017

PB 2017 - Web Service PDF Generation

** Hot News **
Web Service PDF Generation
(Web Service In-A-Box)
   Software Tool & Die Inc. are pleased to announce the early release of their next Web Service "In-A-Box" series of turn key reusable components. This Web Service facilitates the generation of PDF files in the middle tier using either PB 2017 NativePDF, a 3rd party solution (ie: Amyuni) or a PostScript printer (ie: GhostScript open source) software solution.
  The current problem with the PowerBuilder Classic PDF implementation is that the PB application needs to quite often install & configure the external software or license 3rd party software on every PC where a PB application resides. This may also includes configuring a PostScript printer as well. A very tedious task for a few PC's, let alone when 100's or even 1,000's of PC's are concerned.

   The STD PDF Web Service negates the MS-Windows PC Client install & configuration by isolating the PDF generation software to an IIs application server. The Web Service component utilizes the frameworks PowerShell (aka Command Shell) interface to execute PDF Generation and Storage of the PDF file(s) on an accompanying Web Server. The native, web or mobile application can then make a simple URL request for the PDF file when its ready. The URL request will in turn render the PDF file within the client's local web browser.
   The current Web Service prototype renders the PDF file to the Web Server but, you could adapt the basic code to save the PDF file in a database table, FTP it to the client, etc just to name a few other alternatives. The PDF Web Service leverages the STD Web Service framework to enable the PDF generation. The example PB & Appeon Web/Mobile application utilizes the STD Integrated framework to call the PDF Web Service and then render the generated PDF file in the client's local web browser.
  You can download the PDF Web service, example PB & Appeon Web/Mobile client application by clicking here!
Enjoy ... Chris