12.05.2003

If anyone knows how in the hell ArcSDE generates OBJECTIDs (or ROW_IDs, if you wish) on SQL Server 2000, hook me up. I created a table through sql server itself with an OBJECTID column and made sure whilst building the table that all the values were unique. Problem is, the column ain't an Autonumber column, since evidently sde doesn't use those. How's sde to understand what the next key value should be?? you've got me... the fucker keeps wanting to choose shit like 22, 23, 24 for the values even though i have 130 records in there already (so OBJECTID ranges from 1..130). You'd think the next value should be 131, but nooo, it chooses 23, of course causing all hell to break loose when you try to do an update on the table.

grr!

there's some stored procs it looks like that do this under sql server 2000, for these iXXX tables, where XXX denotes each table's registrationID. but these procs are buffaloing me a bit... so wtf.

Any SDE gurus out there? :)

No comments: