March2000

ADO Jumpstart for Microsoft

Visual FoxPro Developers by Barry R. Lee

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

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

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

Server—The most common examples of server-side ADO recordsets are those created through Active Server Pages

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 Connection 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.

The LA Fox Developer

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.

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 development 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 architecture. 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.

Who’s Going to DevCon

Windows 2000 Deployment