Hi Taifun and all,
I use the sqlite extention to call "select id,sqrt(id) from tabelle". ( the id is in the table)
"select id from tabelle" works.
same with ... power(id,2) ...
The function is not available, but in https://sqlite.org/lang_mathfunc.html#pow the functions are listed.
So I guess your sqlite is with less functions? Or what can I do?
Horst
The sqlite application is on your device, not a part of the extension. It may not have all the functions that the main linux/windows sqlite application has, this will depend on what (version) the vendor installs, and how they compile it...
From your link:
The math functions shown below are part of the SQLite amalgamation source file but are only active if the amalgamation is compiled using the -DSQLITE_ENABLE_MATH_FUNCTIONS compile-time option.
[edit]You are lucky, my device doesn't even have sqlite installed on it! Found it now !
From the link you posted, it just explains that sqlite must be compiled with maths functions enabled for maths functions to be available in the sqlite application. It is quite possible that the compile on your device does not have these functions. Do any of the other maths functions work ?
Hi,
I just tried my app on an Galayy S2 and sqlite works, But my formula sqrt() did not work on S9
But I changed my sql using an other formula, which gives an enough accurate result.
I think I have no choice to implement sqrt() in my device. If the sqlite is only basic it's ok. It is only bad if you spend time searching the error when there is no error, only a missing option.#
Sqlite was not present on my HTC 10 (Android 7) nor is it available on my Google Pixel 4a (Android 11).
[edit] Found it now, buried deep inside android - well, Taifun's sqlite extension works, just can't access from Juan's terminal extension.
This is why I had a look at a solution to use sqlite using the Termux App.
Well, don't feel it offensive but, helping in someone's problem is more necessary than just pointing out spelling mistakes. The community is for helping each other and sorting spelling mistakes isn't a too good idea