[sqlite] Why sqlite has no sqlite_bind_auto or similary named function

Hi, The problem was with my program that automatically converts xml data into an sqilte table. It looks for an attribute and appends a column if it does not exists, but stating no particular type. All values were appended with sqlite_bind_text. Everything was fine, but an index created after this

Re: [sqlite] about merge rows

On 4/17/2014 9:26 PM, YAN HONG YE wrote: I want to merge all the mnote, how to do this? What do you mean "merge"? What should the table look like afterward? -- Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] about merge rows

I have a sqlite table like this: id namemnote 7 DDD_POSTE_DE_COND 2;AA35469850.1;DDD;ECRHEMBNETM6X100AC8Z;000

Re: [sqlite] Bug Report

Ryan, The late Grace Hopper would be happy about your responce *Jim Dodgen* On Thu, Apr 17, 2014 at 10:40 AM, RSmith wrote: > That is just the compiler trying to be helpful without being able to > completely grasp the code and can safely be ignored, but thank you for

Re: [sqlite] field length retreval

On 17 Apr 2014, at 11:24pm, David Clark wrote: > If I have a table of > field1 varchar(25) > field2 varchar(50) > field3 varchar(75) You don't. SQLite does not support a datatype of varchar(). Fields you declare like that will be implemented as TEXT fields and handled

Re: [sqlite] field length retreval

On 4/17/2014 6:24 PM, David Clark wrote: If I have a table of field1 varchar(25) field2 varchar(50) field3 varchar(75) I know sqlite does not enforce limits, but in my program it would be useful if I could find the declared lengths of 25, 50 and 75 in this case. How might I do that in sqlite?

[sqlite] field length retreval

If I have a table of  field1 varchar(25) field2 varchar(50) field3 varchar(75) I know sqlite does not enforce limits, but in my program it would be useful if I could find the declared lengths of 25, 50 and 75 in this case.  How might I do that in sqlite? Thank you, David Clark

Re: [sqlite] The execute command

Thx for hint. I see also the RSmith contribute. This is not only impossible in the current SQLite implementation, it is also inconceivable. By that I mean that the query output can be of any form, there is no way a prepare statement can know before-hand what the query would look like, it

Re: [sqlite] The execute command

On 2014/04/17 20:43, aperi2007 wrote: Hi to all, There is in sqlite a command to run a query build at runtime ? Our use-case is a list of query build from a sql script and stored in a table. something like this: select EXECUTE([field_query]) from table1; where "table1" is the table and

Re: [sqlite] The execute command

On Thu, Apr 17, 2014 at 2:43 PM, aperi2007 wrote: > Hi to all, > > There is in sqlite a command to run a query build at runtime ? > Not built-in. But you can add your own. See http://www.sqlite.org/src/artifact/d3013ce36f19ac72?ln=289-319 for an example function that

[sqlite] The execute command

Hi to all, There is in sqlite a command to run a query build at runtime ? Our use-case is a list of query build from a sql script and stored in a table. something like this: select EXECUTE([field_query]) from table1; where "table1" is the table and "field1" is the field where the builded

Re: [sqlite] about the apparently arriving soon "threads"

Hi James, You're right : my example is indeed a "4 independant process" rather than "4 threads in the same process". The job I need to do is unchanged : transform a big input table in a big output table. I hope that SQlite improvements will allow us to approach this "2x" (or more) boost in the

Re: [sqlite] Bug Report

That is just the compiler trying to be helpful without being able to completely grasp the code and can safely be ignored, but thank you for the notice and feel free to initialize the variable in your version. As an aside, that does not qualify as a "bug", the word "bug" means a whole other

[sqlite] Bug Report

Hey, I downloaded the "Legacy Source Code Distribution Formats - sqlite-preprocessed-3080403.zip", while compiling in Microsoft Visual Studio 2013 a bug appeared in file "fts3_tokenize_vtab.c","error C4703: potentially uninitialized local pointer variable 'pTab' used" Line:203.Assigning the

Re: [sqlite] sqlite dump makes wrong "CREATE VIEW" order

On 17 Apr 2014, at 3:42pm, Igor Tandetnik wrote: > If there's a bug anywhere in this, I'd say it's the fact that SQLite allowed > "DROP VIEW v2" statement to proceed. Agreed. Is there a similar bug if you try to drop a table that a FOREIGN KEY depends on ? Simon.

Re: [sqlite] sqlite dump makes wrong "CREATE VIEW" order

On 4/17/2014 12:43 AM, Tyumentsev Alexander wrote: sqlite in some cases dumps views in wrong order. Interesting situation. My take on it would be that dump is a simple little tool designed to help move a database file from one place to another. In tricky situations, some editing of its

Re: [sqlite] cannot set connection while a datareader is active

Il 16/04/2014 22.33, Joe Mistachkin ha scritto: Stefano Ravagni wrote: Joe i cannot find the way for follow the command object properties you saycould you tell me what and how to observe exactly please ? You might need to add the System.Data.SQLite project(s) to the solution in order to

Re: [sqlite] sqlite dump makes wrong "CREATE VIEW" order

On 4/17/2014 3:43 AM, Tyumentsev Alexander wrote: CREATE VIEW v2 as select id1 from test where id1; CREATE VIEW v1 as select t1.id2 from test as t1 LEFT JOIN v2 ON t1.id2=v2.id1; DROP VIEW v2; Is it the user responsibility to follow all dependencies and recreate "VIEW" tree ? I'd say it's the

Re: [sqlite] sqlite dump makes wrong "CREATE VIEW" order

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 17/04/14 00:43, Tyumentsev Alexander wrote: > Is it the user responsibility to follow all dependencies and recreate > "VIEW" tree ? The dumping is happening in the order that the views were created. This approach generally works, but fails in

Re: [sqlite] detach failed with error code 1

On Thu, Apr 17, 2014 at 9:08 AM, dd wrote: > Dear Richard, > > This is great api. > > output: > > (1) statement aborts at 5: [DETACH my_in_memory_db;] database > my_in_memory_db is locked > The DETACH failed because you have unfinalized statements using the attached

Re: [sqlite] detach failed with error code 1

Dear Richard, This is great api. output: (1) statement aborts at 5: [DETACH my_in_memory_db;] database my_in_memory_db is locked (1) statement aborts at 5: [ATTACH DATABASE '/full/path/info.db' AS my_in_memory_db;] database my_in_memory_db is already in use (1) statement aborts at 5:

Re: [sqlite] Why my question are not visibile in this group ?

Stefano Ravagni wrote: > Why my question are not visibile in this group ? Because this is not a group, it is a mailing list. Apparently, Google's archive stopped updating in 2012. If you want to know why Google Groups doesn't work, ask Google. Every single post in this list has a footer with

Re: [sqlite] Why my question are not visibile in this group ?

On Wed, Apr 16, 2014 at 3:13 PM, Stefano Ravagni wrote: > Why my question are not visibile in this group ? > > I send question but never see published... i have many difficult to > understand the way of support for Sqlite ... > > With Gmail you won't see your original

[sqlite] sqlite dump makes wrong "CREATE VIEW" order

sqlite in some cases dumps views in wrong order. how to reproduce on linux: 1) Make the test database with 2 "view". v1 depends on v2. Recreate v2 cat <<_EOF_ | sqlite3 test.sqlite PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE test ( "id1" integer(8,0), "id2" integer(8,0), "id3"

[sqlite] Why my question are not visibile in this group ?

Why my question are not visibile in this group ? I send question but never see published... i have many difficult to understand the way of support for Sqlite ... ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] detach failed with error code 1

Please turn on error logging (http://www.sqlite.org/errlog.html) and report back what error messages you are seeing. On Thu, Apr 17, 2014 at 6:47 AM, dd wrote: > Hi All, > > 1. prepare, step, then finalize: Attach DATABASE '/full/path' as > 'my_in_memory_db'; > 2.

[sqlite] detach failed with error code 1

Hi All, 1. prepare, step, then finalize: Attach DATABASE '/full/path' as 'my_in_memory_db'; 2. prepare, step, then finalize: Delete from my_in_memory_db.table_1 where primary_key = 'value'; 3. prepare, step, then finalize: DETACH my_in_memory_db; Executed above three queries in loop for