Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How can I force a cursor to have a memo field
Message
De
30/01/2001 13:21:53
 
 
À
30/01/2001 12:17:10
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00470158
Message ID:
00470206
Vues:
26
David,

You could add the memo field to the cursor using ALTER TABLE:

SELECT type FROM FoxUser INTO CURSOR ReadOnly
USE DBF() AGAIN ALIAS ReadWrite IN 0 && open cursor in read-write mode
USE && close ReadOnly cursor
ALTER TABLE ReadWrite ADD COLUMN mMemo M


>My base table doesn't have a memo field, but I want my updatable view, or cursor to have one. I can say 'select space(10) as spacefield', but how can i say something like 'select memo(10) as mymemofield'.
>
>How can I create the memo on the fly, unless i do a join from a dummy table that has a memo already in it -
>
>
>ty
>
>David Schlesinger
Daniel
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform