Re: [sqlite] Strange .dump output
Sure enough, that's in the sqlite_master table. I guess I did do it back when I created the database but I can't imagine why.. Thanks! On Dec 11, 2007 2:19 PM, <[EMAIL PROTECTED]> wrote: > "Mitchell Vincent" <[EMAIL PROTECTED]> wrote: > > I've noticed something strange in some of the SQL statements created > > from the command line utility in Windows (the most current version as > > of this morning). > > > > For nearly all of the tables it works well but it puts a ' character > > around the name of one table named invoice_master, which is breaking > > the import into another database. That is the only table name that is > > surrounded by the single quote and I can't for the life of me figure > > out why. Other table names have underscores, so what would be the > > reason of quoting that table name in the CREATE statement with single > > quotes? > > > > The original SQL text used to create the table is stored in the > sqlite_master table. The .dump command should be using this > exact text. > > Are you sure you didn't quote the table name when you originally > created the invoice_master table? > -- > D. Richard Hipp <[EMAIL PROTECTED]> > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > -- - Mitchell Vincent - K Software - Innovative Software Solutions - Visit our website and check out our great software! - http://www.ksoftware.net - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Strange .dump output
"Mitchell Vincent" <[EMAIL PROTECTED]> wrote: > I've noticed something strange in some of the SQL statements created > from the command line utility in Windows (the most current version as > of this morning). > > For nearly all of the tables it works well but it puts a ' character > around the name of one table named invoice_master, which is breaking > the import into another database. That is the only table name that is > surrounded by the single quote and I can't for the life of me figure > out why. Other table names have underscores, so what would be the > reason of quoting that table name in the CREATE statement with single > quotes? > The original SQL text used to create the table is stored in the sqlite_master table. The .dump command should be using this exact text. Are you sure you didn't quote the table name when you originally created the invoice_master table? -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Strange .dump output
I've noticed something strange in some of the SQL statements created from the command line utility in Windows (the most current version as of this morning). For nearly all of the tables it works well but it puts a ' character around the name of one table named invoice_master, which is breaking the import into another database. That is the only table name that is surrounded by the single quote and I can't for the life of me figure out why. Other table names have underscores, so what would be the reason of quoting that table name in the CREATE statement with single quotes? -- - Mitchell Vincent - K Software - Innovative Software Solutions - Visit our website and check out our great software! - http://www.ksoftware.net - To unsubscribe, send email to [EMAIL PROTECTED] -