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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement