sqlite

  1. Mashiane

    B4J Tutorial [BANano] Exploring Using PHP & SQLite for your WebApp

    Ola UPDATE: BANanoSQLite now available for actual sqlite db file CRUD functionality. This is part 1 of a series of my explorations using SQLite as a backend to a BANano app. I need a way to persist the data to a database, but thought of a serverless database for now. Series 1. Create the...
  2. E

    Android Question How to Add SQLite to Assets

    Can i add sqlite database to assets? im use database for read only, i will never insert,update or delete it. just use for select data. schema and record will make out of application.
  3. Mashiane

    B4J Tutorial [BANano]: Distributing and accessing an existing SQLite Databases - Part 1

    Ola Part 2 UPDATE: BANanoSQLite now available for actual sqlite db CRUD using PHP I've been wondering if I could be able to do this as I want to distribute my app with an already existing SQLite.DB database for READONLY access. No, this is not WebSQL but a pure SQLite database. At first I...
  4. E

    Share My Creation My Quiz Software

    It works with B4J, Sqlite Database And also ESp8266 12F...through UDP Communication
  5. E

    Android Question Database file added in apk file

    Is it Possible to add a Database File (Sqlite) in Andriod Application. If yes how it is possible. My requirement is this database file install in my Andriod Device during installation of APK file. So that I can read,edit, modify its content.
  6. peacemaker

    Android Question SOLVED: SQLite concatenation

    HI, All android.database.sqlite.SQLiteException: near "||": syntax error (code 1): , while compiling: SELECT FName || ' ' || Name || ' ' || SName ', ' || Position FROM CompanyWorkers WHERE UserID = 'F185C519D5E91F03' Requested like SQL.ExecQuerySingleResult(req) Why error? SOLVED: $"SELECT...
  7. peacemaker

    Android Code Snippet DBUtils: clear table (delete all)

    'Tests whether the given table exists Public Sub TableExists(SQL As SQL, TableName As String) As Boolean Dim count As Int = SQL.ExecQuerySingleResult2("SELECT count(name) FROM sqlite_master WHERE type='table' AND name=? COLLATE NOCASE", Array As String(TableName)) Return count > 0 End...
  8. E

    B4J Question SQLite Database....How can I find the the number of rows in a table.

    How can i find number of rows in a table in Sqlite Database....Thanks in Advance..
  9. peacemaker

    Android Question DButils: error-free JSON import into SQLite

    HI, All If we have HTTP API and get the JSON reply that should be saved into SQLite DB table - the API may be changed, extra fields can be added into JSON suddently... The SQLite DB structure is always fixed, so the task is to automate any JSON import (insert to or update the table), but only...
  10. MODERN TALKING

    B4J Question SQLite Table Auto-Update

    Hi guys, Is there any way to Auto-Update or Auto-Refresh an SQLite Table in WebView - WITHOUT MANUALLY REQUESTING, such as clicking a Button Like in Erel's Data Collection example: https://www.b4x.com/android/forum/threads/server-data-collection-solution-device-desktop-and-web-reports.37254...
  11. KMatle

    B4J Code Snippet Use Google Drive as a backup solution

    This more a suggestion/idea than a real snippet or other code. If you have installed Google Drive on the PC where you are running your B4J-App (I use B4J as a inhouse server solution with SQlite) it has just a simple folder which you can use like we know it. Just copy backup files to this...
  12. KMatle

    Other Updates for sqlite-jdbc

    Check for updates here: https://bitbucket.org/xerial/sqlite-jdbc/downloads/ Newest version (18.8.2018): sqlite-jdbc-3.23.1 Just copy the newest version to the AdditionalJar folder and delete the old one. Set the reference in "#Region Project Attributes" #Region Project Attributes...
  13. Mashiane

    B4J Tutorial SQLite Triggers: Creating Audit Trails For Dummies

    Ola What is an audit trail? As per Wikipedia... An audit trail (also called audit log) is a security-relevant chronological record, set of records, and/or destination and source of records that provide documentary evidence of the sequence of activities that have affected at any time a specific...
  14. K

    Android Question CustomListView running too slow

    I have same problem again. my customlistview taking more than 4 min for nearly 1200 records of sqlite 7.12.00 7.16.00 my code is : cursor = Starter.year.ExecQuery("select * from GL where FBOOK='G001' order by FDESC") Dim...
  15. K

    Android Question passing field name in function

    i make function to get value of any field :: Sub function(sqlite As SQL,book As String,accode As String,return_field) As String Return sqlite.ExecQuerySingleResult2("select '" & return_field & "' from GL where FBOOK = ? and FACCODE = ?", _ Array As...
  16. K

    Android Question db numeric value

    After inserting numeric value in database and the value is round I have a php code and get value = 152448.52 my b4a code is amt = m.Get("mamt") sql.ExecNonQuery2("INSERT INTO gl " & _ "(fbook,faccode,fdesc,fplace,fitcu,fin1,ftype," & _...
  17. K

    Android Question sqlite and spinner

    Can I add all record of cursor to spinner without using spinner.add(cursor.getstring("accode"))
  18. K

    Android Question MySql to Sqlite

    Hii Expert I want to make app that download data from mysql and insert it into android db file. Plz give me example or sample code. I am new in B4A
  19. N

    Please wrap Objective-C lightweight SpatiaLite library for B4i.

    Need help with the wrap for Objective-C lightweight spatial SQLite/SpatiaLite library for B4i Sample Project : Github project. https://github.com/andreacremaschi/SpatialDBKit. Or equivalent of B4A Spatialite library B4A. https://www.b4x.com/android/forum/threads/spatialite.36296/ Please...
  20. N

    Wish Please wrap Objective-C lightweight SpatiaLite library for B4i.

    Please wrap this Objective-C lightweight spatial SQLite/SpatiaLite library for B4i. Github project. https://github.com/andreacremaschi/SpatialDBKit
Top