EXECUTE QUERY [message #588714] |
Thu, 27 June 2013 11:18 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/526fb5d7092890677bd591daad81c1f1?s=64&d=mm&r=g) |
jocelyne
Messages: 34 Registered: December 2012 Location: lebanon
|
Member |
|
|
hi all,
how can i execute query using a where condition?
thank you
|
|
|
|
|
|
|
|
|
Re: EXECUTE QUERY [message #588723 is a reply to message #588721] |
Thu, 27 June 2013 13:12 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
This is such a generic question that cannot be answered with such little information provided. and you wonder why the thread keeps going on and on and on and on.
Please ask a fully detailed question.
My answer is you do not need a where clause, you use the built-in functionality of FORMS and base the block on a table.
Also, "but it did not work" is not an Oracle error message.
[Updated on: Thu, 27 June 2013 13:13] Report message to a moderator
|
|
|
Re: EXECUTE QUERY [message #588724 is a reply to message #588723] |
Thu, 27 June 2013 13:32 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/526fb5d7092890677bd591daad81c1f1?s=64&d=mm&r=g) |
jocelyne
Messages: 34 Registered: December 2012 Location: lebanon
|
Member |
|
|
create table Product_detail
(
id_inv_det integer,
barcode varchar2(50),
quantity integer,
unit_price integer,
total integer,
constraint pk_iddetail_barcode primary key(id_inv_det,barcode),
constraint fk_iddetail foreign key(id_inv_det) references Invoice_detail(id_inv_det),
constraint fk_barc foreign key(barcode) references Product(barcode)
);
this is my table all i want is to get the data from the db and put it in a grid but i don't want to display all the records, i need to display only the records for the selected id_inv_det
did you get what i need?
|
|
|
Re: EXECUTE QUERY [message #588725 is a reply to message #588724] |
Thu, 27 June 2013 13:50 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
- enter query mode
- now, enter desired value into ID_INV_DET
- execute query
- only records that contain that value within the ID_INV_DET column are displayed
|
|
|