PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN

This content has been translated automatically. Click here to view the French version.
  • Miscellaneous
  • Equivalence
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
CtAccess (Property)
In french: CxAccès
OLE DBAvailable only with this kind of connection
The Property CxAccess allows you to manage the type of file access when connecting OLE DB to a specific table. You can:
  • Find out the type of access to the data file used for connecting to a table by OLE DB.
    The type of access can correspond to:
    • the type of access defined in the data model editor,
    • the type of access specified in HConnect, HDescribeConnection or HOpenConnection.
      This property can be used for a data file or for a connection defined in the data model editor or by programming.
  • Define the type of access to the data file used for connecting to a table by OLE DB (when the data file is described by programming).
    In this case, this property is equivalent to CtDescribedAccess.
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 defined:
  • in the data model editor during the description of the data file,
  • when the data file was described by programming.
Example
// Find out the type of access to the Customer data file
ResAccessType = Customer.CtAccess
Syntax

Finding out the type of access to the data file by 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.
hOReadWriteThe data file can be accessed in read/write. You have the ability to read the records and to write new records.
hOReadThe data file can be accessed in read-only. You only have the ability to read the records. No record can be added or deleted.
<Data file or Connection>: Character string (with or without quotes)

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

<Data file or Connection>.CtAccess = <Type of access>
<Data file or Connection>: Character string (with or without quotes)
<Type of access>: Constant
Defines the type of access to the data file.
hOReadWriteThe data file can be accessed in read/write. You have the ability to read the records and to write new records.
hOReadThe data file can be accessed in read-only. You only have the ability to read the records. No record can be added or deleted.
Remarks

Miscellaneous

CtDescribedAccess is used to find out and modify the type of access specified for the OLE DB connection when describing the data file.

Equivalence

The Property CtAccess allows to define the type of access on a data file handled by a connection. This property is kept for backward compatibility. It is recommended to use the Property Access. Access 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