About Database Tables and Datatypes

You can use the Database component to interact with only database tables. No other database objects are available. Furthermore, the component does not support procedure executions.

The database table must have a primary key. The following primary key datatypes are supported: string, text, varchar, int, double, float, and decimal. If you use another datatype for the primary key, you need to modify the SQL command.

The following datatypes are supported:

  • string

  • text

  • varchar

  • int

  • double

  • float

  • decimal