[sqlite] How to write the trigger?

I created a table like this： CREATE TABLE record_trip (trip_id CHAR(1), gp_no CHAR(1), rec_date INTEGER, trun CHAR(1), ctrl_id CHAR(1), moment_value INTEGER, minutes_value INTEGER, set_value INTEGER ); CREATE UNIQUE INDEX i_record_trip ON record_trip (trip_id, gp_no, rec_date); And the trigger

Re: [sqlite] Doesn't update return wrong code while there isn't record in table?

Thank you for you reply, :) But I see the return errmsg is "unknown error" on sqlite3.6.23-1. What does it mean? Kees Nuyt wrote: > > On Mon, 24 May 2010 01:27:05 -0700 (PDT), liubin liu > <7101...@sina.com> wrote: > > >> Doesn't update return wr

[sqlite] Doesn't update return wrong code while there isn't record in table?

Doesn't update return wrong code while there isn't record in table? Is it normal action? _code__ #include #include void create_db (void); int main (void) { int ret = -1; create_db (); sqlite3 *db = NULL; ret = sqlite3_open

[sqlite] the wrong in building sqlite-3.6.23.1 on Fedora-7.0

the original version of sqlite in fedora is 3.4.2. I built the newest version on Fedora-7.0. And get the the wrong in building sqlite-3.6.23.1 on Fedora-7.0 like below: ./libtool --mode=compile --tag=CC gcc -g -O2 -DSQLITE_OS_UNIX=1 -I. -I../SQLite-b078b588d617e078/src -D_HAVE_SQLITE_CONFIG_H

Re: [sqlite] multi processes, so many errores of SQLITE_BUSY and SQLITE_MISUSE

I assume you want the sqllite3_stmt to work -- so you need to loop that >> while it's busy. >> >> Michael D. Black >> Senior Scientist >> Northrop Grumman Mission Systems >> >> >> >> >> From: sqlite-users-boun

Re: [sqlite] multi processes, so many errores of SQLITE_BUSY and SQLITE_MISUSE

ad-onliy > operations (like SELECT).It's just the write operations > (INSERT/UPDATE) which will cause SQLITE_BUSY to occur. > > Michael D. Black > Senior Scientist > Northrop Grumman Mission Systems > > > > > From: sqlite-us

Re: [sqlite] multi processes, so many errores of SQLITE_BUSY and SQLITE_MISUSE

is in sqlrun.c with looping and killing. Looks > pretty squirrely to me. You're not waiting for the forks to finish so > what is your logic here? > > Michael D. Black > Senior Scientist > Northrop Grumman Mission Systems > > > >

[sqlite] multi processes, so many errores of SQLITE_BUSY and SQLITE_MISUSE

Multi processes, getting so many errores of SQLITE_BUSY and SQLITE_MISUSE... And the system performance is very bad because of the three processes of insert/read/update database. How to improve the sqlite3's operations? _my codes___

Re: [sqlite] Is there any memory leak in the normal routine?

te3_exec (db=0x2acd74d28c10, > zSql=0x47b358 "CREATE TABLE data_his (id INTEGER PRIMARY KEY, d1 > CHAR(16))", xCallback=0, pArg=0x0, > pzErrMsg=0x0) at sqlite3.c:76835 > #22 0x00401d8a in main () at thread.c:16 > > > > Michael D. Black > Senior Sc

Re: [sqlite] Is there any memory leak in the normal routine?

And I watch the the process's run by top. At first, the memory statistics is: PID PPID USER STAT VSZ%MEM %CPU COMMAND 17731 15488 root S1104 5% 7% ./sqlite3multiwrite When the printf() prints the 150, the memory statistics is: PID PPID USER

[sqlite] Is there any memory leak in the normal routine?

A routine of sqlite3_prepare_v2() + sqlite3_step() + sqlite3_finalize() could contain leak. It sound ridiculous. But the test code seems to say it. Or I used the sqlite3_* wrongly. __code__ #include #include // for usleep() #include int

Re: [sqlite] Is there any memory leak in the code while being busy?

)'s return code is wrong, and the memory pointed by p_stmt isn't freed by sqlite3_finalize()? Simon Slavin-3 wrote: > > > On 23 Apr 2010, at 1:16pm, liubin liu wrote: > >> But I test the routine of sqlite3_prepare_v2() + sqlite3_step() + >> sqlite3_finalize() in my rea

Re: [sqlite] Is there any memory leak in the code while being busy?

