Page 1 of 1
sqlite3_prepare(...) & sqlite3_reset(...)
Posted: Fri Jul 02, 2010 1:32 pm
by karweru
Hello Rathi,
Pardon my ignorance Rathi. I'm looking at your samples on sqlite and I'm unable to decide exactly what these two statements are for. Kindly shed some light for me.
Thanks in advance.
Re: sqlite3_prepare(...) & sqlite3_reset(...)
Posted: Fri Jul 02, 2010 2:23 pm
by Rathinagiri
From Harbour SQLite library sourcecode:
Compiling An SQL Statement
sqlite3_prepare( db, cSQLTEXT )
-> return pointer to compiled statement or NIL if error occurs
Reset A Prepared Statement Object
sqlite3_reset( pStmt ) -> nResultCode
With the compiled SQL statement, we can know about the column type details.
Re: sqlite3_prepare(...) & sqlite3_reset(...)
Posted: Sat Jul 03, 2010 8:37 am
by karweru
Thanks so much Rathi for this info. I'm still studying your warehouse program and all other posts you have done to this forum to see whether i can adopt sqlite as my choice database.
Re: sqlite3_prepare(...) & sqlite3_reset(...)
Posted: Sat Jul 03, 2010 9:17 am
by Rathinagiri
Oh! Thanks Gilbert. I am overwhelmed.