Re: [sqlite] create table question

On 10 Aug 2012, at 9:14pm, u okafor wrote: > We are doing a CREATE TABLE query; sqlite3_step() is called in shell.c and > along > the way, sqlite3VdbeExec() is called. sqlite3VdbeExec() call is pased with > "p" > pointer which contains "aOp" array. Could you please tell us where this "aOp" >

[sqlite] create table question

Dear Forum members, We are doing a CREATE TABLE query; sqlite3_step() is called in shell.c and along the way, sqlite3VdbeExec() is called. sqlite3VdbeExec() call is pased with "p" pointer which contains "aOp" array. Could you please tell us where this "aOp" array is created in the code...  Thank

Re: [sqlite] create table question

Ken & Deb Allen wrote: So, would this problem still exist if the code were to open two 'connections' to the database, issue the SELECT on one open connection and then issue the CREATE TABLE via the other open connection? I'm new to this to, but I think it depends on if that 'db.execute()' functi

Re: [sqlite] create table question

So, would this problem still exist if the code were to open two 'connections' to the database, issue the SELECT on one open connection and then issue the CREATE TABLE via the other open connection? Does this in any way prevent an application from opening a single connection, issuing a SELECT, a

Re: [sqlite] create table question

> > > > select_stmt = db.execute("SELECT * FROM people") > > # use some, but not all of the rows in select_stmt > > create_stmt = db.execute("CREATE TABLE other (a,b)") # error: > > database table is locked > > > > Why does this happen? > > > > Anyway around this

Re: [sqlite] create table question

eople') db.do("insert into hey values (1,2)") # insert works, but create table does not s.finish # finalizes statement ### db.do() just executes a statement and finalizes it right away. -Charlie -Original Message- From: Paolo Vernazza [mailto:[EMAIL PROTECTED] Se

RE: [sqlite] create table question

Vernazza [mailto:[EMAIL PROTECTED] > Sent: Friday, April 08, 2005 9:09 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] create table question > > Charles Mills wrote: > > >>> I am trying to create a table after creating a select statement > >>>

Re: [sqlite] create table question

Charles Mills wrote: I am trying to create a table after creating a select statement which selects records from an existing table. Is this possible? I get a SQLITE_LOCKED / "database table is locked" error when I attempt this. In psuedo code the logic is as follows: select_stmt = db.execute("

Re: [sqlite] create table question

On Apr 8, 2005, at 2:35 AM, Paolo Vernazza wrote: Charles Mills wrote: I am trying to create a table after creating a select statement which selects records from an existing table. Is this possible? I get a SQLITE_LOCKED / "database table is locked" error when I attempt this. In psuedo code th

Re: [sqlite] create table question

Charles Mills wrote: I am trying to create a table after creating a select statement which selects records from an existing table. Is this possible? I get a SQLITE_LOCKED / "database table is locked" error when I attempt this. In psuedo code the logic is as follows: select_stmt = db.execute("S

[sqlite] create table question

I am trying to create a table after creating a select statement which selects records from an existing table. Is this possible? I get a SQLITE_LOCKED / "database table is locked" error when I attempt this. In psuedo code the logic is as follows: select_stmt = db.execute("SELECT * FROM people")