-
Welcome to B4X forum!
B4X is a set of simple and powerful cross platform RAD tools:
- B4A (free) - Android development
- B4J (free) - Desktop and Server development
- B4i - iOS development
- B4R (free) - Arduino, ESP8266 and ESP32 development
sqrt
-
R
Android Code Snippet Taking SquareRoot in SQL
SQLite doesn't have SQTR as a standard function, so you would normally do this in code. There is a way though to do this in SQL with a CTE: strSQL = "update Table1 set xValue = (" & _ "with Guesses(FindRootOf, " & _ "guessRoot) as (" & _ "select xValue, " & _ "case when xValue...- RB Smissaert
- Thread
- cte sql sqrt
- Replies: 16
- Forum: Code Snippets