>>I have just created a simple table and accessed it via ODBC and a remote view - it worked fine! - How have you set the remote view up and how are you adding records? (Insert, Browse etc)
>>
>>There must be a solution!!
>>
>>Ian
>
>I haven't been following the whole thread but here's my two cents:
>
>If the update is being done through the view and the problem column is not in the view than the VFP ODBC driver has to decide what value to put into the column. It seems to have it's mind made up that it wants to insert a NULL. But the column is not defined with to accept NULLs. An easy solution would be to define a DEFAULT on the problem column.
>
>-Mike
Ah, perhaps, I made a blunder missing that initial question mentioned that the error was during tableupdate(). Now it looks clear.
Edward Pikman
Independent Consultant