| error while updating and deleting [message #84983] |
Mon, 17 May 2004 08:53  |
John Donson
Messages: 2
Registered: May 2004
|
Junior Member |
|
|
Hi,
I'm trying to update a record in my database, but I get the same error all the time: FRM-40508 Oracle error : unable to INSERT record. The code I've written behind the update button is
UPDATE Bezoekregeling
SET AanvraagType = :ZOEKBEZOEKREGELING.AanvraagType,
BezoekDatum = :ZOEKBEZOEKREGELING.BezoekDatum,
BezoekBegin = :ZOEKBEZOEKREGELING.BezoekBegin,
BezoekEinde = :ZOEKBEZOEKREGELING.BezoekEinde,
GedNr = :ZOEKBEZOEKREGELING.GedNr,
BezNaam1 = :ZOEKBEZOEKREGELING.BezNaam1,
BezNaam2 = :ZOEKBEZOEKREGELING.BezNaam2,
BezNaam3 = :ZOEKBEZOEKREGELING.BezNaam3
WHERE AanvraagNr = :ZOEKBEZOEKREGELING.AanvraagNr;
COMMIT;
I get the same message when I try to delete a record. The code behind that button is
DELETE FROM Bezoekregeling
WHERE Aanvraagnr = :BEZOEKREGELING.Aanvraagnr;
COMMIT;
Could anyone tell me why I can't update or delete my record?
Thanks in advance,
|
|
|
|
| Re: error while updating and deleting [message #84985 is a reply to message #84983] |
Mon, 17 May 2004 22:14  |
Gagarin
Messages: 1
Registered: May 2004
|
Junior Member |
|
|
Try this. You'll get more detailed desciption:
begin
DELETE FROM Bezoekregeling
WHERE Aanvraagnr = :BEZOEKREGELING.Aanvraagnr;
COMMIT;
message('Done', ACKNOWLEDGE);
exception
when others then
message(sqlerrm, ACKNOWLEDGE);
end;
|
|
|
|
| Re: error while updating and deleting [message #84986 is a reply to message #84983] |
Mon, 17 May 2004 23:06 |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
Check your Block's Insert & Delete Allowed properties.
they must be set to YES & should not be Set to NO programatically in any of the Triggers.
Apart from this at Database level you should have Delete & Update previleges on the Tables involved.
Regards
Himanshu
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
