[sqlite] SQLite3 API

[Cousin Stanley]

>> Any plans for distribution of your cobol/sqlite interface ?
> 
> The SQLite3 Interface for GnuCOBOL [sql3i4gc] 
> will soon be available from the Contribution area 
> of the GnuCOBOL Project 
>
>     
>   
> It is being released under the GNU GPLv3
>  

  Robert  

Thanks for your effort and generosity  

I will check the open-cobol sourceforge site
for  sql3i4gc  availability 


-- 
Stanley C. Kitching
Human Being
Phoenix, Arizona

[sqlite] SQLite3 API

[Robert W.Mills (Phoenix)]

| Any plans for distribution of your cobol/sqlite interface ?

The SQLite3 Interface for GnuCOBOL [sql3i4gc] will soon be available 
from the Contribution area of the GnuCOBOL 
 Project. It is being 
released under the GNU GPLv3.

The initial version consists of a file containing documentation, COBOL 
Working-Storage definitions and a set of Macros. You will need to 
download, compile and install the CobolMac 
 
utility (also released under the GNU GPLv3) to enable you to use it.

[sqlite] SQLite3 API

[Cousin Stanley]

> I have written (in COBOL) an SQLite3 interface for GnuCOBOL
>  

  Robert  

Any plans for distribution 
of your cobol/sqlite  interface ?


-- 
Stanley C. Kitching
Human Being
Phoenix, Arizona

[sqlite] SQLite3 API

[Richard Hipp]

On 11/26/15, Robert W.Mills (Phoenix)  wrote:
>
> But how do I get the number of rows UPDATEd or DELETEd?
>

https://www.sqlite.org/c3ref/changes.html

-- 
D. Richard Hipp
drh at sqlite.org

[sqlite] SQLite3 API

[Robert W.Mills (Phoenix)]

To all,

I have written (in COBOL) an SQLite3 interface for GnuCOBOL and would 
like to add a routine that will return the number of rows that were 
selected, updated or deleted by the last executed SQL statement.

I currently have a routine, named DBSQL, that calls sqlite3_prepare_v2, 
sqlite3_step and sqlite3_finalize. I am using this routine for SQL 
statements (INSERT, UPDATE, DELETE, etc.) where any returned data is not 
required. Any data returned by sqlite3_step (SQLITE-ROW is true) is 
being ignored, although I do output a message indicating this has happened.

For SELECT statements I am doing the following (error checking not shown):

set rowcount to zero
call sqlite3_prepare_v2
   call sqlite3_step
   if sqlite-row then
 call sqlite3_column_count
 loop for each column
call sqlite3_column_type *> save value in an array
 end-loop
 loop while sqlite-row
   add 1to rowcount
   loop for each column
call sqlite3_column_x *> where x = int or text
*> save value in avariable
   end-loop
   call routine to process the returned data
   call sqlite3_step
 end-loop
   end-if
   sqlite3_finalize

Using this method I am able to return the number of rows selected and 
with the addition of some code around the DBSQL routine I can keep a 
count of the number of INSERTS.

But how do I get the number of rows UPDATEd or DELETEd?

Please note that I am NOT a C programmer.

regards,
Robert

[sqlite] SQLite3 API Reference omission

[Clark Christensen]

One thing I noticed in the API ref for sqlite3_bind_text()
and sqlite3_bind_blob() is there's no info describing what
the fourth arg is for.  After some trial and error, I
discovered it's to describe the length of the string/blob
in the third arg (duh!) :-)

 -Clark