Re: List Item (drop down menu) problems...please help - searchform.jpg (0/1)

[Quoted] Thanx for the advice Vanessa...I'm gonna give this a shot...May I contact you by [Quoted] email if I'm experiencing other problems?

Sincerely,
Maarten

>Hi Maarten,
>
>What you need to do is set the update and insert properties of the block to
>false (to prevent records being altered or inserted).
>
>You should add a trigger at form level WHEN-NEW-FORM-INSTANCE which has the
>command 'enter_query;'. This will put the form into enter query mode
>everytime the form is opened.
>
>The user can then select a student name from the pull down item and then
>press F8 to execute query.
>
>Once the record has been retrieved the user will have to press F8 to clear
>the form and put it back into enter query mode, or you could place the form
>in enter query mode by placing a trigger on a button, that is a
>WHEN-BUTTON-PRESSED trigger on a button with the command 'enter_query;'.
>
>I hope this helps.
>
>Vanessa.
>
>"Maarten Martens" <maarten.martens_at_freebel.net> wrote in message
>news:tj7u6t0tulo66johj8gr9luiutop1fqsua_at_4ax.com...
>> Hello,
>>
>> I'm a beginner in oracle and have a question. I'm working on this little
>> project...
>>
>> Is it possible when running a form to switch it automaticaly into "enter
 query
>> mode" (without pressing F7) so that the data of the DB couldn't get
 altered? I
>> included a little jpg, to give you people an idea. What I would like to do
 is
>> when I run this form, and choose a student name from the drop down item
 (search
>> student), all the other fields are filled automaticaly with the correct
 data
>> from the tables of my DB...But without changing any records on DB level
 (only on
>> form level). Is this possible? How?
>>
>> I hope any of this makes sense to you people...
>>
>> Are there any good oracle sites on the net? With info on list items and
 field
>> connections and so on...
>>
>> Thanx in advance
>> Maarten
>>
>
  Received on Wed Jan 24 2001 - 23:20:40 CET