ApiTableConvertAllAddException - cDbUpdateFunctionLibrary

To add an exception table to the array of tables that should not be converted with the ApiTableConvertALLToSQL message.

Type: Procedure

Parameters: Handle hTable

Parameter	Description
hTable	The table number as referenced to by Filelist.cfg

Syntax

Procedure ApiTableConvertAllAddException Handle hTable

Call:

Send ApiTableConvertAllAddException MyTable.File_Number

Description

Use it to add a table to the exception list for tables that should not be converted to SQL when the message ApiTableConvertALLToSQL is used in the OnUpdate event.

Note

The tables "CodeMast", "CodeType" and "DbVersion" are automatically excluded when using the ApiTableConvertALLToSQL message so you don't need to explicitly add those tables to the exception list.

Example

Object oDbUpdateVersion1.2 is a cDbUpdateVersion

Set pnVersionNumber to 1.2

Send ApiTableConvertAllAddException SomeTableNameNotToConvert.File_Number

Procedure OnUpdate

Send ApiTableConvertALLToSQL

End_Procedure

End_Object