Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
MLINE(comment,1) in cursor truncates memo field
Message
De
01/03/1999 16:56:44
 
 
À
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:
00192876
Vues:
22
Bob ---

Try using the second parameter of MLINE() explicitly using the _MLINE system variable...for example:

nCurrMLine=_MLINE
SELECT MLINE(comment,1,_MLINE) FROM hdefects INTO CURSOR curTemps WHERE .....


>If I do this:
>
>? MLINE(comment,1) && where comment is a memo field
>
>I get the first line of the memo field, as I expected.
>
>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
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform