SCIROCCO Software Development, Database Design and Consulting
Properties, Methods and Events for the SCIROCCO DAO Data Control 1.0
(If you have any questions or need help using the control please contact . It will be our pleasure to assist you.)
Properties Methods Events
Data
DatabaseExclusive
DatabaseReadOnly
LockType
Recordset (Object)
RecordsetOptions
RecordsetType
WorkSpaceType
Appearance
AboutVisible
BackColor
CaptionOn
Enabled
FontName
FontSize
Height
Language
MousePointer
PictureOn
Visible
Width
Misc
Version
Recordset
OpenRecordset
CloseRecordset
Misc
About
StartUp
Initialize
Data
AddNewComplete
DeleteComplete
RefreshComplete
UndoComplete
SaveComplete
Navigation
MoveFirstComplete
MovePreviousComplete
MoveNextComplete
MoveLastComplete
Close
Terminate
CloseClicked

Data Properties
DatabaseExclusive

For Microsoft Jet workspaces you can use the following values. The WorkSpaceType must be set to dbUseJet.

Setting Description
True Opens the database in exclusive mode. Not more then one-user connected at a time.
False Default. Opens the database in shared mode. Multiple users can connect simultaneously.
Return to Top
DatabaseReadOnly

Specifies if the database is Read-Only or Read/Write.

Setting Description
True Opens the database with read-only access.
False Default. Opens the database with read/write access.
Return to Top
LockType

Specifies the lock type used.

Constant Description
dbOptimistic Default. Optimistic concurrency based on record ID. Cursor compares record ID in old and new records to determine if changes have been made since the record was last accessed.
dbOptimisticBatch Enables batch optimistic updating. The WorkSpaceType must be set to dbUseODBC.
dbOptimisticValue Uses optimistic concurrency based on row values. The WorkSpaceType must be set to dbUseODBC.
dbPessimistic Uses pessimistic locking to determine how changes are made to the Recordset in a multiuser environment. The page containing the record you're editing is locked as soon as you any editing is done.
Return to Top
Recordset (Object)

You can set or retrieve the current recordset being used by the Data Control using this Object Property. It represents an open DAO recordset.

The Object property is very useful when you want to set the Data Control to another recordset.

Syntax Example:

Set SCIROCCODAODataControl.Recordset = MyRecordset

Return to Top
RecordsetOptions

Optional. A combination of constants that specify characteristics of the new Recordset, as listed below.

You can use a combination of the following constants for the RecordsetOptions argument.

Constant Description
dbAppendOnly Allows users to append new records to the Recordset, but prevents them from editing or deleting existing records. (Microsoft Jet only)
dbSQLPassThrough Passes an SQL statement to a Microsoft Jet-connected ODBC data source for processing (Microsoft Jet snapshot-type Recordset only).
dbSeeChanges Generates a run-time error if one user is changing data that another user is editing (Microsoft Jet dynaset-type Recordset only). This is useful in applications where multiple users have simultaneous read/write access to the same data.
dbDenyWrite Prevents other users from modifying or adding records (Microsoft Jet Recordset objects only).
dbDenyRead Prevents other users from reading data in a table (Microsoft Jet table-type Recordset only).
dbForwardOnly Creates a forward-only Recordset (Microsoft Jet snapshot-type Recordset only). It is provided only for backward compatibility, and you should use the dbOpenForwardOnly constant in the type argument instead of using this option.
dbReadOnly Prevents users from making changes to the Recordset (Microsoft Jet only). The dbReadOnly constant in the lockedits argument replaces this option, which is provided only for backward compatibility.
dbRunAsync Runs an asynchronous query (ODBCDirect workspaces only).
dbExecDirect Runs a query by skipping SQLPrepare and directly calling SQLExecDirect (ODBCDirect workspaces only). Use this option only when you’re not opening a Recordset based on a parameter query. For more information, see the "Microsoft ODBC 3.0 Programmer’s Reference."
dbInconsistent Allows inconsistent updates (Microsoft Jet dynaset-type and snapshot-type Recordset objects only).
dbConsistent Allows only consistent updates (Microsoft Jet dynaset-type and snapshot-type Recordset objects only).
Return to Top
RecordsetType

Specifies the type of recordset used by the control.

You can use one of the following constants for the RecordsetType argument.

Constant Description
dbOpenTable Opens a table-type Recordset object (Microsoft Jet workspaces only).
dbOpenDynamic Opens a dynamic-type Recordset object, which is similar to an ODBC dynamic cursor. (ODBCDirect workspaces only)
dbOpenDynaset Default. Opens a dynaset-type Recordset object, which is similar to an ODBC keyset cursor.
dbOpenSnapshot Opens a snapshot-type Recordset object, which is similar to an ODBC static cursor.
dbOpenForwardOnly  Opens a forward-only-type Recordset object.
Return to Top
WorkSpaceType

Specifies the Type of WorkSpace used by the control.

You can use the following constants for WorkSpaceType.

Constant Description
dbUseJet Creates a Microsoft Jet workspace.
dbUseODBC Creates an ODBCDirect workspace.
Return to Top

Appearance Properties
AboutVisible

