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 backward 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 installments 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 development 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. Requirements: Positions require excellent written skills, Please connect 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