| Text item [message #234514] |
Tue, 01 May 2007 23:08  |
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 #234739 is a reply to message #234514] |
Thu, 03 May 2007 01:40  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
