OraFAQ Forum: Forms » when button pressed

Home » Developer & Programmer » Forms » when button pressed (forms6i)

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

when button pressed [message #330159]

Fri, 27 June 2008 13:02

kommerashashi
Messages: 23
Registered: November 2007

Junior Member

Hi to all,

i got very much problem with writing the code for searching the concept
my requiremment is
i have 1 select statement,2 insert statements,

i have to write 3 queries in the when button pressed trigger
how to wrtie that code is it possible?
and i dont have any relation in any table in the queries.
depnding on the number i have to retriebv the data and simaltanously i have to insert the data into two table at a time ?
bot the tables are master and details but there is no relation tables in the insert statements.

how to write the code can you help me please?

thanks in advance.........

Report message to a moderator

Re: when button pressed [message #330209 is a reply to message #330159]

Fri, 27 June 2008 22:58

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

Hi

All the action manually you want to do on the button action.

Otherwise send your working Form. if possible We will explain.

kanish

[Updated on: Fri, 27 June 2008 22:58]

Report message to a moderator

Re: when button pressed [message #330272 is a reply to message #330209]

Sat, 28 June 2008 12:27

kommerashashi
Messages: 23
Registered: November 2007

Junior Member

hi,
yes i want to do action with in the button pressed , that is my requirement ..it is the new form am going to develop......

but what ever i know these 3 queries are not possible with in when button pressed trigger
,
apart from this there is no relation between 3 tables .....they are telling to use these 3 queries with in the when button pressed trigger ...but i am not getting the code how to write
.......
i will give the syntax.......

query 1 :

select * from table A, table B where A.column1 = B.column1 and
A.column2= B.column 2;

from this query i have to retrivie the query the data and i have to post in the different blocks.....

Query 2;

insert into table 3 (columns) values(column_values);

table3 is the master table,

insert into table 4(columns) values(column_values)

table 4 is the detail table

and there is no relation between table 3 and table 4 ...
how to write this code ..in the when button pressed trigger...

can u tell me is it possible to write all these back end queries in front end........
in my its wrong ..... can you clarify.....

please inform me ..how can i write the code ...for searching using these 3 queries ..please ....help me As soon As possible....

thanks in advance

Report message to a moderator

Re: when button pressed [message #330359 is a reply to message #330159]

Sun, 29 June 2008 21:55

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

Hi

1st I need your sample code then I can easily solve the problem.

All back end DML command We can use it here also. Small change in Select only.

 Select a into b from table x;

kanish

Report message to a moderator

Re: when button pressed [message #330554 is a reply to message #330159]

Mon, 30 June 2008 07:41

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

You are talking about "3 queries", "tables are master and details but there is no relation" (hm? what kind of master-detail relationship is it if there's no relation?), "searching using these 3 queries" etc.

I think that you are, actually, presenting YOUR idea of solving a problem. But, you didn't explain what that problem is.

So, what would you want to do? What is the input, what is the output?

Report message to a moderator

Previous Topic:	Form hangs
Next Topic:	run select statment in button press trigger

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 08:08:55 CST 2025