User (Property)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

InfoThumbnailGeneration

OperationLogDirectory

Password

PasswordProtected

PersistedCalculatedItem

RepeatableReadSupported

This content has been translated automatically. Click here to view the French version.

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HFSQL properties

User (Property)

In french: Utilisateur

Not available with these kinds of connection

The User property allows to manage the user of an Connection (HFSQL Client/Server, OLE DB, ...). You can:

Find out the user of a connection (HFSQL Client/Server, OLE DB, ...).
Define the user of a connection (HFSQL Client/Server, OLE DB, ...). In this case, if the connection is currently opened, it will be closed and reopened with the new parameters during the first access to a file that uses this connection.

Remark: The connection can correspond to:

a connection described in the data model editor,
a connection described by HConnect, HDescribeConnection or HOpenConnection.
a connection described by a Connection variable.

Versions 17 and later

This property is now available for iPhone/iPad applications.

New in version 17

This property is now available for iPhone/iPad applications.

Versions 18 and later

This property is now available in Windows Store Apps mode.

New in version 18

This property is now available in Windows Store Apps mode.

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Versions 21 and later

This property is now available in Universal Windows 10 App mode.

New in version 21

This property is now available in Universal Windows 10 App mode.

Example

MyConnection is Connection
// Describe the connection
MyConnection.User = "FP"
MyConnection.Password = "Test"
MyConnection.Server = "MYSERVER"
MyConnection.Database = "Database"
MyConnection.Provider = hAccessHFClientServer
MyConnection.Access = hOReadWrite
MyConnection.ExtendedInfo = "Extended information"
MyConnection.CursorOptions = hClientCursor

HOpenConnection(MyConnection)

Syntax

Finding out the user of a connection Hide the details

<User name> = <Connection used>.User

<User name>: Character string

Name of the user of the connection.

<Connection used>: Connection name

Name of connection used. This name was defined:
in the data model editor,
by HDescribeConnection or HOpenConnection,
by a Connection variable.

Defining the user of a connection Hide the details

<Connection used>: Connection name

Name of connection used. This name was defined:
in the data model editor,
by HDescribeConnection or HOpenConnection,
by a Connection variable.

<New user name>: Character string (with quotes)

Name of the user of the connection.

Remarks

CtUserName is used to define the user of a connection. This property is kept for backward compatibility. It is advisable to use the Property User.