Welcome!

API Journal Authors: Peter Silva, Greg O'Connor, Pat Romanski, SearchStorage.com News, Jason Bloomberg

Related Topics: PowerBuilder

PowerBuilder: Article

New Features in PowerBuilder 11.5 – Part 2

A look at the improvements in GUI functionality

This is the second part of an ongoing series about the new features that were added in PowerBuilder 11.5. In the first part, we looked at the Federal Desktop Core Configuration (FDCC) and the impact it had on developers. In this part, we're going to look at a number of the improvements in GUI functionality. We'll start that by comparing a couple of screenshots of images in DataWindows (Figure 1 and Figure 2) that demonstrate a number of these new functions.

Support for PNG Files
The first thing you may notice is that the image type (in both images) is a Portable Network Graphics (PNG) file. The PNG file format was introduced to overcome limitations of the GIF file format, most notably:

  • The compression algorithm used in GIF files is patented.
  • GIF images are limited to a 256 color depth

PNG images actually provide greater compression than GIF and provide better support for transparency. The main advantage that GIF maintains is support for animation. PNG also has advantages over JPG in that it has lossless compression and transparency support. JPG was particularly designed for photographs, and so PNG tends to render better with non-photographic material (e.g., line art, text).

PowerBuilder 11.5 adds support for PNG files in DataWindow picture controls and in standard Picture controls as well as menus, treeview controls, and toolbars.

Transparency Support
In Figure 1, you'll also notice the "Make Color Transparent" option on the popup menu. This allows you to support transparency when the underlying image format doesn't support transparency, or when the picture you're using isn't transparent in the region you want it to be.  The latter is the case here, as the background of this PNG file has been set to black. I right clicked on the background, chose "Make Color Transparent" and every occurrence of that color in the image was re-rendered as transparent.

You can also set the color manually through the Transparent Color option you see on the property tab on the right of Figure 1, or at runtime by manipulating that property.  You'll also notice the Transparency Setting  on the right property tab of Figure 1. That option is unrelated to the Transparent Color option, what it controls is the opacity of the entire image.  Setting it higher make it possible to see the control or window background behind the picture through the picture.

Gradient/Picture Backgrounds
You'll notice in Figure 2 that now that the picture has a transparent background, what is showing through is a gradient color, not a solid background. That's because PowerBuilder 11.5 adds support for specifying a gradient or picture background for the DataWindow bands. The new Brush Mode property you can see in Figure 2 controls the background, and you have an option between Solid (old style), 5 different gradient styles or the Picture option. For both Gradients and Picture backgrounds, there is a section each of the Background properties tab for controlling a wide variety of options for how they are displayed (see Figure 3 and Figure 4). In fact, it's a bit confusing at first because those areas of the property pane appear continuously, no matter which option you have selected for the Brush Mode.  But you will only see the options that you have specified in the Gradient section applied if you pick one of the Gradient brush styles, and similarily none of the Picture properties settings have any effect until you select a Picture brush style.

Tooltips
Take a look at the properties pane in Figure 5, and you'll see the new Tooltips options for DataWindow controls. Figure 6 shows what the tooltip looks like at runtime. You'll notice that you have a lot of control over how the tooltip displays through the properties, all of which are adjustable via runtime properties as well. Note also how many of them support expressions, as indicated by the small equals sign button to the right of the property. Any property with such an icon can be specified through an expression, so that the attribute can be dynamically driven by data within the DataWindow.

Improved 3D Rendering of Graphs
Figure 7 and Figure 8 help illustrate the next new feature, improved 3D rendering of graphs. The improvement is implemented through DirectX, so there are some runtime ramifications.  One of them is that you'll need to install DirectX on the development machine and ensure that it's also available on the machines you are deploying to.  For the development machine, Sybase provides an installer for DirectX in the Program Files\Sybase\Shared\PowerBuilder\dxre directory.  It also means that some of your older machine may not have graphics cards capable of supporting the new graph styles.  Fortunately, when that is the case the display degrades gracefully to the previous 3D format.

Rich Text Edit Control
Last but not least, PowerBuilder 11.5 introduces a new edit style called the Rich Text Edit style (see Figure 9). No longer will you have to use SELECTBLOB/UPDATEBLOB and a separate RichText control to display rich text to the end user. You can select textual data (up to the limits imposed by your database driver) in the normal datawindow select and allow the user to edit it and store it in RTF format.

Some observations.  First, see Figure 10, which shows the edit style selected in the DataWindow painter.  Note that you don't have a lot of the options for the edit style that you do for the normal Rich Text windows control.

The second, shown in Figure 11, is a Rich Text Edit Style related property that appears for the DataWIndow Control, not the DataWindow Object.  The RichText Toolbar Activiation Mode determine when the toolbar for the edit control appears.  The choices are essentially:

  • Always - display the toolbar all the time, whether the rich text edit column has focus or not
  • On Edit - only display the toolbar when the rich text edit column has focus
  • Never - don't display the toolbar, even when the rich text edit column has focus

