Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using CHRTRAN to search
Message
From
15/02/2012 12:36:36
 
 
To
14/02/2012 21:30:58
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
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:
01535482
Views:
125
>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.

Can you give a bit more detail of what the nature of the search? For example, is it along the lines of "search for items that start with (search-string)", or is it more like "search for items that contain (search-string)" ?
Previous
Reply
Map
View

Click here to load this message in the networking platform