>Hi Emanuele.
>
>>UpdateType = 2 <<< WHY ? i forced it
>
>This is definitely the cause of the problem. I don't know why it's getting set to 2. Check something: choose Options from the Tools menu, and check the Remote Data page. Under SQL Updates, what is Method set to? If it's set to SQL Delete + SQL Insert, change it to SQL Update, click on Set As Default, then click on OK. See if that makes a difference. Let me know what you find.
>
>Doug
The Option was Sql Update!
I tried to force updatetype = 1 passing it calling DODEFAULT(...) in the beforeupdate event ... no change!
Another thing.
The UpdateType, should change only the mode to have record canghed.
The two statement DELETE and INSERT should work .... but the insert statement captured with profiler show me that only fields changed are inserted, not the all fields of records, so the operation isn't corretct!
Ex:
"Table" with one record
---------
Fields Values
----------------------
id 1
Code Goofy
Description Cartin
i change description in "CARTOON"
the two statement sent to the sever are:
DELETE Table WHERE id = 1
INSERT Table (Description) values ('CARTOON')
i think that the right two commands should be (if updatetype=2):
DELETE Table WHERE id = 1
INSERT Table (id, code, Description) values (1, 'Goofy', 'CARTOON')
Where i'm in wrong ? Where VFP is is Wrong ?
Thanx in advance !! ... and sorry for my orrible english.
bye, Emanuele!
In the beginning the Universe was created.
This has made a lot of people very angry and been widely regarded as a bad move.