The last option is useful either when you don't have room to show the toolbar, or if you want to implement your own toolbar. The latter is possible because of a number of methods that have been added to the DataWindow that allow you to interact with the rich text edit masked column. This option would be the path you might take in order to show a fixed toolbar. Note in Figure 7 that the toolbar is floating. There is currently no option in the rich edit control style to make the toolbar fixed to the top of the edit area. Instead, the toolbar will remember the last location it was displayed at, and the end-user can move it around as needed when it's visible.

One caveat mentioned earlier bears repeating. The rich column edit style is limited to the amount of text that your target database allows you to select in a normal SQL statement.  For some databases, this can be a rather small amount compared to the amount of data required for RTF data. RTF has a very verbose syntax.  The single paragraph shown in Figure 9 required over 40K of RTF formatted data.  When a single bitmap was included, the size mushroomed to over 400K. Currently you either need to work with a database that allows direct access to very large text data fields, or you'll need to place tight limits on the amount of data used.  Perhaps future enhancements in this area will address this limitation.

That's all for Part Two. Watch for Part Three, where we'll cover even more new functionality.

More Stories By Bruce Armstrong

Bruce Armstrong is a development lead with Integrated Data Services (www.get-integrated.com). A charter member of TeamSybase, he has been using PowerBuilder since version 1.0.B. He was a contributing author to SYS-CON's PowerBuilder 4.0 Secrets of the Masters and the editor of SAMs' PowerBuilder 9: Advanced Client/Server Development.

Comments (0)

Share your thoughts on this story.

Add your comment
You must be signed in to add a comment. Sign-in | Register

In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.


