Re: [sqlite] Problems with some SQL

2009-03-19 Thread Radu Lodina
TABLE UserGroup ( `UserGroupID` INTEGER PRIMARY KEY, Please see the INTEGER keywords in DDL. Good luck. - Original Message - From: To: Sent: Thursday, March 19, 2009 11:31 PM Subject: [sqlite] Problems with some SQL > Heya, > > I'm currently working on a simp

[sqlite] Problems with some SQL

2009-03-19 Thread thom
Heya, I'm currently working on a simple setup for a news and user system. However, I'm having some issues with the SQL I'm using. It's available @ http://geekerzoid.pastebin.com/m532d173a I keep getting "SQL error: foreign-key violation: UserGroup.UserGroupID" Any help would be greatly appreciat

Re: [sqlite] Problems with some SQL statements

2006-01-28 Thread Robert L Cochran
I always keep a few books on SQL around me. Bob [EMAIL PROTECTED] wrote: Ken & Deb Allen <[EMAIL PROTECTED]> wrote: > The following statement works in other databases but fails in SQLite with "SQL error: no such column: X.TeamID" SELECT X.TeamID, X.TeamName, Y.TeamID,

Re: [sqlite] Problems with some SQL statements

2006-01-28 Thread drh
Ken & Deb Allen <[EMAIL PROTECTED]> wrote: > > > The following statement works in other databases but fails in > SQLite with "SQL error: no such column: X.TeamID" > > SELECT X.TeamID, > X.TeamName, > Y.TeamID, > Y.TeamName, > X.Points > FROM ( SELECT

[sqlite] Problems with some SQL statements

2006-01-28 Thread Ken & Deb Allen
I have some SQL statements that the 3.3.2 engine does not seem to handle properly. The project with which this is associated is keeping track of the game schedule for a Little League division, and being able to produce the proper standings at the end of the season. The standings are first