How to insert data in sqlite database

Possible Duplicate:
Insert data from text fields into SQLite database

Hi friends, i want that when i insert data into my textfield in xib and click on the save button.the same data that i have entered int the textfield must be saved in the column of database when i click the save is this possible.Please anybody help in solving this problem.


You could get the data from your textView,

NSString* myData = textView.text ;

And follow SO link to know inserting data in sqllite3

How to insert data to sqlite database in iphone

Category:iphone Time:2011-04-18 Views:1

Related post

  • Error with inserting data into sqlite database 2010-12-02

    I'm trying to insert data into SqLite database by using a dialog wrapper. However, I am unable to do so. I have 2 texts called Title and Template to insert into the database. But it crashes. Below is my java code: @Override public boolean onCreateOpt

  • Cannot insert data to sqlite database; why not? 2011-11-24

    I want to save data to sqlite database but it does not work. // Setup the database object sqlite3 *database; // Open the database from the users filessytem if(sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK) { // Setup the SQL Sta

  • unable to insert data into sqlite database for android device 2011-12-19

    I've met an unknown error while inserting data into the database. The LogCat had been display "unable to insert data", however, the code that I've used is copied from another activity (which works). weird enough, when I placed the code in the onStart

  • Unable to insert data in Sqlite Database android 2012-01-18

    Following code is used to insert data in the database. When application is launched, following code is executed. After RecentDBManager is executed, when I PULL database from emulator memory, it shows no record in FavoriteScrip table. When I logged In

  • Safely inserting data into SQLite database with apostrophe 2011-03-31

    I am trying to create a table in a SQLite database based on user provided text. Everything was working correctly, except when I tried to add an apostrophe inside the text (which was to be the new table name). After research, I determined that what I

  • unable to insert data into sqlite database in obj c 2011-05-20

    hii every one i am using following method to insert data into data base , but it will save the first entered value only all the time the following method is in the insertUpdateDelete class - (void) InsertRecord { if(addStmt == nil) { NSString *nsql =

  • I can not insert data to SQlite database in objective c 2012-03-30

    Possible Duplicate: Assertion failure error in objective c I want to try insert some data in to sqlite database table but I got an error like this: ***Assertion failure in -[ViewController buttonClick:],/Users/ds/Desktop/SqliteDeneme/SqliteDeneme/Vie

  • Error inserting Data into SQLite database? 2011-07-10

    I keep getting this error 07-10 21:50:06.296: ERROR/Database(538): android.database.sqlite.SQLiteException: no such table: task: , while compiling: INSERT INTO task(descrip, time, title, date, status) VALUES(?, ?, ?, ?, ?); When I execute this line o

  • Inserting Data into sqlite database on iPhone - not working 2012-03-14

    I'm new to using sqlite and the iPhone and I'm having some trouble adding a record to my database. I've used what I can online to try and solve this problem but I'm stuck in a rut. I'm using this piece of code to attempt to add a record into the data

  • No such table when wanting to insert data on SQLite database 2011-08-23

    I used to insert 2 values/columns in my sqlite db(coordinates/markers to show them on map), today i wanted to add another column, i added it as usual but when wanting to launch map activity i have a logcat error as: 08-23 13:27:30.001: ERROR/Database

  • Bad Encoding when inserting non-latin data to sqlite database using c# 2011-11-01

    I'm trying to insert non-latin data into sqlite database using bind variables using System.Data.SQLite. when I inserting the data without bind variables everything is ok: cmd.CommandText = "INSERT INTO mytab VALUES (/" some non-latin data /")"; cmd.E

  • Problem in inserting data in SQLite? 2010-08-13

    Hi i am using FMDB to retrieve data from SQLITE database. db = [[FMDatabase alloc] initWithPath:path]; [db open]; FMResultSet *fResult= [db executeQuery:@"SELECT * FROM Users"]; aUsers = [[NSMutableArray alloc] init]; while([fResult next]) { userData

  • Unable to delete data from SQLite database in iphone application 2011-08-24

    I am not able to delete data from SQlite database. I have created a database of Places. and I am able to display it in UItableView. But when I try to delete something from it code crashes. The error I am getting is Assertion failure in -[Place delete

  • How can I retrieve just the last two rows inserted in an SQLite database? 2011-10-24

    I want to retrieve the last 2 rows inserted into an SQLite database for display in a label. What would be the proper SQLite statement to retrieve these rows? --------------Solutions------------- If you last inserted data has just inserted (maybe in t

  • How to Read Data from SQLite Database and show it on a list view 2012-01-20

    How to pull Data from SQLite Database and show it on a list view. I am doing this in my code, but I am getting an error: public class ShoewDataListActivity extends ListActivity { @Override public void onCreate(Bundle savedInstanceState) { super.onCre

  • How to save parsed data into sqlite database in iPhone 2012-01-21

    I am new in iphone, i am developing an ipad application (like offline mode application) in which data are comes from server and i have parsed these data and store into nsmutable array, now i want to insert these data into sqlite database how to do pl

  • Adding Data to SQLite database 2012-04-02

    Following code is to add data to SQLite database; NSString *insertSQL = [NSString stringWithFormat: @"INSERT INTO FruitsTable name,qty,amt,date VALUES \"%@\",\"%@\",\"%d\",\"%@\"",fruits.fruitName,fruits.qty,fruits.amount,]; NSLog(@"query

  • insert data to the database, and then get an autogenerated int key in return 2009-10-04

    Couldn't find a method like the int executeUpdate(String sql, int autoGeneratedKeys) in php. I want to insert data to the database, and then get an autogenerated int key in return (the ID). Thanks :) Oh, and PS: it has to be a method from the mysqli

  • how to store blob data in sqlite database from javascript with google gear? 2009-11-12

    We have a very special requirement to store blob data in SQLite database, where We have to store documents. We have static html page which is in user disk, so we want user to upload document without connecting to internet with help of google gear, ja

Copyright (C), All Rights Reserved.

processed in 0.430 (s). 13 q(s)