Re: [sqlite] CREATE TABLE

Are you execduting several sqlite3_prapare and sqlite3_step statements? The prepare steps through the statements returning a pointer to the start of the next one as one is compiled. Ryan M. Lederman wrote: I'm using sqlite3, built with Microsoft's CL compiler, 8.0 on a Windows Mobile platform

Re: Re[2]: [sqlite] CREATE TABLE

In fact, it uses to be N seperate execs and I consolidated it in an effort to fix the problem. It seems like under certain circumstances, my code fails to create a table but does not report it as an error. // strTmp is filled with other CREATE TABLE commands before this, strTmp.Format(L"CREATE

Re[2]: [sqlite] CREATE TABLE

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 kn

Re: [sqlite] CREATE TABLE

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 po

RE: [sqlite] CREATE TABLE

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

[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

RE: [sqlite] Using SQlite with .NET

There are a few .NET wrappers for SQLite. I would suggest System.Data.SQLite available here: http://sqlite.phxsoftware.com/ And for ADO.NET 2.0 development use version 1.0.43. For LINQ stuff use 2.0.35. Also wrapper-specific questions will probably get quicker responses in their dedicated foru

[sqlite] Using SQlite with .NET

Hi, I am trying to evaluate the use of SQLite with .NET in out project. I have downloaded the ADO.NET 2 adaptor for SQLite from source forge. But I was not sure which version do I need to download (if any) from the download page to get myself started. Could you please give me some direction, li

Re: [sqlite] Views

On Fri, 2007-07-06 at 08:42 -0700, Mike Johnston wrote: > n Fri, 2007-07-06 at 07:18 -0700, Mike Johnston wrote: > > I have to join three tables to retrieve bits of data from each. I'm > wondering if I use a view are there any performance issues vs. issuing > the complete 3 table join query in co

Re: [sqlite] FTS and upgrades

Right, but what I'm asking is: If version 1.0 of my program uses Sqlite with *only* fts1, and then I upgrade users to version 2.0 of my program which uses *only* fts3, can my version 2.0 code (which is using sqlite that only has fts3) safely delete the original fts1 table created by version 1.0 w

Re: [sqlite] Views

--- Mike Johnston <[EMAIL PROTECTED]> wrote: > I have to join three tables to retrieve bits of data from each. I'm wondering > if I use a view > are there any performance issues vs. issuing the complete 3 table join query > in code. As long as your VIEW/subquery does not make use of UNION/EXCEP

[sqlite] Views

n Fri, 2007-07-06 at 07:18 -0700, Mike Johnston wrote: > I have to join three tables to retrieve bits of data from each. I'm wondering if I use a view are there any performance issues vs. issuing the complete 3 table join query in code. > > Also, is it quicker to have sqlite do joins on primary

Re: [sqlite] Views

On Fri, 2007-07-06 at 07:18 -0700, Mike Johnston wrote: > I have to join three tables to retrieve bits of data from each. I'm wondering > if I use a view are there any performance issues vs. issuing the complete 3 > table join query in code. > > Also, is it quicker to have sqlite do joins on pri

[sqlite] Re: Is it necessary to clear bindings in a Prepared Statement

J Jayavasanthan <[EMAIL PROTECTED]> wrote: Is it necessary to clear bindings in a Prepared Statement, before reusing it to insert or update or select from the database again, No. In fact, sometimes it is useful that sqlite3_reset preserves bindings, e.g. if one needs to insert several rows tha

[sqlite] Is it necessary to clear bindings in a Prepared Statement

Hi, Is it necessary to clear bindings in a Prepared Statement, before reusing it to insert or update or select from the database again, I recently found out, sqlite3_reset doesn't reset the bound parameters in a prepare statement, and sqlite3_clear_bindings need to be used, If sqlite3_clear_bin

[sqlite] Views

I have to join three tables to retrieve bits of data from each. I'm wondering if I use a view are there any performance issues vs. issuing the complete 3 table join query in code. Also, is it quicker to have sqlite do joins on primary keys between tables instead of doing three separate single t

Re: [sqlite] Using loadable extension with Qt

Many thanks for the suggestion. It solved my problem. - Alex

[sqlite] Suggestions Add/Remove columns from Table

I've been reading up a bit and I understand SQLite has limited support for ALTER TABLE columns can be added but not dropped. Some suggestions are to create a temp table and copy the data to it drop the old table create the new one and then select the data back. But there appears to be more to