ExportPropertyToColumn

Syntax

bool ExportPropertyToColumn (strParam)

Parameters

1. The property name whose value will be stored in 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

1. There is no connection to the Export database.
2. The column of the database does not exist.
3. The property (variable) identified by the parameter does not exist.
4. A SetTableName action was not used previously.

Otherwise, True.

Level

Details

Example:

SetTableName("Export_Results")
ExportFieldToColumn("VendorID,db_Number")
ExportPropertyToColumn("Status,db_PageStatus,2")
ExportFieldToColumn("Total,db_Total")
AddRecord()        

This sequence updates the db_PageStatus column of the Export_Results table with the value of the selected object's Status property. It also uses the optional third parameter to define a Style for the action.