Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
String too long
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00945890
Message ID:
00945893
Vues:
24
This message has been marked as the solution to the initial question of the thread.
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform