Are there have an easy way to update one record ?

htits · 2017-01-23 06:03:50

Are there have an easy way to update one record ?
select * from tablename where keyfield=?keyValue
if found
update
else
insert JSON

ab · 2017-01-23 08:31:36

See TSQLRest.AddOrUpdate if keyfield is ID.
https://synopse.info/files/html/api-1.1 … DDORUPDATE
But it will depend on the supplied ID value (0 or not 0).

Otherwise, there is no such a direct method, since a command like REPLACE is not supported directly by all SQL dialects.
You should rather use an aggregate record, and update internal fields depending on your business logic.

edwinsn · 2017-01-23 12:25:17

@ab, is there a way for us to extend the TSQLRestBatch class to support the real "INSERT OR REPLACE" operation supported by SQLITE? Thanks.

ab · 2017-01-23 13:00:52

Isn't it already there as a batch option?

htits · 2017-01-23 22:52:58

In my old project, I got tableName and delta (in TFDMemTable & TClientDataset, What Log changs), It can easy save to Datasnap's Server.
If I serializate tableName and delta to Json,
How I save the Json to mORMot's server?

mORMot Open Source

#1 2017-01-23 06:03:50

Are there have an easy way to update one record ?

#2 2017-01-23 08:31:36

Re: Are there have an easy way to update one record ?

#3 2017-01-23 12:25:17

Re: Are there have an easy way to update one record ?

#4 2017-01-23 13:00:52

Re: Are there have an easy way to update one record ?

#5 2017-01-23 22:52:58

Re: Are there have an easy way to update one record ?

Board footer