Home » Developer & Programmer » Forms » when button pressed (forms6i)
when button pressed [message #330159] Fri, 27 June 2008 13:02 Go to next message
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.........
Re: when button pressed [message #330209 is a reply to message #330159] Fri, 27 June 2008 22:58 Go to previous messageGo to next message
mm_kanish05
Messages: 487
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 Go to previous messageGo to next message
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
Re: when button pressed [message #330359 is a reply to message #330159] Sun, 29 June 2008 21:55 Go to previous messageGo to next message
mm_kanish05
Messages: 487
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

Re: when button pressed [message #330554 is a reply to message #330159] Mon, 30 June 2008 07:41 Go to previous message
Littlefoot
Messages: 20901
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?
Previous Topic: Form hangs
Next Topic: run select statment in button press trigger
Goto Forum:
  


Current Time: Sat Dec 10 16:42:52 CST 2016

Total time taken to generate the page: 0.05477 seconds