Hello every one! I have some problem with my SQL request. I am trying to create tables like this :
It is compiled ok. But then i tried to run it on emulator the app has dropped with error :
APPLICATION HAS STOPPED UNEXPECTADLY.
And i ve finded error occur in the FOREIGN KEY. WHAT problem?
Code:
myDB.execSQL("CREATE TABLE IF NOT EXISTS "
+ categories
+ " (category_id PRIMARY KEY,parent_id INT,FOREIGN KEY(parent_id) REFERENCES categories(category_id),name text,amount float);");
myDB.execSQL("CREATE TABLE IF NOT EXISTS "
+ accounts
+ " (account_id PRIMARY KEY, name text);");
It is compiled ok. But then i tried to run it on emulator the app has dropped with error :
APPLICATION HAS STOPPED UNEXPECTADLY.
And i ve finded error occur in the FOREIGN KEY. WHAT problem?