Sort column

Hi leandrorezende,

There are two ways to sort an IDEA file, the first and probalby most popular is the Index, this allows you to index up to 8 columns in the order you decided.  An index is attached to the file being indexed.  You can also perform a sort that recreates the file but in the order you have selected, again you can select up to 8 columns to sort on.

Here are some example scripts for performing an index and sorting on a file.

Function IndexDatabase
	Set db = Client.OpenDatabase("My File.IMD")
	Set task = db.Index
	'can add up to 8 columns (keys)
	task.AddKey "COLUMN A", "A" 'A is for ascending
	task.AddKey "COLUMN B", "D" 'D is for descending
	task.AddKey "COLUMN C", "A"
	task.Index FALSE 'Set to true if you want to reindex
	Set task = Nothing
	Set db = Nothing
End Function

Sorting example

Function SortDatabase
	Set db = Client.OpenDatabase("My File.IMD")
	Set task = db.Sort
	'can add up to 8 columns *keys)
	task.AddKey "COLUMN A", "A" 'A is for ascending
	task.AddKey "COLUMN B", "D" 'D is for descending
	dbName = "Sorted database.IMD"
	task.PerformTask dbName
	Set task = Nothing
	Set db = Nothing
	Client.OpenDatabase (dbName)
End Function

If you are reading through an entire file record by record you can also use an index.  This is a bit more technical so let me know if you want that information also.

Brian

Hi leandrorezende, I am just wondering, since you are looking for duplicate why you aren ot using the duplicate key detection?  This will pull off all the transactions that have duplicates within your selected column (you can select up to 8 columns to perform the duplicate test on).