SQL and variables

[Mojster]

I'd like to know how to put variable in SQL statement.
For example:

.....
WHERE t.name= variable
.....


Thanks!

 

[jpbrault]

Var
variable string
endvar

variable = "\"My string\""

S = SQL

SELECT *
FROM table
WHERE Fld = ~variable

endSQL

 

[almir]

If you don't use the same string (ie. string value depends on user's request), try this:

var
sqlString SQL
var String
endVar

var.view("Enter your string:&quot

sqlString =
SQL
SELECT * FROM TableName
where var = ~var
endSQL
endMethod