It's a normal behavior, you are trying to get a Memo Field based on a variable. If you want to create a Memo Field, you have to create based on a cursor:

SELECT * FROM (HOME(2)+"Northwind\Employees") ;
    INTO CURSOR MiCursor 

**** Create a Dummie cursor with the datatype you want, in this sample
**** a Memo field
**** First, add a empy record.

CREATE CURSOR Dummie (CampoMemo M)

APPEND BLANK  IN "Dummie"

**** Join the cursors..

SELECT * FROM MiCursor, Dummie ;
      INTO CURSOR MiCursor READWRITE

BROW

This will change in VFP9 where you can add field with explicit data type, using the new Cast() function.


>Is there anyway to get the select statement to notice that the string is too long for a straight text field and to convert it to a memo field when I run the following select command? I would expect the resulting table to have a memo field, but I don't get one, I get the error "String is too long to fit" instead. Win2K and VFP8.0 and all service packs.

>create table junk.dbf (junk c(1))
>appe blan
>appe blan
>m.junk = space(671)
>SELECT m.junk FROM junk INTO TABLE junk1.dbf

>Thanks in advance and out for the weekend.

Apoya a Visual FoxPro usandolo legalmente
--
¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º
Espartaco Palma Martínez
SysOp PortalFox
http://www.portalfox.com 
esparta@portalfox.com