UPDATEis not supported in Starcounter SQL,
DELETEis available through
INSERTis available with reload. Objects are otherwise created and updated in the programming code.
LastNameof all the
Personobjects in the database, they would be looped through and updated, like so:
Deletemethod on an object
Deleteis used for single objects and
DELETE FROMis used for many objects.
person.Delete()will just delete
DELETE FROM Personwill delete all objects of the
DELETE FROMmight breach the size limit for a single transaction which will cause Starcounter to throw
ScErrMemoryLimitReachedAbort. This can be fixed by using
Deleteand splitting the deletion in smaller transactions: