Welcome!

@CloudExpo Authors: Destiny Bertucci, Pat Romanski, Yeshim Deniz, Nate Vickery, Liz McMillan

Related Topics: PowerBuilder

PowerBuilder: Article

PBDJ Editorial — Introducing DataWindow.NET 2.0 and Looking Ahead

PBDJ Editorial — Introducing DataWindow.NET 2.0 and Looking Ahead

This month we'll take an in-depth look at the new features introduced or existing features enhanced in DataWindow.NET 2.0. In summary, DataWindow.NET 20 includes the following:

  • Support for the .NET Framework 2.0.
  • Accepts DataSets and DataTables as data sources (see Figure 1).
  • Allows indexer access (i.e., dot notation) to DataWindow data.
  • Extends the precision of the decimal datatype to 28 digits and lets them be used as DataWindow arguments.
  • Introduces new reporting properties and functionality, including auto-size height on all parts of a DataWindow and suppression of group headers on page breaks.
  • Introduces a new presentation style for Windows applications, the TreeView, for easily presenting and updating heirachical data.
  • Updates support for database connectivity, including ADO.NET-managed providers for ASE and Oracle and a native driver for ASE 15.
  • Adds a new DatePicker edit mask for putting calendar functionality into a data field.
  • Uses a script callback method so page naviation can be done in Web applications without a postback to the server.
  • Adds a Page Navigation Bar for Web applications.
  • Enhances the DropDownDataWindows used in Web applications.
  • Adds SelectRow, IsSelected, FindNextSelectedRow, and SetRowFocusIndicator methods.
  • Adds support for rendering the groupboxes and rectangles in Web applications.
  • Adds WebResourceFile enumeration for the JavaScriptOption so JavaScript files can be included as part of a resource file and URLs are generated automatically.
  • Updates icons.
