SELECT AES_ENCRYPT(password, 'abcddsfddafdasfddasd');
is work!
I think I need to find out what is the data type and data lengh for storing the
encrypt password
Thanks,
JP
From: Simon Slavin slav...@bigfraud.org
To: Joanne Pham joannekp...@yahoo.com; General
Hi all,
Curently I had the table with the plain text and I want to encrypt these
passwords by using the following sql statement but I got the error mesages. Any
suggestion?
update vpn set password = AES_ENCRYPT(select password from mytable,
abcddsfddafdasfddasd).
Thanks in advance,
JP
From: Igor Tandetnik itandet...@mvps.org
To: sqlite-users@sqlite.org
Sent: Wednesday, October 19, 2011 3:58 PM
Subject: Re: [sqlite] sql statement to update the data in the table
On 10/19/2011 6:34 PM, Joanne Pham wrote:
Curently I had the table with the plain text and I want to encrypt
To: sqlite-users@sqlite.org
Sent: Wednesday, October 19, 2011 5:35 PM
Subject: Re: [sqlite] sql statement to update the data in the table
On 10/19/2011 7:23 PM, Joanne Pham wrote:
update vpn set password = AES_ENCRYPT((select password from vpn) ,
abcddsfddafdasfddasd).
I suspect you want
Hi All,
I have the database which has a lot of insertion and deletion. Do you have any
recomendation about what value that need to be set for auto_vacuum
in this case to improve the performance for deletion as well as insertion the
new row to the database. (0 | NONE | 1 | FULL | 2 |
On 21 Jul 2009, at 11:12pm, Joanne Pham wrote:
CREATE TABLE myTable(
startTime INTEGER ...
appId INTEGER
myId INTEGER ...
trafficType INTEGER
..
)
StartTime can be from 1...59
appId can be from 1...256
myId can be from 1...5000
trafficType can be from 1..3
I would like
Hi All,
I need to create the indexes on the tables and these indexes have 4 columns.
Let say the table definition as below:
CREATE TABLE myTable(
startTime INTEGER ...
appId INTEGER
myId INTEGER ...
trafficType INTEGER
..
)
StartTime can be from 1...59
appId can be from
problem?
Any idea!
Thanks,
JP
From: Joanne Pham joannekp...@yahoo.com
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent: Tuesday, June 16, 2009 3:41:17 PM
Subject: Re: [sqlite] NULL data .dump command
Hi All,
I ran two queries:
1) select
Hi All,
I have the table is defined as below:
CREATE TABLE `signature` (
`sig` char(50) NOT NULL,
`id' bigint(20) default '0',
But I have ran the folowing command:
.output mySelect
select * from signature;
then I didn't see NULL values in the mySelect file at all
But I ran
|345049073990|1276|368|230383|1857|1245183730|2|0
SQL error: database disk image is malformed
Is the index corruped some where?
Your help is greatly appreciated.
Thanks,
JP
From: Joanne Pham joannekp...@yahoo.com
To: General Discussion of SQLite
Hi All,
What was the problem with the SQLite library is builded with
DSQLITE_THREADSAFE=1 but the application is using multiple threads with the
same connection.
Thanks,
JP
___
sqlite-users mailing list
sqlite-users@sqlite.org
-users@sqlite.org
Sent: Tuesday, June 9, 2009 12:52:47 PM
Subject: Re: [sqlite] Compite with DSQLITE_THREADSAFE=1 but application has
mulitple threads using the same connection
On Tue, 9 Jun 2009 12:06:44 -0700 (PDT), Joanne Pham
joannekp...@yahoo.com wrote:
Hi All,
What was the problem
Hi All,
I would like to build the SQLite 3.6.14 to following the steps as mentioned in
the document
tar xzf sqlite.tar.gz ;# Unpack the source tree into sqlite
mkdir bld ;# Build will occur in a sibling directory
cd bld ;# Change to the build directory
../sqlite/configure ;# Run
can do during configuration:
../sqlite/configure -DSQLITE_THREADSAFE=2
Pavel
On Wed, Jun 3, 2009 at 2:27 PM, Joanne Pham joannekp...@yahoo.com wrote:
Hi All,
I would like to build the SQLite 3.6.14 to following the steps as mentioned
in the document
tar xzf sqlite.tar.gz ;# Unpack
Hi All,
We are currently using SQLite 3.59 for our product and We will have the release
in middle of June.
We have been facing a lot of problem regarding performance and next release we
can to able to scale up to 4 times faster than previous release.
Do you think that upgrade the SQLite to
we upgrade the SQLite to 6.6.14.2 from 3.59
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Joanne Pham wrote:
Do you think that upgrade the SQLite to newer version 3.6.14.2 from 3.5.9
will be help to improve the SQLite database operation like Read/Write?
What results did you see when you tried
Hi all,
I would like to update the database and there are two ways to do it and I were
wondering which way is better:
1) Way 1 - used the sqlite3_preare, sqlite3_bind , sqlite3_step ...
q = UPDATE logTable SET stale = ? WHERE id = ?;
rc = sqlite3_prepare(updateSqli q, -1, pstmt, 0);
Thanks Igor,
So you prefer #1 instead of #2.
Thanks,
JP
From: Igor Tandetnik itandet...@mvps.org
To: sqlite-users@sqlite.org
Sent: Thursday, May 14, 2009 11:13:23 AM
Subject: Re: [sqlite] Should use prepare/bind or just sqlite_exec.
Joanne Pham joannekp
Hi All,
I have read one of the performance document and it stated that prepared
statements must be generated inside transaction. Is that correct.
The document also stated that While trying to improve the performance of bulk
imports in our C++ project, we found that creating the prepared
before each transaction.
Pavel
On Tue, May 12, 2009 at 12:32 PM, Joanne Pham joannekp...@yahoo.com wrote:
Hi All,
I have read one of the performance document and it stated that prepared
statements must be generated inside transaction. Is that correct.
The document also stated that While
Hi all,
I have the application and occasionally it is crashed on sqlite3_free when it
callled sqlite3_finalized and I really didn't know what problem it was.
Below is stack trace.
Do you have any idea what is caused this problem.? Any hints will be greatly
appreciated.
#0 0xb5d90c31 in
of
transaction and then use them across different transactions without
any problems but with huge performance improvement compared to when
I've prepared statements before each transaction.
Pavel
On Tue, May 12, 2009 at 12:32 PM, Joanne Pham joannekp...@yahoo.com wrote:
Hi All,
I have read
Hi All,
I had the database and one of the index is not good condition. Every time I use
the index by select ... group by .. the result only return few rows and the
message print out that database disk image is malformed. Is there any
command to check if the index or database in good condition.
to check the healthy of database and the indexes of
the tables
On Tue, 5 May 2009 13:02:13 -0700 (PDT), Joanne Pham
joannekp...@yahoo.com wrote:
Hi All,
I had the database and one of the index is
not good condition. Every time I use the
index by select ... group by .. the result
only return few rows
]
On Behalf Of Joanne Pham
Sent: Tuesday, May 05, 2009 4:02 PM
To: General Discussion of SQLite Database
Subject: [sqlite] How to check the healthy of database and the indexes ofthe
tables
Hi All,
I had the database and one of the index is not good condition. Every time I use
the index by select ... group
Hi All,
I ran the following sql statement:
select blobid, fbid from sig group by peerid;
return about 10 rows
22
...
33
return about 10 rows and I got the error message:
SQL error: database disk image is malformed
but when I ran the following
Database sqlite-users@sqlite.org
Sent: Monday, May 4, 2009 4:26:58 PM
Subject: Re: [sqlite] SQL error: database disk image is malformed
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Joanne Pham
Sent: Monday, May 04, 2009 2:51 PM
Hi All,
Is sqlite3_finalize(sqlite3_stmt) cleaning up the memory which is allocated by
sqlite_prepare()?
I checked the database statement handle before calling sqlite3_finalize and
after calling this sqlite3_finalize the address is the same.
I was wordering if the memory of database statement
Thanks a lot Igor for respond my email.
JP
From: Igor Tandetnik itandet...@mvps.org
To: sqlite-users@sqlite.org
Sent: Sunday, May 3, 2009 7:05:52 PM
Subject: Re: [sqlite] sqlite3_finalize(sqlite3_stmt) is this call clean up
thememory
Joanne Pham joannekp
Hi All,
I read the SQLite document about the sqlite3_step() as below:
The details of the behavior of the sqlite3_step() interface depend on
whether the statement was prepared using the newer v2 interface
sqlite3_prepare_v2() and sqlite3_prepare16_v2() or the older legacy interface
Hi All,
I have read the sqlite document and document stated that:
The SQL command COMMIT does not actually commit the changes to disk. It
just turns autocommit back on.
The question is the default of database open connection is autocommit and if
my function has :
: Wednesday, April 29, 2009 7:48:41 PM
Subject: Re: [sqlite] Transaction control At the SQL Level
Joanne Pham joannekp...@yahoo.com
wrote in message news:464293.67815...@web90308.mail.mud.yahoo.com
1) : If I have mulitple commands which are used the same SQL database
connection then all commands after
At the SQL Level
Joanne Pham joannekp...@yahoo.com wrote:
Just want to make sure that I am fully understand about the single
database connection with multiple database statement handle here.
For example I have one database connection and 2 database statement
handle using the same connection
Hi All,
I have the application and it is crashed on at ../src/vdbeapi.c:538
(sqlite3_mutex_enter(db-mutex); by sqlite3_step.
I couldn't nail down what was the root cause of this problem. Why it crashed on
sqlite3_mutex_enter API.
Would you please shed some light on this?
Thank in advance,
JP
Hi All,
I read the document about File Locking And Concurrency IN SQLite Version 3
about the Transaction Control At The SQL Level as below:
If multiple commands are being executed against the same SQLite database
connection at the same time, the autocommit is deferred until the very last
Hi All,
I was wondering if we need to have the order of columns in the where clause
need to be matched with the order of the indexes.
Does the index will be used if the columns in the where clause didn't match
with the columns in the defined index?
Thanks,
JP
Hi All,
Can we have the trigger to delete to data from different database?
My application has 2 databases and when ever the application is deleting the
rows in one of tables in DB1 I would like to have a trigger to delete the rows
in table in DB2.
Is this possible?
Thanks,
JP
Hi All,
I am current used the SQLite 3.5.9 and SQLite library are compiled by someone
and I would like to check all what are the compiler options being used?
How to check the compiler options in this case?
Thanks,
JP
___
sqlite-users
Hi All,
It didn't work - I am using version 3.5.9 and my application is used the
library libsqlite3.so.8.6 but I have no ideas what are the compiler option
being used.
Any help please.
Thanks,
JP
From: Roger Binns rog...@rogerbinns.com
To: General Discussion
Hi All,
My application is crashed with the stack trace as below:
#0 pager_end_transaction (pPager=0x4031fdb8, hasMaster=0)
at ../src/pager.c:1420
1420 ../src/pager.c: No such file or directory.
in ../src/pager.c
(gdb) where
Hi All,
I have the table which has the following indexes:
CREATE INDEX Zactivate ON sig (peerid,flowid,fbid);
CREATE INDEX Zfbid ON sig (flowid,fbid);
CREATE INDEX Zsignature ON sig (peerid,Zsignature);
And below are where statements:
WHERE Zsignature = ? AND peerid = ?;
WHERE peerid = ?
WHERE
Hi All,
I am currently using sqlite 3.5.9 and I have set the cache_size as below:
sqlSt = sqlite3_exec(pDb, PRAGMA cache_size = 2000 , NULL, 0, errMsg);
It it the right size for the cache_size? My applications have a lot of writes
operations and can be up to millions rows per minutes.
Thanks,
version 3.5.9
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Joanne Pham wrote:
It it the right size for the cache_size? My applications have a lot of writes
operations and can be up to millions rows per minutes.
What results did you get when you did your testing with different sizes?
Roger
, 2009 at 7:13 PM, Joanne Pham joannekp...@yahoo.com wrote:
I haven't test with different sizes at all?
In other words, what Roger is gently trying to tell you is to test
yourself before asking. You are the best judge of your conditions,
your machines, your application. Testing is the surest way
To: sqlite-users@sqlite.org
Sent: Wednesday, April 15, 2009 9:17:09 PM
Subject: Re: [sqlite] Need help with the SQL statement.
Joanne Pham joannekp...@yahoo.com
wrote in message news:872428.4795...@web90308.mail.mud.yahoo.com
But the first row (20657220 1 2 101 -- this is 2009-04-11 00:00:00)
may
Thanks a ton Igor!
It worked. Your help is greatly appreciated.
Thanks,
JP
From: Igor Tandetnik itandet...@mvps.org
To: sqlite-users@sqlite.org
Sent: Thursday, April 16, 2009 4:52:28 AM
Subject: Re: [sqlite] Need help with the SQL statement.
Joanne Pham
Hi All,
I have the following table(dailyDataTable) as defined below
startTime INTEGER : number of minutes in GMT time
appId INTEGER : application Id
remoteId INTEGER : server id
proxyCount INTEGER
This table can have up to 24 hours as below: (this table
To: sqlite-users@sqlite.org
Sent: Wednesday, April 15, 2009 7:44:48 PM
Subject: Re: [sqlite] Need help with the SQL statement.
Joanne Pham joannekp...@yahoo.com
wrote in message news:594788.4966...@web90305.mail.mud.yahoo.com
Hi All,
I have the following table(dailyDataTable) as defined below
startTime
Joanne Pham joannekp...@yahoo.com wrote:
I have read this document and it stated that if a database connectin
in read-uncommitted mode does not attempt to obtain reaad-locks
before reading from database tables.
So in this case if the connection in read-uncommited modes then it
allows
From: Igor Tandetnik itandet...@mvps.org
To: sqlite-users@sqlite.org
Sent: Tuesday, April 14, 2009 1:29:08 PM
Subject: Re: [sqlite] PRAGMA read_uncommitted = 1
Joanne Pham joannekp...@yahoo.com wrote:
I have another question : how to enabled shared-cache mode for the
connection? Thanks,
http
Hi All,
I have set my database connection to PRAGMA read_uncommitted = 1.Is this
allow the dirty read?
Thanks,
JP
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Thank a lot Jay
From: Jay A. Kreibich j...@kreibi.ch
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent: Wednesday, April 8, 2009 1:22:57 PM
Subject: Re: [sqlite] what is the default for the commit when the connection is
opened.
On Wed,
Hi All,
I have seen the define for SQLITE_LOCKED as below
#define SQLITE_LOCKED 6 /* A table in the database is locked */
I thought the SQLITE is database locking so I was wondering when the table in
the database is locked?
Thanks,
JP
Hi all,
I had the application using sqlite and executing the following sql statement:
executeStmt: Error in executing the statment database TCPADDB is already in
use. Error St = 1 , stmt = ATTACH DATABASE
\'/opt/phoenix/monitor/TCPFlowCurDayDB\' as TCPADDB; insert into tcpFlowTable
select
Hi All,
When we use the sqlite3_open_v2 to open the database is this defautl to Auto
commit ?
Thanks,
JP
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
: Monday, April 6, 2009 8:10:58 PM
Subject: Re: [sqlite] Database handle(sqlite3_stmt)
Joanne Pham joannekp...@yahoo.com
wrote in message news:677762.12434...@web90302.mail.mud.yahoo.com
Can we use one statement handle for both insert and select?
Of course not. When you call sqlite3_prepare, you
Hi all,
I have the application is used sqlite 3.5.9 and the program is crashed with the
following strack trace:
#0 0x46b35300 in pthread_mutex_lock () from /lib/libpthread.so.0
#1 0xb6def162 in sqlite3_mutex_enter (p=0x9aca00b6) at ../src/mutex_unix.c:192
#2 0xb6e1ab96 in sqlite3_exec
Hi All,
Is sqlite allowing to use the same datbase handle(sqlite3_stmt) for both read
and insert operation.
Basislly onehandle(sqlite3_stmt) is inside the transaction which hasn't
commited yet and the same handle is used for the read of the same database. Is
this ok to use one handle for both
:02:32 PM
Subject: Re: [sqlite] Database handle(sqlite3_stmt)
Joanne Pham joannekp...@yahoo.com wrote:
Is sqlite allowing to use the same datbase handle(sqlite3_stmt) for
both read and insert operation.
Are you talking about database handle (sqlite3*) or statement handle
(sqlite3_stmt*)? Your
Thanks Eric.
Joanne
From: Eric Minbiole eminbi...@mavroimaging.com
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent: Wednesday, April 1, 2009 12:02:18 PM
Subject: Re: [sqlite] select the first 2 rows
Hi all,
I have a big table and I
Hi All,
We have a application using SQLite 3.5.9 now and we will be releasing this
product in June.
I am think about upgrading SQLite from 3.5.9 to SQLite 3.6.11 but I don't know
what are the impact for the application and is it worth to upgrade SQLite to
newest one before the product is
Hi All,
I have the folowing table which has the following data for example:
remoteId hostName lastUpdateTime
1 host1 19
2 host111
3host2 22
]
On Behalf Of Joanne Pham
Sent: Sunday, March 08, 2009 9:45 PM
To: General Discussion of SQLite Database
Subject: [sqlite] select statement - Need help
Hi All,
I have the folowing table which has the following data for example:
remoteId hostName lastUpdateTime
1
= max_utime
and cnt 1 ;
t.hostName should be table.hostName
Thanks a lot Adler for the help.
JP
From: Joanne Pham joannekp...@yahoo.com
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent: Sunday, March 8, 2009 1:44:01 PM
Hi All,
I have the select statement as below
sqlite select remoteId, hostName , remoteWXType from remoteWXTable order by
hostName;
and the output is below:
1|HostName1-T432|2
2|HostName2-T421|2
3|HostName3-XP|2
4|HostName3-XP|2
But I would like the sql statement to return as below:
(HostName3
From: Joanne Pham joannekp...@yahoo.com
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent: Tuesday, February 17, 2009 10:14:54 PM
Subject: [sqlite] (no subject)
Hi All,
I have the select statement as below
sqlite select remoteId
Subject: Re: [sqlite] sql statement to concatinate two rows.
On Tue, Feb 17, 2009 at 11:16 PM, Joanne Pham joannekp...@yahoo.com wrote:
Hi All,
I have the select statement as below
sqlite select remoteId, hostName , remoteWXType from remoteWXTable order by
hostName;
and the output is below
From: Dan danielk1...@gmail.com
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent: Thursday, February 12, 2009 9:03:12 PM
Subject: Re: [sqlite] sqlite3_finalize (pStmt=0x28) at ../src/vdbeapi.c:204
On Feb 13, 2009, at 11:49 AM, Joanne Pham
:204
On Feb 13, 2009, at 11:24 PM, Joanne Pham wrote:
Thanks for the respond!
So how can we find out the pStmt is valid or not. I did check to see
if it is not NULL before passing this sqlite3_finalize (pStmt=0x28).
To find out the valid handle is touch because the problem couldn't
Hi All,
sqlite3_reset() function is called to reset a prepared statement object back
to its initial state, ready to be re-executed. So if the sqlite3_step is return
back SQL_BUSY we need to retry the execution again do I need to call
sqlite3_reset() before retry to execute again.
And after
Hi All,
We have an application is used SQLite 3.5.9 and our program is crashed on
sqlite3_finalize (pStmt=0x28) at ../src/vdbeapi.c:204 and I don't know why it
crashed on this line.
Do you have any information about why it is crashed on sqlite3_finalize at 204
vdbeapi.
Thanks in advance for
Hi All,
I have the database for one of our application and one for awhile the database
is lock(SQL error: database is locked) and I couldn't find out why the datbase
is locked. I used Sqlite 3.5.9.
So is there anyway to find why the database is locked.
Thanks,
JP:
Hi all,
One of our database had problem to run the schema. The error message below:
The question is how the database getting to this stats Error: file is
encrypted or is not a database
Thanks,
JP
Below is the error message
Enter .help for instructions
sqlite .schema
Error: file is encrypted
Hi All,
I have this problem about open the database. Here is the detail about the
problem.
Our application have one process to create the database and another process to
open the database and creating the report.
The problem here is the database is not created but if the second process has
Subject: Re: [sqlite] Open the database - Creating the empty database
On 12/15/08, Joanne Pham joannekp...@yahoo.com wrote:
Hi All,
I have this problem about open the database. Here is the detail about the
problem.
Our application have one process to create the database and another process
Hi All,
Suddenly on my server whenever I login to the database using the following
command:
sqlite3 myDB
and
run the .schema I got the error message return back:
Error: database disk image is malformed
What is this problem and how to fix it.
Thanks in advance for your help.
Thanks,
Joanne
Hi All,
How to check if the pStmt is not finalize so
sqlite3_finalize(pStmt) can be call again. I think I called
sqlite3_finalize(pStmt) twice so my application is crashed.
Thanks,
JP
- Original Message
From: Joanne Pham [EMAIL PROTECTED]
To: General Discussion of SQLite Database
Of Joanne Pham
Sent: Thursday, September 18, 2008 8:44 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Program is crashed on sqlite3_finalize(pStmt);
Hi All,
How to check if the pStmt is not finalize so
sqlite3_finalize(pStmt) can be call again. I think I called
sqlite3_finalize(pStmt
Hi All,
I have c++ application which is used SQLite 3.5.9.
Occasionally the application is crash on
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
sqlite3_finalize(pStmt);
Is
Hi All,
I have this MAC Address as integer 224577687400448. Is there any buildin
function in SQLite to convert this MAC Address from integer to character
format (IP Address format) as number.number.number.number
Thanks,
JP
___
sqlite-users mailing
of SQLite Database sqlite-users@sqlite.org
Sent: Friday, September 12, 2008 9:22:15 AM
Subject: Re: [sqlite] Convert the MAC address from integer to characters.
Joanne Pham wrote:
I have this MAC Address as integer 224577687400448. Is there any
buildin function in SQLite to convert this MAC
is not correct.
Thanks,
JP
- Original Message
From: Dennis Cote [EMAIL PROTECTED]
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent: Friday, September 12, 2008 10:12:37 AM
Subject: Re: [sqlite] Convert the MAC address from integer to characters.
Joanne Pham wrote
- Original Message
From: Joanne Pham [EMAIL PROTECTED]
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent: Friday, September 12, 2008 10:58:31 AM
Subject: Re: [sqlite] Convert the MAC address from integer to characters.
Thanks a lto Dennis!
But I got the value in reverse
to characters.
Joanne Pham wrote:
Sorry! the conversion is correct but it is in reverse order.
The select statement return :
1A:FC:90:48:30:00
and I checked the MAC Address:
00:30:48:90:fc:1a
How to change it to correct order or may be the number 29672054730752 needs
to be reverse
to characters.
Joanne Pham wrote:
Can we convert these sql statement to function/store procedure so we can pass
in the number and the return value back the character format.
For example : ConvertMAC(29672054730752 ) and the return value back :
00:30:48:90:FC:1A
No, you can't create user
Hi All,
Any idea about these error messages:
0xb6f67ca5 in enterMem () at ../src/mem1.c:66
66 sqlite3_mutex_enter(mem.mutex);
Current language: auto; currently c
Your help is greatly appreciated.
Thanks,
JP
- Original Message
From: Joanne Pham [EMAIL PROTECTED
synchronous=OFF ,
NULL, 0, errMsg);
Joanne Pham wrote:
Any idea about these error messages:
0xb6f67ca5 in enterMem () at ../src/mem1.c:66
66 sqlite3_mutex_enter(mem.mutex);
Current language: auto; currently c
What version of sqlite are you using? Line 66 in mem.c is a comment
Hi all,
I had a function to open the database and set some database properties as below:
sqlite3_exec(pDb, PRAGMA synchronous=OFF , NULL, 0, errMsg);
and this function is crashed on some of the database but not all and return the
message as below:
Program received signal SIGSEGV,
Hi All,
I have an application which is used one of the variable is long long int.
This variable is used for storing the big number and
I used sqlite3_bind_int to bind this variable. One for while I have seen the
negative number in the database for this variable.
It seems like this variable is
: [sqlite] sqlite3_bind_int64, sqlite3_bind_int, sqlite_uint64
Joanne Pham [EMAIL PROTECTED] wrote:
I have read the sqlite'document and found that there are two other
binding function sqlite3_bind_int64, sqlite_uint64 to bind the
columns.
Which function (sqlite3_bind_int64, sqlite_uint64
Hi Igor,
I used SQLite versio n 3.5.9.
I read the SQLite online document and the suggession that we need to finalize
all the prepare statement associated with database connection before closing
the connection as below
while( (pStmt = sqlite3_next_stmt(pDb, 0))!=0 ){
Hi All,
I have a question related toSQLite db handle(pDb in my codes).
I have the function below to open the database connection. I have to call
sqlite3_close(sqlite3 *)(sqlite3_close(pDb) in my case)
before open another database connection( by calling openDb) for releasing the
memory which is
Sorry! Resend an email because no subject in previous email.
Again. Your help is greatly appreciated.
Thanks,
JP
- Original Message
From: Joanne Pham [EMAIL PROTECTED]
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent: Thursday, August 21, 2008 11:54:13 AM
Subject
Is it necessary to call only sqlite3_close(pDb) before open another connection.
Thanks,
JP
- Original Message
From: Igor Tandetnik [EMAIL PROTECTED]
To: sqlite-users@sqlite.org
Sent: Thursday, August 21, 2008 12:03:58 PM
Subject: Re: [sqlite] sqlite3_close
Joanne Pham [EMAIL PROTECTED
Got it!
Thanks a lot for your answer.
JP.
- Original Message
From: Igor Tandetnik [EMAIL PROTECTED]
To: sqlite-users@sqlite.org
Sent: Thursday, August 21, 2008 1:52:15 PM
Subject: Re: [sqlite] sqlite3_close
Joanne Pham [EMAIL PROTECTED] wrote:
Is it necessary to call only
: Thursday, August 21, 2008 1:52:15 PM
Subject: Re: [sqlite] sqlite3_close
Joanne Pham [EMAIL PROTECTED] wrote:
Is it necessary to call only sqlite3_close(pDb) before open another
connection. Thanks,
No (though it's not clear why you would want multiple connections open
at the same time). You can
From: Joanne Pham [EMAIL PROTECTED]
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent: Monday, July 28, 2008 10:57:22 AM
Subject: Re: [sqlite] Convert the CURRENT_TIMESTAMP
Hi,
Thanks for the big help.
Finally I got it worked as expected and the sql statement below
in single quotes ( ... when '0' then 'SUN'
when '1' then 'MON' ...) will give you the expected result.
Jon
-Inline Message Follows-
Igor Tandetnik wrote:
Joanne Pham [EMAIL PROTECTED]
wrote in message news:[EMAIL PROTECTED]
Hi all ,
I have the following statement to convert
PROTECTED]
To: sqlite-users@sqlite.org
Sent: Friday, July 25, 2008 9:21:26 PM
Subject: Re: [sqlite] Convert the CURRENT_TIMESTAMP
Joanne Pham [EMAIL PROTECTED]
wrote in message news:[EMAIL PROTECTED]
Hi all ,
I have the following statement to convert the CURRENT_TIMESTAMP to
format as
TUE JULY
Thanks Igor! It worked.
JP
- Original Message
From: Igor Tandetnik [EMAIL PROTECTED]
To: sqlite-users@sqlite.org
Sent: Friday, July 25, 2008 9:21:26 PM
Subject: Re: [sqlite] Convert the CURRENT_TIMESTAMP
Joanne Pham [EMAIL PROTECTED]
wrote in message news:[EMAIL PROTECTED]
Hi all
1 - 100 of 195 matches
Mail list logo