database

  1. MegatenFreak

    B4J Question Using jSQL to Lock a mySQL table for writing

    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...
  2. Cornelius Smit

    Android Question GPS Running and tracking in background

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

    B4J Question Necessity of closing databases and resultsets?

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

    B4J Tutorial Updated MySQL & PHP example

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

    Spanish App-->SMF Alguna idea...

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

    Android Tutorial [B4X] Create and use SQlite databases with "DB Browser"

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

    B4J Question jdbc_driver Folder

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

    Android Code Snippet Create SQLite field with default "date now" in milliseconds

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

    B4J Tutorial [B4X] SQlite with 6 million rows

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

    Android Tutorial [B4X] Database modelling

    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...
  11. Star-Dust

    B4A Library SD: BindingNavigator (Sqlite GUI Navigator)

    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...
  12. Star-Dust

    B4A Library SD: SqliteExtra

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

    Android Question DBUtils DBversion doesnt return user version set in Sqlite

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