tSQLLoggedInUser - The Database Update Framework

See Also: Declaring Variables, Struct 

Purpose

tSQLLoggedInUser is a structured type used by the cDbUpdateHandler class for enumerating currently logged in users for a particular database.

Type Declaration

Struct tSQLLoggedInUser

    String sUser

    String sProgram

End_Struct

Struct Members

 sUser

The login name of the user.

sProgram

The name of the program for the logged in user as reported by the SQL back end database.

Syntax

Use cDbUpdateHandler.pkg

:

tSQLLoggedInUser {variableName}

Declaring variables

To declare tDbUpdateHandler variables, use the name of the type (tDbUpdateError) followed by the variable name.

tSQLLoggedInUser[] SQLLoggedInUser

See struct variables for more details of instantiating struct types.

Example

    Procedure OnClick

        String sDatabase

        Integer iSize iCount

        tSQLLoggedInUser[] SQLLoggedInUsers

        Move "OrderEntry" to sDatabase

        Get SqlUtilEnumerateLoggedInUsers of ghoDbUpdateFunctionLibrary MSSQLDRV_ID sDatabase to SQLLoggedInUsers

        Move (SizeOfArray(SQLLoggedInUsers)) to iSize

        Decrement iSize

        For iCount from 0 to iSize

            Showln SQLLoggedInUsers[iCount]

        Loop

    End_Procedure