Re: [sqlite] syntax error near AS

2017-07-06 Thread John McMahon
On 06/07/2017 17:01, Domingo Alvarez Duarte wrote: I already did this before but it was not accepted. For myself I did a modification on sqlite3 to allow the use of "AS" on delete/update statements. You can see the parser part here

Re: [sqlite] syntax error near AS

2017-07-06 Thread John McMahon
ror message if they are not the same as the updated table). -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of John McMahon Sent: Wednesday, 5 July, 2017 21:17 To: SQLite Users Subjec

Re: [sqlite] syntax error near AS

2017-07-06 Thread John McMahon
On 06/07/2017 16:33, Clemens Ladisch wrote: John McMahon wrote: an alias for an "UPDATE" table name is not permitted. Is there a particular reason for this? The UPDATE statement affects a single table. While an alias might be a convenience, it is not necessary (any naming conflicts in

Re: [sqlite] syntax error near AS

2017-07-06 Thread John McMahon
On 06/07/2017 15:03, Keith Medcalf wrote: Do you know of any implementation of SQL that accepts an AS clause for the updated table? I don't think any do. No Keith, I don't. My only exposure to SQL is sqlite. Some versions have a FROM extension and you CAN specify an alias for the

Re: [sqlite] syntax error near AS

2017-07-06 Thread John McMahon
On 06/07/2017 17:01, Domingo Alvarez Duarte wrote: I already did this before but it was not accepted. For myself I did a modification on sqlite3 to allow the use of "AS" on delete/update statements. You can see the parser part here

Re: [sqlite] syntax error near AS

2017-07-06 Thread John McMahon
On 06/07/2017 16:33, Clemens Ladisch wrote: John McMahon wrote: an alias for an "UPDATE" table name is not permitted. Is there a particular reason for this? The UPDATE statement affects a single table. While an alias might be a convenience, it is not necessary (any naming conflicts in

Re: [sqlite] syntax error near AS

2017-07-06 Thread John McMahon
ror message if they are not the same as the updated table). -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of John McMahon Sent: Wednesday, 5 July, 2017 21:17 To: SQLite Users Subjec

Re: [sqlite] syntax error near AS

2017-07-06 Thread John McMahon
On 06/07/2017 15:03, Keith Medcalf wrote: Do you know of any implementation of SQL that accepts an AS clause for the updated table? I don't think any do. No Keith, I don't. My only exposure to SQL is sqlite. Some versions have a FROM extension and you CAN specify an alias for the

Re: [sqlite] syntax error near AS

2017-07-06 Thread Domingo Alvarez Duarte
I already did this before but it was not accepted. For myself I did a modification on sqlite3 to allow the use of "AS" on delete/update statements. You can see the parser part here https://github.com/mingodad/sqlite/blob/decimal64/src/parse.y . Cheers ! On 06/07/17 05:16, John McMahon

Re: [sqlite] syntax error near AS

2017-07-06 Thread Clemens Ladisch
John McMahon wrote: > an alias for an "UPDATE" table name is not permitted. Is there a particular > reason for this? The UPDATE statement affects a single table. While an alias might be a convenience, it is not necessary (any naming conflicts in subqueries can be resolved by using an alias on

Re: [sqlite] syntax error near AS

2017-07-06 Thread Paul Sanderson
ıɥʇ pɐǝɹ uɐɔ noʎ ɟı > > > -Original Message- > > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > > On Behalf Of John McMahon > > Sent: Wednesday, 5 July, 2017 21:17 > > To: SQLite Users > > Subject: [sqlite] syntax error nea

Re: [sqlite] syntax error near AS

2017-07-05 Thread Keith Medcalf
sıɥʇ pɐǝɹ uɐɔ noʎ ɟı > -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of John McMahon > Sent: Wednesday, 5 July, 2017 21:17 > To: SQLite Users > Subject: [sqlite] syntax error near AS > > Hi > > Wondering if someo

[sqlite] syntax error near AS

2017-07-05 Thread John McMahon
Hi Wondering if someone else can spot the syntax error in the following statement. "locns" is an attached database. There are four "AS" terms in the statement, they all alias tables. Ok, found it. It seems that an alias for an "UPDATE" table name is not permitted. Is there a particular

Re: [sqlite] Syntax error near "NOT"

2006-04-05 Thread Pam Greene
What version are you using? The "IF NOT EXISTS" clause only exists in SQLite 3.3.0 and later. - Pam On 4/5/06, Lucky Luke <[EMAIL PROTECTED]> wrote: > > Ok, a VERY VERY strange error, which I can't solve. > > I use the SQLite.NET wrapper from www.phpguru.org to use it with C#. > > I have the

[sqlite] Syntax error near "NOT"

2006-04-05 Thread Lucky Luke
Ok, a VERY VERY strange error, which I can't solve. I use the SQLite.NET wrapper from www.phpguru.org to use it with C#. I have the following query: sql = "CREATE TABLE IF NOT EXISTS bot_users (" + "username VARCHAR(100)," + "password VARCHAR(100) " +