为什么不能我的sqlite不能创建主外键关联。。。

Question

一下是我写的代码。。。创建主外键的关联  或者谁有个可以运行的例子给我介绍下也行。。。。。

db.execSQL("create table "+OnlineTable+
    "("+videoId +" integer primary key autoincrement,"
    +name+" text,"+type+" text,"+region+" text,"+year+
    " text,"+actor+" text,"
    +television+" text,"+introduction +" text,"+
    collection+" text ,"
    +number+" integer not null,"

    +"foreign key ("+number+") references "+JujiTable+"("+number+"))");

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

  //创建添加的触发器
  db.execSQL("create trigger fk_Movie_deptid " +
    "before insert on "+OnlineTable+" for each row begin " +
    "select case when ((select "+number+" from "+JujiTable+
    " where "+number+"=new."+number+")is null) then raise " +
  "(abort,'foreign key violation') end;end");

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

  //创建视图
  db.execSQL("create view "+ viewEmps+" as select "+OnlineTable+"."+videoId+" as _id,"
    +
    ""+OnlineTable+"."+type+","+
    OnlineTable+"."+actor+","
    +OnlineTable+"."+name+","
    +OnlineTable+"."+number+","
    +OnlineTable+"."+television+","
    +OnlineTable+"."+year+","
    +OnlineTable+"."+introduction+","
    +OnlineTable+"."+collection+","
    +OnlineTable+"."+region+","+
    ""+JujiTable+"."+webside+","
    +JujiTable+"."+number+","
    +JujiTable+"."+link+""
    +" from "+OnlineTable+
    " join "+JujiTable+" on "+OnlineTable+"."+number+"="+JujiTable+"."+number+"");

 

Answer 1

你是想创建主外键关系吗？应该是现有主键表，再有外建表，你这样不是成了现有外键，再有主键了，应该不行。