# Adobe air sqlstatement.execute

**URL:** <https://forum.kirupa.com/t/adobe-air-sqlstatement-execute/267420>\
**Category:** Uncategorized\
**Created:** [July 31, 2008, 8:51pm UTC](https://forum.kirupa.com/t/adobe-air-sqlstatement-execute/267420 "2008-07-31T20:51:31Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![trustyteen](https://avatars.discourse-cdn.com/v4/letter/t/eada6e/32.png) [@trustyteen](https://forum.kirupa.com/u/trustyteen)\
**Post date:** [July 31, 2008, 8:51pm UTC](https://forum.kirupa.com/t/adobe-air-sqlstatement-execute/267420/1 "2008-07-31T20:51:31Z")

</div>

i wrote this query and when it executes, it only executes the first command:

```auto
    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