mORMot Open Source

factor200x

Member

Registered: 2017-05-23

Posts: 15

Question to TSQLRestClientURI

Hello,

When I run the following command on the client side, the SQL statement is not executed. Can someone give me a tip, what I do wrong?

This is the command I want to run:

TSQLRestClientURI.Execute('UPDATE TblTest SET Field1 = 2')

TSQLRestClientURI.Execute returns False

Many thanks
Olaf

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: Question to TSQLRestClientURI

As explained in the framework doc:

1. Plain SQL are a wrong idea on the client side.
Use a service instead.

2. For security reasons, such direct SQL write operations are disabled.
See TSQLAuthGroup documentation about tuning the ORM remote execution rights.

3. If you really need remote SQL execution, consider using the SynDBRemote feature, not the RESTful ORM.