>CREATE TABLE Customer ; > (SalesID c(6), ; > CustId i PRIMARY KEY, ; > CustName c(20) UNIQUE, ; > SalesBranch c(3), ; > FOREIGN KEY SalesId TAG SalesId REFERENCES Salesman) >>
>>tname=[JFUNDS] >> >> >>CREATE TABLE ([data\]+tname) (; >> id i PRIMARY KEY default sp_default("ID","JFUNDS"),; >> fundname c(20) FOREIGN KEY UPPER(fundname) TAG fundname,; <<------- syntax error on this line >> status c(10) FOREIGN KEY UPPER(status) TAG status,; >> Notes m,; >> insdttm T DEFAULT sp_default("DATETIME"),; >> insuser_id I DEFAULT sp_default("USERID"),; >> upddttm T DEFAULT sp_default("DATETIME"),; >> upduser_id I DEFAULT sp_default("USERID") ; >> ) >> >>>>