ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage properties / HFSQL properties
  • Miscellaneous
  • Equivalence
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
CtAccess (Property)
In french: CxAccès
OLE DBAvailable only with this kind of connection
The CtAccess property sets the type of access to the data file when connecting to a specific table via OLE DB. You can:
  • Get the type of access to the data file used to connect to a table via OLE DB.
    The type of access can correspond to:
    • the type of access defined in the data model editor,
    • the type of access specified with HConnect, HDescribeConnection or HOpenConnection.
      This property can be used for a data file or connection defined in the data model editor or programmatically.
  • Define the type of access to the data file used for connecting to a table via OLE DB (only for data files defined programmatically).
    In this case, this property is equivalent to the CtDescribedAccess property.
Reminder: HConnect is used to redefine one or more parameters of the OLE DB connection to a table. By default, the characteristics of the OLE DB connection are set:
  • when defining the data file in the data model editor,
  • when defining the data file programmatically.
Example
// Get the type of access to the Customer data file
ResAccessType = Customer.CtAccess
Syntax

Getting the type of access to the data file via a connection Hide the details

<Type of access> = <Data file or Connection>.CtAccess
<Type of access>: Constant
Returns the type of access to the data file.
hOReadThe data file can be accessed in read-only mode. It is only possible to read records. It is not possible to add or remove records.
hOReadWriteThe data file can be accessed in read/write mode. It is possible to read and write new records.
<Data file or Connection>: Character string

Defining the type of access to the file via a connection Hide the details

<Data file or Connection>.CtAccess = <Type of access>
<Data file or Connection>: Character string
<Type of access>: Constant
Defines the type of access to the data file.
hOReadThe data file can be accessed in read-only mode. It is only possible to read records. It is not possible to add or remove records.
hOReadWriteThe data file can be accessed in read/write mode. It is possible to read and write new records.
Remarks

Miscellaneous

The CtDescribedAccess property gets and sets the type of access specified for the OLE DB connection when describing the data file.

Equivalence

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. The Access property is used to define the type of access to the data files handled by a connection.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/14/2024

Send a report | Local help