Re: [sqlite] sql statement to update the data in the table

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 To: Joanne Pham ; General Discussion of SQLite Datab

Re: [sqlite] sql statement to update the data in the table

ndetnik 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&qu

Re: [sqlite] sql statement to update the data in the table

dea. Thanks, JP From: Igor Tandetnik 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

[sqlite] sql statement to update the data in the table

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 _

[sqlite] PRAGMA auto_vacuum

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 | INCREMENTAL;)

Re: [sqlite] Indexes on the table

Thanks Simon for detail explaination about the indexes! JP From: Simon Slavin To: General Discussion of SQLite Database Sent: Tuesday, July 21, 2009 3:57:22 PM Subject: Re: [sqlite] Indexes on the table On 21 Jul 2009, at 11:12pm, Joanne Pham wrote

[sqlite] Indexes on the table

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 1...256

Re: [sqlite] NULL data .dump command

t has problem? Any idea! Thanks, JP From: Joanne Pham To: General Discussion of SQLite Database Sent: Tuesday, June 16, 2009 3:41:17 PM Subject: Re: [sqlite] NULL data .dump command Hi All, I ran two queries:     1) select * from signature;         I didn'

Re: [sqlite] NULL data .dump command

have seen the malformed         ...         11020876449360377856|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 To: General Discussion

[sqlite] NULL data .dump command

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 the

Re: [sqlite] Compite with DSQLITE_THREADSAFE=1 but application has mulitple threads using the same connection

e.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 wrote: > > >Hi All, >What was the problem with the SQLite library

[sqlite] Compite with DSQLITE_THREADSAFE=1 but application has mulitple threads using the same connection

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 http://sqlite.o

Re: [sqlite] How to change the default values option when build SQLite 3.6.14

/configure -DSQLITE_THREADSAFE=2 Pavel On Wed, Jun 3, 2009 at 2:27 PM, Joanne Pham 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 the source tree into "sqlite" >   

[sqlite] How to change the default values option when build SQLite 3.6.14

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

Re: [sqlite] Should we upgrade the SQLite to 6.6.14.2 from 3.59

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 tr

[sqlite] Should we upgrade the SQLite to 6.6.14.2 from 3.59

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 newe

Re: [sqlite] Should use prepare/bind or just sqlite_exec.

Thanks Igor, So you prefer #1 instead of #2. Thanks, JP From: Igor Tandetnik 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 wrote: > I would like to upd

[sqlite] Should use prepare/bind or just sqlite_exec.

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);   

Re: [sqlite] Prepared statements must be generated inside yourtransaction

org Sent: Tuesday, May 12, 2009 3:00:34 PM Subject: Re: [sqlite] Prepared statements must be generated inside yourtransaction Joanne Pham wrote: > Regarding "batch" insert why we need to put the column binding > (sqlite3_bind...) before running sqlite3_step. For example: > sqlit

Re: [sqlite] Prepared statements must be generated inside your transaction

ern, I prepare statements outside 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:3

[sqlite] Program is crashed on sqlite3_free

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 sqlite3

Re: [sqlite] Prepared statements must be generated inside your transaction

tion. Pavel On Tue, May 12, 2009 at 12:32 PM, Joanne Pham 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 trying to im

[sqlite] Prepared statements must be generated inside your transaction

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 state

Re: [sqlite] How to check the healthy of database and the indexes ofthe tables

d on peerid?  Does "Explain query plan" show that it is used by the first query.  If so, perhaps the peerid index contains some corruption? -- Does adding "peerid" to your second select run without error? Regards,   Donald       -Original Message- From: sqlite-users

Re: [sqlite] How to check the healthy of database and the indexes of the tables

database and the indexes of the tables On Tue, 5 May 2009 13:02:13 -0700 (PDT), Joanne Pham 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 and the message

[sqlite] How to check the healthy of database and the indexes of the 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 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

Re: [sqlite] SQL error: database disk image is malformed

day, 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 To: General Discussion of SQLite Databa

[sqlite] SQL error: database disk image is malformed

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 sql

[sqlite] "COMMIT"

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 :             sqlite3_exec

[sqlite] The details of the behavior of the sqlite3_step() interface

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 sqlite3_

Re: [sqlite] sqlite3_finalize(sqlite3_stmt) is this call clean up thememory

Thanks a lot Igor for respond my email. JP From: Igor Tandetnik 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" wrote in me

[sqlite] sqlite3_finalize(sqlite3_stmt) is this call clean up the memory

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 han

[sqlite] sqlite3_mutex_enter(db->mutex) problem

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

Re: [sqlite] Transaction control At the SQL Level

Joanne Pham 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. Using the first databa

Re: [sqlite] Transaction control At the SQL Level

esday, April 29, 2009 7:48:41 PM Subject: Re: [sqlite] Transaction control At the SQL Level "Joanne Pham" 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 afte

[sqlite] Transaction control At the SQL Level

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

Re: [sqlite] How to check compiler options being used

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 To: General Discussion of SQLite Database Se

[sqlite] How to check compiler options being used

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 mailin

[sqlite] create the trigger to delete the data from other database

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 __

[sqlite] Columns in where clause and the index.

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 ___

[sqlite] Indexes questions

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

[sqlite] Program is crashed on pager_end_transaction

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        

Re: [sqlite] what is the right cache_size for sqllite version 3.5.9

Thanks! I will do so. JP From: P Kishor To: General Discussion of SQLite Database Sent: Monday, April 20, 2009 5:18:27 PM Subject: Re: [sqlite] what is the right cache_size for sqllite version 3.5.9 On Mon, Apr 20, 2009 at 7:13 PM, Joanne Pham wrote: >

Re: [sqlite] what is the right cache_size for sqllite version 3.5.9

SSAGE- 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 -BEGIN PGP SIGNATURE- Ver

[sqlite] what is the right cache_size for sqllite version 3.5.9

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,

Re: [sqlite] Need help with the SQL statement.

Thanks a ton Igor! It worked. Your help is greatly appreciated. Thanks, JP From: Igor Tandetnik 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" wrote in me

Re: [sqlite] Need help with the SQL statement.

ik 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" 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) > ma

Re: [sqlite] Need help with the SQL statement.

e.org Sent: Wednesday, April 15, 2009 7:44:48 PM Subject: Re: [sqlite] Need help with the SQL statement. "Joanne Pham" wrote in message news:594788.4966...@web90305.mail.mud.yahoo.com > Hi All, > I have the following table(dailyDataTable) as defined below > startTime INTEGER :

[sqlite] Need help with the SQL statement.

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 ca

Re: [sqlite] PRAGMA read_uncommitted = 1

From: Igor Tandetnik To: sqlite-users@sqlite.org Sent: Tuesday, April 14, 2009 1:29:08 PM Subject: Re: [sqlite] PRAGMA read_uncommitted = 1 Joanne Pham wrote: > I have another question : how to enabled shared-cache mode for the > connection? Thanks, http://sqlite.org/sharedcache.html

Re: [sqlite] PRAGMA read_uncommitted = 1

Hi Igor, I have another question : how to  enabled shared-cache mode for the connection? Thanks, JP From: Igor Tandetnik To: sqlite-users@sqlite.org Sent: Tuesday, April 14, 2009 12:06:29 PM Subject: Re: [sqlite] PRAGMA read_uncommitted = 1 Joanne Pham wrote

Re: [sqlite] PRAGMA read_uncommitted = 1

   - also allows read if there is a write-lock right? Thanks again for respond my email. JP From: Igor Tandetnik To: sqlite-users@sqlite.org Sent: Monday, April 13, 2009 9:00:12 PM Subject: Re: [sqlite] PRAGMA read_uncommitted = 1 "Joanne Pham"

[sqlite] PRAGMA read_uncommitted = 1

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

[sqlite] when A table in the database is locked

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 _

Re: [sqlite] what is the default for the commit when the connection is opened.

Thank a lot Jay From: Jay A. Kreibich To: General Discussion of SQLite Database 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, Apr 08, 2009 at 10:12:15PM +0200, Martin

[sqlite] what is the default for the commit when the connection is opened.

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

