Hello,
As part of a simple data cleaning routine I am using the following code:
lcNameKey = CHRTRAN(lcNameKey, " ',./;#[]{}=-_+()*&^%$£!z", "")
99.9% of the time this code does exactly what you would expect...
However, every once in a while the code instantiates a Fatal Exception C000000005 error (I may have incorrect number of 0's but you know the one I mean)
I cannot see any pattern in the value coming in as lcNameKey, usually a surname or forename and surname.
I am running VFP6 SP5.
The code is called from within a SCAN loop, the error occurs less on low data quantities (< 1000) and more on quantities into the tens of thousands.
Has anybody come across anything similar? Can anyone provide any advice?
TIA
Ben
Ben Sugden
"Remember to enjoy hunting - and that means relishing the search for the product that has never been advertised or placed handily at the front of the shop; Life begins on the uppermost shelf, avoid guide books and top 10's like the plague." - Ramsey Dukes