Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
INSERT INTO ...FROM ARRAY malfunctioning
Message
From
29/09/2001 19:16:44
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00559933
Message ID:
00562298
Views:
19
>>Something like Scatter Name? Mmmm... nope, there's no insert from name. A simple scatter ... memo should do, since the structures are identical.
>
>Something like "SCATTER MEMVAR MEMO" and "INSERT INTO ..... FROM MEMVAR", but I haven't had time to check it out yet. Memos have a reputation for corrupting very easily, and I've stayed away from them until this transgression... I should repent , :), and replace the memo field with a linked rtf file, like I always do.

That will work in your case, even if the structures aren't completely identical - you can have more or less fields, memos converted to strings and vice versa, numeric values of different length etc.

Come to think of it, most of our code is in memos - just look at the structure of .pjx, .vcx, .scx, .mnx and .frx files, and it's so in the last four versions. Haven't seen memo corrupted in quite a while. Maybe the last time was at home, in FPD2.6 after a power out.

back to same old

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

Click here to load this message in the networking platform