Date Time - From & To Passing
Dear All,
I use CRPE to pass the FromDatetime & ToDateTime to the stored procedure being called by the CR8.5 .
For the reports where I use just 1 input DateTime, my application works fine,
Ex: SetParamField ( 1, DateStr )
but , when I try to do:
SetParamField ( 1, FromDateStr )
SetParamField ( 2, ToDateStr )
I get "Error Detected in Database DLL".
Can anyone help me .
Here's my small piece of code for your reference .
if (!PEConvertVInfoToPFInfo(ptrPEValueInfo
, &ptrPEValueInfo->valueType
, ptrPEParameterFieldInfo->CurrentValue)) {
throw new CCrystalException( m_printJob->GetErrorText() );} // if
}
objPEParameterFieldInfo.CurrentValueSet = 1;
// Set the parameter field value
if (!PESetNthParameterField(m_printJob->GetJobHandle (), nth, ptrPEParameterFieldInfo)) {
throw new CCrystalException( m_printJob->GetErrorText() ); } // if
Thanks & Regards
Sankar
|