sql

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

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

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

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

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

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

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

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

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

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

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

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

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); }...

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

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

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

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