CtAccess (Property)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

InfoThumbnailGeneration

OperationLogDirectory

Password

PasswordProtected

PersistedCalculatedItem

RepeatableReadSupported

Miscellaneous
Equivalence

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

CtAccess (Property)

In french: CxAccès

Available only with this kind of connection

..CtAccess is used to manage the type of access to the file during the OLE DB connection 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 Customer file
ResAccessType = Customer..CtAccess

Syntax

Finding out the type of access to the data file by a connection Hide the details

<Type of access> = <File name>..CtAccess

<Type of access>: Constant

Returns the type of access to the data file.
hOReadWrite The data file can be accessed in read/write. You have the ability to read the records and to write new records.
hORead The data file can be accessed in read-only. You only have the ability to read the records. No record can be added or deleted.

<File name>: Character string (with or without quotes)

Name of data file used. This name was defined in the data model editor or by the File description type.
Name of connection used. This name was defined in the data model editor, or by #HDescribeConnection or HOpenConnection.

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

<File name>..CtAccess = <Type of access>

<File name>: Character string (with or without quotes)

Name of data file used. This name was defined in the data model editor or by the File description type.
Name of connection used. This name was defined in the data model editor or by HDescribeConnection or HOpenConnection.

<Type of access>: Constant

Defines the type of access to the data file.
hOReadWrite The data file can be accessed in read/write. You have the ability to read the records and to write new records.
hORead The 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

..CtAccess is used to manage the type of access to a data file handled by a connection. This property is kept for backward compatibility. We recommend that you use ..Access. ..Access is used to define the type of access to the data files handled by a connection.