Syntax Error in Sqlite manager

Question

hi I m using the following code to generate a table on sqlite manager.

CREATE TABLE Transaction (ID PRIMARY KEY , amount REAL , currencyCode CHAR(3) , comments VARCHAR , debitAccount INTEGER , creditAccount INTEGER , debitAccountExchangeRate REAL , creditAccountExchangeRate REAL , FOREIGN KEY (currencyCode)REFERENCES Currency (code) , FOREIGN KEY (debitAccount) REFERENCES Account  (ID) , FOREIGN KEY (parentAccount) REFERENCES Account (ID ));

but I am getting the syntax error. Can any one please specify what am i doing wrong here.

    [ near "Transaction": syntax error ]
    Exception Name: NS_ERROR_FAILURE
      Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE)      [mozIStorageConnection.createStatement]

Hadi · Accepted Answer · 2011-08-19 03:28:12Z

4

Try this..

CREATE TABLE "Transaction" (ID PRIMARY KEY , amount REAL , currencyCode CHAR(3) , comments VARCHAR , debitAccount INTEGER , creditAccount INTEGER , debitAccountExchangeRate REAL , creditAccountExchangeRate REAL , FOREIGN KEY (currencyCode)REFERENCES Currency (code) , FOREIGN KEY (debitAccount) REFERENCES Account  (ID) , FOREIGN KEY (creditAccount) REFERENCES Account (ID ));

answered Aug 19, 2011 at 3:28

Hadi

1,2142 gold badges17 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dan · Accepted Answer · 2012-07-12 21:02:02Z

4

I was having a similar issue and, believe it or not, just changing my table name to "TRANSACTIONS" worked for me. "Transaction" must a reserved word in SQLite, but I know the error message I got was far from helpful.

Hope that helps.

answered Jul 12, 2012 at 21:02

Dan

412 bronze badges

Comments

Thick_propheT · Accepted Answer · 2014-07-26 16:04:10Z

1

I got this error because I forgot to separate the columns in my query with commas. I guess it doesn't like that.

I was doing:

SELECT Col1 Col2 Col3 FROM Table1

SQLite was expecting:

Select Col1, Col2, Col3 FROM Table1

answered Jul 26, 2014 at 16:04

Thick_propheT

1,0682 gold badges11 silver badges30 bronze badges

Collectives™ on Stack Overflow

Syntax Error in Sqlite manager

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related