Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can I add a blank memo to a cursor via select
Message
 
 
To
04/06/2003 15:10:33
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00796309
Message ID:
00796344
Views:
14
>Hi, Steve.
>
>>I would like to add an empty memo field to a cursor created with a select. For instance memo as blnkmemo, like the character below:
>>
>>
SELECT *, space(50) as blnkchar;
>> from dbtwiz!tactualdata;
>> WHERE thisform.zgettoolset(tactualdata.fkey)==thisform.ztoolset;
>> into cursor cExport readwrite
>>any suggestions?, Thanks
>
>You could issue an ALTER TABLE command after your Select-SQL:
>
>
>Alter Table cExport add column blnkmemo M
>
>
>HTH

It wouldn't work if cursor has long field names.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform