ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage properties / HFSQL properties
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
Access (Property)
In french: Accès
ODBCHFSQL ClassicNot available with these kinds of connection
The Access property is used to manage the type of access of a connection (HFSQL Client/Server, OLE DB, etc.). You can:
  • Get the type of access used for a connection (HFSQL Client/Server, OLE DB, etc.).
  • Define type of access used for the connection (HFSQL Client/Server, OLE DB, etc.). In this case, if the connection is currently open, it will be closed and opened again with the new parameters when first accessing a data file that uses this connection.
Remark: The connection can correspond to:
Example
MyConnection is Connection
// Describe the connection
MyConnection.User = "USER"
MyConnection.Password = "PASSWORD"
MyConnection.Server = "MYSERVER" 
MyConnection.Database = "Database"
MyConnection.Provider = hAccessHFClientServer
MyConnection.Access = hOReadWrite
MyConnection.ExtendedInfo = "Extended information"
MyConnection.CursorOptions = hClientCursor
HOpenConnection(MyConnection)
Syntax

Getting the type of access of a connection Hide the details

<Type of access> = <Connection>.Access
<Type of access>: Integer constant
Returns the type of access of the connection:
hOReadThe data files used by the connection can be accessed in read-only mode. It is only possible to read records. It is not possible to add or remove records.
OLE DB This constant is only available for OLE DB connections.
hOReadWriteThe data files used by the connection can be accessed in read and write mode. It is possible to read and write new records.
<Connection>: Character string or Connection variable
Name of the connection used. This name is defined:

Defining the type of access of a connection Hide the details

<Connection>.Access = <Type of access>
<Connection>: Character string or Connection variable
Name of the connection used. This name is defined:
<Type of access>: Integer constant
Defines the type of access of a connection:
hOReadThe data files used by the connection can be accessed in read-only mode. It is only possible to read records. It is not possible to add or remove records.
OLE DB This constant is only available for OLE DB connections.
hOReadWriteThe data files used by the connection can be accessed in read and write mode. It is possible to read and write new records.
Remarks
The CtAccess property defines the type of access to a data file used by a connection. This property is kept for backward compatibility. It is recommended to use the Access property.
Caution: The Access property applies only to "Connection" types. The CtAccess property applies to data files.
Minimum version required
  • Version 10
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 04/22/2024

Send a report | Local help