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

2011-10-19 Thread Joanne Pham
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

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

2011-10-19 Thread Joanne Pham
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

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

2011-10-19 Thread Joanne Pham
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

2011-10-20 Thread Joanne Pham
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...@

[sqlite] How to get the latest version of SQLite for Linux and how to apply it on Linux box

2007-10-18 Thread Joanne Pham
Hi All, I already had SQLite3 version 3.3.14 on my Linux box and I want to replace this version with the new version SQLite3 3.5.1and I don't know what are the steps to apply new version to my Linux box and where to downloading this new version. Thanks in advance, JP

[sqlite] How to post the question to this group

2007-10-18 Thread Joanne Pham
Hi All, I got a lot of email from this group but I don't remember how to post the question to this user group. Please help. Thanks, JP __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

[sqlite] tool to compare two database(content and schema)

2007-10-23 Thread Joanne Pham
Hi All, Do you know any tool to compare two databases both schema and content of the tables. Thanks, Jodie __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

Re: [sqlite] Read and write in SQLite

2007-11-09 Thread Joanne Pham
PROTECTED]> To: sqlite-users@sqlite.org Sent: Friday, November 9, 2007 1:43:26 PM Subject: Re: [sqlite] Read and write in SQLite On 11/9/07, Joanne Pham <[EMAIL PROTECTED]> wrote: > I knew that SQLite doesn't allow concurrency for both read and write at the > same time. > My appl

[sqlite] Begin and End Transaction.

2007-11-19 Thread Joanne Pham
Hi All, Do I need to have the commit/rollback statement if I have "Begin" and "End" transaction in my program. Thanks, JP Be a better pen pal. Text or chat with friends inside Yahoo! Mail. See how.

[sqlite] SQLITE_BUSY retry

2007-11-28 Thread Joanne Pham
Hi All, I have used "BEGIN" and "END" Transaction to insert the data to SQLite database. BEGIN insert ... insert ... END When I issued the "END" operation the error message return back is "SQLITE_BUSY". What should I do if I want to handle SQLITE_BUSY /retry the

Re: [sqlite] SQLITE_BUSY retry

2007-11-28 Thread Joanne Pham
ND" transaction again or What should I do in this case to handle SQLITE_BUSY. Thanks a lot in advance for the help or advice. JP - Original Message ---- From: Joanne Pham <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Wednesday, November 28, 2007 11:27:52 AM Subject: [sql

Re: [sqlite] SQLITE_BUSY retry

2007-11-28 Thread Joanne Pham
E_BUSY is encountered so that the time slice is dropped and other processes can run. A alternative is to issue a short delay or sleep. Joanne Pham wrote: > Hi All, > Here my statements to insert rows into the database > Open the database connection > BEGIN >insert ...using sqlite3

[sqlite] Different between BEGIN, END and "begin transaction", "

2007-11-29 Thread Joanne Pham
Hi All, What is the different between BEGIN insert . END and begin transaction insert ... end transaction Are they the same? Thanks, JP Be a better pen

Re: [sqlite] Re: Different between BEGIN, END and "begin transaction", "

2007-11-29 Thread Joanne Pham
TED]> To: SQLite <sqlite-users@sqlite.org> Sent: Thursday, November 29, 2007 10:46:36 AM Subject: [sqlite] Re: Different between BEGIN, END and "begin transaction", " Joanne Pham wrote: > What is the different between > BEGIN > insert . >

Re: [sqlite] Performance tuning using PRAGMA, other methods

