Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 26th November 2003, 17:54
bklunder's Avatar
bklunder bklunder is offline
Junior Member
 
Join Date: Jan 2002
Location: Ontario, Canada
Posts: 16
bklunder is on a distinguished road
Baan: 4C4 - DB: Oracle - OS: WIN 2003
Zoom Session for selection

I have been asked to create some sessions to aid our users in scheduling holidays. One of the requirements is to be able to print a calendar for a number of departments showing who will be off.

The problem I am having is with my zoom session for the print holiday calendar session. All I want this zoom session to do is display all of my departments, and a check box beside each one so that the person running the report can select various departments. I have a list of departments on my display session (just a multi-occurrence form field on a display session) and I have my check boxes (also a multi-occurrence form field). I can select all the departments I want but when I scroll up or down I loose all of my selections.

Has anyone ever created a session like this and have it working? and if so How?

Thanks
Reply With Quote
Sponsored Links
  #2  
Old 27th November 2003, 08:25
Hitesh Shah's Avatar
Hitesh Shah Hitesh Shah is offline
Guru
 
Join Date: Nov 2001
Location: Mumbai,India
Posts: 1,855
Hitesh Shah is on a distinguished road
Baan: triton,Baan IVc4 , ERP Ln - DB: Oracle/Bisam/SQL 2000/SQL 2005 - OS: Sun Solaris/Windows 2003
multiple selections

We have worked with this in many cases. This is a typical case when specific selections are required and from-to selection are not what we require.

For this purpose we have created a single temporary table (tijwx921) wherein all specific selection can be stored user wise . And the application program uses this specific table to carry out it's logic. The same table can accomodate multiple selections many criteria (like project, production order etc) for many people at a time.

In the zoom display session you have to write following code
1.before.display of check box field to get the selected value from temporary table (ie tijwx921)
2.when.field.changes of the check box field to insert / delete values from temporary table
3. before.program to delete specific selection of the user from the temporary table.

And ur print logic should use such temporary table for this purpose.

Code:
Table tijwx921
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Field Name     | Description                    | Domain          | Datatype   | Length |  Physic.| Mand. | Acti  | Refer.   | Ref.         | Ref.Cntr| Ref.Contr. | Initial Value
               |                                |                 |            |        |  length |       |       | Table    | Mode         | Update  | Delete     |
---------------+--------------------------------+-----------------+------------+--------+---------+-------+-------+----------+--------------+---------+------------+----------------
  1  user      | User Name                      | tdstr15         | String     |  15    |      15 | No    | Yes   |          |              |         |            |
  2  item      | Item                           | tcitem          | String     |  16    |      16 | No    | Yes   |          |              |         |            |
  3  cprj      | Project                        | tccprj          | String     |   6    |       6 | No    | Yes   |          |              |         |            |
  4  pdno      | Prodn.Order                    | tcpdno          | Long       |   6    |       4 | No    | Yes   |          |              |         |            |
  5  orno      | Sales Order                    | tcorno          | Long       |   6    |       4 | No    | Yes   |          |              |         |            |
  6  srno      | Serial No.                     | tcspos          | Long       |   3    |       4 | No    | Yes   |          |              |         |            |
  7  cdis      | Reason                         | tccdis          | String     |   3    |       3 | No    | Yes   |          |              |         |            |
  8  recd      | Reason for Inv.Adj.            | tdinv.recd      | String     |   3    |       3 | No    | Yes   |          |              |         |            |
  9  shno      | Shipment No.                   | tcorno          | Long       |   6    |       4 | No    | Yes   |          |              |         |            |
 10  dept      | Department No.                 | tccwoc          | String     |   3    |       3 | No    | Yes   |          |              |         |            |
 11  cuno      | Customer No.                   | tccuno          | String     |   6    |       6 | No    | Yes   |          |              |         |            |
 13  cupo      | Cupo                           | tcstr30         | String     |  30    |      30 | No    | Yes   |          |              |         |            |
 14  jnos      | Style No.                      | tcstr8          | String     |   8    |       8 | No    | Yes   |          |              |         |            |
                                                                                            -----
                                                                             Record Length:   106

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Index| Description                                                  |                                              Index Parts                                     | Dupl  | Active
      |                                                              | 1        2        3        4        5        6        7        8        9        10          |       |
------+--------------------------------------------------------------+----------------------------------------------------------------------------------------------+-------+-------
  1   | User + Serial Number                                         | user     srno                                                                                | No    | Yes
  2   | User + Project                                               | user     cprj                                                                                | Yes   | Yes
  3   | User + Prodn.order                                           | user     pdno                                                                                | Yes   | Yes
  4   | User + Sales Order                                           | user     orno                                                                                | Yes   | Yes
  5   | User + Item                                                  | user     item                                                                                | Yes   | Yes
  6   | User + Reason                                                | user     cdis                                                                                | Yes   | Yes
  7   | User + Reason for Inv. Adj.                                  | user     recd                                                                                | Yes   | Yes
  8   | User + Shipment No                                           | user     shno                                                                                | Yes   | Yes
  9   | User + Department No.                                        | user     dept                                                                                | Yes   | Yes
 10   | User + Customer No.                                          | user     cuno                                                                                | Yes   | Yes
 11   | User + cupo                                                  | user     cupo                                                                                | Yes   | Yes
 12   | User + Style No                                              | user     jnos                                                                                | Yes   | Yes
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Zoom to Session from Main Session ltannous Tools Development 5 2nd November 2004 11:49
zoom to item session monica1 Tools Development 11 28th September 2004 12:56
zoom to different session trchandra Tools Development 2 19th March 2002 04:58
Opening zoom session E.Toniolo Tools Development 6 21st February 2002 22:02


All times are GMT +2. The time now is 01:22.


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