>>How can I insert current datetime in my sql table via VFP ?
>>
>>year, month, day, h, m,s
>>
>>Please help me insert date in line below:
>>
>>cSQL = "UPDATE reembolso set reg_correios= ?m.reg_correios, env_ect = 1 where code = ?m.code, datetime = "
>>
>>asa=SQLEXEC(lnHandle,cSQL )
>>
>>I am not sure if I have to convert it.
>>
>>Moises
>

>ltTime = datetime()
>
>cSQL = "UPDATE reembolso set reg_correios= ?m.reg_correios, env_ect = 1 where code = ?m.code, datetime = ?m.ltTime" 
>
>asa=SQLEXEC(lnHandle,cSQL )

That's slick, Tore, but doesn't that add the time to the string and mess up the comparison?