Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2003 Server
>I have a large number of DBF files and I want to find out if any of them contain a certain string.
>
>The Search in Windows Explorer does NOT find it even if I open a dbf file and copy an exact string, then use Search utility to find that string, it still says NOT FOUND
>
>I am not sure what field it will be in, but it will be a 10 digit number, but stored in a character field.
>
>I could open each file and do Control F to find it, but I have several hundred dbf files to look through and numerous strings to look for.
>
>Any suggestions????
You can use ADir() to fill an array with your table names and AFields() to get all (char) fields in each table.
Then you can either "Locate For" (and "Continue") to find matching rows.
Or use ATagInfo() to find index tags that can be used in Seek() expressions.
hth
-Stefan
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement