FRM 40507 : UNABLE TO FETCH NEXT QUERY RECORD ?? [message #260480] |
Mon, 20 August 2007 01:54 |
jhedspig
Messages: 2 Registered: August 2007 Location: pune
|
Junior Member |
|
|
I am working on forms/oracle 10G
there is this form which has a Combo Box list item.
data in this list is fetched from a table 'A'.
while saving data the value in the list item is saved in
another table 'B'
Now when i try to query the form using F11 and Ctrl + F11
it gives me an error :
FRM: frm 40507 UNABLE TO FETCH NEXT QUERY RECORD
Details of the FORM :
a) there is only one table
b) we are using 2 datablocks . parent and child. This is because the child is
displaying about 5 records. No parent child relation is set in the datablocks yet or in the table. can we do this in a single table ?
c) now the user shall select a value from the activity list ( combo box ) . The date and time are auto populated in when new form instance. User then enters data for the child records and clicks save.
d) data is save correctly.
e) but while querying data that is saved it errors out saying that : FRM 40507 Unable to fetch next query record
Will we have to define a parent child relation in the single table or in the datablocks ?
i m really confused ??
please guide what cn be done ...
Regards
[Updated on: Mon, 20 August 2007 07:22] Report message to a moderator
|
|
|
|
|