Hi,

I'm using Oracle's trigger and sequence way of generating Auto Increment field values with Adapter Template. (LLBLGEN 2.0)

But when I save and refetch my entity like this :

adapter.SaveEntity(MyEntity, true)

I have this error message :

The entity is out of sync with its data in the database. Refetch this entity before using this in-memory instance.

I try to use LLBLGEN documentation to fix the problem with :

<add key="OracleTriggerSequences" value="true" />

but the problem is'nt solve yet

Thx for help

Edit : I want to add that the SaveEntity() method works fine because the database is populated after the save.

Hello

Edit : I want to add that the SaveEntity() method works fine because the database is populated after the save.

Do the problem still exist?

You have to set a sequence on the PK field in the designer, even though you use triggers!

sparmar2000 wrote:

Do the problem still exist?

Yes

Otis wrote:

You have to set a sequence on the PK field in the designer, even though you use triggers!

I try to do that, but the check box is disable in the designer Do you know why is it disable ?

Hi Mephyston

Is the field a numeric field?

sparmar2000 wrote:

Hi Mephyston

Is the field a numeric field?

No, this is a string field because we need to have this format :

XXXMMM000000001 XXXMMM000000002 XXXMMM000000003

Hi,

can you have a look at the following thread which is just about the same issue?

http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=7163

Hope it can help