sql

  1. I

    iOS Question Accessing a database residing on a Local Network Pi Server

    Hi All, I have a requirement to use a Raspberry PI as a Local DB server, but I need to support both Android and iOS clients. I was looking at this post: https://www.b4x.com/android/forum/threads/mariadb-does-not-wait-for-query-results.132054/post-833507, and it seems to be straightforward with...
  2. P

    German SQL - Update autoincrement-Feld

    HAllo, gibt es in B4A eine Möglichkeit, z.B. nach dem Löschen von Datensätzen, die Reihenfolge eines autoincrement-Feldes wieder upzudaten. Was ich bisher im Web gefunden habe funktioniert anscheinend unter B4A nicht, ich erhalte ich eine Syntax-Fehlermeldung. SQL1.ExecNonQuery2("ALTER TABLE...
  3. G

    Android Question Mylocation example pauses

    Hi, I am using the example in https://www.b4x.com/android/forum/threads/background-location-tracking.99873/#content. I added the required line to my manifest. The app pauses when the screen turns black. I did not change a thing besides that I added a SQL table that holds some data and when...
  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. B

    German Daten an SQL Server

    Hallo, ich habe eine App geschrieben, welche einwandfrei funktioniert und Daten über Bluetooth empfängt und diese in eine SQL Datenbank mithilfe der SQL Bibliothek schreibt. Dies funktioniert alles super. Nun wäre es super, wenn parallel dazu alle Werte, welche in die lokale SQL Datenbank...
  6. R

    Share My Creation Remote SQL Server Interface

    I have been using other people's work on this site for a number of years as I tried to learn how to code in this environment. I recently retired from a career in data collection programming involving writing applications to capture data from the shop floor and updating a remote sql server...
  7. Col

    Android Question SQL Builder - is a Library needed?

    I sometimes build long complex SQL statements from code, and it takes a lot of effort to code and test, so figured why not build a class to do it for me? Here's a very simple class (the example is in B4J) to build SQL statements from code. It consists of a very basic screen (only needed for the...
  8. R

    Android Question How to replace SQLite database after installation?

    Hi all, When my app is initially installed, it comes with a SQLite database. I'm working on code that allows end users to replace this SQLite database after the app has been installed - I would have them download and save the new database to the device's "Downloads" folder. During the...
  9. behnam_tr

    B4J Question [Solved] SqlLite , How Select data per month ??

    hello my friends I have the following database table and I want to extract the Monthly profit (from the profit column) information with the optimal code. Does anyone have a solution ?? In fact, how many profit did we have per month? like this : Month 1 >> 250,000 $ Month 2 >> 300,000 $ ...
  10. S

    B4J Question ABMaterial - cannot get logged into the database

    It looks like I am a little late to the ABMaterial party but it seems interesting so I am trying to work through the tutorial. I am also VERY new to B4J so trying to learn it as well. I really like it so far. The issue I am experiencing is with lesson 3 where it connects to a mySQL DB. I...
  11. J

    B4J Question Question about parameterizing queries

    I can't seem to figure out how to deal with dates and "in" clauses for parameterized queries. I'd be grateful if someone could tell me how to do it. Thanks Date I have a date in string format, Postgresql wants that wrapped in apostrophes in order to accept it into a timestamp field Dim...
  12. Guenter Becker

    Android Question SQLite Crypto

    Hello to you, I'm working with SQlite Version 3 and as known this kind of database has no encryption or password protection. But there is an enhanced clone of the native database as a GitHub Open Source Project is's called SQLiteCipher. The Documentation says that it is working like a standard...
  13. S

    B4J Library Build parametized SQL queries for Insert,Update and Delete

    This is a small class to easily build SQL queries declare an instance of the class clBuildSQL and initialize it Private fBuildSQL As clBuildSQL .... fBuildSQL.initialize Insert record Just pass as first parameter the table name and as second parameter a map with pairs keys/values...
  14. S

    B4A Class Build parametized SQL queries for Insert,Update and Delete

    This is a small class to easily build SQL queries declare an instance of the class clBuildSQL and initialize it Private fBuildSQL As clBuildSQL .... fBuildSQL.initialize Insert record Just pass as first parameter the table name and as second parameter a map with pairs keys/values...
  15. 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...
  16. Guenter Becker

    Other Observable from Informatix - New Demo #4

    Hello, a long time I looked for a more automatic handling of database driven application like binding views to a record and more. I searched the forum but did not found any answer. Why? The answer is my question was wrong! The good information I found an other member of the forum who lead me to...
  17. SoftSpot

    Android Question Load an Image from MS Sql Server into customlistview

    I am having trouble loading an image (sql type: image) into my customlistview. Without the Image code all works fine, I would appreciate some here as I an running into walls. #Region Activity Attributes #FullScreen: False #IncludeTitle: True #End Region Sub Process_Globals 'These...
  18. johnmie

    Android Question SQL insert into enigma

    My DB table has 5 fields (see attached) When I try to add a record like this **200915, 862, 122, Anves3, ka¦116¶pr¦25¶aq¦89¶ch¦64¶ft¦1¶ca¦5** with sql2.ExecNonQuery2("INSERT INTO history VALUES (?, ?, ?, ?, ?)", _ Array (Q.heute, Q.currentID, wtS.text, nName, A)) and then read it...
  19. A

    iOS Question SQLCipher library for B4i

    Erel, is there any chance B4i will have a SQLCipher library or something like that to secure a database content? Thanks.
  20. rgarnett1955

    Android Code Snippet Tip: B4a SQLite Database Potholes - WAL File Checkpoint

    Hi B4X'ers I just thought I'd post this tip to warn of a problem I came across when using an sqLite data base created and populated using sqLite Studio. The steps I used were. Created an sqLite db using sqLite Studio on Win 10 pc Set the DB to use the Write Ahead Log journal method (WAL File)...
Top