Fox 2.6: Beyond String

[filibuster]

in our application's error log the error message "beyond string" is shown. The error happened during a reindexing process.

However, I could not reproduce the error, neither by re-reindexing the table nor by playing around with the substr() function (this is the function which causes the "beyond string" message).

I remember having had this problem years ago, and that it was related to a corroupted dbf/cdx/fpt file. However I'm not sure, but maybe some people here do know more ?

It's not a major issue in our project, as the error did not occur again, but I'd still like to know.


I was trying to reproduce a "beyond string" programatically, e.g.

? substring( "Test", 100, 1)

but was never able to get the "beyond string" error. I did search the web (experts-exchange, universal thread, tek-tips, ms knowledge and google), but this error seems to never occur ...

does anybody know how to reproduce the error ? please note that I'm using Fox 2.6. There was a similar error caused by a bug VFP 5, which has been removed in subsequent versions of VFP.

 

[rgbean]

I think you'll find that this happened on an index that was defined with substr() in the expression. There were some releases that actually created the index length based on the FIRST record when the index was created. This could obviously cause problems if the data field was empty().

You are using 'a' release of 2.6, and not the original release aren't you?

Rick