HMGforum.com

Hola amigos.

Desde hace unos días estoy utilizando las funciones OrdCondSet() y OrdCreate() para filtrar una base de datos con 75.000 registros, añadiendo un nuevo TAG (provisional) al BAG de un índice CDX que ya existe y consigo más rapidez que con la función OrdScope(). El nuevo TAG, una vez que lo he usado, lo borro.

Solo tengo un problema, que necesito, además de filtrar, ordenar por otro campo y no sé como hacerlo.

Os agradezco la ayuda que me podáis ofrecer.

Saludos.
Rafael Pérez

Translated by Google.
Hello friends.

For a few days I'm using OrdCondSet functions () and OrdCreate () to filter a database with 75,000 records, adding a new TAG (provisional) to BAG CDX index that already exists and get more quickly than OrdScope function (). The new TAG, once I've used it, I delete it.

Only I have a problem, I need, plus filter, sort by another field and do not know how.

I appreciate the help that you may offer me.

Greetings.
Rafael Pérez

arroya2 wrote: For a few days I'm using OrdCondSet functions () and OrdCreate () to filter a database with 75,000 records, adding a new TAG (provisional) to BAG CDX index that already exists and get more quickly than OrdScope function (). The new TAG, once I've used it, I delete it.

Only I have a problem, I need, plus filter, sort by another field and do not know how.

Hola Rafael

If I understood correct, you want :

- more than one index ( tag / order ) in same index file (order bag)
- assign different condition ( filter ) to each

If so, you need call OrdCondSet () and OrdCreate () pair separately for each filter / condition by giving different <OrderName> (tag) to each.

If <OrderName> does not already exist in the order list ( index file ), then it is added. If it is does exist, then the <OrderName> replaces the former name in the order list.

I hope this will give you an idea

By the way, your topic may be more relevant to "Database" sub forum (viewforum.php?f=37) of "HMG General Help" forum ( viewforum.php?f=5).

Happy HMG'ing