[patch_done] Error Param.DataType in TZStoredProcedure
Posted: 10.03.2010, 23:08
Hi,
Maybe this is reported already, but if I use TZStoredProc and a string parameter as input, I receive Param.Datatype unknown error (line 221 : raise EZDatabaseError.Create(SUnKnownParamDataType);)
After debugging TZStoredProc.SetStatementParams, I noticed that the string parameter is passed as WideString (I don't have any idea why it's passed as Widestring and not as string. The string is only 20 chracters long. Anyway when I add ftWidestring, it is working.
Line 181 :
ftString , ftFixedChar:
Statement.SetString(I+1, Param.AsString);
Changed to :
ftString , ftWideString, ftFixedChar:
Statement.SetString(I+1, Param.AsString);
I hope the way I did it is correct ?
Anyway after recompiling the library, everything is working fine...
Best regards and thanks !
Nico Callewaert
Maybe this is reported already, but if I use TZStoredProc and a string parameter as input, I receive Param.Datatype unknown error (line 221 : raise EZDatabaseError.Create(SUnKnownParamDataType);)
After debugging TZStoredProc.SetStatementParams, I noticed that the string parameter is passed as WideString (I don't have any idea why it's passed as Widestring and not as string. The string is only 20 chracters long. Anyway when I add ftWidestring, it is working.
Line 181 :
ftString , ftFixedChar:
Statement.SetString(I+1, Param.AsString);
Changed to :
ftString , ftWideString, ftFixedChar:
Statement.SetString(I+1, Param.AsString);
I hope the way I did it is correct ?
Anyway after recompiling the library, everything is working fine...
Best regards and thanks !
Nico Callewaert