>>>It is bug.
>>>Change the field type of F2 to be C(20)
>>>and use the same insert. You will see that the parameter is passed w/o time info.
>>>
>>
>>I can't directly say bug or where. It works if VFPOLEDB driver is used from .Net. One difference is that from .Net it is DateTime.Now, from VFP Datetime() (or {...} anything that is a datetime). I can insert from anywhere but VFP:)
>>Cetin
>
>ROFL
>Maybe it is NOT designed to be used from VFP :-)))))))))))))))))))
>
>For me it is a bug, if didn't work as expected :-)
Ah I forgot to say that it works as is if I use Advantage Database Server OleDb driver instead of VFPOLEDB. That helps my confusion to increase at least:)
Cetin