Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Default values

Status
Not open for further replies.
webfocusraj

webfocusraj

Programmer
Aug 24, 2003
14
US
Can please somebody help me with the default values problem? If I pass '$*' as default value for a parameter and then compare it with a string, it is working fine. I am having problem comparing with a numeric value. Please help. I am using Dev Studio 5.2.
Thanks,
WFR
 
Sort by date Sort by votes
Hi

try this value.

'1 OR (1 EQ 1)'

this can work in your program?
 
Upvote 0 Downvote
That doesn't work Simaccs! I would like it to work with any numeric value (a numeric field from the database to be compared with the parameter value).
Thanks Simaccs.
 
Upvote 0 Downvote
Raj,
I ran into the same problem. I'm also using WF5.2. It turns out Simaccs is right.

Try this:
-DEFAULT &SeatsPropmt = 'ALL';
-SET &SeatsWhere = IF &SeatsPropmt EQ 'ALL' THEN '1 OR (1 EQ 1)' ELSE &SeatsPropmt;
TABLE FILE CAR
PRINT
CAR
SEATS
WHERE SEATS EQ &SeatsWhere;
END

Thanks for the solution, Simaccs.
Regards,
Michael
 
Upvote 0 Downvote
Hi Michael,
Thanks for the detailed code.
Thanks Simaccs
Regards
WFR
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sxschech
  • Locked
  • Question
Prompt Based on List Of Values
Replies
0
Views
249
sxschech
sxschech
lauraskaggs
  • Locked
  • Question
Positioning Data in Report not default
Replies
0
Views
181
lauraskaggs
lauraskaggs
calvinw
  • Locked
  • Question
reference values in a hold file
Replies
1
Views
245
calvinw
calvinw
LeonelSanchezJr
  • Locked
  • Question
Accept Numeric Values Only - TextBox
Replies
1
Views
167
gizzy17
gizzy17
LeonelSanchezJr
  • Locked
  • Question
Creating a Drop Down List With Values 1 Thru 5000
Replies
2
Views
230
LeonelSanchezJr
LeonelSanchezJr

Part and Inventory Search

Sponsor

Back
Top