mple query:
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 '
following output:
1
1
2
* What did go wrong:
The second query yields to the output:
1
It seems that the limit clause in the compound select when used inside a
view is used for the overall result set and not for the subquery.
In the hope that this might help others.
Thank you very much for your har
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/timelin
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
&g
Excerpts from Richard Hipp's message of 2017-03-13 14:47:49 -0400:
> On 3/13/17, Marco Silva wrote:
> > Hi,
> >
> > Does anyone knows a Common Table Expression (CTE) to be used with the
> > sqlite_master table so we can count for each table how many rows it
>
Hi,
Does anyone knows a Common Table Expression (CTE) to be used with the
sqlite_master table so we can count for each table how many rows it
has.
--
Marco Arthur @ (M)arco Creatives
___
sqlite-users mailing list
sqlite-users
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 wrote:
>
> On 9/6/16, Nelson, Erik - 2 wrote:
>>
>> What percentage of sqlit
Hi,
How do we know how many connections a database has ? Is it possible
to query it using SQL ? Is there a simple command from the sqlite3
shell client ?
--
Marco Arthur @ (M)arco Creatives
> 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://sea
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
fts5 table, I might as well use use the external content table.
>
> Any additional thoughts on this from the more knowledgeable?
>
> enjoy,
>
> -jeremy
>
> --?
>
> Jeremy Hinegarnder
> Copious Free Time, LLC
--
Marco Arthur @ (M)arco Creatives
Solved.
At the end I have added the parameter -DSQLITE_THREADSAFE=0 to exclude the
multithread code from the library
Thank you.
Marco
-Original Message-
From: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Clemens
Hi,
could you please give me the full Bcc32 string you are using ?
thank you
Marco
-Original Message-
From: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Clemens
Ladisch
Sent: Thursday, October 22, 2015 4:22 PM
To
dex' referenced from
K:\ACTIVEXP\SOURCE\SQLITE.SEE\SQLITE3.LIB|sqlite3
Error: Unable to perform link
Marco
-Original Message-
From: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of R.Smith
Sent: Thursday, October 22,
lite_see_2013\sqlite_see_2013.bcl ,
K:\sqlite_see_2013\Debug\sqlite_see_2013.Lst
TLIB 6.4 Copyright (c) 1987-2014 Embarcadero Technologies, Inc.
+K:\sqlite_see_2013\Obj\sqlite3.Obj
Any help ? Thank you in advance
Marco
s what I suggested you: create a new trigger for t2 itself to check
on the values inserted.
>
> Best Regards,
> Daniel
--
Marco Arthur @ (M)arco Creatives
w in t3 to the
> corresponding row in t2
may try this to insert into t3.
CREATE TRIGGER trigger_on_table_1
AFTER UPDATE OF value ON t1
FOR EACH ROW WHEN NEW.VALUE = 1 AND EXISTS (SELECT id FROM te WHERE
ti_id = NEW.id)
BEGIN
-- SELECT THE ROWS FROM t2 to insert values
INSERT INTO t3 VALUES(id, name) SELECT t2.t1_id, 'dummy' FROM t2
WHERE t2.t1_id == NEW.id;
END;
Then you may wish to set a trigger to t4 itself to handle the newly
created t3 rows.
--
Marco Arthur @ (M)arco Creatives
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
ate.
How can I tell sqlite to interpret timestamp in ms?
Thanks.
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
http://instagram.com/sqlabs
more clever than average Joe and sooo
> caring about performance, they certainly would have fixed the hundreds of
> memory leaks that plague FF users
>
This is going off topic, I'd be happy to digress about this but it's not
the right place. If you have suggestions or bugs, the codebase is open and
the bug tracker is public, you can reach every single developer through
mail or IRC. You have all the tools to make the difference.
Marco
2015-06-15 18:05 GMT+02:00 Jean Chevalier :
> What I'm thinking now is to what extent the developer who put up the
> Mozilla wiki page was entitled to put up opinions and statements either
> expressed or implied about a third-party product on behalf of the Mozilla
> Foundation (though is that the
diff
code, 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-
Where can I download sqlitediff and its source code?
Thanks.
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
http://instagram.com/sqlabs
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 wrote:
> On Wed, May 7, 2014 at 9:00 AM, Marco Bambini wrote:
>
>> What is the best way to know if a ta
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 wrote:
> On 5/7/2014 9:40 AM, RSmith wrote:
>> SELECT in
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
ration but after executing the UNDO code above, when I call:
rc = sqlite3session_changeset(session, &pnChangeset, &ppChangeset);
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/sql
LL);
Is that all?
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
http://instagram.com/sqlabs
On 03 Jan 2014, at 15:54, Richard Hipp wrote:
> The standard pre-built amalgamation won't work with sessions. You have to
> pull source code from the "sessions" br
?
--
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
http://www.horsecenter.com.br/i4jsow.php
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
?
Thanks in advance
Marco
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
nyone 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
to UTF-8 just using
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
__
) and this version
creates a correct backup.
Thanks for the fix.
--
Regards,
Marco ten Thije
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On 01/02/2013 11:03 AM, Marco ten Thije wrote:
On 01/02/2013 10:04 AM, Dan Kennedy wrote:
What series of commands did you pass to 3.7.5 to create
this file?
This file was copied from an existing product which uses QT 4.7
libraries to populate the database. I cannot
reproduce the exact
sed
Page 66 is never used
Page 68 is never used
Page 73 is never used
Page 82 is never used
Page 89 is never used
Page 91 is never used
Page 93 is never used
Page 98 is never used
Page 99 is never used
--
Regards,
Marco ten Thije
___
sqlite-users maili
00060 2d00 1de2 000d 0004 00e3 7202 2002
070 7301 e300
080
--
Regards,
Marco ten Thije
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/ma
attachments.
Best regards,
Marco ten Thije
//
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
00 27e2 000d 0004 00e3 7202 2002
On 12/21/2012 02:34 PM, Eric Minbiole wrote:
Can you please try running "pragma integrity_check;" on the original
database? That will give an indication of whether the original database
has any data corruption.
On Fri, Dec 21, 2012 at 4:13 AM,
are not writing to the database during
the backup.
Is this a bug or some other problem?
--
Regards,
Marco ten Thije
*Use system engineering bv*
Loc: Industriestraat 77 - 7482 EW HAAKSBERGEN - The Netherlands Mail
Address: Po
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.
SQLite
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 wrote:
> On Fri, Sep 21, 2012 at 9:56
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 wrote:
> On Fri, Sep 21, 2012 at 9:56 AM, Ma
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
s external resource", or a reserved
series like SQLITE_USRERR1, SQLITE_USRERR2, ... that an
application can interpret in its own way.
>> So is it better if I do not expose them at the foreign
>> language level?
>
> Ahh... that's an interesting que
sqlite3_bind_value()" and
"sqlite3_result_value()" there only for SQL function
implementations embedded in the source code of SQLite? So
is it better if I do not expose them at the foreign language
level?
HTH
--
Marco Maggi
___
sqlite-
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
./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 wrote:
>
>> I just tried to download:
>> http://www.s
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 wrote:
>
> I
without
the Sqlite3 internal lock system.
So, is there a way to disable the Sqlite locking system (windows) ? As I
know this is already available in Sqlite3 unix using the unix-nolock
parameter in lib compilation.
Thanks in advance
Best Regards,
Marco
What about if table name or column name contains that escape character?
Do I need to escape it in another way?
Please let me know.
Thanks a lot.
--
Marco Bambini
http://www.sqlabs.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlit
is the expected behavior or am I missing something?
Thanks in advance.
Marco
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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
like also Extended Result Codes do not cover this case.
Please help.
Thanks let me know.
--
Marco Bambini
http://www.sqlabs.com
___
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
f '.eOperator' must have
struct/union type
..\Sources\sqlite3.c(110554) : error C2198: 'sqlite3ExprFunction' : too few
arguments for call
..\Sources\sqlite3.c(110555) : error C2059: syntax error : '!'
Can someone is able to give me an explanation and a way to fix them?
T
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
Hi all,
I need to alter a field from smallint(1) to smallint(2),
is there to do this using ALTER TABLE ?
Thanks in advance
Marco
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite
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.
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
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
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
On 08/10/2011 01:24, Joe Mistachkin wrote:
Marco Cosentino wrote:
The ErrorCode is set to "NotADatabase".
Wouldn't it more correct if this code is set to something like
SQLiteErrorCode.Auth or the Exception is more specialized?
The exceptions thrown by System.Data.SQL
code is set to something like
SQLiteErrorCode.Auth or the Exception is more specialized?
Thank you
Marco
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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_checkpoi
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
Works.. Im really sorry for my stupid question, thanks for support and
your time, i think that i need an holyday.. Marco
Il giorno domenica 17 luglio 2011, Black, Michael (IS)
ha scritto:
> Column numbers are zero-based, not one-based.
>
> From http://www.sqlite.org/c3ref/column_
",
\"now\")"];
}
-(int) setClientiUpdated{
return [self ioSQL:@"update settings set AAClienti=strftime(\"%Y\",
\"now\"), MMClienti=strftime(\"%m\", \"now\"), GGClienti=strftime(\"%d\",
\"now\")"];
}
-(int) setOrdiniUp
.. im really getting crazy.
i know i can close my eyes and invert that commands, but i care my software
and i really like to know what im doing wrong..
thx for reply, marco
2011/7/17 John Deal
> Hello,
>
> I am new and have received much information from this list so I hope I am
> not was
"now"), strftime("%d", "now")
from settings
returns correct values, running or loading value into XCode simulator looks
not working and i dont know why. :'(
does anyone can suggest me what to fix or check?
thx in advance, marco
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 wrote:
>> I have a table Clients defined as (simplified version):
>> CREATE TABLE Clients (id INTEGER PRIMARY KEY AUTOINCR
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
where last_activity <
datetime('now', '-%d.00 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
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
Hi all,
We are successfully using the SEE module in Sqlite.
All runs well but we need to provide a ODBC connection to a limited number
of users.
Question: is there a Sqlite odbc driver SEE compatible ?
Thanks.
Regards,
Marco Turco
IT Business Devl Manager
Software XP LLP
1 - 100 of 270 matches
Mail list logo