Re: Database UPDATE

Home Forum Integrating PerfectForms Database UPDATE Re: Database UPDATE



Now I understand; I mistakenly assumed that empty parameters would not be passed in the query. In looking at the log file, I now see that empty parameters are passed as “”, hence my UPDATE did not work because it was looking for a record of (mostly) empty strings.

I created and tested an UPDATE action passing only two parameters, the row ID (primary key) for the WHERE clause, and an updated string for an Employee Name field, which worked as expected.

Is there any way to setup an UPDATE action for all fields where you can specify that the action omit empty fields from the query?