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 XPKO_YDLRK_CK91_HIS
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 limite
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> |
| ||
| | 31/01/2
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 interactive
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 quer
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 wi
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 mechan
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 is
if you can send that to me
On 1/30/06, Nemanja Corlija <[EMAIL PROTECTED]> wrote:
> On 1/30/06, Clint Bailey <[EMAIL PROTECTED]> wrote:
> > Is it possible to import tab delimited data into sqlite in order to
> > start testing?
> You can use sqlite3 command for that. Something like this:
>
> E:\SQL
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
Hi D. Richard Hipp,
I'm not sure what it is you are doing wrong. Are you
typing this in at the command-line shell? Or are you
using some kind of language binding?
I am using Sqlitecc
http://bobmanc.home.comcast.net/sqlitecc.html
And Klint Gore, Show me it is Slqitecc 's bug
Now Sqlite work
[EMAIL PROTECTED] wrote:
The shell likely does not believe that it is running interactively for some
reason, and so is not presenting prompts. Look at the documentation for the
shell to figure out how to tell it to go into interactive mode.
Derrell
You are correct. This is a common probl
Me neither. With SQLite3Explorer, the SQL statement:
insert into table01 select * from table02
works perfectly. Shum, you need to find the problem elsewhere... perhaps
the data of table02 is already
in table01??
/R
On Sun, 29 Jan 2006 13:53:22 -0500, <[EMAIL PROTECTED]> wrote:
"shum [Ming
It is supposed to create the index if it does not exist already without
any errors.
I found the on the sqlite web site at
www.sqlite.org/lang_createindex.html, so I expected it to work since the
header on the web page is SQL As Understood By SQLite.
-Original Message-
From: Igor Tand
"nbiggs" <[EMAIL PROTECTED]> 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
Merijn Vandenabeele wrote:
I know where I can download the sources, but there's no makefile or
visual studio project or anything like that included. What should I do
with this bunch of headers and c-files to create a dll?
Create a standard windows dll project, add all the *.c files to it
cr
[EMAIL PROTECTED] wrote:
and Derrell,
You need to ATTACH the disk-resident database to the memory one,
rather than vice versa as you're trying. Since you already have the
database handle for the memory-resident database, issue an "ATTACH
'diskdatabase.db' AS disk_db;" command on the memory-res
Quoting Igor Tandetnik ([EMAIL PROTECTED]):
> nbiggs wrote:
> >CREATE UNIQUE INDEX IF NOT EXISTS idx_table ON table (field1, field2);
> >SQL error: near "NOT": syntax error
>
> I've never seen such syntax. SQLite does not support it. What is it
> supposed to mean anyway?
I think it's a MySQL-ism
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, field
Цитат на писмо от Gerry Snyder <[EMAIL PROTECTED]>:
Dear Gerry,
> >
> It works for me.
>
> How do you know it fails? Do you get an error message? If
> so, what???
>
> Do you have one process creating the memory DB and
> another trying to
> access it?
>
> More details are needed.
ok, here is a
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
I know where I can download the sources, but there's no makefile or visual
studio project or anything like that included. What should I do with this
bunch of headers and c-files to create a dll?
Merijn
- Original Message -
From: "Craig Morrison" <[EMAIL PROTECTED]>
To:
Sent: Monday
[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
http://www.sqlite.org/sql
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.
-
Sl
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 co
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 PROTECT
"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 us.
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 ;
>
>
>
> then
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
D
Hi,
I'm using sqlite 3.0.8 on Linux v2.4.21. I keep seeing an error
"database is locked" whenever I run my application.
This error occurs only when I login to another machine from mine and
then run it. If I run the app on my own machine it works fine.
I've tried to debug using gdb and found ou
Hi Klint Gore,
The bug is in sqlitecc
Thanks for your information.
I try my application directly,
Yes Sqlite works fine ...
Now it is fine for me
Thanks again !
Shum
www.mingyik.com
- Original Message -
From: "Klint Gore" <[EMAIL PROTECTED]>
To:
Sent: Monday, January
40 matches
Mail list logo