Re: [sqlite] beginner question: help required to retrieve "filename" from an open "sqlite3*" handle

On 4 February 2011 07:38, Andreas Otto wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hi, > > with "sqlite2_open" the parameter "filename" is used to specify the > database location. > > Q: how I can retrieve this parameter from an open handle?

Re: [sqlite] beginner

On 24 Dec 2010, at 2:05am, Bob Keeland wrote: > Is there anything like SQLite-Manager that works for those of us who still > use Microsoft software? I would suggest you download and install FireFox even if you intend to keep using Internet Explorer for your normal web browsing. The two

Re: [sqlite] beginner

considering a dabble with LINUX, but have not made the jump yet.   Bobby Keeland --- On Thu, 12/23/10, stormtrooper <lewis.mil...@gmail.com> wrote: From: stormtrooper <lewis.mil...@gmail.com> Subject: Re: [sqlite] beginner To: sqlite-users@sqlite.org Date: Thursday, December 23, 20

Re: [sqlite] beginner

Srinidhi, I recommend Sqlite-manager, a free tool which runs inside Mozilla FireFox, to help build your queries and view the table,rows, etc. http://code.google.com/p/sqlite-manager/ Keith -- View this message in context: http://old.nabble.com/beginner-tp30480116p30523978.html Sent from

Re: [sqlite] beginner

I have that book, also, and it is OK, but I ordered it online and didn't realize how much of it was dedicated to incorporating SQLite into applications. Of course, "Using SQLite" is the title, after all... I have SQL for Dummies, too, which I think is a nice supplement. One more thing:

Re: [sqlite] beginner

r 17, 2010 9:01 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] beginner > > On Fri, Dec 17, 2010 at 08:42:54AM -0600, john darnell scratched on the wall: > > > I am learning SQLite based on the O'Reilly book by Jay Kreibich, > > called &q

Re: [sqlite] beginner

On Fri, Dec 17, 2010 at 08:42:54AM -0600, john darnell scratched on the wall: > I am learning SQLite based on the O'Reilly book by Jay Kreibich, > called "USING SQLITE," which came out in August of this year, so > it's pretty up to date. I hope you're finding it useful. -j -- Jay A.

Re: [sqlite] beginner

Hello Srindhi: From one SQLite beginner to another... SQLite and SQL are two different subjects. So you need to clarify for yourself what you want to do. Do you want to learn SQL? Then there are a number of good books you can get from Amazon to help you learn, and there are a number

Re: [sqlite] beginner

On 17 Dec 2010, at 11:43am, Srinidhi Rao wrote: > I am interested to learn the nuances of a SQL but I have no background of > using one as I am an electronics student. > I would like to know few things, that does SQLite help me to learn and > devoid the space of not having any background. > >

Re: [sqlite] beginner

Also, just to add when you reply back with a different query to the list, pls post a seperate mail with a appropriate subject line so that more people might be interested to help you. Thanks, Pavan. On 9/5/07, Clay Dowling <[EMAIL PROTECTED]> wrote: > > Nishit, > > Much as we believe in

Re: [sqlite] beginner

Nishit, Much as we believe in helping out new people, I think it is reasonable to expect that before you ask for helping in using the C interface to SQLite that you familiarize yourself with C. Looping and logic structures are something you should learn pretty early on, and if you haven't

RE: [sqlite] beginner

lite.org Subject: Re: [sqlite] beginner thanks for this help. i have done this... my another problem is that i have multiple columns in my database and on the basis of two columns( has integer values) i have to read the database. but i m unable to make a loop in C. can u help me. regards Nishi

Re: [sqlite] beginner

prepare sql query and pass it to sqlite3_exec Thanks, Pavan. On 9/3/07, nishit sharma <[EMAIL PROTECTED]> wrote: > > thanks for this help. i have done this... > my another problem is that i have multiple columns in my database and on > the > basis of > two columns( has integer values) i have to

Re: [sqlite] beginner

thanks for this help. i have done this... my another problem is that i have multiple columns in my database and on the basis of two columns( has integer values) i have to read the database. but i m unable to make a loop in C. can u help me. regards Nishit On 9/3/07, Pavan <[EMAIL PROTECTED]>

Re: [sqlite] beginner

You should link the library when you compile .It should be gcc test.c-l library name should be your sqlite shared library. Just check in /usr/lib directory Thanks, Pavan. On 8/31/07, nishit sharma <[EMAIL PROTECTED]> wrote: > > hey buddy can u tell me how to compile the C source code in

Re: [sqlite] beginner

can anybody tell me which database formats are supported by sqlite3 and the dependencies if i export my database to another system. regards Nishit On 8/31/07, nishit sharma <[EMAIL PROTECTED]> wrote: > > hey buddy can u tell me how to compile the C source code in which i have > used >

