Questions tagged as 'sqlite3'

Tagged questions
1
answer

SQLite3 does not fail to insert nonexistent reference

I am working against a database in SQLite3 and I was surprised to be able to insert a line with a reference to another table in which the corresponding row with the foreign key does not exist. The following minimum example illustrates the sit...
asked by 07.01.2016 / 09:17
1
answer

Can I save the BD SQLite in android in another route instead of / Data / ...?

I would like to save the BD of my mobile application in another folder that was not the normal path of / data / .., for example in the sdcard in a route that I can specify.     
asked by 26.10.2016 / 02:43
2
answers

Undefined index in php and SQLite3

I need help with an error, I am inserting data in a table called "posts" but it gives me the news that in certain fields where null is allowed, it says "Undefined index ... in ....... .... " I do not understand why this error occurs if these f...
asked by 12.02.2016 / 04:51
2
answers

Several Primary Key in SQLite3

Hello, I want a table in SQLite that has 2 fields as primary key and also a field% co_of% that is unique integer. What I've been looking for is something like this: create table t (id integer, name string, phone string, nick string PRIMARY KEY...
asked by 11.08.2016 / 20:44
1
answer

How to automate the file name in bat file

The following code opens a db file (sqlite language) and exports the resulting query to a file on my desktop. Up here all good. What I want is for the file name to be different every time the batch is executed. sqlite3 -cmd ".headers on" -cmd...
asked by 30.08.2018 / 17:43
2
answers

Hibernate with sqlite [closed]

I am developing a desktop application and I want to do it using Sqlite e Hibernate . Does anyone know if it is possible to integrate Hibernate with Sqlite3 ?     
asked by 17.12.2015 / 13:23
1
answer

How can I store a data from a column of a sqlite database in a variable using Python?

I have a problem I am trying to get a value from a database in sqlite3 using python: import sqlite3 #Conexion a la base de datos con = sqlite3.connect("basededatos.db") cursor = con.cursor() #Comprobar conexion a base de datos cursor.execute...
asked by 23.08.2018 / 12:54
0
answers

What is the best way to encrypt a database (SQLite - Android)? [closed]

I imagine two possible ways of encrypting a database, encrypting the data by means of a class in charge of encrypting and decrypting or some mechanism that performs it automatically but I'm not sure what to use.     
asked by 20.10.2016 / 23:19
2
answers

Query C # a SQLITE

I have the following Database CREATE TABLE [Request] ( [IDRequest] INTEGER PRIMARY KEY NOT NULL, [RequestID] VARCHAR(10) NULL, [ReceivedDate] VARCHAR(20) NULL, [RequestStatus] VARCHAR(20) NULL, [ExpirationStatus] VARCHAR(15) NULL, [Respo...
asked by 04.08.2016 / 22:24
1
answer

How to modify the Sqlite Path

I can not change the path of SQLITE . I set up a database in android studio and the class that extends from SQLiteOpenHelper I have: public Constructor (Context ctx){ super(ctx, NombreBase, null, 1) }...
asked by 19.12.2017 / 04:06