Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Mline Not reading entire line
Message
 
À
03/12/2001 13:27:20
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00588823
Message ID:
00588830
Vues:
23
>I tried to modify an existing application. The original programmer stores commands in a memo field, reads them in an then use macro substitution to execute them. I needed to make a change in a program and get error messages in programs that use these memo fields. The memo field has the following lines
>
> SELE report
> INDEX ON STR(YEAR(report.trans_date))+category TAG year
> TOTAL ON STR(YEAR(report.trans_date))+category TO report2
> SELE 0
> USE report2
> DO mergeyr WITH 'trans_date'
> SELE rpyrly
> GO TOP
>
>I get an error on line 2, invalid sytnax or index not found. I ran a test and fined that what is happening is that line is not being read completely that is it get broken up into two lines
>
> INDEX ON STR(YEAR(report.trans_date))+category TAG
>and
> year
>
>I an not sure why. Any pointers would be appreciated (ie how would I check if there is a non-diplayable ascii character int the line, etc)


from the help: MLINE()
The length and number of the lines in a memo field are determined by the current value of SET MEMOWIDTH (the default line length is 50 characters). If a carriage return is encountered, no additional characters are returned.

from alek:
len('INDEX ON STR(YEAR(report.trans_date))+category TAG') = 50

set memowidth to 256

should solve your problem
Alek
Alek Massey
- The only stupid question is one left unasked -
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform