I find that the best way to do this is to undefine empty variables. That way the proper null value gets inserted. I still have problems with empty date values at times, and have started routinely RELEASEing them from memory before doing my insert. It might just be something wierd about my setup tho.
>>Can you insert into a remote view using memory variables similar to using a local table?
>>
>>INSERT INTO [remote view] FROM MEMVAR
>>
>>Thanks,
>>Doug
>
>Yes.
--Todd Sherman
-Wake Up! Smell the Coffee!