--- [EMAIL PROTECTED] wrote:
> I am trying to write my first application using sqlite in perl.
> The perl part is no problem, but I have not used sql before and
> am having some difficulty.
>
> I have three tables:
>
> CREATE TABLE i2u(i UNIQUE, u);
> INSERT INTO i2u
Hello,
I'm using in memory tables that are copies of file tables.
I create the in memory tables by opening an in memory database, and
attaching a file database to it.
I then copy the table to my in memory database using something like
"create table t_mem as select * from t_file".
This gets the
Hi Tiago,
Unfortunately, I cannot always specify the column names. I wrote a
framework used by other developers, so I must honor whatever SQL
query they decide to execute.
I just hope to see a fix for this soon.
Thanks a lot for your answer,
-- Tito
On 20/05/2005, at 18:26, Tiago Dionizio
Hello Tim,
OK... so I'm not the only one!
I didn't know what else to try... does anyone have a workaround or
trick of some sort? Is this a known bug?
Thanks,
-- Tito
On 20/05/2005, at 14:24, Tim McDaniel wrote:
-Original Message-
From: Tito Ciuro [mailto:[EMAIL PROTECTED]
Sent: Friday,
I am trying to write my first application using sqlite in perl.
The perl part is no problem, but I have not used sql before and
am having some difficulty.
I have three tables:
CREATE TABLE i2u(i UNIQUE, u);
INSERT INTO i2u VALUES('i1','u1');
INSERT INTO i2u
On May 20, 2005, at 11:46 AM, Rob Laveaux wrote:
You can't use a WHERE clause on the result of an aggregation. Use
HAVING instead.
This should work:
select sum(ft) as Pts, pkey from playergame group by pkey having
Pts > 15
Doh! Yes, that is it. Thanks a lot.
On 20-mei-05, at 20:37, Will Leshner wrote:
select sum(ft) as Pts, pkey from playergame where Pts > 15 group by
pkey
I just get back one record with "0" for the value of Pts. I guess what
I was trying to do was get back results something like the first
query, but for only those sums of ft that
> -Original Message-
> From: Tito Ciuro [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 20, 2005 1:07 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Is 'full_column_names' still broken?
>
> Hello Tiago,
>
> On 20/05/2005, at 7:08, Tiago Dionizio wrote:
>
> > On 5/20/05, Tito
Bom dia, Maurício!
Já estou trabalhando direitinho no Linux.
Você está usando oSQLite com que propósitos?
Até mais,
Cláudio
--- "Mauricio M. Maia" <[EMAIL PROTECTED]>
escreveu:
> Claudio,
>
> you need to execute like:
> $ ./sqlite3-3.2.1.bin
>
> PS: If you want, send a private message to
> pwd is not in your path.
> try ./sqlite3-3.2.1.bin
Thanks toi everybody!
It worked very well!!!
Cláudio
> also make sure it's got the right permissions:
>
> chmod a+x sqlite3-3.2.1.bin
>
> HTH,
> B
>
> Claudio Bezerra Leopoldino wrote:
> > Hi!
> >
> > I've used the windows command line
> The problem is that, when I send a query that uses a Tcl-defined SQL
> function to the database, it starts allocating memory that is not freed
> afterwards, until I close the Tcl interpreter.
Memory leak in Tcl interface code. Fixed in cvs now.
Hello,
I am having a problem with the memory usage of SQLite, when using from Tcl.
Could you tell me if any of you has had similar problems?
The problem is that, when I send a query that uses a Tcl-defined SQL
function to the database, it starts allocating memory that is not freed
afterwards,
12 matches
Mail list logo