I'm trying to run a stored procedure that reads in an id, copies the record in the
database, and then returns the new id.
I've tried everything I can think of, but it doesn't work. I don't get any errors,
according to the checks, the DO succeeded, but nothing happens.
Here's the code I'm using:
CSpProcedure spCopy = (CSpProcedure)
CSpider.getDataObject(PROC_COPY_CCP);
spCopy.clearAllValues();
spCopy.setValue("spCcpId", ccpIdentifier);
int spResult = spCopy.execute();
if (spCopy.succeeded () && (spResult != STOP_PROCESSING))
{
SpLog("Succeeded without a stop processing result");
//ccpIdentifier = (CSpLong) spCopy.getValue(0,"srNewId");
SpLog("Retrieving? :" + spCopy.isRetrieving());
SpLog("Modifying? :" + spCopy.isModifying());
SpLog("Error Code: "+spCopy.getErrorCode());
SpLog("Testing : "+ spCopy.getValue(0, "srOut"));
ccpIdentifier = new
CSpLong(spCopy.getValue(0,"srOut").longValue());
SpLog("Got the ID");
}
SpLog("ID is " + ccpIdentifier);
Any suggestions?
---Seth Rutledge
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
