UPDATE

dim cn as sql::Connection

dim args as sql::Arguments

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


vsql = <<%txt%

UPDATE mytable SET

firstname = :firstname,

lastname  = :lastname

%txt%


args.set("lastname","wood")

args.set("firstname","steve")


cn.execute(vsql,args)

cn.close()