How to use database via SQL. There are several options. For example, you can connect the database in parallel, using ODBC, via SQL Server, Oracle, MySQL, etc.
Example 1:
Simple, with an existing table:
4 steps:
1 – Script . Place the script, for example, in the OnAfterUpdate event .
2 – DSN . Define the DSN in the script.
3 – Table . Define the already existing table, in the script.
4 – Tags . Define which tags in the script.
Script :
if timer.sqldatabase>5000 then ‘set timeline (ms)
odbc.dsn=“sqlserver1” ‘set DSN
odbc.table=“databasename1.dbo.table1” ‘set table
odbc.connect
odbc.addnew
odbc.field(“Time”)=now
odbc.connect
odbc.addnew
odbc.field(“Time”)=now
‘ set TAGS:
odbc.field(“Tag1”)=Tag1
odbc.field(“Tag2”)=Tag2
odbc.field(“Tag3”)=Tag3
odbc.field(“Tag4”)=Tag4
odbc.field(“Tag1”)=Tag1
odbc.field(“Tag2”)=Tag2
odbc.field(“Tag3”)=Tag3
odbc.field(“Tag4”)=Tag4
odbc.update
odbc.disconnect
odbc.disconnect
timer.sqldatabase.reset
end if
Example 2
Automatically all tags, with already existing table.
Script :
if timer.sqldatabase>5000 then ‘set timeline (ms)
odbc.dsn=“sqlserver1” ‘set DSN
odbc.table=“databasename1.dbo.table1” ‘set table
odbc.connect
odbc.addnew
odbc.field(“Time”)=now
odbc.connect
odbc.addnew
odbc.field(“Time”)=now
for i=1 to tags.count
odbc.field(tag$(i).name)=tag(i)
odbc.field(tag$(i).name)=tag(i)
next
odbc.update
odbc.disconnect
odbc.disconnect
timer.sqldatabase.reset
end if
* DSN:
The DSN can be defined in the Windows ODBC command.
Example 3:
SELECT fields example from SQL database:
Script :
odbc.dsn=“sqlserver1” ‘set DSN
odbc.connect
odbc.SQLExecute( “SELECT * FROM databasename1.dbo.table1” ) ‘set query
odbc.moveLast
n = odbc.recordCount
s = “”
s = odbc.field(“Tag1”) ‘ read field
msgBox(s)
odbc.disconnect