HELP PLEASE! How to insert arrays 1x24 in columns of a database sql?
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Andrés Felipe Fontalvo Mejia
el 20 de Mzo. de 2020
Editada: Andrés Felipe Fontalvo Mejia
el 20 de Mzo. de 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);
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/278362/image.png)
0 comentarios
Respuestas (2)
Guillaume
el 20 de Mzo. de 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 comentarios
Ver también
Categorías
Más información sobre Database Toolbox en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!