Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to get SQL memo column
Message
From
20/11/1998 17:21:18
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
19/11/1998 12:03:24
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00159322
Message ID:
00159998
Views:
19
>I tried that, it only seems to work with expressions of 2 terms. The following does not work:
>
>
>create table test1 (c1 c(254))
>create table test2 (c1 c(254))
>insert into test1 (c1) values (replicate('X', 254))
>insert into test2 (c1) values (replicate('X', 254))
>create cursor tmp (dummy M)
>insert into tmp values("")
>select dummy+test1.c1+test1.c1 as memocol from test1,test2,tmp
>
Would

select dummy+test1.c1+test2.c1 as memocol from test1,test2,tmp

matter? You've used test1 twice in your last line.

Nope, it doesn't work even that way. I've tested a dozen variants, and they all give "String too long to fit".

back to same old

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

Click here to load this message in the networking platform