AGG Software Forums
November 10, 2024, 02:34:47 AM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Welcome on our forum!
 
   Home   Help Search Login Register  

Pages: [1]
  Print  
Author Topic: SQL Db Pro module  (Read 11435 times)
motoxrdr21
Newbie
*

Karma: +0/-0
Posts: 1


View Profile
« on: December 04, 2012, 09:19:03 PM »

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




* Untitled.png (14.72 KB, 489x433 - viewed 8 times.)
Logged
Arthur Grasin
Tech. Support
Administrator
Hero Member
*****

Karma: +0/-0
Posts: 806



View Profile WWW
« Reply #1 on: December 05, 2012, 08:03:39 AM »

you need to specify a parameter like :P1

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

next step: bind this parameter with data logger variable.
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by SMF 1.1.21 | SMF © 2015, Simple Machines