Re: [sqlite] Issues with sqlite3session_attach(conn, NULL) w/ duplicate table in temp

2020-02-27 Thread Adam Levy
Dan, I tried the above patch and it resolves the issue! Also you were right about use of "*" in attach. I misinterpreted the output of my test in that case. Thank you so much for taking the time to fix this! When can I expect this patch to make it into a release? Adam Levy On Thu, Feb 27, 2020

Re: [sqlite] Issues with sqlite3session_attach(conn, NULL) w/ duplicate table in temp

2020-02-27 Thread Dan Kennedy
On 27/2/63 05:04, Adam Levy wrote: Hi all When I have a database connection with a temp table of the same name as a table in main, I am getting what I feel is unexpected behavior from the session extension. Most succinctly, I start a session on a connection on the main db with a table with an

[sqlite] Issues with sqlite3session_attach(conn, NULL) w/ duplicate table in temp

2020-02-26 Thread Adam Levy
Hi all When I have a database connection with a temp table of the same name as a table in main, I am getting what I feel is unexpected behavior from the session extension. Most succinctly, I start a session on a connection on the main db with a table with an INTEGER PRIMARY KEY, attach it to all

Re: [sqlite] PHP + SQLite - Issues with update

2011-10-21 Thread Simon Slavin
On 21 Oct 2011, at 12:05am, Prashant Prabhudesai wrote: > $db = new SQLiteDatabase('db/reg.s3db'); This is the old-style SQLite2 interface. I strongly suggest you switch to the new SQLite3 interface as documented here: http://www.php.net/manual/en/book.sqlite3.php In that your line would be

Re: [sqlite] PHP + SQLite - Issues with update

2011-10-21 Thread Stephan Beal
On Fri, Oct 21, 2011 at 1:05 AM, Prashant Prabhudesai < prashantprabhude...@gmail.com> wrote: > $row = $res->fecth(); > ... After the script exits successfully I inspect the value in the Token column > Are you 100% sure the above command executes correctly? -- - stephan beal http://wanderi

[sqlite] PHP + SQLite - Issues with update

2011-10-21 Thread Prashant Prabhudesai
Hello, I am running into some issues trying to update a column in a table in a SQLite database using PHP on Windows and was hoping could get some help on this mailer. Here is the create and insert statement - CREATE TABLE SERVER ( IPAddress varchar(100) not null unique primary key, Token varchar

Re: [sqlite] Issues with

2010-09-14 Thread Simon Slavin
On 14 Sep 2010, at 9:55am, Nimish Nayak wrote: > I was trying to figure out how to export the Database as an SQL File. > > I came across sqlite3_backup but it copies Db to Db. But i failed to get the > Db to sql file as dont by SqliteBrowser > > I can achieve this using .dump or .bachup in sqli

[sqlite] Issues with

2010-09-14 Thread Nimish Nayak
I was trying to figure out how to export the Database as an SQL File. I came across sqlite3_backup but it copies Db to Db. But i failed to get the Db to sql file as dont by SqliteBrowser I can achieve this using .dump or .bachup in sqlite cli but how should i do it using the C API's ? -- Mr. Ni

[sqlite] Issues with sqlite3_release_memory

2008-07-03 Thread Srinivasa Ragavan
Guys, Im facing a wierd issue when thread 1 is doing a sqlite3_exec and if thread 2 attempts to call sqlite3_release_memory, the thread1 never returns from sqlite3_exec? It seems to take 100% cpu forever. Any suggestion, on how the memory should be freed or are there any guidelines on how to use