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()
2011/7/17 Simon Slavin slav...@bigfraud.org
On 17 Jul 2011, at 4:03am, san long wrote:
(process name)
Implement this logic in your programming language,
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
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.
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
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
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
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.
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
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
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);
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
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
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)
michael.bla...@ngc.com ha scritto:
Column numbers are zero-based, not one-based.
From
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 (compile
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
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, an
-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
dcharno dcha...@comcast.net 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.
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(a,b));
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
20 matches
Mail list logo