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: String containing the AMS network ID of the target device, at which the ADS command is directed.
hDBID: 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 a 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: Returns the ADS error code or TcDatabaseSrv_Error_Codes if the bError output is set.
sSQLState: Returns the SQL error code of the corresponding database type
Requirements
Development environment |
Target system type |
PLC libraries to be linked |
---|---|---|
TwinCAT v3.0.0 |
PC or CX (x86) |
Tc2_Database |