database

Hello. I'm writing an app that allows several computers to add new orders to the database. To avoid any conflicts, I want to make sure that when one system is adding a new list of orders, no others can interrupt and will have to wait for the first one to finish up. I understand that the most...

Good day are there any sample application in B4A to do gps tracking and updating a database even when the screen is locked.The app needs to start when the device boot and update at all times.

Hello. Is it necessary to call the "close" method on a database once we're done with it? What about result sets? Is it necessary to close them? Thanks in advance.

Before you start: You need some experience with php, Apache Servers, OkHttpUtils, Lists, Maps and JSON structures. This is an updated example of how to - communicate with a apache server via OKHttpUtils calling a php script - doing MySQL data requests (Insert, Update and Delete) using...

Hola a todos: Estoy empezando a full con B4X... ya hice 3 cursos, y la verdad es que vá de pelos !!... Y en cuanto al pedido este, nunca me animé a registrarme y pedir ayuda... No sé, como que pensé que no me darían mucha bola... (perdón por la expresión :) ) Dispongo de un foro, hecho en php...

I often use Sqlite for my apps and I came across "DB Browser". It's a free tool to browse and edit SQlite databases and tables. Download it from here: http://sqlitebrowser.org/ For B4J apps I recommend you to use the latest sqlite-jdbc-3.21.0.jar file. Get it from here...

Hi! I'm trying to use SQLite as local / remote DB. I have successfully downloaded sqlite-jdbc-3.21.0.jar from the proper server: https://bitbucket.org/xerial/sqlite-jdbc/downloads/ Now arises the question: Where should I put the .jar file in order to get use of it? I haven't found the...

DDL code: [entrCreate] INT NOT NULL DEFAULT (strftime('%s','now') *1000) Make sure that the expression (strftime('%s','now') *1000) is enclosed in brackets.

I've written a tutorial about database modelling and how long queries in a good designed db environment should take. This is a example about using huge databases. What it does: - creates two tables (customers and orders) - inserts 1 million customers and 5 orders per customer = 5 million orders...

This tutorial is about db modelling with a small example. Of course this is just an overwiew and there is much more. I assume you know how to create tables and Co. Databases A db is a collection of related data and it contains tables. Mostly it's called database system like (SQlite or MySQL...

This is a first version of the BindingNavigator Library, which wants to somehow reproduce the corresponding BindingNavigator of VB.NET. What is needed? I want to get something similar to the tools available on VB.NET to link the views to the DB. As in the pictures. A DataSet Class is...

This new library is used to add some functions to the already precious SQL library. Insertion, updating and reading of images in fields of type BLOB. Functions to add a table, a field. Update a field. Delete a row or table. List of tables, fields and typos of the fields contained in the...

How to I set and Get correct DBVersion in SQL Browser and my application. From the sample code below, I get result as 1 meanwhile, in building the database, I set user version as 15. Screenshot below What am i doing wrong. Also included example project If...