maak

QUOTE (orko @ May 11 2008, 10:21 PM)

Even though these reserved keywords should not be used, they can be worked around by using brackets to surround the table name, like this for example:

Hope this helps you out.

the brackets is all what I need :thumbup:

thanks

Hi

I'm new to SQL and i'm facing with following error:

using "Example - Insert into a Table.vi" to add a record in Access2000 DB composed by only one table named "Section" with one numeric field named "ID".

When I run vi with following Command Text "INSERT INTO Section VALUES (1)" get this error code "-2147217900 Exception occured in Microsoft JET Database Engine. Syntax error in instruction INSERT INTO".

Now I change the name of the table from "Section" to "AAAA" (but any other name is fine) and with the same command (replacing only table name) the error disappear and the values are correctly writed!!!

Seems that "Section" is not a valid name for a table using LabSQL...or i'm missing something, i'm not experienced with SQL.

I cannot change the name of tables in DB because are used from other programs.

thanks for help

Maak