Reading Data from a Database

Read data from a connected database for use in your code.

1. Connect to a database using the Open Connection node.
2. 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.
3. 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.
4. Use a Close Connection node to close the connection with a database.