Re: Forms 3.0 Questions.

In article <2Jw4oc1w165w_at_vicuna.ocunix.on.ca>, frampton_at_vicuna.ocunix.on.ca (Steve Frampton) writes:

<< message not copied... >>

The response already present shows a correct answer, if not the reason that it works. Basically, you can have only one INTO clause in your select statement; if you have two (or more) values in your pseudo list-of-values select statment, only put an INTO clause in your first and you should be fine. Note that you are using system resources that each time you execute this list though, so if you have a large number of users you might want to consider the benefits of having a simple Yes/No value coded in such a fashion.

As a suggestion for your second question, you might consider using the Forms trigger SET_FIELD command. You can turn a field's visible attribute ON after filling the field with your message, then turn it off again after the user fixes the problem and exits the field. Note that you would still have to reserve space for the message field on the screen, so you would have some holes that you could not use for other purposes. I've used the SET_FIELD command quite successfully in a number of different situations (if not this one, exactly).

Hope that helps!

Dave Rathbun (DRATHBUN_at_AOL.COM) Received on Sun Jul 10 1994 - 06:21:01 CEST