IsManagedConnection - cConnection

Used to check if a table uses managed connection

Type: Function
Return Data Type: Boolean

Parameters

Parameter	Type	Description
hTableNumber	Handle	[number of the SQL table to be checked]

Syntax

Function IsManagedConnection Handle hTableNumber Returns Boolean

Call Example

Get IsManagedConnection hTableNumber to BooleanVariable

Description

Checks if the table passed as parameter (hTableNumber) uses managed connection. Returns True if it does.

This function is to be used with SQL backends only. Attempting to use it with embedded database (native DataFlex) will trigger an error.

Sample

If (sAction = "TestConnection") Begin
    Handle hFileNum 
    Boolean bIsManaged

    Move Customer.File_Number to hFileNum
    Get IsManagedConnection of ghoConnection hFileNum to bIsManaged

    Send ShowInfoBox ("Customer table" * (If(bIsManaged, "uses", "does NOT use")) * "Managed Connection")
End

Sample

Procedure CheckManagedConnection
    Boolean bManaged

    Open Customer

    // Check if the table uses managed connection
    Get IsManagedConnection of ghoConnection (RefTable(Customer.File_Number)) to bManaged

    If bManaged Begin
        Showln "Customer table uses managed connection."
    End
    Else Begin
        Showln "Customer table does NOT use managed connection."
    End

End_Procedure