Welcome!


Top Stories

The DropDownDataWindow (DDDW) edit style is one of PowerBuilder's outstanding features. Yes, I know there are a lot of new and exciting capabilities in the upcoming release of PowerBuilder, but in this article I'll try to solve some of the current problems with the existing features that are popping up in nearly every project I've seen. Here I'll focus on DropDownDataWindows, including: How to get started with DDDWs Filtering DDDWs without losing the display value in other rows Catching the collapsing of a DDDW Trapping the cursor keys in a DDDW Autocomplete DDDW values Getting Started The basics are well covered in the PowerBuilder User's Manual, but if you still have problems defining them look at Figure 1. Click on the column you want and its edit style (yes, click on edit on the properties) as DDDW (choose DropDownDW as Style Type). Next, choose your DataWindow, ... (more)

Cloud Expo 2011 East To Attract 10,000 Delegates and 200 Exhibitors

SYS-CON Events announced today that the 8th International Cloud Expo will take place June 6-9, 2011, in New York City. The International Cloud Computing Conference & Expo series is the world's leading Cloud-focused event and is held three times a year, in New York, Silicon Valley and in Europe. Over 600 corporate sponsors and 10,000 industry professionals have participated in Cloud Computing Expo since its inception, more than all other Cloud-related events put together. Cloud Computing Expo 2011 East Call for Papers Deadline November 30, 2010 - SUBMIT YOUR SPEAKING PROPOSAL TODAY! The four-day event will offer a rich array of sessions led by exceptional speakers about the business and technical value of cloud computing with more than 150 sponsors and exhibitors and over 5,000 estimated delegates from well over 48 different countries. Explore Cloud Expo Sponsorship &... (more)

Mobile Business Objects: MBO Concept and Creation

The design cornerstone of the Sybase's MEAP the Sybase Unwired Platform is the Mobile Business Object (MBO). The MBO encapsulates the business process logic and data into a reusable unit that can be accessed from a variety of clients. The development can take two approaches,  firstly the Top-Down approach, which creates the MBO based upon how the client wants to use it... eventually binding to the data source. Secondly, the Bottom-UP approach which uses the data source to automatically bind and create the MBO. Both use the Unwired tooling and are easy to create, with similar steps listed below Connect to the back-end data sources that need to be mobilized, via the Unwired tooling Connect the Unwired tooling to the Unwired Server Create a Mobile Application Project Create the MBO from the data source via wizards or Create the MBO attributes and Create, Update, Delete... (more)

The March Goes on for the iPad 2 in 2011

I have been using Apple's iPad since it was launched and am totally hooked on using it whilst out on the road in a personal & business basis. So yesterday we had the announcement of Apple's iPad2 and I was glued, like most of the internet, to the live feeds etc. Firstly, I have to say what a delight it was to see Steve Jobs come back for the day to announce the updated device. Secondly the update is not massive, it is not a game changer like the introduction of the iPad in 2011, but it is still respectful enough for iPad converts to upgrade and for the iPad2 to continue its march ahead in 2011 (excuse the pun March... as we are looking towards release on March 11 in the US and March 25 in other countries). What this revision does is to push it further ahead, maintaining its lead in the Tablet Market, which is definitely here to stay.... Along with defining the stand... (more)

SAP Executive Interview with Raj Nathan

At Mobile World Congress last week in Barcelona, I had the great fortune to interview... Raj Nathan, EVP and CMO, Sybase, an SAP company As Executive Vice President and Chief Marketing Officer of Worldwide Marketing and Business Solutions Operations, Dr. Raj Nathan is responsible for all marketing initiatives for Sybase and its subsidiaries, Sybase iAnywhere and Sybase 365. In this role, Dr. Nathan leads a global marketing organization setting Sybase's technology direction and go-to-market initiatives. Under his leadership, Sybase continues to be recognized for visionary technology that meets the direct needs of customers and partners. Dr. Nathan’s work experience has taken him around the globe, and has run the gamut from hardware to software, and from large companies to small including Unisys and Siemens Pyramid. Raj earned his doctorate and master’s degree from I... (more)

