×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

one to many, how to select specific record?

one to many, how to select specific record?

one to many, how to select specific record?

(OP)
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?

RE: one to many, how to select specific record?

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

CODE

JOIN from_field IN host TO ALL to_field IN target AS join_name

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

CODE

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):

CODE

-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.

RE: one to many, how to select specific record?

(OP)
Works great!!

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

RE: one to many, how to select specific record?

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close