LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Insert cluster into database

Solved!
Go to solution

According to the help file, there is a flatten cluster input for the Insert function.

 

flatten cluster? specifies whether to insert a cluster that you wire to data as a binary value. If the value is TRUE, this VI updates the column that you specify in the columns input with the flattened binary value of the cluster. If the value is FALSE, this VI updates each column that you specify in the columns input with the corresponding item in the cluster. The default is FALSE.

Note  This input is valid only if you wire a cluster to the data input.

 

I haven't tried it but this says to me that you must specify the column names.


aputman
LabVIEW 2017
LabVIEW Programming
0 Kudos
Message 11 of 15
(441 Views)

....And it would appear to me that the column names must match the cluster element names.  I'm not certain of that.


aputman
LabVIEW 2017
LabVIEW Programming
0 Kudos
Message 12 of 15
(431 Views)
Solution
Accepted by topic author PauldePaor

I got it working finally. I have attached the solution that has worked for me if anyone is interested or if it helps anyone out in the future.

----------------------------------------------------------------------------------
I have not lost my mind, it's backed up on a disk somewhere
0 Kudos
Message 13 of 15
(418 Views)

Why does your reference say Array....then goes to DB Cluster (whatever that is) comes out as an array and is auto indexed to return a cluster?  Something is not right there.  And something is not right about marking your own comment as the solution.


aputman
LabVIEW 2017
LabVIEW Programming
0 Kudos
Message 14 of 15
(399 Views)

@aputman wrote:

Why does your reference say Array....then goes to DB Cluster (whatever that is) comes out as an array and is auto indexed to return a cluster?  Something is not right there.  And something is not right about marking your own comment as the solution.


The marked "solution" is also rather useless given that the PNG he posted shows that he is using a VI called DB Cluster (purpose unknown) that he fails to include.

0 Kudos
Message 15 of 15
(387 Views)