Finisar SQLite Problem with ParameterDirection
Posted
by Emanuel
on Stack Overflow
See other posts from Stack Overflow
or by Emanuel
Published on 2010-03-19T19:53:36Z
Indexed on
2010/03/20
8:41 UTC
Read the original article
Hit count: 413
private int GetNextId()
{
SQLiteConnector conn = new SQLiteConnector(false);
conn.OpenConnection();
cmd = new SQLiteCommand("SELECT @id_account = MAX(id_account) FROM account");
SQLiteParameter param = new SQLiteParameter("@id_account", DbType.Int32);
param.Direction = ParameterDirection.Output;
cmd.Parameters.Add(param);
cmd = conn.ExecuteReadeOutput(cmd);
conn.Close();
return int.Parse(cmd.Parameters["id_account"].Value.ToString()) + 1;
}
...
public SQLiteCommand ExecuteReadeOutput(SQLiteCommand cmd)
{
conn.Open();
cmd.Connection = conn;
reader = cmd.ExecuteReader();
reader.Close();
return cmd;
}
When I call the method GetNextId() occur the following error: Specified argument was out of the range of valid values. at line: param.Direction = ParameterDirection.Output;
Any idea?
Thanks.
© Stack Overflow or respective owner