LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Create new table using LABSQL

Hi, how can i create and delete a table in MS Access using labSQL?
0 Kudos
Message 1 of 4
(1,656 Views)
Do you have Databse Connectivity Toolkit or SQL Toolkit?

Here are some examples you can look at:

The attached VI (in AccSQL.zip) creates a table and inserts data. It demonstrates the use of Access syntax. It requires LabVIEW Database Connectivity Toolset.

Inserting Data in LabVIEW from Table Create Using Access 97 SQL Toolkit Syntax

SQL Toolkit for G Reference Manual


You should also look under SQL examples that ship with the toolkit.

Zvezdana S.
0 Kudos
Message 2 of 4
(1,656 Views)
The SQL syntax for creating a table is:

CREATE TABLE tablename (column def, column def, ...)

To use LabSQL, you use ADO Connection Create, ADO Connection Open (with the DSN of your database), and then SQL Execute. An example might be:

CREATE TABLE UUT_RESULT
( SERIAL_NUMBER TEXT,
LOGIN_NAME TEXT,
DATE_TIME DATETIME,
STATUS TEXT,
ERROR_CODE INTEGER,
ERROR_MESSAGE TEXT
);

The SQL syntax to delete a table is:

DROP TABLE tablename;
0 Kudos
Message 3 of 4
(1,656 Views)
hi all...

i manage to create and delete the table...
thanzzz...
cheers...
0 Kudos
Message 4 of 4
(1,656 Views)