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