>Hi,
>
> I am creating a connection to foxpro tables(.dbf) like this
>CREATE CONNECTION SCRUB CONNSTRING "Provider=MSDASQL.1;Driver={Microsoft Visual FoxPro Driver};SourceDB=" + Destination_path_BT + ";SourceType=DBF "
>
> Then I create view by using the following commands
>gcTable = gaDatabase(nCount,1)
> gcTable = UPPER(ALLTRIM(gcTable))
>
> *!* Creating View from the foxpro table
> SET PATH TO &Destination_path_BT
> Create SQL VIEW rv_tbltemp2;
> connection SCRUB;
> as SELECT * FROM &gcTable
>
> It works great but the problem is when the view is created, it puts the value in date fields (12/30/1899) even when it is blank in the foxpro table. Do you know any way so that it should pass blank if that field's value is blank in Foxpro table.
>
>Thanks
>Bharat

You will need to use NULL instead of blanks when using a remote view.