Welcome!

@CloudExpo Authors: Yeshim Deniz, Pat Romanski, Liz McMillan, Elizabeth White, Charles Araujo

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
Without a clear strategy for cost control and an architecture designed with cloud services in mind, costs and operational performance can quickly get out of control. To avoid multiple architectural redesigns requires extensive thought and planning. Boundary (now part of BMC) launched a new public-facing multi-tenant high resolution monitoring service on Amazon AWS two years ago, facing challenges and learning best practices in the early days of the new service.
Digital Transformation is much more than a buzzword. The radical shift to digital mechanisms for almost every process is evident across all industries and verticals. This is often especially true in financial services, where the legacy environment is many times unable to keep up with the rapidly shifting demands of the consumer. The constant pressure to provide complete, omnichannel delivery of customer-facing solutions to meet both regulatory and customer demands is putting enormous pressure on...
The best way to leverage your CloudEXPO | DXWorldEXPO presence as a sponsor and exhibitor is to plan your news announcements around our events. The press covering CloudEXPO | DXWorldEXPO will have access to these releases and will amplify your news announcements. More than two dozen Cloud companies either set deals at our shows or have announced their mergers and acquisitions at CloudEXPO. Product announcements during our show provide your company with the most reach through our targeted audienc...
With 10 simultaneous tracks, keynotes, general sessions and targeted breakout classes, @CloudEXPO and DXWorldEXPO are two of the most important technology events of the year. Since its launch over eight years ago, @CloudEXPO and DXWorldEXPO have presented a rock star faculty as well as showcased hundreds of sponsors and exhibitors!
DXWorldEXPO LLC announced today that All in Mobile, a mobile app development company from Poland, will exhibit at the 22nd International CloudEXPO | DXWorldEXPO. All In Mobile is a mobile app development company from Poland. Since 2014, they maintain passion for developing mobile applications for enterprises and startups worldwide.
Both SaaS vendors and SaaS buyers are going “all-in” to hyperscale IaaS platforms such as AWS, which is disrupting the SaaS value proposition. Why should the enterprise SaaS consumer pay for the SaaS service if their data is resident in adjacent AWS S3 buckets? If both SaaS sellers and buyers are using the same cloud tools, automation and pay-per-transaction model offered by IaaS platforms, then why not host the “shrink-wrapped” software in the customers’ cloud? Further, serverless computing, cl...
JETRO showcased Japan Digital Transformation Pavilion at SYS-CON's 21st International Cloud Expo® at the Santa Clara Convention Center in Santa Clara, CA. The Japan External Trade Organization (JETRO) is a non-profit organization that provides business support services to companies expanding to Japan. With the support of JETRO's dedicated staff, clients can incorporate their business; receive visa, immigration, and HR support; find dedicated office space; identify local government subsidies; get...
The current age of digital transformation means that IT organizations must adapt their toolset to cover all digital experiences, beyond just the end users’. Today’s businesses can no longer focus solely on the digital interactions they manage with employees or customers; they must now contend with non-traditional factors. Whether it's the power of brand to make or break a company, the need to monitor across all locations 24/7, or the ability to proactively resolve issues, companies must adapt to...
"We view the cloud not as a specific technology but as a way of doing business and that way of doing business is transforming the way software, infrastructure and services are being delivered to business," explained Matthew Rosen, CEO and Director at Fusion, in this SYS-CON.tv interview at 18th Cloud Expo (http://www.CloudComputingExpo.com), held June 7-9 at the Javits Center in New York City, NY.
DXWorldEXPO LLC announced today that the upcoming DXWorldEXPO | CloudEXPO New York event will feature 10 companies from Poland to participate at the "Poland Digital Transformation Pavilion" on November 12-13, 2018.
In his Opening Keynote at 21st Cloud Expo, John Considine, General Manager of IBM Cloud Infrastructure, led attendees through the exciting evolution of the cloud. He looked at this major disruption from the perspective of technology, business models, and what this means for enterprises of all sizes. John Considine is General Manager of Cloud Infrastructure Services at IBM. In that role he is responsible for leading IBM’s public cloud infrastructure including strategy, development, and offering m...
As data explodes in quantity, importance and from new sources, the need for managing and protecting data residing across physical, virtual, and cloud environments grow with it. Managing data includes protecting it, indexing and classifying it for true, long-term management, compliance and E-Discovery. Commvault can ensure this with a single pane of glass solution – whether in a private cloud, a Service Provider delivered public cloud or a hybrid cloud environment – across the heterogeneous enter...
We all know that end users experience the internet primarily with mobile devices. From an app development perspective, we know that successfully responding to the needs of mobile customers depends on rapid DevOps – failing fast, in short, until the right solution evolves in your customers' relationship to your business. Whether you’re decomposing an SOA monolith, or developing a new application cloud natively, it’s not a question of using microservices - not doing so will be a path to eventual ...
"DivvyCloud as a company set out to help customers automate solutions to the most common cloud problems," noted Jeremy Snyder, VP of Business Development at DivvyCloud, in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
More and more brands have jumped on the IoT bandwagon. We have an excess of wearables – activity trackers, smartwatches, smart glasses and sneakers, and more that track seemingly endless datapoints. However, most consumers have no idea what “IoT” means. Creating more wearables that track data shouldn't be the aim of brands; delivering meaningful, tangible relevance to their users should be. We're in a period in which the IoT pendulum is still swinging. Initially, it swung toward "smart for smart...
DXWorldEXPO LLC announced today that ICC-USA, a computer systems integrator and server manufacturing company focused on developing products and product appliances, will exhibit at the 22nd International CloudEXPO | DXWorldEXPO. DXWordEXPO New York 2018, colocated with CloudEXPO New York 2018 will be held November 11-13, 2018, in New York City. ICC is a computer systems integrator and server manufacturing company focused on developing products and product appliances to meet a wide range of ...
We all know that end users experience the Internet primarily with mobile devices. From an app development perspective, we know that successfully responding to the needs of mobile customers depends on rapid DevOps – failing fast, in short, until the right solution evolves in your customers' relationship to your business. Whether you’re decomposing an SOA monolith, or developing a new application cloud natively, it’s not a question of using microservices – not doing so will be a path to eventual b...
Major trends and emerging technologies – from virtual reality and IoT, to Big Data and algorithms – are helping organizations innovate in the digital era. However, to create real business value, IT must think beyond the ‘what’ of digital transformation to the ‘how’ to harness emerging trends, innovation and disruption. Architecture is the key that underpins and ties all these efforts together. In the digital age, it’s important to invest in architecture, extend the enterprise footprint to the cl...
Sanjeev Sharma Joins November 11-13, 2018 @DevOpsSummit at @CloudEXPO New York Faculty. Sanjeev Sharma is an internationally known DevOps and Cloud Transformation thought leader, technology executive, and author. Sanjeev's industry experience includes tenures as CTO, Technical Sales leader, and Cloud Architect leader. As an IBM Distinguished Engineer, Sanjeev is recognized at the highest levels of IBM's core of technical leaders.
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 ...
As Cybric's Chief Technology Officer, Mike D. Kail is responsible for the strategic vision and technical direction of the platform. Prior to founding Cybric, Mike was Yahoo's CIO and SVP of Infrastructure, where he led the IT and Data Center functions for the company. He has more than 24 years of IT Operations experience with a focus on highly-scalable architectures.