hello drh, list
I used to think that only in my country they can forbid
knives and forks because someone can misuse them, but
obviously it is true for other countries too.
Regards,
Emily
-
Спортни залагания!
bg.sportingbet.com
-
hi all
i have two questions:
1) how can i build sqlite3 with static libs? ; in my case I
have multiple versions of sqlite3 and their dynamic libs
...
2) what i have to do after this message:
"""
cp ../sqlite-3.3.9/www/common.tcl .
tclsh ../sqlite-3.3.9/www/arch.tcl >arch.html
In FreeBSD, tclsh is
hi list
in other DBs one can create time stamp column with
CREATE TABLE todo (
id serial primary key,
title text,
created timestamp default now(),
done boolean default 'f'
);
in SQLITE probably I have to add a trigger on the INSERT
event (right?) to do the same:
CREATE TABLE todo (
id
Igor,
thank you very much!
BTW, yes, the schema is 'as is' and i have to convert it,
but how to converts rows to columns and add to other
columns? ;-)
Regards,
e.
Цитат на писмо от Igor Tandetnik <[EMAIL PROTECTED]>:
> [EMAIL PROTECTED] wrote:
> > it there a way to execute a SQL query generate
hi all,
it there a way to execute a SQL query generated by SELECT ?
for eg. :
select 'insert into plan (personid, curseid, statid) select
tbl.excelid, ' || id || ',status.id from tbl, status where
tbl.' || fldname || ' = status.name ;' from curses;
regards
emily
-
Sl
yes you are correct,
but even when i rewrite the typo, there was no result (i got
an empty one)
i mean with the originald table, not the present in letter
(i got it with sqlite explorer export function)
but when i select all from the db with sqlite.exe i saw,
that in this column the data was ... NU
thanks
actualy the problem was in the sqlite explorer because the
column was defined as integer and any text is interpreted
as zero :-)
Цитат на писмо от Guillaume MAISON <[EMAIL PROTECTED]>:
> [EMAIL PROTECTED] a ?crit :
> > hi guys
> > i need help :-)
> >
> > what is the problem :
> > (SQLite
hi guys
i need help :-)
what is the problem :
(SQLite version 3.3.4, win XP)
i have a table:
CREATE TABLE plan(personid INTEGER, curseid INTEGER, statid
INTEGER);
INSERT INTO plan VALUES(1,1,0);
INSERT INTO plan VALUES(2,1,0);
INSERT INTO plan VALUES(3,1,0);
INSERT INTO plan VALUES(4,1,NULL);
IN
hi Steve
for me you are absolutely right and this is the sintuation
in sqlite3explorer.
with a simple rename (the old one), copy & rename of the DLL
you can deal with any of the sqlite issues!
regards,
e.
Цитат на писмо от Steve O'Hara
<[EMAIL PROTECTED]>:
> Hi Ralf,
>
> SqliteSpy is a nice tool
Цитат на писмо от Clint Bailey <[EMAIL PROTECTED]>:
> Can anyone point me to web sites that are powered by
> Sqlite? I'm curious
> as to how they function as compared to a MySQL, or brand
> M$ powered site.
>
>
>
yes - www.sqlite.org
-
Slon.bg ™
Симпатичният магази
Цитат на писмо от 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
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
hi DAniel
i had similar probme and at the end i had to build my own
tool to migrate from csv to sql ...
maybe it will solve your problem too?
regards
e.
Цитат на писмо от Daniel de Matos Alves
<[EMAIL PROTECTED]>:
> PLEASE, read my e-mail, i really need help ;-)
>
>
> I am trying to import dat
hi guys,
this query works in sqlite 3.x
SELECT * FROM logs LIMIT (SELECT lmt FROM base);
but in sqlite2.8.17 it generates error .. near to ( ! Is
this normal??
regards
e.
-
Slon.bg ™
Симпатичният магазин за
книги, DVD, игри и музика
http://www.slon.bg
hi
maybe the GMT is obsolete. The new time-standart becomes BMT
- Biel Mean Time, which is linked up to the Central European
Winter/Standard time - which is UTC + 1 hour (aka internet
time).
regards
e.
Цитат на писмо от John Stanton <[EMAIL PROTECTED]>:
> Brad wrote:
> >> I am looking for a sim
Hi,
what is the difference between sqlite3.exe (the command-line
shell) and an application which calls sqlite3_get_table()?
Because the same sql script gives different results! :-)
the script:
In sqlite327.exe:
CREATE TABLE accounts (us TEXT, pw TEXT, md5 TEXT, UNIQUE
(us));
INSERT INTO accounts
Hi all,
Where can i find a framework (or example) to incorporate
SQLITE in a CGI (written in C)?
Regards,
Emilya
-
Всички говорят безплатно.
Каквото изговориш до 6-ти януари, се презарежда по твоята vivatel сметка на
7-ми януари.
http://www.vivatel.bg/
17 matches
Mail list logo