Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Mline Not reading entire line
Message
 
To
03/12/2001 13:27:20
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00588823
Message ID:
00588830
Views:
21
>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 -
Previous
Reply
Map
View

Click here to load this message in the networking platform