ADO Jumpstart for Microsoft
Visual FoxPro Developers
Part 6
John V Petersen
[Ed. Note: Reprinted with the author’s full permission. This is
the sixth installment of a multi-part article begun in February’s
LA Fox Developer.]

Alternatively, you can produce the SQL on the client if you wish.
The following code illustrates the difference:
With oCommand
.CommandText = “Select * From Customers Where CustomeriD =
‘ALFKI” + Chr(13) + ‘Select * From Orders Where customerlo =
.ActiveConnection = oConnection
.CommandType adCmdText

oRecordset = oCommand.Execute

The same result is achieved. The difference lies in how the
result is achieved

Which approach is better?

it depends on what your requirements are. The first option,
which uses stored procedures, is more secure; the code is set
and you can assign permissions with regard to who can ex-
ecute the stored procedure. The second option provides more
flexibility, but less security.

Fabricated Recordsets

Up to this point, recordset objects have been presented in the
context of origination from an ADO connection. In many cases,
you may want to create an ADO recordset with data that does
not come from a data source, just as you may in some cases
use the Create Cursor command in Visual FoxPro. For ex-
ample, you may have an application that works with a small
amount of data, such as an array or Visual FoxPro cursor.
Perhaps you need to dynamically build a table structure.
Whatever the reason, the ability to create ADO recordsets from
scratch is powerful.

(Con’t, page 6)
At LA Fox
Out and About
by Bariy R. Lee

July 17, 2000, 7:30 PM. Kristyne McDaniel. Kris will be here
talking about configurable toolbars.

August 21, 2000, 7:30 PM. John Miller. Conceptual Design
To design conceptually means to design without reguard to the
platform, language or architecture.

This presentation will focus on the benefits of using conceptual
design as a means for adapting to changes in the design of
applications. An overview of Conceptual Design and Conceptual
Design Methodologies will be presented and the techniques for
mapping Conceptual Designs to physical implementations will
be explained. A specific Conceptual Design Methodology will be
presented that will demonstrate the following:
Derivation of a physical object model and physical data
model from a conceptual model
Creation of the SQL queries required to bind the object
model to the data model
The use of XML data marshalling and XSL templates to
produce a web application to manipulate the data
through the object model
While the implementation will largely be in Visual FoxPro, the
methodology is technology independent and could be imple-
mented using any database or OOP language. The application
implemented uses a true 3-tier architecture that isolates the
presentation from, business logic, from the data logic.
In this issue
Undocumented FoxPro
Humor from the ‘Net
Miami DevCon
Page 3
Page 3
Page 9
The LA Fox Developer
A Newsletter for FoxPro Application Developers in Southern California
Visit our WebSite at: http://www.lafox.org
July 2000
The July meeting of LA Fox will be held on
July 17, 2000, at 7:30 PM at our new meeting
place (NCR, 100 N. Sepulveda Blvd., El
Segundo, CA). For details on how to get
there, see the map on the back page.
and much more!