Re: CDaoRecordset - Reading data into a structure

From:

"Alex Blekhman" <xfkt@oohay.moc>

Newsgroups:

microsoft.public.vc.language

Date:

Mon, 2 Oct 2006 17:27:30 +0200

Message-ID:

<egfPMdj5GHA.4536@TK2MSFTNGP06.phx.gbl>

<dan655t@gmail.com> wrote:

  I was wondering if anybody knew of a method that can be
used to read
data from a recordset into a structure that has already
been defined.

For example I have a struct:

typedef struct
{
   int id_num;
   char name[50];
   int qty;
} INVENTORY;

and a table in a database named INVENTORY (that has been
read into the
recordset) with columns for id_num, name, and qty.

Is there any method built into CDaoRecordset that can copy
this
information into the struct? Thanks!

I never used it myself but MSDN says it is possible:

<quote>
CDaoRecordset uses DAO record field exchange (DFX) to
support reading and updating of record fields through
type-safe C++ members of your CDaoRecordset or
CDaoRecordset-derived class.
</quote>

See for more info:

"Data Exchange for Record Views"
http://msdn2.microsoft.com/en-us/library/y2tb0fc2.aspx

"Record Field Exchange (RFX)"
http://msdn2.microsoft.com/en-us/library/a8staww2.aspx

HTH
Alex