Database Connectivity

Step 2

To read data from a database we have to use a SQL statement which will read data from a database table. To do this we have to make a statement that contains the SQL SELECT command.

Please note that Zinc™ v2.5 will execute the SELECT statement, then store the data into a result set. The data will remain there, waiting to be accessed until another SELECT statement is executed. The following command will NOT actually place the data in your Projector, but it will prepare it for access.

An easy SQL SELECT statement (assuming that the database has a table that is called "mytable") would be: "SELECT * FROM mytable":

       mdm.Database.MSAccess.select("SELECT * FROM myTable");

The above command (inserted on Frame 1 after the connection command) would select all of the data from the table "mytable" and store it in a record set for access.

Continue to Step 3