You are not logged in.
Pages: 1
How would I represent this in MORMot (SQLite3)?
UPDATE info SET b=true WHERE a=1;
Right now I'm doing a CreateAndFillPrepare and then looping through the result set and updating each record. I'm just checking to see if there is a method I am missing.
Offline
In fact, such a feature did exist at low-level (via EngineUpdateField abstract methods), but not at high-level
I have just added TSQLRest.UpdateField() overloaded methods to update a single field in a record.
See http://synopse.info/fossil/info/d2aaf10a69
You could now write either:
Client.UpdateField(TSQLRecordInfo,'a',1,'b',true); // with variant
Client.UpdateField(TSQLRecordInfo,'a',[1],'b',[true]); // with a parameter array
Offline
Thanks!
Offline
Offline
Pages: 1