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

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Next
Reply
Map
View

Click here to load this message in the networking platform