HELP PLEASE! How to insert arrays 1x24 in columns of a database sql?
6 views (last 30 days)
Show older comments
Andrés Felipe Fontalvo Mejia
on 20 Mar 2020
Edited: Andrés Felipe Fontalvo Mejia
on 20 Mar 2020
Hello guys, how are you? (I speak spanish)
I need inserts 4 arrays 1x24 at the same time in a database but have an error
%% INSERT TO DATABASE SQL
columns = {'FechaHora,Presion,Volumen,Energia,id_Distribucion,RangoOperacional,Valido'};
dato = {x1,x2,x3,x4,id3,RangoOp,Valido}; %%ARRAYS 1X24 WITH VARIOUS DATA (X1 IS STRING - DATETIME) (X2,3,4 ARE DOUBLES)
insert(conn2,'dbo.Datos',{columns},{dato});
exec(conn2,query2);
0 Comments
Answers (2)
Guillaume
on 20 Mar 2020
Your columns input is completely wrong. It's a cell array with just one cell, a very long char vector. You then wrap that into another cell array when calling insert. Correct syntax should be:
columns = {'FechaHora', 'Presion', 'Volumen', 'Energia', 'id_Distribucion', 'RangoOperacional', 'Valido'};
dato = {x1,x2,x3,x4,id3,RangoOp,Valido}; %%ARRAYS 1X24 WITH VARIOUS DATA (X1 IS STRING - DATETIME) (X2,3,4 ARE DOUBLES)
insert(conn2,'dbo.Datos', columns, dato);
exec(conn2,query2);
0 Comments
See Also
Categories
Find more on Database Toolbox in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!