Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Make Memo Field from Select-SQL?
Message
De
21/01/2005 17:59:30
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
00979472
Message ID:
00979487
Vues:
10
Hi Sergey,

Please excuse my ignorance. This won't work for me in VFP8 (tells me I'm missing a ")" in a function) Also, I'm not familiar with CAST, is this new with VFP9?

Jim

>Sure.
SELECT field1, CAST(space(4) AS memo) as memofield ;
>  FROM table1 INTO CURSOR cursor2
>
>>Is there a way to add a memo field when selecting records from a table/cursor?
>>
>>For Example:
>>
>>
>>SELECT field1, space(4) as memofield FROM table1 INTO CURSOR cursor2
>>
>>In this example, I would like "MemoField" to be of Memo type in "cursor2".
>>Is there a way WITHOUT using CREATE CURSOR?
Jim Philippi

quando omni flunkus moritati
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform