Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using CHRTRAN to search
Message
From
14/02/2012 21:30:58
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Using CHRTRAN to search
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows 7
Network:
Windows 2000 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01535424
Message ID:
01535424
Views:
196
Hi. I want to be able to search my dbf (free) from a form with the "dashes, slashes and blanks" removed (for a more thourough Find).

I am using the following on both my search criteria and the index for my database
CHRTRAN(itemno,'/- ','')
with NO favorable results. Can someone tell me what I am doing wrong (or an article/example)?? I am using a SEEK. Should I be using SQL?

Thanks, Randy
ps: I am still in Fox 7.
Next
Reply
Map
View

Click here to load this message in the networking platform