sqlite

  1. B

    Android Question SQLite not updating after exit program

    Hello, I have an Android app that I created a year ago. It does updates to a SQLite database installed with the app. It worked fine on Android 10 but with Android 12 when we make changes and then exit the app the changes are not saved. When we restart the app it starts with the data just like...
  2. Guenter Becker

    Android Question SQLite & SQLCipher Error Trapping

    Hello, hope you are all fine. Today my question to the professionals is concerning the use of SQL or SQLCIPHER Library. If we do any sql action via the library like an insert a.s.o. it might be possible to fall into an error situation because for example we are going to insert a record with a...
  3. Guenter Becker

    B4A Library TDDBUtils Functions to handle SQLite and SQLCipher

    Library: TDDBUtils.b4xlib Language: B4A Version 1.8 Manual: Version 1.5.2 (did some checks and improvements, added SQLCipher tutorial) Status: Work in Process (C) This library is free for non commercial use other use see manual. New to 1.8: optimized code fixed some errors Added grouping and...
  4. L

    B4J Question TableView crashes after 100 refreshes

    Lectori Salutem, I've run into this oddity where a tableview crashes after it has been reloaded exactly 100 times. It's no use to do it in a loop, that doesn't refresh the table properly but when you click the button 100 times and let the table reload properly the app crashes (not joking)...
  5. Alessandro Zuppa

    Italian Modulo DBRequestManager per VB.Net

    Buongiorno a tutti Mi trovo con un problema che devo risolvere velocemente. Ho un server dove si trova un applicativo web (fatto in Python e al quale si collegano diversi tablets), un paio di applicazioni VB.Net, e l'applicazione jRDC2 che mi consente di connettermi con dei palmari con...
  6. LucaMs

    B4J Library [B4XLib] lmB4XSQLiteDump

    Based on this @KMatle's tutorial, this library allows you to dump SQLite database tables. I used this yesterday to create the import-export feature of my lmSnippetManager DB. Paying attention to which tables to import first, due to the relationships, it is sufficient to replace the instructions...
  7. LucaMs

    Android Question SQLite SOUNDEX

    Is there any way to activate SOUNDEX in SQLite? android.database.sqlite.SQLiteException: no such function: SOUNDEX (Sqlite code 1): , while compiling:... https://www.sqlite.org/compile.html#soundex
  8. Guenter Becker

    B4A Library TDDButils Database Management for SQlite and SQLiteCipher

    Name: TDDBUtils Type: b4a, b4xlib Version: 1 (C): TechDoc G. Becker Royalty Free for Personally/Commercial use for B4X Board Members This additional B4A library makes the live of standard Database Management for SQLite (unencrypted) and SQLiteCipher (encrypted) Databases a little bit easier...
  9. Magma

    Share My Creation EasyCode - Form/B4XTable Generator with no writting code [B4A] [B4J]

    Well, I ve decided to create a Form-View Generator (B4J - B4A)... that creates Forms with B4XTable + with no writing code at all... The Designer is in B4J (like FormBuilder), the produced code/files working at B4A too !!! Well.. after one month of programming... I want to share / sell my...
  10. A

    Android Question What is the best SQLite data browser to use?

    Hello! Can you please tell me which SQLite data browser is preferable to use today? My database consists of several tables with a fairly complex structure with not very many records. I see a lot of bad reviews for the classic ""DB Browser for SQLite"", but maybe users didn't explore it well...
  11. Magma

    Share My Creation Simple Database Application in B4J (a Catalog for Car Parts)

    Hi there... This is a very simple but very helpful application (for those want to know B4X and use it for CRM,CRUD,business general apps etc) I wanna sell/share with you guys only for 5$ - special price !!! Well a big reason for that price is in Greek Language... but not difficult to...
  12. J

    Android Question Row too big to fit into CursorWindow

    Hello! I'm getting this error when I do a SQL Select from in SQLite. The data is not big, the query only selecting 3 columns and getting 8 rows of data. android.database.sqlite.SQLiteBlobTooBigException: Row too big to fit into CursorWindow requiredPos=7, totalRows=8 at...
  13. Mashiane

    Share My Creation [BANanoVuetifyAD3] BANanoServer - DirectSQLite CRUD

    Ola Download Successfully implement a direct SQLite connection for BANanoVuetifyAD3 BANanoServer SQLite and did some crud. This depends on BANanoVuetifyAD3 Version 6.05 Update 15. NB: This uses jSQL DataSource Connection Settings This shoul be uploaded soon...
  14. 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...
  15. 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)...
  16. aeric

    Share My Creation Web API Template

    Web API Version: 1.14 Description: A boilerplate for creating REST API Server with database CRUD functionalities. Depends on following libraries: ByteConverter, JavaObject, jServer, Json, jSQL Features: CRUD based - RESTful Web API (GET, POST, PUT, DELETE) Front-end (HTML, CSS, JS...
  17. 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!
  18. 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...
  19. 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)...
  20. 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...
Top