U++ forum: Welcome to the forum

Re: quick parameter question [message #53341 is a reply to message #53340]

Mon, 30 March 2020 01:56

mtdew3q
Messages: 181
Registered: July 2010
Location: Upstate, NY (near Canada)

Experienced Member

Hi Novo-

I am just not sure in the syntax for use with the parameter. I see how they do it in an insert statement on the sql tutorial, but I am not sure how to use a select statement with a parameter.

U++ comes with a zillion sql expressions, but for whatever reason, I haven't seen an example with select used for a select statement and a parameter.I could figure out the SQL::SetParam piece, but I don't know how the sql syntax works with that.

I looked in the examples of sql expressions that are in postgresql translated to U++ expressions on the website.

Is there any way someone can give me an example of how to do that with a parameter in the where clause?

Thanks,
roboloki

Report message to a moderator