Update using parameters

I think you have a syntax problem in your QueryParams. You can break it up a little to be more understandable. This should work:

QueryParameter[] inputs = {
            new QueryParameter("@p1",Local.Var1),
                new QueryParameter("@p2",Local.Var2),
                new QueryParameter("@p3",Local.Var3)
        };

        Mstm.SelectSql(new MetastormDefault(),
            @"Update  YOUR_TABLE set Column1 = @p1,Column2 = @p2 where Column3 = @p3",
            inputs);

Sounds like you might have something else going on in your solution. Does the solution validate and deploy with a simple SQL Select statement instead of the update with the same given parameters? Can you cast the native metastorm types that will be coming in off of the Local object to the .Net counterparts (ToString() for TextField, ToNullableDateTime(), for DateTimeField, etc...)

You should be able to execute ant SQL in the SelectSql() function.

You should probably use the SQLArg() function to create the QueryParameter object as it is cleaner.

I can see nothing wrong with your Update function call. I suspect the error is caused by something else.

---

jm_aussie wrote:

If I need to insert into a table, the following works well for text fields where single quotes (apostrophes) may be used:

 

{

Mstm.SelectSql(new MetastormDefault(),@INSERT INTO YOUR_TABLE

(Column1,Column2)

VALUES (@p1, @p2)",

      new QueryParameter("@p1",Local.Variable1),

      new QueryParameter("@p2",Local.Variable2)

      );

}

 

Is there a corresponding format for  UPDATE?  I haven't been able to stumble my way thru the correct syntax - I get a "name" variable error when I try to deploy even though the script validates correctly:

 

{

Mstm.SelectSql(new MetastormDefault(),@Update  YOUR_TABLE set

Column1 = @p1,Column2 = @p2 where Column3 = @p3"

      new QueryParameter("@p1",Local.Variable1),

      new QueryParameter("@p2",Local.Variable2),

      new QueryParameter("@p3", Local.Variable3)

      );

}

 

Thanks for any assistance. 

---