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