Vo2Ado Help
Contents
|
Index
|
Search
Getting Started
Introduction
References
OLE DB providers
Advantage
MsJet
MsOracle
MsSql
MySql
ODBC
Oracle
Sybase
Objects and Collections
Properties
Error Handling
Event handling
Data types
Binary values
ADO connections
Technical Support
Performance Issues
ADO Versions
Version History
Dataservers
AdoServer Class
Append()
Bof
BookMark
BookMark
CacheSize
CacheSize
Close()
Commit()
Connection
DBStruct
Delete()
Deleted
EoF
ErrInfo
Error()
Fcount
FieldGet()
FieldGetFormatted()
FieldPos()
FieldPut()
Filter
Filter
Find()
Flock()
Found
GetData()
GoBottom()
GoTo()
GoTop()
Init()
LastRec
Name
NoIVarGet()
NoIVarPut()
Notify()
NullAsBlank
NullAsBlank
OrderBy()
PageCount
PageNo
PageNo
PageSize
PageSize
Recall()
RecallAll()
RecCount
RecNo
RecnoColumn
RecnoColumn
RecordSet
RecordSet
Refresh()
Requery()
ResetNotification()
Resync()
Rlock()
RollBack()
Save()
Seek()
SetFilter()
SetIndex()
SetOrder()
SetDataField
SetRecordSet()
Skip()
Source
Source
SuspendNotification()
UnLock()
Update()
Used
AdoRelationServer Class
Append()
ClearRelation()
Filter
Filter
Notify()
Relation()
SetRelation()
SetSelectiveRelation()
AdoShapeServer Class
ClearRelation()
Notify()
Relation()
ResetNotification()
SetRelation()
StayInSync
StayInSync
SuspendNotification()
Compatibility Classes (Professional Version Only)
Classmate
SQL CLasses
SqlConnection
SqlStatement
SqlSelect
SqlTable
SqlList Classes
SQL Functions
Missing Classes
Ado Classes
AdoCommand Class
ActiveConnection
ActiveConnection
Cancel()
CommandStream
CommandStream
CommandText
CommandText
CommandTimeout
CommandTimeout
CommandType
CommandType
CreateParameter()
Dialect
Dialect
Execute()
Init()
Name
Name
NamedParameters
NamedParameters
Parameters_
Prepared
Prepared
State
AdoConnection Class
Attributes
Attributes
BeginTrans()
Cancel()
Close()
CommandTimeout
CommandTimeout
CommitTrans()
ConnectionString
ConnectionString
ConnectionTimeout
ConnectionTimeout
CursorLocation
CursorLocation
DefaultDatabase
DefaultDatabase
Destroy()
DisableEvents()
EnableEvents()
EventHandler
Errors
Execute()
Init()
IsolationLevel
IsolationLevel
Mode
Mode
Open()
OpenSchema()
Provider
Provider
RollbackTrans()
State
Version
AdoError Class
Description
HelpContext
HelpFile
NativeError
Number
Source
SQLState
AdoErrors Class
Clear()
AdoField Class
ActualSize
AppendChunk()
Attributes
Attributes
DefinedSize
DefinedSize
GetChunk()
Init()
Name
NumericScale
NumericScale
OriginalValue
Precision
Precision
Type
Type
UnderlyingValue
Value
Value
AdoFields Class
Append()
Delete()
Init()
Item
AdoParameter Class
AppendChunk()
Attributes
Attributes
Direction
Direction
Init()
Name
Name
NumericScale
NumericScale
Precision
Precision
Size
Size
Type
Type
Value
Value
AdoParameters Class
Append()
Delete()
AdoProperties Class
AdoProperty Class
Attributes
Attributes
Init()
Name
Type
Value
Value
AdoRecordset Class
AbsolutePage
AbsolutePage
AbsolutePosition
AbsolutePosition
ActiveCommand
ActiveConnection
ActiveConnection
AddNew()
BOF
Bookmark
Bookmark
CacheSize
CacheSize
Cancel()
CancelBatch()
CancelUpdate()
Clone()
Close()
CloseOnAxit
CloseOnAxit
Collect
Collect
CompareBookmarks()
CursorLocation
CursorLocation
CursorType
CursorType
DataMember
DataMember
DataSource
DataSource
Delete()
DisableEvents()
EditMode
EnableEvents()
EOF
EventHandler
FieldGet()
FieldPut()
Fields
Filter
Filter
Find()
GetRows()
GetString()
Index
Index
Init()
LockType
LockType
MarshalOptions
MarshalOptions
MaxRecords
MaxRecords
Move()
MoveFirst()
MoveLast()
MoveNext()
MovePrevious()
NextRecordset()
NoIvarGet()
NoIvarPut()
Open()
PageCount
PageSize
PageSize
RecordCount
Requery()
Resync()
Save()
Seek()
Sort
Sort
Source
Source
State
Status
StayInSync
StayInSync
Supports()
Update()
UpdateBatch()
Ado 2.5+ Classes
AdoRecord Class
ActiveConnection
ActiveConnection
Cancel()
Close()
CopyRecord()
DeleteRecord()
Fields
GetChildren()
Init()
Mode
Mode
MoveRecord()
Open()
ParentURL
RecordType
Source
Source
State
AdoStream Class
Cancel()
CharSet
CharSet
Close()
CopyTo()
EOS
Flush()
Init()
LineSeparator
LineSeparator
LoadFromFile()
Mode
Mode
Open()
Position
Position
Read()
ReadText()
SaveToFile()
SetEos()
Size
SkipLine()
State
Type
Type
Write()
WriteText()
Ado Events
AdoConnectionEventClass
AdoConnectionEvents Class
BeginTransComplete()
CommitTransComplete()
Connection
ConnectComplete()
Disconnect()
ExecuteComplete()
Infomessage()
RollBackTransComplete()
WillConnect()
WillExecute()
AdoDisableConnectionEvents
AdoDisableRecordSetEvents
AdoEnableConnectionEvents
AdoEnableRecordSetEvents
AdoEventHandler Class
AdoRecordSetEventClass
AdoRecordSetEvents Class
EndOfRecordSet()
FetchComplete()
FetchProgress()
FieldChangeComplete()
RecordSet
MoveComplete()
RecordChangeComplete()
RecordSetChangeComplete()
WillChangeField()
WillChangeRecord()
WillChangeRecordSet()
WillMove()
Adox Classes
AdoCatalog Class
ActiveConnection
ActiveConnection
Create()
GetObjectOwner()
Groups
Init()
Procedures
SetObjectOwner()
Tables
Users
Views
AdoColumn Class
Attributes
Attributes
DefinedSize
DefinedSize
Init()
Name
Name
NumericScale
NumericScale
ParentCatalog
ParentCatalog
Precision
Precision
Properties
RelatedColumn
RelatedColumn
SortOrder
SortOrder
Type
Type
AdoColumns Class
Append()
Delete()
AdoGroup Class
GetPermissions()
Init()
Name
Name
SetPermissions()
Users
AdoGroups Class
Append()
Delete()
AdoIndex Class
Clustered
Clustered
Columns
IndexNulls
IndexNulls
Init()
Name
Name
PrimaryKey
PrimaryKey
Properties
Unique
Unique
AdoIndexes Class
Append()
Delete()
AdoKey Class
Columns
DeleteRule
DeleteRule
Init()
Name
Name
RelatedTable
RelatedTable
Type
Type
UpdateRule
UpdateRule
AdoKeys Class
Append()
Delete()
AdoProcedure Class
Command
Command
DateCreated
DateModified
Init()
Name
AdoProcedures Class
Append()
Delete()
AdoTable Class
Columns
DateCreated
DateModified
Indexes
Init()
Keys
Name
Name
ParentCatalog
ParentCatalog
Properties
Type
AdoTables Class
Append()
Delete()
AdoUser Class
ChangePassword()
GetPermissions()
Groups
Init()
Name
Name
SetPermissions()
AdoUsers Class
Append()
Delete()
AdoView Class
Command
Command
DateCreated
DateModified
Init()
Name
AdoViews Class
Append()
Delete()
Enums
AdoActionEnum
AdoAffectEnum
AdoAllowNullsEnum
AdoAsyncThreadPriorityEnum
AdoAutoRecalcEnum
AdoBookmarkEnum
AdoColumnAttributesEnum
AdoCommandTypeEnum
AdoCompareEnum
AdoConnectModeEnum
AdoConnectOptionEnum
AdoConnectPromptEnum
AdoCopyRecordOptionsEnum
AdoCursorLocationEnum
AdoCursorOptionEnum
AdoCursorTypeEnum
AdoDataTypeEnum
AdoEditModeEnum
AdoErrorValueEnum
AdoEventReasonEnum
AdoEventStatusEnum
AdoExecuteOptionEnum
AdoFieldAttributeEnum
AdoFieldEnum
AdoFieldStatusEnum
AdoFilterGroupEnum
AdoGetRowsOptionEnum
AdoInheritTypeEnum
AdoIsolationLevelEnum
AdoKeyTypeEnum
AdoLineSeparatorEnum
AdoLockTypeEnum
AdoMarshalOptionsEnum
AdoMoveRecordOptionsEnum
AdoObjectStateEnum
AdoObjectTypeEnum
AdoParameterAttributesEnum
AdoParameterDirectionEnum
AdoPersistFormatEnum
AdoPositionEnum
AdoPropertyAttributesEnum
AdoRecordCreateOptionsEnum
AdoRecordOpenOptionsEnum
AdoRecordStatusEnum
AdoRecordTypeEnum
AdoResyncEnum
AdoRightsEnum
AdoRuleEnum
AdoSaveOptionsEnum
AdoSchemaEnum
AdoSearchDirectionEnum
AdoSeekEnum
AdoSortOrderEnum
AdoStreamOpenOptionsEnum
AdoStreamReadEnum
AdoStreamTypeEnum
AdoStreamWriteEnum
AdoStringFormatEnum
AdoUpdateCriteriaEnum
AdoUpdateResyncEnum
AdoXactAttributeEnum
Support Classes
AdoAdo Class
GetProperty()
Item
Item()
Properties
PropertyList()
AdoCollection Class
AsArray()
Count
ForEach()
Item
Item()
Refresh()
AdoDateTime Class
AsReal8()
AsSqlString()
AsString()
DateVal
DateVal
Init()
TimeString
TimeString
TimeVal
TimeVal
AdoDynaCollection Class
Delete()
Item
AdoLongBinary Class
AsString()
Init()
ProgId
SafeArray
Value
AdoObject Class
AdoVersion
AsOleAutoObject()
AsVoComObject()
Init()
Support Functions
AdoCollectionBase
AdoCheckNullString
AdoConnectionEventClass
AdoConvertNullStringToNull
AdoDate2Str
AdoDateTimeAsDate
AdoDisableConnectionEvents
AdoDisableRecordSetEvents
AdoDriverEdit
AdoDriverSelect
AdoEnableConnectionEvents
AdoEnableRecordSetEvents
AdoEnum2Str
AdoFieldType
AdoGetConnection
AdoLastError
AdoRecordSetEventClass
AdoServerCallClientError
AdoServerCallErrorHandler
AdoSetAdoVersion
AdoSetConnection
AdoStr2Enum
AdoVersion
Examples
Connection
1: SQL Server
2: MsJet
3: UDL
4: DriverSelect
5: Schema Info
Command
1: Simple Command
2: Stored Procedure 1
3: Stored Procedure 2
4: Stored Procedure 3
5: Multiple Resultsets
RecordSet
1: Collect access
2: Fields collection
3: Fields collection improved
4: Roll Your Own
5: DataShape
6: Cursor Types
Server
1: DataWindow
2: Bookmarks
3: Filters
4: RelationServer
5: Relation Window
6: Shapes
7: Source property
Other samples
1: Framework
2: DateTime
3: Events
4: Jet & Excel
Explorers
Catalog Explorer
Data Explorer
Third Party
bBrowser
Editors
The Vo2Ado Server Editor
Connection Editor
Server Info
Browse window
Display structure
Table Range
Toolbar Buttons
Setup defaults
Templates
Connection Templates
Server Templates
FieldSpec templates
Callback Templates
The Editor Sourcecode
The Vo2Ado RDD
Basics
Welcome to the Vo2Ado RDD
Compatibility with existing RDDs
Getting Started
Basic Usage
Known Problems
Workarea Operations
Names and reserved words
Long Field Names
Validations and Integrity
Connections
Table files or Table Callback
Transactions
Converting from DBF to SQL
Error Handling
Version History
Indexes
Index getting started
Index Files or indexes through a callback
Index support
Index expressions
Index Expression with Descend()
Index expression examples
Using the RDD
Using the RDD with the DbServer Editor
Using the RDD with ReportPro
CallBacks
Connection CallBack Methods
AfterConnect
AfterDisconnect
BeforeConnect
BeforeDisconnect
RDD Support Library
AdoDb() functions
Overview
AdoDbClearRecordSet
AdoDbDropTable
AdoDbGetConnection
AdoDbGetConnectionString
AdoDbGetRecordSet
AdoDbGetServerFilter
AdoDbGetSQLString
AdoDbHasTransaction
AdoDbLongFieldNames
AdoDbSaveConnection
AdoDbSaveProvider
AdoDbSaveTableDef
AdoDbSetServerFilter
AdoDbTransactionBegin
AdoDbTransactionCommit
AdoDbTransactionRollBack
AdoDbServer Class
List of additional INFO() commands
Special Callback functions
Enum values
Appendices
Error Codes
File structures
Table file structure
Connection file structure
Index file structure
Microsoft SQL Server Functions
Microsoft Jet Engine Functions
Oracle Functions
ODBC Functions
Advantage OleDb functions
Requirements
Specifications
About us
© 1999-2021 - Solution Application Software