Hi,

I have created 17 DBF's from a VFP remote connection. The DBF's are the same format as the SQL's. I am getting NULL VALUES in some fields. I do not want any NULL VALUES in any DBF fields in the created DBF's.

During the DBF creation process (REMOTE CONNECTION), I would like to specify "convert NULL VALUES to their default field type value; ie. BLANKS in Character Fields, 0 in Numeric fields etc." (Or simply NO NULL VALUES IN OUTPUT FIELDS).

I can't seem to find any VFP Syntax that will place blanks/0's in the fields will NULL VALUES when the DBF's are created.

I used in my program during the remote connection the following:

SET NULL OFF
SET NULLDISPLAY TO ""

I still have NULLS in the fields.

Please help me solve this problem with the minimium amount of work.

Thanks
Roland...