?
Solved

append to end of sqlite

Posted on 2011-10-22
2
Medium Priority
?
325 Views
Last Modified: 2012-08-14
How do I append my sqlite files

fname-(somedbfile.sqlite)
f=open(fname,'w')
f.write(data)
f.close()

Open in new window


I thought that it should work like a txt file and change the w to "a" or 'ab' but nothing happens when I do it ... any ideas
0
Comment
Question by:dolamitejenkins
2 Comments
 
LVL 84

Accepted Solution

by:
Dave Baldwin earned 2000 total points
ID: 37012982
You need to use the Python-SQLite interface.  You can't just treat them like simple files and expect it to work right.  Here's one interface http://code.google.com/p/pysqlite/ but you should note that it requires the Database API 2.0.
0
 

Author Closing Comment

by:dolamitejenkins
ID: 37013099
thanks that what I thought
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Learn the basics of strings in Python: declaration, operations, indices, and slicing. Strings are declared with quotations; for example: s = "string": Strings are immutable.: Strings may be concatenated or multiplied using the addition and multiplic…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question