AnsweredAssumed Answered

Error Creating SQL Server Spatial View

Question asked by rayjaw on Jul 9, 2014
Latest reply on Jul 9, 2014 by Christian_Wells-esristaff

Hi,

I seem to be having difficulty creating a spatial view in SQL Server.  The format I use is basically identical to the example in the Help, but I am getting this error:

 

Msg 102, Level 15, State 1, Procedure spvw_TEST, Line 2

 

Incorrect syntax near ','.

 

Does anyone know why it would be complaining about a comma (it is the first comma after "vw.FieldID" below)?  Here is an abbreviated version of the code I am trying to run:

 

CREATE VIEW spvw_TEST

AS SELECT (vw.FieldID,vw.Field1,vw.Field2,fc.Shape)

FROM vw_AllMain vw JOIN FeatsDistrib fc

ON vw.txtFeatID = fc.txtFeatID

 

Thanks,

Justin

Outcomes