>>It also interacts through cursors, better say through mix of objects and cursors. One record is held by object, recordsets are held by cursors.
>>Could you tell me: is cursor XBASE or SQL notion? I ask you because IMO we spend too much ardor on definitions and this may harm other considerations.
>
>The CURSOR concept, the CURrent Set Of Records, is very much a SQL construct, and not something that originated with xBASE. It was the first of a very welcome set of enhancements to the underlying language that help FoxPro in general and VFP in particular be a better player in the SQL environment.
>
>Philosophically, we differ in the ownership of data - the object may well have ownership of a cursor, which would correspond as a structure to a collection of the object. An object is not an inherently relational construct from my POV. VFP's tables structures seem to best fit object models of data by having the object at it's top level represent a thing with a distinct pkey, and the other recordsets that make up elements of the object being modelled normally would be children of the thing whose pkey is held by the object.
That's very close to the model I use.
Edward Pikman
Independent Consultant