I have a table with columns lastname varchar(20) firstname (20) dob date
combination of them are primary key for the table test in mysql. I created view view_test as select * from test
in phprunner 9.8 i put key fields for view_test as a same combination .
Set up layout to bootstrap, select checkbox "update selected" on Pages page and trying to press update selected to call edit page. If the fields lastname and firstname do not have spaces, it shows correctly how many rows i selected . If lastname or firstname consist some spaces it does not show correct numbers of rows, exclude rows with spaces in key fields. For examle if i choose one rows with a spaces in lastname it will show me 0 records selected and when i try to save the records empty message appears on the top . I found that if i choose the record for editing , do mothing inside and just save, after that i can check it for update selected and everything will work fine.
The verdict is If the key fields have spaces inside , "update selected" action does not perform . Action "update selected" execute only after you simulate "Save" the record, by pressing button "edit" and after that "Save" without entering any changes to record. Does not matter, either, table or view have been used.
Could somebody help to solve the problem. Thanks