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

2011-02-04 Thread Simon Davies
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?

http://www.sqlite.org/pragma.html#pragma_database_list

>
> sqlite-version: latest
>
>
> mfg, Andreas Otto

Regards,
Simon
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] beginner

2010-12-23 Thread Simon Slavin

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 programs don't 
interfere with one-another: you just start up whichever one you want to run.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] beginner

2010-12-23 Thread Bob Keeland
On SQLite I see lots of complex questions and equally complex answers posted by 
people who obviously know what they are doing. I, however, still need to learn 
the basics of using SQLite. Is there anything like SQLite-Manager that works 
for those of us who still use Microsoft software? I'm 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, 2010, 11:56 AM




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 the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] beginner

2010-12-23 Thread stormtrooper


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 the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] beginner

2010-12-17 Thread George Roberge
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: there is an iPod Touch app which is a fully- 
functioning SQLite console and instructions.  Awesome.

George R.

-- The days of good English has went.
-- We can either use our money to serve God or our god will be our  
money. 

On Dec 17, 2010, at 10:01, "Jay A. Kreibich"  wrote:

> 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. Kreibich < J A Y  @  K R E I B I.C H >
>
> "Intelligence is like underwear: it is important that you have it,
> but showing it to the wrong people has the tendency to make them
> feel uncomfortable." -- Angela Johnson
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] beginner

2010-12-17 Thread john darnell
(Grin and embarrassed blush)  I am. Quite useful, as a matter of fact.  If you 
need an endorsement, please let me know.

> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
> On Behalf Of Jay A. Kreibich
> Sent: Friday, December 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 "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. Kreibich < J A Y  @  K R E I B I.C H >
> 
> "Intelligence is like underwear: it is important that you have it,
>  but showing it to the wrong people has the tendency to make them
>  feel uncomfortable." -- Angela Johnson
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] beginner

2010-12-17 Thread Jay A. Kreibich
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. Kreibich < J A Y  @  K R E I B I.C H >

"Intelligence is like underwear: it is important that you have it,
 but showing it to the wrong people has the tendency to make them
 feel uncomfortable." -- Angela Johnson
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] beginner

2010-12-17 Thread john darnell
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 of fine tutorials on the web.  Are you trying to embed a database into a 
program or web page?  Then you need both SQL and SQLite (I have no experience 
embedding SQLite into a web page so don't ask for advice from me on that one).  
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.

   Amazon has a number of good books on both subjects, so surf on over to their 
site and enter "SQL" into the subject line.  I personally have found any of the 
"HEAD FIRST" books to be superb for quickly picking up a new topic.  I just 
checked; there is a *Head First SQL* book out there that should be ideal for 
learning SQL.

> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
> On Behalf Of Srinidhi Rao
> Sent: Friday, December 17, 2010 5:43 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] beginner
> 
> Hello SQLiters...
> 
> 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.
> 
> Can any one suggest me where (and how...) to start, any good books that can
> help me here.
> 
> --
> Thanks and Regards,
> Srinidhi.
> 
> Tell me and I forget. Teach me and I remember. Involve me and I learn.
> -- Benjamin Franklin.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] beginner

2010-12-17 Thread Simon Slavin

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.
> 
> Can any one suggest me where (and how...) to start, any good books that can
> help me here.

Do not start by trying to learn SQLite.  Start by trying to learn SQL and what 
it is for.  There are many web pages with title like 'SQL for beginners'.  Once 
you have understood some of those, then you might find pages about SQLite 
interesting.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] beginner

2007-09-05 Thread Pavan
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 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 reached
> that point yet SQLite is going to be well beyond you.
>
> If you're truly this lost, let me recommend "The C Programming Language",
> which while basic, is also very good.
>
> Clay
>
> nishit sharma 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 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]> wrote:
> >>
> >> 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 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 PROTECTED]> wrote:
> >> > >
> >> > > 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 sqlite
> >> > > > > can anybody send me a link which can help me
> >> > > > > in building and maintining databse
> >> > > > >
> >> > > >
> >> > > >
> >> > > >
> >> > > > --
> >> > > > '
> >> > > > Always finish stronger than you start
> >> > > > *
> >> > > >
> >> > >
> >> > >
> >> >
> >>
> >>
> >>
> >> --
> >> '
> >> Always finish stronger than you start
> >> *
> >>
> >
>
>
> --
> Lazarus Registration
> http://www.lazarusid.com/registration.shtml
>
>
>
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
>
> -
>
>


-- 
'
Always finish stronger than you start
*


Re: [sqlite] beginner

2007-09-05 Thread Clay Dowling
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 reached
that point yet SQLite is going to be well beyond you.

If you're truly this lost, let me recommend "The C Programming Language",
which while basic, is also very good.

Clay

nishit sharma 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 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]> wrote:
>>
>> 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 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 PROTECTED]> wrote:
>> > >
>> > > 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 sqlite
>> > > > > can anybody send me a link which can help me
>> > > > > in building and maintining databse
>> > > > >
>> > > >
>> > > >
>> > > >
>> > > > --
>> > > > '
>> > > > Always finish stronger than you start
>> > > > *
>> > > >
>> > >
>> > >
>> >
>>
>>
>>
>> --
>> '
>> Always finish stronger than you start
>> *
>>
>


-- 
Lazarus Registration
http://www.lazarusid.com/registration.shtml


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



RE: [sqlite] beginner

2007-09-03 Thread kirrthana M
In the sql query use AND operator for the two columns you want to compare.
Ex:select * from table_name where col1=="value" AND col2 == "value";

-Original Message-
From: nishit sharma [mailto:[EMAIL PROTECTED]
Sent: Monday, September 03, 2007 3:41 PM
To: sqlite-users@sqlite.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
Nishit


On 9/3/07, Pavan <[EMAIL PROTECTED]> wrote:
>
> 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 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 PROTECTED]> wrote:
> > >
> > > 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 sqlite
> > > > > can anybody send me a link which can help me
> > > > > in building and maintining databse
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > > '
> > > > Always finish stronger than you start
> > > > *
> > > >
> > >
> > >
> >
>
>
>
> --
> '
> Always finish stronger than you start
> *
>


The information contained in this electronic message and any attachments to 
this message are intended for the exclusive use of the addressee(s) and may 
contain proprietary, confidential or privileged information. If you are not the 
intended recipient, you should not disseminate, distribute or copy this e-mail. 
Please notify the sender immediately and destroy all copies of this message and 
any attachments contained in it.

Contact your Administrator for further information.

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



Re: [sqlite] beginner

2007-09-03 Thread Pavan
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 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]> wrote:
> >
> > 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 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 PROTECTED]> wrote:
> > > >
> > > > 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 sqlite
> > > > > > can anybody send me a link which can help me
> > > > > > in building and maintining databse
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > '
> > > > > Always finish stronger than you start
> > > > > *
> > > > >
> > > >
> > > >
> > >
> >
> >
> >
> > --
> > '
> > Always finish stronger than you start
> > *
> >
>



-- 
'
Always finish stronger than you start
*


Re: [sqlite] beginner

2007-09-03 Thread nishit sharma
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]> wrote:
>
> 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 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 PROTECTED]> wrote:
> > >
> > > 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 sqlite
> > > > > can anybody send me a link which can help me
> > > > > in building and maintining databse
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > > '
> > > > Always finish stronger than you start
> > > > *
> > > >
> > >
> > >
> >
>
>
>
> --
> '
> Always finish stronger than you start
> *
>


Re: [sqlite] beginner

2007-09-03 Thread Pavan
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 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 PROTECTED]> wrote:
> >
> > 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 sqlite
> > > > can anybody send me a link which can help me
> > > > in building and maintining databse
> > > >
> > >
> > >
> > >
> > > --
> > > '
> > > Always finish stronger than you start
> > > *
> > >
> >
> >
>



-- 
'
Always finish stronger than you start
*


Re: [sqlite] beginner

2007-09-03 Thread nishit sharma
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
> 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 PROTECTED]> wrote:
> >
> > 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 sqlite
> > > > can anybody send me a link which can help me
> > > > in building and maintining databse
> > > >
> > >
> > >
> > >
> > > --
> > > '
> > > Always finish stronger than you start
> > > *
> > >
> >
> >
>


Re: [sqlite] beginner

2007-08-31 Thread nishit sharma
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 PROTECTED]> wrote:
>
> 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 sqlite
> > > can anybody send me a link which can help me
> > > in building and maintining databse
> > >
> >
> >
> >
> > --
> > '
> > Always finish stronger than you start
> > *
> >
>
>


Re: [sqlite] beginner

2007-08-30 Thread nishit sharma
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 sqlite
> > can anybody send me a link which can help me
> > in building and maintining databse
> >
>
>
>
> --
> '
> Always finish stronger than you start
> *
>


Re: [sqlite] beginner

2007-08-30 Thread Pavan
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
>



-- 
'
Always finish stronger than you start
*


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

2007-04-20 Thread David A O L

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 into some values("hi", 0);
insert into some values("hi there", 0);
update some set count = count +1 where xthing="hi";
update some set count = count +1 where xthing="hi";
update some set count = count +1 where xthing="hi";
update some set count = count +1 where xthing="hi there";


The following in C
select * from some;
// and in the callback after print the value of count and extract a random
value...


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

2007-04-20 Thread Dennis Cote

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 details.


HTH
Dennis Cote

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



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

2007-04-20 Thread David A O L

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).
Like I know I have here sqlite3 I will search the way to print the version
of the library used...


Also an extra question, I have done a wrapper for sqlite_exec... but because
I get sometimes the msg "Database is locked", I have writed something like
this:

while ((rc = sqlite3_exec (db, x, callBack, primerArg, )) ==
SQLITE_BUSY);

I have tried after putting a counter, but aparently it is to fast a 5 count
for retry the exec...



Sorry for the "anterior way" word, was thinking that it exist anterior, but
in fact it should be "previous way"


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

2007-04-20 Thread Michael Hooker

>>The question is: the anterior way is the only way???<<

>>I think anterior means "before"... I'm no wordsmith...<<

Yes it does: David means "what I said before", or "the foregoing".  He's 
simply asking if there is another way.


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 -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 = actividad = 0;
for (i = 0; i < argc; i++) {
printf("%s = %s ", azColName[i], argv[i] ? argv[i] : "NULL");
}
printf("\n");
// Here!
return 0;
}


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.


What I see is that I can use arg1 like a pointer to a linked list to hold
data and then do the update...


True. That's the way to go with v2 I think.


The question is: the anterior way is the only way???


I think anterior means "before"... I'm no wordsmith...

Dan.



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




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



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

2007-04-19 Thread Dan Kennedy
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 = actividad = 0;
> for (i = 0; i < argc; i++) {
> printf("%s = %s ", azColName[i], argv[i] ? argv[i] : "NULL");
> }
> printf("\n");
> // Here!
> return 0;
> }
> 
> 
> 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.

> What I see is that I can use arg1 like a pointer to a linked list to hold
> data and then do the update...

True. That's the way to go with v2 I think.

> The question is: the anterior way is the only way???

I think anterior means "before"... I'm no wordsmith...

Dan.



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



Re: [sqlite] beginner question

2006-11-17 Thread Qiang
--- 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
> > table (20,000 - 30,000 rows, 2 columns). does it
> make
> > much different on performance? if yes, what makes
> it?
> >
> > 2. Comparing select a sequence number first from a
> > small table THEN select all rows from another
> table
> > that have the same sequence number ( hence two
> selects
> > )
> >with
> >join select on this two tables where they have
> the
> > same sequence number. any difference here?
> >
> >   
> Qiang,
> 
> Re 1: It will be slightly faster to get the data
> from a table with fewer 
> columns if the required columns are at the end of
> the row since sqlite 
> has to skip over the unused fields. But unless you
> have large fields the 
> difference will be very small. It is more important
> to reduce the number 
> of rows to scan, or provide an index so sqlite can
> locate the correct 
> row more quickly.
> 
> Re 2: I suspect the join will always be faster since
> it essentially does 
> the same thing but without the overhead of executing
> a second statement. 
> If you only return the columns from the second table
> it will give the 
> same results.
> 

thank you for the answer. the reason i asked because i
want to combine few smaller table into one and save
the time join all of them. your answer helped me see
the the consequence.

> HTH
> Dennis Cote
> 

Qiang


 

Sponsored Link

$200,000 mortgage for $660/ mo - 
30/15 yr fixed, reduce debt - 
http://yahoo.ratemarketplace.com

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



Re: [sqlite] beginner question

2006-11-17 Thread Dennis Cote

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 performance? if yes, what makes it?

2. Comparing select a sequence number first from a
small table THEN select all rows from another table
that have the same sequence number ( hence two selects
)
   with
   join select on this two tables where they have the
same sequence number. any difference here?

  

Qiang,

Re 1: It will be slightly faster to get the data from a table with fewer 
columns if the required columns are at the end of the row since sqlite 
has to skip over the unused fields. But unless you have large fields the 
difference will be very small. It is more important to reduce the number 
of rows to scan, or provide an index so sqlite can locate the correct 
row more quickly.


Re 2: I suspect the join will always be faster since it essentially does 
the same thing but without the overhead of executing a second statement. 
If you only return the columns from the second table it will give the 
same results.


HTH
Dennis Cote

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



Re: [sqlite] Beginner Problem...

2005-02-17 Thread Keith Herold
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 Problem...
> 
> 
> I've used SQLite utility to learn about the library,
> but have a doubt...
> I need to submit sql text scripts to the utility
> instead of command line sql code. It´s possible?
> 
> Cláudio Leopoldino
> 
> ___
> Yahoo! Acesso Grátis - Instale o discador do Yahoo! agora.
> http://br.acesso.yahoo.com/ - Internet rápida e grátis
> 
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 14-2-2005
> 
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 14-2-2005
> 
> 

somewhat more helpfully :), 

.read 

replace  with the name of your script.  I have had some
trouble with this, when reading in files which have binary-encoded
data (using sqlite_binary_encode), but for everything else, it works
fine.


I would also use .output when reading scripts; if there are any
errors, the information scrolls by a little two quickly, and if the
script is long, the scroll buffer will lose the info:

.output myoutputfile.txt

To redirect to stdout, use:

.output stdout

For help:

.help

--Keith




-- 
**
- Ever notice how 'big' isn't, compared to 'small'?

- Sounds like a Wookie; acts like mad cow.

- I'm not a professional; I just get paid to do this.

- Rules for programming:
   1.  Get it working, right?
   2.  Get it working right.

- Things I've learned about multithreaded programming:

123...   PPArrvooottieedcc ttm  ueelvvteeirrtyyhtt
rhheiianndgge  dwi hnpi rctohhg eri aslm omscitanalgt 
 iowcbh,je engceltvo ebwrah lip,co hso srci abonlt ehb
.ee^Nr waicscee snsoetd  'aotb jtehcet -slaomcea lt'il
m^Ne from two or more threads
**


RE: [sqlite] Beginner Problem...

2005-02-17 Thread Peter Berkenbosch
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 library,
but have a doubt... 
I need to submit sql text scripts to the utility
instead of command line sql code. It´s possible?

Cláudio Leopoldino







___ 
Yahoo! Acesso Grátis - Instale o discador do Yahoo! agora.
http://br.acesso.yahoo.com/ - Internet rápida e grátis

-- 
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 14-2-2005
 

-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 14-2-2005
 



RE: [sqlite] Beginner Problem...

2005-02-17 Thread Peter Berkenbosch
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 submit sql text scripts to the utility
instead of command line sql code. It´s possible?

Cláudio Leopoldino







___ 
Yahoo! Acesso Grátis - Instale o discador do Yahoo! agora.
http://br.acesso.yahoo.com/ - Internet rápida e grátis

-- 
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 14-2-2005
 

-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 14-2-2005