Hello Ryan, Why not make N distinct Execs to create the tables and see if it works? Seems like simplification is the way to trouble-shoot this.
Friday, July 6, 2007, 7:08:09 PM, you wrote: RML> James, RML> Nope. And actually, it's always a different table that fails to get RML> created. I know that (usually) all the tables get created RML> successfully. It seems plausible that it's a low-memory condition RML> that causes it, seeing as this code is running on PDAs with very very RML> little memory. RML> I will post my code here if necessary. RML> 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] >> ----------------------------------------------------------------------------- >> >> -- Best regards, Teg mailto:[EMAIL PROTECTED] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
