pierjsap last edited by
I linked an external database I did Statement test with a simple select * from my table query and I managed to get the result set. So, I tried to create a datapoint because I imagined that they could be used to derive data through a sql script. As far as I could understand, can only insert and update?
Thanks in advance for the support
Jared Wiltshire last edited by Jared Wiltshire
@pierjsap Not following. What is the problem? You said you could query and get a result, then you said you could insert and update. Not there are two buttons "Submit query" and "Submit update".
I would not recommend trying to insert data points via the SQL console regardless. There is a binary blob field which you will not be able to insert easily. Also you will need to restart Mango after doing any manual SQL inserts in this manner.
There will be a new UI module out today probably which will enable you to create data points via CSV. Hopefully that will help you.
 Wait.. SQL data source.. I was thinking you were talking about the SQL console. Why are you trying to create data points from within a data source?
phildunlap last edited by phildunlap
I too am somewhat confused. It sounds like you're asking if the SQL data source can read data? The answer is yes, it can store data from the data source's select statement or it can be configured only to update the table (which it must be if you wish to set the point to some dynamic value in the update statement, a point that isn't "Modify Table Only" will only have a constant update statement), You either have to match the 'Column name' property of the point to the column names returned, or do a "row based query" and have the column name match the value in the first column of the results, then its value in the second column.
There are a few examples scattered around the forum. If you can say more, perhaps I can recall a relevant thread for you.