Questions tagged as 'sqlite-studio'

1
answer

SQLite - too many levels of trigger recursion

I'm getting the error below when I try to insert into SQLite.    Error while executing SQL query on database 'BDTEST': too many levels of trigger recursion Creating the table CREATE TABLE INSTANCES ( ID INTEGER NOT NULL PRIMARY KEY AUTO...
asked by 23.10.2017 / 15:48
1
answer

How to join records from a table distributed in multiple .sqlite files?

I have several files with .sqlite extension, each containing at least 1000 records totaling about 4,000 records. See how they are distributed: vihicles1.sqlite vihicles2.sqlite vihicles3.sqlite vihicles4.sqlite Inside each fi...
asked by 20.02.2017 / 17:44
1
answer

How to represent in the database (android sqlite), one class that extends another? [closed]

Hello, I'm working on android, I have a case where one table extends another. example: Exercise table - > String dataInicio, String description ....... etc Football table - > String startTime, Int duration ... etc Football exte...
asked by 08.05.2017 / 14:44
1
answer

Error performing a SQLITE table creation

I'm trying the following error: android.database.sqlite.SQLiteException: no such column: np (code 1): , while compiling: SELECT _id, nome, email, np, tipoFunc FROM usuarios ORDER BY nome ASC...
asked by 21.06.2017 / 21:11
0
answers

How can I separate text from a bibliography from sqlite to other columns of the same row in sqlite?

I'm doing a college job where the teacher asked me to get the data from his site " link ", where it contains all the bibliography of his publications, the information about all his publications and organize in a database of automatic way. I was...
asked by 27.03.2018 / 03:25
0
answers

Using SQLite Dates and Hours

I'm having difficulty using dates and times in Sqlite, somehow not saving the data. below my databaseAdapter public class DataBaseAdapter extends SQLiteOpenHelper{ private static final int DATABASE_VERSION = 1; protected static final Strin...
asked by 01.10.2017 / 03:46