Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

At 15 FEB 2012 09:06:01PM Jim Vaughan wrote:

Popup() function

Pop_Def<PMODE$> = 'L'

To select which records are displayed

Pop_Def<PDISPLAY$> = "WITH CONTRACT EQ '":Contract_Id:"' BY ID"

The above works, what is the format for the PDISPLAY$ parameter if I want to select by two criteria?

Pop_Def<PDISPLAY$> = "WITH JOB EQ '":Job_Id:" AND WITH CONTRACT EQ '":Contract_Id:"' BY ID"

The above does not.

What is the correct format for this rlist type statement?


At 15 FEB 2012 09:11PM Jim Vaughan wrote:

Never-mind I am an idiot, missing a quote

Pop_Def<PDISPLAY$> = "WITH JOB EQ '":Job_Id:"' AND WITH CONTRACT EQ '":Contract_Id:"' BY ID"

Jim R Vaughan

www.waterloo-software.com


At 16 FEB 2012 05:42PM Barry Stevens wrote:

See what a few beers does!


At 16 FEB 2012 07:21PM Dave Harmacek wrote:

Yeah, even after all this time, I recently missed a : (concatenation) and became a casualty of the old "implied formatting" of Arev.

A = "this is ": "it"

A is "this is it"

with implied formatting

A = "this is" "it"

A is "this is"

Dave Harmacek

Harmacek Database Systems

View this thread on the Works forum...

  • third_party_content/community/commentary/forums_works/f54769df0004a3761a28a6000.txt
  • Last modified: 2023/12/30 11:57
  • by 127.0.0.1