OraFAQ Forum: Forms » error while updating and deleting

Home » Developer & Programmer » Forms » error while updating and deleting

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

error while updating and deleting [message #84982]

Mon, 17 May 2004 08:52

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,

Report message to a moderator

Re: error while updating and deleting [message #85050 is a reply to message #84982]

Tue, 25 May 2004 02:01

Anupam
Messages: 62
Registered: July 2001

Member

A fatal error occurred while trying to insert a record. The table associated with the current block of the form might not exist, your username might not have authority to perform the specified action on the table, or some other reason might have caused the fatal error.

Report message to a moderator

Previous Topic:	Commit. On update
Next Topic:	Calling Query builder in forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 01 17:50:20 CDT 2024