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: 407

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

Related posts about c#

Related posts about sqlite3