Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Mline not returning all text
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Pro
Database:
Visual FoxPro
Divers
Thread ID:
01003652
Message ID:
01003660
Vues:
22
MLINE() is depend on SET MEMOWIDTH TO n, you can use ALINES().

MartinJ

>hi all,
>i have a problem with a memo field, its contents are below (please don't mock my test data!).
>
>aMarks testing kokokoko1
>bline 2
>
>When i do the following
>
>SELECT MLINE(memo1,1) as "Description" FROM sub_table
>
>i get "aMarks testi" returned. if i set _mline to 50 and run
>
>SELECT MLINE(memo1,1,_mline) as "Description" FROM sub_table
>
>i get "n". What ultimately i need to do is
>
>SELECT MLINE(memo1,1) + " " + MLINE(memo1,2) as "Description" FROM sub_table
>
>but i cannot even manage to get the first line of the memo filed out.
>I have hit this before but i cannot remember how to remedy it, any help gratefully received.
>Slán
>~M
"Navision is evil that needs to be erazed... to the ground"

Jabber: gorila@dione.zcu.cz
Jabber? Jabbim
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform