mORMot Open Source

KJames

Member

Registered: 2013-07-02

Posts: 15

TSQLHttpClientWinHTTP function EngineExecute

Hello,

I'm trying to use this function to execute a update command like:

UPDATE TABLE1 SET VAL = ((VAL * 0.5) + VAL) WHERE column2ID= 5

and this function doesn't execute the command correctly into the database.

But the SQL command works normally when I run it directly into the database.

Why does it happen?

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: TSQLHttpClientWinHTTP function EngineExecute

How to you call it?
You should not execute such requests from the client side (i.e. via TSQLRestClientURI methods).
The ORM core has translation features with external tables - see the SAD 1.18 pdf about how it works.

You can execute it directly into the DB on the server side, using e.g. the SynDB layer for external databases, or the SQLite3 engine.

Step into your code with the debugger to see what happed.