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.
sqlite3_prepare(...) & sqlite3_reset(...)
Moderator: Rathinagiri
- karweru
- Posts: 220
- Joined: Fri Aug 01, 2008 1:51 pm
- DBs Used: DBF,mysql,mariadb,postgresql,sqlite,odbc
- Contact:
sqlite3_prepare(...) & sqlite3_reset(...)
Kind regards,
Gilbert.
Gilbert.
- 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(...)
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.
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.
South or North HMG is worth.
...the possibilities are endless.
- 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(...)
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.
Gilbert.
- 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(...)
Oh! Thanks Gilbert. I am overwhelmed.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.