Error with GetListEntryWithFields in .NET APIs

[André Delcroix]

Hi list,

I am trying to export data from a server (7.0.01)  running on Oracle 
8.1.7 with the .NET APIs
When I include field ID 15 (Status History) in the list of fields, I get 
the following error:

BMC.ARSystem.ARException: Error (552): Failure during SQL operation to 
the database;ORA-00904: Invalid column name

   @ BMC.ARSystem.Server._UpdateContext(Object[] retVals)
   @ BMC.ARSystem.Server._Eval(Object v)
   @ BMC.ARSystem.Server.GetListEntryWithFields(String formName, String 
qualification, EntryListFieldList fieldIdList, UInt32 firstRetrieve, 
UInt32 maxRetrieve, Int32& numMatches, ArrayList sortInfoList, String 
vuiName, Boolean useLocale)
   @ BMC.ARSystem.Server.GetListEntryWithFields(String formName, String 
qualification, EntryListFieldList fieldIdList, UInt32 firstRetrieve, 
UInt32 maxRetrieve, Int32& numMatches)
   @ BMC.ARSystem.Server.GetListEntryWithFields(String formName, String 
qualification, EntryListFieldList fieldIdList, UInt32 firstRetrieve, 
UInt32 maxRetrieve)

The code I use is very simple (in C#):

     EntryListFieldList Fields;
     EntryFieldValueList Entries= new EntryFieldValueList();
     Fields = new EntryListFieldList();
     Fields.AddField(15);
     Fields.AddField(105);
     Fields.AddField(106);
     Entries= m_ARS.GetListEntryWithFields(groupFormName, "", Fields, 
1, 0);

wherem_ARS is the server object.
If I do not include field with ID 15, everything is OK

Did someone already hit this issue?

Thanks a lot

André

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"