News:

Welcome on our forum!

Main Menu

SQL Db Pro module

Started by motoxrdr21, December 04, 2012, 06:19:03 PM

Previous topic - Next topic

motoxrdr21

I'm evaluating purchasing the SQL Db Pro module to replace the ODBC export that I'm currently doing using OPC Logger, and I'm not seeing any of the options from the documentation on configuring the SQL Queue, attached is a screen of my queue window, the parameter configuration is missing entirely, I'm also wondering if/how we write the variables that the data logger is pulling from the source to SQL using this plugin, the tutorial mentions insert statements but doesn't specify how the source variables are identified ie

insert into sqltable
(sqlcolumn1
) values
([??dataloggervariable??]
)
from ??



Arthur Grasin

you need to specify a parameter like :P1

Example:
insert into sqltable (sqlcolumn1) values (:P1)

next step: bind this parameter with data logger variable.
If you like my work, please take a few seconds and add feedback about our site or our software [here]