Re: [sqlite] Problem with sqlite3_exec

2014-03-17 Thread khaloud1987
Thank you Kees Nuyt It solves the problem. -- View this message in context: http://sqlite.1065341.n5.nabble.com/Problem-with-sqlite3-exec-tp74523p74579.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlit

Re: [sqlite] Problem with sqlite3_exec

2014-03-15 Thread Kees Nuyt
On Fri, 14 Mar 2014 07:56:57 -0700 (PDT), khaloud1987 wrote: > the problem arises when I am trying to erase lines and I have a power failure > so that it deletes rows but sometimes I have a line that is deleted from the > first table and not from the second. > (yes i have a table with this name t

Re: [sqlite] Problem with sqlite3_exec

2014-03-14 Thread khaloud1987
the problem arises when I am trying to erase lines and I have a power failure so that it deletes rows but sometimes I have a line that is deleted from the first table and not from the second. (yes i have a table with this name table2 and i can't read the return value when it fails caused by the pow

Re: [sqlite] Problem with sqlite3_exec

2014-03-13 Thread Igor Tandetnik
On 3/13/2014 6:33 AM, khaloud1987 wrote: I have a problem with sqlite3_exec that the first delete execute suuccesfully but the second delete (table2) does not. My qustion is : sqlite_exec can return a value different with SQLITE_OK and it works ok What value does the second call return?

[sqlite] Problem with sqlite3_exec

2014-03-13 Thread khaloud1987
Hello, I have a problem with sqlite3_exec that the first delete execute suuccesfully but the second delete (table2) does not. My qustion is : sqlite_exec can return a value different with SQLITE_OK and it works ok this is my code: snprintf(query,q_size,"DELETE FROM " table1 " where record

Re: [sqlite] problem with sqlite3_exec() and select sql statemant

2008-10-14 Thread John Stanton
Use the correct SQL delimiter for a literal - single quotes, e.g. 'google.com'. Hari wrote: > Hi as i am new to sqlite. > I have problem when i am using sqlite3_exec() function with select > as i am using sqlite3_open() to opening database > then creating table and inserting some information usi

Re: [sqlite] problem with sqlite3_exec() and select sql statemant

2008-10-14 Thread Martin.Engelschalk
Hello Hariom, - use single quotes around text constants: select * from my_table where Primarykey='google.com' - use sqlite3_prepare and sqlite3_step to select data. First call sqlite3_prepare for your statement and then sqlite3_step in al loop until it returns SQLITE_DONE - It is not an error i

[sqlite] problem with sqlite3_exec() and select sql statemant

2008-10-14 Thread Hari
Hi as i am new to sqlite. I have problem when i am using sqlite3_exec() function with select as i am using sqlite3_open() to opening database then creating table and inserting some information using sqlite3_exec() and 'create table' and 'insert into' then again if i use sqlite3_exec() with select l

[sqlite] problem with sqlite3_exec method

2006-08-12 Thread Py Olivier
Hello, I'm sorry but even after looking in the archives I haven't found any help on this subject : I'm testing a very simple C program that uses SQLite. The sqlite3_open method works fine and the database opens normaly, but then I get an error coming from the sqlite3_exec method : sqlite3_exec(d