Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Collate problem
Message
De
17/02/2009 09:03:32
 
 
À
17/02/2009 09:00:57
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01382300
Message ID:
01382332
Vues:
29
hi Agnes,

I would have preferred steps (1) to (8), but then, that's me

>Gregory,
>
>if anything else fails ...
>
>We solved the problem the other way arround.
>I create (anyway) a extra sorting key, export the original name and the key, costumer uses this to rename the files (they use some self created Excel automation) to my index and print it in this order.
>
>Voila!
>
>Agnes
>>ah, Agnes,
>>
>>And I thought you picked up the files from the file system...
>>
>>Well - proposal
>>(1) Check locally if the sorting sequence is ok, by adding a few files in a folder manually
>>
>>(2) if (1) is ok, then
>>- create a temp folder
>>- strToFile('', addbs(tmpFolder) + rtrim(TableName.FieldName) ) all names you have in the table
>>
>>(3) sort the folder using ("Scripting.FileSystemObject")
>>
>>(4) update an int in the table (the number of the file out of ("Scripting.FileSystemObject")
>>
>>(5) get rid of the tmp folder and its contents
>>
>>(6) set the index to that int field
>>
>>(7) grid.Refresh()
>>
>>(8) done
Gregory
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform