Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using CHRTRAN to search
Message
De
15/02/2012 12:36:36
 
 
À
14/02/2012 21:30:58
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Windows 7
Network:
Windows 2000 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01535424
Message ID:
01535482
Vues:
121
>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)" ?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform