Thanks Jay for your detailed reply.
I would be more happy if the SQLite documentaion include the error codes
each function can return.
Thanks a lot,
Lloyd
- Original Message -
From: Jay A. Kreibich j...@kreibi.ch
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent
Hi,
Lets assume that we have a very simple without any indexing or constraints. Now
we have inserted some data to the table. When we do a simple select query, is
it guranteed that the rows will be retrieved in the same order as they are
inserted?
Thanks a lot,
Lloyd
Thanks Swithun. I dont have any supportive column in table to issue order
by. Can it be achieved by issuing an ordr by query on row_id (used by
sqlite internaly)?
Thanks,
Lloyd
Hello
L Lets assume that we have a very simple without any indexing or
Lconstraints. Now we have inserted some
Hi,
Which are all the type of SQLite APIs can return SQLITE_BUSY?
sqlite3_open_v2
sqlite3_prepare_v2
sqlite3_step
sqlite3_finalize
sqlite3_bind_blob
sqlite3_column_int
Thanks,
Lloyd
__
Scanned and protected by Email scanner
handle at the same time
using sqlite_open - with wrtie permission- is it possible?) I have tried
compiling the application with both -DSQLITE_THREADSAFE=2 and
-DSQLITE_THREADSAFE=1.
Any hint would be very helpful...
Thanks a lot,
Lloyd
__
Scanned
is locked, I am ready to
wait and open it)
You men to handle the BUSY by waiting for some time and trying to execute
sqlite3_step?
Thanks a lot,
Lloyd
__
Scanned and protected by Email scanner
___
sqlite-users mailing
So it means we can have mor than one valid db handle?
Thanks,
Lloyd
- Original Message -
From: Pavel Ivanov paiva...@gmail.com
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent: Wednesday, July 07, 2010 6:40 PM
Subject: Re: [sqlite] sqlite3_step returns
Thank you Igor and Dan. Now I am clear about the concept.
On Sat, 28 Feb 2009 20:07:45 +0530, Dan danielk1...@gmail.com wrote:
On Feb 28, 2009, at 8:44 PM, Lloyd wrote:
Hi,
When we create a view what happens internally in sqlite? Does it
select
all the data from the table
To escape ' use cosecutive ' , i.e ''
On Wed, 18 Feb 2009 10:32:28 +0530, J. R. Westmoreland j...@jrw.org wrote:
I can't remember how to escape a ' in a string.
My statement looks something like:
insert . values ('DAY'S AVE' .);
It's been a long day.
Thanks in advance.
J. R.
Thank you very much Dan.
On Fri, 2008-10-17 at 14:10 +0700, Dan wrote:
On Oct 17, 2008, at 1:43 PM, Lloyd wrote:
Hi,
Lets assume a table having following data
No. NameAddress
1 A addrA
2 B addrB
3 C addrC
4 B
Hi,
In the test folder of sqlite3 source distribution I saw so many test
scripts. How can I run these tests? I am curious to know the various
testing methods used in sqlite.
Thanks,
Lloyd
__
Scanned and protected by Email scanner
Hi Punkish,
I think after installing the library, and making the path entry in
the /etc/ld.so.conf (If it is not there), simply running the ldconfig
command will serve your need.
Regards,
Lloyd
On Thu, 2008-03-13 at 12:09 -0500, P Kishor wrote:
I am not at all conversant with RH Linux (RHEL
Hi,
Can I know how SQLite performs 64bit operations (addition,
multiplication, division) on 32bit machine?
Thank you very much,
Lloyd
__
Scanned and protected by Email scanner
Thanks Andy.
So, SQLite doesn't have its own features to manage this? So I must be
able to perform 64bit operations on a 32bit machine using C. How can I
do that? or how to declare a 64bit integer on a 32bit machine?
Thanks,
Lloyd
On Thu, 2007-07-12 at 15:06 -0500, Andrew Finkenstadt wrote
Thanks Igor :)
Regards,
Lloyd
On Fri, 2007-07-13 at 00:18 -0400, Igor Tandetnik wrote:
Lloyd lloyd-jowPkhCZOFef0DUV/[EMAIL PROTECTED] wrote:
So, SQLite doesn't have its own features to manage this? So I must be
able to perform 64bit operations on a 32bit machine using C. How can I
do
Thank you very much Andrew.
Regards,
Lloyd
On Thu, 2007-07-12 at 23:37 -0500, Andrew Finkenstadt wrote:
Use sqlite_int64 as your type. That typedef supports 'long long' or 'signed
__int64' or whatever the compiler environment needs.
--a
On 7/12/07, Lloyd [EMAIL PROTECTED] wrote
Hi,
I would like to know the reserved characters which cannot be used in
inserting a string.. (like ,',...).
Thanks in advance,
Lloyd
__
Scanned and protected by Email scanner
doesn't seem to work for me
alter table x add (v3 number,v4 number);
Regards,
Lloyd
On Tue, 2007-06-05 at 11:25 +0530, Kirrthana M wrote:
Hi all,
I have created a table with two columns c1 and c2 and inserted some
values into,in future i may include some additional columns c3,c4
should be my own libsqlite3.so looking like. Can you explain the way
I should make the library? I would like to learn this technique :)
If it is statically linked and has -g symbols, use gdb.
If it's stripped, x86 assembler is not that hard to learn.
Thanks,
Lloyd
In old versions it work... But in new versions (3.* I think) its not
working!
On Wed, 2007-05-09 at 12:11 +0200, Peter van Dijk wrote:
On 9-mei-2007, at 11:06, A.J.Millan wrote:
As a suggestion, and even in the risk to abuse of Mr Hipp's
patience. Would
it be possible to include in the
system on my Linux)
Thanks and Regards,
Lloyd
On Wed, 2007-04-25 at 10:13 +0530, Lloyd wrote:
Hi,
I am working on Redhat EL4, with sqlite3. In my application (written in
C++ and wxWidgets, and I use wxSqlite3 wrapper) there a module which
will be called repeatedly which in turn opens and closes
Thank you Arjen. I would consider your alternative or I will go for some
other file system. (Because I would have to handle files larger than
2GB)
Thanks and Regards,
Lloyd
On Thu, 2007-05-03 at 13:52 +0200, Arjen Markus wrote:
Lloyd wrote:
This error occurs only on FAT 32 file system! I
) for short period of time (10 mins -small input) am not getting
any error. But when it runs for around 1 hour (large input) I am getting
an error called
sqlite 14, cant open database !
What could be the reason for this particular error?
Thanks and regards,
Lloyd
Thank you John Stanton. This has opened new doors for me, and think it
would be helpful for others in the list too..
Thanks and Regards
Lloyd
On Thu, 2007-04-12 at 12:34 -0500, John Stanton wrote:
We use a very simple data retrieval method for smallish datasets. The
data is just stored
in the data structure and it
will be searched millions of times. The data is not in any ordered form.
Thanks for your information,
Lloyd
__
Scanned and protected by Email scanner
and the key field would be of size maximum of
20 bytes). (I will see, what is memory based hash)
Thanks and Regards,
Lloyd
__
Scanned and protected by Email scanner
-
To unsubscribe
filter)
Thanks,
Lloyd
__
Scanned and protected by Email scanner
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
On Wed, 2007-04-11 at 10:00 -0500, P Kishor wrote:
I think, looking from Lloyd's email address, (s)he might be limited to
what CDAC, Trivandrum might be providing its users.
Lloyd, you already know what size your data sets are. Esp. if it
doesn't change, putting the entire dataset in RAM
Thank you all. I got so many new ideas from your replies. Now I just
have to derive the best solution for me, thanks :)
Lloyd
On Wed, 2007-04-11 at 10:35 -0500, John Stanton wrote:
You might discover that you can craft a very effective memory
resident
storage system using a compression
Would anybody suggest a good tool for performance measurement (on
Linux) ?
On Wed, 2007-04-11 at 10:35 -0500, John Stanton wrote:
You might discover that you can craft a very effective memory
resident
storage system using a compression system like Huffman Encoding and
an
index method
, I will have millions of integers to store and retrieve)
What the real data is a network packet dump file. I want to store and
retrieve the location of each packet, in order to make packet reading a
faster way from a very large dump file (in terms of GBs)
Thanks,
Lloyd
Hi,
My table contains a text field called Name. Let the data be
Name
---
Abc
abcd
AB
cab
def
I want to selcct all the rows which contains the term ab (not case
sensitive). How can I do this?
Thanks in advance,
Lloyd
-
This email was sent using
of a short as an array of bits
Thanks,
Lloyd
Sorry for asking irrelevant question to this list.
__
Scanned and protected by Email scanner
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Thanks Igor. This is what I wanted.
On Thu, 2007-03-01 at 07:46 -0500, Igor Tandetnik wrote:
Lloyd lloyd-jowPkhCZOFef0DUV/[EMAIL PROTECTED] wrote:
How can I make an array of bit fields? something like, using the 16
bits
of a short as an array of bits
You can't. But, if you can use C
Thanks John. yes, I am familiar with this way, I just wanted to know
whether there is a way to make bit field array. From Igor's reply I
understood that it is not possible in C.
Thanks,
Lloyd
On Thu, 2007-03-01 at 09:48 -0600, John Stanton wrote:
Use a mask to load from and store to your bit
Would not adding verification cause a problem for those include the
downloading of sqlite in bash/make files of certain apps.
Lloydie T
- Original Message -
From: Rich Shepard [EMAIL PROTECTED]
To: sqlite-users@sqlite.org
Sent: Tuesday, January 30, 2007 2:50 PM
Subject: Re: [sqlite]
I wish to create a query where I do a number of counts on the same table but
with different filters.
ie:
count(id) as numrows
count(id) as inrows where direction = 'In'
count(id) as outrows where direction = 'Out'
Could I do the above in a single query?
| id | date | direction |
Ethereal make use of Lemon
On Fri, 2006-12-29 at 11:08 -0400, Cesar Rodas wrote:
Where can i find a tutorial with examples of how to use LEMON parser...
because i need to build interpreted language
Thanks to all
__
Scanned and protected by Email scanner
Thanks Karthick. My code too works fine... (I made a small typo mistake in
query, which executed silently)
But I guess your method is the right one.
Regards,
Lloyd
On Wed, 2006-12-20 at 16:54 +0530, Karthick V - TLS , Chennai wrote:
Let the time zone given by user
+0530
Therefore its
is shown)
what could be the reason? Is there any better way for me to achieve the
same result?
Thanks and Regards,
Lloyd
__
Scanned and protected by Email scanner
-
To unsubscribe, send
there in no where clause to add, so my final query
become
select a from mytable where (b=0) and
and this is a syntax error.
Is there any option to add a null clause after the 'and' ?
Thanks,
Lloyd
__
Scanned and protected by Email scanner
Thanks, 0=0 works well enough for me. (This hint is what I wanted)
Thanks again,
Lloyd
On Wed, 2006-12-06 at 10:00 +0100, Mario Frasca wrote:
Lloyd wrote:
select a from mytable where (b=0) and
and this is a syntax error.
you're not saying which language you're using.
in Python
I feel little difficulty in understanding what you actually want (I
thing the same is for all...). So could make it more clear? so that your
problem can be solved fast!
Thanks,
Lloyd.
Yes, they are stored as INTEGER. and the conversion outside sqlite
is simple. However, I still need
The way I am dealing with this is...
First convert the IP to a 32bit integer. (In the system it will
represented as a 32bit integer)
Store it in the database.
Perform the comparison operations on this stored data.
Thanks,
Lloyd
On Mon, 2006-12-04 at 22:07 -0500, Igor Tandetnik wrote:
Kevin
Hi,
How much time can it take to perform 2000 selection queries on the
same database ? Mostly the result set will contain only 1 raw. Is there
is any way to improve the selection speed?
Thanks,
Lloyd
__
Scanned and protected by Email scanner
I think, Through the command line mode it is impossible.
For this you have to write a program which open and reads the (binary)
data in file and inserts it to the sqlite database.
Thanks,
Lloyd
On Tue, 2006-11-28 at 13:36 +0800, LuYanJun wrote:
Can anybody give a simple example
Are you forgetting to close the database?
On Fri, 2006-11-24 at 02:03 -0800, mithin wrote:
Hi,
In my application I am using SQLite 3 c++ API. Everything works fine till my
application is open. While doing any transaction a journal file is created.
Once I close the app, the journal file is
wrapper class. All these are performed from a single program.
Thanks,
Lloyd.
__
Scanned and protected by Email scanner
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Thanks Clay Dowling,
Yes there is a function for fanalize function. Now the problem is
solved.
On Tue, 2006-11-14 at 08:02 -0500, Clay Dowling wrote:
Lloyd,
You need at some point to call the sqlite3_finalize function. I don't use
wxSqlite, but if it's not handled by the destructor
,
Lloyd.
On Wed, 2006-11-15 at 14:46 +0530, Lloyd wrote:
Hi,
I have opened a database, created tables and inserted data to it in a
single transaction. Then I have closed the data base. Then I reopened
the database and tried to update the table entries. But it throws an
exception called
- Original Message -
From: Rúben Lício [EMAIL PROTECTED]
To: sqlite-users@sqlite.org
Sent: Wednesday, November 08, 2006 1:03 PM
Subject: [sqlite] PHP5 with SQLite3
Are you connecting correctly to the database. Which version of sqlite3 was
the database created in. I beleive php5.1 is
Hi,
How can I manage date and time using sqlite? [Do I have to do it
outside sqlite?]
Thanks,
Lloyd.
__
Scanned and protected by Email scanner
-
To unsubscribe, send email
Thanks gg and Craig Morrison for your informative reply.
I would like to know one more thing, can I use these date and time
functions with comparison operators? Will they return the correct result
or as per the string comparison rules?
Thanks again,
Lloyd.
On Tue, 2006-11-07 at 04:25 -0500
the accurately converted date and time ?
Thanks,
Lloyd.
__
Scanned and protected by Email scanner
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
it accurately. (as in the localtime).
Which way can I prefer ?
Thanks,
Lloyd.
__
Scanned and protected by Email scanner
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Thanks Craig Morrison. Now I got the idea clearly.
On Wed, 2006-11-08 at 00:55 -0500, Craig Morrison wrote:
Lloyd wrote:
select datetime(1162961284,'unixepoch','localtime');
2006-11-08 10:18:04
The result is correct.
I would like to know how sqlite is performing the localtime
SQLite database is stored as a normal file in the disk. Why dont you use
Operating System calls to back up the file?
- Original Message -
From: [EMAIL PROTECTED]
To: sqlite-users@sqlite.org
Sent: Friday, November 03, 2006 2:18 PM
Subject: [sqlite] sqlite backup from the program.
Hi
Whether your database creation error solved? what was the problem?
- Original Message -
From: [EMAIL PROTECTED]
To: sqlite-users@sqlite.org
Sent: Friday, November 03, 2006 2:18 PM
Subject: [sqlite] sqlite backup from the program.
Hi All,
How to take a backup of the sqlite
I don't know whether I am right in this perspective. Just to know
whether sqlite is causing the high memory usage, comment the commands
(statements) related to sqlite and check the memory status.
Thanks,
Lloyd.
On Mon, 2006-10-30 at 12:45 +, Nuno Lucas wrote:
On 10/30/06, Ben Clewett
Which platform are you using? Do you (application) have enough
permission to create files in the specified location ?
On Sat, 2006-10-28 at 16:19 +0530, [EMAIL PROTECTED] wrote:
Hi All,
I am using sqlite3_open() in my program. It is returning
error code 14(file not found) every
the full path of
the file. It will work fine.
Thanks,
Lloyd.
On Fri, 2006-10-27 at 12:17 +0530, sandhya wrote:
Hi,
Is it possible to refer db file from other than the Current project
location.If Yes,How can we refer(tell) the location of the DB file to the
project.Please help me
Most probably it will be a memory leak in your program. We must release
the dynamically allocated memory ourselves. So check whether you are
forgetting to do that. Most probably that leak will be happening inside
some loops or repeatedly calling functions.
On Fri, 2006-10-27 at 17:00 +0100, Ben
/userdb: file is encrypted or is not a
database .
How can I open the database using sqlite command line? ]
Thank you very much.
Lloyd.
On Tue, 2006-10-24 at 11:02 +, [EMAIL PROTECTED] wrote:
Lloyd [EMAIL PROTECTED] wrote:
Hi List,
Whether the data base which we create through
Sorry for my mistake.
I was creating database using sqlite3 API and trying to open it with
sqlite command line client version 2.7
Thanks a lot.
Lloyd.
On Wed, 2006-10-25 at 11:51 +0530, Lloyd wrote:
Thanks for your informative reply.
I would like to know, whether I can open a database
Hi list,
can I insert a hexadecimal value to an integer field? if yes How can
do that?
Thanks,
Lloyd
__
Scanned and protected by Email scanner
-
To unsubscribe, send email
I am using sqlite 3.2.8 which is included in PHP5.1. I seem to be having a
problem doing queries where with '' to search a number.
for instance if I do the following
select ring_time fron calls where ring_time '10';
I get the following results
3
6
3
6
3
6
2
3
3
3
2
etc.
Why?
This row is
I did try number literal 10 but mad no difference. I will rebuild the
database row as an integer.
Lloyd
- Original Message -
From: Igor Tandetnik [EMAIL PROTECTED]
To: SQLite sqlite-users@sqlite.org
Sent: Thursday, October 26, 2006 12:21 AM
Subject: [sqlite] Re: number problem
to use the interface provided by the
sqlite. How can I open the database in SQLite ?
Thanks,
Lloyd.
__
Scanned and protected by Email scanner
-
To unsubscribe, send email to [EMAIL
primary key of text and integer.
Is this the expected performance? Can I improve it anyway? (I am using
the wxSQLite wrapper class)
Thanks,
Lloyd.
__
Scanned and protected by Email scanner
Hi,
When this 3M inserts are performed, it takes 130 more seconds compared
to the actual application running time. The actual application run time
is 20 seconds but when this 3M inserts are performed it takes 150
seconds.
Is there any way to reduce the time ?
Thnaks,
Lloyd.
On Mon, 2006
Hi List,
In SQLite, to see the table structure which command can I use?
(as in Oracle's desc table name )
Thanks,
Lloyd
__
Scanned and protected by Email scanner
to throw error]
How can I get this done?
Thanks,
Lloyd.
__
Scanned and protected by Email scanner
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
,
Lloyd.
__
Scanned and protected by Email scanner
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Are these inserts in 1 transaction or 1000?
Yes it is in 1000 transactions.
For me consistancy, atomicity...(ACID) are not a problem. But the speed
of operation is major constraint. How can I achieve speed in insertion
cases like this?
Thanks for your informative reply.
Lloyd.
On Tue, 2006
I think you are asking for this... This is the case when we use
wxSQLite3.
wxSQLite3ResultSet result = samp.ExecuteQuery(wxT(select name,age from
test));
while (result.NextRow())
{
cout (const char*)(result.GetString(0).mb_str()) result.GetInt
(1) endl;
}
On Fri, 2006-10-06 at 17:07
Hi All,
I have downloaded the SQLite library (sqlite-3.3.7.so.gz) from the
homepage. But I don't know how to install it. Please help me. My Redhat
Enterprise Linux machine runs on i386 architecture.
Thanks and Regards,
Lloyd.
__
Scanned and protected
Thanks everybody, I have downloaded the library RPM from
http://rpm.pbone.net/
and the library name is
libsqlite-3.2.1-1.i386.rpm
It may be useful for newbie like me...
and did as what you said. And works fine...
Thanks,
Lloyd.
On Wed, 2006-09-27 at 10:08 +0200, Markus Hoenicka wrote
and how
to install it in my machine. Awaiting for your kind reply.
Thanks and regards,
Lloyd.
__
Scanned and protected by Email scanner
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Hi Lloyd,
I had exactly the same problem being new to C++. These are the
steps I took. You may find that the library files may be in a folder where
RH does not expect them to be. Try 'whereis libsqlite3.so' to locate. I
can't remember where the default lib folder is. you will need
/sqlite-3.3.7
How can I solve this? From where do I can get an installable copy if the
SQLite library for linux?
Thanks,
Lloyd.
On Tue, 2006-09-26 at 13:17 +0100, Lloyd Thomas wrote:
Hi Lloyd,
I had exactly the same problem being new to C++. These are the
steps I took. You may find
continues
How can I resole this. Please help me...
Can I use the library alone without recompiling the whole sqlite? (Thus
it will be easier for me to distribute my application along with sqlite)
Thanks and regards,
Lloyd.
On Tue, 2006-09-26 at 07:52 -0400, Mark Richards wrote
am dealing with the wrong file, please let me know
from where I can get the needed installable library.
Thanks for your clear and patient reply.
Thanks,
Lloyd.
__
Scanned and protected by Email scanner
I far as i know you compile with php5-pdo-sqlite, but this was only tested
on debian. Last time i looked this supports sqlite 3.2.8 and you have to use
php's pdo functions and not the sqlite functions which only work with v2.
- Original Message -
From: Michael Young [EMAIL PROTECTED]
I am still having some problems compiling my code. I suspect it maybe
something to do with my app not linking (ld) with sqlite libraries, but I do
not know how to do this or it could be something else.
Can you advise?
-
- Original Message -
From: Teg [EMAIL PROTECTED]
To: Lloyd Thomas sqlite-users@sqlite.org
Sent: Sunday, September 10, 2006 12:47 AM
Subject: Re[2]: [sqlite] A lillte help adding sqlite to a c program
Hello Lloyd,
You need to escape the quotes. Remember in C and C++ means
Nearly there just a couple of outstanding issues any help apreciated
Error:--
make: Warning: File `logger.cpp' has modification time 45 s in the future
g++ -c -Wall -O -g logger.cpp -o logger.o
logger.cpp: In function `void* start_one_channel(void*)':
I know nothing of C++ and therefore need a lilte help editing a C++ app to
insert some records into a database.
This is where I am so far
#include sqlite.h
sqlite *db;
//insert record into database
+'+details.channel+','+details.filename+');
- Original Message -
From: Jay Sprenkle [EMAIL PROTECTED]
To: sqlite-users@sqlite.org
Sent: Saturday, September 09, 2006 11:16 PM
Subject: Re: [sqlite] A lillte help adding sqlite to a c program
On 9/9/06, Lloyd Thomas [EMAIL PROTECTED] wrote:
I
[EMAIL PROTECTED]
To: Lloyd Thomas sqlite-users@sqlite.org
Sent: Sunday, September 10, 2006 12:47 AM
Subject: Re[2]: [sqlite] A lillte help adding sqlite to a c program
Hello Lloyd,
You need to escape the quotes. Remember in C and C++ means the
beginning or end of a literal string so, when you
I am not sure if I am being crazy, but I seem to be getting a wierd result
when using 'BETWEEN'.
if use
SELECT count(call_id) as num_rows WHERE ring_time BETWEEN 6 and 10;
I get 0 results
but if I do
SELECT count(call_id) as num_rows WHERE ring_time = 7;
I get 39 results
SELECT count(call_id)
If i do
SELECT count(call_id) as num_rows WHERE ring_time BETWEEN 10 and 6;
I get 633 results.
Is that normal?
- Original Message -
From: Lloyd Thomas [EMAIL PROTECTED]
To: sqlite-users@sqlite.org
Sent: Saturday, March 25, 2006 3:48 PM
Subject: [sqlite] Wierd between results
I am
Go back to my original problem if I change 'between 6 and 10' to 'between 6
and 9', I get the expected results.
SELECT count(call_id) as num_rows WHERE ring_time BETWEEN 6 and 9;
232
Am I finding a bug or is my syntax incorrect?
- Original Message -
From: Lloyd Thomas [EMAIL PROTECTED
]
To: sqlite-users@sqlite.org
Sent: Saturday, March 25, 2006 5:39 PM
Subject: Re: [sqlite] Wierd between results
Lloyd Thomas [EMAIL PROTECTED] wrote:
if use
SELECT count(call_id) as num_rows WHERE ring_time BETWEEN 6 and 10;
I get 0 results
You DID specify a table in your actual queries, didn't
As you can tell I am no sql guru. Is there anyway I could do the following
without 'group by'.
query:
SELECT C.call_id, C.extn_no, C.dest, U.group_name
FROM call_data AS C, grp_user AS G, user_grp AS U
LEFT JOIN user_grp ON G.group_id = U.group_id
LEFT JOIN grp_user ON C.extn_no = G.extn_no
installed
sqlite 3.2.8 correctly for me. It would be good if I could type sqlite3 at
the prompt and it would just start.
Lloyd
- Original Message -
From: Arjen Markus [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, January 03, 2006 7:51 AM
Subject: Re: [sqlite] Building sqlite
The precompiled version did work. I was just trying to compile it myself to
get experience building a linux box.
Lloyd
- Original Message -
From: [EMAIL PROTECTED]
To: sqlite-users@sqlite.org
Sent: Tuesday, January 03, 2006 1:29 PM
Subject: Re: [sqlite] Building sqlite 3.2.8
I have compilted tcl, but had a problem with tk. having compiled sqlite3 I
get a new error trying to run sqlite3 =
'sqlite3: error while loading shared libraries: libsqlite3.so.0: cannot open
shared object file: No such file or diretory'
Any Ideas?
Lloyd
- Original Message -
From
There does not seem to be a library file in /usr/lib/ called
libsqlite3.so.0. would that be the problem. Please bear with me I am a linux
newbie.
Lloyd
- Original Message -
From: Arjen Markus [EMAIL PROTECTED]
To: sqlite-users@sqlite.org
Sent: Monday, January 02, 2006 12:13 PM
I am having a problem building sqlite on my redhat 9 box. There seems to be
a problem with TCL. I am no linux guru, so it some one can poinjt me in the
right direction that would be great.
here is as far as I get
[EMAIL PROTECTED]
I look into the build in function of SQLite and saw there is a function to know
the length of a string (in a record).
Great!
But to my disbelief there is (apparently) no way to get the size of a blob
(other than loading it :-()
And no, length() doesn't work on Blob.
I think it would be a
1 - 100 of 149 matches
Mail list logo