I sent Mike my Test Data APP I showed last Friday to add to his Repo. I’ll attached it here.
That App has Wizard Browses that use the File Keys. As shown below the lower case “van der Xxx” names sort after the "Zzzz " names.
TestInvoice_20230125_120355.ZIP (435.4 KB)
The Keys do have NOCASE. Not sure how the DB was setup or its exact def, I think they simply used Clarion Create()
Customer FILE,DRIVER('SQLite'),OWNER(Glo:Owner),NAME('Customer'),PRE(Cus),BINDABLE,CREATE,THREAD ! Customer's Information
GuidKey KEY(Cus:GUID),NAME('Customer_GuidKey'),NOCASE,PRIMARY !
CompanyKey KEY(Cus:CompanyGuid),DUP,NAME('Customer_CompanyKey'),NOCASE !
LastFirstNameKey KEY(Cus:LastName,Cus:FirstName),DUP,NAME('Customer_LastFirstNameKey'),NOCASE !
PostalCodeKey KEY(Cus:PostalCode),DUP,NAME('Customer_PostalCodeKey'),NOCASE !
StateKey KEY(Cus:State),DUP,NAME('Customer_StateKey'),NOCASE !
Record RECORD,PRE()
GUID STRING(16) !
CustomerNumber LONG !
CompanyGuid STRING(16) !
FirstName STRING(100) !
LastName STRING(100)