>I believe you when you say you can insert into a remote view from memvar -- I just can't get it to work! I keep getting the following error message:
>
>Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'id', table 'fers.dbo.applican'; column does not allow nulls. INSERT fails.
>
>My code looks like this:
>m.id = THISFORM.appidfield1.VALUE
>m.disaster = gc_dnum
>INSERT INTO vapplican FROM MEMVAR
>=TABLEUPDATE(.F.,.F.)
>
>The id and disaster fields make up the primary key. They both have values but I still get the error above.
>
>Any ideas?
>
>Thanks,
>Doug

Are you able to do successful updates from this view after inserting or appending a record with any other means?

If so, compare the contents of the view after appending with the other method with the contents of the view after INSERT FROM MEMVAR. The backend doesn't know how the contents of the view got into the view, it only knows about what you are trying to insert. So something has to be different in the view after your INSERT FROM MEMVAR. Also check that the "id" field is checked as updateable in the view definition.