Home > Default > Problem of LOV, Datatype Problem

Problem of LOV, Datatype Problem

November 30Hits:0
Advertisement
hi experts
When i applied an LOV on Supplier ID field which is foreign key, i am getting this error please see the Snapshot of form.
http://1.bp.blogspot.com/-JsNiNnjdoyg/T5KGcPpzlCI/AAAAAAAAAOk/a51eItBrDWM/s1600/Capture-1.PNG
Datatype of supplierID in Child Table is Integer while in parent table it is type of DBSequence. I have also apply sequence in database.
One Very Important thing is that i am using lot of LOVs in My project but i am not getting this type of error in any LOV. I am using same techniques in other LOVs. I have not any
problem in database.
Please help me to solve this problem.
Thanks.........Regards
Muhammad Nasir

Answers

In Record group of second LOV(EMPLOYEES) insert where-clause like:
where emp.DEPTNO = :DEPTNO_you get_from_first_lov
P.S. Please, do better if you write in lowercase, It would be more readable

Read other 2 answers

Tags:

Related Articles

  • Problem on CLOB datatype after importOctober 11

    I got problem and call to Oracle support and they use DUL for extract data from datafile to dump file and I import everything is done and no error but when I check in CLOB datatype that have space(blank character) separate each character see below Or

  • Problem with DATATYPES, in a UNIONOctober 11

    Hello, I m trying to disply a custom message when no data found using the below structure. Unfortunately I ve got a problem with the datatypes I m trying to union I ve tried various datatypes in the 2nd SELECT but the problem remain. Please help. SEL

  • Problem in execution of a function having clob datatypeOctober 11

    [http://www.orafaq.com/forum/t/128331/98870/] Hi, I had a Problem in executing a function having clob datatype. Here below is my function. create or replace type split_obj as object     occurence_id number(10,0),     splitvalue varchar2(1000) create

  • Problem in reading Text (DataType) field.October 11

    Hi Its j2sdk1.4.2_05, Tomcat 5.0, and MS SQL server 2000. My clients requirement is to store bulk text data into database. I created a table with one field of text datatype, I am unable to read the value in the field. If I change the field datatype t

  • Problem with special chars in BLOB datatype using contains keywordOctober 11

    Facing problem, when part searching with special chars in BLOB datatype. It is considering the non alpha-numeric chars as a separtor in a provided string EX: SELECT * FROM RESUME_TEST P,grst_candidate d WHERE d.candidate_id = p.candidate_id AND CONTA

  • Problems with datatypes while callling MS-SQL stored procedureOctober 11

    Hi     We have a stored procedure in MS-SQL server ( Sql Server 2000 ) that we are invoking from XI 3. ( SP18) using a receiver adapter communication channel . One of the parameters of the stored procedure has a decimal data type . In XI design time

  • A problem with inconsistent datatypesOctober 11

    Whenever I try inserting a new record of type t_cliente_societa in my Cliente table, I get ORA-00932 inconsistent datatypes error and I'm not able to find the reason. Could anyone help me? Thanks in advance. I'll post my SQL code here. please ignore

  • VERY URGENT: problem in sql query with long datatype in weblogicNovember 30

    I have a problem while tryind to retrieve a column value with a long datatype using servlet and oci driver and the server is weblogic5.1 .I have used prepared statement the problem comes in the preparedStatement.executeQuery(). The sql Query is simpl

  • Problem finding out datatype for jdbc scenarioNovember 30

    Hi all, Here is my scenario. JDBC(oracle)->FILE I have a database table orders in oracle with three fields id,name,num. I want to select this table values and map to a different format and send it to a file system. Can anyone tell me what should be t

  • Datatype mapping problemNovember 30

    Hi I've have a table with column with int4[] as data type. I have a problem with setting the type of corresponding entity bean field. I still have a message about not proper datatypes - byte array instead of integer[]. To be precise, message is: java

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.826 s.