| EXECUTE QUERY [message #588714] |
Thu, 27 June 2013 11:18  |
 |
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  |
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 |
|
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 |
 |
Littlefoot
Messages: 21823
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
