Hi,

In order to retrieve the value of the column Convention in the instrument list, the code shall be implemented as follow:

• use CSRInstrument::GetPerimeter in order to retrieve the id of the convention
• use a query on the Oracle table BO_PE_PERIMETER_DEF, in order to retrieve the name that corresponds to the id. Of course, a memory cache - using ITQMemoryCache for instance - is welcome if several values should be retrieved.

For instance, the following code retrieves the value:

long _perimeterId = _instrument->GetPerimeter();
if(_perimeterId!=0)
{
 m_accConventions->SetValue(&_perimeterId);
 m_valueAccessor.SetRowId(-1); // reset the result of the precedent search
 m_valueAccessor.SetType(itq::memorycache::IITQAccessor::evtNull); // let the cache input the type
 if(m_cacheConventions->GetItem(m_indexConventions,m_keyConventions,&m_valueAccessor))
 {
  char _name[41]; // 40 car. max in database (bo_pe_perimeter_def)
  int _size = sizeof(_name);
  if(m_valueAccessor.GetStringValue(_name,&_size)) // a right code should increase the value...
   _record.m_convention = _name;
 }
}