Error when inserting data into database without toolbox
显示 更早的评论
Hi,
I don't have database toolbox. But I created a correct connection. I try to use insert function to insert one row into a table, but keep getting this: Undefined function 'insert' for input arguments of type 'sun.jdbc.odbc.JdbcOdbcConnection'. What function should I use if I don't have a toolbox? Thanks for any suggestions.
JF
1 个评论
采纳的回答
Guillaume
2017-2-6
Why are you using a jdbc to odbc driver? It would only make sense if you were already familiar with the java sql api, which does not appear to be the case here. You may as well connect directly to the odbc driver from matlab.
As far as I know no odbc (or jdbc) driver offer insert methods. You have to build the SQL query yourself. Refer to your database documentation to know the exact syntax. It's usually something like:
sql = 'INSERT INTO tablename (colum_name, column_name, column_name) VALUES (value, value, value)'
connection.execute(sql);
Possibly wrapped in a transaction.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Database Toolbox 的更多信息
产品
Translated by 
