How can I tell what table a recordset is bound to?

How can I tell what Table a disconnected recordset is (logically) bound to?

OK, I know that strictly speaking the question doesn't make sense, since the
truth is a recordset might possibly be updatable to multiple tables (subject
to driver support). But knowing what I do know about our own recordsets, I'd
be satisfied with the Table binding for the first column and I'd be happy
enough to work off the assumption that all columns are updating to the same
table.

I can see in the XML representation of the recordset that there is a table
attribute for each column definition:

<s:AttributeType name="DOCUMENTGROUPDESC" rs:number="1" rs:nullable="true"
rs:writeunknown="true" rs:basecatalog="FreedomDemo"
rs:basetable="DOCUMENTGROUP" rs:basecolumn="DOCUMENTGROUPDESC">

If I have to, I can get this information by serializing the recordset to XML
and using the XML DOM to find the basetable attribute for the first column.
But if this is available as part of the XML representation, I'd assume that
there should be some recordset or field property which would expose this. Is
there?

Thanks!

- Joe Geretz -



.

Relevant Pages

  • Re: Combo box
    ... I have populated my combo box with all the data in the first column ... from the 2nd column in my recordset to be displayed in a text box. ... Dim sNum As Long ... Set conn = Nothing ...
    (microsoft.public.vb.general.discussion)
  • Re: Concatenate problem
    ... > Function sCostDesc(lcindex As Variant) As Variant ... Rs As Recordset ... The first column is an ID ... the second is a description keyword. ...
    (microsoft.public.excel.programming)