>>>>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?
>
>Well, you question was "How can I insert current datetime"...
That was the question but the example he gave us is a comparison.
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.