the code's written in the pl/sql of menu item 'ENT_QRY' in the menu 'MYMENU'.
i want to disable this menu item when the system gets into the enter-query mode on clicking the menu item.
hi frends,
i've written this in the menu pl/sql
if NOT system.mode='eneter-query'
then
enter_query;
set_menu_item_property('mymenu.ent_qry',ENABLED,PROPERTY_FALSE);
end if;
but it's not working.
plz help me.
sorry dear frend DIMA
i couldn't stick to ur advice due to the problem that i ws wondering if not to write this DML, then how to update some data i'm looking at in my forms.
Hearty thanks for ur precious advices.
bye
Hi dear frends
i've written the sql update command on a button press trigger as
begin
update TNA
set shipdate = :shipdate , description = :description
where TNAID = :TNAID;
commit ;
end;
but when i do this it shows PK Uniqueness error. i.e. the form tries to resave it as...
i've tried editing FMRUSW.res file and to save it but can't either save the same file or save it to another location with different name.
key bindings.
hi frends plz help
i'm wondering on how to get started with oracle terminal , where to find the resource file thats currently being used by the oracle forms and that how can i modify it to get my required tasks done.
thanks in advance.
bye
sorry it'll b a great problem for me to having it reinstalled then restoring the data.
and the problem was not in the beginning but it has started behaving like this abt a week ago.
thanks for ur response.
any other suggestion plz.
hi frends,
both of these properties i.e. Deffered & Auto Query are set to 'NO' (default-I didn't change).
is it necessary to create relation even, when doing the job manually.
thanx
bye
hi dear frends,
plz help me resolving my problem.
problem is that,every next day when i try to connect to the DB through sql.the error Unable to connect to destination is returned . and on rebooting the system the problem gets solved .
plz tell me what might b the reason and suggest the...
...sql select statement on the mouse-doubleclick trigger. still i need the solution for the multi record block as this solution won't solve my problem in case of multi record block.
* and what r these DEFERRED_COORDINATION and AUTOQUERY
and where to look for these.
thanx & regards.
bye
hi dear dima.
i've to manually execute the query afterwards.
means the query doesn't get executed.
and also after i manually execute the query the forms ask for saving the values.
regards.
no dear ,problem is that it goes to that block, but the query doesn't show any results.
perhaps the fault is somewhere in executing query after copying the value into the item.
hi dear dima.
in all u r rite.
but there are some other things we don't know abt and we want them, then y not to try. as for cue cards , i've read these all but couldn't find demos etc any where plz tell me if u can find some site for the demos & built ins.
my detailed block has a no of...
hi dear frends,
i've two blocks named STYLES and SDETAILS both in the different canvases. where STYLES is a master block and
SDETAILS is detailed block.
now i want while entering the data or querying block
that on double clicking the STYLE_NO from styles the form
should move to the...
hi dima
thanks for ur reply. but thats what i already know and 2nd thing is i dont know how to use this tool.
so i'm looking for some pre builts for this purpose.
thanks
bye.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.