ApiTableConvertAllToSQL - cDbUpdateFunctionLibrary

To convert ALL tables in the Filelist.cfg to SQL. To exclude one or more tables from being converted to SQL see the ApiTableConvertAllAddException message.

Type: Procedure

Parameters: Handle hTable

Syntax

Procedure ApiTableConvertAllToSQL

Description

Use it to convert all Filelist.cfg table from Embedded (DataFlex) to SQL.

Note

Use the ApiTableConvertAllAddException message to add tables that should not be converted to SQL. 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.

This also means that if you also would like to convert "CodeMast", "CodeType" and "DbVersion", you would need to add ApiTableConvertToSQL messages for those tables.

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