Welcome!

Search Authors: Liz McMillan, Elizabeth White, Pat Romanski, Aditya Banerjee, Trevor Parsons

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 true value of the Internet of Things (IoT) lies not just in the data, but through the services that protect the data, perform the analysis and present findings in a usable way. With many IoT elements rooted in traditional IT components, Big Data and IoT isn’t just a play for enterprise. In fact, the IoT presents SMBs with the prospect of launching entirely new activities and exploring innovative areas. CompTIA research identifies several areas where IoT is expected to have the greatest impact.
There is no doubt that Big Data is here and getting bigger every day. Building a Big Data infrastructure today is no easy task. There are an enormous number of choices for database engines and technologies. To make things even more challenging, requirements are getting more sophisticated, and the standard paradigm of supporting historical analytics queries is often just one facet of what is needed. As Big Data growth continues, organizations are demanding real-time access to data, allowing immediate and actionable interpretation of events as they happen. Another aspect concerns how to deliver ...
The Internet of Things will greatly expand the opportunities for data collection and new business models driven off of that data. In her session at @ThingsExpo, Esmeralda Swartz, CMO of MetraTech, discussed how for this to be effective you not only need to have infrastructure and operational models capable of utilizing this new phenomenon, but increasingly service providers will need to convince a skeptical public to participate. Get ready to show them the money!
Code Halos - aka "digital fingerprints" - are the key organizing principle to understand a) how dumb things become smart and b) how to monetize this dynamic. In his session at @ThingsExpo, Robert Brown, AVP, Center for the Future of Work at Cognizant Technology Solutions, outlined research, analysis and recommendations from his recently published book on this phenomena on the way leading edge organizations like GE and Disney are unlocking the Internet of Things opportunity and what steps your organization should be taking to position itself for the next platform of digital competition.
Scott Jenson leads a project called The Physical Web within the Chrome team at Google. Project members are working to take the scalability and openness of the web and use it to talk to the exponentially exploding range of smart devices. Nearly every company today working on the IoT comes up with the same basic solution: use my server and you'll be fine. But if we really believe there will be trillions of these devices, that just can't scale. We need a system that is open a scalable and by using the URL as a basic building block, we open this up and get the same resilience that the web enjoys.
In their session at @ThingsExpo, Shyam Varan Nath, Principal Architect at GE, and Ibrahim Gokcen, who leads GE's advanced IoT analytics, focused on the Internet of Things / Industrial Internet and how to make it operational for business end-users. Learn about the challenges posed by machine and sensor data and how to marry it with enterprise data. They also discussed the tips and tricks to provide the Industrial Internet as an end-user consumable service using Big Data Analytics and Industrial Cloud.
How do APIs and IoT relate? The answer is not as simple as merely adding an API on top of a dumb device, but rather about understanding the architectural patterns for implementing an IoT fabric. There are typically two or three trends: Exposing the device to a management framework Exposing that management framework to a business centric logic Exposing that business layer and data to end users. This last trend is the IoT stack, which involves a new shift in the separation of what stuff happens, where data lives and where the interface lies. For instance, it's a mix of architectural styles ...
IoT is still a vague buzzword for many people. In his session at @ThingsExpo, Mike Kavis, Vice President & Principal Cloud Architect at Cloud Technology Partners, discussed the business value of IoT that goes far beyond the general public's perception that IoT is all about wearables and home consumer services. He also discussed how IoT is perceived by investors and how venture capitalist access this space. Other topics discussed were barriers to success, what is new, what is old, and what the future may hold. Mike Kavis is Vice President & Principal Cloud Architect at Cloud Technology Pa...
The Internet of Things (IoT) is rapidly in the process of breaking from its heretofore relatively obscure enterprise applications (such as plant floor control and supply chain management) and going mainstream into the consumer space. More and more creative folks are interconnecting everyday products such as household items, mobile devices, appliances and cars, and unleashing new and imaginative scenarios. We are seeing a lot of excitement around applications in home automation, personal fitness, and in-car entertainment and this excitement will bleed into other areas. On the commercial side, m...
Dale Kim is the Director of Industry Solutions at MapR. His background includes a variety of technical and management roles at information technology companies. While his experience includes work with relational databases, much of his career pertains to non-relational data in the areas of search, content management, and NoSQL, and includes senior roles in technical marketing, sales engineering, and support engineering. Dale holds an MBA from Santa Clara University, and a BA in Computer Science from the University of California, Berkeley.
Almost everyone sees the potential of Internet of Things but how can businesses truly unlock that potential. The key will be in the ability to discover business insight in the midst of an ocean of Big Data generated from billions of embedded devices via Systems of Discover. Businesses will also need to ensure that they can sustain that insight by leveraging the cloud for global reach, scale and elasticity.
The 3rd International Internet of @ThingsExpo, co-located with the 16th International Cloud Expo - to be held June 9-11, 2015, at the Javits Center in New York City, NY - announces that its Call for Papers is now open. The Internet of Things (IoT) is the biggest idea since the creation of the Worldwide Web more than 20 years ago.
"People are a lot more knowledgeable about APIs now. There are two types of people who work with APIs - IT people who want to use APIs for something internal and the product managers who want to do something outside APIs for people to connect to them," explained Roberto Medrano, Executive Vice President at SOA Software, in this SYS-CON.tv interview at Cloud Expo, held Nov 4–6, 2014, at the Santa Clara Convention Center in Santa Clara, CA.
Performance is the intersection of power, agility, control, and choice. If you value performance, and more specifically consistent performance, you need to look beyond simple virtualized compute. Many factors need to be considered to create a truly performant environment. In his General Session at 15th Cloud Expo, Harold Hannon, Sr. Software Architect at SoftLayer, discussed how to take advantage of a multitude of compute options and platform features to make cloud the cornerstone of your online presence.
SYS-CON Media announced that Splunk, a provider of the leading software platform for real-time Operational Intelligence, has launched an ad campaign on Big Data Journal. Splunk software and cloud services enable organizations to search, monitor, analyze and visualize machine-generated big data coming from websites, applications, servers, networks, sensors and mobile devices. The ads focus on delivering ROI - how improved uptime delivered $6M in annual ROI, improving customer operations by mining large volumes of unstructured data, and how data tracking delivers uptime when it matters most.
Cultural, regulatory, environmental, political and economic (CREPE) conditions over the past decade are creating cross-industry solution spaces that require processes and technologies from both the Internet of Things (IoT), and Data Management and Analytics (DMA). These solution spaces are evolving into Sensor Analytics Ecosystems (SAE) that represent significant new opportunities for organizations of all types. Public Utilities throughout the world, providing electricity, natural gas and water, are pursuing SmartGrid initiatives that represent one of the more mature examples of SAE. We have s...
Since 2008 and for the first time in history, more than half of humans live in urban areas, urging cities to become “smart.” Today, cities can leverage the wide availability of smartphones combined with new technologies such as Beacons or NFC to connect their urban furniture and environment to create citizen-first services that improve transportation, way-finding and information delivery. In her session at @ThingsExpo, Laetitia Gazel-Anthoine, CEO of Connecthings, will focus on successful use cases.
DevOps Summit 2015 New York, co-located with the 16th International Cloud Expo - to be held June 9-11, 2015, at the Javits Center in New York City, NY - announces that it is now accepting Keynote Proposals. The widespread success of cloud computing is driving the DevOps revolution in enterprise IT. Now as never before, development teams must communicate and collaborate in a dynamic, 24/7/365 environment. There is no time to wait for long development cycles that produce software that is obsolete at launch. DevOps may be disruptive, but it is essential.
“With easy-to-use SDKs for Atmel’s platforms, IoT developers can now reap the benefits of realtime communication, and bypass the security pitfalls and configuration complexities that put IoT deployments at risk,” said Todd Greene, founder & CEO of PubNub. PubNub will team with Atmel at CES 2015 to launch full SDK support for Atmel’s MCU, MPU, and Wireless SoC platforms. Atmel developers now have access to PubNub’s secure Publish/Subscribe messaging with guaranteed ¼ second latencies across PubNub’s 14 global points-of-presence. PubNub delivers secure communication through firewalls, proxy ser...
The industrial software market has treated data with the mentality of “collect everything now, worry about how to use it later.” We now find ourselves buried in data, with the pervasive connectivity of the (Industrial) Internet of Things only piling on more numbers. There’s too much data and not enough information. In his session at @ThingsExpo, Bob Gates, Global Marketing Director, GE’s Intelligent Platforms business, to discuss how realizing the power of IoT, software developers are now focused on understanding how industrial data can create intelligence for industrial operations. Imagine ...