Re: recordset dynamic properties

anybody can tell me how to set a recordset's dynamic properties before
opening the recordset with c++.

Some of those properties don't exist before you open the Recordset.
At the point of opening, some properties are appended.
So if they do not exist, how can you change them?

As I notice there aren't any properties
available in the collection before I open the recordset, and after I
opened
it they are readonly.

Yes. The MSDN mentions that certain properties become ReadOnly after a
successful Open.

I'm trying to set "Asynchronous Rowset Processing"
property to DBPROPVAL_ASYNCH_INITIALIZE of a AS400 server to be able to
start
a complex query without freezing the connection....

Right. So have you tried the 5th parameter of Recordset Open() ?
You have tried adAsyncExecute, adAsyncFetch, adAsyncFetchNonBlocking ???
See here
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthrstopen.asp
and click on ExecuteOptionEnum

Stephen Howe


.

Relevant Pages

  • Re: Forcing a ReQuery
    ... but opening a recordset only retrieves data. ... are action queries, maybe you want to Execute the queries ... >>> Set rst = Nothing ...
    (microsoft.public.access.modulesdaovba)
  • Re: extreme bloating of mdb with vba - how to reduce?
    ... > filtered so I opened the recordset with a query, for example, ... > Set dbs = CurrentDb ... So instead of opening with a query, ... > recordset opened via query vs a straightforward opening of the table? ...
    (microsoft.public.access.modulesdaovba)
  • Re: Too Few parameters. Expected 2. (3061) - Northwind DB - Please Help
    ... You'd need to include the Users, UserGroups and UserGroupsMembership tables ... opening the recordset could probably be ... on your Customers Extended query, restricting it on the ID column. ...
    (microsoft.public.access.queries)
  • Re: ADO and the Find method
    ... Opening of the whole table was not a good design anytime. ... > "Val Mazur" wrote in message ... >> recordset on a whole table and then searching it for the value, ...
    (microsoft.public.vb.database.ado)
  • Links vs. ADO Connection
    ... Howdy! ... differences between opening a recordset by directly using an ADO ... connection versus opening a recordset through Access linked tables? ...
    (comp.databases.ms-access)
Loading