Home » Developer & Programmer » Forms » Text item
Text item [message #234514] Tue, 01 May 2007 23:08 Go to next message
karthi_real
Messages: 11
Registered: May 2007
Junior Member
Hi everyone

I am using froms 6i.
i have two text items, start date and end date.

i want to display all the records which has a date value greater than start date and date lesser than end date.

could you tell how it can be done?

thank you all in advance.
Re: Text item [message #234530 is a reply to message #234514] Wed, 02 May 2007 01:03 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Using a DEFAULT WHERE condition for that block.
Re: Text item [message #234693 is a reply to message #234530] Wed, 02 May 2007 22:45 Go to previous messageGo to next message
karthi_real
Messages: 11
Registered: May 2007
Junior Member
thankyou for your reply.

am very much new to forms.
could you explain in the way of steps.
Re: Text item [message #234739 is a reply to message #234514] Thu, 03 May 2007 01:40 Go to previous messageGo to next message
imen_mr2004
Messages: 22
Registered: October 2006
Location: tunisia
Junior Member
you click to your block that must be a data base block, u can know this if u pree F4 or double click under the block an u must go to the property clause where and u put this code
where table.column1>:datablock.textitem1 and table.column2<:datablock.textitem2


N.B: table.column1 and table.column2 are column names in table
:datablock is name of block
textitem1 is name of the text item corresponding to "begin date"
textitem2 is name of the text item corresponding to "end date"


Good luck
Re: Text item [message #234821 is a reply to message #234739] Thu, 03 May 2007 04:20 Go to previous message
karthi_real
Messages: 11
Registered: May 2007
Junior Member
thank you.

i will try it now.
Previous Topic: order by in tabular form
Next Topic: Req Block Solution
Goto Forum:
  


Current Time: Fri Dec 09 13:52:22 CST 2016

Total time taken to generate the page: 0.08369 seconds