Backend is VFP :) Purpose to support mobile staff. Maybe I should drop the idea of remoteview and use local. I was insisting on using remoteview because I try to make this a generic routine for mobile support. I didn't use the null in the same manner thinking base table might not be set as accepting nulls. For now I'll stop to bent more and code separately for each :)
Cetin
>Cetin,
>
>It seems to me that your problem is really related to the remote view, not to the fact that you've taken it off line. What is the back end for the view (VFP, SQL Server, Access)? I've found that in many cases back ends can't accept empty fields for certain types. What I do is very similar to what you're doing except that I put a null in the field if it's empty. Like this:
>
>for ix = 1 to fcount()
> if empty(eval(field(ix))) and type(field(ix)) $ "MDT"
> REPLACE (field(ix)) WITH NULL
> endif
>endfor