SQL Insert Statement

SQL Insert Statement

  

is this statement true? 

Hi Errorn, 

   https://www.w3schools.com/sql/sql_insert.asp

    Just go through the above link . It will give you an idea on how to modify that command according to your table structure

Solution

Hello Erron,

Don't understand what do you mean by "true"?

Usually, an INSERT is done this way:

INSERT INTO {identify} VALUES (@userid, @deviceid)

But for something so simple and for a single record, we would use the CreateIdentify or CreateOrUpdateIdentify entity actions. Every action in OutSystems have those entity actions. Exceptions for accessing them from consumer modules if they are set to ReadOnly or if they do not have a Primary Key (identifier).

Cheers.

Solution