Page 1 of 1

FRX : Null Value in DataSet

Posted: Sat May 28, 2016 7:26 am
by Milan Mehta
When using FRX, if there is any Null value in the DataSet passed, it results in hanging of the application.

What is the way out ?

TIA
Milan.

Re: FRX : Null Value in DataSet

Posted: Thu Jun 02, 2016 4:06 pm
by bingen
There is a method inside FR for this purpouse

////////////////////////////////////////////////////////////////////////
// SetConvertNulls() - Converts the "Null" value of the DB field into
// "0", "False," or empty string, depending on the
// field type. Default - True
////////////////////////////////////////////////////////////////////////

METHOD SetConvertNulls(lConvert) class frEngineOptions
Call_Proc_I(::_SetConvertNulls, IF(lConvert <> NIL, IF(lConvert, 1, 0) , 1))
RETURN self

Only activate it SetConvertNulls(.T.)

Re: FRX : Null Value in DataSet

Posted: Sat Jun 04, 2016 3:50 pm
by Milan Mehta
My following code is giving me error : "No Exported Variable lConvertNulls"

WITH OBJECT oReport := TFastReport():New(self)

:oEngineOptions:lConvertNulls := .T.

END WITH

What am I doing wrong ?

TIA
Milan

Re: FRX : Null Value in DataSet

Posted: Thu Jul 07, 2016 1:06 pm
by bingen
WITH OBJECT oReport := TFastReport():New(self)

:oEngineOptions:SetConvertNulls(.T.)

END WITH