sqlite3_prepare(...) & sqlite3_reset(...)

Topic Specific Tutorials and Tips.

Moderator: Rathinagiri

Post Reply
User avatar
karweru
Posts: 220
Joined: Fri Aug 01, 2008 1:51 pm
DBs Used: DBF,mysql,mariadb,postgresql,sqlite,odbc
Contact:

sqlite3_prepare(...) & sqlite3_reset(...)

Post 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.
Kind regards,
Gilbert.
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: sqlite3_prepare(...) & sqlite3_reset(...)

Post 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.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
karweru
Posts: 220
Joined: Fri Aug 01, 2008 1:51 pm
DBs Used: DBF,mysql,mariadb,postgresql,sqlite,odbc
Contact:

Re: sqlite3_prepare(...) & sqlite3_reset(...)

Post 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.
Kind regards,
Gilbert.
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: sqlite3_prepare(...) & sqlite3_reset(...)

Post by Rathinagiri »

Oh! Thanks Gilbert. I am overwhelmed.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
Post Reply