Identity properties are not updateable ?!

[bebeto]

Hi,

I have fdo schema where I have primary key (PK) editable (readonly=false). I'm able to INSERT any value when it is not NULL and unique (conditions for PK) . But I'm pretty surprised why I'm not able to UPDATE such property. I'm getting error:

"Identity properties are not updateable"

Any reason for this ? Is it a bug in FDO ?

[Orest Halustchak]

Hi,

Which provider are you using? Some fdo providers don't allow the update of an identity property once it is set. You would have to delete the object and insert a new one with the new identity. Mostly this is an issue for providers that support things like long transaction tracking of changes to objects, history, etc. These rely on the identity of an object not changing.

Thanks,
Orest.

-----Original Message-----
From: [hidden email] [mailto:[hidden email]] On Behalf Of bebeto
Sent: Thursday, October 08, 2009 5:26 AM
To: [hidden email]
Subject: [fdo-users] Identity properties are not updateable ?!


Hi,

I have fdo schema where I have primary key (PK) editable (readonly=false).
I'm able to INSERT any value when it is not NULL and unique (conditions for
PK) . But I'm pretty surprised why I'm not able to UPDATE such property. I'm
getting error:

"Identity properties are not updateable"

Any reason for this ? Is it a bug in FDO ?


--
View this message in context: http://n2.nabble.com/Identity-properties-are-not-updateable-tp3786913p3786913.html
Sent from the FDO Users mailing list archive at Nabble.com.
_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users
_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users

[bebeto]

I'm using OSGeo.SQLServerSpatial.3.4

I think when underlying datasource - sql server - support this, it should work also with provider - without any limitations.

Orest Halustchak wrote:

Hi,

Which provider are you using? Some fdo providers don't allow the update of an identity property once it is set. You would have to delete the object and insert a new one with the new identity. Mostly this is an issue for providers that support things like long transaction tracking of changes to objects, history, etc. These rely on the identity of an object not changing.

Thanks,
Orest.

-----Original Message-----
From: [e-mail] [mailto:[e-mail]] On Behalf Of bebeto
Sent: Thursday, October 08, 2009 5:26 AM
To: [e-mail]
Subject: [fdo-users] Identity properties are not updateable ?!


Hi,

I have fdo schema where I have primary key (PK) editable (readonly=false).
I'm able to INSERT any value when it is not NULL and unique (conditions for
PK) . But I'm pretty surprised why I'm not able to UPDATE such property. I'm
getting error:

"Identity properties are not updateable"

Any reason for this ? Is it a bug in FDO ?


--
View this message in context: http://n2.nabble.com/Identity-properties-are-not-updateable-tp3786913p3786913.html
Sent from the FDO Users mailing list archive at Nabble.com.
_______________________________________________
fdo-users mailing list
[e-mail]
http://lists.osgeo.org/mailman/listinfo/fdo-users
_______________________________________________
fdo-users mailing list
[e-mail]
http://lists.osgeo.org/mailman/listinfo/fdo-users