one to many, how to select specific record?

[jackyzsn]

Another Q. I need to joint two table together. It's one to multiple situation. I need to select one record based on some criteria, say for example, based on an effective day would be one to one, how could I do that?

Another one, I need to accept PARM from client input, I need to format the client input for example change the input to upper case so I can use it for selection criteria?

 

[focwizard]

A one-to-many JOIN is done with the 'ALL' or 'MULTIPLE keyword:

JOIN from_field IN host TO [b]ALL[/b] to_field IN target AS join_name

As for the parameter, there's a routine called UPCASE:

UPCASE(length,input,outfield/format)

Since you'll be doing it in Dialogue Manager, you have to be creative (if you don't have a fixed length variable), and do it something like this (assuming your variable is called &A):

-SET &UA = UPCASE(&A.LENGTH,&A,'A100');
-SET &UA = TRUNCATE(&UA);

The first set gives you a 100 character output (assume that's the maximum length. the second set drops trailing blanks.

 

[jackyzsn]

Works great!!

Where can I find a list of function I can use in webfocus, like the TRUNCATE? I'm using webfocus 7.1.

 

[jimster06]

You should have access to online documentation with your WF install.
Click on HELP.