sqlite3_mprintf (sql_f, i); > ret = sqlite3_prepare_v2 (db1, sql, -1, _stmt, NULL); > sqlite3_free(sql); > > > Michael D. Black > Senior Scientist > Northrop Grumman Mission Systems > > > > > From: sqlite-user

Re: [sqlite] Is there any memory leak in the code while being busy?

d your question multible times... ;) > > to answer: what makes you think that sqlite3_finalize can't > free the prepared statement ? > > liubin liu wrote: >> Is there any memory leak in the code? >> >> Below is the code. Is there any memory leak in the pthread2?

[sqlite] Is there any memory leak in the code while being busy?

Is there any memory leak in the code? Below is the code. Is there any memory leak in the pthread2? While pthread1 is using test.db exclusively, the sqlite3_prepare_v2() of pthread2 still prepares the p_stmt pointer to a piece of memory malloced by sqlite3_preapare_v2(). And then the

[sqlite] Is there any memory leak in the code ?

Is there any memory leak in the code? Below is the code. Is there any memory leak in the pthread2? While pthread1 is using test.db exclusively, the sqlite3_prepare_v2() of pthread2 still prepares the p_stmt pointer to a piece of memory malloced by sqlite3_preapare_v2(). And then the

[sqlite] Is there any memory leak in the code?

Below is my code. My question is: Is there any memory leak in the pthread2? While pthread1 is using test.db exclusively, the sqlite3_prepare_v2() of pthread2 still prepares the p_stmt pointer to a piece of memory malloced by sqlite3_preapare_v2(). And then the sqlite3_finalize() can't free the

[sqlite] why block at sqlite3_prepare_v2(*)?

