What's interesting, though, is that I still got the error with FbDbType set to Text as well.  Shouldn't that have worked, even with the size specified?

Thanks,
Jess


On 4/11/06, Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote:
Hello:
>             fbParam.DbType = System.Data.DbType.String;

With this when infering the data type it will be set as a VarChar field.

>             //fbParam.Size = 250;

Now if you give the size, when executing the command the parameter will
be automagically described as VarChar(250)
instead of a text blob ( there are no request to the server to describe
the command unless it's really needed ), if you left
the parameter without the size, when trying to describe the parameter it
will be VarChar(??) and will do a request to the server to describe it,
what more than probably will get the right data type ( blob sub_type
text :P )


Hope this helps.


--
Carlos Guzmán Álvarez
Vigo-Spain

http://carlosga.blogspot.com/

"When you don't code, you tend to become one of those architects who thinks everything is possible" ( Anders Hejlsberg )



-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmdlnk&kid0944&bid$1720&dat1642
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to