Questions tagged as 'sqlite'

Tagged questions
0
answers

Variable error with assigned array

I'm making a map that shows information, located in a database, through bookmarks. So far, I can only show the last data in the database. What should I do to resolve this problem? PS: This is done in PHP and JS. BODY echo' <script>...
asked by 14.08.2018 / 17:36
1
answer

use ion-select dynamically

I've placed as options in ion-select, Zone South, North, Center and West. I want when I click on any option, only show the information of that zone taking the information from the database. At the moment I only have the same select. <ion-it...
asked by 03.08.2018 / 15:24
1
answer

Search database specific data in ionic 3

I would like to know how to filter and receive only the data I want on each page. my database.ts: 'getAllProducts () { return new Promise<Produto[]>((resolve, reject) => { let sql = "select * from tb_produto"; this.executeQuery(s...
asked by 26.07.2018 / 14:58
0
answers

Listview getting blob image and sqlite name

I'm trying to populate a listview with names and phones, images and ids (id will not be shown, served only when I click on the desired clients, play to another activity requesting the information found through the id), I tried to increment my co...
asked by 18.07.2018 / 22:42
0
answers

SQLiteOpenHelper Error (8,8)

I'm starting to program in Android and I want to make a class with a database. package josephisaac.com.wmvendas; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper; public class BancoDados extend...
asked by 19.07.2018 / 20:47
1
answer

placeholder for varchar sql

I'm doing a program that reads the Arduino output and sends it to a SQLITE3 database. You're giving me this error: cursor.execute("INSERT INTO reciclagem_data (personID, nome) VALUES (%s,%s)", (pieces[0], pieces[1])) OperationalError: near...
asked by 12.07.2018 / 03:13
0
answers

Synchronize sqlite with an online database

I need to synchronize (one playing information to the other) a sqlite DB with some DB server like sqlserver or mysql, and I would like to know how I can do this, I'm using C # language with visual studio, Thanks Edit: Just to be clearer, I'm...
asked by 11.07.2018 / 20:24
1
answer

Create field unique Android Studio

I am a beginner in android development and am trying to create a table in sqlite where the email value will be unique. However, the application is allowing you to register the same emails. @Override public void onCreate(SQLiteDatabase db)...
asked by 12.07.2018 / 15:33
0
answers

UPDATE Error SqLite and PHP

<?php $ip = $_REQUEST['ip']; $port = $_REQUEST['port']; class MyDB extends SQLite3 { function __construct() { $this->open('Tracker.db'); } } $db = new MyDB(); if(!$db) { echo $db->lastError...
asked by 08.07.2018 / 23:09
1
answer

Using Tkinter next to a Database

I'm doing a people registration program with interface (still pretty basic, just to do tests) and I'm having several difficulties: I am extracting the data using .get() , however, I can only type 1 character. If I type more then the fo...
asked by 04.07.2018 / 20:27