In order for this site to work correctly we need to store a small file (called a cookie) on your computer. Most every site in the world does this, however since the 25th of May 2011, by law we have to get your permission first. Please abandon the forum if you disagree.

Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.

FRX : Null Value in DataSet

FastReport for Xailer & [x]Harbour (English/Spanish)
Milan Mehta
Posts: 113
Joined: Sun Dec 27, 2009 9:54 am

FRX : Null Value in DataSet

Postby Milan Mehta » Sat May 28, 2016 7:26 am

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.
User avatar
bingen
Posts: 440
Joined: Mon Jul 07, 2014 8:17 pm
Location: Bilbao
Contact:

Re: FRX : Null Value in DataSet

Postby bingen » Thu Jun 02, 2016 4:06 pm

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.)
BiSoft Desarrollo de software profesional
http://www.bisoft.es
Milan Mehta
Posts: 113
Joined: Sun Dec 27, 2009 9:54 am

Re: FRX : Null Value in DataSet

Postby Milan Mehta » Sat Jun 04, 2016 3:50 pm

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
User avatar
bingen
Posts: 440
Joined: Mon Jul 07, 2014 8:17 pm
Location: Bilbao
Contact:

Re: FRX : Null Value in DataSet

Postby bingen » Thu Jul 07, 2016 1:06 pm

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

:oEngineOptions:SetConvertNulls(.T.)

END WITH
BiSoft Desarrollo de software profesional
http://www.bisoft.es

Return to “FastReport”