Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
When insert from name inserts blanks - gotcha
Message
From
19/12/2009 07:04:19
 
 
To
18/12/2009 20:26:02
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01439900
Message ID:
01439914
Views:
106
>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.

In general, any time you use FOR EACH with a VFP collection, you should use FOXOBJECT. Not only does it prevent this kind of problem, it's an order of magnitude faster.

Tamar
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform