database

  1. 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...
  2. 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 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...
  3. C

    Android Question Can I modify a custom type, while it's already used in a database list?

    I'm using a custom type that consists of keys like title, text, datetime, keywords etc. My simple "database" is just a list of hundreds of these. The problem is that as for now I'm using their Unix times to identify them, and that was a big mistake, as due to how the app works there will be...
  4. Guenter Becker

    Android Question Can not copy/open database?

    Hello, hope you are fine. At present I have a probleme that I did not have before updating b4a suite to 11.20. and I need professional help. Sub Process_Globals Public SQLite As SQL ' Database object Sqlite Version 3 End Sub Sub Service_Create Try ' # copy...
  5. 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...
  6. Guenter Becker

    B4A Library extDBUtils

    Warm welcome to the audiance I hope you are well. Since Erel published DBUtils development of database driven app has become much easier. Very good job done! But who says that good work could not be polished up to get better? Every time I am using DBUtils I have to develop addional...
  7. 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...
  8. A

    Android Question "Name already used please try another name!" how to fix this?

    im makeing a app to database record and when i input a name "John" for example and there is already a record in database john its says "Name already used please try another name!" how can i remove it? im using dbequest manager and jrdc btw Sub GetSelectedRecord (NameSelectedItem As String)...
  9. 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...
  10. 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...
  11. M

    Android Question "Heavy work" and freezing - multithread?

    Hi everyone, I've an app that need to download an huge dataset. We are talking about making a http request the return a json of 8000 rows, that need to be stored in a local SQL DB in the device. Now.. the problem is the following: downloading and storing all the rows in the DB takes a while...
  12. 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
  13. 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...
  14. LucaMs

    B4i Library [B4X] lmB4XComboBox

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

    B4J Library [B4X] lmB4XComboBox

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

    Italian DATABASE in remoto con B4A

    Buongiorno a tutti, dovrei realizzare una APP dove deve scrivere dei dati su un DATABASE che sto aprendo su ALTERVISTA. Ho frequentato un corso base di B4A tramite UDEMY, ora vorrei sapere se c'è un tutorial per vedere come accedere al DATABASE e come scriverci i dati una volta contenuto. Ho una...
  17. O

    Web/Database recommendations for prototype

    Greetings all To show proof of concept I need to make a simple web page, that connect to a database, which then the clients (B4A and B4I) connects to, in order to exchange data and receive tasks ect. I’m not much of a DB man (but I can if needed be hack my way through it), and certainty not a...
  18. A

    Android Question Example for LazyLoading from jRDC2

    Hi All, I can load/SELECT ALL data in a table from jRDC2 (mysql DB) with no problem, but I think this is not perfect in case of thousands of rows to return/SELECT from App performance standpoint, also I am aware that I can use LIMIT to limit the number of rows; however I am not sure how to...
  19. LucaMs

    B4J Library [B4X] lmB4XComboBox

    lmB4XComboBox is a b4x library (https://www.b4x.com/android/forum/threads/100383/#content). It works with B4A, B4J and B4i. It is a modified version of the Erel's original B4XComboBox and allows you to store in it a value for each text item. Not rarely (mainly handling DB data) you need a...
  20. rleiman

    Android Question Free database to lookup grocery item barcodes

    Greetings, I have a requirement from a customer who wants me to make an app that looks up the barcode from grocery items and extracts details such as the product name, photo of the product, etc. from a free trusted web site. I plan to use the b4aZbarBarcodeScanner to read the barcodes. When I...
Top