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?
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?
CODE
As for the parameter, there's a routine called UPCASE:
CODE
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 = 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?
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?
Click on HELP.