Home » Developer & Programmer » Forms » how to display current record? (forms10g)
how to display current record? [message #579526] Tue, 12 March 2013 22:18 Go to next message
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 Go to previous messageGo to next message
dude4084
Messages: 213
Registered: March 2005
Location: Mux
Senior Member
set_block_property(default_where .......


Set property as per your need.
Re: how to display current record? [message #579536 is a reply to message #579535] Wed, 13 March 2013 01:09 Go to previous messageGo to next message
needs2lern
Messages: 14
Registered: January 2013
Location: Philippines
Junior Member
thank you sir.. Smile
Re: how to display current record? [message #579537 is a reply to message #579536] Wed, 13 March 2013 01:11 Go to previous messageGo to next message
Littlefoot
Messages: 19633
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).
Re: how to display current record? [message #579538 is a reply to message #579537] Wed, 13 March 2013 01:23 Go to previous messageGo to next message
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
Littlefoot
Messages: 19633
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.
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:
  


Current Time: Mon Sep 22 09:22:31 CDT 2014

Total time taken to generate the page: 0.04922 seconds