Insert data to SQL database table

[314159ym]

Hi.

I have a problem with labsql for insert a data into database,can someone tell me what is wrong this this code? Is the sql code error or i need a lab-sql inerset function?

Thanks

[wiebe@CARYA]

A typo in the table name? "schoolinifo", instead of "schoolinfo"?

[Yamaeda]

Do SQL insert handle unicode?

/Y

[UliB]

No comma before values?

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

[newbieprogrammer]

You will need to change the column handling unicode data to nvarchar imo. Is it nvarchar in this case?

I know for a fact that the ado client can handle unicode but it depends on the destination column of the table which dictates a successful insert. 

[314159ym]

Hi 

I insert the data in mysql it works but in labview doesn't work with the same sql code.

And also i used the same code for insert the data into access it is also works.

[UliB]

---

@314159ym wrote:

Hi 

I insert the data in mysql it works but in labview doesn't work with the same sql code.

---

The error message says: "You have an error in your SQL syntax; check [...] for the right syntax to use near ' values (  [...] ) ' at line 1"

I don't think you used the very same SQL code in LabVIEW as in MySQL.

[wiebe@CARYA]

Does any query work?

On the bottom it reads "select * from schoolinfo". If that works, "insert into schoolinifo" will not work.

[314159ym]

Hi 

The read query works,but insert not works

I used function "ADO SQL EXCUTE" Is this the right one or has other function i should use

[wiebe@CARYA · Accepted solution]

I don't know what the function is called (I don't even know what library you use), but usually the insert and select functions require either different functions, or setting in input (get results or something like that).

The insert will not give any results, and if the execute expects results, it will give an error.