9
The LA Fox Developer Newsletter
February 2000
ADO Quickstart (Con’t from page 8)
Sound Familiar?
In addition, I highly recommend ADO 2.0 Programmers Refer-
ence, by David Sussman and Alex Homer, from Wrox Press.
Sometimes it helps to remember the client’s unique perspective:
Client’s Creed:
RecordSet types
- i want it my way
You can create four types of recordsets in ADO:
- I want it right now
- I shouldn''t t have to pay for it
+ Forward Only—This type of recordset can be navigated only in
- You should be willing to make sacrifices so I can have it
a forward direction. It is ideal when only one pass through a
recordset is required. Examples include populating a List box or
All else is merely compromise.
a Combo box. The RecordCount property is irrelevant with this
type of recordset.
- Bruce Allen
Left Brain Incorporated
+ Keyset—This type of recordset keeps acquired data up to
http:/Awvw.Ieftbrainincorp.com
date. For example, if you retrieve 100 records, data modified by
other users to those 100 records will be visible in your
recordset. However, modifications regarding new or deleted
records made by other users will not be visible in your
recordset. Both forward and backward navigation are supported.
The RecordCount property returns a valid value with this type of
recordset.

+ Dynamic—With this type of recordset, all underlying data is
visible to the Recordset object. Because the number of records
in the underlying table can change, the RecordCount property is
irrelevant with this type of cursor. However, forward and back-
ward navigation are supported.

+ Static—Both the number of records and data are fixed at the
time the Recordset object is created. The only way to get the
latest version of data and all records is to explicitly invoke the
Requery method. You can use the RecordCount property. In
addition, both forward and backward navigation is permitted.


[End of Part If

[Ed. Note: If you absolutely can’t wait through the next install-
ments and want to download the entire “ADO Quickstart”
article, visit the LA Fox website at http://www.lafox.org.)
It Can’t Get Any Easier.......
We’ve come up with an easy way to submit articles to the LA
Fox DeveloperNewsietter one that has been overlooked for
a long time.

You can submit your articles to Barry Lee at CIS# 72723,3422
on Compuserve, or brlee@earthlink.net.

These articles can be on any FoxPro-related topic, whether it
concerns a new technique you’ve discovered, a certain develop-
ment technique you may favor over others, book reviews, etc.
Editor reserves the right to edit or offer constructive comments
concerning submitted articles and accepted articles shall be
considered to be in the public domain.

The quality of this newsletter really depends on the members
that support it, not just read it. And I think we’d all be surprised
by the useful information that could be circulated around the
membership.

So.
How ‘bout it?
Job Op...
Visual Foxpro
Programmer Needed
Job Description

Visual Foxpro Programmer position open for fast-growing
company. Self starter, with strong experience, company is high
growth, and looking for people to grow with them. Require-
ments: Positions require excellent written skills, Please con-
nect to us ASAP.

PingWin, Inc.
Location:
14407 Hamlin St Van Nuys, CA. 91401
Phone: (818)781-6661 Fax: (818)786-9321
Email: tal@pingwin.com; talbahir@earthlink.net
“Those who have knowledge, don’t predict.
Those who predict, don’t have knowledge.”
- Lao
Tzu (6th Century BC Chinese Poet)
Wise words from a long time ago.
Page 9

9