Kurt Wendt wrote on 2012-04-04:
> 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.
>
Kurt,
CAST("" AS MEMO) AS DummyFiled
Tracy Pearson
PowerChurch Software
_______________________________________________
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/[email protected]
** 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.
