Re: [sqlite] confusing with how to to this in sqlite

2008-12-21 Thread Rachmat Febfauza
It looks like you are using the sqlite3 shell, so experiment with .separator Have you used .help? Rgds, Simon yes i am using sqlite3 shell, i mean not to make display like mysql does, but the difference column that i want like mysql does. take a look at this different A1221|SMALL|FOOD|CAKE|

Re: [sqlite] Sharing a database / Replication

2008-12-21 Thread Simon
> Most you need to know about locking is found in: > http://www.sqlite.org/lang_transaction.html > > sqlite3_exec() these statements one by one: > ATTACH 'filename' as db2; > BEGIN IMMEDIATE; -- or EXCLUSIVE > (error handling/retry) > > -- this assumes table1 has the exact > -- same definition

Re: [sqlite] [sqlite-announce] SQLite version 3.6.7

2008-12-21 Thread William Kyngesburye
On Dec 16, 2008, at 12:35 PM, D. Richard Hipp wrote: > Version 3.6.7 includes a major cleanup of the Unix driver in > os_unix.c. Also included is the new "Proxy Locking" locking module > for OSX. Proxy Locking provides greatly enhanced performance for > databases located on AFP filesystems. The

Re: [sqlite] Trigger UPDATE based on a different row

2008-12-21 Thread jose isaias cabrera
"P Kishor" wrote... > On 12/20/08, jose isaias cabrera wrote: >> >> Greetings! >> >> Imagine these rows in a table named LSOpenJobs: >> >> id, PID,subject, bdate, edate, lang,job >> 1, 232,2008-01-01,2008-01-10,es,trans >> 2, 232,2008-01-01,2008-01-10,fr,trans >> 3, 232,2008-01-01,2008-01-

Re: [sqlite] confusing with how to to this in sqlite

2008-12-21 Thread Simon Davies
2008/12/21 Rachmat Febfauza : > > It looks like you are using the sqlite3 shell, so experiment with .separator > > Have you used .help? > > Rgds, > Simon > > > yes i am using sqlite3 shell, i mean not to make display like mysql does, but > the difference column that i want like mysql does. > > tak

Re: [sqlite] [sqlite-announce] SQLite version 3.6.7

2008-12-21 Thread Dan
On Dec 22, 2008, at 12:44 AM, William Kyngesburye wrote: > On Dec 16, 2008, at 12:35 PM, D. Richard Hipp wrote: > >> Version 3.6.7 includes a major cleanup of the Unix driver in >> os_unix.c. Also included is the new "Proxy Locking" locking module >> for OSX. Proxy Locking provides greatly enha

Re: [sqlite] [sqlite-announce] SQLite version 3.6.7

2008-12-21 Thread William Kyngesburye
On Dec 21, 2008, at 9:09 PM, Dan wrote: > I found I also needed: > > -DSQLITE_ENABLE_LOCKING_STYLE -D__DARWIN__ > > Dan. Huh, __DARWIN__ doesn't seem to be an OSX system macro. I wonder why __APPLE__ isn't used, I figured __DARWIN__ was set. And I missed SQLITE_ENABLE_LOCKING_STYLE in th

Re: [sqlite] Trigger UPDATE based on a different row

2008-12-21 Thread jose isaias cabrera
"jose isaias cabrera" wrote... > > "P Kishor" wrote... > >> On 12/20/08, jose isaias cabrera wrote: >>> >>> Greetings! >>> >>> Imagine these rows in a table named LSOpenJobs: >>> >>> id, PID,subject, bdate, edate, lang,job >>> 1, 232,2008-01-01,2008-01-10,es,trans >>> 2, 232,2008-01-01,2008-

Re: [sqlite] SQLITE3_OPEN returns SQLITE_NOMEM

2008-12-21 Thread hussainfarzana
Dear Kartthi, Hope you have resolved this issue, and we have started 3.6.7 version of Sqlite and now we too got the same error. If you have already solved this and having a solution, kindly guide us so that we could get rid of this issue. Note: We are working with 3.6.1 version of sqlite and it