SQL relational database system

Oct 27, 2016

1. Any complex mathematical expressions in SQL UPDATE for numeric type fields are available now! Use table fields as arguments for any mathematical funvctions in your expressions!
2. Also any complex mathematical expressions are available in SELECT parameters list as well.
For example,
SELECT (1+LOG10(SQRT(MyData+PI()/2)))/2 AS MyCalc FROM MyTable WHERE MyCalc>1.0
UPDATE MyTable SET MyField1=SQRT(SIN(Field2+pi()/2))+1
3. What about new menu concept on main form screen?