> Actually I doubt it can - since without the column name it can't create the
> prepared statement byte code, right?
Right. It can't be done.
>
> Is it possible for a bind variable to be a column name? I'd like to make a
> query which is:
>
> select from MyTable;
>
> and I'd like the
Hi,
Why not construct the SQL statement dynamically in the C/C++ code? That way your
statement(s) would have variable column names before compilation.
Eugene Wee
Brown, Dave wrote:
Actually I doubt it can - since without the column name it can't create the
prepared statement byte code,
That is what I do. But that also means I have to call sqlite_prepare() each
time, instead of just once. I was originally hoping I could prepare() once
and just bind.
-Dave
-Original Message-
From: Eugene Wee [mailto:[EMAIL PROTECTED]
Sent: Sunday, July 10, 2005 12:18 AM
To:
On Sun, 2005-07-10 at 00:23 -0700, Brown, Dave wrote:
> That is what I do. But that also means I have to call sqlite_prepare() each
> time, instead of just once. I was originally hoping I could prepare() once
> and just bind.
>
If another thread or process VACUUMs the database or creates a
new
I try copying a table from a :memory: data base to a file data base, but
could not make it work.
Anybody has any suggestions?
Thanks
I tried something like:
open a data base :memory:
create table MYTABLE (...)
...
attach 'filename.db' as FileDB
create table FileDB.MYTABLE as select *
Cornel Gazdaru <[EMAIL PROTECTED]> writes:
> I try copying a table from a :memory: data base to a file data base, but
> could not make it work.
> Anybody has any suggestions?
> Thanks
>
> I tried something like:
>
> open a data base :memory:
> create table MYTABLE (...)
> ...
>
> attach
Yes, actually I'm doing that already. Thanks!
-Dave
-Original Message-
From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
Sent: Sunday, July 10, 2005 4:12 AM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Binding a column name?
On Sun, 2005-07-10 at 00:23 -0700, Brown, Dave wrote:
>
On Sun, 2005-07-10 at 12:21 -0400, [EMAIL PROTECTED]
wrote:
> IIRC, you can't create a table in an attached DB.
That's true for SQLite 2.8. But beginning with SQLite 3.0
the restriction is removed and you can create new tables in
an attached database.
--
D. Richard Hipp <[EMAIL PROTECTED]>
> -Original Message-
> From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
> Sent: Sunday, July 10, 2005 6:12 AM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] Binding a column name?
>
> On Sun, 2005-07-10 at 00:23 -0700, Brown, Dave wrote:
> > That is what I do. But that also means I
On Sun, 2005-07-10 at 15:34 -0700, Tim McDaniel wrote:
> >
> > If another thread or process VACUUMs the database or creates
> > a new table or makes any other structure changes to the
> > database file, all of your prepared statements will be
> > invalided and you will have to rerun
I think there might be a bug in this code in lockBtree:
if( sqlite3pager_pagecount(pBt->pPager)>0 ){
u8 *page1 = pPage1->aData;
if( memcmp(page1, zMagicHeader, 16)!=0 ){
goto page1_init_failed;
The problem is if you are trying to open a non-sqlite file that is
smaller than
11 matches
Mail list logo