hi!
i have some problem with using sqlite,- cant initialisate it.
i use win7. sqlite3 had installed,- in cmd.exe can use it, but in x-11 cant: err "sqlite3 its not a brogramm or .bat"
And for Android i cant use it too. Cant install sqlite3 package,- url in app is illegal (http://www.zois.co.uk/dl/sqlite3).
Can smb help me?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You are right. The Download page for the sqlite binary has vanished. However there is a little project which can compile a sqlite3-static binary for Android:
concerning sqlite on WIN7: Where exactly is sqlite3.exe installed? In which directory?
What is the exact command you used to call it from X11-Basic? maybe it should be called with the ending .exe.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
on win7 sqlite installed in C:\Windows\System32 and i was used:
system "sqlite3"
system "sqlite3.exe"
system "C:\Windows\System32\sqlite3.exe"
and system "cmd" next in cmd "sqlite3". ending.exe - dont work too.
and was used "sqldemo.bat" from examples
for android. thank, but compilling wil dont need becourse i use androuid 4.1.1 and it for android 5.0 and upper(((
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
sqldemo.bas fails on Android 5.1.1 using the 1.25-50 APK. It appears the included sqlite3 is not a 'position independent executable' (PIE) and is therefore not supported.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The problem is Android related. sqlite is called as a native excecutable from X11-Basic. This is not possible anymore in more recent Android versions. So sqlite needs to be implemented as a library or something like that. I am not an expert on sql at all, so I would need advice/suggestions how this should be implemnted in X11-Basic (maybe as a built-in command).
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
View and moderate all "Open Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Discussion"
hi!
i have some problem with using sqlite,- cant initialisate it.
i use win7. sqlite3 had installed,- in cmd.exe can use it, but in x-11 cant: err "sqlite3 its not a brogramm or .bat"
And for Android i cant use it too. Cant install sqlite3 package,- url in app is illegal (http://www.zois.co.uk/dl/sqlite3).
Can smb help me?
You are right. The Download page for the sqlite binary has vanished. However there is a little project which can compile a sqlite3-static binary for Android:
https://github.com/stockrt/sqlite3-android
Maybe someone needs to compile it for you.
concerning sqlite on WIN7: Where exactly is sqlite3.exe installed? In which directory?
What is the exact command you used to call it from X11-Basic? maybe it should be called with the ending .exe.
View and moderate all "Open Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Discussion"
on win7 sqlite installed in C:\Windows\System32 and i was used:
system "sqlite3"
system "sqlite3.exe"
system "C:\Windows\System32\sqlite3.exe"
and system "cmd" next in cmd "sqlite3". ending.exe - dont work too.
and was used "sqldemo.bat" from examples
for android. thank, but compilling wil dont need becourse i use androuid 4.1.1 and it for android 5.0 and upper(((
Hm, maybe the SYSTEM command is not working at all?
Maybe good news: the next release for Android will have a sqlite3 binary included in the .apk package. I am also going to adapt the sqldemo.bas.
The release is out (1.24-33) sqldemo.bas should now work without downloading anything.
sqldemo.bas fails on Android 5.1.1 using the 1.25-50 APK. It appears the included sqlite3 is not a 'position independent executable' (PIE) and is therefore not supported.
Hm, it seems only work on Android versions before and equal 5.0.
There is a newer precompiled download page. Is this suitable?
The problem is Android related. sqlite is called as a native excecutable from X11-Basic. This is not possible anymore in more recent Android versions. So sqlite needs to be implemented as a library or something like that. I am not an expert on sql at all, so I would need advice/suggestions how this should be implemnted in X11-Basic (maybe as a built-in command).
The issue on Android 5.0 up to 9 has been fixed now. Please test the most recent version: 1.27-63 (163) p.ex. found here: https://f-droid.org/en/packages/net.sourceforge.x11basic/
sqldemo now works on all my Android devices, 4.4.4, 5.1.1, 9, 10, and 11. Muchas gracias!
Ok, great. Thanks for testing. So this issue can be closed.