Error 1054

Resolve a database error 1054 when saving form data.

Overview

The error occurs because a checkbox group in the form creates array data that the database save action cannot process directly.
Add a Handle Arrays action to the form's OnSubmit event and position it before the DB Save action to properly prepare the data.

Answered
bo box-com 28 Feb, 2016
Hello Bob,
I have a problem with a form.
Everything works. When writing to the database, the error 1054 is reported.
Can you help me?
Here is the debug.
Thanks

Best regards
Peter
Gr GreyHead 28 Feb, 2016
Answer
Hi Peter,

1054 is an unknown column error. It might be because you have the checkbox group in the form. Please drag a Handle Arrays action into the OnSubmit event and move it up before the DB Save action.

Bob
bo box-com 28 Feb, 2016
Hello Bob,
so easy...
It works.
Thank you very much.

Peter
This topic is locked and no more replies can be posted.