PHPRUNNER 7.1 - BUILD 20946 x86
I'm using a Lookup Wizard Dropdown Box against a MYSQL column of type SET with 36 items and an input "List Of Values" (not a database table) for the selections - also allowing multiple selections.
All works well adding and removing the various selections and updating the database UNTIL you attempt to unselect/deselect all items which would leave NONE of the SET items selected - the database is not updated (also the before record updated event is not called from the edit page).
If you simply change the Lookup Wizard to Checkbox List - all functions correctly (including the removal from the database of the last unselected/deselected items leaving the SET column on MySQL with no items chosen).
There appears to be a bug with the Dropdown Box when attempting to unselect/deselect the last remaining item(s) leaving the SET empty - the database update is not performed and the events (at least the "before record updated" event from the edit page) are not called.
Thanks for your help. Take Care... Mike.