sSQL = SELECT user_ID, user_LName, user_EMail FROM users;

0) typename: String
SELECT user_ID, user_LName, user_EMail FROM users;

1) typename: Recordset
PropertyValueType
AbsolutePage1Long
AbsolutePosition1Long
{...}
PropertyValueType
ActiveConnectionProvider=MSDataShape.1;Persist Security Info=True;Data Source=C:\Inetpub\vhosts\gladhillassociates.com\httpdocs\_data\db\gladhill_14.1.mdb;Data Provider=Microsoft.Jet.OLEDB.4.0Connection
CommandStreamNothing
CommandTextSELECT user_ID, user_LName, user_EMail FROM users;String
CommandTimeout30Long
CommandType8Long
Dialect{C8B521FB-5CF3-11CE-ADE5-00AA0044773D}String
NameString
NamedParametersFalseBoolean
0Parameters
PreparedFalseBoolean
{Count = 103}
NameValueAttributesType
IAccessorTrue513adBoolean
IChapteredRowsetTrue1537adBoolean
IColumnsInfoTrue513adBoolean
IColumnsRowsetTrue513adBoolean
IConnectionPointContainerTrue513adBoolean
IConvertTypeTrue513adBoolean
ILockBytesFalse513adBoolean
IRowsetTrue513adBoolean
IDBAsynchStatusFalse1537adBoolean
IParentRowsetTrue513adBoolean
IRowsetChangeTrue1537adBoolean
IRowsetExactScrollTrue513adBoolean
IRowsetFindTrue1537adBoolean
IRowsetIdentityTrue513adBoolean
IRowsetInfoTrue513adBoolean
IRowsetLocateTrue513adBoolean
IRowsetRefreshTrue1537adBoolean
IRowsetResynchFalse513adBoolean
IRowsetScrollTrue513adBoolean
IRowsetUpdateTrue1537adBoolean
IRowsetViewTrue1537adBoolean
IRowsetIndexFalse513adBoolean
ISequentialStreamTrue513adBoolean
IStorageFalse513adBoolean
IStreamFalse513adBoolean
ISupportErrorInfoTrue513adBoolean
Preserve on AbortTrue513adBoolean
Access Order2513adInteger
Append-Only RowsetFalse1537adBoolean
Blocking Storage ObjectsFalse1537adBoolean
Use BookmarksTrue513adBoolean
Skip Deleted BookmarksTrue513adBoolean
Bookmark Type1513adInteger
Cache Deferred ColumnsFalse513adBoolean
Fetch BackwardsTrue513adBoolean
Hold RowsTrue1537adBoolean
Scroll BackwardsTrue513adBoolean
Change Inserted RowsTrue513adBoolean
Column PrivilegesFalse513adBoolean
Command Time Out301537adInteger
Preserve on CommitTrue513adBoolean
Defer ColumnFalse513adBoolean
Delay Storage Object UpdatesTrue513adBoolean
Private11537adBSTR
Filter Operations27513adInteger
Find Operations27513adInteger
Hidden Columns0513adInteger
Immobile RowsTrue513adBoolean
Literal BookmarksTrue513adBoolean
Literal Row IdentityTrue513adBoolean
Maximum Open Rows0513adInteger
Maximum Pending Rows0513adInteger
Maximum Rows01537adInteger
Column WritableFalse513adBoolean
Memory Usage0513adInteger
Notification Granularity1513adInteger
Notification Phases31513adInteger
Column Set Notification3513adInteger
Row Delete Notification3513adInteger
Row First Change Notification3513adInteger
Row Insert Notification3513adInteger
Row Resynchronization Notification3513adInteger
Rowset Release Notification3513adInteger
Rowset Fetch Position Change Notification3513adInteger
Row Undo Change Notification3513adInteger
Row Undo Delete Notification3513adInteger
Row Undo Insert Notification3513adInteger
Row Update Notification3513adInteger
Bookmarks OrderedTrue513adBoolean
Others' Inserts VisibleFalse513adBoolean
Others' Changes VisibleFalse513adBoolean
Own Inserts VisibleTrue513adBoolean
Own Changes VisibleTrue513adBoolean
Quick RestartTrue513adBoolean
Reentrant EventsTrue513adBoolean
Remove Deleted RowsTrue513adBoolean
Report Multiple ChangesFalse513adBoolean
Return Pending InsertsTrue513adBoolean
Row PrivilegesFalse513adBoolean
Asynchronous Rowset Processing01537adInteger
Row Threading Model1513adInteger
Server CursorFalse513adBoolean
Strong Row IdentityTrue513adBoolean
Objects TransactedFalse513adBoolean
Unique RowsFalse513adBoolean
Updatability71537adInteger
Batch Size151537adInteger
Update Criteria21537adInteger
Background Fetch Size151537adInteger
Initial Fetch Size501537adInteger
Background thread Priority31537adInteger
Cache Child RowsTrue1537adBoolean
Maintain Change StatusFalse1537adBoolean
Auto Recalc11537adInteger
Unique Table1537adBSTR
Unique Schema1537adBSTR
Unique Catalog1537adBSTR
Resync Command1537adBSTR
Cursor Engine Version100513adInteger
Reshape Name513adBSTR
Update Resync11537adInteger
Release Shape On DisconnectFalse1537adBoolean
BookmarkableTrue513adBoolean
Properties
State0Long
Command
ActiveConnectionProvider=MSDataShape.1;Persist Security Info=True;Data Source=C:\Inetpub\vhosts\gladhillassociates.com\httpdocs\_data\db\gladhill_14.1.mdb;Data Provider=Microsoft.Jet.OLEDB.4.0Connection
BOFFalseBoolean
Bookmark1Double
CacheSize1Long
CursorLocation3Long
CursorType3Long
DataMemberString
EditMode0Long
EOFFalseBoolean
{Count = 3}
ActualSize4Long
Attributes90Long
DataFormatNothingNothing
DefinedSize4Long
Nameuser_IDString
NumericScale255Byte
OriginalValue1Long
Precision10Byte
{Count = 9}
NameValueAttributesType
BASECOLUMNNAMEuser_ID1adVarWChar
BASETABLENAMEusers1adVarWChar
BASECATALOGNAMENull1adVarWChar
BASESCHEMANAMENull1adVarWChar
KEYCOLUMNTrue1adBoolean
ISAUTOINCREMENTTrue1adBoolean
RELATIONCONDITIONSNull1adVarBinary
CALCULATIONINFONull1adVarBinary
OPTIMIZEFalse1adBoolean
Properties
Status0Long
Type3Long
UnderlyingValue1Long
Value1Long
ActualSize22Long
Attributes106Long
DataFormatNothingNothing
DefinedSize50Long
Nameuser_LNameString
NumericScale255Byte
OriginalValueWitherspoonString
Precision255Byte
{Count = 9}
NameValueAttributesType
BASECOLUMNNAMEuser_LName1adVarWChar
BASETABLENAMEusers1adVarWChar
BASECATALOGNAMENull1adVarWChar
BASESCHEMANAMENull1adVarWChar
KEYCOLUMNFalse1adBoolean
ISAUTOINCREMENTFalse1adBoolean
RELATIONCONDITIONSNull1adVarBinary
CALCULATIONINFONull1adVarBinary
OPTIMIZEFalse1adBoolean
Properties
Status0Long
Type202Long
UnderlyingValueWitherspoonString
ValueWitherspoonString
ActualSize28Long
Attributes106Long
DataFormatNothingNothing
DefinedSize255Long
Nameuser_EMailString
NumericScale255Byte
OriginalValuemike@azguys.coString
Precision255Byte
{Count = 9}
NameValueAttributesType
BASECOLUMNNAMEuser_EMail1adVarWChar
BASETABLENAMEusers1adVarWChar
BASECATALOGNAMENull1adVarWChar
BASESCHEMANAMENull1adVarWChar
KEYCOLUMNFalse1adBoolean
ISAUTOINCREMENTFalse1adBoolean
RELATIONCONDITIONSNull1adVarBinary
CALCULATIONINFONull1adVarBinary
OPTIMIZEFalse1adBoolean
Properties
Status0Long
Type202Long
UnderlyingValuemike@azguys.coString
Valuemike@azguys.coString
Fields
Filter0Long
IndexString
LockType4Long
MarshalOptions0Long
MaxRecords0Long
PageCount1Long
PageSize10Long
{Count = 103}
NameValueAttributesType
IAccessorTrue513adBoolean
IChapteredRowsetTrue1537adBoolean
IColumnsInfoTrue513adBoolean
IColumnsRowsetTrue513adBoolean
IConnectionPointContainerTrue513adBoolean
IConvertTypeTrue513adBoolean
ILockBytesFalse513adBoolean
IRowsetTrue513adBoolean
IDBAsynchStatusFalse1537adBoolean
IParentRowsetTrue513adBoolean
IRowsetChangeTrue1537adBoolean
IRowsetExactScrollTrue513adBoolean
IRowsetFindTrue1537adBoolean
IRowsetIdentityTrue513adBoolean
IRowsetInfoTrue513adBoolean
IRowsetLocateTrue513adBoolean
IRowsetRefreshTrue1537adBoolean
IRowsetResynchFalse513adBoolean
IRowsetScrollTrue513adBoolean
IRowsetUpdateTrue1537adBoolean
IRowsetViewTrue1537adBoolean
IRowsetIndexFalse513adBoolean
ISequentialStreamTrue513adBoolean
IStorageFalse513adBoolean
IStreamFalse513adBoolean
ISupportErrorInfoTrue513adBoolean
Preserve on AbortTrue513adBoolean
Access Order2513adInteger
Append-Only RowsetFalse1537adBoolean
Blocking Storage ObjectsFalse1537adBoolean
Use BookmarksTrue513adBoolean
Skip Deleted BookmarksTrue513adBoolean
Bookmark Type1513adInteger
Cache Deferred ColumnsFalse513adBoolean
Fetch BackwardsTrue513adBoolean
Hold RowsTrue1537adBoolean
Scroll BackwardsTrue513adBoolean
Change Inserted RowsTrue513adBoolean
Column PrivilegesFalse513adBoolean
Command Time Out301537adInteger
Preserve on CommitTrue513adBoolean
Defer ColumnFalse513adBoolean
Delay Storage Object UpdatesTrue513adBoolean
Private11537adBSTR
Filter Operations27513adInteger
Find Operations27513adInteger
Hidden Columns0513adInteger
Immobile RowsTrue513adBoolean
Literal BookmarksTrue513adBoolean
Literal Row IdentityTrue513adBoolean
Maximum Open Rows0513adInteger
Maximum Pending Rows0513adInteger
Maximum Rows01537adInteger
Column WritableFalse513adBoolean
Memory Usage0513adInteger
Notification Granularity1513adInteger
Notification Phases31513adInteger
Column Set Notification3513adInteger
Row Delete Notification3513adInteger
Row First Change Notification3513adInteger
Row Insert Notification3513adInteger
Row Resynchronization Notification3513adInteger
Rowset Release Notification3513adInteger
Rowset Fetch Position Change Notification3513adInteger
Row Undo Change Notification3513adInteger
Row Undo Delete Notification3513adInteger
Row Undo Insert Notification3513adInteger
Row Update Notification3513adInteger
Bookmarks OrderedTrue513adBoolean
Others' Inserts VisibleFalse513adBoolean
Others' Changes VisibleFalse513adBoolean
Own Inserts VisibleTrue513adBoolean
Own Changes VisibleTrue513adBoolean
Quick RestartTrue513adBoolean
Reentrant EventsTrue513adBoolean
Remove Deleted RowsTrue513adBoolean
Report Multiple ChangesFalse513adBoolean
Return Pending InsertsTrue513adBoolean
Row PrivilegesFalse513adBoolean
Asynchronous Rowset Processing161537adInteger
Row Threading Model1513adInteger
Server CursorFalse513adBoolean
Strong Row IdentityTrue513adBoolean
Objects TransactedFalse513adBoolean
Unique RowsTrue513adBoolean
Updatability71537adInteger
Batch Size151537adInteger
Update Criteria21537adInteger
Background Fetch Size151537adInteger
Initial Fetch Size501537adInteger
Background thread Priority31537adInteger
Cache Child RowsTrue1537adBoolean
Maintain Change StatusFalse1537adBoolean
Auto Recalc11537adInteger
Unique Table1537adBSTR
Unique Schema1537adBSTR
Unique Catalog1537adBSTR
Resync Command1537adBSTR
Cursor Engine Version100513adInteger
Reshape NameDSRowset1513adBSTR
Update Resync11537adInteger
Release Shape On DisconnectFalse1537adBoolean
BookmarkableTrue513adBoolean
Properties
RecordCount4Long
SortString
SourceSELECT user_ID, user_LName, user_EMail FROM users;String
State1Long
Status0Long
StayInSyncTrueBoolean