So, I finish a simple application to turn an XML Document into a SQL Lite table, however, every time I try to run it, I simply get an error message in the error log I set up: [b]Error ID:3115 DetailsError #3115: SQL Error.[/b] As you can see, it's simply not descriptive enough.
Going over my code, I really have no idea on where I could be doing things wrong here, it could be something as simple as improper formatting, but the document I'm working to convert is huge, thus making the create table, and insert statement with just the number of columns (34!). I'm not exactly sure where to begin here, and since posting snippets would exceed the max size of the post I suppose I could ask for a point in the right direction. Right now I'm thinking something is not matching up right. Here's a snippet from my XML document, and the statements in my app, due to the size of the XML, I can't post it in it's entirety since it would exceed most message board limits. --------------------------------------------------------------------Xml Document Snippet <Support xmlns="http://tempuri.org/Support.xsd";> <Avery> <Original>3267</Original> <Product_Code>3267</Product_Code> <Unique_Product_ID>3267</Unique_Product_ID> <Trademark>Yes</Trademark> <Patent_Pending>No</Patent_Pending> <Avery_Product_Category>Greeting Cards</Avery_Product_Category> <Product_Description>White Full-Size Card Sheet</Product_Description> <Product_Type>Card</Product_Type> <Coated_Stock>Yes</Coated_Stock> <Photo_Quality>-</Photo_Quality> <Full_Bleed>-</Full_Bleed> <Mirror_Image_Required>-</Mirror_Image_Required> <Printer_Type>Inkjet</Printer_Type> <Corresponding_A4_SKU>C2356</Corresponding_A4_SKU> <Template_Family>9</Template_Family> <Page_Size>8 1/2 x 11</Page_Size> <Orientation>Portrait</Orientation> <Number_of_Lbls_Cards_per_Sheet>1</Number_of_Lbls_Cards_per_Sheet> <Label_Height>11</Label_Height> <Label_Width>8.5</Label_Width> <Corner_Radius>0</Corner_Radius> <Number_Sections_Across>1</Number_Sections_Across> <Number_Sections_Down>1</Number_Sections_Down> <Top_Margin>0</Top_Margin> <Bottom_Margin>0</Bottom_Margin> <Left_Margin>0</Left_Margin> <Right_Margin>0</Right_Margin> <Horiz_Pitch>8.5</Horiz_Pitch> <Vertical_Pitch>11</Vertical_Pitch> <Sheet_Width>8.5</Sheet_Width> <Sheet_Depth>11</Sheet_Depth> <Unique_Product_Code>3267</Unique_Product_Code> </Avery> --------------------------------------------------------------------Crea\ te Table Statement Snippet private function createTable():void { var sqlText:String = "CREATE TABLE Avery(Original TEXT, Product_Code TEXT, Cross_Reference TEXT, Sequence NUMERIC, " + "Unique_Product_ID TEXT, Trademark TEXT, Patent_Pending TEXT, Avery_Product_Category TEXT, " + "Product_Description TEXT, Priority_SKU TEXT, Product_Type TEXT, Coated_Stock TEXT, Photo_Quality TEXT, " + "Full_Bleed TEXT, Mirror_Image_Required TEXT, Printer_Type TEXT, Corresponding_A4_SKU TEXT, " + "Template_Family NUMERIC, Page_Size TEXT, Orientation, Number_of_Lbls_Cards_per_Sheet NUMERIC, " + "Label_Height NUMERIC, Label_Width NUMERIC, Corner_Radius NUMERIC, Number_Sections_Across NUMERIC, " + "Number_Sections_Down NUMERIC, Top_Margin NUMERIC, Bottom_Margin NUMERIC, Left_Margin NUMERIC, " + "Right_Margin NUMERIC, Horiz_Pitch NUMERIC, Vertical_Pitch NUMERIC, Sheet_Width NUMERIC, " + "Sheet_Depth NUMERIC, Unique_Product_Code TEXT)"; createTableStatement = new SQLStatement(); createTableStatement.sqlConnection = conn; createTableStatement.addEventListener(SQLEvent.RESULT, createTableResult); createTableStatement.text = sqlText; createTableStatement.execute(); } --------------------------------------------------------------------Inse\ rt Statement Snippet
