OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

[Solved] Parameter default value .

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
Cenda
Power User
Power User


Joined: 18 Feb 2011
Posts: 92
Location: Czech Republic

PostPosted: Wed Mar 09, 2011 9:25 am    Post subject: [Solved] Parameter default value . Reply with quote

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
View user's profile Send private message Yahoo Messenger
Sliderule
Super User
Super User


Joined: 29 May 2004
Posts: 2499
Location: 3rd Rock From The Sun

PostPosted: Wed Mar 09, 2011 10:09 am    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group