Top Stories by Deanne M. Chance
Did you ever wonder where your kids are driving around on a Saturday night?
Perhaps you are a business owner and need to know where your workforce is
located on different job sites. With the help of PowerBuilder, a wireless
connection, a GPS receiver, and Microsoft MapPoint, you can track the
location of any individual in real-time. This article will show you how.
To get things started you will need a few things:
PowerBuilder A serial-based GPS receiver (Bluetooth will do) MS MapPoint 2004
MS Visual C# (for sockets implementation) A static IP address or a router
capable of port forwarding A wireless connection for the client Some time to
learn! Introduction to Client/Server Programming
First, an introduction to socket-based client/server programming: In this
project we will write two components. One will be a server to listen for
requests on port 1968. The other will ... (more)
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)
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
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)
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)
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)