Hello!
On Monday 21 September 2009 05:44:31 D. Richard Hipp wrote:
> Is the content of the "date" field either a julian day number or an
> ISO-8601 format date string?
Please speak is now correct to store 'start of month' dates in julianday
format? Does SQLite now uses internal reprezentation o
Hello!
On Monday 21 September 2009 01:45:07 Fred Williams wrote:
> With the background of the never ending drumbeat of "feature, feature,
> feature..." on this list as a reason, I wonder if the structure of
> SQLite could be "enhanced" to better support the "plug-in" concept, aka:
> as with Firefo
Thank you Robert and Simon. I knew it would be something simple, but
I'm still a newbie. Hopefully some day I can help you.
Jimmy Verner
www.vernerlegal.com
On Sep 20, 2009, at 6:47 PM, Simon Slavin wrote:
>
> On 21 Sep 2009, at 12:30am, Jimmy Verner wrote:
>
>> person's
>
> You're using sin
On Sep 18, 2009, at 7:59 PM, Mike Nolting wrote:
> Mr Hipp
>
> I am unable to make any of the date time functions work using your
> examples on your web site when applying to
> data in a table.
> The 'now' variable works great, but there seems to be no way to use
> data from a select query fr
On 21 Sep 2009, at 12:30am, Jimmy Verner wrote:
> person's
You're using single quotes to surround the text, and there's an
apostrophe in the middle of the text. I make this mistake a lot with
PHP and it's really annoying.
Simon.
___
sqlite-users
You've got single quotes in the body of your text that need to be doubled:
'Rule 404. Character Evidence not Admissible to
Prove Conduct; Exceptions; Other Crimes(A)
Character evidence generally. Evidence of a person'[<-- right here]s
character .
-Original Message-
From: sqlit
I can't add this record (and several others) to my table. Most of the
records did load, both before and after this one.
If anyone can let me know what the problem is, I would be most
grateful. Here is the table setup:
CREATE TABLE "rules" ("number" NUMERIC PRIMARY KEY NOT
NULL ,"section"
Can you say Oracle? :-)
Along this same line, and based on a few years of using SQLite and
following the messages on this list, here's my two cents worth.
First a disclaimer: I have no knowledge of the detailed implementation
and architecture of SQLite, other than by inference from discussions on
On 20 Sep 2009, at 8:06pm, Mohit Sindhwani wrote:
> Kees Nuyt wrote:
>> On Sun, 20 Sep 2009 12:02:17 +0800, Mohit Sindhwani
>> wrote:
>>
>>> Hi! An embedded SQL-based database that we used earlier had a
>>> concept
>>> of packed fetches - this would mean that we could create a certain
>>> buf
StepSqlite PL/SQL compiler for SQLite is certainly not for all.
It is simply aimed at what we believe is a majority.
http://www.metatranz.com/stepsqlite/
regards,
-sk
>>But I write stored procedures and triggers for PostgreSQL on Tcl. PL/pgSQL or
>>PL/SQL is not the best solution to all.
__
Having to support a dedicated language for stored-preocedures sounds to me
like an overkill, PL/SQL or not. IMHO having the ability to store complex
queries in the standard TSQL syntax already supported today for queries,
plus basic extra stuff only like loops, and have their compiled version
execu
As Igor mentioned in a previous post, Hebrew has no capital and lower case
versions of a letter. It has only what's called Mantzpach, which are 5
letters which look different if in the end of a word; IIRC this is never an
issue since they are ordered right after the original letter, and have their
Kees Nuyt wrote:
> On Sun, 20 Sep 2009 12:02:17 +0800, Mohit Sindhwani
> wrote:
>
>
>> Hi! An embedded SQL-based database that we used earlier had a concept
>> of packed fetches - this would mean that we could create a certain
>> buffer for results, prepare a query, execute it and read back
P Kishor wrote:
> On Sun, Sep 20, 2009 at 4:16 AM, Dan Bishop wrote:
>
>> Max_wang wrote:
>>
>>> A few months ago,I used SQLite 3.5.0 execute SQL:"SELECT
>>> date(253392451200.0,
>>> 'unixepoch');"
>>> The result was "-09-09".
>>>
>>> But now I use SQLite 3.6.18 replace it,this SQL ex
Hello,
Is there anyone interested in sqlite profiler? If yes what features would
you like to see?
Thank you.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hello!
On Sunday 20 September 2009 18:16:19 sub sk79 wrote:
> PL/SQL has a very wide user-base and a huge repository of existing
> code-base in the world. Using StepSqlite PL/SQL compiler this huge
> base can use SQLite by reusing their code as well as reusing their
> skills - no learning curve fo
Igor Tandetnik wrote:
> Mohit Sindhwani wrote:
>
>> Hi! An embedded SQL-based database that we used earlier had a concept
>> of packed fetches - this would mean that we could create a certain
>> buffer for results, prepare a query, execute it and read back the
>> results in "groups" of 10 or 20
Can you say Oracle? :-)
Along this same line, and based on a few years of using SQLite and following
the messages on this list, here's my two cents worth.
First a disclaimer: I have no knowledge of the detailed implementation and
architecture of SQLite, other than by inference from discussions on
Thanks, now work fine
BestRegards
GVS
Simon Davies escribió:
> 2009/9/20 Guillermo Varona Silupú :
>
>> Hi
>> I want to insert this text:
>>
>> 1' equivale a 12"
>>
>> cQry := "INSERT INTO Tabla1 (Code,Equiv) VALUES (10, "1' equivale a 12"")
>>
>
> INSERT INTO Tabla1 (Code,Equiv) VALUES (
Guillermo Varona Silupú wrote:
> I want to insert this text:
>
> 1' equivale a 12"
>
> cQry := "INSERT INTO Tabla1 (Code,Equiv) VALUES (10, "1' equivale a
> 12"")
What language is that? ':=' suggests Pascal, but string literals in
Pascal use single quotes.
In SQL, string literals are surrounded
>> 1. Generate a loadable SQLite extension and distribute it with DB.
>
> We can write C extension without any wrapper. Why we need to learn
> your extension for getting the same result and possible new bugs?
PL/SQL has a very wide user-base and a huge repository of existing
code-base in the worl
2009/9/20 Guillermo Varona Silupú :
> Hi
> I want to insert this text:
>
> 1' equivale a 12"
>
> cQry := "INSERT INTO Tabla1 (Code,Equiv) VALUES (10, "1' equivale a 12"")
INSERT INTO Tabla1 (Code,Equiv) VALUES (10, '1'' equivale a 12"');
>
> TIA
> Best Regards
> GVS
>
> P.D.: Sorry for the post p
On Sun, 20 Sep 2009 12:02:17 +0800, Mohit Sindhwani
wrote:
>Hi! An embedded SQL-based database that we used earlier had a concept
>of packed fetches - this would mean that we could create a certain
>buffer for results, prepare a query, execute it and read back the
>results in "groups" of 10 o
Hi
I want to insert this text:
1' equivale a 12"
cQry := "INSERT INTO Tabla1 (Code,Equiv) VALUES (10, "1' equivale a 12"")
TIA
Best Regards
GVS
P.D.: Sorry for the post past and my bad english
___
sqlite-users mailing list
sqlite-users@sqlite.org
h
Hi
I want to insert this text:
1' equivale a 12"
cQry := "INSERT INTO Tabla1 (Code,Equiv) VALUES (10, "1' equivale a 12"")
TIA
Best Regards
GVS
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sql
Wenbo Zhao wrote:
> I was talking about this example by
> 2009/9/19 Igor Tandetnik
> "Imagine the
> classic example, where a transaction first verifies that the balance
> in a bank account is sufficient, then performs a withdrawal. If it
> relinquishes all locks between these two steps, then someb
Mohit Sindhwani wrote:
> Hi! An embedded SQL-based database that we used earlier had a concept
> of packed fetches - this would mean that we could create a certain
> buffer for results, prepare a query, execute it and read back the
> results in "groups" of 10 or 20 or 1000 (or "n") results per cal
On Sun, Sep 20, 2009 at 4:16 AM, Dan Bishop wrote:
> Max_wang wrote:
>> A few months ago,I used SQLite 3.5.0 execute SQL:"SELECT date(253392451200.0,
>> 'unixepoch');"
>> The result was "-09-09".
>>
>> But now I use SQLite 3.6.18 replace it,this SQL execute result is
>> "-1413-03-01".
>>
>> Is
Hello!
On Sunday 20 September 2009 08:05:04 Darren Duncan wrote:
> The more general solution here to the duplicate column name problem is to be
> stricter than the SQL standard and treat attempts to return duplicate column
> names as a syntax or constraint error. For example, if you had 2 table
Hello!
On Sunday 20 September 2009 02:42:30 Darren Duncan wrote:
> As for Tcl, well one solution there is to create a new singleton TCL type and
> use its one value to correspond to NULL, and so then empty string will
> continue
> to just mean empty string, as it should. Not being able to dist
Max_wang wrote:
> A few months ago,I used SQLite 3.5.0 execute SQL:"SELECT date(253392451200.0,
> 'unixepoch');"
> The result was "-09-09".
>
> But now I use SQLite 3.6.18 replace it,this SQL execute result is
> "-1413-03-01".
>
> Is this a Bug?
>
Apparently so. And the problem first occur
Hello!
On Sunday 20 September 2009 02:45:32 sub sk79 wrote:
> 1. Generate a loadable SQLite extension and distribute it with DB.
We can write C extension without any wrapper. Why we need to learn
your extension for getting the same result and possible new bugs?
> 2. If distributing loadable e
32 matches
Mail list logo