Good days.

I have a doubt that itself not as solving:

- As I can change the "SELECT" of a sesion of consultation, putting it otherwise? since in the program does not appear. ...

thanks

:D

You can add query extensions to the main session query. These are a little different in Baan IV and Baan V? What version are you on? I think this link will take you to the help on query extensions for Baan V.

http://www.baanboard.com/programmers_manual_baanerp_help_functions_dal_query_extensions

BaaN 4 C4.

As I can modify the "select" of a sesion of consultation?, since that select itself is not seen in the program source..

When BaaN creates a sesion of consultation, creates its own one "select" with references to many boards, references q relentizan the process, I want to modify that "select" to remove the references that do not need to optimize the time at the outset of the data..

Not sure I understand, I'll give a shot. You cannot see or edit the underlying query to the main table. So, you cannot remove the references it reads. But you can ADD to it using the query extension. In Baan IV you are limited to adding to the where clause of the main table only. In Baan V, you can extend this to other tables.

An example of a valid query extension in Baan IV is, say to find only the tdsls041 records with quantity greater than 0 would be:


before.program:
query.extension = "tdsls041.oqua > 0"


Hope that helps.

thanks....

I know this post is waaay old, but I found a new variable in the programmer's guide that may be of help here. At least I think it's new, I don't see it in my Baan IV guide, and never ran across it before:

long select.only.fields.on.form

true: all reference tables are read (default)
false: only reference tables of fields on form are read

Use in before.program section.

I will take him a look as soon as I can remember the session's name.


thank you.