SetTableName

Syntax

bool SetTableName (strParam)

Parameters

Two comma separated parameters:

1. The name of the database table where the exported data will be inserted.
2. Optional: If the numeric value of 1 is specified, the action will immediately check the database to confirm that the supplied table name is valid.

If the table name is not valid, SetTableName will return False. Note that this value causes an extra database call so it is typically specified only during development, not in a production system as it will increase the number of database calls and running time.

If the second parameter is not specified, this action will always return True.

If the specified table name is in valid, an error will be returned when the current row is inserted to the database on the next AddRecord call.

Returns

Returns False only if the first parameter contains an invalid table name and a value of 1 is specified as a second parameter. Otherwise this action always returns True.

Level

All.

Details

Sets the name of the table in your database to which the data is to be exported. This action needs to be used before the AddRecord action.

Example:

SetTableName(Export_Results,1)
ExportFieldToColumn(MyDate, db_Date)
AddRecord()