Re: [sqlite] commit and rollback

2007-11-26 Thread arbalest06
good day! i think its really a good solution to this problem. However, im required to implement the c apis of sqlite..so i need to use the sqlite3_commit_hook and sqlite3_rollback_hook..im doing some prototyping to see their functionalities but i really cant make it work..and i also cant find

Re: [sqlite] commit and rollback

2007-11-28 Thread arbalest06
good day! thanx guys for helping me out..i got it working already..i just misunderstood your solutions, that's why it took me a while to get it right.. =^D now i have another question, still related to this topic, but more on theoretical.. q#1: is it possible that multiple users can write into

Re: [sqlite] commit and rollback

2007-11-28 Thread arbalest06
so there is really no way that multiple processes can write into the database?..but multiple processes can read at the same time right?.. Igor Tandetnik wrote: > > arbalest06 <[EMAIL PROTECTED]> wrote: >> q#1: is it possible that multiple users can write into the database &

RE: [sqlite] commit and rollback

2007-11-28 Thread arbalest06
ses can read at the >>same time right?.. > > --Yes > > -Sreedhar > > > Igor Tandetnik wrote: >> >> arbalest06 <[EMAIL PROTECTED]> wrote: >>> q#1: is it possible that multiple users can write into the database >>> at the same time? >&

Re: [sqlite] commit and rollback

2007-11-28 Thread arbalest06
about this synchronization of multiple writers, can you please explain on how to make this possible? or your just saying that i need to make a daemon that will eventually synchronize the writers? John Stanton-3 wrote: > > Multiple writers merely have to be synchronized. > > arba

[sqlite] maximum number of columns

2007-12-03 Thread arbalest06
good day! i am making an api for an sqlite database. 1 api needs the number of columns in the database. i want to restrict the input by putting a specific range (colNum > 0 and colNum < MAX)..is there any constant in the sqlite3.h that has the value of the maximum number of columns in a table?..

[sqlite] query does not work on sqlite c apis but works on the console

2007-12-20 Thread arbalest06
good day! im implementing a C program that uses the sqlite as my database..im using a global database pointer because im creating my apis for open and close database..my problem is that when i put a select query, the return value is 1..i copied my query to the console of sqlite3 and it worked

Re: [sqlite] query does not work on sqlite c apis but works on the console

2007-12-20 Thread arbalest06
ite3_prepare returns an error code other than SQLITE_OK..mostly, ..SQLITE_ERROR Dennis Cote wrote: > > arbalest06 wrote: >> im implementing a C program that uses the sqlite as my database..im using >> a >> global database pointer because im creating my apis for open and

[sqlite] database column attributes

2007-12-21 Thread arbalest06
good day! i want to create a database with a table that has a column which is a TEXT..i want to specify the maximum length of the text..but i cant do TEXT(20)( ie., 20 characters max )..how can i do this?.. also i would like to specify that this column should be a required field..so if the

Re: [sqlite] database column attributes

2007-12-21 Thread arbalest06
i got it working already..thank you so much!..would this check(length(a) <= 3 also work if the datatype is integer? Igor Tandetnik wrote: > > arbalest06 <[EMAIL PROTECTED]> wrote: >> i want to create a database with a table that has a column which is a >> TEXT..i

[sqlite] memory leak on sqlite3_open

2008-01-04 Thread arbalest06
Good day! I have a C function that would open a database. But when i ran it in valgrind, it gave me the following leak: ==7230== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 16 from 1) ==7230== malloc/free: in use at exit: 272 bytes in 2 blocks. ==7230== malloc/free: 289 allocs, 287

[sqlite] Re[sqlite] trieving only one record in the database

2008-01-25 Thread arbalest06
Good day! I want to retrieve only one record in the database with a condition that may cause a retrieval of many records. The purpose of this is for me to check only if there is at least 1 record in the database. So if given my condition, the query would now search for one record in the database

[sqlite] SQLITE_BUSY frequent error

2008-06-15 Thread arbalest06
://www.mail-archive.com/sqlite-users@sqlite.org/msg28643.html so you guys can check out for yourselves. If anyone can help me go around this problem, please do so. Thank you and God bless! Best regards, arbalest06 -- View this message in context: http://www.nabble.com/SQLITE_BUSY-frequent-error