Re: [ORACLE FORMS] PRE-BLOCK

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sat, 23 Apr 2005 10:37:17 -0700
Message-ID: <1114277599.793465@yasure>

Bartosz wrote:
> DA Morgan napisał(a):
>

>> Bartosz wrote:
>>
>>> DA Morgan napisał(a):
>>> DO you know what might be wrong?
>>>
>>>> Don't know what version you have or how you are trying to implement
>>>> whatever it is you are doing: So no.
>>>>
>>>> Does it cost you more to post the trigger?  ;-)
>>>
>>>
>>>
>>> It is in the PRE-BLOCK trigger and both oracle database and developer 
>>> suite are the latest available for 9i from Oracle website.
>>
>> Seriously ... if you are not willing to getting a solution to the
>> problem ... don't expect anyone here to donate their time to help
>> you. I've done all the dragging and pulling I can.

>
>
> I am sorry I am new in oracle databases. The database version is
> 9.2.0.1.0 and the oracle forms is 9.0.2.9.0. And when it comes to the
> code it would be impossible because there is none. I made a data block
> with a tabular view. When you start the application there is nothing in
> the fields to have it I have to choose execute_query from menu. I wanted
> that to be automatic and to have all the fields filled with data from
> the database that's why I've placed just one instruction in the
> Pre-block trigger and the instruction is Execute_query but I just get
> restricted procedure error. I have very limited access to the books on
> Oracle forms in my country and on the Internet I can find very little.
> I've seen that working but than the database was oracle 8 something.
>
> That is all I can tell you about my problem I would be very grateful if
> you could help me solve it or give me some instructions what to do in
> order to provide information needed to solve the problem.

Thanks for getting the version numbers. Now for the next step ... you have made reference to the PRE-BLOCK trigger. My assumption, and I think a reasonable one, is that you put code there to try to pre-populate one or more text items in the block. Since you say there is no code, and I can't see it even if it exists, let me suggest the following which is how I do it.

Use SET_ITEM_PROPERTY and do so WHEN_NEW_BLOCK_INSTANCE, WHEN_NEW_ITEM_INSTANCE, or WHEN_NEW_RECORD_INSTANCE depending on which does what you need.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Sat Apr 23 2005 - 12:37:17 CDT