i wrote this query and when it executes, it only executes the first command:
Create Table tRole (
roleID integer Primary Key
,roleName varchar(40)
);
Create Table tFile (
fileID integer Primary Key
,fileName varchar(50)
,fileDescription varchar(500)
,thumbnailID integer
,fileFormatID integer
,categoryID integer
,isFavorite boolean
,dateAdded date
,globalAccessCount integer
,lastAccessTime date
,downloadComplete boolean
);
Create Table tCategory (
categoryID integer Primary Key
,categoryName varchar(50)
,parent_categoryID integer
);
Create Table tFileFormat (
fileFormatID integer Primary Key
,fileFormatName varchar(50)
,fileExtension varchar(15)
,thumbnailID integer
);
Create Table tKeyword (
keywordID integer Primary Key
,keyword varchar(40)
);
Create Table tFile_Keywords (
fileKeywordID integer Primary Key
,keywordID integer
,fileID Integer
);
Create Table tRole_File (
roleFileID integer Primary Key
,fileID integer
,roleID integer
);
Create Table tRole_Category (
roleCategoryID integer Primary Key
,categoryID integer
,roleID integer
);
Create Table tThumbnail (
thumbnailID integer Primary Key
,fileName varchar(80)
,downloadComplete boolean);
Create Table tFileAccess (
fileAccessID integer Primary Key
,accessTime date
,fileID int
);
if i remove a semi colon it fails. after executing this statement, i only have 1 table (tRole). is this a limitation in air’s sqlstatement class? if so, please kill me now