, the initial byte of a text value
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
of these is the correct name, or are they equivalent?
--
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
this sort of undo system using triggers.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
, but I don't think you would have much ground to stand
on in trademark dispute, especially if you have not registered your
trademark.
Just my two cents.
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin
for an unregistered trademark for that matter) on your website, so I
assumed you hadn't registered the trademark.
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
optimization for
applications were it makes sense.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
it is really an interface to
whole underlying operating system, *NOT* just the filesystem.
Or something similar. Maybe the NOT doesn't need that much emphasis, but
it should be there.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
Used Database. That may clear the saved database name.
After that you can try re-enabling the option after opening the new
database file.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman
Day = '11'
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
for
more details).
You do not need to clear the old bindings if you are going to bind new
values for each of the variables before you execute the command again.
The clear binding call basically binds a NULL to each variable, which
you are overwriting anyway.
HTH
Dennis Cote
://www.sqlite.org/sqlite-source-3_6_16.zip. Compile and link shell.c
and sqlite3.c from the amalgamation together like this (untested):
gcc sqlite3.c shell.c -o sqlite3.exe
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http
where movies.id = 'tt0426459';
select title,my_rating
from movies natural join user
where user.id = 'tt0426459';
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo
of:
INSERT INTO a(code,name,identity) VALUES('V','abc',1);
why don't you do this:
INSERT INTO a(code,name,creator) VALUES('V','abc',1);
I think you may need to expand on your description of shooting
new.identity into another field to clarify what you are trying to
accomplish.
Dennis
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
that the parser is basically designed to only accept a
STRING at that position, not an expression which is what would be
required to allow concatenation and other function calls. I assume that
the other possible values (join keyword etc) would be caught and
reported as errors.
HTH
Dennis Cote
the rowid should be very fast, and
once the page with the required record has been read into the cache the
subsequent value lookup queries
should execute very quickly as well.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http
, execute
the insert, then reset the statement to be run again for the next insert.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
off at the end of the previous run.
I would have expected the time to stabilize on 3 byte values fairly
qucikly, and then only change again when switching to values that
required 4 bytes.
This may be a part of the answer even if it is not the complete answer.
Dennis Cote
other database programs don't complain when you to break
this rule because it is sometimes useful to get a randomly selected
value for a column in the group. Usually it just leads to the confusion
you are seeing.
HTH
Dennis Cote
___
sqlite-users
should file a bug report using this example. If there is
a bug it will probably be fixed in short order.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
before
the changes are implemented. I think it could help to avoid future
errors like the sqlite_column_text return type issue.
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite
is this? It's certainly not
English. :-)
It seems to me that robinsmathew should investigate the shift key, and
the spell check functions in his email client.
Is it just me, or do others find jibberish like wat, jus, wanna, i,
wen, etc... to be very distracting and not the least bit cool?
Dennis
available turns many common tree queries into pattern
matches against the path using like conditions on standard SQL queries.
Unless your tees are very large I find this method to be a very good
alternative to simple adjacency lists or nested sets.
HTH
Dennis Cote
the suffix, and changing the name of the
CURRENT_TIMESTAMP default value to CURRENT_DATETIME so that
CURRENT_TIMESTAMP can be used for an julian day number, etc.
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin
executing the select.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
to use SQL for just a FIFO, but then again, SQLite
would take acre of all ACID / concurrency issues.
Has this been done before?
You can use simple triggers to manage a fifo in a table.
See http://www.mail-archive.com/sqlite-users@sqlite.org/msg12121.html
for an example.
HTH
Dennis Cote
and pass it back
into a second sqlite command. You would be replacing Python programming
with bash shell scripting.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
of a statement when it was compiled outside a transaction. This
opcode would incorrectly close the transaction when executed inside a
transaction.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman
these two tables
into a single table in the first place. It would eliminate the need to
combine them for this type of query. The tables already have a type
field to distinguish the email adresses from the phone numbers, so there
is no need to put them in separate tables.
HTH
Dennis Cote
the pragma
collation_list, but there is no equivalent for functions.
SQLite seems to assume that only the application that creates a function
will ever use the function, so there is no need for this information.
HTH
Dennis Cote
___
sqlite-users mailing list
);
Of course this won't work if you are relying on the unique constraint to
eliminate duplicate strings in your data.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
project and include sqlite3.h in
your source files that call sqlite functions.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
;
}
}while( rc==SQLITE_ROW );
// finalize the statement to release resources
sqlite3_finalize(stmt);
}
// close the database file
sqlite3_close(db);
}
}
return rc!=SQLITE_DONE;
}
HTH
Dennis Cote
___
sqlite-users
() function.
select title from event
where starttime windowstart
and starttime windowend
union
select title from event
where starttime =
(select starttime from event
where starttime = windowstart
order by starttime desc
limit 1);
HTH
Dennis Cote
is
strange to the vast majority of the worlds population. :-)
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
sizes as s on t.size=s.id;
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
(length(a) = 15),
b integer check (typeof(b) = 'integer')
);
insert into t values('one', 1);
insert into t values('two', 'three');
insert into t values('one hundred twenty three million...', 123456789);
HTH
Dennis Cote
___
sqlite-users
cases where it is not
suitable, a user could continue to use the ICU extension just as they
can now.
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
for the Spatialite GUI which can be found at
http://www.gaia-gis.it/spatialite/
It is a free open source Mac OS X native GUI DB management tool.
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman
to get access to that function.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Jibin Scaria wrote:
I am facing problem with spaces in the database path, able to open database
but queries are returning no such table: table name.
If your table names contain embedded spaces you must quote the name in
your SQL queries
select * from table name;
HTH
Dennis Cote
to a floating point value to
ensure that a floating point division is done.
sqlite select cast(SUM(1) as real)/3;
0.333
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite
test_table;
test_field two
-- --
-1 one
You can report the bug at
http://www.sqlite.org/cvstrac/captcha?nxp=/cvstrac/tktnew
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org
On Sun, Oct 5, 2008 at 7:59 AM, Gilles Ganault [EMAIL PROTECTED]wrote:
This is for an accounting program: As an exemple, all accounts
starting with 6 must be listed together, which means that eg. 6001
must come after 601, and not after, say, 801.
It sounds like you want the account numbers
the
sqlite3_step function the second time? This should also generate an
different error (possibly SQLITE_MISUSE) but I just want to be sure what
you are doing when you get the IOERR return. It would be best if you
could post the code you are using to prepare and execute the query.
Dennis Cote
P Kishor wrote:
Still, you have a point, and maybe DRH will expound and enlighten us
on his reticence to enable locking style equal to one.
It seems he isn't so reticent after all. See checkin [5737] from this
morning at http://www.sqlite.org/cvstrac/chngview?cn=5737.
Dennis Cote
sensitive
comparisons. This may lead to a change in behavior if the string
zConflict is not constrained to be lower case elsewhere in the code.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman
on a complete query, but I have managed to trigger a
crash in SQLite in the process.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
for the insert trigger. It executes after each row is inserted.
Always add 1.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
still have a journal file then you must have a
manual transaction open.
You will probably get better, more detailed, help if you post the code
you are using to write to the database.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users
to see if this can be corrected.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
have, and what format do you really want to
use to display it?
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
)
as 'MAC Address'
from t;
This assumes that the table t has an integer column mac that hods the
mac address to be displayed.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman
) + 1, 1)
as 'MAC Address'
from t;
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
address as an integer.
select data, mac_addr
from t
join tv on tv.id = t.id
where t.mac in (select ...)
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
the outer back
tick quotes. SQLite seems to get confused because the quotes appear at
the ends of the identifier string.
Have you filed a bug report to see in any of these can be resolved?
Dennis Cote
___
sqlite-users mailing list
sqlite-users
in any of these can be resolved?
I will file a bug report for this one.
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Lothar Behrens wrote:
Am 10.09.2008 um 17:37 schrieb Dennis Cote:
Lothar Behrens wrote:
What is the function to rollback a transaction or commit ?
I want also to break into these functions. If there is no way I try
to implement the rollback and commit callbacks.
Also the closing
primary
key column as this will eliminate a rowid lookup operation if it is an
indexed column.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
of views ?
In some ways. You can use a view to hide the complexity of a query.
create view foo_B as
select B.* from A join B on B._ID = A.b where A.name = 'foo%';
With this view defined you can now get the same results using a simpler
query.
select * from foo_B;
HTH
Dennis Cote
Clark Christensen wrote:
Long setup for a simple question: Is null the expected result when
one column of a concatenation operation is null?
Yes, that is the result required by the SQL standard. The result of a
concatenation operator is NULL if either argument is NULL.
HTH
Dennis Cote
return. This will probably
cause problems if you use this to execute a query.
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
insert untrimmed data, but the database will
only store trimmed data, and therefore you will only ever retrieve
trimmed data.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite
Joanne Pham wrote:
Any idea about these error messages:
0xb6f67ca5 in enterMem () at ../src/mem1.c:66
66sqlite3_mutex_enter(mem.mutex);
Current language: auto; currently c
What version of sqlite are you using? Line 66 in mem.c is a comment in
the current version.
Dennis
and
invoice.status.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
return. You
should simply sleep and then continue to retry.
If you want to ensure you don't loop forever, you could add a retry
counter and do a reset and return if the retry limit is exceeded.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite
a like comparison to locate the strings quickly using
the index (since the search string is now the prefix of string).
select field from sometable
where reversed like reverse(:somestring) || '%';
HTH
Dennis Cote
___
sqlite-users mailing list
file you are looking at with your database browser.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
for details.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
application will
be rolled back and lost (see H12019 at
http://www.sqlite.org/c3ref/close.html).
Can you add a function to check the auto commit status in your main line
code (i.e. where you are navigating and viewing the data)?
Dennis Cote
___
sqlite
3.6.2.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
it ignores any non numeric suffix.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
in building A, and a room 101 in
building B). In this case, you do *not* want to auto increment the
roomID values. Now you require the combination of the roomID and the
buildingID to identify a particular room.
HTH
Dennis Cote
___
sqlite-users mailing
,
:theBuilding);
Now you only need to specify the building and sqlite will calculate the
lowest unused room number in that building.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
opening the database, and report that the incomplete transaction will be
rolled back as the database is opened. I doubt if many applications do
this however.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi
on names.rowid = rnd.id
where rnd.RNDValue 0.99;
-- delete temp table
drop table rnd;
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Transaction0 0 000
17VerifyCookie 0 2 000
18TableLock 0 3 0 t 00
19Goto 0 3 000
sqlite
There is no reason to evaluate the length function twice.
Dennis Cote
the power failure?
I'm sorry I can't help you with recovering your database, except to
suggest going back to your last backup, and redoing the changes since then.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi
Alexey Pechnikov wrote:
Is it included to 3.6.1 or 3.6.2 version?
No, it is not included in either version. The patch was submitted by the
mozilla group, but it has not been checked in to SQLite.
You can of course apply the patch to your own customized version of SQLite.
HTH
Dennis Cote
level, more complex, algorithms in assembler often leads
to the use of simpler slower algorithms.
In short, writing in assembly language does not guarantee that the
resulting program will be fast. Assembler can be fast, but it is by no
means certain that it is fast.
Dennis Cote
the values.
See http://www.sqlite.org/datatype3.html for the column type affinity
deduction rules.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hardy, Andrew wrote:
Is there any way to log conversions to highlite any issues that would
have been hilighted by failure with strict typing?
Not that I am aware of.
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http
.
The trade off is that the compiler may become more complex and the
compilation step may take longer. There may still be a net benefit if
the compilation time is only a small percentage of the statement's
execution time (i.e complex long running queries on large tables).
Dennis Cote
is shown here
http://www.sqlite.org/lang_createvtab.html. The virtual table statement
does not allow the optional if not exists clause.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo
with a rowid somewhere between 0 and 999.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Brown, Daniel wrote:
Interesting, I just tried that in my test application and Dennis's and I
get access violations during the vacuum command execution when trying to
resize the pages from 1k to 4k with my database or Dennis's test
database.
Daniel,
I have found that sqlite works correctly
is stored securely encrypted in
the pages of the file.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
, and/or the logical
deduction from the premises to the conclusion is flawed.
Classic. :-)
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
with the 1K page size (17.4 MB) and the one with the 4K page
size (12.2 MB).
Where would you like me to send them? The zipped versions are each about
1.3 MB in size.
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org
) indexes or triggers, so there was nothing else to be copied.
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
.
It was introduced in 3.6.0 (see http://www.sqlite.org/changes.html), so
it was not present in 3.5.9.
HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
-rule based issues, such as out of
memory or I/O error that may cause an API function to fail. The mere
existence of such possibilities should not be grounds to avoid
documenting the errors that are returned when any of the many rule based
errors conditions occur.
Dennis Cote
.
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
provide a copy of the database file you are using? If so they
usually compress quite well using a zip utility.
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
.
Daniel, can you run a pragam page_size; query on youyr database and
let us know the results?
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
the 18102 KB of memory used after the table is built. The
actual memory used is exactly the same (as expected since it is storing
the same tables).
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman
requirement, but didn't change the memory required to hold the
database after the copy was completed.
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
1 - 100 of 1167 matches
Mail list logo