sqlite

  1. R

    Android Code Snippet Tip: B4a SQLite Database Potholes - WAL File Checkpoint

    Hi B4X'ers I just thought I'd post this tip to warn of a problem I came across when using an sqLite data base created and populated using sqLite Studio. The steps I used were. Created an sqLite db using sqLite Studio on Win 10 pc Set the DB to use the Write Ahead Log journal method (WAL File)...
  2. R

    Android Question SqLite create_aggregate function

    Hi All The other day I wrote a query for sqLite to return the standard deviation of a column. SELECT STD(colFred), AVG(colFred) FROM tblFredsTable ... Imagine my disappointment when I found that sqLite doesn't provide standard deviation or variance aggregate functions. All of the other...
  3. demonio_jack

    Android Question JdbcSQL and SQL are compatible?

    Hello everyone: Today I have a fairly specific question: Are the JdbcSQL and SQL libraries compatible or not? I have been developing an app (android) using JdbcSQL, as recommended, and connecting to a MYSQL server without any problem. However, for a few days now, I have wanted to add to my...
  4. Mashiane

    B4J Library BANanoSQLiteR - Distributing and accessing an existing SQLite Databases - Part 2

    Ola Download Part 1 is here. At some stage we explored how one can distribute / embed SQLite database on their BANano app. These databases are mainly for read only access purposes where one just wants to display data. Here we explore part 2 of the tutorial, however now made into a library...
  5. Mashiane

    B4J Library [BANanoConnect] BANanoSQL+SQLite+MySQL+MSSQL Library

    Ola For a while I have been exploring backend connectivity using BANano for BANanoSQL, SQLite, MSSQL and MySQL. The purpose of this lib is for a one place for all your connectivity with these backends. This library as a couple of class utilities for connecting to BANAnoSQL, SQLite, MSSQL and...
  6. LucaMs

    B4J Library [B4X] lmB4XComboBox

    lmB4XComboBox is a b4x library (https://www.b4x.com/android/forum/threads/100383/#content). It works with B4A, B4J and B4i. It is a modified version of the Erel's original B4XComboBox and allows you to store in it a value for each text item. Not rarely (mainly handling DB data) you need a...
  7. S

    Android Question Get text from Xcustomlistview - SQLite Database

    I created a Xcustom list view as shown in this thread, https://www.b4x.com/android/forum/threads/b4x-xui-xcustomlistview-cross-platform-customlistview.84501/ to get data i used SQLite database. To load the layout I used the following code as shown in the above thread, Sub Process_Globals...
  8. C

    Android Question sql delete question

    I have been trying out SQLite and ran into something odd. I have just implemented a Delete function and it appears to work fine. It no longer shows up in specific queries or if I list all records in the appropriate table. However, if I take the database file to a PC and examine it, the rows are...
  9. L

    Android Question SQLiteDiskIOException: disk I/O error (code 1034)

    Hello, I get this error on a service in my application. The error occours sometimes on a SQL EndTransaction: The error is rare, it appens one time in a hour. The transaction is on a sub called by a client socket. What it can depend on? Here the logs...
  10. jroriz

    B4J Question Would you recommend SQLite?

    Well, I intend to rewrite a small POS system for B4J. It will be used by small restaurants, so I don't expect a lot of competing readings and recordings, or a lot of data, and it will be used on a local network. My intention is to use SQLITE, to facilitate the installation, but I never used this...
  11. AKJammer

    B4J Question In Memory SQLite Database

    Hopefully this is a quick question. I'm trying to do some array processing and sorting and think it would be easier to do this within a database environment, but don't want to have to go back to the mySql server for this temporary stuff. I think an in memory SQLite connection would work just...
  12. peacemaker

    Android Code Snippet Clean SQLite database, if it grows much

    Long working apps have DB that grows and grows. It must be controlled, when records qty is very big, and most old data should be deleted: Sub Clean_SQL(tables() As String) As Boolean 'Starter.SQL is already open Dim TotalRecordsLimit As Int = 20000 'set yourself according to the...
  13. DALB

    Android Question SQLite Insert seems not to insert

    Hello every pro, I use the code below to insert datas in a table which name is pvpt (for geography) synt="INSERT INTO pvpt(pays,villes,lat,ns,lon,ew,abrv,ajout) VALUES " & _ "('" & _ txtPays.Text & sep & _ txtSaisieNelleVille.Text & sep & _...
  14. DALB

    Android Question Non correct extraction from SQLite (May be)

    Hello everyone, In the code below, when I extract datas from a table, I find a special behaviour decribed here: The log renders the good answers for two datas LAT and LON, but if I try to put them in two EditTexts, the result is 0. Do I miss something ? Thanks
  15. peacemaker

    Android Question Expert system project for Android

    HI, All, Who tried to develop it ? I think, it's very interesting task. For ex., we make: 1) choosing the subject, area for the app - say, fishing (or electrotechnics...)... 2) Develop the database structure 3) invent the interface template for db filling by the expert 4) invent the interface...
  16. D

    Android Question SQL Lite - No Such Column

    I am trying to do a join on 2 different SQLite tables. Here is my SQL Statement: Select * FROM tbl_items WHERE tbl_categories.cl_reference = 'cat01' AND tbl_categories.cl_song = tbl_items.cl_song ORDER BY cl_last_access_time ASC I keep getting the following error...
  17. R

    Android Question Place sqLite DB on external storage (SD Card)

    Hi, I wish to use an sqlite db on a tablet's external sd card. The tablet is running Android Build version 6 with API Level (19 KiKat). I tried ExternalStorage.zip. I had to edit the manifest to a minimum of 19 to get it to install. It now installs and runs, but when I push the Pick Folder...
  18. OliverA

    Wish Enable locking for alternative SQLite JDBC drivers

    This wish is for enabling jSQL's locking for alternative SQLite JDBC drivers. Various methods for enabling this could be (this is a repeat found in my post here: https://www.b4x.com/android/forum/threads/sqlite-jdbc-driver-with-encryption-and-authentication-support.110565/#post-690205): 1) If...
  19. Kevin Hartin

    Android Question Put SQLite BLOB into MySQL BLOB using PHP

    I have an app that stores an image in a SQLite BLOB and happily retrieves and displays it in a form. However I need to push that up to a PHP Webserver and store it in the corresponding MySQL BLOB field. Do I have to retrieve the BLOB, store it locally as a file then Post it to the Server for...
  20. Mashiane

    B4J Library SQLite 2 JavaScript / JSON

    Ola I needed to embed a sqlite db as part of a web app i'm working on, but as JavaScript / JSON. This app helps with converting your sqlite db to javascript. This is useful when one wants to use the data for READ ONLY purposes, my case in point. 1. Add the database that you want to be...
Top