Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

inside custom component

Web and WebWorks Development

Reply
Developer
VansFannel
Posts: 166
Registered: ‎03-04-2011
My Device: Playbook

webworks for playbook database FOREIGN clause

Hello,

 

I'm getting troubles with this statement:

 

CREATE TABLE IF NOT EXISTS Idea (
	id INTEGER PRIMARY KEY,
	title TEXT NOT NULL,
	content TEXT NOT NULL,
	created TIMESTAMP NOT NULL,
	sketchID INTEGER,
	categoryID INTEGER NOT NULL, 
	FOREIGN KEY (sketchID) REFERENCES (Sketch),
	FOREIGN KEY (categoryID) REFERENCES (Category));

 I think  the problem is with FOREIGN clause.