i already validate on ui side, but if also the db will throw an exception it's
an additional help to find errors/bugs.
if with param lenght you mean FbParameter.Size then there will be no excpetion
also without setting it
this code will silently truncate the long text
using (FbConnection conn = new FbConnection(str))
{
conn.Open();
using (FbTransaction tx = conn.BeginTransaction())
using (FbCommand comm = conn.CreateCommand())
{
comm.Transaction = tx;
comm.CommandText = InsertQuery;
FbParameter param = new FbParameter("p0", FbDbType.VarChar);
param.Value = longText;
comm.Parameters.Add(param);
tx.Commit();
}
}
i will not add it to the tracker becouse for me is better to don't change the
behaviour if the lenght is/not is explicitly set on the parameter
(and also becouse maybe you mean another thing :) )
thanks for your responses
------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
lucky parental unit. See the prize list and enter to win:
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
