Deanne M. Chance

Subscribe to Deanne M. Chance: eMailAlertsEmail Alerts
Get Deanne M. Chance: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn


Top Stories by Deanne M. Chance

We begin this article by asking the question, why would you want to add caller ID to your PowerBuilder applications anyway? I can think of about a handful of applications for it, mostly revolving around picking a phone number and querying a database. For example, "Good morning, Chance, will you be ordering the cheese and sausage pizza again?" Or perhaps a database of people, some whom you might not like, just to have your modem hang up on them. The possibilities are endless. First some introductions. How does caller ID information get relayed from Ma Bell to your phone or modem anyway? Modems use a technique called Frequency Shift Keying to transmit information over a phone line. One tone represents a binary 1, while a nother represents a binary zero. A modem changes frequencies depending on whether it wants to send a 1 or a 0. To send caller ID information to your... (more)

Publishing .NET Web Services Using SQL Anywhere 10.0.1

In this article we're going to take a database and create our own mini version of an "Amazon-like" item lookup. That is to say, any .NET or .NET-compatible client will be able to look up items in our database via the Web by simply providing a UPC. This article will show you how. To complete this project, you'll need a few items: -  SQL Anywhere 10.0.1 or higher. Here is a free developer edition. -  Visual Studio 2005 -  Internet connection -  Some time to learn! Note: This article assumes some knowledge of how to create ODBC connections and how to type in commands in iSQL. If you're no... (more)

Integrate Real-Time GPS Data Into Your PowerBuilder Applications

We begin this article by asking the question: Why would you want to integrate real-time GPS data into your PowerBuilder applications anyway? After all, it's not likely you are going to connect a GPS receiver to your desktop computer and ask yourself where you are currently located. (At least I hope not!) More likely, you will be utilizing some sort of field service application where you need to know how to get from point A to point B, for example, an insurance assessor who needs to know how to get to the next accident site. For this, the user might use a tablet PC connected to a... (more)

A Real-Time Physical Inventory Solution Using PocketBuilder, ASA, and a Wi-Fi Connection

Why do a physical inventory? A physical inventory count is necessary to reconcile the quantity on hand stored in a database versus what is really on the shelf. In a retail environment, this process is typically done once a year. In a perfect world, these values would always be in sync. The value would be decremented when items are sold and incremented when items are received. Unfortunately, this is not always the case. Consider shrinkage, shoplifting, and, my personal favorite, software bugs. Through a case study, this article will show how easy it is to architect a wireless real... (more)

Consuming Amazon Web Services Using PowerBuilder and SQL Anywhere 10.0.1

Since I'm in the middle of moving to a new city and need to get organized, I thought I'd roll a little application using SQL Anywhere, PowerBuilder, and Amazon Web Services to help organize my media collection. In doing so, I'm going to check out some cool features in SQL Anywhere, in particular, consuming Web Services. Calling Web Services out of your favorite development tool is nothing new. But who knew you could call them out of your favorite database? This opens up a whole world of programming fun. You might be wondering why you'd want to do this. Aside from the obvious - y... (more)