[SQLiteFunction(Name = "SetValue", Arguments = 2, FuncType = FunctionType.Scalar)]
public class SetValue : SQLiteFunction
{
public override object Invoke(object[] args)
{
Dictionary<String, String> data = new Dictionary<string, string>();
data.Add("V_SEQ_NAME", args[0].ToString());
data.Add("V_VALUE", args[1].ToString());
string sql = "UPDATE SEQUENCE SET CURRENT_VAL = @V_VALUE WHERE SEQ_NAME= @V_SEQ_NAME; ";
SqliteHelper.ExecuteScalar(sql, data);
return SqliteHelper.ExecuteScalar(string.Format("SELECT GetCurrentValue('{0}')", args[0].ToString()), null);
}
}