Welcome!
This community is for professionals and enthusiasts of the Genio platform.
Share your questions and challenges, and help your partners!
What is needed for Geographical coordinates field type? Is it only usable with Google maps?
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.
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.
The image with the error is unreadable. Make sure you reindex the database successfully first.
You are likely writing the point in the incorrect format. I edited my answer.
Keep Informed
About the Community
Question tools
Stats
| Asked: 04/10/19, 13:55 |
| Seen: 2115 times |
| Last updated: 11/11/19, 18:15 |
Thank you for your answer, but can you help in why I can't save the record?