Write into a table in database

[aparab]

hello,

I am trying to read/write from/into a database.

Well reading is simple. The issue is with writing,

• a. I want a GUI with  no Queries , that means the Recordset has to be read in a Cluster first and then editted and writtenn back or say a new recordset is created.
•  b. have I had only 1 -2 Tables its not a work to create Cluster(as mentioned in the egs for database connectivity module ) but 1o  15 table are a issue.

 Is there an example of dynamically creating Clusters for this purpose. ??

regards

Akshay

(using LV2013)

[Sebastian.Weber]

It is possible to programmatically generate entire VIs using VI Scripting. (Enabled in Tools > Options > VI Server > VI Scripting)

This VI will generate a typedef control containing a cluster with a string and an I16:

Since you can read information about column names and data types of a given database table, you can programmatically generate clusters matching the table, and so don't have to do this by hand.

I think it is not possible to use this control directly in the VI that created it. However, it might be possible to script an other VI, which uses the just  created control to cast the data read from the DB to labview, edit it, and then writes it back to the DB. This VI could be loaded into a Subpanel of the current VI. But I did not test this.

[aparab]

thanks Sebastian I will give it a try