AnsweredAssumed Answered

vrf MySQL / scripting

Question asked by michael.asbery on Apr 23, 2002
Latest reply on May 25, 2014 by cindy313

Like • Show 0 Likes0
Comment • 4

Hello,

Can anyone make a recommendation for a barcode reader for use in a VEE
application. I would prefer a serial port device, but could live with USB.
Also any war stories regarding the software interface to the device (dll, AX
etc) would be most appreciated.

Many thanks

Andy

-----------------------
Andy Street
Technical Consultant
Agilent Technologies
Tel: 01189-275395
Mob: 07765-897003
e-mail: andy_street@agilent.com
---------------------------------------------------------------------
This is the "vrf" maillist, managed by Majordomo. To send messages to
this maillist, just email to "vrf@lvld.agilent.com". Subscriptions and
unsubscriptions are done through the address "vrf-request@lvld.agilent.com".
If you need details, just send a message containing the text "help"
to "vrf-request@lvld.agilent.com".
---------------------------------------------------------------------

No one else has this question

Outcomes

4 Replies

VRFuser Apr 23, 2002 5:50 AM
Mark Correct
Correct Answer
Craig,

In addition to Mike's excellent example, consider the use of multi-statement
formulas.
Also, when I see the work space start to get cluttered, I will often select
a group of VEE objects and create a UserObject (Edit > Create UserObject...)
and give it a descriptive name. Create a UserFunction instead if you want to
use the code in more than one place. I also often spend some time moving
objects around and resizing them (to spread out the I/O terminals) so as to
reduce the clutter of lines. Finally, use as few sequence pins as you really
need to guarantee the order of execution where it is critical. Most of the
time the data lines can drive the flow.

Regards,
Bill Ossmann
--
bill_ossmann@hsgmed.com
Philips Ultrasound

>-----Original Message-----
>From: Michael Asbery [mailto:michael.asbery@nrl.navy.mil]
>Sent: Wednesday, April 24, 2002 8:17 AM
>To: vrf@lvld.agilent.com
>Subject: RE: vrf MySQL / scripting
>
>
>Craig,
>
>You might want to investigate the use of the formula object. You can
>basically write short C scripts within the object using most of the vee
>objects from the function and object browser. See my example
>of using a
>formula box, with the equivalent "Clunky code" below the object.
>
>Mike Asbery
>***********************************************************
>Michael N. Asbery, NRL Code 5733.20, (202)404-3014, DSN 357
>michael.asbery@nrl.navy.mil fax (202)404-7661
>***********************************************************
>
>
>-----Original Message-----
>From: owner-vrf@lvld.agilent.com [mailto:owner-vrf@lvld.agilent.com]On
>Behalf Of MCINTYRE Craig
>Sent: Tuesday, April 23, 2002 7:59 PM
>To: vrf@lvld.agilent.com
>Subject: vrf MySQL / scripting
>
>
>Hi there,
>
>Being a complete newbie to VEE Pro, I have a couple of
>questions about some
>of its functionality.
>
>1. I need to interface to a MySQL database. I've seen the
>example in the
>help which uses ADO however this looks like a pretty 'clunky'
>solution. Is
>there a better way to communicate with an SQL database? (write
>a dll? other
>methods?)
>
>2. Being a newbie, I'm still trying to make that paradigm shift from
>conventional programming into this visual environment. One thing I keep
>wanting to do is to write a few lines of code to do a particular task
>instead of dragging in a dozen boxes and joining them up in a
>messy way. Is
>there any way to include short scripts (eg VBscript or
>otherwise) to perform
>simple processing algorithms that would otherwise require the
>use of a lot
>of VEE 'blocks' and a lot more time to implement?
>
>Many thanks,
>Craig McIntyre.
>
>---------------------------------------------------------------------
>This is the "vrf" maillist, managed by Majordomo. To send messages to
>this maillist, just email to "vrf@lvld.agilent.com". Subscriptions and
>unsubscriptions are done through the address
>"vrf-request@lvld.agilent.com".
>If you need details, just send a message containing the text "help"
>to "vrf-request@lvld.agilent.com".
>---------------------------------------------------------------------
>
---------------------------------------------------------------------
This is the "vrf" maillist, managed by Majordomo. To send messages to
this maillist, just email to "vrf@lvld.agilent.com". Subscriptions and
unsubscriptions are done through the address "vrf-request@lvld.agilent.com".
If you need details, just send a message containing the text "help"
to "vrf-request@lvld.agilent.com".
---------------------------------------------------------------------
Like • Show 0 Likes0
Actions
VRFuser Apr 23, 2002 4:06 PM
Mark Correct
Correct Answer
Craig,

