× 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
6 years 8 months ago #18138 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.

More
6 years 8 months ago #18141 by jpb
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
6 years 8 months ago #18142 by Tacka
YES... works .. thx for quick reply..

have a nice day... night :)

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

More
3 weeks 6 days ago - 3 weeks 6 days ago #23689 by MAK_T24
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: 3 weeks 6 days ago by MAK_T24.

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

Time to create page: 0.110 seconds