Baanboard.com

Baanboard.com (http://www.baanboard.com/baanboard/index.php)
-   Tools Development (http://www.baanboard.com/baanboard/forumdisplay.php?f=8)
-   -   Setting query.extention of any standard session (http://www.baanboard.com/baanboard/showthread.php?t=69527)

VishalMistry 9th December 2016 16:06

Setting query.extention of any standard session
 
Hello everyone,

I want to set query.extention of standard session (say tiitm0101m000). So that, when the session is started, it will filter and display records based on query.extension.

How can I do it ?

Vishal

mark_h 9th December 2016 19:18

Do you own source code? If you do all you have to do is in the before.program section add the query.extension code. Below is sample code we have in one session - when you zoom from the tiudi session it creates a filter on the session. If you do not have source code then you need to look at a source extender option.

Code:


        if prog.name$ = "tiudi4102m000" then
                query.extension = "tirou001.cwoc <> " & chr$(34) & "ZZZ" & chr$(34) & " and tirou001.kowc <> 3"
        endif


VishalMistry 12th December 2016 10:04

HI mark,

We do not own source code. Any other way around ?

Vishal

sachinbaan 12th December 2016 11:44

Hello,
You can give try to "Before.zoom"
field.f.item:
Before.zoom:
tiitm001.kitm = tckitm.manufacture
OR

You can create one session with main table tiitm001, there you can give query.extension.

mark_h 12th December 2016 14:34

Depending on what you are doing like sachinbaan recommends. Create your own session. You can use the forms from tiitm0101m000, just give it your own name. Of course this would work best for display only. Otherwise look at ~vamsi's source code extender in the code and utilities session.


All times are GMT +2. The time now is 07:48.


vB.Sponsors
©2001-2017 - Baanboard.com - Baanforums.com