SELECT *, MEMO as myMemo FROM table INTO CURSOR tCursor
If I was creating a string it would look like...
SELECT *, SPACE(100) as myString FROM table INTO CURSOR tCursor
I'm sure it is simple but I'm not finding it in the doc's.
Thanks for any advice
--hm--
In a SELECT statement with a READWRITE, I want to create a MEMO field that will become populated with data on a second pass at the result cursor. How does one define the MEMO on the first pass?
SELECT *, MEMO as myMemo FROM table INTO CURSOR tCursor
If I was creating a string it would look like...
SELECT *, SPACE(100) as myString FROM table INTO CURSOR tCursor
I'm sure it is simple but I'm not finding it in the doc's.
Thanks for any advice
--hm
select cast('' as M) as colname,....
In a SELECT statement with a READWRITE, I want to create a MEMO field that will become populated with data on a second pass at the result cursor. How does one define the MEMO on the first pass?
SELECT *, MEMO as myMemo FROM table INTO CURSOR tCursor
If I was creating a string it would look like...
SELECT *, SPACE(100) as myString FROM table INTO CURSOR tCursor
I'm sure it is simple but I'm not finding it in the doc's.
Thanks for any advice
--hm--