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
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

Keep Informed

About This 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: 86 times
Last updated: 11/11/19, 6:15 PM