[sqlite] to retreive OID

[abiramip]

Hi,
In the command prompt if i give the following,
select OID from tablename;
am able to get the corresponding OID...
If i use sqlite3_prepare() APIhow do i proceed inorder to do the same ?

Please suggest a procedure to  perform this.
Thanks in advance .

Regards,
abirami p

Re: [sqlite] hi

[abiramip]

thanks for sending tht sample code on how to store and retrieve images into 
and from databases


regards
abirami p
- Original Message - 
From: "Gerry Snyder" <[EMAIL PROTECTED]>

To: <sqlite-users@sqlite.org>
Sent: Monday, September 11, 2006 7:32 PM
Subject: Re: [sqlite] hi



abiramip wrote:

hi,
how can i import gif or jpg files into SQLite database and how can i 
export the same image to the local system?



thanks in advance...


Hello,

Frequently it is better to store just the file names in the database and 
keep large files separate, so you should consider that, but sometimes what 
you are asking for is fine, too. SQLite calls hunks of binary data 
"blobs," and here is some info on how to use them: 
http://www.sqlite.org/cvstrac/wiki?p=BlobExample


Hope this helps.

Gerry

-
To unsubscribe, send email to [EMAIL PROTECTED]
-





-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] hi

[abiramip]

hi,
how can i import gif or jpg files into SQLite database and how can i export the 
same image to the local system?


thanks in advance...