FiveTech Support Forums

FiveWin / Harbour / xBase community
Board indexAll discussionsLogin (GitHub)
Board index FiveWin for Harbour/xHarbour dbeval error
Silvio.Falconi
Posts: 7317
Joined: Thu Oct 18, 2012 07:17 PM
dbeval error
Posted: Tue Jan 29, 2013 09:12 AM

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 ?

Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
Patrizio
Posts: 90
Joined: Wed Nov 07, 2007 08:56 AM
Re: dbeval error
Posted: Tue Jan 29, 2013 10:56 AM
Silvio, from xHarbour guide:

Code (fw): Select all Collapse
DbEval( <bBlock>,[<bForCondition>],[<bWhileCondition>],[<nNextRecords>],[<nRecord>], [<lRest>]) --> NIL


so you can try this:

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


or you can try this:

Code (fw): Select all Collapse
MV->( DBEVAL( { || IF(Month( FIELD->FECHA ) >0, aCanE[ Month( FIELD->FECHA ) ][ 2 ]+= IIF( FIELD->TIPO="E", MV->TOTAL,0), ) }) )
Silvio.Falconi
Posts: 7317
Joined: Thu Oct 18, 2012 07:17 PM
Re: dbeval error
Posted: Tue Jan 29, 2013 08:35 PM

thanks run ok

Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com

Continue the discussion

Static archive · New replies & topics via GitHub Discussions