Nigam Das 30.Jan.11 04:17 AM a Web browser Domino Designer6.5.2Windows XP
Hi,
I am Facing problem in getting the data From a procedure which i called in a subroutine . I am able to get the data of application id and application sequence id but the custmor_id .There is no error is showing in the log file and it is also saying the no of application get exicuted successfully.Please Suggest:::-
Set input_parameters= New LCFieldList
Set output_parameters = New LCFieldList
Set APPLICATION_ID = input_parameters.Append("applicationid", LCTYPE_TEXT)
APPLICATION_ID.text =gblAppNumber
Set APPSEQUENCE_ID = input_parameters.Append("appseqid", LCTYPE_NUMERIC)
APPSEQUENCE_ID.text =gblAppSeqID
Print Cstr(APPSEQUENCE_ID.text(0))
Print Cstr(APPLICATION_ID.text (0))
Set BL_CD_INDICATOR = input_parameters.Append("BL_CD_INDICATOR", LCTYPE_TEXT)
BL_CD_INDICATOR.Text = gblDataSrc
'Execute the stored procedure "usp_xl_completepackage"
countInt= DBConn.call(input_parameters,1,output_parameters)
Set CustomeridValue = output_parameters.Lookup("Customer_id")
Set CnameFieldValues= output_parameters.Lookup("customer_name")
Print Cstr(CustomeridValue.text(0))
Set input_parameters = Nothing
Set output_parameters= Nothing
Return to top
Print this page
