FB_DBTableCreate
The FB_DBTableCreate function block permits tables with any desired table structure to be created in databases.
VAR_INPUT
VAR_INPUT
sNetID : T_AmsNetID;
hDBID : UDINT;
sTableName : T_MaxString;
cbTableCfg : UDINT;
pTableCfg : POINTER TO ARRAY[0..MAX_DB_TABLE_COLUMNS] OF ST_DBColumnCfg;
bExecute : BOOL;
tTimeout : TIME;
END_VAR
sNetID : Is a string containing the AMS network identifier of the target device to which the ADS command is directed.
hDBID : Is the ID of the database to be used.
sTableName : Provides the name of the table.
cbTableCfg : Returns the length of the array in which the columns are configured.
pTableCfg : Provides the pointer address of the table structure array. The individual columns are written in this array.
bExecute : The command is executed with the rising edge.
tTimeout : Indicates the duration of the timeout.
VAR_OUTPUT
VAR_OUTPUT
bBusy : BOOL;
bError : BOOL;
nErrID : UDINT;
sSQLState : ST_DBSQLError;
END_VAR
bBusy : The command is in the process of being transmitted by ADS. No new command will be accepted as long as "bBusy" remains TRUE.
bError : Becomes TRUE, as soon as an error occurs.
nErrID : Supplies the ADS Error Code or the TcDatabaseSrv_Error_Codes when the bError output is set.
sSQLState : Supplies the SQL error code of the specified database type.
Requirements
Development environment | Target system type | PLC libraries to be linked |
---|---|---|
TwinCAT v2.10.0 | PC or CX (x86) | TcDatabase.Lib |
TwinCAT v2.10.0 | CX (ARM) |