sqlite

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

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

Web API Server Version: 1.16 Description: Create Web API Server with CRUD functionalities Updates: Web API Server 2.0 is available https://www.b4x.com/android/forum/threads/project-template-web-api-server-2.143310/ Depends on following libraries: ByteConverter, JavaObject, jServer...

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!

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

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

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

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

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.

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

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