Evaluate_string Method

dim cn as sql::Connection

cn.open("::name::conn")

vsql = "SELECT * FROM mytable WHERE lastname='{lastname}'"

lastname = "wood"

vsql = evaluate_string(vsql)


'vsql now contains "SELECT * FROM mytable WHERE lastname='wood'"


cn.execute(vsql)

cn.close()