Hi Dan,
Appreciate yoda isaiah does!
a) The user queries the database
b) A set is returned
c) The user does something to the set
d) The set is returned to the DB
"D" is of course optional. The user might just be querying for reporting purposes
This is the basic process of all databases. I think your discussion of set based and transaction based is the same thing in my mind.
The transactions are just sets of one or batched as you mentioned. Queries are set based (1 or more rows returned) VFP apps can be developed entirely set based. Using SQL Selects and such to retrieve data for work.
In my mind it's set based vs record based. Give me a set of records with this criteria vs goto record 1001 etc.
So long story.... I think the vast majority of developers work set based and not record based.
Does that make sense or learn more I must?
Rodman
Rod Paddock
Editor in Chief CoDe Magazine
President Dash Point Software, Inc.
VP Red Matrix Technologies,Inc.