Home » Developer & Programmer » Forms » Ask For Forms_ddl
icon7.gif  Ask For Forms_ddl [message #260888] Tue, 21 August 2007 03:36 Go to next message
oracle10g
Messages: 4
Registered: August 2007
Junior Member
Hi All
this a first one ask in this site
i hope i find the answer for my question

i need to write a update statement but the table name is variable
i used the forms_ddl statement and it is return succeded_forms is true
but the update not done
how can do it please help me asap

thank
Re: Ask For Forms_ddl [message #260894 is a reply to message #260888] Tue, 21 August 2007 03:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Welcome.
There are many forums there.
Please check the one that fit your question.
If it is a Forms question, then post it in Forms forum.

In addition, many forums have sticky at their bottom, please read and follow them.

Regards
Michel
Re: Ask For Forms_ddl [message #260904 is a reply to message #260894] Tue, 21 August 2007 04:21 Go to previous messageGo to next message
oracle10g
Messages: 4
Registered: August 2007
Junior Member
thanks for ur replay
but iam read all questions and answers
but no one maches with my question
i will write the code

forms_ddl('Begin update '||:TRANS_MASTER_V.table_name||
' set RECONCIL=''Y''
where coid=:GLOBAL.G_CO_CODE
and bankid=:global.BANKID
and jvid=:TRANS_MASTER_V.jvid;');
why it cannot do update

Thanks For ur Efforts
Re: Ask For Forms_ddl [message #260906 is a reply to message #260894] Tue, 21 August 2007 04:24 Go to previous messageGo to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
did u commiti.e
forms_ddl('standard.commit');
after the update
post your code i here
Re: Ask For Forms_ddl [message #260922 is a reply to message #260906] Tue, 21 August 2007 04:56 Go to previous messageGo to next message
oracle10g
Messages: 4
Registered: August 2007
Junior Member
i do the commit
and ask the IF NOT FORM_SUCCESS THEN
the answer true
but no update are made

thanks
Re: Ask For Forms_ddl [message #261102 is a reply to message #260922] Tue, 21 August 2007 18:56 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I searched this site for 'forms_ddl FORM_SUCCESS' and found http://www.orafaq.com/forum/m/198609/67467/?srch=forms_ddl+FORM_SUCCESS#msg_198609 and http://www.orafaq.com/forum/m/164549/67467/?srch=forms_ddl+FORM_SUCCESS#msg_164549

Please post ALL the code that you are running, not just the fragment that you listed previously. Also, post it within 'code' tags please.

David
Re: Ask For Forms_ddl [message #261199 is a reply to message #261102] Wed, 22 August 2007 02:30 Go to previous messageGo to next message
oracle10g
Messages: 4
Registered: August 2007
Junior Member
thanks for ur effort with me

this code i was write it in when buttem Pressed tregier
forms_ddl('Begin update '||:TRANS_MASTER_V.table_name||
' set RECONCIL=''Y'' 
where coid=:GLOBAL.G_CO_CODE
and bankid=:global.BANKID
and jvid=:TRANS_MASTER_V.jvid; End ;');

forms_ddl('Commit');
IF NOT form_success THEN
   message('Not Commit');
else
message('Commit Succeeded! ');
end if;


Upd-mod: What part of 'use code tags' is so hard!!

[Updated on: Thu, 23 August 2007 01:49] by Moderator

Report message to a moderator

Re: Ask For Forms_ddl [message #261590 is a reply to message #261199] Thu, 23 August 2007 01:52 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Did you split the 'set' line of the 'forms_ddl' line yourself or is the code you supplied the 'actual' code that you have in your form?

David
Previous Topic: Want to know better reporting tool
Next Topic: Compile Form Won't Stop
Goto Forum:
  


Current Time: Thu Dec 08 16:31:11 CST 2016

Total time taken to generate the page: 0.10666 seconds