I know well the qt sqlite to say, maybe you aren't destroing the QSqlQuery
class or simple call finish function, and the statement is openned helding the
lock!
Enviado via iPhone
> Em 29/10/2013, às 10:51, Stephan Beal escreveu:
>
>> On Tue, Oct 29, 2013 at 1:52 PM, Martin wrote:
>>
>> The
ocess tries to
write the error happens,
but I can not sure about this...
I just saying you are not alone.
--
Israel Lins Albuquerque
Antes de imprimir, pense em sua responsabilidade com o MEIO AMBIENTE.
Em 18/07/2013, às 16:26, Loren Keagle escreveu:
>> Date: Wed, 17 Jul 2013 17:21:15 +0
begin of
read?
Thats it, thanks for patience.
Regards,
--
Israel Lins Albuquerque
Antes de imprimir, pense em sua responsabilidade com o MEIO AMBIENTE.
Em 26/06/2013, às 14:24, Israel Lins Albuquerque
escreveu:
> I open an database twice times in same process and same thread one in
&g
:
sqlite3BtreeOpen line 1788, because the shared cache uses the same structure in
booth connections, and pBt->pPager->readOnly is set to 1.
To workaround this I will open read write mode first, but that make readonly
connection become read write.
There is an know issue?
Regards,
--
Israe
As I can see my problem is solved on sqlite 4.
Em 08/03/2013, às 16:35, Israel Lins Albuquerque
escreveu:
> Thank you guys, and sort for my bad explanation about what I want. I
> understand that double problems very well,
> I will continue working with round.
>
> Regards
allmoney.
>
> -Original Message-
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin
> Sent: Friday, March 08, 2013 1:37 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Bug on real
I know that very well.
I don't know how postgresql handle this, may be I can check,
I just charring by problem to brainstorm if sqlite may do or not what
postgresql do.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-b
I know that.
I don't know how postgresql handle this, may be I can check,
I just charring by problem to brainstorm if sqlite may do or not what
postgresql do.
Em 08/03/2013, às 15:06, Israel Lins Albuquerque
escreveu:
> But I see this as a workaround, and not a solution.
> Is t
"%e\n",d);
> }
> On both MS Visual C and gcc on a Linux system:
> 0.00
> 3.55271e-015
> 3.552714e-015
>
> -----Original Message-
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Israel Lins
> Albuquerque
> Sen
printf("%e\n",d);
> }
> On both MS Visual C and gcc on a Linux system:
> 0.00
> 3.55271e-015
> 3.552714e-015
>
> -----Original Message-
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Israel Lins
> Albuquer
a bug on calculation of doubles.
Regards,
Israel Lins Albuquerque
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
m case to case but typically prior to indexing it
> is about 300MB and with indexes 600MB.
>
> Ill have a look at FTS as there are other benefits to using that.
> _______
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http:/
Due to attach limits this is the part 002 of the file!
- "Israel Lins Albuquerque" escreveu:
> Attached has a database corrupted.
> We use the version 3.6.23.1 in wince.
>
> the command:
> pragma integrity_check;
>
> show many errors and
>
Due to attach limits this is the part 001 of the file!
- "Israel Lins Albuquerque" escreveu:
> Attached has a database corrupted.
> We use the version 3.6.23.1 in wince.
>
> the command:
> pragma integrity_check;
>
> show many errors and
>
eone can
see that,
Thanks for your time!
--
Atenciosamente/Regards,
Israel Lins Albuquerque
Desenvolvimento/Development
Polibrás Brasil Software Ltda.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/li
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
--
Atenciosamente/Regards,
Israel Lins Albuquerque
Desenvolvimento/Development
Poli
Thanks, "Zaher Dirkey"!
Only,
PRAGMA journal_mode = TRUNCATE
solves my problem.
By some way the O.S. is locking the one off the journals and the program
can't delete it.
--
Atenciosamente/Regards,
Israel Lins Albuquerque
Desenvolvimento/Development
Polibrás Brasi
E.
> If you run x86 platform, could you share some idea with the WinCE developer?
>
> Thanks
> Lu
>
> On Fri, Sep 3, 2010 at 5:40 AM, Israel Lins Albuquerque <
> israel...@polibrasnet.com.br> wrote:
>
> > Guys I had a problem.
> >
> > We u
ELETE FROM ...;' and the error occur,
the program makes a lot of things, including stay with prepared statements
in memory, but no one are locking the file I wish
I appreciate some help.
Ps. I'm using the version 3.6.23.1 of sqlite library.
--
Atenciosamente/Regards,
> Thank you in advance,
> >
> > Dev
> >
> >
> >
> > --
> > D. Richard Hipp
> > d...@sqlite.org
> >
> >
> >
> >
> > ___
> > sqlite-users mailing list
>
to add
> 'ORDER BY _rowid_' to the end of those if the order matters.
>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
QLite function datetime.
>
> This way you could build a view and be able to see a normal date instead
> of ticks.
>
> Any idea?
> Roberto
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite
>read row;
>
>
> something like that.
>
>
>
>
> --
> Thanks & Regards
>
> Piyush Verma
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
Atenciosamente/R
If your table doesn't have a primary key, this look like your table aren't
normalized, maybe you can try broke this table in 2 tables like:
Your definition:
CREATE TABLE table1(id INTEGER, name VARCHAR, id2 INTEGER, name2 VARCHAR, year
INTEGER);
indexes : index1( name ), index2( id2 ), index
t;
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
Atenciosamente/Regards,
Israel Lins Albuquerque
Desenvolvimento/Development
Polibrás Bra
Hello,
I'm needing a corrupted database for test purpose, someone can help me?
I want an database with corruption on index like:
"rowid [%ld] missing from index %s" or "wrong # of entries in index %s"
--
Atenciosamente/Regards,
Israel Lins Albuquerque
De
+
|+ if( pExpr->iColumn>pParse->nVar ){
|+ pParse->nVar = pExpr->iColumn;
|+ }
| }else{
| /* Wildcards like ":aaa", "$aaa" or "@aaa". Reuse the same variable
| ** number as the prior appearance of the same name, or if the name
--
Atenciosament
Segunda-feira, 14 de Junho de 2010 15:41:01
Assunto: Re: [sqlite] Parametrized Queries issue (Possible bug)
On Mon, Jun 14, 2010 at 03:03:52PM -0300, Israel Lins Albuquerque scratched on
the wall:
> I know what you booth are are saying. But if this is a limitation of sqlite,
> this need
syntax.
David
--- On Mon, 6/14/10, Israel Lins Albuquerque
wrote:
> From: Israel Lins Albuquerque
> Subject: Re: [sqlite] Parametrized Queries issue (Possible bug)
> To: "General Discussion of SQLite Database"
> Date: Monday, June 14, 2010, 10:55 AM
> Once mo
sagem original -
De: "Jay A. Kreibich"
Para: "General Discussion of SQLite Database"
Enviadas: Segunda-feira, 14 de Junho de 2010 12:00:32
Assunto: Re: [sqlite] Parametrized Queries issue (Possible bug)
On Mon, Jun 14, 2010 at 11:51:07AM -0300, Israel Lins Albuquerque
Once more detail...
Doing this...
SELECT *
FROM a
WHERE a.a = :a
AND a.b = ?1;
and this...
SELECT *
FROM a
WHERE a.a = ?1
AND a.b = :b;
Will have different behavior!
- Mensagem original -
De: "Israel Lins Albuquerque"
Para: "sqlite-users"
Env
only one!
--
Atenciosamente/Regards,
Israel Lins Albuquerque
Desenvolvimento/Development
Polibrás Brasil Software Ltda.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
SQLITE_AFF_NONE because affinity of left expression "c2" (is a collumn) is
INTEGER and
rigth expression "'2'" is TEXT!
- Mensagem original -
De: "Israel Lins Albuquerque"
Para: "General Discussion of SQLite Database"
Enviadas: Quarta-
***/
--
Atenciosamente/Regards,
Israel Lins Albuquerque
Desenvolvimento/Development
Polibrás Brasil Software Ltda.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I asked that before because Oracle do this.
It notify the developer and ask if we want to create that transient index as
materialized.
I didn't see this working but I know this by a friend.
--
Atenciosamente/Regards,
Israel Lins Albuquerque
Desenvolvimento/Development
Polibrás B
t; new.payment
OR (payment = new.payment
AND id > new.id));;
END;
/***/
--
Regards/Atenciosamente,
Israel Lins Albuquerque
Developer/esenvolvimento
Polibrás Brasil Software Ltda.
__
OM account a
JOIN movement m ON (a.id = m.account_id)
GROUP BY m.account_id
HAVING payment = MAX(payment);
/*******/
- Mensagem original -
De: "Israel Lins Albuquerque"
Para: steph...@mankowski.fr, &qu
fact that I am using an undo/redo mechanism.
Regards,
Stephane
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Atenciosamente,
Israel Lins Albu
About that future release functionality. Will be possible to know whats
temporary index are created?
Using that information will be easy to know what indexes we need create to
increase perfomance,
don't giving chance to sqlite create that indexes!
--
Regards/Atenciosamente,
Israel
created?
Using that information will be easy to know what indexes we need create to
increase perfomance,
don't giving chance to sqlite create that indexes!
--
Regards/Atenciosamente,
Israel Lins Albuquerque
Developer/Desenvolvimento
Polibrás Brasil Software Ltda.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
eg. Apache +
mod_php.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Atenciosamente,
Israel Lins Albuquerque
Desenvolvimento
Polibrás Brasil Software Ltda.
___
ics; backing up assertions with evidence is science
===
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Atenciosamente,
Israel Lins Albuquer
to do this, and now vacuum will work. I'm sending attached the path
for this.
--
Atenciosamente/Regards,
Israel Lins Albuquerque
Desenvolvimento/Development
Polibrás Brasil Software Ltda.
___
sqlite-users mailing list
sqlite-users@sqlit
fo/sqlite-users
--
Regards ,
Israel Lins Albuquerque
Desenvolvimento
Polibrás Brasil Software Ltda.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I have to talk with someone to add this function on the sqlite? Or this will be
tested and added later?
--
Atenciosamente,
Israel Lins Albuquerque
Desenvolvimento
Polibrás Brasil Software Ltda.
___
sqlite-users mailing list
sqlite-users
,
+ FUNCTION(strpos, 2, 0, 0, strposFunc ),
+ FUNCTION(strpos, 3, 0, 0, strposFunc ),
FUNCTION(substr, 2, 0, 0, substrFunc ),
FUNCTION(substr, 3, 0, 0, substrFunc ),
FUNCTION(abs, 1, 0, 0, absFunc ),
/**/
--
Atenciosamente,
Israel Lins Albuquerque
Desenvolvimento
Polibrás Brasil Software Ltda.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
are you right the call to strpos("áéíóú", "í") are returning 5 and not 3
I'm looking for this...
--
Atenciosamente,
Israel Lins Albuquerque
Desenvolvimento
Polibrás Brasil Software Ltda.
___
sqlite-users mailing lis
Re: [sqlite] Why we don't have strpos function?
On Wed, Mar 17, 2010 at 01:15:35PM -0300, Israel Lins Albuquerque scratched on
the wall:
> There are the patch:
Which seems to assume one character equals one byte.
-j
--
Jay A. Kreibich < J A Y @ K R E I B I.C H >
"Our op
rFunc ),
FUNCTION(substr, 3, 0, 0, substrFunc ),
FUNCTION(abs, 1, 0, 0, absFunc ),
/***/
- Mensagem original -
De: "Israel Lins Albuquerque"
Para: "General Discussion of SQLite Database"
Enviadas: Qua
I forgot attach...
This are based in the current release 3.6.23.
--
Atenciosamente,
Israel Lins Albuquerque
Desenvolvimento
Polibrás Brasil Software Ltda.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin
icode strings, I think.
It's hard to work out the position in a string if you don't know what encoding
you're using.
Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlit
...
--
Atenciosamente,
Israel Lins Albuquerque
Desenvolvimento
Polibrás Brasil Software Ltda.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
My apologies everybody. I'm wrong.
forget what I said.
--
Atenciosamente,
Israel Lins Albuquerque
Desenvolvimento
Polibrás Brasil Software Ltda.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/ma
rrent
version" is what it used to look like. See
http://www.sqlite.org/src/ci/eb98265b59
for a diff of the change. This was a bug fix.
The code in question only comes into play when you compile with
SQLITE_OMIT_DATETIME_FUNCS and so it doesn't matter for most people.
We didn
rrent
version" is what it used to look like. See
http://www.sqlite.org/src/ci/eb98265b59
for a diff of the change. This was a bug fix.
The code in question only comes into play when you compile with
SQLITE_OMIT_DATETIME_FUNCS and so it doesn't matter for most people.
We didn
mp, 0, "%Y-%m-%d", 0, currentTimeFunc),
STR_FUNCTION(current_date, 0, "%Y-%m-%d %H:%M:%S", 0, currentTimeFunc),
I fink this is a problem because:
SELECT CURRENT_DATE will return 2010-03-10 09:34:55
SELECT CURRENT_TIMESTAMP will return 2010-03-10
Are this correct?
Regard
user per his typical database session?
Regards,
Samuel
- Original Message
From: Jay A. Kreibich
On Fri, Feb 19, 2010 at 09:39:08AM -0300, Israel Lins Albuquerque scratched on
the wall:
> Samuel,
>
> Each one attached database has its own page cache with 2000
>
hat you know at http://ca.answers.yahoo.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Israel Lins Albuquerque
Desenvolvimento
Polibrás
Thank you, that's work for me.
--
Israel Lins Albuquerque
Desenvolvimento
Polibrás Brasil Software Ltda.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
s for atention.
--
Israel Lins Albuquerque
Desenvolvimento
Polibrás Brasil Software Ltda.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ked a patch for this, see file attached.
--
Israel Lins Albuquerque
Desenvolvimento
Polibrás Brasil Software Ltda.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
De: "Israel Lins Albuquerque"
Para: "sqlite-users-bounces"
Enviadas: Quarta-feira, 20 de Janeiro de 2010 16:48:52 (GMT-0200) Auto-Detected
Assunto: Crash Calling sqlite3_vfs_unregister
if I call sqlite3_vfs_unregister without initialize the sqlite I have a crash.
62 matches
Mail list logo