ADO Jumpstart for Microsoft

Out and About

Visual FoxPro Developers by Barry R. Lee

Part I

John V Petersen

[Ed. Note: Reprinted with the author’s full permission. This is

the second installment of a multi-part article begun last month.]

RecordSet Locations

Recordset objects can exist in either of two locations, the server

or the client:

Server—The most common examples of server-side ADO

recordsets are those created through Active Server Pages

(ASP).

Client—A recordset that resides on a workstation is useful when

creating disconnected recordsets or recordsets on which you

wish to apply filters, sorts, or indexes.

The most common properties you are likely to use with ADO

recordsets include the following:

ActiveCommand property—An object reference to the Command

object that created the recordset.

ActiveConnection property—An object reference, to the Connec-

tion object, that provides the link to an underlying data source.

AbsolutePosition property—Specifies the relative position of a

record in an ADO recordset. Unlike the Bookmark property,

which does not change, the AbsolutePosition property can

change depending on the active sort and filter.

Bookmark property—A unique record identifier that, like the

record number in a Visual FoxPro cursor or a record number in

Visual FoxPro, does not change during the life of a recordset.

BOF/EOF properties—Beginning of File and End of File,

respectively, that work just like the BOF( ) and EOF( ) functions

in Visual FoxPro.

EditMode property—Specifies the editing state of the current

record in an ADO recordset.

(Con’t, page 3)

The LA Fox Developer

A Newsletter

for FoxPro Application Developers in Southern California

Visit our WebSite at: http://www.lafox.org March 2000

The March meeting of LA Fox will be held on

March 20, 2000, at 7:30 PM at our new meet-

ing place (NCR, 100 N. Sepulveda Blvd., El

Segundo, CA). For details on how to get

there, see the map on the back page.

At LA Fox

March 20, 2000, 7:30 PM. Kevin McNeish. Kevin McNeish is

President of Oak Leaf Enterprises - a company that specializes

in object-oriented software, training and developer tools. He is

the creator of The Mere Mortals Framework for Visual FoxPro -

a robust tool for developing flexible and adaptable applications

rapidly. Kevin mentors and trains many software development

companies to build flexible, component-based applications that

can easily scale from two-tier to n-tier and also be accessed via

the Internet. He is a Microsoft-Certified Developer and has

created many enterprise-wide applications for a wide variety of

vertical markets using Visual FoxPro as the primary develop-

ment tool. This session takes you beyond the basics of

business objects into advanced topics of creating, distributing

and using business objects in the real world. See how the new

features of Visual FoxPro 6 Service Pack 3 can help you create

business objects that can automatically adapt and scale to their

environment; whether it’s a two-tier, three-tier or n-tier architec-

ture. Learn how to overcome the inherent slowness of DCOM.

Learn to create business objects with crisp boundaries and a

well-balanced load of responsibilities. During this session you’ll

see live examples of business objects at work in a variety of

settings from the desktop to the Internet, serving up Visual

FoxPro cursors, HTML, XML and ADO recordsets.

April 17, 2000, 7:30 PM. Peter Butterfield. User Interface

Architecture—tips, tricks, and tirades.

Elsewhere

(Con’t, page 2)

In this issue

Who’s Going to DevCon

Windows 2000 Deployment

One More Time

Page 4

Page 6

Page 7

...and much more!