Hello Dan,
To answer your question, the 2nd ftruncate() is not zeroing the 1st mmapped
region. I had checked it using debugger, and it happens only during
2nd mmap call.
But from my investigation, i found that the 2nd ftruncate()(and further calls)
is the one from where the problem is arising.
Hi,
Thanks for the reply's i have tried the various ways described that they do
not seem to be working. I have a way in which it works but this is in SQL
could anyone convert it to SQLite for me? i am not to sure it is even
possible. I have also attached the DB just encase anyone can do it for
On 19 Oct 2010, at 1:07pm, Dickie.wild wrote:
Thanks for the reply's i have tried the various ways described that they do
not seem to be working. I have a way in which it works but this is in SQL
could anyone convert it to SQLite for me? i am not to sure it is even
possible. I have also
Actually marbex came up with the best solutionwould work with ANY allowable
path characters.
UPDATE video_files SET strCover TO (rtrim(strPath,replace(strPath,'\','')) ||
'folder.jpg')
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Northrop Grumman Information Systems
Hi,
I thought that looked like it would get the same results, but i seem to be
getting the following error, are you able to try it and let me know if your
getting the same error?
SQLiteManager: Likely SQL syntax error: UPDATE video_files SET strCover TO
(rtrim(strPath,replace(strPath,'\',''))
Sorry...I didn't test before I submitted...
sqlite create table video_files(strPath varchar,strCover varchar);
sqlite insert into video_files values('c:\dir1\dir2\file.txt','');
sqlite update video_files set strCover=(rtrim(strPath,replace(strPath,'\',''))
|| 'folder.jpg');
sqlite select * from
Dickie.wild dickie.w...@yahoo.com wrote:
I thought that looked like it would get the same results, but i seem to be
getting the following error, are you able to try it and let me know if your
getting the same error?
SQLiteManager: Likely SQL syntax error: UPDATE video_files SET strCover TO
Hi,
Well i have to say i am like a kid in a sweet shop right now, you all may
have just saved me 6 or so hours work. Thanks again for your input.
I was wondering if anyone had any issues with me posting this up on the
Boxee forum as there lots of people with this issue? I will of course tell
Just as a follow up, there was a bug in the developers code, and he's
corrected the problem. He forgot to carry a month. {smirk}
On Mon, Oct 18, 2010 at 6:30 AM, Stephen Chrzanowski pontia...@gmail.comwrote:
Interesting. I get the same results as you when I use sqlite3.exe, but, in
a
Spread the word...that's what these lists are for...
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Northrop Grumman Information Systems
From: sqlite-users-boun...@sqlite.org on behalf of Dickie.wild
Sent: Tue 10/19/2010 8:03 AM
To:
On Mon, Oct 18, 2010 at 8:19 AM, ivoryjoh...@gmail.com wrote:
I made an error in my SQL when I did not include one of my non-aggregate
columns in my group. I was surprised that Sqlite did not catch this, and
even more surprised when the docs spelled out this behavior.
Is everyone ok with
2. I suggest that you're better off doing the logic entirely in SQL, rather
than application code, for the sake of portability, data integrity and speed.
I'd say this is a very bad advice for the developer using SQLite.
First of all insert or ignore and insert or replace are not
portable SQL
On Tue, Oct 19, 2010 at 09:39:44AM -0400, Richard Hipp scratched on the wall:
I was going to change this at one point, so that it raised an error, but
that suggestion raised such an outcry that I decided to leave it.
Apparently, there are many applications out there that depend on this
On Mon, Oct 18, 2010 at 9:18 AM, Peter pe...@somborneshetlands.co.ukwrote:
I have a query which takes 17 minutes to run with 3.7.3 against 800ms
with 3.7.2
Thank you for the report.
Can you please send your complete schema. The query is useful in
combination with the schema but is pretty
I have a table containing width and height of images with columns wPixels,
hPixels. I would like to select all rows that have either a unique wPixels or
a
unique hPixels value.
for this data:
10, 20
10, 20
10, 30
10, 3015, 10
15, 30
15, 30
15, 30
I would like to select:
10, 20
10, 30
15, 10
On 19 October 2010 16:26, jeff archer jarch...@yahoo.com wrote:
I have a table containing width and height of images with columns wPixels,
hPixels. I would like to select all rows that have either a unique wPixels
or a
unique hPixels value.
for this data:
10, 20
10, 20
10, 30
10, 3015,
On 20/10/2010, at 1:23 AM, Pavel Ivanov wrote:
2. I suggest that you're better off doing the logic entirely in SQL, rather
than application code, for the sake of portability, data integrity and speed.
I'd say this is a very bad advice for the developer using SQLite.
Thanks for your input.
On Thu, Oct 14, 2010 at 2:41 PM, Afriza N. Arief afriza@gmail.comwrote:
... sometimes my WinCE application has a problem where the changes made in
one instance a of sqlite3 database not reflected in the other instance b of
the same database file even though they exist in the same process.
Hi,
I am using sqlite DB and am creating my DB in USB drive(this is my
application requirement), My problem is that. when am creating my DB as a
admin in 1 system and taking the same USB in 2nd system who is having
limited rights, then 2nd system user is getting Read only Database
exception,
19 matches
Mail list logo
