#1 Re: mORMot 1 » Update part of a table | Execute Pure SQL » 2017-10-17 16:58:02

Hello JD, thanks for your help, I will take a look at your example. In this meantime, I just got another way to do that directly in the database.

Using TSQLDBConnectionProperties and TQuery.

#2 mORMot 1 » Update part of a table | Execute Pure SQL » 2017-10-16 23:35:16

ivanilsonpacheco
Replies: 2

Hello AB, congratulations for your great work!

I have two questions:

1 - Is it possible to update only part of a table?
Ex: I have a product table, when there is a buying process I need to update only stock quantity, costs...
I know I can use Client.UpdateField to update only one field, but I think this is not the correct way to do that

2 - Can I execute pure SQL commands "overriding" the ORM?

PS: I'm using Client/Server http.

Forgive me if I typed something wrong, I'm not fluent in English.

#3 mORMot 1 » TSQLHttpClient Connections » 2017-07-12 10:13:26

ivanilsonpacheco
Replies: 1

Hello, I'm new on mORMot and I'd like to know which is the best way to manage httpclient connections. Every time I do something like insert, update or retrieve I use

TSQLHttpClientWinHTTP.Create('localhost','888',aModel);

but I know this isn't the best way to do it, how can I reduce this work?

Board footer

Powered by FluxBB