Tags in SQL statements?

[jthyge]

Hello

How is it possible to use tags in SQL statements in Machine SCADA Expert?

If I e.g. want to change the database the select is made in. 

SELECT * FROM [TAG].trend001

Best regards 

Jesper

[Rodrigo_Garcia]

Hello @TomDroll , Could you support on this?

Regards,

[Paul_Derbyshire · Accepted solution]

Hell Jesper,

You can use {} to enclose tags in a DBExecute script command.

For example:

SELECT * FROM {MyTag}.trend001

However, you want to change the database?

You can change the database/ERP reference in the DB Execute.

$DBExecute($MyDBConnection, "SELECT * FROM trend001")

Where $MyDBConnection is a string which contains the of the Database/ERP connection name that you created.

---

@jthyge wrote:

Hello

How is it possible to use tags in SQL statements in Machine SCADA Expert?

If I e.g. want to change the database the select is made in. 

SELECT * FROM [TAG].trend001

Best regards 

Jesper

---

[TomDroll]

HI, 

Yes it is possible to add tags to your SQL query. there are 3 options available.

Option 1:VB Script or Function where you can use VB Variables to build the query and then the $DBExecute function. something like this:

Dim SQL

SQL = "SELECT FROM Table WHERE Column = " & $TagName

$DBExecute("Connection",SQL)

Option 2: You can also use the script database command $DBSelect command with the syntax below.

DBSelect("DB1","Table1","Array1,Array2","Column1,Column2","","")

Option 3: You can use the database worksheets in the Tasks->Database/ERP folder,  the condition field would be your select where from would be.

Hopefully this helps!

[jthyge]

Thanks Paul  and Tom

This was just what I was looking for.