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
