Great, thanks!
"Kevin English" <kenglish_at_4csoftware.com> wrote in message
news:06d7usg41j4mqbb81tjil99226qg7ul7r3_at_4ax.com...
> John,
> This should work for your first question:
>
> ub4 nrows;
> OCIAttrGet(stmthp,OCI_HTYPE_STMT,&nrows,0,OCI_ATTR_ROW_COUNT,errhp);
>
> On Tue, 10 Oct 2000 20:54:03 +0100, "John Savill"
> <john_at_savilltech.com> wrote:
>
> >Hi,
> >
> >I have an SQL statement which performs an update
> >
> >checkerr(errhp, status=OCIStmtExecute(svchp, stmthp, errhp, (ub4) 1,
(ub4)
> >0,
> > (CONST OCISnapshot *) 0, (OCISnapshot *) 0, (ub4) OCI_DEFAULT));
> >
> >How can I tell how many rows were updated?
> >
> >Also I have another SQL statement
> >
> >sprintf(tempSQL, "UPDATE COMPLETED SET AUDIT_TRAIL='%s',
TS_LASTCHANGE='%s'
> >where MMS_REF='%d'",AUDIT_TRAIL,timeStamp,mmsRefNo);
> >
> >and each time I try to run through OCI it seems incorrectly terminated
> >string but if I take the SQL and run it manually it works fine!
> >
> >Thanks,
> >
> >John
> >
> >john_at_savilltech.com
> >
> >
>
Received on Wed Oct 11 2000 - 12:53:36 CDT
