Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
New memo field to output dbf
Message
From
04/11/2005 08:13:27
 
 
To
04/11/2005 08:05:18
Kathy Schmidt
Michigan Health and Hospital Association
Michigan, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 6
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01065395
Message ID:
01065398
Views:
11
>How do I add a new memo field to the output dbf when querying a table? There is no memo field in the table being queried. (VFP 6.0)
>
>Thanks!

Kathy,

Create a cursor with one record and an empty memo field

If you need this often, create a free table that you include in the app/exe
create cursor EmptyTable ;
    ( et_m M default '' ;
    )
append blank

select Table1.*, ;
       et_m    as FieldMemoName ;
    from Table1, EmptyTable, ....
Gregory
Previous
Reply
Map
View

Click here to load this message in the networking platform