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
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
I have a sqlite table like this:
id namemnote
7 DDD_POSTE_DE_COND
2;AA35469850.1;DDD;ECRHEMBNETM6X100AC8Z;000
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
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
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?
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
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
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
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
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
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
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
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
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.
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
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
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
-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
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
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:
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
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 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"
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
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.
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
27 matches
Mail list logo