>Is there a way to write a SELECT-SQL statement so that one of the output columns is a memo type field? I know I can do SELECT "something" AS MyText, or SELECT 0000 as MyNumeric, or SELECT {} AS MyDate, but I can't figure out how or if it's even possible to get a column that's a memo type field.
>
>Alternatively, I have managed to use ALTER TABLE MySQLOutput ADD COLUMN MyMemo M or some other kluge, but once the ALTER table takes, I loose needed long field names.
>
>Any suggestions or ideas?
I don't think it's possible to directly get a memo field in the output as you wish to do. If anyone has any ideas I'd like to know how too!
You could CREATE CURSOR with the same structure as the SELECT - SQL output but with the additional memo field. Then APPEND the SELECT output into the cursor.
If you have ANY memo field in one of the SELECT tables you could reference it AS a new column. However, if you don't want its results you'd have to USE...AGAIN to make it read-write and then REPLACE ALL WITH "".
All kludges, I know...
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up