Hello:
> Sorry, my fault.
Don't worry ^^
> BTW just quick info, if I write:
> cmd.Parameters.Add("@s", FbDbType.VarChar).Value =3D "";
> provider will ask server for length (on other side no asking =
>
> cmd.Parameters.Add("@s", FbDbType.VarChar, 5).Value =3D "";), right?
Right
Carlos Guzmán Álvarez wrote:
> It should be done in XdrStream for the standalone server GDS implementation.
Damn, you're right, of course. I got FbException with specific error
message and number so I thought it's from server.
Sorry, my fault.
BTW just quick info, if I write:
cmd.Parameters.Add
Hello:
> Are you sure? I was testing this yesterday and nothing was thrown.
It should be done in XdrStream for the standalone server GDS implementation.
case DbDataType.Char:
if (param.Charset.IsOctetsCharset)
{
this.WriteOpaque(param.DbValue.GetBinary(), param.Length);
Not nothing of course. I got error from FB server of course.
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsa
Carlos Guzmán Álvarez wrote:
> The provider checks for char and varchar parameters that the value has a
> correct lenght according to the parameter definition, if it hasn't it
> will raise an exception.
Are you sure? I was testing this yesterday and nothing was thrown.
--
Jiri {x2} Cincura
htt
Hello:
> This question is about the handling of parameter overflow in the
> Firebird.NET Provider. If you do something along these lines:
>
> c:=FbCommand.Create('select * from zip where zip_code=?',
> FbConnection1);
> c.Parameters.Add('', FbDbType.VarChar).Value:='123456'; <<-
Kevin Donn wrote:
> and zip_code is defined to be varchar(5), you'll receive an
> isc_arith_except error. In the Delphi TDataSet world, if you write a
> parameterized query like this, and then supply a value that is too long,
> it will in general be shortened to fit and no error returned or
>
This question is about the handling of parameter overflow in the Firebird.NET
Provider. If you do something along these lines:
c:=FbCommand.Create('select * from zip where zip_code=?', FbConnection1);
c.Parameters.Add('', FbDbType.VarChar).Value:='123456'; <<-- note 6
chars
