[ok] Error in dbexpida40.dll

sdm · Post by **sdm** » Tue 14 Sep 2010 12:04

hello,

With CodeGear C++ 2009, and with DbxIda250,
ifi execute a Select Query, i've got a such message :

It appears if there is a special character (é , à, è, ....) in a Blob-text field (in the query). With Firebird 2.1.3.18185.

Thank you for your advices.

sdm · Post by **sdm** » Tue 14 Sep 2010 14:09

do you need another informations to describe the problem ?

sdm · Post by **sdm** » Tue 14 Sep 2010 19:30

hello,

With this topic,
http://www.devart.com/forums/viewtopic. ... 6bd4fb6392
I found the solution :

I did a function to set the value of a blob-text-field-parameter

Code: Select all

void SetFieldByName_BlobText(TSQLQuery * Req, AnsiString NomChamp, AnsiString val)
{
   /// Req->ParamByName(NomChamp)->AsMemo = val;  // failed ! :-/

   Req->ParamByName(NomChamp)->DataType  = ftWideMemo;
   Req->ParamByName(NomChamp)->ParamType = ptInput;
   Req->ParamByName(NomChamp)->Value     = val;

}

thanks all

AndreyZ · Post by **AndreyZ** » Wed 15 Sep 2010 05:44

It's good to see that this problem has been solved. If any other questions come up, please contact me.