I want to add an empty field to the cursor created with SQL Select.
The field should of memo type, so that later it can be populated.
For example, if I wanted the field to be of char type I would do the following?
select MYFIELD1, MYFIELD2, space(10) as MYNEWFLD from MYTABLE
But what would I put in the place of "space(10)" if I want the MYNEWFLD to be of memo type?
I realize I can add the field after I create the cursor, but I am curious if it is possible to do in one expression.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham