Re: adOpenStatic


<bob@xxxxxxxxxxxxxx> wrote in message
news:1188267119.829786.268180@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
When you use adOpenStatic with a query, does that typically mean the
records get loaded
into memory?


"Returns" in the ADO Object Model are managed by Recordset objects. Objects
always occupy some memory - somewhere. The various Cursor attributes provide
instructions for how much machinery and links back to the source need to be
activated in the delivered Recordset.

For example, adOpenStatic means provide a static snapshot of all the records
requested. Do not maintain any links back to the source. Allow forward and
backward navigation.

It might help to appreciate that while Data Access libraries make it appear
that one is working directly with the tables/records in a database. One
never is. There are always anywhere from 7 to 12 layers between here and
there. <g>

-ralph


.

Relevant Pages

  • Re: Another question about multidimentional arrays
    ... Ron Francis wrote: ... int arr; ... but the contents (and the memory they occupy) are essentially the same. ...
    (microsoft.public.vc.language)
  • Re: difference
    ... >>I think integer constants are objects, ... They occupy ... some sort of memory storage -- registers, virtual memory, etc. ... Whether data objects exist or not may be irrelevant ...
    (comp.lang.c)
  • Re: Windows 2000 Groups
    ... environment. ... Is there any limitation? ... Will it occupy any memory for each Group and User assigned ...
    (microsoft.public.win2000.group_policy)
  • Re: Another question about multidimentional arrays
    ... but the contents (and the memory they occupy) are ... It's all in the algorithms you use. ... I do not respond to top-posted replies, ...
    (microsoft.public.vc.language)