Read data from a connected database for use in your code.
-
Connect to a database using the Open Connection
node.
-
Insert a Select Data node. To limit the amount of data
read from a large database, connect a string control to the
columns input and select the columns you want to
read. Customize the gray sections for your unique programming goals.
-
Connect a variant array constant to the
data output to read and interact with the returned
data. Microsoft ActiveX Data Objects (ADO) use variants as data types. Use
Variant to Data to convert variant data for use in
graphs, charts, or LEDs. Customize the gray sections for your unique
programming goals.
-
Use a Close Connection node to close the connection with a
database.