FB_DBTableCreate

FB_DBTableCreate 1:

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)