I have a collection of objects. All objects have the same properties, and each one is created as a kind of log entry in a long process. At the end of the process, I wanted to create a cursor and fill it from these objects, like this:
for each oObj in oCollection
insert into mycursor from name oObj
endfor
The trouble is, all records came up blank. When I inserted from one of the objects I created manually, it worked.
What fixed this? for each oObj in oCollection FOXOBJECT. Because the oObj we get without it is a COM object somehow, and while the debugger shows its properties alright, Intellisense doesn't pick them and insert from name doesn't work. There may be other gotchas with this kind of object reference - just reporting that I caught this one.