MySql_Query

MySql_Query (FB)

FUNCTION_BLOCK MySql_Query EXTENDS CBM.ETrig

Short description:

This function block executes a MySQL command that returns results, e.g. SELECT, etc.

Detailed description: The MySQL commands must be constructed using an array. The array length is defined by the GLOBAL CONSTANTS. The FBox is based on the general behavior model “Etrig”, so you can process and observe the current process state within your application.

Info about MySQL_Command: Non-numeric SQL parameter values must be quoted with quotation marks (apostrophe = '). To use an apostrophe inside a CODESYS string, you must declare it with a dollar sign plus apostrophe ($') or with $27.

e.g:

MySQL_Command[0] := 'SELECT * FROM table WHERE name ='
MySQL_Command[1] := '$27nonNumberValue$27 ';

Caution: Maximum length for identifiers are 250 bytes and for field data 500 bytes,

InOut:

Scope	Name	Type	Comment
Input	MySQL_Command	ARRAY [0..gc_MySQL_iStatementMax] OF STRING(gc_MySQL_iStatementLength)	MySQL command
Inout	MySQL_Connection	MySQL_ConnectionString	MySQL connection string which holds the server and login information
Inout	stResultSet	MySQL_DataSet	Query result
Output	eError	ERROR	Error type
Output	sExecute_State	STRING(200)	Current execute state