Welcome!

API Journal Authors: Liz McMillan, Elizabeth White, Kevin Benedict, Anders Wallgren, Amit Golander

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 IoT is changing the way enterprises conduct business. In his session at @ThingsExpo, Eric Hoffman, Vice President at EastBanc Technologies, discuss how businesses can gain an edge over competitors by empowering consumers to take control through IoT. We'll cite examples such as a Washington, D.C.-based sports club that leveraged IoT and the cloud to develop a comprehensive booking system. He'll also highlight how IoT can revitalize and restore outdated business models, making them profitable...
Designing IoT applications is complex, but deploying them in a scalable fashion is even more complex. A scalable, API first IaaS cloud is a good start, but in order to understand the various components specific to deploying IoT applications, one needs to understand the architecture of these applications and figure out how to scale these components independently. In his session at @ThingsExpo, Nara Rajagopalan is CEO of Accelerite, will discuss the fundamental architecture of IoT applications, ...
In his session at 18th Cloud Expo, Bruce Swann, Senior Product Marketing Manager at Adobe, will discuss how the Adobe Marketing Cloud can help marketers embrace opportunities for personalized, relevant and real-time customer engagement across offline (direct mail, point of sale, call center) and digital (email, website, SMS, mobile apps, social networks, connected objects). Bruce Swann has more than 15 years of experience working with digital marketing disciplines like web analytics, social med...
SYS-CON Events announced today that Enzu, a leading provider of cloud hosting 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. Enzu’s mission is to be the leading provider of enterprise cloud solutions worldwide. Enzu enables online businesses to use its IT infrastructure to their competitive advantage. By offering a suite of proven hosting and management services, Enzu wants companies to foc...
Customer experience has become a competitive differentiator for companies, and it’s imperative that brands seamlessly connect the customer journey across all platforms. With the continued explosion of IoT, join us for a look at how to build a winning digital foundation in the connected era – today and in the future. In his session at @ThingsExpo, Chris Nguyen, Group Product Marketing Manager at Adobe, will discuss how to successfully leverage mobile, rapidly deploy content, capture real-time d...
A strange thing is happening along the way to the Internet of Things, namely far too many devices to work with and manage. It has become clear that we'll need much higher efficiency user experiences that can allow us to more easily and scalably work with the thousands of devices that will soon be in each of our lives. Enter the conversational interface revolution, combining bots we can literally talk with, gesture to, and even direct with our thoughts, with embedded artificial intelligence, wh...
IoT generates lots of temporal data. But how do you unlock its value? How do you coordinate the diverse moving parts that must come together when developing your IoT product? What are the key challenges addressed by Data as a Service? How does cloud computing underlie and connect the notions of Digital and DevOps What is the impact of the API economy? What is the business imperative for Cognitive Computing? Get all these questions and hundreds more like them answered at the 18th Cloud Expo...
As cloud and storage projections continue to rise, the number of organizations moving to the cloud is escalating and it is clear cloud storage is here to stay. However, is it secure? Data is the lifeblood for government entities, countries, cloud service providers and enterprises alike and losing or exposing that data can have disastrous results. There are new concepts for data storage on the horizon that will deliver secure solutions for storing and moving sensitive data around the world. ...
What a difference a year makes. Organizations aren’t just talking about IoT possibilities, it is now baked into their core business strategy. With IoT, billions of devices generating data from different companies on different networks around the globe need to interact. From efficiency to better customer insights to completely new business models, IoT will turn traditional business models upside down. In the new customer-centric age, the key to success is delivering critical services and apps wit...
The essence of data analysis involves setting up data pipelines that consist of several operations that are chained together – starting from data collection, data quality checks, data integration, data analysis and data visualization (including the setting up of interaction paths in that visualization). In our opinion, the challenges stem from the technology diversity at each stage of the data pipeline as well as the lack of process around the analysis.
SYS-CON Events announced today that ContentMX, the marketing technology and services company with a singular mission to increase engagement and drive more conversations for enterprise, channel and SMB technology marketers, has been named “Sponsor & Exhibitor Lounge Sponsor” of SYS-CON's 18th Cloud Expo, which will take place on June 7-9, 2016, at the Javits Center in New York City, New York. “CloudExpo is a great opportunity to start a conversation with new prospects, but what happens after the...
SYS-CON Events announced today that MangoApps 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. MangoApps provides modern company intranets and team collaboration software, allowing workers to stay connected and productive from anywhere in the world and from any device. For more information, please visit https://www.mangoapps.com/.
SYS-CON Events announced today that 24Notion has been named “Bronze Sponsor” of SYS-CON's 18th Cloud Expo, which will take place on June 7-9, 2016, at the Javits Center in New York, New York. 24Notion is full-service global creative digital marketing, technology and lifestyle agency that combines strategic ideas with customized tactical execution. With a broad understand of the art of traditional marketing, new media, communications and social influence, 24Notion uniquely understands how to con...
WebRTC is bringing significant change to the communications landscape that will bridge the worlds of web and telephony, making the Internet the new standard for communications. Cloud9 took the road less traveled and used WebRTC to create a downloadable enterprise-grade communications platform that is changing the communication dynamic in the financial sector. In his session at @ThingsExpo, Leo Papadopoulos, CTO of Cloud9, will discuss the importance of WebRTC and how it enables companies to fo...
SYS-CON Events announced today TechTarget has been named “Media 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. TechTarget is the Web’s leading destination for serious technology buyers researching and making enterprise technology decisions. Its extensive global networ...
Korean Broadcasting System (KBS) will feature the upcoming 18th Cloud Expo | @ThingsExpo in a New York news documentary about the "New IT for the Future." The documentary will cover how big companies are transmitting or adopting the new IT for the future and will be filmed on the expo floor between June 7-June 9, 2016, at the Javits Center in New York City, New York. KBS has long been a leader in the development of the broadcasting culture of Korea. As the key public service broadcaster of Korea...
With major technology companies and startups seriously embracing IoT strategies, now is the perfect time to attend @ThingsExpo 2016 in New York and Silicon Valley. Learn what is going on, contribute to the discussions, and ensure that your enterprise is as "IoT-Ready" as it can be! Internet of @ThingsExpo, taking place Nov 3-5, 2015, at the Santa Clara Convention Center in Santa Clara, CA, is co-located with 17th Cloud Expo and will feature technical sessions from a rock star conference faculty ...
The 19th International Cloud Expo has announced that its Call for Papers is open. Cloud Expo, to be held November 1-3, 2016, at the Santa Clara Convention Center in Santa Clara, CA, brings together Cloud Computing, Big Data, Internet of Things, DevOps, Containers, Microservices and WebRTC to one location. With cloud computing driving a higher percentage of enterprise IT budgets every year, it becomes increasingly important to plant your flag in this fast-expanding business opportunity. Submit y...
There are several IoTs: the Industrial Internet, Consumer Wearables, Wearables and Healthcare, Supply Chains, and the movement toward Smart Grids, Cities, Regions, and Nations. There are competing communications standards every step of the way, a bewildering array of sensors and devices, and an entire world of competing data analytics platforms. To some this appears to be chaos. In this power panel at @ThingsExpo, moderated by Conference Chair Roger Strukhoff, panelists will discuss the vast to...
Internet of @ThingsExpo, taking place November 1-3, 2016, at the Santa Clara Convention Center in Santa Clara, CA, is co-located with the 19th International Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world and ThingsExpo New York Call for Papers is now open.