04-04-2006 8:17 PM
Hello all,
I am facing a strange problem here with a maintenance view.
I had created a maintenance view over one table which is mainly used for creating entries in to that table.
It was working great since couple of months and all of a sudden it started giving the error message everytime somebosy tries to add an entry into the table using this view.
<u>The error it gives is:</u>
<i><b>Specify the key within the work area
Message no. SV 033
Diagnosis
You have attempted to create an entry whose key is not in the range defined for this area.
System Response
The entry cannot be created.
Procedure
Please check your entry.</b></i>
Does it has anything to do with the number ranges for the keyfields. I had checked the number ranges..they look good.
Please help.
Thanks
Message was edited by: Naren Somen
04-04-2006 8:22 PM
Hi Naren,
You might also get this error if the values given for the key fields are not in the Value table/Check table, Domain etc..
Regards,
Suresh Datti
04-04-2006 8:57 PM
Suresh,
There is no value table/domain values for any of those key fields. Any value can be entered.
I couldn't figure out why the problem has occured so far...but I had solved the problem by removing the selection conditions from the view.
In the selection conditions tab of the view...I passed a condition like this
ztable-field1 eq 99999.
I removed it and it started working fine. Only records which satisfied the above selection condition will/should be displayed but it should not restrict us in creating any entries with doesnt satisfy that selection condition. Am I true??
Please suggest.
Thanks,
10-26-2006 10:38 AM
Hi somen,
This is ravi ganji ..i too got the same requirement wherein i need to create a zprog so that it shld call the view v_rf07 and here the user enters the table values and the values shld be updated in the table rf07..and if any duplicate entries found then i need to display a popup message..
cld u plz help me out how to proceed ....
really appreciated with points ...awaiting for u r reply..kindly send the information to my maid id ravi.v.ganji@gsk.com
Regards,
Ravi Ganji