• In-place editing of items.
  No programming needed to edit ALL columns.
• Highlight Entire Rows (CBrowseLC)
  No programming necessary to get your list control to highlight ENTIRE rows.
• Sortable Columns (CBrowseLC)
  No programming needed to sort on ALL columns.
• Browse tables of any size (CBrowseVLC)
  No need to worry about complex programming solutions, arrays, memory limitations etc.

• Programming Language
  Visual C++ version 4.2 at minimum. ActiveX controls can be used with Visual Basic 32 bit versions.
• Operating System
  Any 32 bit Windows or NT operating system version.
• Programming Expertise Required
  Novice to professional.

//UDF is a CArray to be filled with DEFFIELDS structures

#define UDF CArray<DEFFIELDS, DEFFIELDS&>
//DEFFIELDS struct to insert into a CArray acting as a paramater for user-defined
//fields.

struct DEFFIELDS
{
CString strFldLabel; //user defined field label
BOOL bCalcField; //Supply calculated field function pointer
union
{
LPCSTR lpszFldName; //Actual field name. Used if bCalcField == FALSE
struct //If bCalcField == TRUE, fill in the DefFunction struct
{
void (*lProc)( LPSTR lpszValue/*Pointer to string to receive calc. field value*/,
CRecordset* pSet = NULL/*Pointer to ODBC recordset object */ ); //function pointer
SDWORD nType; //SQLType, eg. SQL_NUMERIC
int nLen; //Field width
int nDec; //Field decimals, if any

}DefFunction;

}FldInfo;

};

Each element of the UDF array element will contain a structure of the above type for each field, user defined or otherwise. The structure will contain either the actual field name or a user defined field label associated with a pointer to a function which will calculate a value. If a user defined field name is used, set the boolean flag, bCalcField to TRUE, otherwise the list control will display the field contents associated with the actual field name indicated in the structure. See samples.

void CalcPayoff( char* pStr, CRecordset* pSet ); // See df.FldInfo.DefFunction.lProc below

BOOL CDialogBrowse::OnInitDialog()
{
   CDialog::OnInitDialog();
   CBitmap pBitmap; //Needed for the imagelist
   UDF pFlds;
   DEFFIELDS df; //For the UDF parameter
   df.strFldLabel = "Date Updated";
      df.bCalcField = FALSE;
   df.FldInfo.lpszFldName = "UPDATED";
   pFlds.Add( df );

   df.strFldLabel = "Type";
   df.bCalcField = FALSE;
      df.FldInfo.lpszFldName = "TYPE";
   pFlds.Add( df );

   df.strFldLabel = "Payoff";
   df.bCalcField = TRUE;
   df.FldInfo.DefFunction.lProc = CalcPayoff; //See CalcPayoff function defined below
   df.FldInfo.DefFunction.nType = SQL_DOUBLE;
   df.FldInfo.DefFunction.nLen = 10;
   df.FldInfo.DefFunction.nDec = 0;
   pFlds.Add( df );

CBrowseLC* m_pBrowse = new CBrowseLC( m_pSet, this, CRect( 5, 5, 186, 70 ), &pFlds, pImageList, FALSE );
// Replace CBrowseLC with CbrowseVLC for large tables

m_pBrowseShowWindow( SW_SHOW );

// Actually m_pBrowse should be declared as a class member and
// deleted in the destructor
}
/* The function defined below is used to display a calculated field. For this field, set df.bCalcField = TRUE. Set a pointer to this function. eg. df.FldInfo.DefFunction.lProc = CalcPayoff as
shown above. */

void CalcPayoff( char* pszFld, CRecordset* pRecSet )
{
   CPROJWIZAnalysisSet* pSet = (CPROJWIZAnalysisSet*)pRecSet;
   char szHold[10];
   double dCalc =
   ( m_pSet->m_SP1 * pSet->m_RETURN1 ) +
   ( m_pSet->m_SP2 * pSet->m_RETURN2 ) +
   ( m_pSet->m_SP3 * pSet->m_RETURN3 ) +
   ( m_pSet->m_SP4 * pSet->m_RETURN4 ) +
   ( m_pSet->m_SP5 * pSet->m_RETURN5 ) +
   ( m_pSet->m_SP6 * pSet->m_RETURN6 ) +
   ( m_pSet->m_SP7 * pSet->m_RETURN7 );

   ltoa( dCalc, szHold, 10 );
   lstrcpy( pszFld, szHold );
}