Re: [sqlite] Re: Re: Re: Which API to use to get resultant of query
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
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
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
> -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] -
