I am using ARCGis 10.1 platform .From One of the database sde Connection i have created view using new -
> view option The view get created fine and its visible in ARCCatalog preview tab in geometry tab as table view option.
The problem is during arc Desktop 10.1 when i add the view to the geometry is visible but the i press open attribute table then it shows blank fields.
The Problem when I have checked the ObjectId Data type it is showing long instead of Object Id. So the problem is with OBJECTID . How to deal with this issue?Thank you in advance.
Below is the error i get when i press open attribute table.
[ATTACH=CONFIG]17443[/ATTACH]
> view option The view get created fine and its visible in ARCCatalog preview tab in geometry tab as table view option.
The problem is during arc Desktop 10.1 when i add the view to the geometry is visible but the i press open attribute table then it shows blank fields.
The Problem when I have checked the ObjectId Data type it is showing long instead of Object Id. So the problem is with OBJECTID . How to deal with this issue?Thank you in advance.
SELECT SPE.[OBJECTID] ,SPE.[BaseId], SPE.[PlayId] , B.[BasinName], SP.[ShaleName], AGS.[AgeS [Ref] , SPE.[Shape] , SPE.[Shape_STArea__], SPE.[Shape_STLength__] FROM [dbo].[Play] SPE inner join [dbo].[Base] B on SPE.[BaseId]=B.[OBJECTID] inner join [dbo].[shale] SP on SPE.[Shale]=SP.[OBJECTID] inner join [dbo].[Age] AGS on SPE.[AgeId]=AGS.[OBJECTID]
Below is the error i get when i press open attribute table.
[ATTACH=CONFIG]17443[/ATTACH]
information to the previous post (which actually had more information than this one). Among
the details available would be:
+ The database software in use
+ The layouts of the tables involved (as reported by 'sdetable -o describe')
+ The layout of the view (as reported by 'sdetable -o describe')
+ The geometry storage type for the base layer (SDEBINARY, ST_GEOMETRY or native type)
+ The exact command you used to create the view or the exact command you used to
register the view with ArcSDE
You should also include any errors as text in body of the post (images are not free text searchable),
so that others can find your query (and solution).
Please note that Mr. Richards instructions are incorrect with regard to the source of the registered
rowid column (OBJECTID): You do *not* always want to take the OBJECTID from the geometry
table, you want to take it from the table which will generate a unique value with each returned row
(in a many-to-one join, from the "many" side). The OBJECTID column MUST always be NOT NULL,
even with an OUTER JOIN.
- V