Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
MLINE(comment,1) in cursor truncates memo field
Message
 
À
01/03/1999 16:51:52
Bob Tracy
Independent Consultant
Driftwood, Texas, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00192872
Message ID:
00192878
Vues:
15
>If I do this:
>SELECT MLINE(comment,1) FROM hdefects INTO CURSOR curTemp WHERE .....
>I get the first few characters of the memo line but not the entire line. SET
>MEMOWIDTH doesn't seem to have anything to do with the length of the returned
>line. What am I overlooking? TIA

You're probably overlooking the fact that the first returned line in a SELECT statement determines the field width for the rest of the lines.

Try SELECT PADR(MLINE(comment, 1), SET('MEMOWIDTH')) AS comment...
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform