Select to view content in your preferred language

Records Shown in ArcCatalog/ArcMap but not in SQL Server 2005

864
1
01-18-2011 04:06 PM
AryaWardhana
Emerging Contributor
Dear All,

First
I`m Using SDE 9.3 and SQL Server 2005.

I have add Records into my existing SDE featrure class using ordinary load from arccatalog, the process is running well without error.
and the added reocords was shown beatifully in arcmap and arccatalog.

But, when i access the SDE feature class table using SQL server and list the records, the records what i just add, wasnt shown at all. please tell me what a hell happen to my feature class.

i have browse to all the webiste and couple said that i have problem with my versioning, but as far as i know, didnt set my versioning at all, (i not sure 100% i have set or not my versioning, because i`m new using this sde).

Please help me.
0 Kudos
1 Reply
CherylCleghorn
Esri Contributor
Arya

I suspect that the feature class (FC) is registered as versioned. So let's check to see if your feature class is registered as versioned:

  • In ArcCatalog, right click on the  FC and select properties

    The bottom of the general tab - versioning section - will say if the feature class is registered as versioned
If the FC is registered as versioned then the edits are managed in user versioning (delta) tables which the native database does not have direct access to when querying the business (or base) table with SQL.

The following link provides information on registering data as versioned:
Registering data as versioned

The next link defines the delta (adds and deletes) and base tables:
Essential versioning vocabulary

Hope this helps

Regards
Cheryl
0 Kudos