Home » Developer & Programmer » Forms » Update on database through forms compilation Error!
Update on database through forms compilation Error! [message #192685] Wed, 13 September 2006 04:43 Go to next message
Sharaf
Messages: 62
Registered: September 2005
Location: U.K
Member
Please I am trying to create an update button that will update a field when pressed I have the plsql code as shown below, the problem i have is, it is asking me to decalre the table first/datablock first.

Actually the datablock has another name in the database (Branch)but when i brought it into my form, i changed the name to ADD_NEW_BRANCH.

UPDATE ADD_NEW_BRANCH
SET BRANCH_NAME = :ADD_NEW_BRANCH.BRANCH_NAME
WHERE BRANCH_ID = :ADD_NEW_BRANCH.BRANCH_ID;
COMMIT;
MESSAGE('Record Successfully Updated.');
CLEAR_FORM;

error message
identifier 'ADD_NEW_BRANCH' must be declared.

please advise

[Updated on: Thu, 14 September 2006 21:24] by Moderator

Report message to a moderator

Re: Update on database through forms compilation Error! [message #192866 is a reply to message #192685] Thu, 14 September 2006 00:21 Go to previous message
sandeepk7
Messages: 137
Registered: September 2006
Senior Member

Use Original name as in Database

Sandy
Previous Topic: how to make a simple search engine???
Next Topic: Link between forms and reports
Goto Forum:
  


Current Time: Sun Dec 11 02:40:18 CST 2016

Total time taken to generate the page: 0.09946 seconds