sql server - Matlab fastinsert error -


i have simple table in sqlserver database, simsqltable. column head are:

index, del_date, name 

i have table in matlab mytbl, 1 row:

num   deldate  myname ---   -------  ------ 1     '07-02-2015 00:00:00.0'  'jenz'  mycolnames = {'index', 'del_date', 'name'} 

i use fastinsert this:

fastinsert(conn, 'simsqltable', mycolnames, mytbl) 

but error:

error using database/fastinsert (line 90) variable fields , insert fields not match.

how resolve this?

fastinsert queries database datatypes of columns. causes problems reserved keywords. try use back-tick ` in mysql or " in transact-sql quote keyword index.

mysql:

mycolnames = {'`index`', 'del_date', 'name'} 

transact-sql:

mycolnames = {'"index"', 'del_date', 'name'} 

Comments

Popular posts from this blog

toolbar - How to add link to user registration inside toobar in admin joomla 3 custom component -

linux - disk space limitation when creating war file -

How to provide Authorization & Authentication using Asp.net, C#? -