> > Not generating SP for each field, but rewriting you sql select query

with

> > SP :
> > if it was
> > where
> > my_year > 1975
> > my_week > 45
> > my_age > 25
> > my_weight > 125
> > it would be
> > where
> > (SELECT MY_NUMERIC FROM MY_SP( my_year )) > 1975
> > AND
> > (SELECT MY_NUMERIC FROM MY_SP( my_week )) > 45
> > AND
> > (SELECT MY_NUMERIC FROM MY_SP( my_age )) > 25
> > AND
> > (SELECT MY_NUMERIC FROM MY_SP( my_weight )) > 125
>
> Oops!
> Sorry, you're right!!!

Still: band aid ... workaround ... weird design.

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com