Home » Developer & Programmer » Forms » Query regarding a error
Query regarding a error [message #217222] Thu, 01 February 2007 04:12 Go to next message
romi
Messages: 67
Registered: October 2006
Member
Hello all,

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,

update pw(table name)

SET password(column name) = :changepw(datablock_name).text4(text_name)
WHERE name(column name) = :changepw(datablock_name).text6(text_name);
COMMIT;
MESSAGE('Record Successfully updated.');
CLEAR_FORM;

error message
identifier 'ADD_NEW_BRANCH' must be declared.

please advise me and also i want to use a link at the place of button.how can i do it.Plz advice me

Thanks.
Re: Query regarding a error [message #217233 is a reply to message #217222] Thu, 01 February 2007 04:45 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This code has nothing to do with the error - there's no 'add_new_branch' here. Search through all PL/SQL units to find it and see what it does there (probably should be renamed or removed).
Re: Query regarding a error [message #217235 is a reply to message #217222] Thu, 01 February 2007 04:51 Go to previous messageGo to next message
romi
Messages: 67
Registered: October 2006
Member

Thanks Littlefoot,

It's giving this error, where pw is my table name.

error message
identifier 'pw' must be declared.

Re: Query regarding a error [message #217242 is a reply to message #217235] Thu, 01 February 2007 05:31 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Don't post pseudocode - show us your exact query. This might give us an idea what might be wrong. Without it, I can only say "declare identifier PW before compiling this program unit".
Previous Topic: Possible to override Forms commit behaviour?
Next Topic: Form Query output to Excel ?
Goto Forum:
  


Current Time: Sun Dec 04 14:59:10 CST 2016

Total time taken to generate the page: 0.11921 seconds