Welcome!

API Journal Authors: Rishi Bhargava, Pat Romanski, Liz McMillan, Christopher Keene, Elizabeth White

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 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, Digital Transformation, 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 opportuni...
IoT is rapidly changing the way enterprises are using data to improve business decision-making. In order to derive business value, organizations must unlock insights from the data gathered and then act on these. In their session at @ThingsExpo, Eric Hoffman, Vice President at EastBanc Technologies, and Peter Shashkin, Head of Development Department at EastBanc Technologies, discussed how one organization leveraged IoT, cloud technology and data analysis to improve customer experiences and effi...
The Internet of Things will challenge the status quo of how IT and development organizations operate. Or will it? Certainly the fog layer of IoT requires special insights about data ontology, security and transactional integrity. But the developmental challenges are the same: People, Process and Platform. In his session at @ThingsExpo, Craig Sproule, CEO of Metavine, demonstrated how to move beyond today's coding paradigm and shared the must-have mindsets for removing complexity from the develo...
SYS-CON Events announced today that MangoApps will exhibit at the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. 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.
The IETF draft standard for M2M certificates is a security solution specifically designed for the demanding needs of IoT/M2M applications. In his session at @ThingsExpo, Brian Romansky, VP of Strategic Technology at TrustPoint Innovation, explained how M2M certificates can efficiently enable confidentiality, integrity, and authenticity on highly constrained devices.
“delaPlex Software provides software outsourcing services. We have a hybrid model where we have onshore developers and project managers that we can place anywhere in the U.S. or in Europe,” explained Manish Sachdeva, CEO at delaPlex Software, in this SYS-CON.tv interview at @ThingsExpo, held June 7-9, 2016, at the Javits Center in New York City, NY.
The IoT is changing the way enterprises conduct business. In his session at @ThingsExpo, Eric Hoffman, Vice President at EastBanc Technologies, discussed how businesses can gain an edge over competitors by empowering consumers to take control through IoT. He cited examples such as a Washington, D.C.-based sports club that leveraged IoT and the cloud to develop a comprehensive booking system. He also highlighted how IoT can revitalize and restore outdated business models, making them profitable ...
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 Silicon Valley Call for Papers is now open.
We all know the latest numbers: Gartner, Inc. forecasts that 6.4 billion connected things will be in use worldwide in 2016, up 30 percent from last year, and will reach 20.8 billion by 2020. We're rapidly approaching a data production of 40 zettabytes a day – more than we can every physically store, and exabytes and yottabytes are just around the corner. For many that’s a good sign, as data has been proven to equal money – IF it’s ingested, integrated, and analyzed fast enough. Without real-ti...
SYS-CON Events announced today that 910Telecom will exhibit at the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. Housed in the classic Denver Gas & Electric Building, 910 15th St., 910Telecom is a carrier-neutral telecom hotel located in the heart of Denver. Adjacent to CenturyLink, AT&T, and Denver Main, 910Telecom offers connectivity to all major carriers, Internet service providers, Internet backbones and ...
Big Data, cloud, analytics, contextual information, wearable tech, sensors, mobility, and WebRTC: together, these advances have created a perfect storm of technologies that are disrupting and transforming classic communications models and ecosystems. In his session at @ThingsExpo, Erik Perotti, Senior Manager of New Ventures on Plantronics’ Innovation team, provided an overview of this technological shift, including associated business and consumer communications impacts, and opportunities it ...
You think you know what’s in your data. But do you? Most organizations are now aware of the business intelligence represented by their data. Data science stands to take this to a level you never thought of – literally. The techniques of data science, when used with the capabilities of Big Data technologies, can make connections you had not yet imagined, helping you discover new insights and ask new questions of your data. In his session at @ThingsExpo, Sarbjit Sarkaria, data science team lead ...
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, discussed the importance of WebRTC and how it enables companies to focus...
ReadyTalk has expanded the capabilities of the FoxDen collaboration platform announced late last year to include FoxDen Connect, an in-room video collaboration experience that launches with a single touch. With FoxDen Connect, users can now not only engage in HD video conferencing between iOS and Android mobile devices or Chrome browsers, but also set up in-person meeting rooms for video interactions. A host’s mobile device automatically recognizes the presence of a meeting room via beacon tech...
Manufacturers are embracing the Industrial Internet the same way consumers are leveraging Fitbits – to improve overall health and wellness. Both can provide consistent measurement, visibility, and suggest performance improvements customized to help reach goals. Fitbit users can view real-time data and make adjustments to increase their activity. In his session at @ThingsExpo, Mark Bernardo Professional Services Leader, Americas, at GE Digital, discussed how leveraging the Industrial Internet a...
On Dice.com, the number of job postings asking for skill in Amazon Web Services increased 76 percent between June 2015 and June 2016. Salesforce.com saw its own skill mentions increase 37 percent, while DevOps and Cloud rose 35 percent and 28 percent, respectively. Even as they expand their presence in the cloud, companies are also looking for tech professionals who can manage projects, crunch data, and figure out how to make systems run more autonomously. Mentions of ‘data science’ as a skill ...
IoT generates lots of temporal data. But how do you unlock its value? You need to discover patterns that are repeatable in vast quantities of data, understand their meaning, and implement scalable monitoring across multiple data streams in order to monetize the discoveries and insights. Motif discovery and deep learning platforms are emerging to visualize sensor data, to search for patterns and to build application that can monitor real time streams efficiently. In his session at @ThingsExpo, ...
"delaPlex is a software development company. We do team-based outsourcing development," explained Mark Rivers, COO and Co-founder of delaPlex Software, in this SYS-CON.tv interview at 18th Cloud Expo, held June 7-9, 2016, at the Javits Center in New York City, NY.
SYS-CON Events announced today that LeaseWeb USA, a cloud Infrastructure-as-a-Service (IaaS) provider, will exhibit at the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. LeaseWeb is one of the world's largest hosting brands. The company helps customers define, develop and deploy IT infrastructure tailored to their exact business needs, by combining various kinds cloud solutions.
Amazon has gradually rolled out parts of its IoT offerings in the last year, but these are just the tip of the iceberg. In addition to optimizing their back-end AWS offerings, Amazon is laying the ground work to be a major force in IoT – especially in the connected home and office. Amazon is extending its reach by building on its dominant Cloud IoT platform, its Dash Button strategy, recently announced Replenishment Services, the Echo/Alexa voice recognition control platform, the 6-7 strategic...