sqlite

  1. DALB

    Android Question NO TABLE BUT THE TABLE EXISTS :android.database.sqlite.SQLiteException: no such table: pvpt ...

    Hello. Developing an app for weeks, I run it many times without any problems, bringing new features every week. This day, it stops running with this arror: What is interesting is that I never changed anything about the pvpt table for a long time. I work on other activities. My starter...
  2. Claudio Oliveira

    B4J Library SQLite JDBC - Library version updates

    Hi everybody! This thread is supposed to get all SQLite JDBC library version links together so as to find and download them easier. As a heavy B4J+SQLite user, I'm always looking forward to have new JDBC versions. All information contained herein has been taken from Mr. Taro L. Saito (xerial)...
  3. M

    Android Question Cursor size too big

    Hello! I'm getting this error when I do a SQL Select from a pretty big table in sqlite I can use without a problem the row 0 and row 1 but when c.position=2 it crashs Is there a way to know the whole cursor size? Thank you!
  4. 2SucresCelestin

    Android Question Print a picture in CLV from a URL obtained from an SQLite DB

    Hello, I wanted to print some images obtained from a URL stocked in a SQLite DB. I don't really know how to do it. i implemented some code in job done to apply images into panel's image views but still having issues. Some one knows how to do it ? Sub JobDone(Job As HttpJob) If Job.Success...
  5. DALB

    Android Question SQLITE returns 0 result

    Hello, I have a little problem I can't solve, here. with these lines... synt="SELECT * FROM bnotes WHERE " & spiChoix & _ " LIKE ('%" & filtre.ToUpperCase & "%' OR '%" & _ filtre.ToLowerCase & "%' OR '%" & filtre & "%')" curs=Starter.sql1.execquery(synt)...
  6. Razmehr

    Android Question search quwery

    I'm very new to android studio so forgive me in advance if my question is not smart. I'm trying to create a dictionary (Pahlavi language to English). When I run the app it works almost perfectly, the only issue is that I'm not able to search for some of Pahlavi alphabet e.g (ā, č, ē) it only...
  7. R

    Android Question App crash, but no information

    Using this code to write large .csv file to SQLite: Sub CSV2Table3(strFolder As String, _ strFile As String, _ bFileHasFieldNames As Boolean, _ arrFieldNames() As String, _ 'this will be provided by GetCSVProperties btSeparatorByte As...
  8. D

    Android Question upload image from memory to sqlite

    Hello Couldn't find a similar question on the forum on my own, sorry. Is there a way to upload a photo from my phone to SQLite? So that the user can see the gallery and select a photo. I will be glad for any help.
  9. adriano.freitas

    Android Question "This app was created for an older version of Android and may not work properly..." message

    Helo! I'm starting programming with B4A. When my first app runs, it checks if the database exists. If it doesn't exist, create it. If there is, use it. Everything works, however, when the database does not exist and he has to create a new one, the mobile application generates a message that...
  10. SMOOTSARA

    Android Question Add columns to the sqlite table

    Hello friends 🌹 I have a sqlite database "master.db" with a table "table1" The columns of the table are: " ID, first_name, last_name" I want to check if there is no "phone_number" column, add it and save a data in "phone_number" column . (with coding sqlite commands in the program) 1_How...
  11. Guenter Becker

    Android Question SQLite Crypto

    Hello to you, I'm working with SQlite Version 3 and as known this kind of database has no encryption or password protection. But there is an enhanced clone of the native database as a GitHub Open Source Project is's called SQLiteCipher. The Documentation says that it is working like a standard...
  12. S

    Android Question Import or read db with 1.000.000 and more records

    Hi, i have a csv file with 1.000.000 and more records. My initially idea is read and copy the records into my sqlite database, because i want my records locally, but the file is too big and the app crash (450 mb). What is the best way to copy locally or it's better to read remotely this file...
  13. gezueb

    B4J Question B4j Sqlite missing write permission?

    I have made an B4j programm that reads and writes into a local sqlite database. The database is located in the path c:/sql in a windows 10 installation. The program works perfectly when compiled and executed in the IDE. However, it fails to insert data into the sql database (without exception)...
  14. S

    B4J Library Open street map viewer

    see https://www.b4x.com/android/forum/threads/open-street-map-viewer-gps.127827/ a B4Xlib for B4A and B4J to view Open Street Map
  15. S

    B4A Class Open Street Map viewer - GPS

    Hi, This b4Xlib contains a custom view (cvMap) which can display Open Street Map. The tiles are retrieved from the internet and cached in a database. You can add shapes and images on the map. UI : - Lat/lng Center of the map - Zoom Level - Compass Direction with rotation - Scale - Button...
  16. LucaMs

    B4i Library [B4X] lmB4XComboBox

    Version: 1.04 02/03/2021 https://www.b4x.com/android/forum/threads/b4x-lmb4xcombobox.116767/post-729765
  17. LucaMs

    B4J Library [B4X] lmB4XComboBox

    Version: 1.04 02/03/2021 https://www.b4x.com/android/forum/threads/b4x-lmb4xcombobox.116767/post-729765
  18. Daniel44

    Android Question [SOLVED]How to Sum the items of a listView (Not count them)

    Hi everyone I'm working with a listview (I know that I must not be working with a lv but a clv but I guess If I work wit a CLv I'd have the same issues:)) I fill it by adding addTwoline with spinners value (spName and spPrice) LV1.AddTwoLines(spName.SelectedItem,SpPrice.SelectedItem) and...
  19. D

    B4J Question Sqlite - LIKE case-insensitive for not English letters

    here is my sample code, but the result is not as expected #Region Project Attributes #MainFormWidth: 600 #MainFormHeight: 600 #End Region #AdditionalJar:sqlite-jdbc-3.32.3.2 Sub Process_Globals Private fx As JFX Private MainForm As Form Private SQL As SQL End Sub Sub...
  20. M

    Android Question select date values stored as numbers from sqlite db

    Hi, I store date values as long in a table of sqlite db. Now I would like to select data with the certain date, picked with B4XDateTemplate. So I have a date in format "dd.MM.yyyy". I try with this code, without success: Try DateTime.DateFormat="dd.MM.yyyy" Dim strgDate As...
Top