On 10/6/15, jonathan wrote:
>> Hello my friends, i need your help, i have problems with the use special
>> character for example "?" , work with vb net. The problem consist when
>> save
>> this character in the data base sqlite, this chance in another character.
>> I
>> hope your help. Thank you.
> Hello my friends, i need your help, i have problems with the use special
> character for example "?" , work with vb net. The problem consist when save
> this character in the data base sqlite, this chance in another character. I
> hope your help. Thank you.
Bach. Jonathan Mej?a Acosta
-boun...@sqlite.org] on
behalf of Singh, Manpreet [manpreet.sing...@ca.com]
Sent: Tuesday, June 21, 2011 2:55 AM
To: sqlite-...@sqlite.org; sqlite-users@sqlite.org
Subject: EXT :Re: [sqlite] Help sqlite database corruption
Anyone with clues to the problem "malformed disk image"?
Anyone with clues to the problem "malformed disk image"?
From: Singh, Manpreet
Sent: Tuesday, May 24, 2011 3:10 PM
To: sqlite-...@sqlite.org; d...@hwaci.com; sqlite-users@sqlite.org
Cc: Singh, Abhijeet; Singh, Satbeer; Prasanth, Neelapalem
Subject: RE: Help sqlite database corruption
Hello
Changing the driver helped in improving the performance drastically.
Sridhar
On 03-06-2011 20:05, Sridhar Polavarapu wrote:
> This is not any update or insert statement. This is just a select
> statement. Will that help if i change the driver ? I am currently
> using sqlitejdbc-v056.jar
>
> Tha
This is not any update or insert statement. This is just a select
statement. Will that help if i change the driver ? I am currently using
sqlitejdbc-v056.jar
Thanks
Sridhar
On 03-06-2011 18:59, Sridhar Polavarapu wrote:
> Hi
>
> One of my sqlite query executes faster in sqlite manager( firefox
On Tue, May 24, 2011 at 5:39 AM, Singh, Manpreet wrote:
> Hello,
>
>
>
> Resending with some more finding any help would be appreciated. One of
> the tables in the database is getting corrupted.
>
http://www.sqlite.org/howtocorrupt.html
http://www.sqlite.org/lockingv3.html#how_to_corrupt
http://w
Hello,
Resending with some more finding any help would be appreciated. One of
the tables in the database is getting corrupted.
1. Sqlite>select count(*) from $table_name
..
7981508|35001|284
7981509|35002|284
7981510|35003|284
7981511|35004|284
SQL error: database disk image is malfo
On 17 Jun 2010, at 4:47pm, backup wrote:
> sprintf(sqlstr,"update db set isSent=1 where ID in (select ID from
> db where isSent=0 limit %d);",RECORD_NUM);
Can you post the commands used to create the table and any indexes on it ?
Simon.
___
sqlite-u
hi, everyone,
I program in an embaded system: ARM9 soc S3C2410 +Linux 2.4+sqlite
3.3.
All data store in NAND FLASH , the file system is YAFFS .
My question is the function "sqlite3_exec(.)" take too many
seconds,
the following is my source code, please see the "printf" 's commen
Thanks a lot Donald, These links really helps me a lot...
On 1/27/09, Griggs, Donald wrote:
>
>
>
> On 1/27/09, Griggs, Donald wrote:
> >
> > Venkat,
> >
> > If you have a ".db" file it almost certainly *is* an sqlite database.
> > A great attribute of sqlite databases is that they are contained
Venkat,
Sorry. I really intended to quote page:
http://www.sqlite.org/sqlite.html
Though
http://www.sqlite.org/quickstart.html
May be helpful as well.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailm
On 1/27/09, Griggs, Donald wrote:
>
> Venkat,
>
> If you have a ".db" file it almost certainly *is* an sqlite database.
> A great attribute of sqlite databases is that they are contained in a
> single file.
>
> If you're looking for a GUI frontend, they are legion, including good
> free ones s
>
>
> -Original Message-
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of venkat karri
> Sent: Tuesday, January 27, 2009 3:25 PM
> To: punk...@eidesis.org; General Discussion of SQLite Database
> Subject: Re: [sqlite] hel
is.org; General Discussion of SQLite Database
Subject: Re: [sqlite] help : sqlite database restore
This morning I had a meeting with the team and found that we also have a
db file, could you please send me the complete syntax to import or
restore this .db
This morning I had a meeting with the team and found that we also have a db
file, could you please send me the complete syntax to import or restore this
.db file in sqlite.
On 1/27/09, P Kishor wrote:
>
> On 1/27/09, venkat karri wrote:
> > Yes it has create queries and insert statements
>
>
On 1/27/09, venkat karri wrote:
> Yes it has create queries and insert statements
in which case, it is a SQL dump. Read up the help on the .read command
or the .import command in the command line sqlite3 program.
>
>
> On 1/27/09, Simon wrote:
> >
> > You may want to open the file in a
Yes it has create queries and insert statements
On 1/27/09, Simon wrote:
>
> You may want to open the file in a basic text editor to see if it's a
> SQL dump. The dump will usually have the queries to create the tables
> and insert data into them.
>
> Simon
>
> On Tue, Jan 27, 2009 at 11:57
You may want to open the file in a basic text editor to see if it's a
SQL dump. The dump will usually have the queries to create the tables
and insert data into them.
Simon
On Tue, Jan 27, 2009 at 11:57 AM, venkat karri wrote:
> Hi Kishor,
>
> Actually iam working on defect tracking migration f
Hi Kishor,
Actually iam working on defect tracking migration from trac to
qualitycenter, the trac developers have given me this .bak file, the person
who has taken this bak file is no longer with the company, so they asked me
to restore the .bak file and see the data, I dont know how its been crea
On 1/27/09, venkat karri wrote:
> Hi
>
> Iam new to sqlite, I have a database backup copy with extension
> trac.db.1.bak. Now iam trying to setup sqlite 3.6.10 on my local machine and
> need to import this bak file to my local database and has to view the data
> in the table.
>
> can any one
Hi
Iam new to sqlite, I have a database backup copy with extension
trac.db.1.bak. Now iam trying to setup sqlite 3.6.10 on my local machine and
need to import this bak file to my local database and has to view the data
in the table.
can any one help me how to restore the database into my local ma
[EMAIL PROTECTED] wrote:
> The attachment size limitation of the bug report is 100k :(
I'm sorry about the late follow up, but I have been away for a while.
Can you contact me off list to see about transferring the compressed
database so I can use it to look into the problem?
Dennis Cote
__
The attachment size limitation of the bug report is 100k :(
- Original Message -
From: "Dennis Cote" <[EMAIL PROTECTED]>
To: "General Discussion of SQLite Database"
Sent: Thursday, May 15, 2008 9:49 PM
Subject: Re: [sqlite] Help!!! sqlite 3.5.8 crash: a
[EMAIL PROTECTED] wrote:
>
> My DB file is too big, how can I provide it to your guys?
You said a compressed copy of the database file is 18M.
One possibility is to create a bug report ticket at
http://www.sqlite.org/cvstrac/captcha?nxp=/cvstrac/tktnew and attach the
compressed database file t
[EMAIL PROTECTED] wrote:
>
> Maybe the database has been damaged.
Possibly.
>
> The shcema of table "CarImages" is :
> CREATE TABLE CarImages(
> CarID char(32) NOT NULL,
> CarNumber char(20) NULL,
> OpTime datetime NOT NULL ,
> TSCode char(6) NOT NULL,
> LaneNum int NOT NULL,
> PicBigPlat
Discussion of SQLite Database"
Sent: Wednesday, May 14, 2008 10:17 PM
Subject: Re: [sqlite] Help!!! sqlite 3.5.8 crash: access violation
> Hello qinligeng,
>
> Wednesday, May 14, 2008, 12:58:32 AM, you wrote:
>
> q1c> When I execute sql statement "delete from Carim
Long null,
PicLane Long null,
Constraint CarImages_Key Primary Key (CarID)
);
- Original Message -
From: "Dennis Cote" <[EMAIL PROTECTED]>
To: "General Discussion of SQLite Database"
Sent: Wednesday, May 14, 2008 9:50 PM
Subject: Re: [sqlite] Help!!! sqlite 3.5.
Hello qinligeng,
Wednesday, May 14, 2008, 12:58:32 AM, you wrote:
q1c> When I execute sql statement "delete from Carimages where OpTime
q1c> <'2008-05-01 00:00:00'" in my database, sqlite3 crashed.
q1c> The Exception Information reported by XP is:
q1c> Code: 0xc005 Flags:0x
[EMAIL PROTECTED] wrote:
> When I execute sql statement "delete from Carimages where OpTime <'2008-05-01
> 00:00:00'" in my database, sqlite3 crashed.
> The Exception Information reported by XP is:
> Code: 0xc005 Flags:0x
> Record: 0x Address: 0x0
When I execute sql statement "delete from Carimages where OpTime <'2008-05-01
00:00:00'" in my database, sqlite3 crashed.
The Exception Information reported by XP is:
Code: 0xc005 Flags:0x
Record: 0x Address: 0x00406652
The sqlite3.exe is
31 matches
Mail list logo
