James, Nope. And actually, it's always a different table that fails to get created. I know that (usually) all the tables get created successfully. It seems plausible that it's a low-memory condition that causes it, seeing as this code is running on PDAs with very very little memory.
I will post my code here if necessary. On 7/6/07, James Dennett <[EMAIL PROTECTED]> wrote:
> -----Original Message----- > From: Ryan M. Lederman [mailto:[EMAIL PROTECTED] > Sent: Friday, July 06, 2007 3:34 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] CREATE TABLE > > I'm using sqlite3, built with Microsoft's CL compiler, 8.0 on a > Windows Mobile platform. > > I have a problem wherein I issue several CREATE TABLE commands > concatenated together, semi-colon delimited. It appears, from the > feedback from my customers, that one or more table(s) fail to get > created, but the database engine reports no failures when executing > the CREATE TABLE statement. I know this because later queries will > fail with messages such as "no such table: foo" > > Has anyone ever seen this before? Am I doing something wrong, or is > this a known bug? Any help would be greatly appreciated. Without seeing your code, it's hard to say, but it seems plausible that you didn't actually execute all of the statements. Is only the first table getting created? -- James ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
-- Ryan M. Lederman ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
