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 <slav...@bigfraud.org> To: Joanne Pham <joannekp...@

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

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

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

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

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

Re: [sqlite] Indexes on the table

on the table 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 fr

[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

Re: [sqlite] NULL data .dump command

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 qu

Re: [sqlite] NULL data .dump command

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 <joannekp...@yahoo.com&

[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

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

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

[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

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

Lite 3.6.14 You 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

[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

3:21:10 PM Subject: Re: [sqlite] Should 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

[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

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

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 <

[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, , 0);      if

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

gt; > As long as SQLite is a concern, 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 T

[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

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

'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 one of the performance document and it stated that "prepared > statements must be generated inside transaction". Is tha

[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

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

-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] 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

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

e] How 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 ..

[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

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

ussion of SQLite 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:

[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

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

[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

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

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

[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

[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

ontrol 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 &g

Re: [sqlite] Transaction control At the SQL Level

@sqlite.org Sent: 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

[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

[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

[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

On Mon, Apr 20, 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.

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

for sqllite 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 diffe

[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, ); 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, JP

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

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. "

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

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

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

org> 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(dail

[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

Re: [sqlite] PRAGMA read_uncommitted = 1

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 >

Re: [sqlite] PRAGMA read_uncommitted = 1

mitted = 1 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-uncommite

[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

[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

Re: [sqlite] Database handle(sqlite3_stmt)

te.org Sent: 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

Re: [sqlite] Database handle(sqlite3_stmt)

2009 4: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 han

[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

[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

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

[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

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 <joannekp...@yahoo.com> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Sunday, March 8,

Re: [sqlite] select statement - Need help

ite-users-boun...@sqlite.org] 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     

[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.

, 2009 10:22:22 PM 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 remo

[sqlite] sql statement to concatinate two rows.

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>

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

[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

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

8) at ../src/vdbeapi.c: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

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

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

[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

[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

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

008 10:43:57 AM 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 t

[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

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

OTECTED] On Behalf 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 calle

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

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

from integer 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:

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

from integer 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

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

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

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

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. Joann

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

eneral Discussion 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] 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

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

te3_exec(pDb, "PRAGMA synchronous=OFF ", NULL, 0, ); 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 sqli

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

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 PROTEC

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

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, ); and this function is crashed on some of the database but not all and return the message as below:     Program received signal SIGSEGV, Segmentation

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

Re: [sqlite] sqlite3_close

g 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 open at t

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 <sqlite-users@sqlite.org> Sent: Thursday, August 21, 2008

[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

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 sta

Re: [sqlite] Convert the CURRENT_TIMESTAMP

AIL 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 C

Re: [sqlite] Convert the CURRENT_TIMESTAMP

umbers 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 fo

Re: [sqlite] Convert the CURRENT_TIMESTAMP

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:

  1   2   >