<ADODB_Connection>.CursorLocation

<< Click to Display Table of Contents >>

Navigation:  ThinBASIC Modules > ADODB > ADODB Module Classes > ADODB_Connection > ADODB_Connection Properties >

<ADODB_Connection>.CursorLocation

 

Description

 
Sets or returns a long value that indicates the location of the cursor service.

It can be set to one of the CursorLocationEnum values.

Default value is %AdUseServer.

 

Syntax

 

GET

n = <ADODB_Connection>.CursorLocation

 

SET

<ADODB_Connection>.CursorLocation = CursorLocation

 

Returns

 

Number: one of the CursorLocationEnum values.

 

Parameters

 

Name

Type

Optional

Meaning

CursorType

Number

Yes

one of the CursorLocationEnum values.

Default value is %AdUseServer.

 

Remarks

 

A cursor is used to:

control record navigation

control the visibility of changes in the database

control the updatability of data

 

Note: an ADODB_Recordset object inherits this setting from the associated ADODB_Connection object.

 

Restrictions

 

Note: this property is read-only on an open ADODB_Recordset object, and read/write on a ADODB_Connection object or on a closed ADODB_Recordset object.

 

See also

 

Examples