2007-11-29 Thread Joanne Pham
Hi Scott, Thanks for the information related to Performance tunning using PRAGMA. My embeded app needs to be tunning too. I have serveral questions for you. Current I had these PRAGMAS in my app: sqlSt = sqlite3_exec(pDb, "PRAGMA page_size=32768", NULL, 0, ); sqlSt = sqlite3_exec(pDb, "PRAGMA

[sqlite] sqlite3_step() crash if didn't use sqlite3_bind_int before it

2007-11-30 Thread Joanne Pham
Hi All, I have the following code: bool insert(Uccls *_uccls, TCPAcclBucket *tcpAcclBucket){ int nextCol; memcpy(, tcpAcclBucket, sizeof (TCPAcclBucket)); bindColumns for tcpAcclRec //Execute statement

[sqlite] How to check if the column is existed in the table

2007-12-05 Thread Joanne Pham
Hi All, Is it possible to check if the certain column is existed in the table. For example : I had the table as define below: create table tablea (appid int, bytesIn int, bytesOut int) and I want to add one more column with default value of 1 and I don't want to drop the table and recreate it

Re: [sqlite] How to check if the column is existed in the table

2007-12-05 Thread Joanne Pham
check if the column is existed in the table On Wed, 5 Dec 2007 09:56:30 -0800 (PST), Joanne Pham <[EMAIL PROTECTED]> wrote: >Hi All, >Is it possible to check if the certain column is existed in the table. >For example : I had the table as define below: > create table tablea (appid int, b

Re: [sqlite] Occasional Database is Locked Error

2007-12-12 Thread Joanne Pham
Hi All, This is the exaclty approach that I used in my code. No way to reduce/minimize the lock issue regardless about the reading or the writting. We need to have to code to sleep and re-try the command again. JP - Original Message From: Richard Klein <[EMAIL PROTECTED]> To:

[sqlite] How to check if the table has some specific values

2007-12-12 Thread Joanne Pham
Hi All, I have been working on MSSQL server and SQLite is new to me. I usually did the following in MSQL server to check of the specific row is existed in the table and have different action depending on the result of the check. For example: Create table versionTable (dbVersion varchar(20)

Re: [sqlite] Re: How to check if the table has some specific values

2007-12-12 Thread Joanne Pham
- Original Message From: Igor Tandetnik <[EMAIL PROTECTED]> To: SQLite <sqlite-users@sqlite.org> Sent: Wednesday, December 12, 2007 4:14:08 PM Subject: [sqlite] Re: How to check if the table has some specific values Joanne Pham wrote: > I have been working on MSSQL server and SQLite

[sqlite] create table with datatype = DATE

2007-12-13 Thread Joanne Pham
Hi All, I create the table as : create table test (name varchar(30), createDate DATE default DATETIME('NOW')); but I got the error message. I want to have the default as now if it is not specify. Thanks in advance, Joanne

Re: [sqlite] create table with datatype = DATE - STORE as DATETIME or INTEGER.

2007-12-14 Thread Joanne Pham
it out as a declared type. To do what you want use a trigger on insert and update the date field with datetime('now'); Joanne Pham wrote: > Hi All, > I create the table as : >create table test (name varchar(30), createDate DATE default > DATETIME('NOW')); > but I got the

Re: [sqlite] create table with datatype = DATE. SHould use as DATETIME or INTEGER.

2007-12-17 Thread Joanne Pham
AIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Thursday, December 13, 2007 2:48:26 PM Subject: Re: [sqlite] create table with datatype = DATE CREATE TABLE test (.. createData DATETIME DEFAULT CURRENT_TIMESTAMP) On 12/13/07, Joanne Pham <[EMAIL PROTECTED]> wrote: > Hi All, >

Re: [sqlite] create table with datatype = DATE. SHould use as DATETIME or INTEGER.

2007-12-17 Thread Joanne Pham
u make it a REAL instead of DATETIME your code will be clearer. Joanne Pham wrote: > Hi All, > I have two question regarding DATETIME column data type: >1 ) Should I store my COLUMN as INTEGER instead of DATETIME. Is it easier > if this column type is INTEGER vs DATETIME then

Re: [sqlite] create table with datatype = DATE. SHould use as DATETIME or INTEGER.

2007-12-17 Thread Joanne Pham
string in the desired format (like printf) 6. current_time returns current time as HH:MM:SS 7. current_date returns current date as -MM-DD 8. current_timestamp returns current timestamp as -MM-DD HH:MM:SS ttp://www.somacon.com/p370.php Joanne Pham wrote: > Th

Re: [sqlite] Re: Error in SQLite's CSV output

2007-12-18 Thread Joanne Pham
Hi All, Is there any way that we can export the data to CSV format to the disk. Thanks, Joanne - Original Message From: Kees Nuyt <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Tuesday, December 18, 2007 8:11:08 AM Subject: Re: [sqlite] Re: Error in SQLite's CSV output On Wed,

[sqlite] How to convert the GMT time to date time format

2007-12-18 Thread Joanne Pham
Hi All, I have a table which has one of column is defined as INTEGER and stored the GMT time. I would like to convert this GMT time from INTEGER format to DATETIME format. Is there any function to convert from GMT in INTEGER to DATETIME format. Thanks, Joanne

Re: [sqlite] How to convert the GMT time to date time format

2007-12-18 Thread Joanne Pham
] How to convert the GMT time to date time format Joanne Pham <[EMAIL PROTECTED]> wrote: > Hi All, > I have a table which has one of column is defined as INTEGER and stored the > GMT time. > I would like to convert this GMT time from INTEGER format to DATETIME format. > Is t

Re: [sqlite] Re: Error in SQLite's CSV output

2007-12-18 Thread Joanne Pham
Thanks! It works. Joanne - Original Message From: Kees Nuyt <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Tuesday, December 18, 2007 10:23:35 AM Subject: Re: [sqlite] Re: Error in SQLite's CSV output On Tue, 18 Dec 2007 09:58:55 -0800 (PST), Joanne Pham <[EMAIL

Re: [sqlite] How to convert the GMT time to date time format

2007-12-18 Thread Joanne Pham
12:20 PM, Joanne Pham <[EMAIL PROTECTED]> wrote: > Thank Richard, > What is the 'localtime' in this case. If my time zone is Pacific Time zone. 'localtime' is the keyword that tells SQLite to get the time from your computer's time zone setting. Read the datetime section on the wi

Re: [sqlite] Re: How to convert the GMT time to date time format

2007-12-18 Thread Joanne Pham
to date time format Joanne Pham wrote: > Thank Richard, > What is the 'localtime' in this case. If my time zone is Pacific Time > zone. You actually put the string literal 'localtime'. SQLite uses whatever time zone your operating system is configured to use. If you want to use specific t

[sqlite] sample code in C++ to get the data from sqlite database loop thru the record set

2007-12-18 Thread Joanne Pham
Hi All, If you have the sample code in C++ to run the command "Select column1, column2 from tablea" from C++ code and able to loop thru the record set to get each rows please share with me. Thanks in Advance, Joanne

[sqlite] How to truncate the hour

2007-12-19 Thread Joanne Pham
Hi All, I have the table as defined below: hourlyAppAcclTable ( appid INTEGER, startTime INTEGER -- is number of seconds in GMT time in the integer . ) the values in this table is : row1 - 1, 1198990800 row 2 - 2,

Re: [sqlite] How to truncate the hour

2007-12-19 Thread Joanne Pham
ber 19, 2007 9:28:22 AM Subject: Re: [sqlite] How to truncate the hour On 12/19/07, Joanne Pham <[EMAIL PROTECTED]> wrote: > Hi All, > I have the table as defined below: > hourlyAppAcclTable ( appid INTEGER, > startTime INTEGER -- is number o

Re: [sqlite] How to truncate the hour

2007-12-19 Thread Joanne Pham
2007 9:49:43 AM Subject: Re: [sqlite] How to truncate the hour On 12/19/07, Joanne Pham <[EMAIL PROTECTED]> wrote: > Hi, > strftime doesn't work for me. I appreciate if you can help me on this. > > My hourlyAppAcclTable > row1 - 1, 1198990800 -- (which is 12-29-2

[sqlite] Program is crahed on sqlite3_bind_int

2008-01-21 Thread Joanne Pham
Hi All, I am using sqlite 3.5.2 and Suddenly my program is crashed on sqlite3_bind_int command The error message from the crash is : sqlite3_bind_int64 (pStmt=0x40058a28, i=1, iValue=10) at ./src/vdbeapi.c:897 897 ./src/vdbeapi.c: No such file or directory. in ./src/vdbeapi.c I had

Re: [sqlite] Program is crahed on sqlite3_bind_int

2008-01-21 Thread Joanne Pham
Hi All, The exactly error message below: sqlite3_bind_int64 (pStmt=0x40058a28, i=1, iValue=10) at ./src/vdbeapi.c:897 897 ./src/vdbeapi.c: No such file or directory. in ./src/vdbeapi.c Current language: auto; currently c Thanks, JP - Original Message From: Joanne Pham

Re: [sqlite] Program is crahed on sqlite3_bind_int

2008-01-21 Thread Joanne Pham
ething wrong with a shared library or DLL. Joanne Pham wrote: > Hi All, > The exactly error message below: > sqlite3_bind_int64 (pStmt=0x40058a28, i=1, iValue=10) at ./src/vdbeapi.c:897 > 897./src/vdbeapi.c: No such file or directory. >in ./src/vdbeapi.c > Current la

Re: [sqlite] Program is crahed on sqlite3_bind_int- Could you please help

2008-01-21 Thread Joanne Pham
ure out what is the problem and how to fit it. It used to work last week. Could you please help. Thanks, JO - Original Message From: Joanne Pham <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Monday, January 21, 2008 4:38:52 PM Subject: Re: [sqlite] Program is crahed on sqlite

Re: [sqlite] Program is crahed on sqlite3_bind_int

2008-01-22 Thread Joanne Pham
sqlite-users@sqlite.org Sent: Monday, January 21, 2008 6:51:08 PM Subject: Re: [sqlite] Program is crahed on sqlite3_bind_int Did you change something on the machine. Is it Windows or Linux? Joanne Pham wrote: > Thanks!! So how to fix this problem.. > -JP > > > > - Orig

Re: [sqlite] Program is crahed on sqlite3_bind_int

2008-01-22 Thread Joanne Pham
achine. Is it Windows or Linux? Joanne Pham wrote: > Thanks!! So how to fix this problem.. > -JP > > > > - Original Message > From: John Stanton <[EMAIL PROTECTED]> > To: sqlite-users@sqlite.org > Sent: Monday, January 21, 2008 3:11:52 PM > Subject: Re: [sql

Re: [sqlite] Program is crahed on sqlite3_bind_int- Could you please help

2008-01-22 Thread Joanne Pham
crahed on sqlite3_bind_int- Could you please help On Jan 22, 2008, at 9:14 AM, Joanne Pham wrote: > Hi All, > I still had the problem below: >> sqlite3_bind_int64 (pStmt=0x40058a28, i=1, iValue=10) at ./src/ >> vdbeapi.c:897 >> 897./src/vdbeapi.c: No such file or

[sqlite] How to truncate the hour fraction

2008-01-23 Thread Joanne Pham
Hi All, I have a hour table which has the startTime are stored at GMT time. The startTime of this hour table has the values below: Hour table --- StartTimeequivalent with the time format 1201561200 -> 2008-01-28 15:00:00 120159 -> 2008-01-28 23:00:00 120159

Re: [sqlite] How to truncate the hour fraction

2008-01-23 Thread Joanne Pham
t2 - (t2 mod 3600) Joanne Pham <[EMAIL PROTECTED]> wrote: Hi All, I have a hour table which has the startTime are stored at GMT time. The startTime of this hour table has the values below: Hour table --- StartTimeequivalent with the time format 1201561200 -> 200

Re: [sqlite] How to truncate the hour fraction

2008-01-23 Thread Joanne Pham
Any help for this question please! I would like to convert from t1 to t2. and my table is store t2. t1: 201561222 -> 2008-01-28 15:00:22 and I want t2 ?-> 2008-01-28 00:00:00 Thanks JP - Original Message From: Joanne Pham <[EMAIL PROTECTED]> To:

[sqlite] sqlite 3.5.2 for 32 bits and 64 bits

2008-01-23 Thread Joanne Pham
Hi All, I already had the sqlite library for 32 bits as libsqlite3.so.0.86 and now I want to build the sqlite library for 64bits for 64bits machine. Can someone help me with the information how to build the sqlite library which is used for 64bits machine. Thanks in advance for your help. JP

Re: [sqlite] sqlite 3.5.2 for 32 bits and 64 bits

2008-01-24 Thread Joanne Pham
Hi All, If you know how to build sqlite library for 64bits please help me with the detail information. Thanks in advance, JP - Original Message From: Joanne Pham <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Wednesday, January 23, 2008 4:09:42 PM Subject: [sqlite] sqlite

Re: [sqlite] sqlite 3.5.2 for 32 bits and 64 bits

2008-01-24 Thread Joanne Pham
sqlite] sqlite 3.5.2 for 32 bits and 64 bits Joanne Pham wrote: > If you know how to build sqlite library for 64bits please help me with the > detail information. What problems did you encounter when you tried to build it on a 64 bit machine? http://catb.org/~esr/faqs/smart-questions

[sqlite] undefined symbol: sqlite3_prepare_v2

2008-02-27 Thread Joanne Pham
Hi All, I used the sqlite3_prepare_v2 in my code and some of the servers are ok but one of my server return an error message that "undefined symbol: sqlite3_prepare_v2 " when the process is started and access the database using sqlite3_prepare_v2 . I don't have any clue why this problem is

Re: [sqlite] undefined symbol: sqlite3_prepare_v2

2008-02-27 Thread Joanne Pham
I have been using 3.5.2 sqlite. I forgot the mention this in my previous email. If you know the answer to this question please help. Thanks, JP - Original Message From: Joanne Pham <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Wednesday, February 27, 2008 9:34:05 AM S

Re: [sqlite] undefined symbol: sqlite3_prepare_v2

2008-02-27 Thread Joanne Pham
Hi all, Thx for the response! On different Linux server. So how to find out what is the SQLite version on the server which has the problem. How to find out the sqlite version using Linux commnad. Thanks, JP - Original Message From: Dimitri <[EMAIL PROTECTED]> To: General Discussion of

Re: [sqlite] undefined symbol: sqlite3_prepare_v2

2008-02-27 Thread Joanne Pham
- Original Message From: Joanne Pham <[EMAIL PROTECTED]> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Wednesday, February 27, 2008 3:23:09 PM Subject: Re: [sqlite] undefined symbol: sqlite3_prepare_v2 Hi all, Thx for the response! On different

Re: [sqlite] undefined symbol: sqlite3_prepare_v2

2008-02-28 Thread Joanne Pham
from this library(libsql3.so.0.8.6. Thanks JP - Original Message From: Joanne Pham <[EMAIL PROTECTED]> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Wednesday, February 27, 2008 10:04:36 AM Subject: Re: [sqlite] undefined symbol: sqlite3_prepar

[sqlite] How to get the minutes number only

2008-03-18 Thread Joanne Pham
Hi All I ran the following statement: select datetime(startTime *60, 'unixepoch','-8 hours') , bytesIn from wanPerfTable where appId = 30 and remoteWXId = 200; and below is my output. 2007-12-03 11:00:00 20 2007-12-03 11:01:00 5 2007-12-03 11:02:00 100 2007-12-03 11:03:00 50

[sqlite] How to get the minutes number only

2008-03-18 Thread Joanne Pham
Hi All I ran the following statement: select datetime(startTime *60, 'unixepoch','-8 hours') , bytesIn from wanPerfTable where appId = 30 and remoteWXId = 200; and below is my output. 2007-12-03 11:00:00 20 2007-12-03 11:01:00 5 2007-12-03 11:02:00 100 2007-12-03 11:03:00

Re: [sqlite] How to get the minutes number only

2008-03-18 Thread Joanne Pham
- Original Message From: Joanne Pham <[EMAIL PROTECTED]> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Tuesday, March 18, 2008 4:40:54 PM Subject: How to get the minutes number only Hi All I ran the following statement: select datetime(s

[sqlite] How to get the number of minutes

2008-03-18 Thread Joanne Pham
Hi All I ran the following statement: select datetime(startTime *60, 'unixepoch','-8 hours') , bytesIn from wanPerfTable where appId = 30 and remoteWXId = 200; and below is my output. 2007-12-03 11:00:00 20 2007-12-03 11:01:00 5 2007-12-03 11:02:00 100 2007-12-03 11:03:00 50

[sqlite] create index with allow duplicate row

2008-03-31 Thread Joanne Pham
Hi All, Is sqlite3 allow to create the index(non-cluster index) with an option allow duplicate row Thanks, JL You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No

[sqlite] sqlite3_finalize(pReadStmt); and sqlite3_close(pDB);

2008-04-03 Thread Joanne Pham
Hi All, Should we always call sqlite3_finalize(pReadStmt); and sqlite3_close(pDB) after we have done with read/write to database. Or sqlite3_finalize(pReadStmt) is good enough. Please advice what is the sequence of statement that we should call after we are done with database

[sqlite] sqlite3_prepare_v2(pDb, stmt, -1, , 0) for read the table

2008-04-09 Thread Joanne Pham
Hi All, I used sqlite3_prepare_v2(pDb,stmt,-1,,0) for preparing the statement and used sqlite3_step(pReadStmt); to get each row. my stmt is : select remoteId, bytesIn from compressTable then it worked ok but if my statement has the attach database then it didn't work because the

Re: [sqlite] sqlite3_prepare_v2(pDb, stmt, -1, , 0) for read the table

2008-04-10 Thread Joanne Pham
are_v2(pDb, stmt, -1, , 0) for read the table "Joanne Pham" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I used sqlite3_prepare_v2(pDb,stmt,-1,,0) > for preparing the statement and used sqlite3_step(pReadStmt); to get > each row. > my stmt is :

Re: [sqlite] sqlite3_prepare_v2(pDb, stmt, -1, , 0) for read the table

2008-04-10 Thread Joanne Pham
lite-users@sqlite.org Sent: Thursday, April 10, 2008 9:13:38 AM Subject: Re: [sqlite] sqlite3_prepare_v2(pDb, stmt, -1, , 0) for read the table Joanne Pham <[EMAIL PROTECTED]> wrote: > Thanks Igor for the info. > I have tried to prepare and execute each one seperately but it didn't > work

Re: [sqlite] sqlite3_prepare_v2(pDb, stmt, -1, , 0) for read the table

2008-04-10 Thread Joanne Pham
---- From: Joanne Pham <[EMAIL PROTECTED]> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Thursday, April 10, 2008 9:33:28 AM Subject: Re: [sqlite] sqlite3_prepare_v2(pDb, stmt, -1, , 0) for read the table Here is what I had: pDb is the sqlite3 *pDb which

[sqlite] delete rows but the database files still have the big size

2008-04-14 Thread Joanne Pham
Hi All, I have used sqlite3 command to clean up ton of rows in the table by executing the following command sqlite3> delete from compressTable where appId > 10; The command above has deleted ~ 99% of the table and now this table has ~ 100 rows but the database file size is the same as before

Re: [sqlite] delete rows but the database files still have the big size

2008-04-15 Thread Joanne Pham
the big size Joanne Pham wrote: > Do I miss some commands here? I thought the database file size shoud get much > smaller after the delete operation but it isn't. > Can you please help to let me know how to get the database file szie smaller. > I have tried "VACUUM"

[sqlite] when we need to use sqlidte3_close

2008-04-18 Thread Joanne Pham
Hi All, The question that I had is when we need to use the sqlite3_close. The reason that I have this question because I had the following codes and it crashed if the sqlite3_closed is used. Below is the codes: . sqlSt = sqlite3_prepare_v2(pDb,stmt,-1,,0); if

[sqlite] How to execute the statment file using sqlite API

2008-04-22 Thread Joanne Pham
Hi all, I have the serveral sql statement in the one file call : getData.sql and I want to use the sqlite API to call this file to execute all sql statements in this file at once. Can you tell me what API I should use. I had the code to execute the statment but I don't know how to call the file.

Re: [sqlite] How to execute the statment file using sqlite API

2008-04-23 Thread Joanne Pham
Message From: Fin Springs <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Wednesday, April 23, 2008 6:25:12 AM Subject: Re: [sqlite] How to execute the statment file using sqlite API On Apr 22, 2008, at 7:57 PM, Joanne Pham joannekpham-at-yahoo.com | sqlite| wrote: > Hi all,

[sqlite] sqlite3_exec return an error message

2008-04-23 Thread Joanne Pham
Hi All, I have the following codes to execute the sql file but the error message return back that dot(.). It seems like sqlite3_exec didn't like ".output wanPerfTableTest". So how go to get arround with this command ".output wanPerfTableTest" Your help is greatly appreciated. Thanks JP

Re: [sqlite] sqlite3_exec return an error message

2008-04-23 Thread Joanne Pham
sage From: Igor Tandetnik <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Wednesday, April 23, 2008 4:03:20 PM Subject: Re: [sqlite] sqlite3_exec return an error message Joanne Pham <[EMAIL PROTECTED]> wrote: > I have the following codes to execute the sql file but the e

Re: [sqlite] sqlite3_exec return an error message

2008-04-23 Thread Joanne Pham
t: Wednesday, April 23, 2008 4:55:30 PM Subject: Re: [sqlite] sqlite3_exec return an error message On 4/23/08, Joanne Pham <[EMAIL PROTECTED]> wrote: > Thanks a lot Igor! > But the codes below didn't work too: > char stmt[STMT_LEN]; > char *sqlStmt = [0]; > strcpy([0],"o

Re: [sqlite] sqlite3_exec return an error message

2008-04-23 Thread Joanne Pham
; command line. > What do you meant by "probably strip all dot commands from it before passign the contents to > sqlite3_exec)." Thanks, JP ----- Original Message From: Joanne Pham <[EMAIL PROTECTED]> To: [EMAIL PROTECTED]; General Discussion of SQLite Database <

[sqlite] One connection with 2 statement handle.

2008-04-26 Thread Joanne Pham
Hi, One connection(sqlite3 *pDb) uses by multiple statements handle(sqlite3_stmt). So one connection is used by two multiple statements concurrently one for insertion and one for selection. Is that ok. Have any one experienced this situation. Thanks, JP

Re: [sqlite] One connection with 2 statement handle.

2008-04-28 Thread Joanne Pham
er? In other words locks will not be used? On Sat, Apr 26, 2008 at 7:40 PM, Joanne Pham <[EMAIL PROTECTED]> wrote: > Hi, > One connection(sqlite3 *pDb) uses by multiple statements > handle(sqlite3_stmt). > So one connection is used by two multiple statements concurrent

Re: [sqlite] One connection with 2 statement handle.

2008-04-30 Thread Joanne Pham
Have anyone had experience about one connection with multiple statement handle: one for selection and one for deletion. Is there any problem in this case. Thanks, JP - Original Message From: Joanne Pham <[EMAIL PROTECTED]> To: General Discussion of SQLite Database <sql

[sqlite] concatenation operator

2008-05-05 Thread Joanne Pham
Hi All, I had the table, appMapTable as defined below: appId, appName, appType 1, appname, 2 2, appname, 3 appName always has string as appname and now I want to concatenate the appName with appId so the result will be: 1,appname1,2 2, appname2,3 . I ran the following sql statement :

[sqlite] SQLITE3 datatype

2008-05-07 Thread Joanne Pham
Hi All, I have read online document regarding SQLITE3 data type and below is list of these datatypes: * TEXT * NUMERIC * INTEGER * REAL * NONE But just now I found out SQLITE3 has bigint and int as another datatype. Can you direct me where I can find

Re: [sqlite] SQLITE3 datatype

2008-05-07 Thread Joanne Pham
2:27:21 PM Subject: Re: [sqlite] SQLITE3 datatype On Wed, 7 May 2008, Joanne Pham wrote: > I was wondering what is the different in size between int(8) and INTEGER > datatype. > Thanks, In the sense you are asking, there is no difference, but more importantly, the question reflects a

[sqlite] Check the error message

2008-05-12 Thread Joanne Pham
Hi All, We have an application in C++ is up and running all the time to insert the data into the table. At the same time we have the shell script to dump the database to file at the end of the hour as defined below in this email. The question that I have is while the application is writting data

[sqlite] sqlite3_finalize vs sqlite3_closed

2008-05-15 Thread Joanne Pham
Hi All,  Should Iuse sqlite3_finalize or sqlite3_closed after I am done with reading/write to the database. Thanks, JP ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Timestamp DataType

2008-05-16 Thread Joanne Pham
Hi All, As mentioned in the document of SQLite the list below is all the datatype of SQLite. How about Timestamp  fromat? Can we havethe column's datatype as Timestamp . Thanks, JP * NULL. The value is a NULL value. * INTEGER. The value is a signed integer, stored in 1, 2, 3, 4,

Re: [sqlite] Timestamp DataType

2008-05-16 Thread Joanne Pham
lt;sqlite-users@sqlite.org> Sent: Friday, May 16, 2008 10:12:54 AM Subject: Re: [sqlite] Timestamp DataType Joanne Pham wrote: > Hi All, > As mentioned in the document of SQLite the list below is all the datatype of > SQLite. > How about Timestamp  fromat? Can we havethe column

[sqlite] Limitation of sqlite3_last_insert_rowid()

2008-05-16 Thread Joanne Pham
U12232 If a separate thread does a new insert on the same database connection while the sqlite3_last_insert_rowid() function is running and thus changes the last insert rowid, then the value returned by sqlite3_last_insert_rowid() is unpredictable and might not equal either the old or the new

[sqlite] get the actual database size.

2008-05-29 Thread Joanne Pham
Hi All, I have the database which has a lot of insertion and deletion. Is there anyway that I can get the actual database size without running VACUUM. Thanks, JP ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] get the actual database size.

2008-05-30 Thread Joanne Pham
lt;sqlite-users@sqlite.org> Sent: Thursday, May 29, 2008 5:40:23 PM Subject: Re: [sqlite] get the actual database size. On 5/29/08, Joanne Pham <[EMAIL PROTECTED]> wrote: > Hi All, >  I have the database which has a lot of insertion and deletion. >  Is there anyway that I can g

Re: [sqlite] get the actual database size.

2008-05-30 Thread Joanne Pham
Ronny http://www.syntegro.be -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of P Kishor Sent: vrijdag 30 mei 2008 2:40 To: General Discussion of SQLite Database Subject: Re: [sqlite] get the actual database size. On 5/29/08, Joanne Pham <[EMAIL PRO

[sqlite] Sqliite Command for appending the data to file

2008-06-12 Thread Joanne Pham
Hi all, I need to dump the data to file in csv format and I have done the following: sqlite> .output dataFile sqlite> .mode csv sqlite> select * from myTable; sqlite>.quit The data is dump to the file correctly but I want to able to     1) append another table to this dataFile     2) Print the

Re: [sqlite] Sqliite Command for appending the data to file

2008-06-13 Thread Joanne Pham
Thanks! It worked. Thanks a ton, JP - Original Message From: Kees Nuyt <[EMAIL PROTECTED]> To: General Discussion of SQLite Database Sent: Friday, June 13, 2008 11:50:12 AM Subject: Re: [sqlite] Sqliite Command for appending the data to file On Thu, 12 Jun

[sqlite] Display all the columns of the table in single line.

2008-06-13 Thread Joanne Pham
Hi All, I ran the following select : select appName from appMapTable but I would like all the appName return as single row and seperate by comma. Can we do that using sqlite commands. Thanks so much. JP " ___ sqlite-users mailing list

Re: [sqlite] Display all the columns of the table in single line.

2008-06-16 Thread Joanne Pham
ite-users@sqlite.org Sent: Friday, June 13, 2008 7:45:08 PM Subject: Re: [sqlite] Display all the columns of the table in single line. "Joanne Pham" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I ran the following select : > select appName from appMapTable >

Re: [sqlite] Display all the columns of the table in single line.

2008-06-16 Thread Joanne Pham
Monday, June 16, 2008 3:46:20 PM Subject: Re: [sqlite] Display all the columns of the table in single line. Joanne Pham <[EMAIL PROTECTED]> wrote: > I got this error message. I had 3.5.2 SQLite. > sqlite> select group_concat(appName) from CDB.appMapTable; > SQL error: no suc

[sqlite] Insert mil.rows to table can take up to a day

2008-07-01 Thread Joanne Pham
Hi All, I have the file which has million rows of insert statement to insert the data to the database like below:  insert into tables values(...) (there are million insert statement to insert to the table) (file name is insertTables) Then I ran the following

Re: [sqlite] Insert mil.rows to table can take up to a day

2008-07-01 Thread Joanne Pham
ows to table can take up to a day Joanne Pham wrote: > Hi All, > I have the file which has million rows of insert statement to insert the data > to the database like below: >  insert into tables values(...) > > (there are million insert st

Re: [sqlite] Insert mil.rows to table can take up to a day

2008-07-01 Thread Joanne Pham
to table can take up to a day Joanne Pham wrote: > Hi All, > I have the file which has million rows of insert statement to insert the data > to the database like below: >  insert into tables values(...) > > (there are million insert statement t

[sqlite] Table Level Locking

2008-07-01 Thread Joanne Pham
Hi All, I read the online document regarding "Table Level Locking" as below:         At any one time, a single table may have any number of active read-locks or a single active write lock. To read data a table, a connection                 must first obtain a read-lock. To write to a table,

[sqlite] Version 3.5.9 vs 3.5.2

2008-07-11 Thread Joanne Pham
Hi All, I am currently using the sqlite3 version 3.5.2 and we will have the release come in soon. So I am wondering if I need to upgrade my sqlite to version 3.5.9 before the release. If so then Can you please tell me why I need to upgrade to 3.5.9. At this time I need the buildin function

[sqlite] Download 3.5.9 version - how to build the library

2008-07-17 Thread Joanne Pham
Hi All, Currently we are using 3.5.2 version and I would like to use SQLite 3.5.9 for our product. Would you please direct me where to find out the release note for 3.5.9 and the instruction how to build the library after downloading the source code of 3.5.9. Thanks JP

[sqlite] Format of the data

2008-07-21 Thread Joanne Pham
Hi All, I am current using sqlite 3.5.9 and below is command to get the data from my database as:     .output '/opt/phoenix/monitor/exportData'     .mode csv     select '#Monitored applications' , group_concat(appName) from appMapTable; The output is:     "#Monitored

[sqlite] Convert the CURRENT_TIMESTAMP

2008-07-25 Thread Joanne Pham
Hi All, I ran the following sql statement select CURRENT_TIMESTAMP; and the output is : 2008-07-25 23:11:13 Is there any easy way or buildin function to convert this format to : TUE JULY 25 23:11:13 2008 Thanks, JP ___ sqlite-users mailing list

  1   2   >