Issue #1
When I'm Adding a new record with "cachedupdates" default field values is coming to null. But When I'm not using "cachedupdates" default values come correct.
Sample Application Attached.

Issue #2
When I use gotobookmark with cachedupdates table focus to another record.
Forexample;
Step by step, I’m getting bookmark after that I‘m doing begincachedupdates and I’m editing some fields, after this and I do cancelcachepupdates and gotobookmark but table focus to another record which is not same as getbookmark record.

Is Anyone have any idea for solve this troubles?

Ömer UZUNER wrote:

I attach a video which shows the issue.

Please do not post attachments in this newsgroup/forum.  Use the Binaries newsgroup/forum instead.

As for the issues, please see my email reply, which is copied here for others to see:

<< When I'm Adding a new record with "cachedupdates" default field values is
coming to null. But When I'm not using "cachedupdates" default values come
correct. >>

Default expressions for columns are not evaluated/populated when using
cached updates.  Default expressions can involve function/procedure calls
and other types of complex evaluations that are not possible on the client
with a remote session, since the client does not have direct access to the
database catalog, the session state, etc.

<< This problem become when I make AlterTable with "ElevateDB Manager" >>

You're specifying the IP address as a numeric constant, not a string
constant.  It should be specified as:

DEFAULT '127.0.0.1'

<< When I use gotobookmark with cachedupdates table focus to another record.

Step by step, I'm getting bookmark after that I'm doing begincachedupdates
and I'm editing some fields, after this and I do cancelcachepupdates and
gotobookmark but table focus to another record which is not same as
getbookmark record. >>

You can't use bookmark values from when cached updates are active to
re-position to rows *after* the cached updates are no longer in effect.  The
rows have different internal row IDs, and that causes the GotoBookmark to
move to the wrong row.

-------------------

The cached updates use the replication functionality in ElevateDB, so they
are functionally equivalent in terms of how they work.  So, you can assume
the same type of behaviors that you would if you were replicating updates
from a machine on the other side of the planet.
------------

Tim Young
Elevate Software
www.elevatesoft.com