"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] -----------------------------------------------------------------------------
