Hi all
I have the following table + index
CREATE TABLE O_YDLRK_CK91_HIST
(
ISIN TEXT NULL,
BOERS_DATODATE NOT NULL,
TERM_DATO DATE NOT NULL,
AFDRAG_BELOEB REAL NULL,
RENTE_BELOEB REAL NULL,
CONSTRAINT
Nemanja,
I never knew this could happen. In one of my latest project I had to
use sed to convert data into csv. Later this data was imported by
import command. But the example stated here would reduce atleast one
step in my project. Moreover I am only concerned that the data may not
be tab
Thanks very much, the quote() helps a lot.
On Mon, 30 Jan 2006 [EMAIL PROTECTED] wrote:
> Shane Baker <[EMAIL PROTECTED]> wrote:
> > Are there any mechanisms that will display the [BLOB]
> > data in a human readable format?
>
> Assuming the table is: CREATE TABLE t1(x BLOB)
> You can do this:
>
Clint Bailey wrote:
Can you set up a field to auto-increment, and if so how?
Details are in the fourth paragraph of:
http://sqlite.org/lang_createtable.html
Summary: create table tbl(fieldname integer primary key autoincrement, ...)
HTH,
Gerry
http://www.sqlite.org/lang_createtable.html
Regards.
rayB
|-+>
| | Clint Bailey |
| | <[EMAIL PROTECTED]|
| | h.net> |
| ||
| |
Can you set up a field to auto-increment, and if so how?
The MSYS "start" command just circumvents the problem by starting a new clunky
Windows cmd window.
The Cygwin, Emacs and remote users logging into a Windows box via telnet/ssh
who prefer to work in
their native terminal program either have to hack the sqlite3 shell.c code to
force an
On Sun, Jan 29, 2006 at 08:30:57AM +0100, Marten Feldtmann wrote:
> Databases like DB2, MaxDB or Oracle offer you these recursive
> SQL statements. The main winning is, that you execute ONE query
> and retrieves all rows belonging to a sub tree, which is MUCH
> faster, that to execute multiple
Shane Baker <[EMAIL PROTECTED]> wrote:
> Are there any mechanisms that will display the [BLOB]
> data in a human readable format?
Assuming the table is: CREATE TABLE t1(x BLOB)
You can do this:
SELECT quote(x) FROM t1;
> For that matter, can I view an INTEGER
> column as hex in the output
I don't know if what I want to do is possible or not.
I have a schema that has a couple of BLOB columns where the data is
either:
1. Really random, or
2. May contain leading 0's
Either way, the results aren't really readable with SELECT using the
sqlite command line tool. Are there any
Merijn
sqlite.dll and the console utility were the first two programs that I ever
compiled on VS2005. VS is a bit of an "experience" compared to what I'm used
to - Delphi - so I just followed the wiki in very dumb step-by-step manner.
You don't need to download any files, as the sqlite.def file
Hi,
a look through openoffice howto docs reveals:
http://documentation.openoffice.org/HOW_TO/data_source/SQLite.pdf
Regards,
Eugene Wee
Jay Sprenkle wrote:
Yes, I saw a driver in the programmers documentation section
On 1/28/06, Tomàs Eroles i Forner <[EMAIL PROTECTED]> wrote:
Hello all!
Is
nbiggs wrote:
I get the following error if I try to use the IF NOT EXISTS function.
If I take out the "IF NOT EXISTS", the statement creates the index.
The same happens when I try using IF NOT EXISTS in a CREATE table
statement.
CREATE UNIQUE INDEX IF NOT EXISTS idx_table ON table (field1,
I get the following error if I try to use the IF NOT EXISTS function.
If I take out the "IF NOT EXISTS", the statement creates the index.
The same happens when I try using IF NOT EXISTS in a CREATE table
statement.
CREATE UNIQUE INDEX IF NOT EXISTS idx_table ON table (field1, field2);
SQL error:
Yes, I saw a driver in the programmers documentation section
On 1/28/06, Tomàs Eroles i Forner <[EMAIL PROTECTED]> wrote:
> Hello all!
> Is it possible to access and work with SQLite databases with Open Office
> Base?
[EMAIL PROTECTED] wrote:
"Dan Petitt" <[EMAIL PROTECTED]> wrote:
I think (looking at the source) that it's a pragma, but I don't know when
you set it, once when DB is opened, on each write or on each read.
You are the third to ask (including me), maybe Richard or someone else can
through some
[EMAIL PROTECTED] wrote:
Hi all,
The situation is:
i have two DBs - one in memory and one in the filesystem. I
need to fill some tables in the second DB from the fist DB.
So, how can I ATTACH DATABASE from memory?
(unfortunately ATTACH DATABASE ":memory:" AS mem; fails ...)
It works for me.
[EMAIL PROTECTED] writes:
> The situation is:
> i have two DBs - one in memory and one in the filesystem. I
> need to fill some tables in the second DB from the fist DB.
> So, how can I ATTACH DATABASE from memory?
> (unfortunately ATTACH DATABASE ":memory:" AS mem; fails ...)
You need to ATTACH
Merijn Vandenabeele wrote:
Hi,
I'd like to compile SQLite v3.3.2 using Visual Studio .NET 2003. I found a
reference to a solution in the wike but I couldn't find a link to download the
file. How should I compile SQLite from source?
Best regards,
Merijn Vandenabeele
Hi all,
The situation is:
i have two DBs - one in memory and one in the filesystem. I
need to fill some tables in the second DB from the fist DB.
So, how can I ATTACH DATABASE from memory?
(unfortunately ATTACH DATABASE ":memory:" AS mem; fails ...)
Regards
E.
-
Ritesh Kapoor <[EMAIL PROTECTED]> wrote:
> Yes.
> My machine has NFS and the machines I log onto also have NFS. But if
> this is the problem then why dosen't it appear on my machine when I run
> the app.
Perhaps you are using a local filesystem when you run on
your machine. Or perhaps NFS is
Hi,
I'd like to compile SQLite v3.3.2 using Visual Studio .NET 2003. I found a
reference to a solution in the wike but I couldn't find a link to download the
file. How should I compile SQLite from source?
Best regards,
Merijn Vandenabeele
Yes.
My machine has NFS and the machines I log onto also have NFS. But if
this is the problem then why dosen't it appear on my machine when I run
the app.
Is there a workaround for this? without having to change the file system
from NFS.
Thanks,
Ritesh
On Mon, 2006-01-30 at 18:12, [EMAIL
"Dan Petitt" <[EMAIL PROTECTED]> wrote:
> I think (looking at the source) that it's a pragma, but I don't know when
> you set it, once when DB is opened, on each write or on each read.
>
> You are the third to ask (including me), maybe Richard or someone else can
> through some light on it for
Ritesh Kapoor <[EMAIL PROTECTED]> wrote:
>
> Can anyone suggest what the problem is with sqlite when running apps on
> different machines.
This happens sometimes when NFS us misconfigured so that it
does not support fcntl() file locks. The lock requests always
fail, hence SQLite always returns
"shum [Ming Yik]" <[EMAIL PROTECTED]> wrote:
>
> create table test01( FLD01 char(3) default '');
> create table test02( FLD01 char(3) default '');
>
> insert into test01(FLD01) values('001');
> insert into test01(FLD01) values('002');
>
> insert into test02 select * from test01 ;
>
>
>
>
I think (looking at the source) that it's a pragma, but I don't know when
you set it, once when DB is opened, on each write or on each read.
You are the third to ask (including me), maybe Richard or someone else can
through some light on it for us.
Dan Petitt
27 matches
Mail list logo