Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problems with the CHRTRAN() function
Message
From
16/11/2001 04:29:42
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Problems with the CHRTRAN() function
Miscellaneous
Thread ID:
00582596
Message ID:
00582596
Views:
66
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
Next
Reply
Map
View

Click here to load this message in the networking platform