I hate to be a PITA - but, that did not work!
I got an error:
Function name is missing ).
The full VFP Select command I am running is as such:
SELECT INVHDR.Invoice as Invoice_Number, ;
DTOC(INVHDR.INVDATE) as Invoice_DATE, ;
INVHDR.ACCOUNT, INVHDR.Store as Store_Number, ;
INVHDR.CustPO as Purchase_Order_Number, ;
"$"+ALLTRIM(STR(INVHDR.TotalChg,12,2)) As Invoice_Amount, ;
SPACE(20) As Description, Space(12) As Upc, Space(25) As SKU, ;
"EACH" As UOM, CAST("" AS MEMO) AS Ship_track, ;
DTOC(INVHDR.Complete) as Cancel_Date, ;
SPACE(15) as Item_Number ;
FROM INVHDR ;
WHERE &XFILTER ;
INTO Cursor TempInv READWRITE
Again TIA,
-K-
-----Original Message-----
From: [email protected] [mailto:[email protected]]
On Behalf Of Tracy Pearson
Sent: Wednesday, April 04, 2012 5:41 PM
To: [email protected]
Subject: RE: Memo Fields in SQL SELECTS...
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-
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/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.
