sql

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

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

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

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

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

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

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

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

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

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

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

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 ??

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

Hello, I like to get a suggest of method, regarding best practices for my App : 1/ i have an SQLITE db that contain general setting strings and language strings for its operation, and independent of user data. I systematicaly copy that DB from asset dir to Internal, so even after app updating...

Colleagues, I'm pretty worried, I should do this migration from SQLCiper V1.50 to V1.60, as we all know from the 64BIT binary. The problem is generated because the database created in V1.50 will not be compatible with V1.60, so as I do to pass that data to the new database when updating the app...

Hello, I have a problem is that I do not understand at all how to "Block" an HTTP request because I use Wait For (Resumable). Look at the case: I select my items from my local database, and then I send the data to an API but they are not sent properly because, as it is a "non-blocking" event...

I am working on the SQL tutorial at https://www.b4x.com/android/forum/threads/sql-tutorial.6736/#content I seem to have pretty much understood the example project. Now I am modifying it to get to what I need. I have this grid showing data, a bit like a spreadsheet, and the user may modify one...

Hello everyone, My app is an ordering app, so the buyer contacts the seller and once the seller send the buyer a message and he is not online the app should send a notification. The problem : The notifications Not always are being sent and the services some times it works and sometimes it just...

Hi there, I want to share a tactic / a small guard for MySQL/MariaDB DataBases.. Well all we know that having a Database online and not in localhost is difficult to protect from brute force attacks / ransomware attacks... Well i ll give a little "pebble" to help others to think / different -...

Buenas, soy nuevo en este mundillo y tengo un problema con mi código. Expongo la situación: Estoy trabajando en una aplicación de listados de fallos. A través de una base de datos .db muestro en un list view los fallos. Mi problema es que cuando hago clic encima de un item del list view quiero...