>
> >>Thanks for your reply and sorry for delay in reply, actually the problem
> is if the field is other then character field, what value I should return
> to make it empty.
> >>
> >>Pls Advs
> >>
> >Vinod:
> >
> >You would have to return a value that is of the same type as the field
> type in the generated select statement. If numeric, you could pass back 0
> or -1 (pick some default value). If the select field is logical, you would
> have to return .t. or .f. Again, you would need to test the type of data
> being passed to the function, and I would do this within the function.
> Then return a corresponding result type. You could experiment returning
> ..null. if a value is "empty." You may be able to return .null. for empty
> date, numeric, logical, etc., fields.
> >
> >HTH
>
> The problem is this only, If I return 0 for numeric and .f. for logical,
> the fields which should be left blank are filled with these values.
>
> If I try to return null, its not accepting, as the cursor which select is
> making is not supporting null values.
>
> Pls advs, I want to make those fields empty and not 0 or .f.
Store it as it is, and then
if empty(field_name)
blank field (field_name)
endif
so it will be blank.