ExportSmartParamToColumn

Syntax

bool ExportSmartParamToColumn (strParam)

Parameters

Three comma-separated values:

1. A smart parameter that specifies the value to be stored into the column.
2. The name of the database column that will hold the value.
3. Optional: Can be set to the numerical value of 1, 2, or 3. If this parameter is not specified, quotes will be placed around the value in the SQL query to update the table.

Setting the value to 1 causes this action to return False if the Table name is invalid; otherwise the error will not be discovered until the action that performs the DB insert call, such as an AddRecord action, is called. This value would typically only be used in a development environment as it will increase processing time.

Setting this value to 2 allows NULL column values and inserts no quotes around values (for numeric) in the SQL query to update the database.

Setting the value to 3 allows NULL and if the column value is not NULL, the column value will be surrounded in quotes in the SQL query to update the database.

Returns

False if:

1. There is no connection to the database.
2. The column identified by the parameter does not exist.
3. A SetTableName action was not previously used.

Otherwise, True.

Level

All, but generally at the Page or Field level.

Details

Using the database opened by an earlier ExportDB action, this action will store a value into the specified column for the current row.

The action allows the input value to be specified with a smart parameter.

Example:

ExportSmartParamToColumn("@P\MyField.TYPE,EXPDBCOLUM")