Murray Moffatt wrote:
I would like to tidy up the schema's of a few tables. At the moment
all of the fields run together on the same line, i.e. something like
this:
sqlite> .schema materials
CREATE TABLE Materials (MaterialType varchar(10) not null,
MaterialCode varchar(
10) not null, Descript
I would like to tidy up the schema's of a few tables. At the moment all of
the fields run together on the same line, i.e. something like this:
sqlite> .schema materials
CREATE TABLE Materials (MaterialType varchar(10) not null, MaterialCode
varchar(
10) not null, Description varchar(50),Quantit
Hi,
I have just compiled Sqlite for PowerPc 8XX and I'm trying to open a new
database but i'm getting the error
below.
/mnt/nfs/TesteSqlite # ./sqlite test.db
./sqlite: error while loading shared libraries: libsqlite.so.0: cannot open
shared object file: No such file or
directory
I try to
Christopher Petrilli wrote:
On 5/3/05, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
On Tue, 2005-05-03 at 17:52 -0400, Christopher Petrilli wrote:
I'm wondering if the availability of 128-bit numbers has ever been
contemplated? The reason I'm asking is that I have an application that
needs to
On Tue, 2005-05-03 at 18:55 -0400, Tom Shaw wrote:
At 6:09 PM -0400 5/3/05, D. Richard Hipp wrote:
>On Tue, 2005-05-03 at 17:45 -0400, Tom Shaw wrote:
>> Hi.
>>
>> I was using SQLite with PHP 5 (MacOSX) and due to some issues the php
>> page timedout before completing the DB update. Now I
On Tue, 2005-05-03 at 18:25 -0400, Christopher Petrilli wrote:
> On 5/3/05, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
> > On Tue, 2005-05-03 at 17:52 -0400, Christopher Petrilli wrote:
> > > I'm wondering if the availability of 128-bit numbers has ever been
> > > contemplated? The reason I'm askin
On Tue, 2005-05-03 at 18:55 -0400, Tom Shaw wrote:
> At 6:09 PM -0400 5/3/05, D. Richard Hipp wrote:
> >On Tue, 2005-05-03 at 17:45 -0400, Tom Shaw wrote:
> >> Hi.
> >>
> >> I was using SQLite with PHP 5 (MacOSX) and due to some issues the php
> >> page timedout before completing the DB update.
At 6:09 PM -0400 5/3/05, D. Richard Hipp wrote:
On Tue, 2005-05-03 at 17:45 -0400, Tom Shaw wrote:
Hi.
I was using SQLite with PHP 5 (MacOSX) and due to some issues the php
page timedout before completing the DB update. Now I can't read the
DB via php nor via the sqlite command line tool. I kee
On 5/3/05, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
> On Tue, 2005-05-03 at 17:52 -0400, Christopher Petrilli wrote:
> > I'm wondering if the availability of 128-bit numbers has ever been
> > contemplated? The reason I'm asking is that I have an application that
> > needs to store IPv6 addresses,
On Tue, 2005-05-03 at 17:45 -0400, Tom Shaw wrote:
> Hi.
>
> I was using SQLite with PHP 5 (MacOSX) and due to some issues the php
> page timedout before completing the DB update. Now I can't read the
> DB via php nor via the sqlite command line tool. I keep getting DB
> busy/DB locked. How do
On Tue, 2005-05-03 at 17:52 -0400, Christopher Petrilli wrote:
> I'm wondering if the availability of 128-bit numbers has ever been
> contemplated? The reason I'm asking is that I have an application that
> needs to store IPv6 addresses, which are 128bits. Right now, I'm
> storing them in 2 64-bit
I'm wondering if the availability of 128-bit numbers has ever been
contemplated? The reason I'm asking is that I have an application that
needs to store IPv6 addresses, which are 128bits. Right now, I'm
storing them in 2 64-bit fields, but this obviously complicates the
query quite a bit.
Thought
Hi.
I was using SQLite with PHP 5 (MacOSX) and due to some issues the php
page timedout before completing the DB update. Now I can't read the
DB via php nor via the sqlite command line tool. I keep getting DB
busy/DB locked. How do I repair the DB and remove the "lock"and
either 1) try to reco
Hi,
The SQLite documentantion 'Distinctive Features' says:
"If you store a single character in a VARCHAR(100)
column, then only a single byte of disk space is
consumed. (Actually two bytes - there is some overhead
at the beginning of each column to record its datatype
and length.)"
I would like
Understood.
I fall into case 5, and this is definitely not the way they're
represented. So assuming my code was correct, and the documentation
refers to 3.2.1, the documentation is STILL incorrect?
Regards,
Steve
-Original Message-
From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
Sent:
On Tue, 2005-05-03 at 15:09 +0100, Drew, Stephen wrote:
> This is not the case for the version of SQLite 3.2.1 I am using. Is
> the documentation incorrect, or am I doing anything wrong?
>
Documentation is wrong. See http://www.sqlite.org/cvstrac/wiki?
p=ColumnNames
--
D. Richard Hipp <[EM
Hello,
Sorry to keep on harping on about this, but the documentation for the
full_column_names pragma states clearly:
"...Normally, such result columns are named
if the SELECT statement joins two or
more tables together, or simply if the SELECT statement
queries a single table."
This is not
17 matches
Mail list logo