SQL::Connection::GenerateDropUserFromGroupStatement()

Syntax

SQL_Statement as C = SQL::Connection::GenerateDropUserFromGroupStatement( User as C, Group as C )

Argument	Description
SQL_Statement	An add user group statement appropriate for the database.
User	The name of the user to remove.
Group	The name of the group containing the user.

Description

The .GenerateDropUserFromGroupStatement() method returns the SQL statement that will remove a user from a group.

Supported By

Alpha Five Version 8 Enterprise Edition

Limitations

Desktop applications only.

Example

dim conn as SQL::Connection

conn.open("{A5API=Access,FileName='C:\Program Files\A5V8\MDBFiles\Alphasports.mdb',UserName='Admin'}")

? conn.GenerateDropUserFromGroupStatement("tom", "documentation")

= "DROP USER tom FROM GROUP documentation"