How use the parameter USER

Topic: How use the parameter USER_ID in sql query (Read 1490 times) previous topic - next topic

How use the parameter USER_ID in sql query

June 30, 2020, 02:14:17 PM

I want to create a sql query using the USER_ID (Active User ID that is logged in)

Check the image below

I write the number 2, but I want to use the USER_ID, if I change the number 2 to USER_ID or $USER_ID, the query fails, how can I use correctly the USER_ID in a query?

Re: How use the parameter USER_ID in sql query

Reply #1 – June 30, 2020, 04:51:08 PM

@claudiomg‍ please check the where window and you will see a sample code at the top, double-clicking and it will be added to the text area, you can then edit it the way you want to use it.

Re: How use the parameter USER_ID in sql query

Reply #2 – June 30, 2020, 06:05:00 PM

Quote from: willvin – June 30, 2020, 04:51:08 PM

@claudiomg‍ please check the where the window and you will see a sample code at the top, double-clicking and it will be added to the text area, you can then edit it the way you want to use it.

I follow the example and it works, thank you