Re: [sqlite] SQL Syntax from 2.8 to 3.0 not backward compatible?

2004-06-25 Thread Guillaume Fougnies 
Ok.
Perhaps it should be written in the documentation of
"SQLite Version 3" or in the chapter "Transaction Control At The SQL
Level" of the "Locking And Concurrency In SQLite Version 3".

Thanks.
bye.

Fri, Jun 25, 2004 at 04:22:10AM -0700: Daniel K wrote:
> A BEGIN cannot have an ON CONFLICT clause in sqlite
> version 3.
>
> Dan.
>
>
> --- Guillaume Fougnies <[EMAIL PROTECTED]> wrote:
> > Here is it:
> >
> > SQLite version 3.0.1
> > Enter ".help" for instructions
> > sqlite> BEGIN TRANSACTION ON CONFLICT ROLLBACK;
> > SQL error: near "ON": syntax error
> >
> > bye.

--
Guillaume FOUGNIES

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] SQL Syntax from 2.8 to 3.0 not backward compatible?

2004-06-25 Thread Daniel K 
A BEGIN cannot have an ON CONFLICT clause in sqlite
version 3.

Dan.


--- Guillaume Fougnies <[EMAIL PROTECTED]> wrote:
> Here is it:
> 
> SQLite version 3.0.1
> Enter ".help" for instructions
> sqlite> BEGIN TRANSACTION ON CONFLICT ROLLBACK;
> SQL error: near "ON": syntax error
> 
> bye.
> --
> Guillaume FOUGNIES
> 
>
-
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
> 
> 





__
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail 

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] SQL Syntax from 2.8 to 3.0 not backward compatible?

2004-06-25 Thread Guillaume Fougnies 
Here is it:

SQLite version 3.0.1
Enter ".help" for instructions
sqlite> BEGIN TRANSACTION ON CONFLICT ROLLBACK;
SQL error: near "ON": syntax error

bye.
--
Guillaume FOUGNIES

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]