FoxPro Programming
Memo in SQL READWRITE
Gravatar is a globally recognized avatar based on your email address. Memo in SQL READWRITE
  Harvey Mushman
  All
  Dec 16, 2014 @ 06:52am
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--

Gravatar is a globally recognized avatar based on your email address. Re: Memo in SQL READWRITE
  Jimbo
  Harvey Mushman
  Dec 16, 2014 @ 07:01am
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

Gravatar is a globally recognized avatar based on your email address. Re: Memo in SQL READWRITE
  Harvey Mushman
  Jimbo
  Dec 16, 2014 @ 08:35am
thanks

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

© 1996-2024