maak
-
Posts
2 -
Joined
-
Last visited
Never
Content Type
Profiles
Forums
Downloads
Gallery
Posts posted by maak
-
-
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
LabSQL problem
in Database and File IO
Posted
QUOTE (orko @ May 11 2008, 10:21 PM)
the brackets is all what I need :thumbup:
thanks