Falsch sortiert

[Horst]

Hallo

Habe ein kleines Problem. Mein Modul um CDX Files neu aufzubauen generiert in einem Fall das CDX File aber die Sortierung ist falsch.

Wen ich mit dbAdmin den Index neu aufbaue stimmt es.

Im Anhang das kleine lauffähige Muster. Hoffe alles ist drin

In VO genau gleich, macht den Index aber die Sortierung stimmt nicht.

Gruss
Horst

[g.bunzel@domonet.de]

Horst,

in VO habe ich diesen Vermerk:

SetAnsi( TRUE ) // after SetNatDLL()!!


Evtl. funktioniert das auch in X#.

HTH

Gerhard

[Chris]

Hi Horst,

Can you please explain a bit more on what exactly is wrong with the generated sort order? It seems to be ok here, but I'm probably overlooking something.

[Horst]

Hallo Gerhard

Habe es probiert, keine Änderung

Hello Chris

I reduzed the code and i added a second DB to sort.

Code: Select all

  
	cPfad 				:= "c:\XIDE\TMP\"    
	
	// PV_Module
	cFilename 			:= cPfad+"PV_Module"
	FErase 				(String2Psz (cFilename+".cdx")) 

	odbTmp 				:= dbserver {cFilename,FALSE,FALSE,"DBFCDX"}   // ohne DBF
	odbTmp:createorder ("PVMODULE",,"HERSTELLER",{|| _field->HERSTELLER})

	/* ----------------------*/                         

	// Buchtexte
	cFilename 			:= cPfad+"Buchtexte"
	FErase 				(String2Psz (cFilename+".cdx")) 

	odbTmp 				:= dbserver {cFilename,FALSE,FALSE,"DBFCDX"}   // ohne DBF
	odbTmp:createorder ("Buch",,"BESCHRIEB",{|| _field->Beschrieb})

All Files are in the zip file.

Please look on the screenshot (shot2.jpg), there you can see on the left side the DB is not sorted , on the right side its sorted.
I dont know why the DB PV_Module is not sorted. I tryed also a different Field (ModulTyp->shot3.jpg) to sort but doesnt work.
When i say to dbAdmin to recreate the index , it works.

Horst

[Chris]

Hi Horst,

Thanks, i see the problem now, it's because the field in some of the records (those that appear on top after reindexing) have a few space characters in front of them. For example the "LG SOLAR" field is actually stored in the dbf as " LG SOLAR". If you remove those spaces from the fields, then the order is correct.

I don't know why dbAdmin does not show the spaces in front of the fields in the browser, but if you try to edit the field (from dbAdmin) then you will see them.

[Horst]

Hello Chris

Thank you very mutch, i see it now, its a TAB.

Horst