DataWindow Reporting

In my early PowerBuilder days, I was very impressed with how easy it was to create and format DataWindows for either online or printed reports. At its easiest, a simple print method is required to send a "What you see is what you get" version of the DataWindow to the printer. Even when the printed version of a DataWindow is different from the visual one, a simple ShareData() function would be all that is required. What took a while, however, was learning how to display and print reports that either had a master/detail relationship or no relationship at all. In short, what if I need to create or print a report that's based on different SQL statements? There are two solutions to this problem: 1.   Create a master (or base) DataWindow, then add additional nested DataWindows (nested reports). 2.   Create a report by using the DataWindow composite presentation style. Neste... (more)

Fixing Ugly Grid Borders

It's an aesthetic thing. When you click on a grid DataWindow label and change an attribute, it acquires what are formally termed UGBs - Ugly Grid Borders. They appear between the labels in the grid header. The vertical lines are thin or thick. Inconsistency! Thick borders! Yuck! Figure 1 illustrates the problem. There are thick borders between the Nickname and Last Name labels and between the Company and Nickname columns; there are thin borders between the Company and Nickname labels and between the Nickname and Last Name columns. Figure 2 shows the same DataWindow with the UGBs fixed. All the borders are thin in Figure 2, which looks a lot better. The UGB problem is characteristic of 3D objects on grids. The detail columns in the figures are 3D lowered. You don't have to worry about UGBs if all your DWO objects are flat. With PB6 and earlier releases it was easy to ... (more)

DataWindow.NET How To: DataWindow Formatting

Last month we saw how DataWindow.NET technology can be a benefit when used for data presentation and data access in a Windows Forms (WinForms) application. This month we're going to look at how DataWindow.NET technology is a simpler but more powerful way of formatting data in the presentation layer. Once again, we'll be taking a sample application provided by Microsoft for .NET and implementing it using DataWindow.NET technology. In this case, we're using the Visual Basic .NET Code Sample: DataGrid Formatting sample application available at www.microsoft.com/downloads/details.aspx? FamilyID=28fd458f-5571-42b4-a2fe-09b69ddf0863&displaylang=en. As with last month's article, the original sample was written to connect to the Microsoft Northwind sample database. So you'll need MSDE or SQL Server with that sample database installed if you want to try it out for yourself. ... (more)

PowerBuilder History - How Did It Evolve?

I have been asked many times by various clients, students, and the IT curious about PowerBuilder: When did Sybase develop the product and how did it evolve? I keep telling this story and answering e-mails on the subject. I am now to the point where I have decided that I should have PBDJ formally publish this story for posterity. This story is solely from my own personal perspective and I'm sure that I may have a somewhat distorted view of time and space (which keeps getting worse at my age). But anyway, here is a perspective of how life (as a DataWindow) began. Episode I - The Phantom Product In a galaxy, far, far away... before Sybase... PowerBuilder was developed as a prototype by Cullinet Database Systems of Boston. Cullinet was the developer of the IDMS DBMS and ADS-Online (Application Development System). IDMS was originally developed by BF Goodrich, the tire co... (more)

Chris Pollach's PowerBuilder Blog: "SQLXTRACT New Release!"

SQLXTRACT - New Release! I am pleased to announce that Software Tool & Die Inc. has just released a new version of the SQLXtract utility (10.2.1) that reverse engineers Sybase's proprietary SQL format (PBSELECT) into ANSI, PL/SQL or TransAct SQL from the "DataWindow" object. The new version of the SQLXtract utility was mainly revised to allow it to reverse engineer the source code from a Unicode based library vs.. an ANSI format previously. The output of SQLXTract is a textual .SQL file that can be input directly into products like Quest Central (aka SQLExpert) for further analysis. I have successfully tested the new version of SQLXTract with Sybase's ASE 15 and Microsoft's SQLServer2005 DBMS versions of Quest Central (by Quest Software). SQLXTract will also be able to handle the new Microsoft DB access mechanisms, they are: OLE-DB and ADO.net. Support for the ODBC db... (more)

