Re: square root?

You can use any sql function than you want inside 4gl without creating any temp table (just using an existing one): Example: ... DEFINE x, y FLOAT LET x = 3.141592654 / 6. SELECT SIN(x) INTO y FROM systables WHERE tabid=1; -- always exists 1 DISPLAY y ... Hope this helps Mario R. Canto mcanto@unl.edu.ar On Fri, 18 Oct 1996, Clem Akins wrote: } >> Does anyone know how to compute square root on 4GL? Also how to compute } >> logarithmic and trig functions? } >> } >> Please respond to fmatrins@sc0126wp.sc.blm.gov } } Though it's not exactly what you asked for, these functions are available } in SQL. Some of them are not documented, but ARE available, in older } versions, too. You may be able to compute these values non-programmatically } using temp tables and SQL functions. } } Check your release notes, as well as newer versions of TFM, and try the } functions on your version (if it's older.) } } You may also check out the International Informix User Group page. There } are many tools and function sets available there for 4GL (and other Informix } products) at no cost to you. Perhaps some of them will be useful. The URL } is: http://www.iiug.org/software/software_index.html } } Good luck, } } ______________________________________________________ } Clem Akins (aka clema@informix.com) } Informix Software, Inc (Standard disclaimers apply) } International Technical Support } Last seen: Spending a balmy winter in Singapore! }