mORMot Open Source

edwinsn

Member

Registered: 2010-07-02

Posts: 1,218

[REOPEN] No equivalent method for the "INSERT OR UPDATE" statement?

Hi Arnaud,

SQLite's "INSERT OR UPDATE..." statement (https://www.sqlite.org/lang_insert.html) is very handy as we don't need to check the existence of a record, and another benefit is avoiding unnecessary network round trip in a C/S environment.

I did a GREP into the mORMot source tree, I assume there is not a equivalent method yet? If no, can I make a suggestion

Update: Well, I misunderstood the AddOrUpdate() method in mORMot - it's NOT the equivalent of the "INSERT OR UPDATE" SQL statement in SQLITE. Sorry.

Last edited by edwinsn (2015-04-17 08:17:36)

---

Delphi XE4 Pro on Windows 7 64bit.
Lazarus trunk built with fpcupdelux on Windows with cross-compile for Linux 64bit.