Click HERE
to order online
Downloads
Subscription info here.
|
Click HERE
to order online.
Authors:
Marcia Akins,
Jim Booth,
Tamar E. Granor,
Andy Kramek,
Ken Levy
Rick Schummer
Rainer Vomel
Length: 28 pages (A4)
Formats Available: Printed (incl. electronic) or Electronic only
Printed format: A4 (210x297 mm or 8.3x11.7 in)
Electronic format: PDF
Single Issue Price ($US): 29.00 (printed+electronic) $19.00 (electronic only)
Press date: January, 2009
Printed issue availability: 2009/01 issue being mailed on 1/10.
Electronic issue availability: Available for download.
Source code: Available for download.
Januaryr, 2009 - Number 6
Intro to the Visual FoxPro Stack:
[[Ken Levy]]
The evolution and next phase of Visual FoxPro has essentially been transferred from Microsoft to the FoxPro community. Visual FoxPro will evolve, but the results of its evolution depend on the efforts within the FoxPro community. VFPS (Visual FoxPro Stack) can become an important part in the future and perception of Visual FoxPro starting in 2009 and into the next decade.
VFPX: Using Desktop Alerts
[[Rick Schummer]]
The Desktop Alerts provide you with another common mechanism to deliver informational messages to the users while your application is running. This month in Rick’s continuing series on VFPX deep dives, he takes a look at the Desktop Alert project on CodePlex, and demonstrates why this control might help you get rid of a few WAIT WINDOWS in your applications.
[[KitBox]]: Take it up with Management
[[Marcia Akins]] and [[Andy Kramek]]
All Visual FoxPro applications rely on data and in VFP we have various ways of handling sets of data. We may use tables directly, views, pre-defined cursors, or cursors generated “on the fly” by SQL queries. However, VFP doesn’t have a command that will unconditionally create or open and make current a data set irrespective of the type. In this month’s column Andy and Marcia discuss the creation of a class that will do precisely that thing.
New Ways: From Type to Type
[[Tamar Granor]], PhD
Changing data from one type to another is a common requirement. In older versions of VFP, you had to know a veritable cornucopia of functions to handle the various possibilities. A few recent additions make type conversion easier.
Best Practices: Best Practices Part II
[[Jim Booth]]
Last month we started this series with a little history and some discussion of basic programming practices. We discovered the ideas of routines and modules in our application development and we discussed the impact of designing for expansion to be able to adapt to future requirements. This month we will be digging deeper into the construction of our code and the concepts that we need to understand to realize the benefits of well designed system development.
Extend Excel with VFP! Using a VFP COM Server with Excel (and other VBA apps)
[[Rainer Vomel]]
Most programmers that use VBA are non-IT employees usually, with a marketing, finance, or logistics background trying to automate some reporting tasks. Usually this starts with an Excel spreadsheet and the use of ODBC. With ODBC the user can retrieve results from database queries and create some powerful reports. However, there might be some surprises that will make the user look for a different solution. In my case this was a bug in the VFP ODBC driver when I was using the default settings. The setting “Fetch data in background” caused the ODBC driver to hang after creating a lot of reports. In my case this was creating a personalized report for roughly 150 recipients. Sometimes after about report 92 the process would hang; at other times this would be around report 102, etc. This made me want to use a VFP ComServer instead of ODBC. After unchecking the ODBC setting Fetch data in the background, the problem vanished, but I now understood the potential benefits of using a COM Server. In addition, the ComServer now has all the SQL features of Visual FoxPro 9, whereas the ODBC driver has not been updated for several years. The ComServer I am using now has about 150 methods. This article describes how to use a Visual FoxPro Comserver with Microsoft Excel.
|
|
