Nope - nothing to do with the XML. You have a comma missing between :Sheet_Depth and :Unique_Product_Code in your sqlText variable in your insertData function.
--- In flexcoders@yahoogroups.com, "bredwards358" <[EMAIL PROTECTED]> wrote: > > 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 >
