Timeline for BEFORE INSERT validation trigger for GPS coordinates
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 27, 2019 at 20:10 | answer | added | Rick James | timeline score: 0 | |
| Nov 26, 2019 at 8:30 | comment | added | Akina | if the coordinates are within one mile of the business location, then insert, otherwise skip over the insert or update. When a query inserts/updates a pack of records, you cannot add/edit a part of them and eject all another (exclusion INSERT..ODKU, and IGNORE option, which is uncontrollable). So SP seems to be the only option. | |
| Nov 26, 2019 at 8:25 | history | edited | Akina | CC BY-SA 4.0 |
CAPS remove
|
| Nov 26, 2019 at 4:20 | comment | added | Vérace | You might want to put that logic into your question - it would save anybody who's trying to help you having to go to the trouble of looking it up? It's an interesting question - +1. p.s. welcome to the forum! 👍 | |
| Nov 26, 2019 at 4:15 | review | First posts | |||
| Nov 26, 2019 at 7:45 | |||||
| Nov 26, 2019 at 4:14 | history | asked | Frank | CC BY-SA 4.0 |