Most voted "sqlite-studio" questions
Sqlite Studio is an open source Sqlite database manager.
Learn more…5 questions
Sort by count of
-
2
votes1
answer345
viewsHow to join records from a table distributed in multiple . sqlite files?
I have several files with extension .sqlite, containing every 1 at least 1000 records thus totaling about 4,000 records. See how they are distributed: vihicles1.sqlite vihicles2.sqlite…
-
2
votes1
answer173
viewsSqlite - Too Many levels of Trigger recursion
I’m getting the error below when I try to make an insertion in Sqlite. Error while executing SQL query on database 'BDTESTE': Too Many levels of Trigger recursion Table creation CREATE TABLE…
-
1
votes1
answer55
viewsHow to represent in the database (android sqlite), a class that extends another?
Hello, I’m working on android, I have a case where a table extends another. example: table Exercise -> String dataInicio, String description ...... etc table Football -> String timeInicio, Int…
-
0
votes0
answers168
viewsHow to use Dates and Times in Sqlite
I’m having trouble using dates and times in Sqlite, somehow not saving the data. below my databaseAdapter public class DataBaseAdapter extends SQLiteOpenHelper{ private static final int…
-
0
votes1
answer385
viewsError while performing an SQLITE table creation
I’m trying the following mistake: android.database.sqlite.SQLiteException: no such column: np (code 1): , while compiling: SELECT _id, nome, email, np, tipoFunc FROM usuarios ORDER BY nome ASC at…