Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using CHRTRAN to search
Message
De
17/02/2012 06:02:24
 
 
À
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:
01535650
Vues:
191
>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.

Sorry, but as long as I know you can't use CHRTRAN() for "searching" records and less on an index key...

You must find using AT() or similar and then you can replace what you want using STRTRAN()

Now I'd really like to know what happen if you use CHRTRAN() on an index key.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform