On 4 February 2011 07:38, Andreas Otto aotto1...@t-online.de 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?
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
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
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
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
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
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.
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
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
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
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
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()
You should link the library when you compile .It should be gcc
test.c-llibraryname
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
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]
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
: [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
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
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
--
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
@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
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
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
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
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 =
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
--- 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 -
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
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
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...
29 matches
Mail list logo