[ok] Error in dbexpida40.dll

[ok] Error in dbexpida40.dll

Postby 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 :

Image

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.
Last edited by sdm on Tue 14 Sep 2010 19:40, edited 1 time in total.
sdm
 
Posts: 6
Joined: Fri 12 Feb 2010 09:28

Postby sdm » Tue 14 Sep 2010 14:09

do you need another informations to describe the problem ?
sdm
 
Posts: 6
Joined: Fri 12 Feb 2010 09:28

Postby sdm » Tue 14 Sep 2010 19:30

hello,

With this topic,
http://www.devart.com/forums/viewtopic.php?t=14200&sid=7efb3868d198973e07a4ed6bd4fb6392
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
sdm
 
Posts: 6
Joined: Fri 12 Feb 2010 09:28

Postby 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.
AndreyZ
 


Return to dbExpress driver for InterBase & Firebird