Help needed with FileNet IDMListView and Recordsets

[Steve]

I'm working with a FileNet IDMListView control in C# and am having a
dickens of a time getting it to populate with the data in the
recordset.

FileNet convention says that you set the "SupportsObjSet" property for
the recordset to True and then pass the "ObjSet" column value to the
AddItems method.

However, while this may work in VB it doesn't in C#, at least the way
I've got it put together.

Here's the snippet for the recordset read:

recordSet.let_ActiveConnection(sConnect);

recordSet.Properties["SupportsObjSet"].Value = true;
recordSet.Properties["SearchFolderName"].Value = "";
recordSet.MaxRecords = 3000;

recordSet.Open(srchString, sConnect,
ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockReadOnly,
-1);

It returns one record and does not have the ObjSet column as expected.

Here's the snippet for the list view AddItems call:

idmListView.AddItems(recordSet.Fields["ObjSet"].Value, 1);

I already know this won't work because the ObjSet column isn't in the
returned results.

Is there something that I'm not setting up correctly or that I'm
missing from my properties or search? If there, please let me know.

Thanks.

Steve

 

[Steve]

I found the solution to this. In case anybody is curious, when working
with FileNet and ADODB recordsets in C#, you need to use
ADODB.LockTypeEnum.adLockUnspecified in any open statements. If you use
anything else FileNet will not necessarily work as intended.

Steve