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 =

‘ALFKI”

.ActiveConnection = oConnection

.CommandType adCmdText

EndWith

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!