See Also: Declaring Variables, Struct
tSQLLoggedInUser is a structured type used by the cDbUpdateHandler class for enumerating currently logged in users for a particular database.
Struct tSQLLoggedInUser
String sUser
String sProgram
End_Struct
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.
Use cDbUpdateHandler.pkg
:
tSQLLoggedInUser {variableName}
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.
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