OraFAQ Forum: Forms » Ask For Forms

Home » Developer & Programmer » Forms » Ask For Forms_ddl

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

Ask For Forms_ddl [message #260888]

Tue, 21 August 2007 03:36

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

Report message to a moderator

Re: Ask For Forms_ddl [message #260894 is a reply to message #260888]

Tue, 21 August 2007 03:51

Michel Cadot
Messages: 68745
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Ask For Forms_ddl [message #260904 is a reply to message #260894]

Tue, 21 August 2007 04:21

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

Report message to a moderator

Re: Ask For Forms_ddl [message #260906 is a reply to message #260894]

Tue, 21 August 2007 04:24

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

Report message to a moderator

Re: Ask For Forms_ddl [message #260922 is a reply to message #260906]

Tue, 21 August 2007 04:56

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

Report message to a moderator

Re: Ask For Forms_ddl [message #261102 is a reply to message #260922]

Tue, 21 August 2007 18:56

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: Ask For Forms_ddl [message #261199 is a reply to message #261102]

Wed, 22 August 2007 02:30

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

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 11:19:28 CDT 2025