database

Hi all, As you know, only a few months before the obligatory switch to targetSdkVersion 29. I have 2 applications with database, one free and one full. Until now, in the free, my database is in File.DirDefaultExternal, and when the user installs the complete one, I copied the database from...

Does anybody have some running JRDC2 code that does this? I've been trying to adjust the code without luck. The client application connects to a central database (database 1). The result from the query is the name of the database and the location of the database on the server (full path + name...

B4X: dim fc As FileChooser dim sql as SQL fc.Initialize fc.Title="Select File" 'title of the dialog box fc.setExtensionFilter("MDB file", Array As String("*.mdb")) myfname=fc.ShowOpen(RemoteResultform) 'myfname contains the full path...

Hi I am reading some data from my sqlite database and I try to create a pdf file from them. I use the instructions base on this https://www.b4x.com/android/forum/threads/printing-and-pdf-creation.76712/ The data I store in database are in Greek language. When the pdf file created without any...

Hi to all the tests continue In my app at first I create the navbar with a single component, basically an icon with the name of the working database B4X: Sub BuildNavDrawer '*copy code after this line vm.Drawer.Setwidth("300") vm.Drawer.Setvisible(True) 'this page should show on...

I'm getting this error again. B4X: Error occurred on line: 479 (MysqlEntrySync) android.database.CursorWindowAllocationException: Cursor window allocation of 2097152 bytes failed. # Open Cursors=920 (# cursors opened by this proc=920) at...

Hi guys, Just want to share my experience with Google Cloud Platform. I got a free trial with a free credit valued US$ 300. So, I created a compute engine to create my own VPS for my jRDC server. It was running OK for about a 90 days, and than, one day, before lunch time, I made some new...

In searches, I've come across a fair few people wondering how to detect if a message is just emoji so that, like WhatsApp, it can be displayed in a larger font if necessary. So I thought I'd share my solution to this. Background: all the messaging between apps and site users goes through the...

SDK 29 has the following feature: No permission to access File.DirRootExternal, even with the STORAGE permission. There's workaround for the manifest files, but it's temporary and issue will just be postponed to SDK 30. I have suite of apps, composed by 2 different apps: a "writer", that...

This tutorial shows how we can export data from a MS Access database to MS Excel workbook. As a former professional Excel developer I highly recommend to use templates in MS Excel. Although jPOI cannot handle real templates (*.xlt) in MS Excel there are some advantages of using a standard...

Hi Experts, In the past I created an app with B4A to connect to a Remote MS SQL database using the jtds-1.3.1 library. I am now wanting to create the same app for ios devices using B4i. I was informed though that B4i does not support jar files, so my question is, how can I connect to a remote...

Hi All, Please note... I have read all (or as many as I could find) threads regarding jRDC2 but I'm still somewhat confused about what I should be using. :confused: I'm playing with an ABMaterial app, which is working beautifully when I'm running it using USBWebserver with a MySQL database...

Hi, is there any way to convert a date and time strings to a format acceptable to an SQL database holding it in DateTime type / format, i.e. I have two input fields Date and Time which the user can fill in, i.e. Date: 2020-07-27 and Time: 18:33 but I wish to save them to a MySql database which...

Hi there - i am trying to connect to my Mariadb sql database... but.. I am getting this : Sub NOT FOUND: 'mysql_status not Connected to Database Maybe didn;t understand well.. i am using the following to connect: B4X: Sub Process_Globals 'These global variables will be declared once when the...

One of the great features of bbcodeview is its dynamism in content adaptation; whenever it is visible, text is drawn while content is removed when it becomes invisible. However, when text drawn from database is empty, bbcodeview seems to create empty row space for each empty database row as...

How can one display all records from Mysql database in BBcodeview ?. I don't know why BBcodeview can't display all records from MYSQL and PHP database or am i the one who is not handling it well?. I have used different approaches, but each ended up displaying only last record in bbcodeview. I...

Hi I haven't used B4J yet but I need to create a program that will connect to a database held on my web server, I have been in contact with the tech support and they state I must have an API to use the data held in the database. The data is updated via a third party app , I know my server name...

Limitations all the desired databases should be in the same server. JRDC2 Server side modifications B4X: Private Sub ExecuteQuery2 (con As SQL, in As InputStream, resp As ServletResponse) As String Dim ser As B4XSerializator Dim m As Map =...

I did not find support for Firebase realtime database in b4i ( a library): iOS Question - Firebase Realtime Database Hi, Just wondering if there are any plans to integrate the firebase realtime database, please? I have an IOS app I need to do, which will hopefully user the reatime database...

I did not find support for Firebase realtime database in b4i ( a library): iOS Question - Firebase Realtime Database Hi, Just wondering if there are any plans to integrate the firebase realtime database, please? I have an IOS app I need to do, which will hopefully user the reatime database...