I am doing this query:SELECT univ._id, univ.firstName, univ.lastName, univ.status, univ.veikla, univ.cellPhone, univ.homePhone FROM universitetas univ" in order to select the information like id, first name, last name etc. from xml file called sql.xml which looks like this: <sql> <statement> CREATE TABLE IF NOT EXISTS universitetas ( _id INTEGER PRIMARY KEY AUTOINCREMENT, firstName VARCHAR(50), lastName VARCHAR(50), status VARCHAR(50), veikla VARCHAR(50), city VARCHAR(50), cellPhone VARCHAR(30), homePhone VARCHAR(30), email VARCHAR(30)) </statement> <statement>INSERT INTO universitetas VALUES(1,'Martin','Tubis','Studentas','Pirmas kursas', 'Vilnius','+370 654 09353','242 74 03','martintubis@gmail.com')</statement> <statement>INSERT INTO universitetas VALUES(2,'Petras','Petraitis','Studentas','Pirmas kursas','Vilnius', '+370 654 09463','222 76 43','petrapetratis@gmail.com')</statement> <statement>INSERT INTO universitetas VALUES(3,'Jonas','Jonaitis','Destytojas','Matematikos destytojas','Vilnius','+370 654 09853','246 65 63','jonasjonaitis@gmail.com')</statement> <statement>INSERT INTO universitetas VALUES(4,'Darius','Petraitis','Dekanas','Dekanatas','Vilnius', '+370 654 12453','248 65 26','dariuspetraitis@gmail.com')</statement> <statement>INSERT INTO universitetas VALUES(5,'Simonas','Daukantas','Destytojas','Programavimo destytojas','Vilnius','+370 654 09634','265 34 73','simonasdaukantas@gmail.com')</statement> <statement>INSERT INTO universitetas VALUES(6,'Linas','Kleiza','Studentas','Antras kursas','Vilnius','+370 654 34553','231 65 73','linaskleiza@gmail.com')</statement> <statement>INSERT INTO universitetas VALUES(7,'Robertas','Javtokas','Studentas','Trecias kursas', 'Vilnius','+370 654 13562','213 88 43','robertasjavtokas@gmail.com')</statement> <statement>INSERT INTO universitetas VALUES(8,'Oscar','Whilde','Prodekanas','Dekanatas', 'Vilnius','+370 654 46434','216 45 63','oscarwhilde@gmail.com')</statement> <statement>INSERT INTO universitetas VALUES(9,'James','Cameron','Studentas','Antras kursas', 'Vilnius','+370 654 99453','216 81 83','jamescameron@gmail.com')</statement> <statement>INSERT INTO universitetas VALUES(10,'Bred','Pitt','Studentas','Pirmas kursas', 'Vilnius','+370 654 06783','266 66 66','bredpitt@gmail.com')</statement> </sql>
And I am getting this error: no such column: univ.veikla. I have no idea why. What I am trying to do is an android app in which you can search for person in a database, click on it and get all info that is stored in the database.
Aucun commentaire:
Enregistrer un commentaire