Page 1 of 1
VFP .NULL.
Posted: Wed Apr 27, 2005 1:56 pm
by Emetsky_(Guest)
Hello folks!____I^m storing .NULL. values in my VFP data tables (dbf) and I want to format the .NULL. to show NA on the report.____IIF(field=.null.,^NA^,field)____Is this possible in R&R v8.1?____TIA,__Emetsky
=> RE: VFP .NULL.
Posted: Wed Apr 27, 2005 3:02 pm
by kfleming
R&R is not able to distinguish an explicit foxpro null from a blank field. For logical nulls, we read the field as .F.__You can use the isblank function to test for a blank and return a value. Because you want to print ^NA^ for an empty field you would need to do a data type conversion for numeric or date fields. __So the expressions would be:____IIF(islblank(field),^NA^,field) __IIF(islblank(field),^NA^,str(field)) __IIF(islblank(field),^NA^,DTOC(field)) ____Kathleen__R&R Support