db

  1. S

    B4J Question What type should the variable be, when importing Date from DB?

    Hello, it's looks that importing data from mariadb with jRDC is very very strict, causing errors which take a lot of time to understand. (no offence, no doubt I'm the biggest cause) If I import via Select a row from DB and a column has date like yyyy-mm-dd, should the variable where this data...
  2. L

    Italian Caricamento csv in una tabella DB

    Ciao a tutti. Devo caricare un csv composto da 140.000 righe in una tabella. Ci riesco ma il caricamento è molto lento. Ho provato con la libreria DBUTILS ma mi dà l'errore : Uncaught translation error: min-sdk-version >= 26) Esiste un metodo rapido e veloce per caricare tutti i dati? Al...
  3. amorosik

    Italian [B4J] Come realizzare classica DbGrid per visualizzare informazioni da database?

    Supponiamo di voler realizzare il classico 'rubrica telefonica' in B4J Dati su db server qualsiasi, select che tira su una ventina di campi, di tipo (char, integer, data, ..) e dimensioni diverse (char(20), char(2000),...) Esiste un metodo 'classico' per ottenere la classica visualizzazione alla...
  4. 3

    Italian connessione jdbc con host

    buongiorno a tutti, è da un po che tento di collegarmi al mio sqlserver ma non riesco in nessun modo. Public mysql As JdbcSQL Private driver As String = "com.mysql.jdbc.Driver" 'Private jdbcUrl As String = "jdbc:mysql://192.168.0.2:1433/SQLTutorial" Private jdbcUrl As String =...
  5. D

    Android Question How to initialize an encrypted sqlite db created by another app ?

    I have created a database sqlite in vb 2015 with that code: dim cmd as new sqlite.sqliconnection cmd=new sqlite.sqlite.rconnection("Data Source = vetesmart.db;Password = "abcd") Once the database file is on my android phone I would like to read it with my B4A app. How can i use...
  6. WebQuest

    Android Question Open and Save a PDF File In the Database with App.

    Hi I'm trying to select a pdf file in the device with the Chooser as it happens with the images, but without success. My intent is to select a pdf through my app and then save it in the db of the app. I'm using SqlLite for the db. I'm using the chooser specifying the type of file to be selected...
  7. K

    Android Question Copy DB from asset

    Hi expert I'm trying to copy file from asset folder it shows error java.io.FileNotFoundException: /storage/emulated/0/Android/data/com.temp/files/temp1.db (No such file or directory) while Log(File.Exists(File.DirDefaultExternal,"temp1.db")) shows true my code : If File.ExternalWritable...
  8. 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...
Top