[patch_done] Error Param.DataType in TZStoredProcedure

The alpha/beta tester's forum for ZeosLib 7.0.x series

Report problems concerning our Delphi 2009+ version and new Zeoslib 7.0 features here.

This is a forum that will be removed once the 7.X version goes into stable!!

Moderators: gto, EgonHugeist, olehs

Locked
nico.callewaert
Fresh Boarder
Fresh Boarder
Posts: 6
Joined: 07.12.2009, 12:23
Location: Belgium

[patch_done] Error Param.DataType in TZStoredProcedure

Post by nico.callewaert »

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
User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Post by mdaems »

SVN REV 798.

Thanks for the patch,

Mark
Image
nico.callewaert
Fresh Boarder
Fresh Boarder
Posts: 6
Joined: 07.12.2009, 12:23
Location: Belgium

Post by nico.callewaert »

Thank you Mark !!
Locked