Post Closed
3392
Views
4
Comments
Solved
SQL Insert Statement
Question

is this statement true? 

2020-02-28 09-46-54
Eduardo Jauch
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.

2018-04-30 04-17-15
Charles Raphel D

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

2020-02-28 09-46-54
Eduardo Jauch
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.

UserImage.jpg
Keerthi MGS

Hey,

I am too facing this issue,


Does anyone aware of what the actual issue the error is reporting?


Thanks,

Keerthi.

2020-09-21 08-42-47
Vincent Koning

Hi Keerthi,

Please create a new thread for your question. This helps both you and the community by keeping things clear.

Thanks,

Vincent