ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE


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
ODBCHFSQLNot 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:
  • Find out the type of access used for a connection (HFSQL Client/Server, OLE DB, etc.).
  • Define the type of access used for the connection (HFSQL Client/Server, OLE DB, etc.). In this case, if the connection is currently opened, it will be closed then re-opened with the new parameters during a first access to a data file that is using 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

Finding out the type of access for a connection Hide the details

<Type of access> = <Connection>.Access
<Type of access>: Integer constant
Returns the type of access for the connection:
hOReadThe data files handled by the connection can be accessed in read-only mode. You only have the ability to read the records. No record can be added or deleted.
hOReadWriteThe data files handled by the connection can be accessed in read/write mode. You have the ability to read the records and to write new records.
<Connection>: Character string or Connection variable
Name of the connection used. This name was defined:

Defining the type of access for a connection Hide the details

<Connection>.Access = <Type of access>
<Connection>: Character string or Connection variable
Name of the connection used. This name was defined:
<Type of access>: Integer constant
Defining the type of access for a connection:
hOReadThe data files handled by the connection can be accessed in read-only mode. You only have the ability to read the records. No record can be added or deleted.
hOReadWriteThe data files handled by the connection can be accessed in read/write mode. You have the ability to read the records and to write new records.
Remarks
The CtAccess property is used to define the type of access to a data file handled 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