AnsweredAssumed Answered

vrf Question about ActiveX and Access

Question asked by VRFuser on Mar 13, 2000
Hi Martin,

     I am looking into Automatically storing data generated from a
Characterisation program into a database. We have both Access and SAS.
If you could send me a copy of the userfunctions you have developed for
access
I would appreciate it. I am currently storing the output from Vee in a comma
delimited file and using SAS to read this in.

Does anyone have any experience of directly storing data into SAS databases,
using
activeX or any other method from VEE?

Any inputs gratefully received.

Regards

     Graeme

-----Original Message-----
From: owner-vrf@hplvlrx.lvld.hp.com
[mailto:owner-vrf@hplvlrx.lvld.hp.com]On Behalf Of Martin,Roger
Sent: Saturday, March 11, 2000 12:51 AM
To: HP VEE Reflector (E-mail)
Subject: RE: vrf Question about ActiveX and Access


With all due respect to another list member who didn't have a good
experience with VEE/Access, I have had great success and am very pleased
with the results.  I have several computers in a manufacturing environment
storing, retrieving, and updating data in a central Access database, and it
has proved to be very robust.  I have used the power of Access' queries and
reports to my advantage and am performing things that could not be achieved
(easily, anyway) by Excel or ASCII.

That said, there is a pretty steep learning curve involved. To specifically
answer your question, I always convert my Access recordsets to VEE record
arrays before I extract data or manipulate them.  VEE record arrays are easy
to deal with; Access recordsets are not.  Then, when I have the data changed
in the VEE record array the way I want, I save the data -- field by field --
to an Access recordset.

It took a while to develop all the userfunctions to accomplish this, but now
that it's done, interacting with Access is a piece of cake.  If you would
like a copy of these userfunctions to play with, let me know.

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


> -----Original Message-----
> From: Shawn Wheelock [mailto:shawnw@cats.ucsc.edu]
>
>
> hello everyone,
>
> I am trying to access information in an access database table.  I have
> been modifying the example that came with the demo of VEE 5.
>
> I guess I am having a conceptual problem.    In the example,
> they treat
> the table as a record set, and then use an array of records
> to input the
> data that will be added to the table using addRecord.  When i
> try to forgo
> the adding and making an array of records, so I can just read
> out what is
> in a table, it starts giving me errors.  It seems like the recordset
> object was just a pointer to the table, but on usage that
> appears to not
> be the case.
>
> Any thoughts?  Thank you so much!
>
> --
> Shawn Wheelock
> shawnw@cats.ucsc.edu


---------------------------------------------------------------------
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".
---------------------------------------------------------------------

---------------------------------------------------------------------
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