Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Collate problem
Message
From
17/02/2009 09:00:57
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
To
17/02/2009 08:54:37
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01382300
Message ID:
01382331
Views:
23
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]
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform