> Because you haven't inserted a record in the dataset, but in a
> cache buffer that is isolated from the dataset's transaction!

Oops!

> Your problem here is that your code separates the cache from the
> transaction in which the task occurs. The sequence has to be
>
> Transaction.StartTransaction
> Query.Open (or Refresh)
> ...
> Query.Insert
> (insert rows into the cache)
> ... (mess around inside the cache if desired)
> Query.ApplyUpdates (posts all new rows)
> ...
> Transaction.Commit
> Query.CommitUpdates

I just tried exactly that and still nothing gets to the DB. After the
Insert, UpdatesPending still returns FALSE.

Is there other possible cause?

Thanks as usual,

Eyal.