This may be an issue with the odbc driver. In the meanwhile, you could
try importing with the gui tool, sqlite3explorer
(www.sqlite.org/contrib). Afaik, it should import access ok.
> -Original Message-
> From: RAY BORROR [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 28, 2005 9:54 AM
>
> Saturday, March 26, 2005, 2:41:10 AM, you wrote:
>
>
> >> Hello sqlite-users,
> >>
> >> any news on that?
>
> > It's not part of the sql standard, so I would bet the answer
> > is going to be 'you have to add that yourself'. I did for
> > my project.
>
> How did you do that?
> Do you
Iulian Popescu said:
> Hi,
>
> Would someone please explain me the semantics of this function? I've
> tried:
>
> SELECT quote('AAA'') AS value
>
> And it returns the following error:
>
> Error: near "": syntax error (1)
Try SELECT quote('AAA\'') AS value
Not sure what purpose this
That doesn't work either - I get the same error.
>From the documentation:
This routine returns a string which is the value of its argument suitable
for inclusion into another SQL statement. Strings are surrounded by
single-quotes with escapes on interior quotes as needed. BLOBs are encoded
as
On Mon, 28 Mar 2005 11:57:10 -0500, Iulian Popescu <[EMAIL PROTECTED]> wrote:
> That doesn't work either - I get the same error.
> From the documentation:
>
> This routine returns a string which is the value of its argument suitable
> for inclusion into another SQL statement. Strings are
How about if the columnname is the AA'AA string? Wouldn't the still generate
a syntax error?
-Original Message-
From: Christopher Petrilli [mailto:[EMAIL PROTECTED]
Sent: Monday, March 28, 2005 12:04 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] quote() function
On Mon, 28 Mar
On Mon, 2005-03-28 at 12:03 -0500, Christopher Petrilli wrote:
> I suspect it was intended to be used like this:
>
> select quote(columname) from table;
>
Chris's suspicions are correct. quote() is especially useful
within triggers where the trigger generates SQL code that will
undo the change
On Mar 28, 2005, at 6:15 AM, Jay wrote:
I didn't add it to Sqlite, I added it to the class that makes
up the application that uses sqlite. If you want the c or c++
code it's freely available on the internet.
One could probably compile PCRE into SQLite...
http://www.pcre.org/
Regards,
David
Sorry if this is the wrong forum, but has anyone run into a problem with
leaking file handles when using SQLite with Perl DBI and DBD::SQLite?
I am calling finish() and disconnect() when I'm done with each
connection, but lsof reports my database file opens once for each
connection and never
Hello Cariotoglou,
Monday, March 28, 2005, 7:23:23 AM, you wrote:
> If you are working with delphi, I could have a solution for you.
>> -Original Message-
>> From: Jay [mailto:[EMAIL PROTECTED]
>> Sent: Saturday, March 26, 2005 3:41 AM
>> To: sqlite-users@sqlite.org; Win a 2
>>
Hi All,
Is there any description of SQL functions which are implemented in SQLite?
I mean functions like substr, mean, etc. (date and time functions have their
documentation in wiki)
Only in some source files of the SQLite?
Regards,
Adam
Adam,
Most of the functions (except date/time functions) are covered on this
page: http://www.sqlite.org/lang_expr.html
Many functions are intentionally left out of SQLite but can be easily
added.
Bob
Envision Information Technologies
Associate
[EMAIL PROTECTED]
v. 608.256.5680
f.
Dear D. Hipp,
Thank you very much for getting involved in this discussion. Would you
please give a concrete example of use of quote()?
Is it something wrong with doing a:
SELECT quote('AA'AA')
Thank you very much,
Iulian.
-Original Message-
From: D. Richard Hipp [mailto:[EMAIL
On Mon, 2005-03-28 at 13:27 -0500, Iulian Popescu wrote:
> Is it something wrong with doing a:
>
> SELECT quote('AA'AA')
>
Yes, it is a syntax error. The ' character within
a string in SQL is doubled to quote it - like in
Pascal. That's the rules of SQL - I did not make
this stuff up.
The
> I am just looking into building some "set top" like
> devices for a particular business application. I
> would like to use Sqlite to manage the data repository
> and I have been a perl developer for the last few
> years.
>
> Does anybody have a recommendation about which
> embeddable linux
I'm really sorry D. Hipps. My question was silly - I didn't realize that the
function arguments are also parsed by the SQL engine and therefore they
should be valid SQL strings.
I apologize for the annoyance.
Iulian.
-Original Message-
From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
Sorry.. I actually had a typo in that sample, but even with it fixed I
get the same results (just runs slower). New code with fixed typo:
#!/usr/bin/perl -w
use strict;
use DBI;
my ( $query, $table_name, $sth, $sth2, $dbh, $dbh2, @rows, @rows2,
$count ); my $database_name = "/home/brad/test.db";
I have been using sqlite successfully for ages with php5.
i recently got sqlitebrowser.. and when i open up my databases they
contain sql commands rather than the data i have stored in the databases...
they still work fine in php, but in the sqlitebrowser "browse data" tab,
it shows the tables,
drop table foo;
create table foo (x,y,z);
insert into foo values (1, null, null);
insert into foo values (2, null, null);
insert into foo values (3, 33, 333);
select x || "-" || y || "-" || z from foo;
whe I run the above select I only see the last row.
it looks as if a row has any nulls in the
Jim Dodgen <[EMAIL PROTECTED]> writes:
> drop table foo;
> create table foo (x,y,z);
> insert into foo values (1, null, null);
> insert into foo values (2, null, null);
> insert into foo values (3, 33, 333);
> select x || "-" || y || "-" || z from foo;
>
> whe I run the above select I only see
20 matches
Mail list logo