@ThingsExpo Stories
The cloud promises new levels of agility and cost-savings for Big Data, data warehousing and analytics. But it’s challenging to understand all the options – from IaaS and PaaS to newer services like HaaS (Hadoop as a Service) and BDaaS (Big Data as a Service). In her session at @BigDataExpo at @ThingsExpo, Hannah Smalltree, a director at Cazena, will provide an educational overview of emerging “as-a-service” options for Big Data in the cloud. This is critical background for IT and data profes...
SYS-CON Events announced today that Men & Mice, the leading global provider of DNS, DHCP and IP address management overlay solutions, will exhibit at SYS-CON's 18th International Cloud Expo®, which will take place on June 7-9, 2016, at the Javits Center in New York City, NY. The Men & Mice Suite overlay solution is already known for its powerful application in heterogeneous operating environments, enabling enterprises to scale without fuss. Building on a solid range of diverse platform support,...
One of the bewildering things about DevOps is integrating the massive toolchain including the dozens of new tools that seem to crop up every year. Part of DevOps is Continuous Delivery and having a complex toolchain can add additional integration and setup to your developer environment. In his session at @DevOpsSummit at 18th Cloud Expo, Miko Matsumura, Chief Marketing Officer of Gradle Inc., will discuss which tools to use in a developer stack, how to provision the toolchain to minimize onboa...
SYS-CON Events announced today that Avere Systems, a leading provider of enterprise storage for the hybrid cloud, will exhibit at SYS-CON's 18th International Cloud Expo®, which will take place on June 7-9, 2016, at the Javits Center in New York City, NY. Avere delivers a more modern architectural approach to storage that doesn’t require the overprovisioning of storage capacity to achieve performance, overspending on expensive storage media for inactive data or the overbuilding of data centers ...
SYS-CON Events announced today that Alert Logic, Inc., the leading provider of Security-as-a-Service solutions for the cloud, will exhibit at SYS-CON's 18th International Cloud Expo®, which will take place on June 7-9, 2016, at the Javits Center in New York City, NY. Alert Logic, Inc., provides Security-as-a-Service for on-premises, cloud, and hybrid infrastructures, delivering deep security insight and continuous protection for customers at a lower cost than traditional security solutions. Ful...
SYS-CON Events announced today that Interoute, owner-operator of one of Europe's largest networks and a global cloud services platform, has been named “Bronze Sponsor” of SYS-CON's 18th Cloud Expo, which will take place on June 7-9, 2015 at the Javits Center in New York, New York. Interoute is the owner-operator of one of Europe's largest networks and a global cloud services platform which encompasses 12 data centers, 14 virtual data centers and 31 colocation centers, with connections to 195 ad...
Companies can harness IoT and predictive analytics to sustain business continuity; predict and manage site performance during emergencies; minimize expensive reactive maintenance; and forecast equipment and maintenance budgets and expenditures. Providing cost-effective, uninterrupted service is challenging, particularly for organizations with geographically dispersed operations.
SYS-CON Events announced today that Commvault, a global leader in enterprise data protection and information management, has been named “Bronze Sponsor” of SYS-CON's 18th International Cloud Expo, which will take place on June 7–9, 2016, at the Javits Center in New York City, NY, and the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. Commvault is a leading provider of data protection and information management...
SYS-CON Events announced today that VAI, a leading ERP software provider, will exhibit at SYS-CON's 18th International Cloud Expo®, which will take place on June 7-9, 2016, at the Javits Center in New York City, NY. VAI (Vormittag Associates, Inc.) is a leading independent mid-market ERP software developer renowned for its flexible solutions and ability to automate critical business functions for the distribution, manufacturing, specialty retail and service sectors. An IBM Premier Business Part...
With an estimated 50 billion devices connected to the Internet by 2020, several industries will begin to expand their capabilities for retaining end point data at the edge to better utilize the range of data types and sheer volume of M2M data generated by the Internet of Things. In his session at @ThingsExpo, Don DeLoach, CEO and President of Infobright, will discuss the infrastructures businesses will need to implement to handle this explosion of data by providing specific use cases for filte...
Cognitive Computing is becoming the foundation for a new generation of solutions that have the potential to transform business. Unlike traditional approaches to building solutions, a cognitive computing approach allows the data to help determine the way applications are designed. This contrasts with conventional software development that begins with defining logic based on the current way a business operates. In her session at 18th Cloud Expo, Judith S. Hurwitz, President and CEO of Hurwitz & ...
Fortunately, meaningful and tangible business cases for IoT are plentiful in a broad array of industries and vertical markets. These range from simple warranty cost reduction for capital intensive assets, to minimizing downtime for vital business tools, to creating feedback loops improving product design, to improving and enhancing enterprise customer experiences. All of these business cases, which will be briefly explored in this session, hinge on cost effectively extracting relevant data from ...
SYS-CON Events announced today that Pythian, a global IT services company specializing in helping companies adopt disruptive technologies to optimize revenue-generating systems, has been named “Bronze Sponsor” of SYS-CON's 18th Cloud Expo, which will take place on June 7-9, 2015 at the Javits Center in New York, New York. Founded in 1997, Pythian is a global IT services company that helps companies compete by adopting disruptive technologies such as cloud, Big Data, advanced analytics, and DevO...
As enterprises work to take advantage of Big Data technologies, they frequently become distracted by product-level decisions. In most new Big Data builds this approach is completely counter-productive: it presupposes tools that may not be a fit for development teams, forces IT to take on the burden of evaluating and maintaining unfamiliar technology, and represents a major up-front expense. In his session at @BigDataExpo at @ThingsExpo, Andrew Warfield, CTO and Co-Founder of Coho Data, will dis...
With the Apple Watch making its way onto wrists all over the world, it’s only a matter of time before it becomes a staple in the workplace. In fact, Forrester reported that 68 percent of technology and business decision-makers characterize wearables as a top priority for 2015. Recognizing their business value early on, FinancialForce.com was the first to bring ERP to wearables, helping streamline communication across front and back office functions. In his session at @ThingsExpo, Kevin Roberts...
SYS-CON Events announced today that iDevices®, the preeminent brand in the connected home industry, will exhibit at SYS-CON's 18th International Cloud Expo®, which will take place on June 7-9, 2016, at the Javits Center in New York City, NY. iDevices, the preeminent brand in the connected home industry, has a growing line of HomeKit-enabled products available at the largest retailers worldwide. Through the “Designed with iDevices” co-development program and its custom-built IoT Cloud Infrastruc...
Eighty percent of a data scientist’s time is spent gathering and cleaning up data, and 80% of all data is unstructured and almost never analyzed. Cognitive computing, in combination with Big Data, is changing the equation by creating data reservoirs and using natural language processing to enable analysis of unstructured data sources. This is impacting every aspect of the analytics profession from how data is mined (and by whom) to how it is delivered. This is not some futuristic vision: it's ha...
Silver Spring Networks, Inc. (NYSE: SSNI) extended its Internet of Things technology platform with performance enhancements to Gen5 – its fifth generation critical infrastructure networking platform. Already delivering nearly 23 million devices on five continents as one of the leading networking providers in the market, Silver Spring announced it is doubling the maximum speed of its Gen5 network to up to 2.4 Mbps, increasing computational performance by 10x, supporting simultaneous mesh communic...
SYS-CON Events announced today that Fusion, a leading provider of cloud services, will exhibit at SYS-CON's 18th International Cloud Expo®, which will take place on June 7-9, 2016, at the Javits Center in New York City, NY. Fusion, a leading provider of integrated cloud solutions to small, medium and large businesses, is the industry's single source for the cloud. Fusion's advanced, proprietary cloud service platform enables the integration of leading edge solutions in the cloud, including clou...
Most people haven’t heard the word, “gamification,” even though they probably, and perhaps unwittingly, participate in it every day. Gamification is “the process of adding games or game-like elements to something (as a task) so as to encourage participation.” Further, gamification is about bringing game mechanics – rules, constructs, processes, and methods – into the real world in an effort to engage people. In his session at @ThingsExpo, Robert Endo, owner and engagement manager of Intrepid D...