Re: [sqlite] beginner

hey buddy can u tell me how to compile the C source code in which i have used sqlite3_open() like calls. i m doing gcc test.c but it is giving me error of undefined reference. i think i am missing some thing in compiling. waiting for reply regards Nishit On 8/30/07, nishit sharma <[EMAIL

Re: [sqlite] beginner

thanks for telling the link. regards On 8/30/07, Pavan <[EMAIL PROTECTED]> wrote: > > Hi Nishit, > > http://www.sqlite.org/quickstart.html > > This is a good link to start with. > > Thanks, > Pavan. > > > On 8/30/07, nishit sharma <[EMAIL PROTECTED]> wrote: > > > > Hi, > > i m beginner to

Re: [sqlite] beginner

Hi Nishit, http://www.sqlite.org/quickstart.html This is a good link to start with. Thanks, Pavan. On 8/30/07, nishit sharma <[EMAIL PROTECTED]> wrote: > > Hi, > i m beginner to sqlite > can anybody send me a link which can help me > in building and maintining databse > --

Re: [sqlite] beginner: Is posible inside a result of a function call another function for delete or update the row??

Use sqlite3_libversion(). See http://www.sqlite.org/capi3ref.html#sqlite3_libversion for details. Im using 3.3.13, I will like if you can show a little snipped of how to go with something like the next.. (The following at sqlite prompt) create table some(xthing varchar, count integer); insert

Re: [sqlite] beginner: Is posible inside a result of a function call another function for delete or update the row??

David A O L wrote: That mean Im using sqlite version 2?? (Because it say database locked). Like I know I have here sqlite3 I will search the way to print the version of the library used... David, Use sqlite3_libversion(). See http://www.sqlite.org/capi3ref.html#sqlite3_libversion for

Re: [sqlite] beginner: Is posible inside a result of a function call another function for delete or update the row??

What I whant is that in // Here! I whant to update (increment, decrement, > etc). > > But it say that the DB is locked... With sqlite v2, yes. If you were using sqlite v3 you could do the UPDATE in the SELECT callback. That mean Im using sqlite version 2?? (Because it say database locked).

Re: [sqlite] beginner: Is posible inside a result of a functioncall another function for delete or update the row??

Michael Hooker From: "Dan Kennedy" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Friday, April 20, 2007 5:42 AM Subject: Re: [sqlite] beginner: Is posible inside a result of a functioncall another function for delete or update the row?? On Thu, 2007-04-19 at 13:29 -050

Re: [sqlite] beginner: Is posible inside a result of a function call another function for delete or update the row??

On Thu, 2007-04-19 at 13:29 -0500, David A O L wrote: > I have a very basic sql statement, mainly Im printing it... > > static int GuardaActividadEnArchivo(void *arg1, int argc, char **argv, char > **azColName){ > int i; > char *nombre, *ok, *ko, *actividad; > nombre = ok = ko =

Re: [sqlite] beginner question

--- Dennis Cote <[EMAIL PROTECTED]> wrote: > Qiang wrote: > > hello, > > > > two questions.. > > > > 1. comparing select one or two columns from one > row > > from a bigger table ( 20,000 - 30,000 rows, 20 > columns > > ). > >with > >select the same column from one row from a > smaller

Re: [sqlite] beginner question

Qiang wrote: hello, two questions.. 1. comparing select one or two columns from one row from a bigger table ( 20,000 - 30,000 rows, 20 columns ). with select the same column from one row from a smaller table (20,000 - 30,000 rows, 2 columns). does it make much different on

Re: [sqlite] Beginner Problem...

On Thu, 17 Feb 2005 16:34:07 +0100, Peter Berkenbosch <[EMAIL PROTECTED]> wrote: > Yes :) > > -Oorspronkelijk bericht- > Van: Claudio Bezerra Leopoldino [mailto:[EMAIL PROTECTED] > Verzonden: donderdag 17 februari 2005 16:25 > Aan: SQLiter Mailing List > Onderwerp: [sqlite] Beginner

RE: [sqlite] Beginner Problem...

EG: % sqlite3 test.db < /data/temp/test.sql -Oorspronkelijk bericht- Van: Claudio Bezerra Leopoldino [mailto:[EMAIL PROTECTED] Verzonden: donderdag 17 februari 2005 16:25 Aan: SQLiter Mailing List Onderwerp: [sqlite] Beginner Problem... I've used SQLite utility to learn about the

RE: [sqlite] Beginner Problem...

Yes :) -Oorspronkelijk bericht- Van: Claudio Bezerra Leopoldino [mailto:[EMAIL PROTECTED] Verzonden: donderdag 17 februari 2005 16:25 Aan: SQLiter Mailing List Onderwerp: [sqlite] Beginner Problem... I've used SQLite utility to learn about the library, but have a doubt... I need to