Form not updating table

Jennifer Methlie

I have a form where the user enters data into various fields and on button click, the table is to be updated per the following:

 

"Update LASP_INVENTORY set chkCalRequested = 1 , parentfolderid = '" + ProcessContext.FolderId + " ' where INVENTORYID = ' " + Local.txtInvID + "'"

 

The command works perfectly outside of Metastorm but the field is never updated when I deploy within Metastorm.

 

Any help would be appreciated.   Thanks!

achopra

could it be the space that you have in your where clause, next to the single quote?  there is also a space by the folderID part of your SQL.  You shouldn't have any spaces in those spots.  Perhaps they aren't spaces though, and it is just the way it looks on this forum.

Jennifer Methlie

That's it.  You stare at it so long and don't see the obvious!!!

 

THANK YOU!

achopra

I know the feeling.  Glad that was it.

Jerome_Pearce

To avoid this problem, and a great many others, it is far better to use SelectSql() and the parameters it offers. Until we get parameters for the other database functions, it is the only way we do updates on the database.