On Jan 31, 5:02 am, "Patrice" <http://www.chez.com/scribe/> wrote:
> Are other changes taken into account ?
>
> The usual problem is a db file with the "always copy" property defined in
> the VS.NET project. It causes the runtime db file to be always overwritten
> when your launch the application...
>
> (also I thought OleDb was not supporting named parameters ?)
>
> ---
> Patrice
>
> "CZuhars" <czuh...@gmail.com> a =E9crit dans le message de news:
> 1170210006.637573.10...@s48g2000cws.googlegroups.com...
>
> > Hi,
>
> > My .NET application writes to an Access 2003 db through OleDb. I'm
> > using a stored query in Access to insert a new row. The app's C# code
> > sample includes:
>
> > myCommand.CommandType =3D CommandType.StoreQuery;
> > myCommand.CommandText =3D "InsertName";
>
> > myCommand.Parameters.AddWithValue("@FIRST", "First name");
> > myCommand.Parameters.AddWithValue("@LAST", "Last name");
>
> > myCommand.Command.Open();
> > int rowNum =3D myCommand.ExecuteNonQuery(); // returns 1 row added
> > myCommand.Command.Close();
>
> > The Access Query - (an Append Query?) is:
> > INSERT INTO Members ( first_name, last_name )
> > SELECT [@FIRST] AS Expr1, [@LAST ]AS Expr2;
>
> > When the app runs, debug says the query returns a row. But when I
> > look at the table's data, nothing is there.
>
> > Any advice?
>
> > Thanks!

> Hi,
>
> My .NET application writes to an Access 2003 db through OleDb. I'm
> using a stored query in Access to insert a new row. The app's C# code
> sample includes:
>
> myCommand.CommandType = CommandType.StoreQuery;
> myCommand.CommandText = "InsertName";
>
> myCommand.Parameters.AddWithValue("@FIRST", "First name");
> myCommand.Parameters.AddWithValue("@LAST", "Last name");
>
> myCommand.Command.Open();
> int rowNum = myCommand.ExecuteNonQuery(); // returns 1 row added
> myCommand.Command.Close();
>
> The Access Query - (an Append Query?) is:
> INSERT INTO Members ( first_name, last_name )
> SELECT [@FIRST] AS Expr1, [@LAST ]AS Expr2;
>
> When the app runs, debug says the query returns a row. But when I
> look at the table's data, nothing is there.
>
> Any advice?
>
> Thanks!
>