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
---

_______________________________________________
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/289ea162f5642645b5cf64d624c66a140b7ce...@us-ny-mail-002.waitex.net
** 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.

Reply via email to