do as database ... end is available for Private Cloud/On-Premises.
Ninox executes transactions either in the client or on server.
On one hand, which transaction is executed on server or in the client depends on its type (read or write). On the other hand, it also depends on whether the transaction was triggered in the web app or the native app.
A client is the program that is executed on an end device of a network, communicating with a server. Depending on what needs to be done, Ninox executes an instruction directly at the client or at the server.
| Description | Transaction type | Web app | Native app |
|---|---|---|---|
Data management
Write
Server
Client
Write
Server
Client
Write
Server
Client
Read
Server
Client
Scripting
Read
Client
Client
Write
Server
Client
Read
Server
Client
Read/Write
Server
Client
Read/Write
Server
Server
Read/Write
Server
Server
Read/Write
Client
Client
Read/Write
Client
Client
Write
Server
Client
Write
Server
Client
Create
Change
Delete
Load views
General (no data change)
General (at least one data change)
select
do as transaction
do as server
do as deferred
do as database
Trigger after open
Trigger on new record
Trigger after update