saving and retrieve textfile to and from sqlite in flex

Question

0.00/5 (No votes)

See more:

hi all,

I need to upload a textfile(.txt) to sqlite as a BLOB and retrieve that file when i click a link for example attachment1.txt in my flex AIR desktop project.

I upload image as BLOB using pngencoder and base64encoder to store to sqlite and retrive back using base64decoder. it's works fine . but need to upload a textfile in local sqlite , how can i do this?, need help urgent

advance thanks

Posted 25-Mar-12 23:19pm

Ram Sam 2

Updated 26-Mar-12 18:53pm

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

TorstenH. · Answer 1 · 2012-03-26T00:08:00

Solution 1

There is a difference between those 2 formats, you should be aware of that.

You should use a generalized approach and store all those files as files and not as special types. So you can use a BLOB for all of them, storing them as binary data.

Blog entry explaining:
http://mornie.org/blog/2007/01/10/Storing-binary-data-in-SQLite/[^]

Posted 26-Mar-12 0:08am

TorstenH.

Comments

Ram Sam 2 27-Mar-12 0:55am

thanks,can u post code to store and retrive only txt file in sqlite database in flex air application.

TorstenH. 27-Mar-12 11:57am

check this: simple example code

and please do a little search on Goole, there are a lot of examples around.

I can also recommend to buy a book about Flex/AIR development, the topic is covered in almost all of them. A book does have the advantage of revealing it's secrets without knowing keywords...