有谁帮我看看下面的代码。。。为什么我创建表的时候都不能创建啊。。。。

[fannifan]

db.execSQL("create table"+OnlineTable+"("+videoId +" integer primary key autoincrement,"+name+" TEXT,"+type+" text,"+region+" text,"+year+" text,"+actor+" text,"+number+" text,"+television+" text,"+introduction +"text,"+collection+"text ,foreign key ("+number+") references "+JujiTable+"("+number+")))");


db.execSQL("create table"+JujiTable+"("+videoId+" integer primary key autoincrement,"+webside+" text,"+link+" text,"+number+" text");

//创建触发器
db.execSQL("CREATE TRIGGER fk_Movie_deptid before insert on "+JujiTable+" for each row begin" +
"select case when ((select "+number+" from "+OnlineTable+" where "+number+"=new."+number+")is null) then raise " +
"(abort,'Foreign Key Violation') end;end");


//创建视图
db.execSQL("CREATE VIEW"+ viewEmps+" AS SELECT "+JujiTable+"."+videoId+JujiTable+"."+webside+","+JujiTable+"."+link+","+JujiTable+"."+number+" " +
""+OnlineTable+"."+type+","+OnlineTable+"."+number+","+OnlineTable+"."+actor+","+OnlineTable+"."+name+","+OnlineTable+"."+television+","+OnlineTable+"."+year+","+OnlineTable+"."+introduction+","+OnlineTable+"."+collection+","+OnlineTable+"."+region+","+OnlineTable+"."+videoId+"AS _id,"
+" FROM "+JujiTable+" join "+OnlineTable+" ON "+OnlineTable+"."+number+"="+JujiTable+"."+number+"");

}

[hvk687]

还有什么错误提示？

[jgszhuzhu]

贴错误

[IT东]

创建表的sql就有问题啊，你把生成的sql打印出来就知道了