Re: [Firebird-net-provider] Error inserting lage blobs

[Sam M. <sam...@cl...>]

Parameterized queries work fine. Here is my code:

public override void Load(FbCommand Cmd)
{
  Cmd.Parameters.Clear();
  StreamReader ValuesStream = new StreamReader(FileName);
  string ValueList = string.Empty;
  string ValueListParam = string.Empty;
  string Sep = string.Empty;
  int FieldIndex = 0;
  bool First = true;
  FbParameter CurParam;
  while (ValuesStream.Peek() >= 0)
  {
    ValueList = ValuesStream.ReadLine();
    FieldIndex = 0;
    foreach(string Value in Regex.Split(ValueList, "','"))
   {
    if (First)
    {
      CurParam = new FbParameter("Field" + FieldIndex.ToString(),
Value.Trim("'".ToCharArray()));
      Cmd.Parameters.Add(CurParam);
      ValueListParam += Sep + "?";
      Sep = ",";
    }
    else
    {
      Cmd.Parameters[FieldIndex].Value = Value.Trim("'".ToCharArray());
    }
    FieldIndex++;
    }
    First = false;
    Cmd.CommandText = "INSERT INTO " + TableReference + " " + ColumnList + "
VALUES (" + ValueListParam + ");";
    Cmd.ExecuteNonQuery();
  }
  ValuesStream.Close();
  Cmd.Parameters.Clear();
}

Sam


"Carlos Guzmán Álvarez" <car...@te...> wrote in message
news:407...@te......
> Hello:
>
> > This is the insert code:
> >
> > StreamReader ValuesStream = new StreamReader(FileName);
> > string ValueList = string.Empty;
> > while (ValuesStream.Peek() >= 0)
> > {
> >   ValueList = ValuesStream.ReadLine();
> >   Cmd.CommandText = "INSERT INTO " + TableReference + " " + ColumnList +
"
> > VALUES (" + ValueList + ");";
> >   Cmd.ExecuteNonQuery();
> > }
> > ValuesStream.Close();
>
> Can you make a test using parameterized querys, please ??
>
>
>
>
>
> --
> Best regards
>
> Carlos Guzmán álvarez
> Vigo-Spain
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>