>>>>Why ? It will be your only option from the likes of it
>>>>
>>>>(1) You can zap a cursor, append + append general [LINK]
>>>>
>>>>(2) You can define a view on the table with an empty general field
>>>>- general field = not updatable
>>>>- requery view
>>>>- scan all
>>>> - append general [ LINK]
>>>>- endscan
>>>>- go top
>>>>
>>>>(3) there is a LINK option in the append general
>>>
>>>Ok. For me.
>>>
>>>How do I define a empty general field in a CA? (IOW there is no general field in any other cursor) ?
>>______
>>Agnes,
>>
>>I have never used a CA .... but I would use a view with an empty general field (not updatable) added
>>Then use an event or so to fill out the general field ( aftercursorfill ?) + some events on the record level should the content of table field (filename) change - if applicable in your case
>
>How do you create an empty general field in a view (or any SELECT SQL result) then?
____________
Yeah, the cast does not seem to work - revert to the vfp6 tricks then

I have a table which is included in the app/exe

It's called EmptyTable and has definitions for 'empty' fields. It has ONE record. I used that a lot in the vfp6 period

It has eg an empty memo field (et_m), a nullable memo field (null_m)
I could add a general field (eg et_g)

Then

create sql view hello as ;
    select Table.*, ;
                et_g as TheField ;
   from Table, EmptyTable ;
   where (........  ?.... .....) ;
   order by ....