I want to a form 10g as image under. Now i want to when item pallet_serial has new information then automatic delivery that information to block under.Example, with this form, i want to deliver information about FROM_LOC, TO_LOC, SEAL_NO, CAR_NO, PALLET_SERIAL... into under block, and after that clear field PALLET_SERIAL for next time input.
View 1 Repliesi have multi data block filed. and checkbox field which based on control block...My task is when i check checkbox only one field should enabled and my mouse goes to that field
e.g
item11 item21 item31 chkbox1
item12 item22 item32 chkbox2
Scenario like this :
My item field based on data block and checkbox based on control block,while i checked chkbox1 , only item31 on that current record should be enabled and i changed value only on that field
when i checked chkbox1 , my cursor goes to item31...not item32
i have a master detail form, In Master block we have one field cheque amount and in Detail block we have field receiveable amount invoice wise. if company paid us a cheque amount we will enter this amount in Master block field Cheque amount and in detail block there will be invoice wise receivable amounts. i want to distribute the cheque amount in detail block invoice wise for example
Cheque amount in master block = 291
Invoice wise receiveable amount is as follows
Invoice No , receivable amount , Received amount
10, 196 , 0
20 , 95 , 0
30 , 54 , 0
Result should be as follows:
Invoice No , receivable amount , Received amount
10, 196, 196
20 , 95 , 95
30 , 54, 0
Received amount field should be distributed according to the receivable amount when recevied amount = cheque amount then remaining will be 0.
I have a multi record control block (basically a text item displaying 6 records) where user enters values and I want to process the values using pre-insert trigger.
I want to read value in each record and then do some tasks using a pre-insert trigger before I commit the values. To navigate between the records I was using first_record, next_record, clear_record built-ins but it gives errors like "40737-illegalrestricted procedure next_record in pre-insert trigger".
We are using Oracle Forms 6i and back-end as Oracle 10g Database. We are facing a specific problem while working with Forms6i. I am giving the steps as showm below:
1. We have a table named TEST (a number not null, b char(1) not null).
2. When we insert a record throuhg SQL*PLUS like this:
insert into test values (1, ' '). The record is inserted in the table TEST successfully.
3. We checked the length of column b i.e. select length(b) from test, it is showing 1. This is the correct value because it has inserted a space in column 'b' of the table TEST. (That's what we want).
4. We created a form having data-block from table TEST and trying to insert the same record throuhg Forms9i.
5. There it gives an error of "Unable to INSERT record" becuase in form builder, it is trimming the spaces for column 'b' automatically and making it NULL. Since the column 'b' defined as NOT NULL in table TEST, hence generating the error. (Basically there in form builder, it is generating ORA-01400 error which is can not insert NULL value in NOT NULL column).
We would like to know why in form builder, space is automatically being trimmed to NULL..? We do not want this to happen. We want space to be inserted as space only. How can i implement this case, becuase we need this kind of functionality in our form builder application.
I want if user is working on forms application which is build in forms 6i with oracle 10g database , as soon as time reached to 5PM it automatically log off. and won't allowed to log in after 5 PM. How to do that
View 9 Replies View RelatedHow Can We Get Hardware Information In Oracle forms 6i for example harddisk size,volume,processor etc.
View 1 Replies View RelatedI'm still trying to import some video in my form.
So far I made one OLE container and add Oracle Video Control, then I made one button and wrote this trigger:
WHEN-BUTTON-PRESSED
declare
video_obj ole2.obj_type;
begin
video_obj := forms_ole.get_interface_pointer
(`MY_VIDEO');ole2.invoke(video_obj,`ImportFileAs');
end;
This works fine. All I want to do now and I don't know why (because I am quite new in Oracle development) is, to make one trigger that will choose automaticly wich video to play and if it is possible to make when I start the form automaticaly to start that video, if not, it's enough just to choose video automaticaly when I press the button.
How could the lov restrict its list as the user types in values:
List:
Amanda
Leila
Leon
User types 'L'
List
Leila
Leon
User type
L+e
List
Leila
At the moment it works but the user has to click the button each time.
I have a four tab canvas. The first 3 tabs belong to one data block. The last tab has two data blocks.
How can I automatically commit changes if the user clicks on any tab and not necessarily in tab order?
how can i put button in a form to print the information i displayed in this form.
View 1 Replies View RelatedI have a trigger program to track updated information's on perks column. I am failing to finish systime in my trigger program.
SQL> desc user_track;
Name Null? Type
----------------------------------------- -------- ----------------------------
EID NUMBER
ENAME VARCHAR2(15)
OLD_PERKS NUMBER
NEW_PERKS NUMBER
UNAME VARCHAR2(15)
ACTION_DATE DATE
ACTION_TIME DATE
SQL> create or replace trigger tri_track
2 After UPDATE ON EMP
3 FOR EACH ROW
4 BEGIN
5 insert into user_track(EID,ENAME,OLD_PERKS,NEW_PERKS ,UNAME,ACTION_DATE,ACTION_TME) values
6 (:old.eid, :old.ename , :old.perks, :new.perks,user, sysdate, to_char(sysdate , 'HH24:MI:SS')
7 from dual;
8 end;
9 /
Warning: Trigger created with compilation errors.
SQL> show errors;
Errors for TRIGGER TRI_TRACK:
LINE/COL ERROR
-------- -----------------------------------------------------------------
2/1 PL/SQL: SQL Statement ignored
3/95 PL/SQL: ORA-00917: missing comma
I have made an application in forms 6i. Now i want if user can update, or modify the data it will required automatic authentication. Administrator will gives his password then the updation will continue otherwise rollback the transaction.
View 1 Replies View Related I want to make an Information System of Subjects and its corresponding sections.Below is my desired output:
+ Sections
- Section 1
- Advanced Algebra
- Physics
- Section 2
[code]...
I wanna do it in a hierarchical tree, since I don't know how to do it,
I am creating a form with 3 blocks.
Control block,
Header Block,
Detail Block.
First i have entered a record in the control block.
Then i navigate to header block,entered the first record for Header Block.
Then i navigate to Detail block,entered the first record for detail Block.
then i again navigate to Header Block..
Now the Problem comes....As i am Trying to enter second record for header block,the pop up comes as "Do you want to save the changes".
Condition 1:i dont want that message to appear for every header record i enter.
Condition 2:For every header record i enter,Corresponding detail record would have been entered.i want that detail records to be retained if i am clicking that header record as i have already created relationship for both header block and detail block.
I created one table with out primary key like well_1 .in that table have have more than 30 columns.
SQL> select uwi,analysis_obs_no,fluid_type,top,base,date_sampled from well_1
2 where uwi ='1000 and base =2871.5;
UWI obs_NO F TOP BASE
---------------- ---- ------ ----- - -----------------------------
1000 1 G 2870.5 2871.5
1000 3 G 2516 2871.5
1000 4 G 2870.5 2871.5
1000 2 G 2870.5 2871.5
1000 6 G 2516 2871.5
1000 5 G 2516 2871.5
1000 7 G 2516 2871.5
1000 1 L 2516 2871.5
1000 2 L 2516 2871.5
7 rows selected.
i did code like this in from in search panel. in taht form i will enter uwi and base values and iwill click search button.then it will display all record values in master block .after taht i will click next button then it will display next values(all values).
i am getting all values (1 G to 7 G values).but iam not getting last 2 records when i click next button (1 L to 2 L values ).
next button
select analysis_obs_no,fluid_type
into :ctrl1.OBS_NO,:ctrl1.fluid_type
from well_gas_anal
where analysis_obs_no =(select min(analysis_obs_no)
from well_gas_anal
[code].....
i tried in SQL*PLUS like this :
select rowid,analysis_obs_no,fluid_type,rownum
2 from well_gas_anal
3 where rowid=(select min(rowid)
4 from well_gas_anal
5 where analysis_obs_no > &a
6 and uwi ='1000' and base =2871.5 )
7 and uwi ='1000' and base =2871.5
8* and fluid_type is not null
SQL> /
I have a main interface that contains 3 buttons (emp, dept, mgr) I want when I click on the button 'emp' interface opens in the main interface(the buttons must remain in the main interface)
see the picture : [URL]
I have form same picture under, and i would delete record already checked on tabular when click button DELETE .
View 5 Replies View RelatedI have 3 tables
1-pr_mst
2-pr_trn
3-hr_mst
Em_code is a common key between theses tables.
on my form table 1 and 2 are the base main tables, due to the relationship, when i enter em_code on table 1 and query it, it shows data on both the table. Its a normal behavior in Master Detail block in forms.
When user enter em_code at form and there is no data found in table 2, obviously it show blank data block related to the table 2 and shows data in table 1 block, now i want an em_code details which stores in the table 3 automatically load in memory and populated in detail block. Is it possible ? and how can i do this.
In a Entry Screen I Require to Check the Value is Changed or not in a Block (A).
If the Value is Changed then Require to done some validation in another block (B) for take the final entry date and their after going to another Block (C), here user require to enter Some data in it.
I am Using the When Timer Expired in the Block (A) for Check the Value and Going Another block, it working till going another after complete the entry Block (C) I have using a Button for move to Main Block (A), but it not going to the consign block and then i put the Message in it, the message is showing, but not going to the block.
i have an error with block corruption
Error: Corrupt block relative dba: 0x01c12a58 (file 7, block 76376)
What all the ,methods I can go for if we are working on a production environment with out any down time.
I can go for dbms repair package and restore and recover
I have a list block of two fields item_name, item_price. User can enter as many item`s as she/he wants. But, before saving the record system should calculate the total and give error if sum is grater then or less than 100.
View 2 Replies View RelatedI have an existing form which i need to customize..In the form in the query block whatever strings we enter..and press the search button..it sets the where clause and use execute query.which populates the detail block which is read only and only 1 column is enabled.
For the Enabled column X I need to enable a button.It has to be done only if the cursor go in the column X
I have 2 blocks named emp,emp1 those are DB's Blocks and empno, ename, sal in EMP block and sal, sum(sal) are in EMP1 block, i set the property for sum is summarized block is: EMP1 and item is SAL, i want display sum(sal), but not display when i click execute query.
View 5 Replies View RelatedI have 2 blocks, MASTER and DETAIL. The navigation style of MASTER is Change Data Block, and its next navigation data block is DETAIL. But despite this, when I tab out of the last item of MASTER, it goes back to the first item of MASTER instead of going to DETAIL.
View 8 Replies View RelatedI want to give update rights of a block to restricted set of people... how can i achieve it???
View 3 Replies View RelatedI've a master detail form. I detail form there is no primary key. When it is executed the following error displayed :
FRM-30100: Block must have at least one primary key item.
Block: ASSETS_ISSUE_DTL
Form: FORM_ASSETS_ISSUE_DTL
TABLE_FROM_BLOCK built-in Package is working in Forms 6i but not in Forms 10g. is there any other built -in available instead of this. how do we populate table from a block in Forms 10g?
View 6 Replies View RelatedWhen I execute my form, on pressing key F5 it displays the all available block names in the form. I want to restrict this.
View 5 Replies View Relatedi have created on query block , upon pressing the button there is a wehre clause in the block which will filter the records based on all alike items from two tables but my problem is , in one table there is no information of struct and in other there is struct information or data, what i want is even if i pass a parameter in the where clause all the records should be filtered.
CREATE TABLE OT_ACTUAL_ACT (ITEM_CODE VARCHAR2(30),ITEM_NAME VARCHAR2(30),WO VARCHAR2(12),STRUCT VARCHAR2(12))
INSERT INTO OT_ACTUAL_ACT(ITEM_CODE,ITEM_NAME,WO,STRUCT)
VALUES ('1001','HEA100X10','300',null);
[Code]...
I am getting this
ITEM_CODEITEM_NAMEWOSTRUCT
1002 HEA100X2230030010
i want all the records
ITEM_CODEITEM_NAMEWOSTRUCT
1002 HEA100X2230030010
1003 HEA100 300
1001 HEA100X10 300