Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Articles
Search: 

WebRAD: Building Database Applications on the Web with Visual FoxPro and Web Con
Mark McCasland, August 1, 2002
Authors: Harold Chattaway, Randy Pearson & Whil Hentzen Publisher: Hentzenwerke ISBN: 1-930919-07-7 Retail Price: $49.95 US, $74.95 CDN Publication Date: 2002 Pages: 492 Online information: Table of Contents, 8 appendices, Source Code and E-Book URL: http://www.hentzenwerke.com/ ...
Authors: Harold Chattaway, Randy Pearson & Whil Hentzen
Publisher: Hentzenwerke
ISBN: 1-930919-07-7
Retail Price: $49.95 US, $74.95 CDN
Publication Date: 2002
Pages: 492
Online information: Table of Contents, 8 appendices, Source Code and E-Book URL: http://www.hentzenwerke.com/

Considering I am developing applications using West-Wind Web Connection, WebRAD could not have been more timely for me. This is truly an incredible book which I gave a 5-star rating in a review I posted on Amazon.com. Although the title makes reference to Web Connection, I would estimate at least half the book discusses in detail every other aspect of deploying a web site including the live server and the development environment.

The first 4 chapters are a terrific jump start on setting up your development environment, installing Web Connection, configuring the web server software, and actually running a test web application. In other words, the first 4 chapters summarize much of the process needed to deploy a web application so you can start experiencing success. All in just the first 90 pages!

After the first 4 chapters get you going, the book is very methodical in how it takes you through building the web site. You first get a brief chapter on the internet basics and how to get your domain name registered. There is also a very good explanation on some basic things to do when something is wrong with accessing your site like pinging and running a trace. The next chapters get you completely setup in your development environment as well as server hardware and hosting options.

One of the major decisions you will make is whether you will host your own web server or if someone else [a data center] will be providing the space, internet connection and/or the server. There is a major portion of a chapter that deals with just this one issue. Regardless of whether you host your own server or go with a data center, you still need to know how to configure the Internet Information Server [IIS] software on your server as well as your development computer. Details abound on installing and configuring IIS, setting up your virtual directories [domains] as establishing FTP capabilities.

Next comes the heart-and-soul of your web site -- developing the application that will take advantage of all your VFP knowledge and data. An entire chapter [60 pages!] is devoted to developing a Web Connection application from start to finish. This is followed up with pros-and-cons on the different methods you can use in your application that will be needed to track your users as they use your web site.

The book wraps up with a few chapters that cover troubleshooting tips. There is short chapter that reads like a manual that would be used by a technical-support help desk. They have categorized several troubleshooting topics, and under each topic they list all kinds of symptoms. Under each symptom, they give the Cause of the symptom, AND A SOLUTION! This chapter is followed by an extensive troubleshooting, debugging and maintenance chapter. You will definitely need to pay attention to this chapter because debugging a web application is not nearly as easy as debugging a regular VFP application.

I tried very hard to find something this book does not cover regarding the development and deployment of web applications. It took awhile, but I did find one small item missing -- how to configure your live server to send e-mail using wwIPStuff without having to go through a 3rd party ISP. However, this is so easy to do, you can find a brief, 13-step document posted by Michael Hogan on the West-Wind wiki at: http://www.west-wind.com/wiki/kb.wiki?wc~SMTPServerSetup

Throughout the book, most chapters referenced other resources relevant to the chapter content. For easier recall of this information, any outside resource mentioned in a chapter was summarized at the end of that chapter along with where the information can be located. Now that is convenient.

There are 8 appendices to the book and are only available as a download from the Hentzenwerke web site. One of the most frequently asked questions I see on news groups regarding web servers is how to configure the server to use the secure sockets layer [SSL and HTTPS]. I have been trying to find a concise document for months now, and Appendix F of this book is it. This clear, concise how-to on SSL is easily worth the price of this book especially when you consider how much getting a digital certificate from a Certificate Authority will cost you. If you are considering web development with Visual FoxPro, I highly recommend this book. It leaves no step unturned

More articles from this author
Mark McCasland, January 1, 2001
More and more we are seeing larger companies migrating their databases to Oracle. Usually this is done for data warehousing and for publishing data to the Internet or a company intranet. What I attempt to explain in this FAQ is how to configure a Windows 3.1 or Win95 workstation to access the Oracle...
Mark McCasland, September 1, 1999
Use the following to display the SQL progress bar without having the results [i.e., ### records selected in ### seconds] displayed on the screen or active window.
Mark McCasland, December 1, 2002
Authors: Tamar Granor, Ted Roche, Doug Hennig and Della Martin Publisher: Hentzenwerke ISBN: 1-930919-22-0 Retail Price: $69.95US for the printed book or $59.95US for the electronic [CHM] file only Publication Date: 2002 Pages: 372 printed, 4.1MB CHM file You also get the electronic ...
Mark McCasland, February 6, 2001
If you have a field that is used in multiple tables, you can get a list of all DBC member tables that the field occurs in by executing the following SQL command: select a.objectid, a.parentid, a.objectname fname, b.objectname tname, b.objectid tableid from MyDBC.DBC a join MyDBC.DBC b on a.parent...
Mark McCasland, December 9, 1999
Let's say you need to provide your users the Report Preview or Report Designer toolbars with your application. You need to provide your users with FOXUSER.dbf and .fpt. The only records you need to include in FoxUser are those whose ID = "TTOOLBAR". Assuming you have a folder where you place all ...
Mark McCasland, August 19, 1998
Using the following code to send a beep to the speaker[s]. External speakers and sound card are not required. It makes use of the MessageBeep Windows API function to accomplish it. It accepts a parameter to identify the beep type. Just pass the beep identifier to obtain a different type of beep.
Mark McCasland, April 11, 2003
This demo code will connect to Oracle [using your ID and password] to create a table of Presidents, a trigger, a sequence and some stored procedures. The stored procedures can be called to insert and update data in the Presidents table. Three of the methods in the VFP class will pass data values to...
Mark McCasland, June 4, 2001
One of the fastest ways to load bulk quantities of data into Oracle is to use the Oracle utility, SQL Loader. The purpose of this FAQ is to describe how to get your data into Oracle tables as fast as possible.