dnnslbrwn
1st June 2004, 00:10
There was an ealier post (2 years ago) about the possibility of starting QBF automatically in a session. While there were lots of posts about other suggestions, I am interested in the original though and how QBF communicates with the session. I would like to create a display session that is sorted on a non indexed field.

I am on BAAN IV so I can not use the extend query feature for sort order (don't remember the exact name right now), I can't add an index to the table as that is a policy our company has adopted (which I agree 100% with) - and I would rather not add a new table that I fill every time a user starts the session with a copy of all of my inventory data just to have an index available to use.

I will be creating the session so I will have the ability to code - if I knew what the variables that QBF used, I think I could set them to acheive what I need.

Thoughts?

Cheers,

-Dennis

Hitesh Shah
1st June 2004, 08:56
As far as i understand ur query , there is no need to write ur own session. In the maintain
session ttadv2100m000 just write the startup choice as 46 - query . It will start the QBF .

Further in the 2nd form of ttstpqbf there is sort sequence which u can use to sort the session
on non-indexed field even in descending mode.

As to the communication with main session , I guess the it must be using dynamic query
and storing the compiled sql ids (next , prev , first , last etc) in the sql ids of
main session.

dnnslbrwn
1st June 2004, 21:10
Well, I will be creating a new session as there is not one there with the layout that I need. I see the advantage to setting the start option to 46 to get part of the way, but as the user wants to sort by date EVERY time, I would like to just set the arguments. Anybody ever tried AFS on the QBF session :eek:

Thanks for the response

-Dennis