AnsweredAssumed Answered

vrf Records

Question asked by VRFuser on Oct 1, 1999
Latest reply on Feb 25, 2002 by VRFuser
You can retrieve the field names from an Access table using the name
property of the Field object contained in the Fields collection (ADO).
Then, using these names, you can retrieve the desired fields/records.  I
haven't actually done this so I don't have an example to send you.

Of course, you can always retrieve a recordset using a SQL statement (like
"SELECT * FROM tblCalData) without referencing any field names.  But the
resulting recordset is useless in VEE unless you convert it to something you
can use (I have userfunctions to convert them to VEE records).  But my
functions require knowing the field names in advance.

Hope this helps,

Roger Martin
Manufacturing Engineer
email: rmartin@granville.com
phone: 303-998-4045
fax: 303-443-2546
HELIX TECHNOLOGY CORP.
Granville-Phillips
Boulder, CO USA


> -----Original Message-----
> From: greg grenier [mailto:greggrenier@yahoo.com]
> Sent: Friday, October 01, 1999 10:08 AM
> To: VEE users
> Subject: vrf Records
>
>
> Is there any way to retreve an entire record from
> Access without knowing the field names in advance?
>
> Thanks in advance
>
> Greg Grenier
> M/A COM
> Torrance Ca.
---------------------------------------------------------------------
This is the "vrf" maillist, managed by Majordomo.  To send messages to
this maillist, just email to "vrf@lvld.hp.com".  Subscriptions and
unsubscriptions are done through the address "vrf-request@lvld.hp.com".
If you need details, just send a message containing the text "help"
to "vrf-request@lvld.hp.com".
---------------------------------------------------------------------

Outcomes