Memo Fields

[obliviux]

Is there a reason that whenever I use the Visual FoxPro 6.0 debugger and get to a line that sets the oder to a table that has a memo field, it crashes foxpro.&nbsp;&nbsp;<br>It display the call stack in a window and then the compiler crashes and shuts down.<br><br>Why is this?<br><br>thanks<br><br><br>Jeremy

 

[CDavis]

Post a few lines of your code and we may be able to better understand what is going on.<br>--CDavis

 

[dgrewe]

Maybe this quote from the foxpro help file on INDEX will shed some light on the problem.<br><br>&quot;If you attempt to build an index with a key that varies in length, the key will be padded with spaces. Variable-length index keys aren't supported in Visual FoxPro.<br><br>It is possible to create an index key with 0 length. For example, a 0-length index key is created when the index expression is a substring of an empty memo field. A 0-length index key generates an error message. When Visual FoxPro creates an index, it evaluates fields in the first record in the table. If a field is empty, it may be necessary to enter some temporary data in the field in the first record to prevent a 0-length index key.<br><br>The length of an index key for an .idx index must be between 1 and 100 characters. The length of an index key for a .cdx index must be between 1 and 240 characters.&quot;<br><br> <p>David W. Grewe<br><a href=mailtoave@internationalbid.net>Dave@internationalbid.net</a><br><a href= > </a><br>

 

[csr]

Would like to help but need clarification on this line ...<br>&quot;a line that sets the oder to a table that has a memo field&quot;.&nbsp;&nbsp;I do not understand that.<br>

 

[obliviux]

For those who are confused the following line:<br>