Welcome!

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

1

0
Rodrigo Serafim
Activé 04/10/2019 15:41

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.

  • Signaler

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

Maria Guedes
le 04/10/2019 15:47

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

Rodrigo Serafim
le 04/10/2019 16:03

I did reindex and I have copied the errlog message

Maria Guedes
le 04/10/2019 16:15

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

Rodrigo Serafim
le 04/10/2019 16:27

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: 04/10/2019 13:55
Seen: 2121 times
Last updated: 11/11/2019 18:15