sqlite exception handling in Android -


i working on application stores data in sqlite, while creating table android throws exception:

failure 1 : syntax error near table1. on ox12d510

i unable identify doing wrong. source code:

import android.content.context; import android.database.sqlite.sqlitedatabase; import android.database.sqlite.sqliteopenhelper; public class mysqlitehelper extends sqliteopenhelper { public static final string database_name = "bedekar12.db"; public static final int database_version = 1; public static final string column_id = "_id"; public static final string column_1 = "column1"; public static final string product_name = "product_name"; public static final string product_category = "product_category"; public static final string order_id = "order_id"; public static final string order_date = "order_date"; public static final string customer_id = "customer_id"; public static final string total = "total"; public static final string salesman_id = "salesman_id"; public static final string order_status = "order_status"; public static final string product_id = "product_id"; public static final string package_id = "package_id"; public static final string quantity = "quantity"; public static final string packgage = "package"; public static final string weight = "weight"; public static final string price = "price"; public static final string customer_no = "customer_no"; public static final string customer_name = "customer_name"; public static final string customer_add = "customer_add"; public static final string customer_city = "customer_city"; public static final string customer_region = "customer_region"; public static final string customer_postal = "customer_postal"; public static final string contact = "contact"; public static final string customer_title = "customer_title"; public static final string customer_phone = "customer_phone"; public static final string customer_email = "customer_email"; public static final string lat = "lat"; public static final string lng = "lng"; public static final string events_date = "events_date"; public static final string events_msg = "events_msg"; // 1. news table public static final string news_table = "news_table"; public static final string news_create = "create table " + news_table + " ( " + column_id + " integer primary key , " + column_1 + " text not null ); "; // 2. product table public static final string product_table = "product_table"; public static final string product_create = "create table " + product_table + " ( " + column_id + " integer primary key , " + product_id + " text not null, " + product_name + " text not null, " + product_category + " text not null ); "; // 3. order table public static final string order_table = "order_table"; public static final string order_create = "create table " + order_table + " ( " + column_id + " integer primary key, " + order_id + " text not null, " + order_date + " text not null, " + customer_id + " text not null, " + total + " text not null, " + salesman_id + " text not null, " + order_status + " text not null ); "; // 4. return order table public static final string return_order_table = "return_order_table"; public static final string return_order_create = "create table " + order_table + " ( " + column_id + " integer primary key, " + order_id + " text not null, " + order_date + " text not null, " + customer_id + " text not null, " + total + " text not null, " + salesman_id + " text not null, " + order_status + " text not null ); "; // 5. orderdetails table public static final string order_details_table = "details_table"; public static final string order_details_create = "create table " + order_details_table + " ( " + column_id + " integer primary key , " + order_id + " text not null, " + product_id + " text not null, " + package_id + " text not null, " + quantity + " text not null, " + price + " text );"; // 6. return orderdetails table public static final string return_order_details_table = "return_details_table"; public static final string return_order_details_create = "create table " + order_details_table + " ( " + column_id + " integer primary key, " + order_id + " text not null, " + product_id + " text not null, " + package_id + " text not null, " + quantity + " text not null, " + price + " text );"; // 7. package table public static final string packaging_table = "packaging_table"; public static final string packaging_create = "create table " + packaging_table + " ( " + column_id + " integer primary key, " + product_id + " text not null, " + package_id + " text not null, " + packgage + " text not null, " + weight + " text not null, " + quantity + " text not null, " + price + " text not null );"; // 8. customer table public static final string customer_table = "customer_table"; public static final string customer_create = "create table " + customer_table + " ( " + column_id + " integer primary key, " + customer_name + " text not null, " + customer_add + " text not null, " + customer_city + " text not null, " + customer_region + " text not null, " + customer_postal + " text not null, " + contact + " text not null, " + customer_title + " text not null, " + customer_phone + " text not null, " + customer_email + " text not null, " + lat + " text not null, " + lng + " text not null ); "; // 9. event table; public static final string events_table = "events_table"; public static final string events_create = "create table " + events_table + " ( " + column_id + " integer primary key, " + events_date + " text not null, " + events_msg + " text not null ); "; public mysqlitehelper(context context) { super(context, database_name, null, database_version); // todo auto-generated constructor stub } @override public void oncreate(sqlitedatabase db) { db.execsql(news_table); db.execsql(product_table); db.execsql(order_table); db.execsql(return_order_table); db.execsql(order_details_table); db.execsql(return_order_details_table); db.execsql(packaging_table); db.execsql(customer_table); db.execsql(events_table); } @override public void onupgrade(sqlitedatabase db, int version1, int version2) { db.execsql("drop table if exists " + news_table); db.execsql("drop table if exists " + product_table); db.execsql("drop table if exists " + order_table); db.execsql("drop table if exists " + return_order_table); db.execsql("drop table if exists " + order_details_table); db.execsql("drop table if exists " + return_order_details_table); db.execsql("drop table if exists " + packaging_table); db.execsql("drop table if exists " + customer_table); db.execsql("drop table if exists " + events_table); oncreate (db); } }

you using wrong string in oncreate method... giving table name only, not string create tables.

change this:

@override public void oncreate(sqlitedatabase db) { db.execsql(news_table); db.execsql(product_table); db.execsql(order_table); db.execsql(return_order_table); db.execsql(order_details_table); db.execsql(return_order_details_table); db.execsql(packaging_table); db.execsql(customer_table); db.execsql(events_table); }

to this:

@override public void oncreate(sqlitedatabase db) { db.execsql(news_create); db.execsql(product_create); db.execsql(order_create); db.execsql(return_order_create); db.execsql(order_details_create); db.execsql(return_order_details_create); db.execsql(packaging_create); db.execsql(customer_create); db.execsql(events_create); }

as side note, of primary keys should called _id facilitate use android widgets. expect name of primary key (it coded widgets can identify data comes record when things lists).

one last pointer, easier use autoincrement feature ids don't have manage primary keys manually.


Comments

Post a Comment

Popular posts from this blog

javascript - backbone.js Collection.add() doesn't `construct` (`initialize`) an object -

<!doctype html public "-//w3c//dtd xhtml 1.0 strict//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-strict.dtd"> <html> <head> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script> <script src="http://documentcloud.github.com/underscore/underscore-min.js"></script> <script src="http://documentcloud.github.com/backbone/backbone-min.js"></script> </head> <body> <button id="cmd_create_event" name="cmd_create_event" type="button">create new `event`</button> <script type="text/javascript"> var eventmodel = backbone.model.extend({ initialize : function() { console.log("`event` initialized. id: " + this.cid); this.bind("change:status", function() { console.log(this.get("status") + " value `status`"); }); this.bind("error", function(model, e...
Read more

php - Get uncommon values from two or more arrays -

is there function in php give array of uncommon values 2 or more arrays? for example: $array1 = array( "green", "red", "blue"); $array2 = array( "green", "yellow", "red"); .... $result = function_needed($array1, $array2,...); print_r($result); should give output: array("blue", "yellow", ...); use array_diff , array_merge : $result = array_merge(array_diff($array1, $array2), array_diff($array2, $array1)); here's demo. for multiple arrays, combine callback , array_reduce : function unique(&$a, $b) { return $a ? array_merge(array_diff($a, $b), array_diff($b, $a)) : $b; } $arrays = array( array('green', 'red', 'blue'), array('green', 'yellow', 'red') ); $result = array_reduce($arrays, 'unique'); and here's demo of that.
Read more

Adding duplicate array rows in Php -

i create function in php adds rows of array shared column value. so input. $test = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); and output. $testduplicatefree = array( array("c", 7, 9), array("test", 5, 6) ) ); i'm thinking function combine_duplicates($array,$col){ ... ... return $duplicatefreearray; } where $col duplicate free array. so, in case, combine_duplicates($test,0); would me desired output. this. <?php function combine_duplicates($array,$col) { $index = array(); foreach ($array $row) { $key = $row[$col]; if (!isset($index[$key])) { $index[$key] = $row; } else { ($i = 0; $i < count($row); ++$i) { if ($i != $col) { $index[$key][$i] += $row[$i]; } } } } return array_values($index); } $array = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); print_r(combine_duplicates($array, 0)); try here: http://codepad.org/mdhesqhi
Read more