dbeval error

[Silvio.Falconi]

to calculate how naly record I have into a archive I usa dbeval function

But when the dbeval function found a record empty ( with a field empty ) the application crash

sample :

MV->( DBEVAL( { || aCanE[ Month( FIELD->FECHA ) ][ 2 ]+= IIF( FIELD->TIPO="E", MV->TOTAL,0) } ) )

how I can resolve it ?

[Patrizio]

Silvio, from xHarbour guide:

Code: Select all

DbEval( <bBlock>,[<bForCondition>],[<bWhileCondition>],[<nNextRecords>],[<nRecord>], [<lRest>]) --> NIL

so you can try this:

Code: Select all

MV->( DBEVAL( { || aCanE[ Month( FIELD->FECHA ) ][ 2 ]+= IIF( FIELD->TIPO="E", MV->TOTAL,0) }, {||Month(FIELD->FECHA)>0} ) )

or you can try this:

Code: Select all

MV->( DBEVAL( { || IF(Month( FIELD->FECHA ) >0, aCanE[ Month( FIELD->FECHA ) ][ 2 ]+= IIF( FIELD->TIPO="E", MV->TOTAL,0), ) }) )

[Silvio.Falconi]

thanks run ok