General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only