Skip to main content
  • EN

I have always tried to use the databaseupdater but have always had issues with it.

Why if i have a unique column with GFID values and i want to match that it gives the error.

Microsoft SQL Server Non-Spatial Writer: Failed to write a feature of type `dbo.COGO_23' to the database. Provider error `(-2147217900) The data types text and text are incompatible in the equal to operator.'. SQL Command `UPDATE [dbo].[COGO_23] SET [gfid]=?, BLAHBLAHBLAHWHERE [gfid]=?'

this is a flat mssql table with no geometry.

 

Hi @Brad Nesom​ 

If the column you're doing the matching on (GFID) is the data type 'text', then the table update will fail. You need to use char or varchar in this case instead.

 

If you're unable to change your column data type to char/varchar you could use a WHERE Clause in your DatabaseUpdater to cast your GFID to varchar instead.

See the screenshot below for an example:

image 

Hope this helps!

Dan

Reply


Community Stats

30,162
Posts
114,480
Replies
37,807
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.