Create new table using LABSQL

[sky]

Hi, how can i create and delete a table in MS Access using labSQL?

[Zvezdana S.]

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.

SQL Toolkit for G Reference Manual


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

Zvezdana S.

[Dennis_Knutson]

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;

[sky]

hi all...

i manage to create and delete the table...
thanzzz...
cheers...