Create a cursor with a memo field, add a blank record to it and then add that field to your sql
On 4 Apr 2012 17:34, "Kurt Wendt" <[email protected]> wrote: I hope this doesn't sound like a stupid question. And, I did look in the online help for the answer - but, a quick search under SQL SELECT did not reveal the answer. So - here's the deal. I know I can define an empty column in an SQL SELECT based upon Spaces using something like: SPACE(6) AS DummyField But, I don't know how to do it for a Memo field. I saw that I do have a Memo field coming from this one DBF in my current SQL Select - but, now I removed that Memo field due to problems (as I stated in a Thread a several weeks ago here) . So - now I want to generate an Empty Memo field - that I will then fill with data After the main Select has been accomplished. I even tried: Memo AS DummyField However, obviously that did NOT work... TIA, -K- Senior Developer Waitex Information System, Inc. P Save a tree. Don't print this e-mail unless it's really necessary. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAHEe=u7prxhggdwk_7eocauudxpqbvap9q8zmmwspcnaxcw...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