[sqlite] Attach the data return an error message

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 (st

Re: [sqlite] Database handle(sqlite3_stmt)

, 2009 8:10:58 PM Subject: Re: [sqlite] Database handle(sqlite3_stmt) "Joanne Pham" 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 pass the query text and

Re: [sqlite] Database handle(sqlite3_stmt)

: [sqlite] Database handle(sqlite3_stmt) Joanne Pham 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 question is confusing. Yes, y

[sqlite] Database handle(sqlite3_stmt)

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 op

[sqlite] crash on sqlite3 mutex

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 (db=0xb62

Re: [sqlite] select the first 2 rows

Thanks Eric. Joanne   From: Eric Minbiole To: General Discussion of SQLite Database 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 want only select the first 2 rows. > I have tried

[sqlite] select the first 2 rows

Hi all, I have a big table and I want only select the first 2 rows. I have tried this : select top 2 from table; but it doesn't work! Any help please. JP ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

[sqlite] Upgrade from 3.5.9 to 3.6.11

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 releas

Re: [sqlite] select statement - Need help

= max_utime                 and cnt > 1 ; t.hostName should be table.hostName Thanks a lot Adler for the help. JP From: Joanne Pham To: General Discussion of SQLite Database Sent: Sunday, March 8, 2009 1:44:01 PM Subject: Re: [sqlite] select statement - N

Re: [sqlite] select statement - Need help

    group by hostName) host_max         where table.hostname = host_max.hostname                 and table.lastUpdateTime = max_utime                 and cnt > 1 ; Eli -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joanne P

[sqlite] select statement - Need help

Hi All, I have the folowing table which has the following data for example:     remoteId hostName        lastUpdateTime     1        host1    19     2   host111     3host2    22

Re: [sqlite] sql statement to concatinate two rows.

concatinate two rows. On Tue, Feb 17, 2009 at 11:16 PM, Joanne Pham 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: > > 1|HostName1-T432|2

[sqlite] sql statement to concatinate two rows.

From: Joanne Pham To: General Discussion of SQLite Database 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, hostName , remoteWXType from remoteWXTable or

[sqlite] (no subject)

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

[sqlite] sqlite3_finalize() vs sqlite3_reset()

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 co

Re: [sqlite] sqlite3_finalize (pStmt=0x28) at ../src/vdbeapi.c:204

, 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  >

Re: [sqlite] sqlite3_finalize (pStmt=0x28) at ../src/vdbeapi.c:204

d. JP From: Dan To: General Discussion of SQLite Database 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 wrote: > Hi All, > We have an app

[sqlite] sqlite3_finalize (pStmt=0x28) at ../src/vdbeapi.c:204

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 yo

[sqlite] Find out what sql statement is locking the database

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: ___

[sqlite] database encrypted

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 encr

Re: [sqlite] Open the database - Creating the empty database

- Creating the empty database On 12/15/08, Joanne Pham 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 >to open the database and creating

[sqlite] Open the database - Creating the empty database

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 tri

[sqlite] Error message "database disk image is malformed"

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  

Re: [sqlite] Program is crashed on sqlite3_finalize(pStmt);

r some other purpose by the time the call to finalize() returns control to you. So your solution is to NULL your pointer after calling finalize() and don't call finalize() again if your pointer is NULL. Robert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTE

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) twice so my application is crashed. Thanks, JP - Original Message From: Joanne Pham <[EMAIL PROTECTED]> To: General Discussion of SQLite Da

[sqlite] Program is crashed on 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 th

Re: [sqlite] Convert the MAC address from integer to characters.

Thank a ton Dennis. I will try with the view then, JP - Original Message From: Dennis Cote <[EMAIL PROTECTED]> To: General Discussion of SQLite Database Sent: Friday, September 12, 2008 11:38:46 AM Subject: Re: [sqlite] Convert the MAC address from integer to characters. Joann

Re: [sqlite] Convert the MAC address from integer to characters.

  ) and the return value back : 00:30:48:90:FC:1A Thansk, JP - Original Message From: Dennis Cote <[EMAIL PROTECTED]> To: General Discussion of SQLite Database Sent: Friday, September 12, 2008 11:12:32 AM Subject: Re: [sqlite] Convert the MAC address from integer to characters.

Re: [sqlite] Convert the MAC address from integer to characters.

- Original Message From: Joanne Pham <[EMAIL PROTECTED]> To: General Discussion of SQLite Database 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 order and not c

Re: [sqlite] Convert the MAC address from integer to characters.

not correct. Thanks, JP - Original Message From: Dennis Cote <[EMAIL PROTECTED]> To: General Discussion of SQLite Database Sent: Friday, September 12, 2008 10:12:37 AM Subject: Re: [sqlite] Convert the MAC address from integer to characters. Joanne Pham wrote: > Thanks a lot

Re: [sqlite] Convert the MAC address from integer to characters.

eneral Discussion of SQLite Database 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 Address

[sqlite] Convert the MAC address from integer to characters.

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 ... Thanks, JP ___ sqlite-users mailing list sqlite-users@sqlite

Re: [sqlite] Crashed on sqlite3_exec(pDb, "PRAGMA synchronous=OFF ", NULL, 0, &errMsg);

hronous=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 me

Re: [sqlite] Crashed on sqlite3_exec(pDb, "PRAGMA synchronous=OFF ", NULL, 0, &errMsg);

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]&

[sqlite] Crashed on sqlite3_exec(pDb, "PRAGMA synchronous=OFF ", NULL, 0, &errMsg);

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, Segmen

Re: [sqlite] sqlite3_bind_int64, sqlite3_bind_int, sqlite_uint64

58:14 PM Subject: Re: [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.

[sqlite] sqlite3_bind_int64, sqlite3_bind_int, sqlite_uint64

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_next_stmt in SQLite 3.5.9

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 ){           sqlit

Re: [sqlite] sqlite3_close

te.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 sqlite3_close(pDb) before open another > connection. Thanks, No (though it's not clear why you would want multiple connections

Re: [sqlite] sqlite3_close

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 necessa

Re: [sqlite] sqlite3_close

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 &

[sqlite] sqlite3_close

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 Sent: Thursday, August 21, 2008 11:54:13 AM Subject: [sqlite] (no s

[sqlite] (no subject)

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

Re: [sqlite] Convert the CURRENT_TIMESTAMP

'06' then 'JUN' when '07' then 'JUL'  when '08' then 'AUG' when '09' then 'SEP' when '10' then 'OCT' when '11' then 'NOV'  when '12' then 'DEC' end) || &#

  1   2   3   >