×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
I am trying to write a procedure I thought would be extremely simple: a
short SQL evaluation program that would simply take an expression and return
the result of SQL operating on that expression. For a silly example:
Exec sql set :myResult = 2 + 2 ;
To minimize complexity, I am passing the '2 + 2' part as a string, so that
the meat of this very short procedure is:
Exec sql setl :myResult = :myExpression ;
But (and, yes, I know I should have expected this) SQL is seeing it as the
string "2 + 2" rather than a pair of values with an operator between them.
Is there an SQL verb/clause that informs the SQL processor that the
following is an expression rather than a string (such as with unix' "expr"
command)? Or is this just a pipe dream, not worth the effort?
Dennis E. Lovelady
AIM/Skype: delovelady MSN: fastcounter@xxxxxxxxxxxx
<
http://www.linkedin.com/in/dennislovelady>
www.linkedin.com/in/dennislovelady --
You can't have everything. Where would you put it?
midrange.com
