>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 -