Ive seen a few videos on youtube... good luck with wonderware support.... !
Well thats a start, Its sad that i can't even get a simple and proper training on a product they use and want to support..
Ive seen a few videos on youtube... good luck with wonderware support.... !
Ive developed over 100 apps in 4 different versions of wonderware, and would be happy to answer any questions you may have. Unfortunetly, ive never used the PLCs your using. So ill help ya where I can.
Matt
Look up bindlists in the wonderware help. They are basically a list that ties a database column on a table with a tag name. ODBC is set up in the administrator section of the control panel in windows under ODBC. Simply create a DSN name in the ODBC setup and point it to your database. Then the SQLConnect command is pointed to this DSN created in the ODBC. Google windows ODBC setup if you need more help.
So,
Create ODBC DSN entry in windows pointing to your database
Create bindlist in wonderware linking your column names to your tag names
In a script at some time (I usually do it in the app script) run a SQLConnect command to create a database connection to that DSN
Then, when you want to record data, run a script with an SQLInsert command with the bindlist and DB Connection. See the wonder help on these commands.
Matt
VIEW Loading Script DLL: WWSQL.DLL
WWSQL 7,1,008,0917
WWSQL -1: Invalid Pointer
WWSQL Error>> Select SELECT MyColumn FROM MyTable WHERE MyPrimaryKey = 1
WWSQL -1011: No Rows were selected
ResultCode = SQLConnect(ConnectionID, "DSN=MyDSN");
IF ResultCode == -1 THEN
texto = SQLErrorMsg(ResultCode);
ENDIF;
ResultCode = SQLSelect(ConnectionID, "MyTable", "MyBindList", "id = 1", "");
IF ResultCode == -1 THEN
texto = SQLErrorMsg(ResultCode);
ENDIF;
ResultCode = SQLEnd(ConnectionID);
ResultCode = SQLDisconnect(ConnectionID);