Re: [sqlite] Statement cache does not play well with sqlite3_stmt_readonly

Ok, Thanks. On Tue, Jun 3, 2014 at 8:42 PM, Richard Hipp wrote: > On Tue, Jun 3, 2014 at 2:27 PM, gwenn wrote: > >> Hello, >> The function "sqlite3_stmt_readonly" returns true/1 for the statement >> "DROP TABLE IF EXISTS test" when the table "test" does

Re: [sqlite] Threads and System.Data.SQLite

On 3 Jun 2014, at 11:05pm, Drago, William @ MWG - NARDAEAST wrote: > "You May create multiple threads, and those threads can create their own > SQLiteConnection and subsequent objects for accessing a database. Multiple > connections on multiple threads to the same

[sqlite] Threads and System.Data.SQLite

All, In the Provider Limitations section of the SQLite.NET help file it says: "You May create multiple threads, and those threads can create their own SQLiteConnection and subsequent objects for accessing a database. Multiple connections on multiple threads to the same database file are

Re: [sqlite] Application with 'grid' form for entering table data wanted

By the sounds of it, the OP wants a spreadsheet app, that isn't a spreadsheet app, acts like a database, but isn't quite a database, looks simple to use, but provide editable information in a reasonable format. To bring up a point about Google that RSmith brought up, Google Docs has a spreadsheet

Re: [sqlite] Statement cache does not play well with sqlite3_stmt_readonly

On Tue, Jun 3, 2014 at 2:27 PM, gwenn wrote: > Hello, > The function "sqlite3_stmt_readonly" returns true/1 for the statement > "DROP TABLE IF EXISTS test" when the table "test" does not exist. > But, if this drop statement is cached, "sqlite3_stmt_readonly" still > returns

[sqlite] Statement cache does not play well with sqlite3_stmt_readonly

Hello, The function "sqlite3_stmt_readonly" returns true/1 for the statement "DROP TABLE IF EXISTS test" when the table "test" does not exist. But, if this drop statement is cached, "sqlite3_stmt_readonly" still returns true even after creating the table "test". The only way I've found to make

Re: [sqlite] Application with 'grid' form for entering table data wanted

On 2014/06/03 18:40, c...@isbd.net wrote: RSmith wrote: Your requirement is unrealistic. You do not want to install anything that makes this happen for you, yet you want very complex abilities. MS Access provides *exactly* what I want 'out of the box' a grid view of the

Re: [sqlite] Application with 'grid' form for entering table data wanted

You didn't list C#(mono,silverlight(uhmm not sure what mono called it) for web) in your repitroire; but a DataGridView filled from a DataAdapter is a few lines of code to get a editable table view. A few more lines and you get auto updating; cells are format protected (prevent entering text as a

Re: [sqlite] Application with 'grid' form for entering table data wanted

On 3 Jun 2014, at 15:07, c...@isbd.net wrote: > I'm looking for an application (or *simple* development framework) > which will provide me with an easily accessible grid form for entering > data into a table. I don't know anything about coding a web program, so all this advice related purely

Re: [sqlite] Application with 'grid' form for entering table data wanted

RSmith wrote: > > On 2014/06/03 16:07, c...@isbd.net wrote: > > I'm looking for an application (or *simple* development framework) > > which will provide me with an easily accessible grid form for entering > > data into a table. > > > > Requirements:- > > This can be a

Re: [sqlite] New DLLs and sources. Was: SQLite version 3.8.5 beta

On Tue, Jun 3, 2014 at 8:34 AM, Max Vlasov wrote: > Don't know what is difference between "stock" 3.8.4.3 from the site > and the newly compiled one... > The official deliveries of 32-bit DLLs are normally cross-compiled on Linux using MinGW 4.5.2. But the most recent

Re: [sqlite] Application with 'grid' form for entering table data wanted

On 2014/06/03 16:07, c...@isbd.net wrote: I'm looking for an application (or *simple* development framework) which will provide me with an easily accessible grid form for entering data into a table. Requirements:- This can be a web app or a [Linux] desktop one though I have a slight

Re: [sqlite] Like and percent character

Are you forming your query with sprintf? It may be worth printing the query you are preparing, to make sure it says what you think it is. Thanks, Kev Sent from my iPhone > On 3 Jun 2014, at 14:53, Micka wrote: > > Hi, > > I'm having trouble with the percent character

Re: [sqlite] Like and percent character

Probably you are using a variant of the printf() function to generate your statement and it is interpreting the %m as strerror(errno) (see man 3 printf), whereas it is ignoring %' (thousands separator for decimal conversions) either because it does not support this conversion or it is missing

[sqlite] Application with 'grid' form for entering table data wanted

I'm looking for an application (or *simple* development framework) which will provide me with an easily accessible grid form for entering data into a table. Requirements:- This can be a web app or a [Linux] desktop one though I have a slight preference for a web app. Must be able to

[sqlite] Like and percent character

Hi, I'm having trouble with the percent character . By example in my table I have : id name 1 micka 2 mickael I would like to do that : Select * from table name where name LIKE '%micka%' with my linux c program, the result is 0 but with the sqlite3 command program it works I also

[sqlite] Like and percent character

Hi, I'm having trouble with the percent character . By example in my table I have : id name 1 micka 2 mickael I would like to do that : Select * from table name where name LIKE '%micka%' with my linux c program, the result is 0 but with the sqlite3 command program it works I also

[sqlite] Like and percent character

Hi, I'm having trouble with the percent character . By example in my table I have : id name 1 micka 2 mickael I would like to do that : Select * from table name where name LIKE '%micka%' with my linux c program, the result is 0 but with the sqlite3 command program it works I also

Re: [sqlite] New DLLs and sources. Was: SQLite version 3.8.5 beta

On Tue, May 27, 2014 at 10:49 PM, Richard Hipp wrote: > On Tue, May 27, 2014 at 10:50 AM, Richard Hipp wrote: >> > > This time I build the 32-bit DLL using mingw instead of MSVC. (MSVC was > still used for the 64-bit DLL.) So perhaps it will work correctly on