| Update on database through forms compilation Error! [message #192685] |
Wed, 13 September 2006 04:43  |
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
