The following table identifies which methods and properties of ADO objects are supported and which are not supported by the SAS Data Providers.
Note:The SAS Data Providers do not support the ICommandWithParameters interface, so the Parameter object and Parameter collection are not supported and are not included in the table.
| SUPPORTED | UNSUPPORTED | |||
|---|---|---|---|---|
| ADO Object | Methods | Properties | Methods | Properties |
| Connection |
Close ConnectionString Open Execute OpenSchema |
Attributes CursorLocation Mode Provider State |
BeginTrans Cancel CommitTrans RollbackTrans |
CommandTimeout ConnectionTimeout DefaultDatabase IsolationLevel |
| Command |
Execute |
ActiveConnection CommandText CommandType Name Prepared State |
Cancel CreateParameter |
CommandTimeout |
| Recordset |
AddNew CacheSize CancelBatch CancelUpdate Close Clone Delete Find GetRows GetString Move MoveFirst MoveLast MoveNext MovePrevious Open Requery Save Supports Update UpdateBatch |
AbsolutePage AbsolutePosition BOF Bookmark CursorLocation CursorType Data Source EditMode EOF Filter LockType MaxRecords PageCount PageSize RecordCount Sort State |
Cancel CompareBookmarks NextRecordset Resync Seek |
ActiveCommand DataMember Index MarshalOptions Status StayInSync Source |
| Error |
|
Description Number Source |
|
HelpContext HelpFile NativeError SQLState |
| Errors Collection |
Clear Refresh |
Count Item |
|
|
| Field |
|
ActualSize Attributes DefinedSize Name NumericScale Precision Type Value |
AppendChunk GetChunk |
DataFormat OriginalValue UnderlyingValue |
| Fields Collection |
Append Refresh |
Count Item |
Delete |
|
| Property |
|
Attributes Name Type Value |
|
|
| Properties Collection |
Refresh |
Count Item |
|
|