This property is only available on the registered control. Set this property to make visible or hide the About button.

Constant Value Description
True 1 Default. About button is visible.
False 0 About button is hidden.
Return to Top
BackColor

Returns or sets the background color of the control.

Return to Top
CaptionOn

Set this property to make visible or hide the captions of the buttons.

Constant Value Description
True 1 Captions are is visible.
False 0 Default. Captions are hidden. Pictures are visible.
Return to Top
Enabled

This attribute specifies if the control is enabled or disabled. The buttons appear gray when disabled.

Constant Value Description
True 1 Default. Control is enabled. Features that your Data Provider does not support, or depending on your choice of properties are automatically disabled i.e. If you you choose a LockType=adLockReadOnly the Add New, Delete, Refresh, Undo and Save buttons will be disabled even if the control is enabled.
False 0 Control is disabled.
Return to Top
FontName

Returns or sets the font used by the captions in the control.

Return to Top
FontSize

Returns or sets the font size used by the captions in the control.

Return to Top
Height

Returns or sets the height dimension of the control.

Return to Top
Language

Returns or sets the language of the control

Constant Value Description
adEnglish 0 Default. Control captions and messages are in English.
adFrench 1 Control captions and messages are in French.
adSpanish 2 Control captions and messages are in Spanish.
adGerman 3 Control captions and messages are in German.
adItalian 4 Control captions and messages are in Italian.
adSwedish 5 Default. Control captions and messages are in Swedish.
Return to Top
MousePointer

Returns or sets a value indicating the type of mouse pointer displayed when the mouse is over the control at run time.

Constant Value Description
vbDefault 0 (Default) Shape determined by the object.
vbArrow 1 Arrow.
vbCrosshair 2 Cross (crosshair pointer).
vbIbeam 3 I beam.
vbIconPointer 4 Icon (small square within a square).
vbSizePointer 5 Size (four-pointed arrow pointing north, south, east, and west).
vbSizeNESW 6 Size NE SW (double arrow pointing northeast and southwest).
vbSizeNS 7 Size N S (double arrow pointing north and south).
vbSizeNWSE 8 Size NW SE (double arrow pointing northwest and southeast).
vbSizeWE 9 Size W E (double arrow pointing west and east).
vbUpArrow 10 Up Arrow.
vbHourglass 11 Hourglass (wait).
vbNoDrop 12 No Drop.
vbArrowHourglass 13 Arrow and hourglass.
vbArrowQuestion 14 Arrow and question mark.
vbSizeAll 15 Size all.
Return to Top
PictureOn

Set this property to make visible or hide the pictures of the buttons.

Constant Value Description
True 1 Default. Pictures are visible.
False 0 Pictures are hidden. Captions are visible.
Return to Top
Visible

Returns or sets a value indicating whether an the control is visible or hidden.

Setting Description
True Default. Control is visible.
False Control is hidden.
Return to Top
Width

Returns or sets the width dimension of the control.

Return to Top

Misc Properties
Version

Returns the version of the control.

Return to Top

Recordset Methods
OpenRecordset

Creates and opens a new Recordset object and appends it to the control. The SCIROCCO DAO Data Control is now bound to this recordset.

Syntax

SCIROCCODAODataControl.OpenRecordset (SQLStatement, DatabasePath, ODBCConnectionString )

The OpenRecordset method syntax has these parts.

Part Description
SQLStatement A valid SQL Statement compatible with the Data Provider you are using.
i.e. SELECT * FROM Authors
DatabasePath String that represents the Database path that you want to open.
ODBCConnectionString Optional. A String that specifies various connection information, including passwords.
Return to Top
CloseRecordset

Closes recordset and releases it from memory.

Syntax

SCIROCCODAODataControl.CloseRecordset()

Return to Top

Misc Methods
About

Displays the About Screen.

Syntax

SCIROCCOADODataControl.About()

Return to Top

StartUp Events
Initialize

Occurs after the control is loaded into memory. You can use this event to open your recordset or bind your controls.

Return to Top

Data Events
AddNewComplete

Occurs after clicking the Add New button and the successful addition of a new record.

Return to Top
DeleteComplete

Occurs after clicking the Delete button and the successful deletion of the current record.

Return to Top
RefreshComplete

Occurs after clicking the Refresh button and a successful refresh of the data.

Return to Top
UndoComplete

Occurs after clicking the Undo button and a successful restoring of the data.

Return to Top
SaveComplete

Occurs after clicking the Save button and a successful save of the data.

Return to Top

Navigation Events
MoveFirstComplete

Occurs after clicking the Move First button and the current record has become the first record.

Return to Top
MovePreviousComplete

Occurs after clicking the Move Previous button and the current record has become the previous or first record.

Return to Top
MoveNextComplete

Occurs after clicking the Move Next button and the current record has become the next or last record.

Return to Top
MoveLastComplete

Occurs after clicking the Move Last button and the current record has become the last record.

Return to Top

Close Events
Terminate

Occurs before the control will be released from memory.

Return to Top
CloseClicked

Occurs after clicking the Close button and before the Terminate event.

Return to Top


   Copyright © 2004  All rights reserved.
  		Software LIcense