[database fast/insert] If exdata a struct, values must be scalars?
显示 更早的评论
Hi! I appear to have run into an, as near as I can tell, undocumented "feature" of the Database Toolbox fastinsert and insert functions: if the exdata argument--containing the data one wants to insert--is a struct, then the values have to have size==[1, 1]? Here's all the help says about exdata being a struct: "If exdata is a structure, field names in the structure must exactly match colnames"; I don't see any Examples where exdata is a struct. When I try to fast/insert a struct like struct('a', {'F'}, 'b', [5]) it works fine, but if I change it to struct('a', {'F', 'G'}, 'b', [5 6]), I get a "Too many input arguments" error; this is true regardless of the arrangement (i.e., horizontal or vertical) of the arrays, and regardless of the kind (i.e., "regular" or cell) of the latter array (obviously, in order for 'F' & 'G' to remain distinct, their contianing array must be of the cell variety). My question is, am I doing something wrong (fast/insert appear to support arrays for exdata as long as they're not contained w/in a struct), or is this indeed a "feature" of using a struct for exdata w/ the fast/insert functions? Thanks!
2 个评论
Oleg Komarov
2012-1-6
Please post the full syntax you used and the full error message.
David Goldsmith
2012-1-6
采纳的回答
David Hruska
2012-1-9
Database Toolbox's insert and fastinsert should work with structures containing multiple rows. I think the issue is in this statement:
struct('a', {'F', 'G'}, 'b', [5 6])
This creates a 1x2 array of structures, rather than a scalar structure whose fields contain vectors of data. I believe the following should do the trick:
insert(conn, tablename, {'a', 'b'}, struct('a', {{'F'; 'G'}}, 'b', {[5; 6]}))
Please see the documentation for struct for details: http://www.mathworks.com/help/techdoc/ref/struct.html
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Database Toolbox 的更多信息
2012-1-6
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
