>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?
>t.i.a.
vardate=date(2005,1,10)
sql="update dates set dat1=?vardate where code=1"
Is this works?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.