Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Build memo with SELECT command
Message
 
 
To
28/05/2003 08:35:21
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00793424
Message ID:
00793429
Views:
37
You may try UNION ALL.
CREATE CURSOR test;
  (m1 M DEFAULT REPLICATE('X',300))

APPEND BLANK
CREATE CURSOR memofield (mm M)

SELECT MM  AS  mResult FROM memofield ;
UNION ALL ;
SELECT m1  AS  mResult FROM test INTO CURSOR cResult
>Hi,
>
>i need build one memo field on SELECT result cursor.
>
>Example:
>
>SELECT eString AS memoField FROM table1 INTO CURSOR result
>
>where eString is one string expression.
>
>I need memoField is a MEMO field.
>
>Thanks
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform