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#prag
On Thursday, December 23, 2010, Bob Keeland wrote:
>Is there anything like SQLite-Manager that works for those of us who still use
>Microsoft software?
You should look at SQLiteSpy
http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index. It is
very nice Sqlite database browser for windows.
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 progra
x27;m considering a dabble with
LINUX, but have not made the jump yet.
Bobby Keeland
--- On Thu, 12/23/10, stormtrooper wrote:
From: stormtrooper
Subject: Re: [sqlite] beginner
To: sqlite-users@sqlite.org
Date: Thursday, December 23, 2010, 11:56 AM
Srinidhi,
I recommend Sqlite-manager, a free
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
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
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 "
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. Kr
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 o
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.
>
> Ca
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 helpin
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
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
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
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]> wro
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 whi
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_op
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 PROTECT
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
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
>
--
'***
David A O L wrote:
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
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 i
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 deta
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
ay.
Michael Hooker
From: "Dan Kennedy" <[EMAIL PROTECTED]>
To:
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
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 = activi
--- 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
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
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 Proble
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 librar
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 sub
31 matches
Mail list logo