Template:AskPlus E.8.4.3

From Vital Soft Wiki
Jump to: navigation, search

Enhancements:

The AskPlus selection has been modified to support the concept of an OUTER join. When using the selection OUTER keyword, AskPlus will no longer drop any primary set records when no secondary set records are retrieved.

Selection Syntax Using Outer: 

 FIND PRIMARY=LOAN-FILE;OUTSEL=(@)
 OUTER
 (LOAN-FILE.BALANCE > 0 AND LOAN-FILE.REST-FLAG-11 <> 80 AND
  LOAN-FILE.SUFFIX = VEHICLE-INFO.SUFFIX)
  • In previous versions of AskPlus, only loans with matching VEHICLE-INFO records would be selected
  • In E.8.4.3 when using the OUTER keyword, all open loans with a balance greater than zero will be selected.
  • Vehicle information will be available for loans with a matching suffix, but no loans will be dropped if no vehicle-info record is found.
  • The OUTER keyword is required, and is not the default.

Watch video sample.

Retrieved from "https://wiki.vital-soft.com/index.php?title=Template:AskPlus_E.8.4.3&oldid=2683"