AGG Software Forums

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 ??

you need to specify a parameter like :P1

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

next step: bind this parameter with data logger variable.