RSS
| << C.1.13- The Stream Object | AppendixC | C.1.2- The Connection Object >> |
Method Calls – Syntax
Command
Command.Cancel
Parameter = Command.CreateParameter([Name As String], [Type As DataTypeEnum], _
[Direction As ParameterDirectionEnum], _
[Size As Long], [Value As Variant])
Recordset = Command.Execute([RecordsAffected As Variant], [Parameters As Variant], _
[Options As Long])
Connection
Long = Connection.BeginTrans
Connection.Cancel
Connection.Close
Connection.CommitTrans
Recordset = Connection.Execute(CommandText As String, _
[RecordsAffected As Variant], _
[Options As Long])
Connection.Open([ConnectionString As String], [UserID As String], _
[Password As String], [Options As Long])
Recordset = Connection.OpenSchema(Schema As SchemaEnum, _
[Restrictions As Variant], _
[SchemaID As Variant])
Connection.RollbackTrans
Errors
Errors.Clear
Errors.Refresh
Field
Field.AppendChunk(Data As Variant)
Variant = Field.GetChunk(Length As Long)
Fields
Fields.Append(Name As String, Type As DataTypeEnum, [DefinedSize As Long], _
[Attrib As FieldAttributeEnum], [FieldValue As Variant])
Fields.CancelUpdate
Fields.Delete(Index As Variant)
Fields.Refresh
Fields.Resync(ResyncValues As ResyncEnum)
Fields.Update
Parameter
Parameter.AppendChunk(Val As Variant)
Parameters
Parameters.Append(Object As Object)
Parameters.Delete(Index As Variant)
Parameters.Refresh
Properties
Properties.Refresh
Record
Record.Cancel
Record.Close
String = Record.CopyRecord([Source As String], Destination As String, _
[UserName As String], [Password As String], _
[Options As CopyRecordOptionsEnum], _
[Async As Boolean])
Record.DeleteRecord(Source As String, Async As Boolean)
Recordset = Record.GetChildren
String = Record.MoveRecord([Source As String], Destination As String, _
[UserName As String], [Password As String], _
[Options As MoveRecordOptionsEnum], _
[Async As Boolean])
Record.Open([Source As Variant], [ActiveConnection As Variant],_
[Mode As ConnectModeEnum], [CreateOptions As RecordCreateOptionsEnum], _
[Options As RecordOpenOptionsEnum], [UserName As String], _
[Password As String])
Recordset
Recordset.AddNew([FieldList As Variant], [Values As Variant])
Recordset.Cancel
Recordset.CancelBatch([AffectRecords As AffectEnum])
Recordset.CancelUpdate
Recordset = Recordset.Clone([LockType As LockTypeEnum])
Recordset.Close
CompareEnum = Recordset.CompareBookmarks(Bookmark1 As Variant,_
Bookmark2 As Variant)
Recordset.Delete(AffectRecords As AffectEnum)
Recordset.Find(Criteria As String, [SkipRecords As Long], _
[SearchDirection As SearchDirectionEnum], [Start As Variant])
Variant = Recordset.GetRows(Rows As Long, [Start As Variant], [Fields As Variant])
String = Recordset.GetString(StringFormat As StringFormatEnum, [NumRows As Long], _
[ColumnDelimeter As String], [RowDelimeter As String], _
[NullExpr As String])
Recordset.Move(NumRecords As Long, [Start As Variant])
Recordset.MoveFirst
Recordset.MoveLast
Recordset.MoveNext
Recordset.MovePrevious
Recordset = Recordset.NextRecordset([RecordsAffected As Variant])
Recordset.Open([Source As Variant], [ActiveConnection As Variant], _
[CursorType As CursorTypeEnum], [LockType As LockTypeEnum], _
[Options As Long])
Recordset.Requery([Options As Long])
Recordset.Resync([AffectRecords As AffectEnum], [ResyncValues As ResyncEnum])
Recordset.Save([Destination As Variant], [PersistFormat As PersistFormatEnum])
Recordset.Seek(KeyValues As Variant, SeekOption As SeekEnum)
Boolean = Recordset.Supports(CursorOptions As CursorOptionEnum)
Recordset.Update([Fields As Variant], [Values As Variant])
Recordset.UpdateBatch([AffectRecords As AffectEnum])
Stream
Stream.Cancel
Stream.Close
Stream.CopyTo(DestStream As Stream, [CharNumber As Long])
Stream.Flush
Stream.LoadFromFile(FileName As String)
Stream.Open([Source As Variant], [Mode As ConnectModeEnum], _
[Options As StreamOpenOptionsEnum], [UserName As String],_
[Password As String])
Variant = Stream.Read([NumBytes As Long])
String = Stream.ReadText([NumChars As Long])
Stream.SaveToFile(FileName As String, Options As SaveOptionsEnum)
Stream.SetEOS
Stream.SkipLine
Stream.Write(Buffer As Variant)
Stream.WriteText(Data As String, [Options As StreamWriteEnum])
| << C.1.13- The Stream Object | AppendixC | C.1.2- The Connection Object >> |
