Xs2Ado Help
Contents
|
Index
|
Search
Getting Started
Introduction
Differences between Vo2Ado to Xs2Ado
Converting from Vo2Ado to Xs2Ado
OLE DB providers
Advantage
MsJet
MsOracle
MsSql
MySql
ODBC
Oracle
Sybase
Objects and Collections
Properties
Error Handling
Event handling
Data types
ADO connections
Technical Support
Performance Issues
ADO Versions
Version History
Dataservers
AdoServer Class
Constructor
Methods
Append()
Close()
Commit()
Error()
Delete()
FieldGet()
FieldGetFormatted()
FieldPos()
FieldPut()
Find()
Flock()
GetData()
GoBottom()
GoTo()
GoTop()
NoIVarGet()
NoIVarPut()
Notify()
OrderBy()
Recall()
RecallAll()
RecCount
Refresh()
Requery()
ResetNotification()
Resync()
Rlock()
RollBack()
Save()
Seek()
SetFilter()
SetIndex()
SetOrder()
SetDataField
SetRecordSet()
Skip()
SuspendNotification()
UnLock()
Update()
Properties
Bof
BookMark
CacheSize
Connection
DBStruct
Deleted
EoF
ErrInfo
Fcount
Filter
Found
LastRec
Name
NullAsBlank
PageCount
PageNo
PageSize
RecNo
RecnoColumn
RecordSet Access
Source Access
Used Access
AdoRelationServer Class
Properties
Filter Access
Methods
Append()
ClearRelation()
Notify()
Relation()
SetRelation()
SetSelectiveRelation()
AdoShapeServer Class
Methods
ClearRelation()
Notify()
Relation()
ResetNotification()
SetRelation()
SuspendNotification()
Properties
StayInSync Access
Classmate
Ado Classes
AdoCommand Class
.ctor()
ActiveConnection
Cancel()
CommandStream
CommandText
CommandTimeout
CommandType
CreateParameter()
Dialect
Execute()
Name
NamedParameters
Parameters_
Prepared
State
AdoConnection Class
.ctor()
Attributes
BeginTrans()
Cancel()
Close()
CommandTimeout
CommitTrans()
ConnectionString
ConnectionTimeout
CursorLocation
DefaultDatabase
Destroy()
DisableEvents()
EnableEvents()
EventHandler
Errors
Execute()
IsolationLevel
Mode
Open()
OpenSchema()
Provider
RollbackTrans()
State
Version
AdoError Class
Description
HelpContext
HelpFile
NativeError
Number
Source
SQLState
AdoErrors Class
Clear()
AdoField Class
.ctor()
Attributes
ActualSize
AppendChunk()
DefinedSize
GetChunk()
Name
NumericScale
OriginalValue
Precision
Type
UnderlyingValue
Value
AdoFields Class
Append()
Delete()
Init()
Item
AdoParameter Class
AppendChunk()
Attributes
Direction
Init()
Name
NumericScale
Precision
Size
Type
Value
AdoParameters Class
Append()
Delete()
AdoProperties Class
AdoProperty Class
Attributes
Init()
Name
Type
Value
AdoRecord Class
ActiveConnection
Cancel()
Close()
CopyRecord()
DeleteRecord()
Fields
GetChildren()
Init()
Mode
MoveRecord()
Open()
ParentURL
RecordType
Source
State
AdoRecordset Class
AbsolutePage
AbsolutePosition
ActiveCommand
ActiveConnection
AddNew()
BOF
Bookmark
CacheSize
Cancel()
CancelBatch()
CancelUpdate()
Clone()
Close()
CloseOnAxit
Collect
CompareBookmarks()
CursorLocation
CursorType
DataMember
DataSource
Delete()
DisableEvents()
EditMode
EnableEvents()
EOF
EventHandler
FieldGet()
FieldPut()
Fields
Filter
Find()
GetRows()
GetString()
Index
Init()
LockType
MarshalOptions
MaxRecords
Move()
MoveFirst()
MoveLast()
MoveNext()
MovePrevious()
NextRecordset()
NoIvarGet()
NoIvarPut()
Open()
PageCount
PageSize
RecordCount
Requery()
Resync()
Save()
Seek()
Sort
Source
State
Status
StayInSync
Supports()
Update()
UpdateBatch()
AdoStream Class
Cancel()
CharSet
Close()
CopyTo()
EOS
Flush()
Init()
LineSeparator
LoadFromFile()
Mode
Open()
Position
Read()
ReadText()
SaveToFile()
SetEos()
Size
SkipLine()
State
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
Create()
GetObjectOwner()
Groups
Init()
Procedures
SetObjectOwner()
Tables
Users
Views
AdoColumn Class
Attributes
DefinedSize
Init()
Name
NumericScale
ParentCatalog
Precision
Properties
RelatedColumn
SortOrder
Type
AdoColumns Class
Append()
Delete()
AdoGroup Class
GetPermissions()
Init()
Name
SetPermissions()
Users
AdoGroups Class
Append()
Delete()
AdoIndex Class
Clustered
Columns
IndexNulls
Init()
Name
PrimaryKey
Properties
Unique
AdoIndexes Class
Append()
Delete()
AdoKey Class
Columns
DeleteRule
Init()
Name
RelatedTable
Type
UpdateRule
AdoKeys Class
Append()
Delete()
AdoProcedure Class
Command
DateCreated
DateModified
Init()
Name
AdoProcedures Class
Append()
Delete()
AdoTable Class
Columns
DateCreated
DateModified
Indexes
Init()
Keys
Name
ParentCatalog
Properties
Type
AdoTables Class
Append()
Delete()
AdoUser Class
ChangePassword()
GetPermissions()
Groups
Init()
Name
SetPermissions()
AdoUsers Class
Append()
Delete()
AdoView Class
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
Unsupported Classes
AdoAdo Class
GetProperty()
Item
Item()
Properties
PropertyList()
AdoCollection Class
AsArray()
Count
ForEach()
Item
Item()
Refresh()
AdoDateTime Class
AsReal8()
AsSqlString()
AsString()
DateVal
Init()
TimeString
TimeVal
AdoObject Class
AdoVersion
AsOleAutoObject()
AsVoComObject()
Init()
Support Functions
Unsupported Functions
AdoCollectionBase
AdoConnectionEventClass
AdoDate2Str
AdoDateTimeAsDate
AdoDecimalAsFloat
AdoDisableConnectionEvents
AdoDisableRecordSetEvents
AdoDriverEdit
AdoDriverSelect
AdoEnableConnectionEvents
AdoEnableRecordSetEvents
AdoEnum2Str
AdoFieldType
AdoGetConnection
AdoLastError
AdoRecordSetEventClass
AdoServerCallClientError
AdoServerCallErrorHandler
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
© 1999-2021 - Solution Application Software