:
SELECT prop_value FROM Table1 WHERE obj_id=10 AND prop_key='key1' AND
(prop_tag='ios' OR prop_tag='*') ORDER BY (prop_tag='ios') LIMIT 1;
I would like to prioritise results based on the fact that the prop_tag column
is 'ios'.
Thanks.
--
Marco Bambini
https://www.sqlabs.com
More info at: https://github.com/marcobambini/sqlite-createtable-parser
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman
So it has nothing to do with which table/row the transaction is modifying?
In your example connection 2 always returns with an error on COMMIT?
Seems like the improvement is only on when the error occurs and not on
concurrency or am I missing something?
--
Marco Bambini
http://www.sqlabs.com
Is there a better formal description about the "transactions may not overlap"
sentence?
Is there any example about overlapping transactions?
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
>> The begin-concurrent branch
>> (https://sqlite.org/src/timel
server-process-edition would be a
better option for my case but is the branch still maintained and updated?
Are the branches mutually exclusive or can be used both in the same process?
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
Philippe,
with a bit of work you can use the authorize api in order to know when an
access to a non existing table is performed.
https://sqlite.org/c3ref/set_authorizer.html
Hope this helps.
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
> On 17 Mar 2018, at 15:53, Phili
with dlsym and once
done call dlclose.
I noticed that all function prototypes are already defined inside sqlite3ext.h
but I wondering if there is a function I could use to all the symbols from the
lib without manually process all the function names.
Any clue?
Thanks.
--
Marco Bambini
Seems like a good reason to introduce a way to query the existence of a
particular pragma command, something like:
PRAGMA exists('user_version');
or
PRAGMA exists='user_version';
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
http://instagram.com/sqlabs
> On 6 Apr 2017, at
You could just filter by screen size instead of user agent.
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
http://instagram.com/sqlabs
> On 06 Sep 2016, at 14:26, Richard Hipp <d...@sqlite.org> wrote:
>
> On 9/6/16, Nelson, Erik - 2 <erik.l.nel...@bankof
> On 02 Mar 2016, at 13:32, Luca Ferrari wrote:
>
> On Wed, Mar 2, 2016 at 1:10 PM, Marco Bambini wrote:
>> I developed the parser myself.
>
> Great job but...what is the aim?
> Why one should use this instead of, let's say, Perl SQL::Parser
> <http://search.c
I developed the parser myself.
Here you go a link to the GitHub page:
https://github.com/marcobambini/sqlite-createtable-parser
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
http://instagram.com/sqlabs
> On 02 Mar 2016, at 11:50, Clemens Ladisch wrote:
>
> Marc
can send me or help me find out some CREATE TABLE sql statements to add
to my internal tests?
Thanks.
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
http://instagram.com/sqlabs
Anyone know which encryption algorithm is used in System.Data.SQLite?
Seems like it doesn?t use the standard SEE sqlite extension.
Thanks a lot.
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
http://instagram.com/sqlabs
Is the sqlite3session module still available and supported?
If not is there a replacement/workaround for it?
Thanks a lot.
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
http://instagram.com/sqlabs
sqlite to interpret timestamp in ms?
Thanks.
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
http://instagram.com/sqlabs
, nor a link to download the executable from
http://www.sqlite.org/sqldiff.html <http://www.sqlite.org/sqldiff.html>.
Thanks.
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
http://instagram.com/sqlabs
> On 24 May 2015, at 08:59, Luuk wrote:
>
> On 24-5-2015 08:39
Where can I download sqlitediff and its source code?
Thanks.
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
http://instagram.com/sqlabs
to replace groupname with * if groupid is 0.
Please note that groupid 0 is never written into the Groups table so my
original query would return NULL as groupname with groupid is 0 instead of the
required "*".
Any idea?
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
http://ins
Thanks a lot Richard, I really appreciate.
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
http://instagram.com/sqlabs
On 07 May 2014, at 16:31, Richard Hipp <d...@sqlite.org> wrote:
> On Wed, May 7, 2014 at 9:00 AM, Marco Bambini <ma...@sqlabs.net> wr
So, is there an official recommended way? or that check should require a manual
sql parsing?
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
http://instagram.com/sqlabs
On 07 May 2014, at 15:51, Igor Tandetnik <i...@tandetnik.org> wrote:
> On 5/7/2014 9:40 AM, RSm
What is the best way to know if a table has been created with the WITHOUT ROWID
option?
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
http://instagram.com/sqlabs
___
sqlite-users mailing list
sqlite-users@sqlite.org
http
If I remember correctly, sqlite3_analyzer is a python script... I am not able
to find its source code since in the download page there is a binary app only.
Any help?
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
http://instagram.com/sqlabs
= sqlite3session_changeset(session, , );
pnChangeset is always 0.
Is this a bug or something not correctly documented?
Please let me know.
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
http://instagram.com/sqlabs
___
sqlite-users mailing list
sqlite
Documentation is not very clear about this point… in order to apply a change
set starting from a session should just I write something like:
int rc= sqlite3session_changeset(session, , );
rc = sqlite3changeset_apply (db, pnChangeset, ppChangeset, NULL, NULL, NULL);
Is that all?
--
Marco Bambini
?
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
http://instagram.com/sqlabs
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
What is the correct way to get a list of all registered sqlite tokenizers?
Thanks a lot.
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
http://instagram.com/sqlabs
___
sqlite-users mailing list
sqlite-users@sqlite.org
http
* FROM myTable WHERE myColumn LIKE '%super%';
While with the MATCH operator it does not find anything:
SELECT * FROM myTable WHERE myColumn MATCH '*super*';
Any help?
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
http://instagram.com/sqlabs
have another solution?
Any help?
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
http://instagram.com/sqlabs
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
sqlite API?
Please note that since I have access to the sqlite amalgamation source code I
could also expose an internal function.
Thanks.
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
http://instagram.com/sqlabs
___
sqlite-users maili
Hello,
we are extremely proud to announce a major release for our SQLiteManager
application (available for both MacOS X and Windows).
SQLiteManager is a powerful database management system for sqlite databases, it
combines an easy to use interface with blazing speed and advanced features.
t I do not understand what if
the correct way to perform the operation.
Thanks.
--
Marco Bambini
http://www.sqlabs.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Announcing SQLiteDoctor, the only way to recover your corrupted sqlite
databases.
Details available from:
http://www.sqlabs.com/sqlitedoctor.php
--
Marco Bambini
http://www.sqlabs.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http
Can I parse the output of the EXPLAIN my_query statement in order to have an
indirect access to columns involved in the WHERE clause?
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
On Sep 21, 2012, at 4:10 PM, Richard Hipp <d...@sqlite.org> wrote:
> On Fri, Sep
Can I parse the output of the EXPLAIN my_query statement in order to have an
indirect access to columns involved in the WHERE clause?
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
On Sep 21, 2012, at 4:10 PM, Richard Hipp <d...@sqlite.org> wrote:
> On Fri, Sep
Hello,
is there a way to extract column names involved in a WHERE clause of a query
without manually parse the select statement?
For example from a query like:
SELECT * FROM myTable WHERE col1=… AND col2=…;
I would need to extract both col1 and col2.
Thanks.
--
Marco Bambini
http
Hello,
can you please send me your corrupted database files? (or put somewhere where I
can download them).
I am finishing a new sqlite utility and I would like to test it with a lot of
different databases.
Thanks a lot!
--
Marco Bambini
http://www.sqlabs.com
Hello,
I am wondering if someone is able to provide some details (or directions) about
locking and concurrency in sqlite 4.
I guess there should be improvements over sqlite 3 but I am looking for
information.
Thanks.
--
Marco Bambini
http://www.sqlabs.com
I am sorry, but it was sent twice for a mistake.
--
Marco Bambini
http://www.sqlabs.com
On Jun 21, 2012, at 2:41 PM, Marco Bambini wrote:
> Consider the following example:
>
> CREATE TABLE t1(x);
> CREATE TABLE t2(y);
> SELECT max((SELECT avg(x) FROM t2)) FROM t1;
>
> Wi
Consider the following example:
CREATE TABLE t1(x);
CREATE TABLE t2(y);
SELECT max((SELECT avg(x) FROM t2)) FROM t1;
With sqlite 3.7.11 NULL is returned, while with sqlite 3.7.13 an error "Misuse
of aggregate: avg()" is returned.
Any thought?
--
Marco Bambini
http://www.sqlab
Consider the following example:
CREATE TABLE t1(x);
CREATE TABLE t2(y);
SELECT max((SELECT avg(x) FROM t2)) FROM t1;
With sqlite 3.7.11 NULL is returned, while with sqlite 3.7.13 an error "Misuse
of aggregate: avg()" is returned.
Any thought?
--
Marco Bambini
http://www.sqlab
Can you post some code or more details?
Sessions has been specifically developed to handle rollbacks so your issue
sounds really strange to me.
--
Marco Bambini
http://www.sqlabs.com
On Jun 13, 2012, at 8:57 PM, Charles Samuels wrote:
>
> I'm using sqlite's sessions module, a
./configure; make sqlite3.c
preupdate_hook code is in-line but no sessions related code.
--
Marco Bambini
http://www.sqlabs.com
On Jun 4, 2012, at 4:38 PM, Richard Hipp wrote:
> On Mon, Jun 4, 2012 at 10:34 AM, Marco Bambini <ma...@sqlabs.net> wrote:
>
>> I just tried to
ree/rtree.c keywordhash.h opcodes.c opcodes.h
parse.c parse.h config.h sqlite3.h tsrc
no ./ext/session/ folder is included.
Any help?
--
Marco Bambini
http://www.sqlabs.com
On May 31, 2012, at 9:27 PM, Richard Hipp wrote:
> On Thu, May 31, 2012 at 2:55 PM, Charles Samuels <char...@ca
anks a lot.
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
something confuse the Visual C++ compiler.
Any idea?
--
Marco Bambini
http://www.sqlabs.com
On Mar 30, 2012, at 1:08 PM, Nick Shaw wrote:
> -Original Message-
>> I am trying to compile the latest sqlite 3.7.11 amalgamation C file within a
>> Visual Studio 2008 Expr
\sqlite3.c(110555) : error C2059: syntax error : '!'
Can someone is able to give me an explanation and a way to fix them?
Thanks a lot.
--
Marco Bambini
http://www.sqlabs.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080
reordering oid within the same pid in
case of INSERT, UPDATE and DELETE.
Please note that if the trigger is too complicated then I could just execute a
smart sql statement every time table foo changes.
Anyone have a smart solution?
Thanks a lot.
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com
Hello,
I am wondering if there is there a place that collect all available sqlite
extensions.
Please let me know.
Thanks.
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
___
sqlite-users mailing list
sqlite-users@sqlite.org
http
Hello,
I am wondering if there is there a place that collect all available sqlite
extensions.
Please let me know.
Thanks.
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
___
sqlite-users mailing list
sqlite-users@sqlite.org
http
sqlite 3.7.8 on MacOS X
This query works fine:
SELECT rowid, * FROM 'customer' WHERE rowid < 100;
While this query does not return anything:
SELECT rowid, * FROM 'customer' WHERE 'rowid' < 100;
Do you have an explanation?
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/
to the databases or an optional
SQL text script can be generated.
SQLiteSync is available for both MacOS X and Windows.
More information available from:
http://www.sqlabs.com/sqlitesync.php
Sincerely.
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
Thanks a lot Tom, don't know why this email was delivered even today, it was
sent yesterday and Dr. Hipp already replied me.
Anyway… thanks a lot for your detailed explanation, I really appreciate.
--
Marco Bambini
http://www.sqlabs.com
On Jan 11, 2012, at 4:06 PM, BareFeetWare wrote
ame of the column being indexed.
I am particularly interested in the rank fields … what does rank really means
here?
Is there a lower/upper bound to this rank value?
Thanks a lot.
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sql
ame of the column being indexed.
I am particularly interested in the rank fields … what does rank really means
here?
Is there a lower/upper bound to this rank value?
Thanks a lot.
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
___
sql
Take a look at my SQLiteManager app:
http://www.sqlabs.com/sqlitemanager.php
--
Marco Bambini
http://www.sqlabs.com
On Nov 6, 2011, at 7:04 PM, Pete wrote:
> Opinions on the best one for OS X?
> Pete
>
>
>
>
>
>
>> Message: 6
>> Date: Sat, 05 N
https://discussions.apple.com/message/15712311#15712311
--
Marco Bambini
http://www.sqlabs.com
On Sep 5, 2011, at 10:46 PM, Lani Gonzales wrote:
> Dear Technical Support:
>
> Please help me remove this error message:
>
> The procedure entry point sqlite3_wal_c
Please take a look at cubeSQL:
http://www.sqlabs.com/cubesql.php
--
Marco Bambini
http://www.sqlabs.com
On Aug 4, 2011, at 7:15 PM, Vinoth raj wrote:
> Dear SQLite users,
>
> I have been using SQlite database since three years. Suddenly I have a
> requirement for client/se
Why this valid statement:
CREATE TABLE USER(
id text, -- the id of the user
nametext-- the name of the user
);
gives me a syntax error with sqlite 3.7.6.3?
Thanks.
--
Marco Bambini
http://www.sqlabs.com
Thanks a lot Igor, it's perfect now.
--
Marco Bambini
http://www.sqlabs.com
On Jun 12, 2011, at 4:46 PM, Igor Tandetnik wrote:
> Marco Bambini <ma...@sqlabs.net> wrote:
>> I have a table Clients defined as (simplified version):
>> CREATE TABLE Clients (i
No I am sorry but I need to query the ping_timeout column from inside the same
query.
--
Marco Bambini
http://www.sqlabs.com
On Jun 12, 2011, at 2:02 PM, Roger Andersson wrote:
> On 06/12/11 01:52 PM, Marco Bambini wrote:
>> things are recently changed in my app and ping_timeo
seconds', 'localtime');", settings.ping_timeout);
using just the ping_timeout column in the Clients table instead of the
settings.ping_timeout global property.
Any idea?
--
Marco Bambini
http://www.sqlabs.com
___
sqlite-users mailing li
Thanks Martin and Richard, solution was so simple that I think to need a time
break today.
Should I add an ORDER BY rowid clause at the end of the SELECT statement or its
implicit by the WHERE clause?
Thanks a lot.
--
Marco Bambini
http://www.sqlabs.com
On Jun 8, 2011, at 4:27 PM
by 1
but I am quite sure that should be a more elegant way.
Thanks a lot.
--
Marco Bambini
http://www.sqlabs.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
What is the official way to escape table name that contains a space and column
name that contain a spaces?
Thanks a lot.
--
Marco Bambini
http://www.sqlabs.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin
starts at $299 USD.
For more information, please visit the SQLabs website:
http://www.sqlabs.com
--
Marco Bambini
http://www.sqlabs.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
4.3 MB seems really too big... you are probably building a debug version of the
library.
--
Marco Bambini
http://www.sqlabs.com
On May 16, 2011, at 5:01 PM, Tito Ciuro wrote:
> Hello,
>
> I have a question about SQLite running on iOS. If I'm not mistaken, SQLite on
> iOS is
Dave please take a look at this blog post:
http://www.sqlabs.com/blog/?p=51
--
Marco Bambini
http://www.sqlabs.com
On Apr 28, 2011, at 9:36 PM, Dave Hayden wrote:
> When the VACUUM feature was added I took a look at using it to keep database
> file sizes down, but disc
Thanks a lot Simon and Robert.
--
Marco Bambini
http://www.sqlabs.com
On Mar 4, 2011, at 11:50 AM, Robert Hairgrove wrote:
> On Fri, 2011-03-04 at 11:10 +0100, Marco Bambini wrote:
>> Hello,
>> I have a table defined as:
>> CREATE TABLE MKProperties (id INTEGER PRIM
2 PARENTID0
2 RESOURCE_ORDER 1
3 PARENTID0
3 RESOURCE_ORDER 3
I need a query that returns all the obj_id with prop_key='PARENTID' AND
prop_value='0' but ordered by prop_value WHERE prop_key='RESOURCE_ORDER'.
Any help?
--
Marco Bambini
http://www.sqlabs.com
Michele take a look at the sqlite3_status function:
http://www.sqlite.org/c3ref/status.html
and
http://www.sqlite.org/c3ref/c_status_malloc_count.html
--
Marco Bambini
http://www.sqlabs.com
On Feb 25, 2011, at 2:17 PM, Michele Pradella wrote:
> Do you know if is there a way to
simple queries is a better approach for the
maintainability of the project.
Thanks a lot for your advices.
--
Marco Bambini
http://www.sqlabs.com
On Feb 2, 2011, at 8:11 PM, Igor Tandetnik wrote:
> On 2/2/2011 11:16 AM, Marco Bambini wrote:
>> your query returns 3 columns, but I
)
and MKProperties contains (1,1,NAME,About Box) and (2,1,WIDTH,200)
the result of the query should should be:
col1col2
'ID'1
'NAME' 'About Box'
'WIDTH', '200'
--
Marco Bambini
http://www.sqlabs.com
On Feb 2, 2011, at 1:43 PM, Igor Tandetnik wrote:
> Marco Bambini <ma...@sqlabs.net&
using 3 select statements).
Thanks a lot.
--
Marco Bambini
http://www.sqlabs.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I recompile sqlite without the SQLITE_OMIT_TEMPDB
macro.
Anyone can confirm my assumption?
Thanks a lot.
--
Marco Bambini
http://www.sqlabs.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Where I can find more information about TEMP TRIGGERs?
In the official page:
http://www.sqlite.org/lang_createtrigger.html
there is no mention about the TEMP clause.
Thanks.
--
Marco Bambini
http://www.sqlabs.com
___
sqlite-users mailing list
have full
control over the conversion process, you can decide to convert the entire
database or just select the individual tables you want to backup.
More information available from:
http://www.sqlabs.com/sqliteconverter.php
--
Marco Bambini
http://www.sqlabs.com
Try to add:
-DSQLITE_THREADSAFE =1
to your compilation options.
--
Marco Bambini
http://www.sqlabs.com
On Dec 15, 2010, at 2:34 PM, Yoni Londner wrote:
> Hi,
>
> I wrote a little program that insert in a loop rows in to the DB, and in
> another thread run wal_checkpoint.
I just tried it on my Mac and this new build works pretty well.
Thanks a lot for your assistance.
--
Marco Bambini
http://www.sqlabs.com
On Dec 8, 2010, at 1:54 AM, Richard Hipp wrote:
> In Tue, Dec 7, 2010 at 7:15 PM, Richard Hipp <d...@sqlite.org> wrote:
>> On Tue, Dec 7,
Running sqlite3_analyzer on a MacOS X 10.6.5 results in the following issue:
dyld: Library not loaded: /usr/local/lib/libtcl8.6.dylib
Referenced from: /Users/marco/Desktop/sqlite3_analyzer
Reason: image not found
Trace/BPT trap
Seems like a broken binary to me.
Any idea?
--
Marco Bambini
http
starting from now (in localtime).
Thanks a lot.
--
Marco Bambini
http://www.sqlabs.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hello,
if a running sqlite database is in WAL mode and a backup is performed on that
db using the sqlite3_backup API, does that process is considered like a reader
and can proceed concurrently with other readers and with the other writer?
Thanks a lot for your answer.
--
Marco Bambini
http
A SQLiteConverter single license is $49 USD. Company and multiplatform licenses
are also available. For more information, please visit the SQLabs website.
--
Marco Bambini
http://www.sqlabs.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org
onstraints
--
Marco Bambini
http://www.sqlabs.com
http://www.creolabs.com/payshield/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Marco Bambini
http://www.sqlabs.com
http://www.creolabs.com/payshield/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Unfortunately I cannot modify the query... it is supplied by an user.
--
Marco Bambini
http://www.sqlabs.com
http://www.creolabs.com/payshield/
On Nov 13, 2009, at 3:10 PM, Virgilio Fornazin wrote:
> SELECT
> field as NAME
>
> does not work?
>
> On Fri, Nov 13, 20
sqlite 3.6.19
CREATE TABLE foo (col1 INTEGER PRIMARY KEY, col2 TEXT);
a
SELECT rowid, col1, col2
returns the following column names with sqlite3_column_name:
col1, col1, col2
Is there a way to force the first column name to be returned as rowid and not
as its col1 alias?
Thanks.
--
Marco
Hello Yan,
you could use my SQLiteManager application:
http://www.sqlabs.com/sqlitemanager.php
Regards,
--
Marco Bambini
http://www.sqlabs.com
http://www.creolabs.com/payshield/
On Sep 21, 2009, at 9:43 AM, Yan Bertrand wrote:
>Hi all,
>
>
>
> I would
Yes, you are right (as always).
Time with SQLITE_THREADSAFE=0 is about 4.33 seconds now.
Thanks a lot.
--
Marco Bambini
http://www.sqlabs.com
http://www.creolabs.com/payshield/
On Aug 28, 2009, at 5:23 PM, D. Richard Hipp wrote:
>
> On Aug 28, 2009, at 11:17 AM, Mike Eggleston
Library is statically linked into the final app and the db is newly
created...
--
Marco Bambini
http://www.sqlabs.com
http://www.creolabs.com/payshield/
On Aug 28, 2009, at 5:17 PM, Mike Eggleston wrote:
> On Fri, 28 Aug 2009, Marco Bambini might have said:
>
>> Hello,
>&g
possible explanation?
Thanks.
--
Marco Bambini
http://www.sqlabs.com
http://www.creolabs.com/payshield/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Have you tried my SQLiteManager app?
http://www.sqlabs.com/sqlitemanager.php
It can easily convert/import your CSV file into an sqlite3 database.
--
Marco Bambini
http://www.sqlabs.com
http://www.creolabs.com/payshield/
On Aug 7, 2009, at 4:57 PM, Adam DeVita wrote:
> This is wh
VIADANA, Italy (June 24, 2009) - SQLabs is proud to announce today the
worldwide availability of SQLiteManager 3.0, the most powerful sqlite
database manager tool for MacOS X and Windows.
SQLiteManager is a "next generation" GUI database manager for sqlite
databases. It combines an
Hello Martin,
it's a db than an user sent me... so I really don't know...
--
Marco Bambini
http://www.sqlabs.com
http://www.creolabs.com/payshield/
On Jun 5, 2009, at 11:31 AM, Martin Engelschalk wrote:
> Hi Marco,
>
> How do you insert this data into your database?
> I
I understand that the issue could be caused by the wrong datatype...
but what is strange is that the same db and the same query worked fine
with sqlite 3.4.2 and the behavior changed with sqlite 3.6.x
--
Marco Bambini
http://www.sqlabs.com
http://www.creolabs.com/payshield/
On Jun 5
I just posted the db on my website... there is one row and there
aren't invisible characters.
Please note that the following query returns the exact row:
SELECT * FROM lo_user WHERE CAST(lo_name AS TEXT)='admin';
but I really don't have an explanation...
--
Marco Bambini
http://www.sqlabs.com
You can download the db from:
http://www.sqlabs.com/download/test.sqlite
It's only 4KB.
--
Marco Bambini
http://www.sqlabs.com
http://www.creolabs.com/payshield/
On Jun 5, 2009, at 11:04 AM, Marco Bambini wrote:
> Anyone can please explain me why this query:
> SELECT * FROM lo_user
Anyone can please explain me why this query:
SELECT * FROM lo_user WHERE lo_name='admin';
returns 0 rows in this db?
Thanks.
--
Marco Bambini
http://www.sqlabs.com
http://www.creolabs.com/payshield/
___
sqlite-users mailing list
sqlite-users
SELECT ... LIMIT 1;
--
Marco Bambini
http://www.sqlabs.com
http://www.creolabs.com/payshield/
On May 19, 2009, at 5:03 PM, Sam Carleton wrote:
> I am far from a SQL expert, but I am 99.9% sure there is SQL syntax
> to limit
> the number of results, I have not looked it
Thanks a lot for the explanation Igor.
--
Marco Bambini
On May 14, 2009, at 1:55 PM, Igor Tandetnik wrote:
> "Marco Bambini" <ma...@sqlabs.net> wrote
> in message news:aa7dd05f-4679-43dd-9dd3-2ba6b98af...@sqlabs.net
>> I have two threads that are writin
rror or missing database (printed with sqlite3_errmsg).
Any explanation of the possible causes for the missed rows?
Thanks.
--
Marco Bambini
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
1 - 100 of 191 matches
Mail list logo