Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Collate problem
Message
De
17/02/2009 09:00:57
Lutz Scheffler (En ligne)
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
 
 
À
17/02/2009 08:54:37
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:
01382331
Vues:
22
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
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform