Re: [sqlite] Re: Re: Re: Which API to use to get resultant of query

[Thomas . L]

On Sun, 17 Sep 2006 13:03:23 +0530, you wrote:

>Thank you very much for your suggestion.
>I found very few samples in the siteBut hardly only one example is there
>which explains abt handling BLOB data.
>There is no documentation which explains about these samples ..
>So for me all your support is very much required.please bear with me
>
>Thank you
>Regards
>Sandhya


Hi Sandhya

You can find a Sample-Testprogramm at
http://www.thlu.de/db/rssqlitetest_vc.html, where you can see how to
read and write Blobs in an easy way. It is a C++-Sample compiled with 
VC++ Net 2003. 
I solved this problem by using COleVariant. That is a MS-Type for
interchange various types of Data to a Database, always going a
similar way, with lowest possible expenditure.

Best Regards
Thomas

www.thlu.de

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

Re: [sqlite] Re: Re: Re: Which API to use to get resultant of query

[sandhya]

Thank you very much for your suggestion.
I found very few samples in the siteBut hardly only one example is there
which explains abt handling BLOB data.
There is no documentation which explains about these samples ..
So for me all your support is very much required.please bear with me

Thank you
Regards
Sandhya



- Original Message - 
From: "Fred Williams" <[EMAIL PROTECTED]>
To: 
Sent: Friday, September 15, 2006 9:19 PM
Subject: RE: [sqlite] Re: Re: Re: Which API to use to get resultant of query


>
>
> > -Original Message-
> > From: Igor Tandetnik [mailto:[EMAIL PROTECTED]
> > Sent: Friday, September 15, 2006 10:27 AM
> > To: SQLite
> > Subject: [sqlite] Re: Re: Re: Which API to use to get
> > resultant of query
> >
> >
> > sandhya <[EMAIL PROTECTED]> wrote:
> > > But where as when i am executing the same from command prompt it is
> > > showing
> > > the OID alone.
> > > Why it is showing DONE when i am doing it through program?Anything
> > > wrong?
> >
> > Check your condition. Make sure it's the same as the one you use in
> > console. Most likely, you've simply misspelled the string in
> > the sprintf
> > call and it cannot be found in the table.
> >
> > As a sanity check, drop the condition and see if you can get
> > anything at
> > all with a simple query like "select oid from tablename;"
> >
> > Igor Tandetnik
> >
>
> Just a suggestion.  When I am learning a new language, database, etc.  I
> sometimes find working with and even stepping through supplied samples
> prove to be the quickest way to gain insight into how the new entity
> works.  Saves both me and a lot of other people a lot of time and
> effort.
>
> Fred
>
>
> --
---
> To unsubscribe, send email to [EMAIL PROTECTED]
> --
---
>



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

Re: [sqlite] Re: Re: Re: Which API to use to get resultant of query

[Dennis Cote]

Fred Williams wrote:


Just a suggestion.  When I am learning a new language, database, etc.  I
sometimes find working with and even stepping through supplied samples
prove to be the quickest way to gain insight into how the new entity
works.  Saves both me and a lot of other people a lot of time and
effort.

  
That sounds a lot like RTFM only presented in a much more pleasant 
manner. :-)


Anyway, it is good advice, and I second it.

Dennis Cote

P.S. I also think the quickstart page at the SQLite website should 
probably be enhanced to show a basic version of a query using the 
sqlite3_prepare/sqlite3_step/sqlite3_column_* APIs. This is a common 
question for people starting to use sqlite now, and the quickstart page 
only shows how to use the older depreciated (at least for queries) 
sqlite3_exec API.


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

RE: [sqlite] Re: Re: Re: Which API to use to get resultant of query

[Fred Williams]

> -Original Message-
> From: Igor Tandetnik [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 15, 2006 10:27 AM
> To: SQLite
> Subject: [sqlite] Re: Re: Re: Which API to use to get
> resultant of query
>
>
> sandhya <[EMAIL PROTECTED]> wrote:
> > But where as when i am executing the same from command prompt it is
> > showing
> > the OID alone.
> > Why it is showing DONE when i am doing it through program?Anything
> > wrong?
>
> Check your condition. Make sure it's the same as the one you use in
> console. Most likely, you've simply misspelled the string in
> the sprintf
> call and it cannot be found in the table.
>
> As a sanity check, drop the condition and see if you can get
> anything at
> all with a simple query like "select oid from tablename;"
>
> Igor Tandetnik
>

Just a suggestion.  When I am learning a new language, database, etc.  I
sometimes find working with and even stepping through supplied samples
prove to be the quickest way to gain insight into how the new entity
works.  Saves both me and a lot of other people a lot of time and
effort.

Fred


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

[sqlite] Re: Re: Re: Which API to use to get resultant of query

[Igor Tandetnik]

sandhya <[EMAIL PROTECTED]> wrote:

But where as when i am executing the same from command prompt it is
showing
the OID alone.
Why it is showing DONE when i am doing it through program?Anything
wrong?


Check your condition. Make sure it's the same as the one you use in 
console. Most likely, you've simply misspelled the string in the sprintf 
call and it cannot be found in the table.


As a sanity check, drop the condition and see if you can get anything at 
all with a simple query like "select oid from tablename;"


Igor Tandetnik 



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