Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Hi Mr. Nedeljkovich,
Thanks for your answer. I had set Collate to "SLOVAK" and created new table and populated with new data. After building index on field lastname (containing national characters) and issuing SET ORDER order in browse window is again confusing (CodePage od DB is 1250) beacuse lower case are between uppercase and also in no proper order. Then I tried this:
gcTranslationExpression =""
for i = 0 to 255
gcTranslationExpression=gcTranslationExpression+chr(i)
next i
gcTranslationExpression=chrtran(gcTranslationExpression,;
"ČĆĐŠŽZ","CCDSY")
save to gcTranslationExpression
RESTORE FROM curdir() + 'gcTranslationExpression' additive
and table is indexed by:
USE TEST3 EXCLUSIVE
INDEX on SYS(15,gcTranslationExpression,prezime) TAG baprez
REINDEX
SET ORDER TO tag baprez
BROWSE
but it order field prezime (only upper case is used) properly only if it contain only one letter; if you add full lastname they are loosing order. Realy weird. Very strange that in so mighty VFP9 has no easy solution for more than 25 mil. citizens :(
In any way, thanks you for your fast response.
Précédent
Suivant
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