Why do attributes (e.g adFldIsNullable) get cleared when opening a contsructed Recordset?

rgutter_at_bctf.ca
Date: 02/21/05 

Date: 21 Feb 2005 02:40:21 -0800

I'm constructing a Recordset where some fields have to accept null
values that will copied into it:

        Rs.Fields.Append "FieldOne", adVarChar, 10,
adFldUpdatable+adFldIsNullable+adFldMayBeNull

When I check Rs.Fields(0).Attributes I see 100, which corresponds to
the 4+32+64 I set.

As soon as I open the Recordset, Rs.Fields(0).Attributes is reset to 4,
and I err out trying to set it to Null.

Any ideas?

Relevant Pages

  • Re: Simple Question?
    ... a recordset in datasheet view. ... One of the fields is EmployeeID which corresponds to ... As it stands, when I run the query, I have field EmployeeID in the ...
    (microsoft.public.access.queries)
  • Simple Question?
    ... I have a form with a command button connected to a query that returns ... a recordset in datasheet view. ... One of the fields is EmployeeID which corresponds to ... As it stands, when I run the query, I have field EmployeeID in the ...
    (microsoft.public.access.queries)
  • Re: !!
    ... Dim Cnn As Connection, Cmd As Command, Rs As Recordset ... If Err Then Err.Clear ... If Err Then MsgBox Err.Description: Err.Clear: Exit Sub ...
    (microsoft.public.vb.general.discussion)
  • Re: ADO Performance question
    ... > there to be much difference performance-wise. ... > I would prefer the mechanism of using a recordset rather than constructing ... > 3) If you are constructing SQL on the fly there ...
    (microsoft.public.data.ado)
  • Re: Evaluating Complex Recordset Field Statements
    ... Constructing the altered query for the recordset seems to be the best way to ... It's easy enough to build the data driven from the reference "fields" ...
    (comp.databases.ms-access)