PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
User (Property)
In french: Utilisateur
ODBCHFSQLNot available with these kinds of connection
..User is used to manage the user of a 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 re-opened with the new parameters during the first access to a file that is using this connection.
Note: The connection can correspond to:
Note: From version 19, HFSQL is the new name of HyperFileSQL.
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 name>..User
<User name>: Character string
Name of the user of the connection.
<Connection name>: Character string (with or without quotes)
Name of connection used. This name was defined:

Defining the user of a connection Hide the details

<Connection name>..User = <New user name>
<Connection name>: Character string (with or without quotes)
Name of connection used. This name was defined:
<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. We recommend that you use ..User.
See also
Minimum required version
  • Version 10
This page is also available for…
Comments
Click [Add] to post a comment