how to display current record? [message #579526] |
Tue, 12 March 2013 22:18 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/540df28716d20f2fda22ee3dd1a76122?s=64&d=mm&r=g) |
needs2lern
Messages: 14 Registered: January 2013 Location: Philippines
|
Junior Member |
|
|
Hi all,
I have problem about displaying current records with same table(tbl_pawnitem). I have 2 transactions which are the pawned transaction and for sale transaction. and both transactions save into tbl_pawnitem table..i want to display only in my list the for sale transaction without deleting the records of pawned transaction. what condition i will use?
thanks
[Updated on: Tue, 12 March 2013 22:20] Report message to a moderator
|
|
|
|
|
|
Re: how to display current record? [message #579538 is a reply to message #579537] |
Wed, 13 March 2013 01:23 ![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/540df28716d20f2fda22ee3dd1a76122?s=64&d=mm&r=g) |
needs2lern
Messages: 14 Registered: January 2013 Location: Philippines
|
Junior Member |
|
|
sir, clarification..if I will use the set_block_property it means the columns u want to disabled will no longer appear in the other transaction..but what if all the columns that I want to disabled is the columns that I will use too? (i.e tbl_pawnitem has itemID,itemdesc and categoryname and this fieldnames are the one that I will use also for my sale transaction) what will I do?
[Updated on: Wed, 13 March 2013 01:32] Report message to a moderator
|
|
|
Re: how to display current record? [message #579545 is a reply to message #579538] |
Wed, 13 March 2013 01:59 ![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 |
|
|
Quote:if I will use the set_block_property it means the columns u want to disabled will no longer appear in the other transaction
Eh? I'm afraid you got it wrong. SET_BLOCK_PROPERTY with DEFAULT_WHERE (if that's what you are talking about) doesn't "disable" anything. It adds WHERE clause to SELECT statement. By default, if you don't code anything additional, data block's query execution acts as if has been ran. DEFAULT_WHERE "converts" it to select * from your_table
where transaction_type = 'sale' (just as an example). Therefore, it doesn't affect COLUMNS, but ROWS.
Now, rethink everything that's been said here along with what you want to do and try to compose a new question, but now use correct terminology.
|
|
|