Anyone know if there's a limit to how long the for ... clause can be in an index statement. According to "Compact index file structure" in help, 2 bytes are set aside in the tag header record to indicate the size of the "for pool." That'd make it possible hold 655536 bytes, but that seems unbelievably generous and unlikely.
The help file says: For a standalone index (.idx) file, the length of an index key must be between 1 and 100 characters. For a compound index (.cdx) file, the length of an index key must be between 1 and 240 characters. I've hit the limit when I've had long character fields(250) and didn't set it to left(field,200) or something... -- Derek _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
