So here’s the deal, I am using a script to run a stored procedure in MSSQL, I get a dataset returned “Dataset [1R ? 1C]”
How do I print that value? Apparently the Stored procedure is returning the column name and the value
Here’s my code:
scanRead = 'C7717343800011'
call = system.db.createSProcCall("spGetCartonLaneAssignment")
call.registerInParam(1, system.db.VARCHAR, scanRead)
laneAssignment = call.getResultSet()
The last line “print laneAssignment” I want to just return “2” For the life of me I cannot figure this out. Should be simple?