The SPT parameters work best but you can also use TEXTMERGE
vardate=date(2005,1,10)
sql = "update dates set dat1= ?vardate where code=1"
lnRetVAl = SQLEXEC(..., sql")
>Hi, i just need to know what's the best way to change a date field on sql server even any other db.
>vardate=date(2005,1,10)
>i use something like sql="update dates set dat1={"+dtoc(vardate)+"} where code=1" but some databases like db2 this changes to: sql="update dates set dat1='"+dtoc(vardate)+"' where code=1" the { changes to ' there is a generic way to do this?
--sb--