Hi!

When INSERT command process the values for inserting, the objects are evaluated somewhat different. This cause strange effects when using WITH/ENDWITH. For example, when accesisng property of the usuall VFP object that way, "property is not found" error occurs. Try to assign values to variable and than use variables in the INSERT command.

>when doing a recursive dir listing using the scripting.filesystemobject method. In the insert command I am using the following:
>
>INSERT INTO filesFSO (Path, Filename, Size, Created, Modified);
>VALUES (.Path, .Name, .Size, .DateCreated, .DateLastModified)
>
>at which point i get a OLE error code 0x800a0005: Unknown COM status code msg box.
>
>BUT, when I leave the .DateCreated out, it runs just fine. Takes forever but it runs :)
>
>Any ideas what is causing this error to creep up with the .DateCreated?
>
>TIA!