OraFAQ Forum: Forms » how to display current record?

Home » Developer & Programmer » Forms » how to display current record? (forms10g)

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

how to display current record? [message #579526]

Tue, 12 March 2013 22:18

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 #579535 is a reply to message #579526]

Wed, 13 March 2013 01:01

dude4084
Messages: 222
Registered: March 2005
Location: Mux

Senior Member

set_block_property(default_where .......

Set property as per your need.

Report message to a moderator

Re: how to display current record? [message #579536 is a reply to message #579535]

Wed, 13 March 2013 01:09

needs2lern
Messages: 14
Registered: January 2013
Location: Philippines

Junior Member

thank you sir.. Smile

Report message to a moderator

Re: how to display current record? [message #579537 is a reply to message #579536]

Wed, 13 March 2013 01:11

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

Senior Member
Account Moderator

As it appears that the requirement is static (i.e. you ALWAYS want to display sale transactions only, it doesn't change), perhaps you'd rather set data block's WHERE property (in its Property Palette window).

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

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

Littlefoot
Messages: 21808
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

select * from your_table

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.

Report message to a moderator

Previous Topic:	40208#Form running in query-only mode.
Next Topic:	How to Check for a unique value in a text item in a multi-record block

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 12:06:37 CDT 2024