error message
Invalid subscript reference
if inlist(laFields[m.lnI,2],'N','I','B')
>Try
>
>if inlist(laFields[m.lnI,2],'N','I','B')
> replace ...
>endif
>
>>hi,
>>
>>i'm sorry ,
>>i have another type need to convert to null or space ...
>>type double and integer.
>>
>>thanks
>>
>>>If this is the case, you should make them NULL, not blank, AFAIK.
>>>
>>>Change the command to
>>>replace (laFields[lnI,1]) with NULL for empty(&laFields[lnI,1])
>>>
>>>Check
Re: Blank dates in Excel Thread #
1140736 Message #
1142863>>>
>>>>yes,
>>>>i convert this table to excel sheet, i found many records have zeroze...
>>>>
>>>>>You cannot fill space to numeric field. Maybe you want to show blank on screen when table field value is zero?
>>>>>