| View previous topic :: View next topic |
| Author |
Message |
Cenda
Power User
Joined: 18 Feb 2011
Posts: 92
Location: Czech Republic
|
 Posted: Wed Mar 09, 2011 9:25 am Post subject: [Solved] Parameter default value . |
 |
|
Hi all
Is there any way to fill-in parameter with default value . User is permanently prompted for date_from and date_to and still has to populate it . I would like it has default broad range of date_from to date_to . The user would populate it just when he/she wants to narrow the range .
The code is :
| Code: |
Select . . . . . .
from . . . . . .
Where . . . . .
AND CAST("DATE" as "DATE") >= :Date_from
AND CAST("DATE" as "DATE") <= :Date_to
|
Thank you for suggestion
Cenda
Last edited by Cenda on Wed Mar 09, 2011 11:10 am; edited 2 times in total |
|
| Back to top |
|
 |
Sliderule
Super User
Joined: 29 May 2004
Posts: 2474
Location: 3rd Rock From The Sun
|
| Posted: Wed Mar 09, 2011 10:09 am Post subject: |
|
|
Cenda:
You said / asked.
| Cenda wrote: | | Is there any way to fill-in parameter with default value . |
No.
Sliderule
Thanks to add [Solved] in your first post Title ( edit button ) if your issue has been fixed / resolved. |
|
| Back to top |
|
|
|
