>I am attempting to append records from a remote view where some of the records in the source table have Null values.
>
>Where all the values in a column are not null they import fine. But if some of the values in a column are Null then I get an error message e.g. 'Field2 does not accept Null values' .
>
>I have tried to look at the table designer and I can't see how to modify the structure to make the fields accept null values. All of the fields in the receiving table are character fields 30 characters wide.
>
>Mike Smith
If by any reason you do not want to change your table structure to accept NULLs, you could convert the data from the remote view into intermediate cursor and replace your NULL values with empty values on the fly using ISNULL() function then append your data from that cursor.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison