Syntax to pass a starface variable into sql select statement

[rbovenkamp]

What is the correct syntax to pass a string variable into a sql select statement to retrieve data from a mysql server?

Regards Rick

[rbovenkamp]

I tried several combinations like:

SELECT Number FROM TableNumbers WHERE Pincode = " ' + VarStringPincode + ' "

but unfortunately didn't work. When I fill in an fixed value like:

SELECT Number FROM TableNumbers WHERE Pincode = 2012

It retrieves the correct Number so that works. Hope somebody can help me.

Thanks in advance, Rick

[slu]

You must Append the sqlStatement before and start then the database connection by SelectStatement.

[rbovenkamp]

Thanks Slu, that works!

[may]

Hello Rick,

nice to see you here although I omitted the corresponding slide about this forum in my presentation

[rbovenkamp]

No problem May