Welcome!

This community is for professionals and enthusiasts of the Genio platform.
Share your questions and challenges, and help your partners!

Hide Intro Register

What is needed for Geographical coordinates field type? Is it only usable with Google maps?

Maps Fields

Maria Guedes

on 10/4/19, 1:55 PM • 2,113 views

I am trying to use a geographical coordinates and I am able to generate and compile without errors.

However there are problems reindexing with the logging options.

And I can't save in the form. It appears this on the errlog:

The statement has been terminated.

2019-10-04 16:47:57,048 [QUIDGEST] ERROR - Error changing record in DbArea: A .NET Framework error occurred during execution of user-defined routine or aggregate "geography":

System.FormatException: 24114: The label 38.697332, -9.178849 in the input well-known text (WKT) is not valid. Valid labels are POINT, LINESTRING, POLYGON, MULTIPOINT, MULTILINESTRING, MULTIPOLYGON, or GEOMETRYCOLLECTION.

System.FormatException:

at Microsoft.SqlServer.Types.OpenGisWktReader.ParseTaggedText(OpenGisType type)

at Microsoft.SqlServer.Types.OpenGisWktReader.Read(OpenGisType type, Int32 srid)

at Microsoft.SqlServer.Types.SqlGeography.GeographyFromText(OpenGisType type, SqlChars taggedText, Int32 srid)

at Microsoft.SqlServer.Types.SqlGeography.Parse(SqlString s)

The statement has been terminated.

Flag

Reply
Comment
Share

Rodrigo Serafim

On 10/4/19, 3:41 PM

Unfortunately the geography field is not compatible with the 'Log trigger' functionality. Like the error says, Sql Server does not implement comparability between two geography fields, so logging triggers cannot determine when the field changes to log it.

You need to turn off that field from the 'Log trigger' set.

As for your second question: Yes, geography fields can only be displayed as google maps or as a raw input field (just a string that represents latitude and longitude). Using raw fields however is a bad idea, because you have to follow the correct syntax precisely by writing explicitly POINT(lat, long). Using a google maps field for editing is much safer.

Flag

Thank you for your answer, but can you help in why I can't save the record?

Maria Guedes

on 10/4/19, 3:47 PM

The image with the error is unreadable. Make sure you reindex the database successfully first.

Rodrigo Serafim

on 10/4/19, 4:03 PM

I did reindex and I have copied the errlog message

Maria Guedes

on 10/4/19, 4:15 PM

You are likely writing the point in the incorrect format. I edited my answer.

Rodrigo Serafim

on 10/4/19, 4:27 PM

Comment

Ask a Question

Keep Informed

About the Community

This platform is for beginners and experts willing to share their Genio knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers. Read Guidelines

Question tools

10 follower(s)

Stats

Asked: 10/4/19, 1:55 PM
Seen: 2113 times
Last updated: 11/11/19, 6:15 PM