Re: [sqlite] Convert the CURRENT_TIMESTAMP

ite.org> Sent: Friday, July 25, 2008 4:41:59 PM Subject: Re: [sqlite] Convert the CURRENT_TIMESTAMP Look at the wiki for date/time functions, specifically strft. Woody from his pda -Original Message----- From: Joanne Pham <[EMAIL PROTECTED]> Sent: Friday, July 25, 2008 4:08 PM To: Genera

[sqlite] Convert the CURRENT_TIMESTAMP

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

[sqlite] Format of the data

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] Download 3.5.9 version - how to build the library

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] Version 3.5.9 vs 3.5.2

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] Table Level Locking

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,

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

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

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

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

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

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] Display all the columns of the table in single line.

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

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

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 >

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

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] Sqliite Command for appending the data to file

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] Sqliite Command for appending the data to file

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] get the actual database size.

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

Re: [sqlite] get the actual database size.

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

[sqlite] get the actual database size.

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

[sqlite] Limitation of sqlite3_last_insert_rowid()

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

Re: [sqlite] Timestamp DataType

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] Timestamp DataType

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,

[sqlite] sqlite3_finalize vs sqlite3_closed

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] Check the error message

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

Re: [sqlite] SQLITE3 datatype

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] SQLITE3 datatype

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

[sqlite] concatenation operator

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 :

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

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

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

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

[sqlite] One connection with 2 statement handle.

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] sqlite3_exec return an error message

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

Re: [sqlite] sqlite3_exec return an error message

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

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

[sqlite] sqlite3_exec return an error message

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] How to execute the statment file using sqlite API

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] How to execute the statment file using sqlite API

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.

[sqlite] when we need to use sqlidte3_close

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

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

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] delete rows but the database files still have the big size

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] sqlite3_prepare_v2(pDb, stmt, -1, , 0) for read the table

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

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

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

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 :

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

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

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

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] create index with allow duplicate row

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] How to get the number of minutes

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

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

- 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 minutes number only

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

[sqlite] How to get the minutes number only

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

Re: [sqlite] undefined symbol: sqlite3_prepare_v2

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

Re: [sqlite] undefined symbol: sqlite3_prepare_v2

- 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

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

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

[sqlite] undefined symbol: sqlite3_prepare_v2

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] sqlite 3.5.2 for 32 bits and 64 bits

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

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

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

[sqlite] sqlite 3.5.2 for 32 bits and 64 bits

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] How to truncate the hour fraction

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:

Re: [sqlite] How to truncate the hour fraction

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

[sqlite] How to truncate the hour fraction

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] Program is crahed on sqlite3_bind_int- Could you please help

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

Re: [sqlite] Program is crahed on sqlite3_bind_int

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

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- Could you please help

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

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

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

[sqlite] Program is crahed on sqlite3_bind_int

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] How to truncate the hour

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

Re: [sqlite] How to truncate the hour

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

[sqlite] How to truncate the hour

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,

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

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

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

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

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

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: Error in SQLite's CSV output

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

] 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

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

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] Re: Error in SQLite's CSV output

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,

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

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] create table with datatype = DATE. SHould use as DATETIME or INTEGER.

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.

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 - STORE as DATETIME or INTEGER.

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

[sqlite] create table with datatype = DATE

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] Re: How to check if the table has some specific values

- 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] How to check if the table has some specific values

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] Occasional Database is Locked Error

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:

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

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

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

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

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

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

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

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

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

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

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

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] SQLITE_BUSY retry

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

Re: [sqlite] SQLITE_BUSY retry

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

[sqlite] SQLITE_BUSY retry

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

[sqlite] Begin and End Transaction.

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.

Re: [sqlite] Read and write in SQLite

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] tool to compare two database(content and schema)

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

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

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

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

<    1   2