Hoi Peter,

Long time no see. You still live !!

I don't have a direct answer for you. Hopefully I'll have one later.

Bye..

Walter,


>Tough problem (after 8 hours research one may say so :) with regard to
>SQLrollback.
>
>I add a record in a remote view (optimistic tablebuffering) and do
>some editing.
>Then I start a manual transaction (SQL-Server).
>I check getfldstate(-1). It's all 333443444344etcetera. So it indeed
>is recognized as a new record and some fields are updated.
>Then I do a tableupdate(). It succeeds.
>Then I do SQLrollback.
>Then I (again) start a manual transaction.
>I check getfldstate(-1). It's all 1111111111etcetera. So it's NO
>LONGER recognized as a NEW record!
>Then I do a tableupdate(). It SEEMS to succeed.
>Then I do SQLcommit().
>However, the record is not really committed in SQL-Server.
>
>I've also tried to set the field states to 3/4 with the setfldstate()
>function, the 2nd time. However, the function will allow me to set
>them to 2, but 3 and 4 are refused.
>
>Who knows what's happening here???
>
>Groeten,
>Peter