Overriding the PowerBuilder MessageBox() Function

A typical PowerBuilder application has a few zillion MessageBox() calls. This article explains how you can roll your own MessageBox() function, replacing the native PowerBuilder MB() function with your code. Why would you want to write your own MB() function? The general reason is to give you a "hook" where you can write code to modify the native Windows MB() behavior. Let's face it, the MB() has evolved about as rapidly as the shark, like, not at all since PB 1.0. And the MB() needs to evolve. Among the native MB()'s deficits: It provides no way to get the text: you can't copy the text on a MB() into the clipboard. It handles long messages badly: the buttons are below the bottom of the screen; and Most aggravating, the PB MB() doesn't display if either its title or text is NULL! How many times have you been burned by that last "feature"? Doh! For these and other rea... (more)

Latest PowerBuilder News
SAP AG on Wednesday announced new capabilities for the SAP Business ByDesign® solution, reaffirming its commitment to provide independent companies and subsidiaries worldwide a flexible, cost-effective mid-market cloud enterprise resource planning (ERP) suite. The updates leverage SAP ...
Tuesday night, SAP confirmed that they will be presenting the official PB Roadmap during the PB World Tour in Europe. After months of speculation, confirmation arrived that SAP will officially support PowerBuilder, and that a new version will be released containing additional features....
Behind every cloud service or cloud-based solution, there are real people... A robust ecosystem of solutions providers has emerged around cloud computing. But who are the CEOs & CTOs behind those providers, who are the internal and external entrepreneurs driving companies involved i...
Jim Hagemann Snabe, whose contract was supposed to run through 2017, has apparently tired of his half of SAP’s CEO job and will be stepping down next May leaving the post solely to Bill McDermott, a 51-year-old American. The plan then is for the 47-year-old Dane, who’s been responsib...
Nowadays IT has the challenge to keep the core business systems running smoothly, bringing in as little disruption as possible while at the same time meeting the constantly growing LoB demands for new features and improved ways to access data. To make it harder – with the growth of mob...
This book is both board and deep. Meaning it covers a ton of topics and goes in-depth on all of them. This book is great for the beginner, but also has a lot of advanced material. After a nice introduction that explains the structure of the book the author starts off Part 1 covering t...
Best Recent Articles on Cloud Computing & Big Data Topics
As we enter a new year, it is time to look back over the past year and resolve to improve upon it. In 2014, we will see more service providers resolve to add more personalization in enterprise technology. Below are seven predictions about what will drive this trend toward personalization.
IT organizations face a growing demand for faster innovation and new applications to support emerging opportunities in social, mobile, growth markets, Big Data analytics, mergers and acquisitions, strategic partnerships, and more. This is great news because it shows that IT continues to be a key stakeholder in delivering business service innovation. However, it also means that IT must deliver new innovation despite flat budgets, while maintaining existing services that grow more complex every day.
Cloud computing is transforming the way businesses think about and leverage technology. As a result, the general understanding of cloud computing has come a long way in a short time. However, there are still many misconceptions about what cloud computing is and what it can do for businesses that adopt this game-changing computing model. In this exclusive Q&A with Cloud Expo Conference Chair Jeremy Geelan, Rex Wang, Vice President of Product Marketing at Oracle, discusses and dispels some of the common myths about cloud computing that still exist today.
Despite the economy, cloud computing is doing well. Gartner estimates the cloud market will double by 2016 to $206 billion. The time for dabbling in the cloud is over! The 14th International Cloud Expo, co-located with 5th International Big Data Expo and 3rd International SDN Expo, to be held June 10-12, 2014, at the Javits Center in New York City, N.Y. announces that its Call for Papers is now open. Topics include all aspects of providing or using massively scalable IT-related capabilities as a service using Internet technologies (see suggested topics below). Cloud computing helps IT cut infrastructure costs while adding new features and services to grow core businesses. Clouds can help grow margins as costs are cut back but service offerings are expanded. Help plant your flag in the fast-expanding business opportunity that is The Cloud, Big Data and Software-Defined Networking: submit your speaking proposal today!
What do you get when you combine Big Data technologies….like Pig and Hive? A flying pig? No, you get a “Logical Data Warehouse.” In 2012, Infochimps (now CSC) leveraged its early use of stream processing, NoSQLs, and Hadoop to create a design pattern which combined real-time, ad-hoc, and batch analytics. This concept of combining the best-in-breed Big Data technologies will continue to advance across the industry until the entire legacy (and proprietary) data infrastructure stack will be replaced with a new (and open) one.
While unprecedented technological advances have been made in healthcare in areas such as genomics, digital imaging and Health Information Systems, access to this information has been not been easy for both the healthcare provider and the patient themselves. Regulatory compliance and controls, information lock-in in proprietary Electronic Health Record systems and security concerns have made it difficult to share data across health care providers.
Cloud Expo, Inc. has announced today that Vanessa Alvarez has been named conference chair of Cloud Expo® 2014. 14th International Cloud Expo will take place on June 10-12, 2014, at the Javits Center in New York City, New York, and 15th International Cloud Expo® will take place on November 4-6, 2014, at the Santa Clara Convention Center in Santa Clara, CA.
12th International Cloud Expo, held on June 10–13, 2013 at the Javits Center in New York City, featured four content-packed days with a rich array of sessions about the business and technical value of cloud computing led by exceptional speakers from every sector of the cloud computing ecosystem. The Cloud Expo series is the fastest-growing Enterprise IT event in the past 10 years, devoted to every aspect of delivering massively scalable enterprise IT as a service.
Ulitzer.com announced "the World's 30 most influential Cloud bloggers," who collectively generated more than 24 million Ulitzer page views. Ulitzer's annual "most influential Cloud bloggers" list was announced at Cloud Expo, which drew more delegates than all other Cloud-related events put together worldwide. "The world's 50 most influential Cloud bloggers 2010" list will be announced at the Cloud Expo 2010 East, which will take place April 19-21, 2010, at the Jacob Javitz Convention Center, in New York City, with more than 5,000 expected to attend.
It's a simple fact that the better sales reps understand their prospects' intentions, preferences and pain points during calls, the more business they'll close. Each day, as your prospects interact with websites and social media platforms, their behavioral data profile is expanding. It's now possible to gain unprecedented insight into prospects' content preferences, product needs and budget. We hear a lot about how valuable Big Data is to sales and marketing teams. But data itself is only valuable when it's part of a bigger story, made visible in the right context.
Cloud Expo, Inc. has announced today that Larry Carvalho has been named Tech Chair of Cloud Expo® 2014. 14th International Cloud Expo will take place on June 10-12, 2014, at the Javits Center in New York City, New York, and 15th International Cloud Expo® will take place on November 4-6, 2014, at the Santa Clara Convention Center in Santa Clara, CA.
Everyone talks about a cloud-first or mobile-first strategy. It's the trend du jour, and for good reason as these innovative technologies have revolutionized an industry and made savvy companies a lot of money. But consider for a minute what's emerging with the Age of Context and the Internet of Things. Devices, interfaces, everyday objects are becoming endowed with computing smarts. This is creating an unprecedented focus on the Application Programming Interface (API) as developers seek to connect these devices and interfaces to create new supporting services and hybrids. I call this trend the move toward an API-first business model and strategy.
We live in a world that requires us to compete on our differential use of time and information, yet only a fraction of information workers today have access to the analytical capabilities they need to make better decisions. Now, with the advent of a new generation of embedded business intelligence (BI) platforms, cloud developers are disrupting the world of analytics. They are using these new BI platforms to inject more intelligence into the applications business people use every day. As a result, data-driven decision-making is finally on track to become the rule, not the exception.