my program is blocked at the point of sqlite3_prepare_v2(*). Why? 512 513 sqlite3_stmt *p_stmt = NULL; 514 printf (" ### 500, %p, %s, %p\n", g_db_base, sql, p_stmt); 515 ret = sqlite3_prepare_v2 (g_db_base, sql, -1, _stmt, NULL); 516 printf ("

[sqlite] why block at sqlite3_prepare_v2(*)?

my program is blocked at the point of sqlite3_prepare_v2(*). Why? 512 513 sqlite3_stmt *p_stmt = NULL; 514 printf (" ### 500, %p, %s, %p\n", g_db_base, sql, p_stmt); 515 ret = sqlite3_prepare_v2 (g_db_base, sql, -1, _stmt, NULL); 516 printf ("

Re: [sqlite] to get 2 records after a special records. But wrong count, the count is 5

Thanks, I've gotten the point, :) and the next question is that how to know the true count after a special record while getting a special number records. P Kishor-3 wrote: > > On Sun, Mar 21, 2010 at 9:19 PM, liubin liu <7101...@sina.com> wrote: >> >> >> my app

[sqlite] to get 2 records after a special records. But wrong count, the count is 5

my application is like below. To get 2 records after a special records. But wrong count, the count is 5: sqlite> sqlite> CREATE TABLE t1 (id INTEGER PRIMARY KEY, data INTEGER); sqlite> INSERT INTO t1 VALUES (3, 999); sqlite> INSERT INTO t1 VALUES (2, 989); sqlite> INSERT INTO t1 VALUES (4,

[sqlite] How to patch several sql words into one words

I want to insert several pieces of data (include blob) into a table in a transaction by programing in C language , like: char *sql[n+2]; sql[0] = sqlite3_mprintf ("BEGIN;"); char *sql_f = "INSERT OR REPLACE INTO collstate VALUES (%d, %d, ?);"; for (i=1; i

[sqlite] one column is another table's row num

I want to create two tables like: create table t1 (id INT PRIMARY KEY, cont TEXT); create table t2 ({select count(*) from t1} INT); How could I do it? -- View this message in context: http://old.nabble.com/one-column-is-another-table%27s-row-num-tp27940860p27940860.html Sent from the SQLite

[sqlite] why SQLITE_BUSY when read the database

why SQLITE_BUSY when read the database My application suffered a problem that sqlite3_step(*) of SELECT returns SQLITE_BUSY. I know "Multiple processes can be doing a SELECT at the same time. But only one process can be making changes to the database at any moment in time, however." from the

[sqlite] how to show the equivalent hex value of integer data while select in sqlite3 shell?

how to show the equivalent hex value of integer data while select in sqlite3 shell? sqlite> sqlite> CREATE TABLE test (id INTEGER, data INTEGER); sqlite> INSERT INTO test VALUES (1, 32); sqlite> SELECT * FROM test; 1|32 sqlite> sqlite> sqlite> SELECT hex(data) FROM test; 3332 ### hope to

Re: [sqlite] speed, writing spends 30ms, reading spends 2ms, still slow

The environment is: Linux at91sam9260nand 2.6.25.10 SQLite 3.6.5 liubin liu wrote: > > the process runs on a board with Atmel AT91SAM9260 (Clocks: CPU 198 MHz, > ...), Memory: 16MB, yaffs on NAND 256MB. > > the time of writing one row is more than 20mS, and the time of re

[sqlite] speed, writing spends 30ms, reading spends 2ms, still slow

the process runs on a board with Atmel AT91SAM9260 (Clocks: CPU 198 MHz, ...), Memory: 16MB, yaffs on NAND 256MB. the time of writing one row is more than 20mS, and the time of reading one row is more than 3mS. Is it the ceiling of the SQLite3? If no, how to improve it? espically improving the

Re: [sqlite] how to show blob data while select in sqlite3 shell?

Thanks!!! SimonDavies wrote: > > 2009/12/9 liubin liu <7101...@sina.com>: >> >> sqlite> INSERT OR REPLACE INTO periods_value VALUES (0, 1, >> x'000102030400a0afaabbaa'); >> sqlite> >> sqlite> SELECT * FROM periods_value; >> 0|1| >>

[sqlite] how to show blob data while select in sqlite3 shell?

[...@** createdb]$ [...@** createdb]$ sqlite3 ./db_ctrl_0.1.db SQLite version 3.6.5 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> CREATE TABLE periods_value (id INTEGER PRIMARY KEY, valid CHAR(1), value BLOB ); sqlite> sqlite> INSERT OR REPLACE INTO

Re: [sqlite] sqlite3 is blocked by transaction when wanting to close the sqlite3 *

in process sends message to other process and when other > process receives it then it closes its database connection... > > Pavel > > On Sun, Nov 29, 2009 at 7:46 PM, liubin liu <7101...@sina.com> wrote: >> >> Thank you! >> >> I'm sorry for not

Re: [sqlite] sqlite3 is blocked by transaction when wanting to close the sqlite3 *

other > process receives it then it closes its database connection... > > Pavel > > On Sun, Nov 29, 2009 at 7:46 PM, liubin liu <7101...@sina.com> wrote: >> >> Thank you! >> >> I'm sorry for not showing clearly the environment is embedded linux on >> arm >

Re: [sqlite] sqlite3 is blocked by transaction when wanting to close the sqlite3 *

); ... } ... } liubin liu wrote: > > I do the job as you say, but the problem is still here. > > There are several processes who write the database. And the place is not > same each time that the problem happens. > > How could I know the reason exactly? > >

Re: [sqlite] sqlite3 is blocked by transaction when wanting to close the sqlite3 *

se connection... > > Pavel > > On Sun, Nov 29, 2009 at 7:46 PM, liubin liu <7101...@sina.com> wrote: >> >> Thank you! >> >> I'm sorry for not showing clearly the environment is embedded linux on >> arm >> board. >> >> Bec

Re: [sqlite] sqlite3 is blocked by transaction when wanting to close the sqlite3 *

her > process, and call it from the main process when you shut down? > > Nick. > > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of liubin liu > Sent: 26 November 2009 02:29 > To: sqlite-users@sqlite

[sqlite] sqlite3 is blocked by transaction when wanting to close the sqlite3 *

My application includes a main process and some other processes. I open the database in other process, but at end I will close the database in main process. The problem happens while I close the database. The main process is blocked. And I could see the journal file is still there, so I guess

Re: [sqlite] How to input a double num?

Thank you! I mayn't need the high precision like "212345678901234567890123456.988290112". John Crenshaw-2 wrote: > >> May I use sqlite3_bind_double() and sqlite3_prepare_v2() to solve the >> problem. > > That won't fix it. Your number is too large to fit in any native data > type. Even the

Re: [sqlite] How to input a double num?

Thanks a lot for every reply. The num is just random num. The project is on power-measurement. So there are some big nums with high precision. May I use sqlite3_bind_double() and sqlite3_prepare_v2() to solve the problem. liubin liu wrote: > > Now I use the sqlite3_mprintf() and t

[sqlite] How to input a double num?

Now I use the sqlite3_mprintf() and the "%f" to get the double num. My code is below. Now there is a num like "212345678901234567890123456.988290112". With the way of "sqlite3_mprintf()" and "%f", the num is cut to "2123456789012346000.00". How to input the num

Re: [sqlite] how to get the records matching some two characters?

Thanks! This is what I need, :) Jay A. Kreibich-2 wrote: > > On Mon, Aug 31, 2009 at 06:33:08PM -0700, liubin liu scratched on the > wall: >> >> create table and index： >> CREATE TABLE data_rt ( id INTEGER, dataid CHAR(4), data CHAR(12), >> rec_

[sqlite] how to get the records matching some two characters?

create table and index： CREATE TABLE data_rt ( id INTEGER, dataid CHAR(4), data CHAR(12), rec_time INTEGER, data_type CHAR(1) ); CREATE UNIQUE INDEX i_drt ON data_rt ( id, dataid ); there are data in the table of data_rt： sqlite> SELECT * FROM data_rt; 6|1290|7e22473a|857000|22

Re: [sqlite] How to create a data of unsigned int?

e data of type unsigned int. And int64 is > exactly the type used for all integers in SQLite. > > Pavel > > On Fri, Aug 7, 2009 at 5:53 AM, liubin liu<7101...@sina.com> wrote: >> >> I want to use a integer to save the ip address of ipv4. Because they all >> are >

[sqlite] How to create a data of unsigned int?

I want to use a integer to save the ip address of ipv4. Because they all are 4 bytes. but it is better when the data type is unsigned int. How to create a data of unsigned int? 1334 1335 // tcp->gate_addr[0]是地址的高8位 1336 for ( i=0, m=1; i<4; i++, m*=0x100 ) 1337 gateaddr =

[sqlite] two question, 1.)sqlite3's select? 2.)errno and the sqlite3's result code

