???Version view??? for tables\layers,

9597
32
Jump to solution
04-08-2014 02:49 AM
by Anonymous User
Not applicable
Original User: Jamal432@gmail.com

???Version view??? for tables\layers,

I couldn???t figure out how particular tables\layers are given the ???Version view??? property while others don???t have it

For example, in the screenshot below, the ???project??? table has this property

[ATTACH=CONFIG]32904[/ATTACH], [ATTACH=CONFIG]32905[/ATTACH]

In return, the ???companies??? table doesn???t have it.

[ATTACH=CONFIG]32906[/ATTACH], [ATTACH=CONFIG]32907[/ATTACH]


Form where this property (versions view) is set?


Thank you

Best

Jamal
0 Kudos
32 Replies
ColinZwicker
Esri Contributor
Jamal,

Upon further review I think my original idea (DBO user related) was incorrect.

For the dataset that is failing, does it contain any user defined fields?

Can you try adding a field to the table before you register it as versioned?
E.g., the field set would contain ObjectID and myTextField

The view is correctly created for me when using a DBO mapped user if the table has more fields that just the default ObjectID field (a questionably useful table schema).

Thanks,
Colin
0 Kudos
by Anonymous User
Not applicable
Original User: asrujit

Colin,

Yes, that seems to have done the trick!
0 Kudos
JamalNUMAN
Legendary Contributor
Jamal,

Upon further review I think my original idea (DBO user related) was incorrect.

For the dataset that is failing, does it contain any user defined fields?

Can you try adding a field to the table before you register it as versioned?
E.g., the field set would contain ObjectID and myTextField

The view is correctly created for me when using a DBO mapped user if the table has more fields that just the default ObjectID field (a questionably useful table schema).

Thanks,
Colin


Many thanks guys for the help.

Colin�?�it worked as a charm.

Adding fields (other than the defaults) to tables before applying the �??register as version�?� solves the issue.

Interestingly, if a table is �??registered as version�?� before adding fields then the version view is not created. In this case, unregistering this table and re-registering it will create the version view provided that other fields are created before applying the registration.

Very much appreciated

Jamal
----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine
0 Kudos