Finisar SQLite Problem with ParameterDirection
- by Emanuel
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.
