BBjStoredProcedureData::setUpdateCount

Description

In BBj 6.0 and higher, this method sets the insert/update/delete count for the stored procedure.

Syntax

Return Value

Method

void

setUpdateCount(int p_updateCount)

Parameters

Variable

Description

p_updateCount

The number of inserted/updated/deleted rows.

Return Values

None.

Remarks

Either this method or setResultSet can be called once. Subsequent invocations result in an !ERROR=207 (BBJ_STATE).

Example

REM Error trapping
    seterr ERROR_ROUTINE
    setesc ERROR_ROUTINE

REM Declares
    declare BBjStoredProcedureData sp!

REM Get a Stored Procedure object from the BBj File System
    sp! = BBjAPI().getFileSystem().getStoredProcedureData()

REM Get the parameters from the application
    CUST_NUM$ = sp!.getParameter("CUST_NUM")


REM Do whatever you need to do here, which would typically include
REM updating records from one or more tables

REM Now set the updatecount so the client knows how many records
REM were affected by calling this stored procedure
    sp!.setUpdateCount(15)



EOP:
    release


ERROR_ROUTINE:
    SETERR EOP

    java.lang.System.out.println("SPROC Error @ " + DATE(0:"%Yl-%Mz-%Dz %Hz:%mz:%sz"))
    msg$ = "Error #" + str(err) + " occured in " + pgm(-1) + " at line " + str(tcb(5))
    if err = 77 then msg$ = msg$ + $0d0a$ + "SQL Err: " + sqlerr(chan)
    java.lang.System.out.println(msg$)
    sp!.setReturn(0)
    release

See Also

BBjAPI

BBjStoredProcedureData

ObjectVariables

See the BBj Object Diagram for an illustration of the relationship between BBj Objects.