sqlite

Hello, today is my 3rd day using this wonderful tool, and I would like to create a simple program, for example, an Product Inventory. Let me explain: The program should have the capability to establish a connection via jrdc2 to a server, enabling the seamless transfer and creation of a table...

Hi, I want to ask. I run query on SQLite SELECT sqlite_version() and it return 3.22.0. I want to update the SQLite to 3.25.2 (at least, latest if possible) because I want to use Row Number feature that was released on that version. Is there any way to update?

Hi, I want to ask a little question. I have a project that take 8 image using camera intent. I put the picture in B4XImageView, after that I get the bitmap and save it to SQLite. Few reason why I must save to SQLite. - I need to send this bitmap (will be converted to Base64) to web server via...

I am successfully using SQLite in my application. Requests are processed and tables are updated. I wanted to make a "filter" that would save me from duplicating records. 1. I created a checksum field - CRC. 2. Made this field CRC as primary key. I specified a condition in the request if we are...

As I don't use SQLite (or any other SQL) all the time and am no database expert, it's always a bit of a challenge to get the SELECT syntax right, specifically when relationships between tables (JOINs) come into play. There's that, and the fact that it was fun to develop (and I wanted to have the...

Hello, I share my application to create task lists. If you want to try it, you can download it from here. The source code is also for sale at the following link: https://b4xapp.com/item/todolist-source-code- features: sqlite database Notification when a task is due or overdue Beautiful UI...

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...

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...

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...

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)...

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...

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...

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

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...

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...

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...

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 share it with you guys !!! Well a big reason for that price is in Greek Language... but not difficult to understand the code and what you can...

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...

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...

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...