PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN

WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
User (Property)
In french: Utilisateur
ODBCHFSQLNot available with these kinds of connection
The User property is used to manage the user of a connection (HFSQL Client/Server, OLE DB, etc.). You can:
  • Identify the user of a connection (HFSQL Client/Server, OLE DB, etc.).
  • 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:
Versions 17 and later
iPhone/iPad This property is now available for iPhone/iPad applications.
New in version 17
iPhone/iPad This property is now available for iPhone/iPad applications.
iPhone/iPad This property is now available for iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This property is now available in Windows Store Apps mode.
New in version 18
Universal Windows 10 App This property is now available in Windows Store Apps mode.
Universal Windows 10 App 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
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
Universal Windows 10 App 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

Identifying 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 the connection used. This name was defined:

Defining the user of a connection Hide the details

<Connection used>.User = <New username>
<Connection used>: Connection name
Name of the connection used. This name was defined:
<New username>: Character string
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 recommended to use the User property.
See also
Minimum version required
  • Version 10
This page is also available for…
Comments
Click [Add] to post a comment