Navigation:  Functions > Enum Functions >

DaoRecordsetOptionEnum() Function

Previous pageReturn to chapter overviewNext page

Purpose

Returns a 2-dimensional array with all the values of the RecordSetOption Enum.

 

Description

Every row in this array has 2 values:

The numeric value of the Enum value
A text representation of this value

 

This array can be used to validate values, and to print a ,meaningful description of the values during debugging

You can pass this array tro the DaoEnum2Str() function to convert the value of an Enum to a string

 

ConstantDescription        
dbDenyWritePrevents other users from changing Recordset records (Microsoft Jet workspaces only).        
dbDenyReadPrevents other users from reading Recordset records (table-type in Microsoft Jet workspaces only).        
dbReadOnlyOpens the Recordset as read-only (Microsoft Jet workspaces only).        
dbAppendOnlyAllows user to add new records to the dynaset, but prevents user from reading existing records (dynaset-type in Microsoft Jet workspaces only).        
dbInconsistentApplies updates to all dynaset fields, even if other records are affected (dynaset- and snapshot-type in Microsoft Jet workspaces only).        
dbConsistentApplies updates only to those fields that will not affect other records in the dynaset (dynaset- and snapshot-type in Microsoft Jet workspaces only).        
dbSQLPassThroughSends an SQL statement to an ODBC database (snapshot-type in Microsoft Jet workspaces only).        
dbForwardOnlyCreates a forward-only scrolling snapshot-type Recordset (snapshot-type in Microsoft Jet workspaces only).        
dbSeeChangesGenerates a run-time error if another user is changing data you are editing (dynaset-type in Microsoft Jet workspaces only).        
dbRunAsyncExecutes the query asynchronously (ODBCDirect workspaces only).        
dbExecDirectExecutes the query without first calling the SQLPrepare ODBC function (ODBCDirect workspaces only).        

 

 

 

 

Returns

Array

 

See Also

DaoEnum2Str()