Latest Contributions by deleted-user-GQE1M5NT-OOh

Using the ISchemaLock.UserName property, I am getting the "username", but it's coming back as my servername, as in HOU-AGSPRD01.10768. What is the "10768"? Is that the PID of the process that has the lock on the featureclass at the time? ... View more

I am attempting to use SQL to create features in my featureclasses. I have been very successful with 2D points and polylines and can insert features at will via SQL. However, with 3D points and lines, its proving more challenging. Something like so: use GeometryTesting go insert into ZMPOINTS (OBJECTID, SHAPE) values (1, geometry::STGeomFromText   ('POINT(1703722.03 12853873.58 1175.94 1176)', 8)) ...isn't liked by SDE. The record goes in: SELECT TOP 1000 [OBJECTID]       ,[SHAPE].AsTextZM() as c   FROM [GeometryTesting].[dbo].[ZMPOINTS] OBJECTID c 1         POINT (1703722.03 12853873.58 1175.94 1176) And as far as the SQL Server geometry type and the base table is concerned, there are Z and M values for the point. When I add the FC to ArcMap, the features do not show up, BUT I can select the feature and zoom to it. Unselect it, and nothing is there. Also, I can export the FC to a shp and the features then show up just fine. It's almost like the FC is just busted. Like I said, with 2D points and polylines, this all works great, there is something going on with the 3D and m-value FCs though. Has anyone had any experience working with ZM points/polylines with the SQL Server geometry datatype and ArcGIS/SDE? Any thoughts greatly appreciated. Thanks. chad ... View more