sqlite

  1. practicalsoft

    B4X FEED SQLite math functions

    Would it be possible to enable SQLite math functions in B4J or B4A or both? I am currently most interested in the modulo function but any and all of the following would be useful at some stage. https://www.sqlite.org/lang_mathfunc.html Thanks in advance for any suggestions. ادامه مطلب...
  2. practicalsoft

    B4X FEED sqLite Progam - One works one doesn't

    Hi, Had trouble using sqlite PRAGMA commands in B4J. I had used them in a B4A V 10.0 project and they worked fine. I created a simple B4A V10 UI Program called sqLiteCheckPointTest, so I could do some more testing, but it keeps crashing when it tries to create the database file...
  3. practicalsoft

    B4X FEED [SOLVED] Problem with SQLite and image in table

    Hello. This is my first post to the forum, so please excuse me if i make any mistakes regarding the posting procedure. I have a little app as a test in order to save a png file from the File.DirAssets directory in a SQLite table named Images and in a field named Image. The saveImage Sub is the...
  4. practicalsoft

    B4X FEED Problem with SQLite and image in table

    Hello. This is my first post to the forum, so please excuse me if i make any mistakes regarding the posting procedure. I have a little app as a test in order to save a png file from the File.DirAssets directory in a SQLite table named Images and in a field named Image. The saveImage Sub is the...
  5. practicalsoft

    B4X FEED Sqlite android.database.CursorWindowAllocationException

    I'm getting this error again. B4X: Error occurred on line: 479 (MysqlEntrySync) android.database.CursorWindowAllocationException: Cursor window allocation of 2097152 bytes failed. # Open Cursors=920 (# cursors opened by this proc=920) at...
  6. practicalsoft

    B4X FEED Shrinking that SQLite JDBC library!

    NOTE: This isnt recommened for everyone, this is just something that works for me. Removing support for specific platforms could cause your app to stop working. I use SQLite for a lot of server projects and I've noticed over the years that the SQLite JDBC library has gotten bigger and bigger...
  7. practicalsoft

    B4X FEED SQLite mit Android 9

    Hallo Leute, brauche mal wieder Hilfe. Ich erstelle zur Laufzeit eine SQLite Datenbank If FirstTime Then If File.Exists(rn.GetSafeDirDefaultExternal (""), "Auftraege.s3db") = False Then 'Hier Freigabe auf Speicher AuftraegeDB.Initialize(File.DirDefaultExternal, "Auftraege.s3db", True)...
عقب
بالا