1.)How does sqlite3's select work? Does it need to seach for all the records? 2.)Is there any relation between errno and the sqlite3's result code? -- View this message in context:

Re: [sqlite] is the sqlite3's C-api used in thread-safety mode ? or non-reentrant?

t; some specially designed functions. > > Pavel > > On Thu, Jul 9, 2009 at 3:52 AM, liubin liu<7101...@sina.com> wrote: >> >> does it mean that the sqlite3's C-api isn't reentrant or thread-safety? >> >> >> ___

Re: [sqlite] is the sqlite3's C-api used in thread-safety mode ? or non-reentrant?

t for > some specially designed functions. > > Pavel > > On Thu, Jul 9, 2009 at 3:52 AM, liubin liu<7101...@sina.com> wrote: >> >> does it mean that the sqlite3's C-api isn't reentrant or thread-safety? >> >> >> ___

[sqlite] is the sqlite3's C-api used in thread-safety mode ? or non-reentrant?

does it mean that the sqlite3's C-api isn't reentrant or thread-safety? #include // for printf() #include // for signal() #include // for alarm() #include // for system() #include // for pthread_create()

[sqlite] there is problem when getting data by sqlite3's c apis in signal-handling func

there is problem when getting data by sqlite3's c apis in signal-handling func. _ #include // for printf() #include // for signal() #include // for alarm() #include // for system() #include // for

Re: [sqlite] why is the data file locked after after using transaction?

You are right I have mend the fault, ^_^ Thank You a lot! Igor Tandetnik wrote: > > liubin liu wrote: >> why is the data file locked after after using transaction? >> >> the last result of printf() is: >> # IN END, ret = 5 >> >> It means to the data

[sqlite] why is the data file locked after after using transaction?

why is the data file locked after after using transaction? the last result of printf() is: # IN END, ret = 5 It means to the database file is locked? why does it happen after using transaction although using sqlite3_finalize()? PS: if shielding the codes relating with the transaction, all the

[sqlite] why is the data file locked after writing?

why is the data file locked after writing? the last printf() result is: # IN END, ret = 5 according to the "Result Codes": #define SQLITE_BUSY 5 /* The database file is locked */ It means to the database file is locked? why does it happen after writing?

Re: [sqlite] how to compose the sql sentence?

at) VALUES (12, '1290', '732e4a39', 8323000, 8323255, 22); Simon Slavin-2 wrote: > > > On 3 Jun 2009, at 7:05am, liubin liu wrote: > >> the first step is to tell if there is the data in the table. >> if the answer is not, I want to insert a row of data into th

Re: [sqlite] how to compose the sql sentence?

pending on your database design, declare a primary key with these > three fields. > > Second, the error message says it all: You supplied three column - > names, but 6 values. > > Martin > > liubin liu schrieb: >> Thank you a lot! >> >> >> I creat

Re: [sqlite] how to compose the sql sentence?

; or - depending on your database design, declare a primary key with these > three fields. > > Second, the error message says it all: You supplied three column - > names, but 6 values. > > Martin > > liubin liu schrieb: >> Thank you a lot! >> >> >> I cr

