sql

  1. 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)...
  2. Marcos Alves

    Android Question Strange Error

    Sub Service_Create 'This is the program entry point. 'This is a good place to load resources that are not specific to a single activity. Log("starting") If File.Exists(File.DirInternal,"dddNorm.db") = False Then...
  3. demonio_jack

    Android Question JdbcSQL and SQL are compatible?

    Hello everyone: Today I have a fairly specific question: Are the JdbcSQL and SQL libraries compatible or not? I have been developing an app (android) using JdbcSQL, as recommended, and connecting to a MYSQL server without any problem. However, for a few days now, I have wanted to add to my...
  4. saeed10051

    B4J Question Update a record in mysql using php

    Hi, i am trying to update a record in an online mysql database. using following php script <?php $conn = new mysqli("pdb48.awardspace.net", "3373050_restaurant", "abc123", "3373050_restaurant"); if ($conn->connect_error) { die("ERROR: Unable to connect: " . $conn->connect_error); }...
  5. BugNot

    Android Question B4A ImageSlider with sql

    Hello, About this, THREAD, how to get images with local sql data base? Thanks
  6. H

    Android Question SQL Error. App force closes when I try to insert a value

    Hi. I'm trying to create a login page where ,when a person clicks the login button and Rememberme checkbox is ticked, it inserts the user credentials in the sql database. but i keep geeting this error. what am I missing? Logger connected to: emulator-5554 --------- beginning of main ---------...
  7. BugNot

    French graphique tableau croisé dynamique

    Salut à tous, Je cherche désespérément un moyen de créer un graphique avec googlechart avec une requete sqlite qui me donne un tableau croisé. ex: mes données résultat de ma requête et le graphique qui devrait ressembler à quelque chose comme ça: J'arrive a faire des graphiques basés sur...
    • BugNot
    • Thread
    • googlecharts pivot table sql tableau croisé dynamique
    • Replies: 8
    • Forum: French Forum
  8. Scotter

    Android Question Basics of including database in my app?

    Hi - I've been out of the loop for a bit and wondering what the latest is in terms of including a database in my application OR being able to connect from a phone that is online to - say an instance of Postgres running on my server? Where is the latest documentation on this for B4A...
  9. I

    Android Question [SOLVED] JRDC2 IN Operator

    Sorry, pheraps this is a noob question.. How can i use IN operator with JRDC2? Dim cmdList As DBCommand = Db.CreateCommand(Query, Array (X,"763043,763054,755123,759006")) This return 0 records This is in properties.config sql.xxx=SELECT Cat, prod, x FROM supprod where id = ? and...
  10. Chris160179

    B4R Question ESP8266 connect to mySQL and copy to global variable

    Hello everybody, i need a little bit help. I know it is not the best idea to connect a ESP/Arduino to a SQL Database but i need this to reduce the complexity of my project. There are better and faster Solutions like this...
  11. P

    B4J Question HTML data to SQL

    Hi everyone, I'm possibly being very slow here but web dev isn't something i've done much/any of... The aim is to try and get 2 text box inputs to be written to a database when a button is clicked. Dim tabParam As ResultSet = Main.IntSQL.ExecQuery("SELECT * FROM TabletParameters;") Dim...
  12. D

    Android Question SQL Search on multiple columns

    I have a database that has Arabic words, so the text is unicode utf-8 encoded. I want to search for a word in all columns. I read a specific word from the database, and then search the same word. If I search on one column I get a result. If I search on multiple columns, I don't get the result...
  13. fprobst

    B4J Question [SOLVED] MS SQL Stored procedure - return value

    Hello, I am using a MS SQL Server an useing the library "SQLCallPRoc Version 1-10" from keirS I have the following stored procedure: CREATE procedure [dbo].[sp_TMS_BuchenPersKommt]( @cPersNr char(10), @dDatum AMSDate, @dZeit AMSTime, @cGrund char(1) ) as begin set...
    • fprobst
    • Thread
    • ms sql server return return value sql stored procedure
    • Replies: 2
    • Forum: B4J Questions
  14. Sandman

    We all have a friend in SQL

    I saw this thread... Taking SquareRoot in SQL https://www.b4x.com/android/forum/threads/taking-squareroot-in-sql.110722/ ...and thought of something else I saw a while back on the internets. A 3d engine, written in SQL. This is something I would categorize as both completely insane and...
  15. R

    Android Code Snippet Taking SquareRoot in SQL

    SQLite doesn't have SQTR as a standard function, so you would normally do this in code. There is a way though to do this in SQL with a CTE: strSQL = "update Table1 set xValue = (" & _ "with Guesses(FindRootOf, " & _ "guessRoot) as (" & _ "select xValue, " & _ "case when xValue...
  16. MARCO C.

    Italian 2 jobdone() in esecuzione ??

    Buongiorno, avete presente questo post https://www.b4x.com/android/forum/threads/mysql-su-aruba.62942/ tutto ok , con il file connessione.php inserito nel server e il seguente codice che lo richiama fraseSql = "SELECT id, idcall, item, qt, prz FROM `app_servicerow`...
  17. Jorge M A

    B4J Question [SOLVED] SQLite Built-in Window Functions?

    Why is it not possible to run a query against SQLite that contains functions like row_number() or rank() ? e.g. Dim RS As ResultSet=Sql1.ExecQuery($"SELECT ROW_NUMBER () OVER ( ORDER BY cid ) RowNum, ostatus, cid, itemcount FROM orders;"$) Error in Log: DBeavear and DB Browser for SQLite...
    • Jorge M A
    • Thread
    • built-in window functions rank row_number sql sqlite
    • Replies: 4
    • Forum: B4J Questions
  18. P

    B4J Question mysql resultset to xml

    So I'm most likely just being a bit thick today but i can't get my head around how to get this to work; The aim being to have an xml builder populated from a database. 'Handler class Sub Class_Globals Private mreq As ServletRequest 'ignore Private mresp As ServletResponse 'ignore '...
  19. behnam_tr

    B4J Question how combine two sql query

    hi i want to combine two sql query Dim RS As ResultSet=Sql1.ExecQuery2("SELECT * FROM tbl WHERE userid = ? ", Array As Int(uid)) Dim RS As ResultSet=Sql1.ExecQuery2("SELECT * FROM tbl OFFSET LIMIT ?,?",Array As String(0,10)) how do i this ??
  20. S

    Android Question How to make SQL object reusable

    I am using SQLITE with B4A. I am using the database in multiple activities. I have created a service to contain my database object. StartAtBoot is set to True. sqlManager #Region Service Attributes #StartAtBoot: True #End Region Sub Process_Globals 'These global variables will be...
Top