Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Make Memo Field from Select-SQL?
Message
From
21/01/2005 17:59:30
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00979472
Message ID:
00979487
Views:
11
Hi Sergey,

Please excuse my ignorance. This won't work for me in VFP8 (tells me I'm missing a ")" in a function) Also, I'm not familiar with CAST, is this new with VFP9?

Jim

>Sure.
SELECT field1, CAST(space(4) AS memo) as memofield ;
>  FROM table1 INTO CURSOR cursor2
>
>>Is there a way to add a memo field when selecting records from a table/cursor?
>>
>>For Example:
>>
>>
>>SELECT field1, space(4) as memofield FROM table1 INTO CURSOR cursor2
>>
>>In this example, I would like "MemoField" to be of Memo type in "cursor2".
>>Is there a way WITHOUT using CREATE CURSOR?
Jim Philippi

quando omni flunkus moritati
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform