Re: [sqlite] Code problem

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

Re: [sqlite] SQL Lite date / time functions

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

Re: [sqlite] Code problem

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

Re: [sqlite] Code problem

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:

[sqlite] Code problem

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

Re: [sqlite] Most wanted features of SQLite ?

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

Re: [sqlite] Reading "packed" data

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

Re: [sqlite] Most wanted features of SQLite ?

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.

Re: [sqlite] Most wanted features of SQLite ?

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

Re: [sqlite] Most wanted features of SQLite ?

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

Re: [sqlite] Reading "packed" data

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

Re: [sqlite] SQLite Date problem

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

[sqlite] Sqlite profiler

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

Re: [sqlite] Most wanted features of SQLite ?

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

Re: [sqlite] Reading "packed" data

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

Re: [sqlite] Most wanted features of SQLite ?

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

Re: [sqlite] How can I do to build this query with a text that contains ' and "?

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

Re: [sqlite] Most wanted features of SQLite ?

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

Re: [sqlite] Most wanted features of SQLite ?

>> 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

Re: [sqlite] How can I do to build this query with a text that contains ' and "?

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 > >

Re: [sqlite] Reading "packed" data

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

[sqlite] How can I do to build this query with a text that contains ' and "?

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

Re: [sqlite] Most wanted features of SQLite ?

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

Re: [sqlite] blocking when locking

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

Re: [sqlite] Reading "packed" data

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

Re: [sqlite] SQLite Date problem

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 >>

Re: [sqlite] Most wanted features of SQLite ?

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

Re: [sqlite] Most wanted features of SQLite ?

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

Re: [sqlite] SQLite Date problem

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

Re: [sqlite] Most wanted features of SQLite ?

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

Re: [sqlite] blocking when locking

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 somebody else