ApiTableAttachAllToSQL - cDbUpdateFunctionLibrary

To attach ALL embedded 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 ApiTableAttachAllToSQL

Description

Use it to attach all Embedded (DataFlex) tables in Filelist.cfg to SQL.

Note

Use the ApiTableConvertAllAddException message to add tables that should not be attached 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 ApiTableAttachToSQL messages for those tables.

Example

Object oDbUpdateVersion1.2 is a cDbUpdateVersion

    Set pnVersionNumber to 1.2  

    Send ApiTableConvertAllAddException SomeTableNameNotToConvert.File_Number

    Procedure OnUpdate

        Send ApiTableAttachALLToSQL            

    End_Procedure

End_Object