Hi there,
I've searched around and found a few threads like this:
http://sqlite.phxsoftware.com/forums/t/2480.aspx
Basically, I have the same issue.
When access the sqlite database via a website (MVC3 running on IIS) the
first time, sqlite works fine.
I properly call connections.Close() when I
I decided to test this so here's an almost-complete example minus any
cross-checks on the tables which you should ultimately do.
This implements exclusion rules which is what you've been describing.
You can make them inclusion rules if you just remove the "not" in the select
statement below, but
On 07/17/2011 09:50 AM, Simon Slavin wrote:
>
> On 17 Jul 2011, at 2:40pm, dcharno wrote:
>
>> I have a table where columns a and b form a unique key for column c. In
>> an attempt to speed up queries I added an index on a and b.
>>
>>CREATE TABLE t(a TEXT, b TEXT, c TEXT, CONSTRAINT u UNIQUE(
dcharno wrote:
> I have a table where columns a and b form a unique key for column c. In
> an attempt to speed up queries I added an index on a and b.
>
> CREATE TABLE t(a TEXT, b TEXT, c TEXT, CONSTRAINT u UNIQUE(a,b));
> CREATE INDEX iab ON t(a, b);
Don't create that index. One is already
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/17/2011 06:29 AM, Simon Slavin wrote:
> Of course my hacked SQLite library
You don't have to hack the SQLite library. Simply create a virtual table
with the table name they expect and filter out rows as appropriate. The
real table can be in t
On 17 Jul 2011, at 2:40pm, dcharno wrote:
> I have a table where columns a and b form a unique key for column c. In
> an attempt to speed up queries I added an index on a and b.
>
> CREATE TABLE t(a TEXT, b TEXT, c TEXT, CONSTRAINT u UNIQUE(a,b));
> CREATE INDEX iab ON t(a, b);
>
> But, a
I have a table where columns a and b form a unique key for column c. In
an attempt to speed up queries I added an index on a and b.
CREATE TABLE t(a TEXT, b TEXT, c TEXT, CONSTRAINT u UNIQUE(a,b));
CREATE INDEX iab ON t(a, b);
But, an automatic index is being used even though it seems lik
On 17 Jul 2011, at 2:00pm, Pavel Ivanov wrote:
>> I can only control the databases and the libsqlite.so.
>> Is everything clear?
>
> How do you do that, I wonder? Why do you think that applications you
> don't control will always use your libsqlite.so? They may not use
> libsqlite.so at all (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_blob.html
>
> "Th
If you don't know how to get your rules yet then you don't know how to design a
solution.
Based on what you've said I see 2 more tables.
create table (pid int, rule int)
create table (rule int, record int)
You can have multiple rules per pid, reuse rules across pids, and records can
overl
> I can only control the databases and the libsqlite.so.
> Is everything clear?
How do you do that, I wonder? Why do you think that applications you
don't control will always use your libsqlite.so? They may not use
libsqlite.so at all (compile SQLite sources into application) or use
whatever libra
Column numbers are zero-based, not one-based.
>From http://www.sqlite.org/c3ref/column_blob.html
"The leftmost column of the result set has the index 0. "
That's at least part of your problem.
So should be:
k.AAArticoli=sqlite3_column_int(statmentS, 0);
k.MMArticoli
Yes, if the OP is not familiar with VBA then that is the best option.
If he is familiar with VBA then with the mentioned wrapper you could
write a simple
Excel add-in (.xla) that will allow you to dump data from SQLite to Excel.
RBS
On Sun, Jul 17, 2011 at 12:56 PM, Baruch Burstein wrote:
> Best
if can help, thats real code :
-- to read
-(void) readUpdateStatus{
const char *sql="select
AAArticoli,MMArticoli,GGArticoli,AAFoto,MMFoto,GGFoto,AAClienti,MMClienti,GGClienti,AAOrdini,MMOrdini,GGOrdini,AA,MM,GG
from settings";
sqlite3_stmt *statmentS;
if (sqlite3_prepare_v2(databas
Best way is to use a tool like "SQLite Database Browser" (or a similar
tool). You can get it from
http://portableapps.com/apps/development/sqlite_database_browser_portable or
from
http://sourceforge.net/projects/sqlitebrowser/files/sqlitebrowser/2.0%20beta1/sqlitebrowser_200_b1_win.zip/download.
Op
you'r right, i made a mistake doing copy and paste writing original mail,
the real select query contains more fields and i can ensure that 1 based
indexes are correct and respected into the real code, real update query is
hardcoded, no params (0 based): 2 days checking, im sure..
at least, do u k
Hello,
I am new and have received much information from this list so I hope I am not
wasting bandwidth. I don't know if it is my misunderstanding or typos but
should your sqlite3_column_int() use indexes 0,1 and 2 instead of 1, 12 and 13?
If this is the case, according to the docs on sqlite3_c
Hi all,
call me stupid but after some days of try and a lot of Googleing, im still
wondering how to solve my problem:
i need to execute a query that updates 3 integer fields (AA, MM, GG) of a
table, containing respectively today year, today month and today day:
update settings set AA=strftime('%Y'
Best way to do this is probably with a VB SQLite wrapper and I would recommend
this one:
http://www.thecommon.net/3.html
Download from this link.
The Toolset-Binaries: (ca. 1.8MB)
There is example code showing you how to use it.
If you get stuck I can mail you a workbook that demonstrates it all.
> actually I don't know how to get my rules yet, but let's assume the
> rules
> exist and we can get it from a function.
> get_forbidden_ids()
I've never done it, so don't know whether it's possible, but you may
be able to create a virtual table on top of the real table which calls
get_forb
20 matches
Mail list logo