Re: [sqlite] how to compose the sql sentence?

the biggest > issue is you only supplied 3 column names but in the values list you have > 6 values. >   > > > --- On Thu, 6/4/09, liubin liu <7101...@sina.com> wrote: > > > From: liubin liu <7101...@sina.com> > Subject: Re: [sqlite] how to compose the

Re: [sqlite] how to compose the sql sentence?

rror: 6 values for 3 columns Does It mean the method isn't the right way? Simon Slavin-2 wrote: > > > On 3 Jun 2009, at 7:05am, liubin liu wrote: > >> the first step is to tell if there is the data in the table. >> if the answer is not, I want to insert a row of data in

[sqlite] how to compose the sql sentence?

the first step is to tell if there is the data in the table. if the answer is not, I want to insert a row of data into the table if the answer is yes, I need to update the row of data acccording to the data inputting from me. -- View this message in context:

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

Thanks! It sounds pretty good. But I don't understand it exactly. Could you write down the sample codes? Matthew L. Creech wrote: > > On Mon, Apr 27, 2009 at 10:25 PM, liubin liu <7101...@sina.com> wrote: >> >> thanks >> >> I'm not sure of the real

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

thanks I'm not sure of the real reason. It's true that the speed of inserting with transaction is very fast. But my project is using SQLite mainly in selecting something. I don't know how to use transaction in the situation. May some friends give me some codes on that? My application needs some

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

Thanks I amend the code according to your message. Marcus Grimm wrote: > > in your test code I see that you open the sqlite DB > each time you perform the single query. > I guess it would be fair to open the sqlite DB only once > outside your test loop. > 2nd: You query against ID without an

[sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

our project is using sqlite3, but found that the speed is too slow. I just tested the BerkeleyDB, and found that the speed is very fast. But I knew the sqlite3 is fast enough. And so I'm confused. I may be using sqlite3 in wrong way? anyway, next is my test code. I'm glad to receive your

Re: [sqlite] which func could get the number of rows

Yes, sqlite3_get_table() is good to handle the mission. and I am always using it. but I found that the prefomance was a little weak. and so I want to get some other API to handle the same mission. Kees Nuyt wrote: > > On Sat, 7 Mar 2009 01:09:28 -0800 (PST), liubin liu > <7101

Re: [sqlite] Are there distillate posts in the sqlite3 board?

inking of posts that were made under the influence of > distillates? :) > > g > > -Original Message- > From: liubin liu [mailto:7101...@sina.com] > Sent: Friday, March 06, 2009 2:39 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] Are there distillate posts i

Re: [sqlite] which func could get the number of rows

009 02:15:10 -0800 (PST), liubin liu > <7101...@sina.com> wrote: > >>which func could get the number of rows? > > There is no function to retrieve the number of rows in a > result set. SQLite doesn't know the number in advance, but > returns row by row while iterating t

[sqlite] which func could get the number of row

which func could get the number of row? -- View this message in context: http://www.nabble.com/which-func-could-get-the-number-of-row-tp22369246p22369246.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list

[sqlite] Are there distillate posts in the sqlite3 board?

are there any distillate posts in the sqlite3 board ? -- View this message in context: http://www.nabble.com/Are-there-distillate-posts-in-the-sqlite3-board--tp22368215p22368215.html Sent from the SQLite mailing list archive at Nabble.com. ___

Re: [sqlite] manual with sample C programs

there are many errors in the codes. but still worthwhile to go through them carefully. liubin liu wrote: > > This's very good! > > I just download the codes from here: > http://www.apress.com/book/downloadfile/2847 > > > dcharno wrote: >> >>

Re: [sqlite] manual with sample C programs

This's very good! I just download the codes from here: http://www.apress.com/book/downloadfile/2847 dcharno wrote: > >> Could you tell me where can I find such documentation, or can you >> recommend some books. > > "The Definitive Guide to SQLite" by Michael Owens explains the SQLite > API

Re: [sqlite] a question on the callback function's return values of sqlite3_exec()

: > > "liubin liu" <7101...@sina.com> wrote in message > news:22176984.p...@talk.nabble.com >> the question is on the callback function's return values of >> sqlite3_exec() >> >> when using sqlite3_exec() to do "select * from ...", how to

[sqlite] a question on the callback function's return values of sqlite3_exec()

the question is on the callback function's return values of sqlite3_exec() when using sqlite3_exec() to do "select * from ...", how to get all the return values by using the callback function? struct olt_info { int olt_index; int olt_logo; char* olt_line; // int nmber; }; int