That's not to say that DataWindow.NET can't stand further improvement. Sybase is already working on 2.5, which should add the following additional functionality:
  • Make the TreeView presentation style available for Web applications (currently it's only available for Windows applications).
  • Make the DataWindow Designer available as a plug-in for Visual Studio so it can be access directly in the IDE.
  • Master-Detail DataWindow.
  • Native support of auto-sort headers and auto-sizing column widths.
In addition, much needed enhancements include:
  • Web Services as a data source.
  • Support for localization.
  • Better graphing engine.
  • The ability to refer to resources (e.g., images) in a resource file.
  • The ability to pull images directly from a database.
  • Storing the DataWindow object syntax in resource files rather than PBLs.
  • Support for calling out to externally written .NET functions in computed fields and object property expressions.
  • DataWindow Designer's system tree should show the objects and columns in a DataWindow object like PowerBuilder's system tree does now.
  • A rich-text format edit style so text formatting can be applied to individual columns.
  • An argument's dialog for Drop Down DataWindows so they can be assigned to parent columns reducing the need for manual Drop Down DataWindow retrieval.
  • A TreeView presentation style that allows different data sources for each level in the hierarchy and delays retrieving child data until that child is expanded.
  • If a DataWindow object is assigned to a DataWindowControl or WebDataWindowControl, support intellisense operations for the properties of the DataWindow object.
Finally, DataWindow.NET needs to be restructured either to eliminate its dependence on unmanaged DLLs or the method used to locate those DLLs has to be enhanced. This is primarily an issue for Web applications, because currently you either have to deploy the unmanaged DLLs to a location in the system path or create a DWDOTNET20 environmental variable that points to their location. This is a departure from the normal methods used to deploy an ASP.NET application and severely limits the use of DataWindow.NET in situations where the Web site is hosted by a third party or the Web servers are managed by an internal infrastructure department that's inflexible. Along those same lines, the method used to generated PDF needs to be modified so it doesn't rely on the installation of a printer driver. Once again, it needs a deploy that doesn't not require special privileges on the server.

All that is to say that the latest version of DataWindow.NET 2.0 provides tremendous functionality, and we look forward to the additional functionality later versions will introduce.

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.


@CloudExpo Stories
You know you need the cloud, but you’re hesitant to simply dump everything at Amazon since you know that not all workloads are suitable for cloud. You know that you want the kind of ease of use and scalability that you get with public cloud, but your applications are architected in a way that makes the public cloud a non-starter. You’re looking at private cloud solutions based on hyperconverged infrastructure, but you’re concerned with the limits inherent in those technologies.
In his keynote at 18th Cloud Expo, Andrew Keys, Co-Founder of ConsenSys Enterprise, provided an overview of the evolution of the Internet and the Database and the future of their combination – the Blockchain. Andrew Keys is Co-Founder of ConsenSys Enterprise. He comes to ConsenSys Enterprise with capital markets, technology and entrepreneurial experience. Previously, he worked for UBS investment bank in equities analysis. Later, he was responsible for the creation and distribution of life settle...
Coca-Cola’s Google powered digital signage system lays the groundwork for a more valuable connection between Coke and its customers. Digital signs pair software with high-resolution displays so that a message can be changed instantly based on what the operator wants to communicate or sell. In their Day 3 Keynote at 21st Cloud Expo, Greg Chambers, Global Group Director, Digital Innovation, Coca-Cola, and Vidya Nagarajan, a Senior Product Manager at Google, discussed how from store operations and ...
In his session at 21st Cloud Expo, Raju Shreewastava, founder of Big Data Trunk, provided a fun and simple way to introduce Machine Leaning to anyone and everyone. He solved a machine learning problem and demonstrated an easy way to be able to do machine learning without even coding. Raju Shreewastava is the founder of Big Data Trunk (www.BigDataTrunk.com), a Big Data Training and consulting firm with offices in the United States. He previously led the data warehouse/business intelligence and B...
Blockchain. A day doesn’t seem to go by without seeing articles and discussions about the technology. According to PwC executive Seamus Cushley, approximately $1.4B has been invested in blockchain just last year. In Gartner’s recent hype cycle for emerging technologies, blockchain is approaching the peak. It is considered by Gartner as one of the ‘Key platform-enabling technologies to track.’ While there is a lot of ‘hype vs reality’ discussions going on, there is no arguing that blockchain is b...
"IBM is really all in on blockchain. We take a look at sort of the history of blockchain ledger technologies. It started out with bitcoin, Ethereum, and IBM evaluated these particular blockchain technologies and found they were anonymous and permissionless and that many companies were looking for permissioned blockchain," stated René Bostic, Technical VP of the IBM Cloud Unit in North America, in this SYS-CON.tv interview at 21st Cloud Expo, held Oct 31 – Nov 2, 2017, at the Santa Clara Conventi...
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, whic...
The cloud era has reached the stage where it is no longer a question of whether a company should migrate, but when. Enterprises have embraced the outsourcing of where their various applications are stored and who manages them, saving significant investment along the way. Plus, the cloud has become a defining competitive edge. Companies that fail to successfully adapt risk failure. The media, of course, continues to extol the virtues of the cloud, including how easy it is to get there. Migrating...
The need for greater agility and scalability necessitated the digital transformation in the form of following equation: monolithic to microservices to serverless architecture (FaaS). To keep up with the cut-throat competition, the organisations need to update their technology stack to make software development their differentiating factor. Thus microservices architecture emerged as a potential method to provide development teams with greater flexibility and other advantages, such as the abili...
Product connectivity goes hand and hand these days with increased use of personal data. New IoT devices are becoming more personalized than ever before. In his session at 22nd Cloud Expo | DXWorld Expo, Nicolas Fierro, CEO of MIMIR Blockchain Solutions, will discuss how in order to protect your data and privacy, IoT applications need to embrace Blockchain technology for a new level of product security never before seen - or needed.
Leading companies, from the Global Fortune 500 to the smallest companies, are adopting hybrid cloud as the path to business advantage. Hybrid cloud depends on cloud services and on-premises infrastructure working in unison. Successful implementations require new levels of data mobility, enabled by an automated and seamless flow across on-premises and cloud resources. In his general session at 21st Cloud Expo, Greg Tevis, an IBM Storage Software Technical Strategist and Customer Solution Architec...
The use of containers by developers -- and now increasingly IT operators -- has grown from infatuation to deep and abiding love. But as with any long-term affair, the honeymoon soon leads to needing to live well together ... and maybe even getting some relationship help along the way. And so it goes with container orchestration and automation solutions, which are rapidly emerging as the means to maintain the bliss between rapid container adoption and broad container use among multiple cloud host...
Blockchain is a shared, secure record of exchange that establishes trust, accountability and transparency across business networks. Supported by the Linux Foundation's open source, open-standards based Hyperledger Project, Blockchain has the potential to improve regulatory compliance, reduce cost as well as advance trade. Are you curious about how Blockchain is built for business? In her session at 21st Cloud Expo, René Bostic, Technical VP of the IBM Cloud Unit in North America, discussed the b...
Imagine if you will, a retail floor so densely packed with sensors that they can pick up the movements of insects scurrying across a store aisle. Or a component of a piece of factory equipment so well-instrumented that its digital twin provides resolution down to the micrometer.
While some developers care passionately about how data centers and clouds are architected, for most, it is only the end result that matters. To the majority of companies, technology exists to solve a business problem, and only delivers value when it is solving that problem. 2017 brings the mainstream adoption of containers for production workloads. In his session at 21st Cloud Expo, Ben McCormack, VP of Operations at Evernote, discussed how data centers of the future will be managed, how the p...
As DevOps methodologies expand their reach across the enterprise, organizations face the daunting challenge of adapting related cloud strategies to ensure optimal alignment, from managing complexity to ensuring proper governance. How can culture, automation, legacy apps and even budget be reexamined to enable this ongoing shift within the modern software factory? In her Day 2 Keynote at @DevOpsSummit at 21st Cloud Expo, Aruna Ravichandran, VP, DevOps Solutions Marketing, CA Technologies, was jo...
"Since we launched LinuxONE we learned a lot from our customers. More than anything what they responded to were some very unique security capabilities that we have," explained Mark Figley, Director of LinuxONE Offerings at IBM, in this SYS-CON.tv interview at 21st Cloud Expo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
When shopping for a new data processing platform for IoT solutions, many development teams want to be able to test-drive options before making a choice. Yet when evaluating an IoT solution, it’s simply not feasible to do so at scale with physical devices. Building a sensor simulator is the next best choice; however, generating a realistic simulation at very high TPS with ease of configurability is a formidable challenge. When dealing with multiple application or transport protocols, you would be...
Nordstrom is transforming the way that they do business and the cloud is the key to enabling speed and hyper personalized customer experiences. In his session at 21st Cloud Expo, Ken Schow, VP of Engineering at Nordstrom, discussed some of the key learnings and common pitfalls of large enterprises moving to the cloud. This includes strategies around choosing a cloud provider(s), architecture, and lessons learned. In addition, he covered some of the best practices for structured team migration an...
Smart cities have the potential to change our lives at so many levels for citizens: less pollution, reduced parking obstacles, better health, education and more energy savings. Real-time data streaming and the Internet of Things (IoT) possess the power to turn this vision into a reality. However, most organizations today are building their data infrastructure to focus solely on addressing immediate business needs vs. a platform capable of quickly adapting emerging technologies to address future ...