1. Forum
  3. T24 Technical Discussions
  5. T24 Development & Customization
  7. LIST / SELECT - how to display the last multivale
× Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...

LIST / SELECT - how to display the last multivale

  • Tacka
  • Tacka's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
8 years 6 months ago #18138 by Tacka
LIST / SELECT - how to display the last multivale was created by Tacka
Hi,
need help..

My table has MV set :
Field AM is in MV set. But we could have 1 or N these multi sets

This works:
LIST F.NLB.RCG.DATA EVAL "AM<1,1>" EVAL "AM<1,2>" EVAL "AM<1,3>" EVAL "AM<1,4>" WITH EVAL "AM<1,2>" NE ''

What's the sintax to LIST only the last multivalue .. if I don't know how many MV sets are there ?

thx, from SLO

Please Log in or Create an account to join the conversation.

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • TAFj-R20 - 'unix'
More
8 years 6 months ago #18141 by jpb
Replied by jpb on topic LIST / SELECT - how to display the last multivale
You can use DCOUNT inside the EVAL, e.g.
... with EVAL"DCOUNT(AM,@VM);AM<1,@1>" NE ''
The following user(s) said Thank You: Tacka

Please Log in or Create an account to join the conversation.

  • Tacka
  • Tacka's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
8 years 6 months ago #18142 by Tacka
Replied by Tacka on topic LIST / SELECT - how to display the last multivalue
YES... works .. thx for quick reply..

have a nice day... night :)

Please Log in or Create an account to join the conversation.

More
1 year 11 months ago - 1 year 11 months ago #23689 by MAK_T24
Replied by MAK_T24 on topic LIST / SELECT - how to display the last multivalue
How to use below statement in SQL
LIST F.NLB.RCG.DATA EVAL "AM<1,1>" EVAL "AM<1,2>" EVAL "AM<1,3>" EVAL "AM<1,4>" WITH EVAL "AM<1,2>" NE ''

I want to use customer table in R17  to extract multivale for field REL.CUSTOMER  through DBtools SQL
Last edit: 1 year 11 months ago by MAK_T24.

Please Log in or Create an account to join the conversation.

  1. Forum
  3. T24 Technical Discussions
  5. T24 Development & Customization
  7. LIST / SELECT - how to display the last multivale
Time to create page: 0.109 seconds