I know it's old technology - but that's what is being used.

We have a MySql table with a DateTime field which is used to store the last savedate for the record. I don't know exactly how the programmer is getting data to and from the table but he has some code referencing a RecordSet and he passes some SQL code to it. The VFP equivalent would be

=SQLEXEC(lnHandle,"UPDATE mytable SET savedate = ?DATETIME() WHERE myCondition")

Could somebody please provide a VB6 equivalent statement?????

(At least what the SQL portion should be)

Thanks to all.............Rich