In addition to Mike's excellent example, consider the use of multi-statement
formulas.
Also, when I see the work space start to get cluttered, I will often select
a group of VEE objects and create a UserObject (Edit > Create UserObject...)
and give it a descriptive name. Create a UserFunction instead if you want to
use the code in more than one place. I also often spend some time moving
objects around and resizing them (to spread out the I/O terminals) so as to
reduce the clutter of lines. Finally, use as few sequence pins as you really
need to guarantee the order of execution where it is critical. Most of the
time the data lines can drive the flow.

Regards,
Bill Ossmann
--
bill_ossmann@hsgmed.com
Philips Ultrasound

>-----Original Message-----
>From: Michael Asbery [mailto:michael.asbery@nrl.navy.mil]
>Sent: Wednesday, April 24, 2002 8:17 AM
>To: vrf@lvld.agilent.com
>Subject: RE: vrf MySQL / scripting
>
>
>Craig,
>
>You might want to investigate the use of the formula object. You can
>basically write short C scripts within the object using most of the vee
>objects from the function and object browser. See my example
>of using a
>formula box, with the equivalent "Clunky code" below the object.
>
>Mike Asbery
>***********************************************************
>Michael N. Asbery, NRL Code 5733.20, (202)404-3014, DSN 357
>michael.asbery@nrl.navy.mil fax (202)404-7661
>***********************************************************
>
>
>-----Original Message-----
>From: owner-vrf@lvld.agilent.com [mailto:owner-vrf@lvld.agilent.com]On
>Behalf Of MCINTYRE Craig
>Sent: Tuesday, April 23, 2002 7:59 PM
>To: vrf@lvld.agilent.com
>Subject: vrf MySQL / scripting
>
>
>Hi there,
>
>Being a complete newbie to VEE Pro, I have a couple of
>questions about some
>of its functionality.
>
>1. I need to interface to a MySQL database. I've seen the
>example in the
>help which uses ADO however this looks like a pretty 'clunky'
>solution. Is
>there a better way to communicate with an SQL database? (write
>a dll? other
>methods?)
>
>2. Being a newbie, I'm still trying to make that paradigm shift from
>conventional programming into this visual environment. One thing I keep
>wanting to do is to write a few lines of code to do a particular task
>instead of dragging in a dozen boxes and joining them up in a
>messy way. Is
>there any way to include short scripts (eg VBscript or
>otherwise) to perform
>simple processing algorithms that would otherwise require the
>use of a lot
>of VEE 'blocks' and a lot more time to implement?
>
>Many thanks,
>Craig McIntyre.
>
>---------------------------------------------------------------------
>This is the "vrf" maillist, managed by Majordomo. To send messages to
>this maillist, just email to "vrf@lvld.agilent.com". Subscriptions and
>unsubscriptions are done through the address
>"vrf-request@lvld.agilent.com".
>If you need details, just send a message containing the text "help"
>to "vrf-request@lvld.agilent.com".
>---------------------------------------------------------------------
>
---------------------------------------------------------------------
This is the "vrf" maillist, managed by Majordomo. To send messages to
this maillist, just email to "vrf@lvld.agilent.com". Subscriptions and
unsubscriptions are done through the address "vrf-request@lvld.agilent.com".
If you need details, just send a message containing the text "help"
to "vrf-request@lvld.agilent.com".
---------------------------------------------------------------------
Like • Show 0 Likes0
Actions
VRFuser Apr 23, 2002 4:59 PM
Mark Correct
Correct Answer
Hi there,

Being a complete newbie to VEE Pro, I have a couple of questions about some
of its functionality.

1. I need to interface to a MySQL database. I've seen the example in the
help which uses ADO however this looks like a pretty 'clunky' solution. Is
there a better way to communicate with an SQL database? (write a dll? other
methods?)

2. Being a newbie, I'm still trying to make that paradigm shift from
conventional programming into this visual environment. One thing I keep
wanting to do is to write a few lines of code to do a particular task
instead of dragging in a dozen boxes and joining them up in a messy way. Is
there any way to include short scripts (eg VBscript or otherwise) to perform
simple processing algorithms that would otherwise require the use of a lot
of VEE 'blocks' and a lot more time to implement?

Many thanks,
Craig McIntyre.

---------------------------------------------------------------------
This is the "vrf" maillist, managed by Majordomo. To send messages to
this maillist, just email to "vrf@lvld.agilent.com". Subscriptions and
unsubscriptions are done through the address "vrf-request@lvld.agilent.com".
If you need details, just send a message containing the text "help"
to "vrf-request@lvld.agilent.com".
---------------------------------------------------------------------
Like • Show 0 Likes0
Actions
cindy313 May 25, 2014 8:08 PM
Mark Correct
Correct Answer
sorry for late reply , i recommend this [url=http://www.keepautomation.com/products/net_barcode/]barcode site[/url] where you can the [url=http://www.keepautomation.com/products/net_barcode_reader/barcode_data_matrix.html]barcode scanners[/url]
Like • Show 0 Likes0
Actions

vrf MySQL / scripting

Outcomes

Related Content

Recommended Content