| Subject | Re: [firebird-support] Is there a parameter value of 'don't care' ? |
|---|---|
| Author | Ivan Grozny |
| Post date | 2007-01-11T18:15:20Z |
tickerboo2002 wrote:
It seems to me that there should be some "sweet spot" that balances the things that your application does vs. the things that Firebird handles. Your app is probably better at making decisions based on user input. Val Melamed, in another thread going on at the same time, is at the other extreme - only using Firebird for data storage, but handling queries etc. in his own app. Somewhere in the middle there is sanity...
Just my US$.02 worth (and with the dollar's recent decline, worth even less than that!)
____________________________________________________________________________________
Yahoo! Music Unlimited
Access over 1 million songs.
http://music.yahoo.com/unlimited
> Let's say the user is not interested in Num_Employees, is it possilbleI'm probably missing something, but I would think that the best thing would be to validate input first and run different queries based on different user requests.
> to set the parameter so that clause is ignored?
It seems to me that there should be some "sweet spot" that balances the things that your application does vs. the things that Firebird handles. Your app is probably better at making decisions based on user input. Val Melamed, in another thread going on at the same time, is at the other extreme - only using Firebird for data storage, but handling queries etc. in his own app. Somewhere in the middle there is sanity...
Just my US$.02 worth (and with the dollar's recent decline, worth even less than that!)
____________________________________________________________________________________
Yahoo! Music Unlimited
Access over 1 million songs.
http://music.yahoo.com/unlimited