Hello All,
In Baan IVc is it possible to create a dynamic index (sort) in the before program section on a form type 3. I am not able to create a new index for this sort and wish to know if it can be done this way.

Table being read is tdsls040, there are no indexes related to order date. New sort order would be customer, order date and SO number.

Any suggestions would be greatly appreciated.
Many Thanks

Brian:confused:

If you want to use the standard program, i.e. navigating records, finding, before after, the answer is NO.

Why are you not able to add a new index to the table? It is really not a big deal to do so.

Would you be trying to do a reverse date sort order? Not sure you can do this so easily?

Originally posted by estotz
Why are you not able to add a new index to the table? It is really not a big deal to do so.

Until Baan comes out with a patch to the table and the patch includes a new index.

quote:
--------------------------------------------------------------------------------
Originally posted by estotz
Why are you not able to add a new index to the table? It is really not a big deal to do so.
--------------------------------------------------------------------------------



Until Baan comes out with a patch to the table and the patch includes a new index.

==============================================
Not sure I am following Foster. Customize the table by adding a new index by customer, date and sales order. The index would be unique since sales order is contained in the index. This takes about 2 minutes to do. Do a reconfig and then make the index available in Maintain Sales Order headers or whatever customized reports you write.

Really, a very trivial customization.

If you want to use the standard program, i.e. navigating records, finding, before after, the answer is NO.


Sorry the answer is YES to this one. In your maintain session click on tools/query use the expressions tab to define filters and the sequence tab to define sorts by ANY table field on the main table.

(it's not the very fastest though - speed depends a lot on the number of records)

I've done some investigation: when you send the query and return to your main session it takes a while to sort the data. Then things are fairly quick when you scroll through the records with either next or previous. Changing direction ie. from next to previous takes some time again but if you continue scrolling in the same direction it is quick - you'll have to see if it's acceptable for your requirements - our users use it a-lot (those that understand how it works!)

Regards,
Rupert

You can use the following (BaanV only):

before.program:
query.extend.order("<fieldname> desc")

Looks like a hit on performance though.

-- Neil