From: David S. W. <dw...@us...> - 2005-01-17 21:08:25
|
Update of /cvsroot/xsb/XSB/docs/userman/odbc_man In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv13212 Modified Files: odbc_man.tex Log Message: Added documentation for odbc_sql_cnt/4, a new predicate to call UPDATE, INSERT, and DELETE SQL statements. It returns the number of affected rows in the fourth argument. Index: odbc_man.tex =================================================================== RCS file: /cvsroot/xsb/XSB/docs/userman/odbc_man/odbc_man.tex,v retrieving revision 1.14 retrieving revision 1.15 diff -u -r1.14 -r1.15 --- odbc_man.tex 7 Dec 2004 15:29:43 -0000 1.14 +++ odbc_man.tex 17 Jan 2005 21:08:00 -0000 1.15 @@ -229,6 +229,19 @@ Note that to include a quote (') in an atom, it must be represented by using two quotes. +There is also a predicate: +\begin{verbatim} +| ?- odbc_sql_cnt(ConnectionName,BindVals,SQLStmt,Count). +\end{verbatim} +\index{\texttt{odbc\_sql\_cnt/4}} + +This predicate is very similar to {\tt odbc\_slq/4} except that it can +only be used for UPDATE, INSERT, and DELETE SQL statements. The first +three arguments are just as in {\tt odbc\_slq/4}; the fourth must be a +variable in which is returned the integer count of the number of rows +affected by the SQL operation. + + \subsection{Cursor Management} \label{odbc:cursors} %======================================================= |