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 execute 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 example, 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 implemented 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

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!