DaDaBIK
This forum is devoted to the discussion about the software DaDaBIK database front-end
the PHP Database application generator for MySQL, PostgreSQL and SQLite; also available for Wordpress.

Welcome! Log In Create A New Profile

Advanced

Saving record blanks out/erases all visable row data.

Posted by DLJonsson 
Saving record blanks out/erases all visable row data.
March 25, 2019 06:08AM
We open our main database as classic grid in DadaBik.

We are looking for records where the County/Parish field is empty.
On quick search we select County/Parish : [is empty].

We add a County into the County field and press <Next>

Then clicking <Previous> we see all visible data from the form has been erased
including the new data we entered into the County field.

Releasing the Quick Search filter we double check the record and its confirmed
all of rows visible at time of the 'Save' have been erased.

We confirm via our SQL client software using
Select * from aw_main where aw_item_number='18'
that all visable columns in the row edited have been blanked/erased.


Could this be a problem with Safari browser?
Should we be advised not to edit when using quick search filters?
Or?

Any suggestions appreciated.
Re: Saving record blanks out/erases all visable row data.
March 25, 2019 01:10PM
Please post version and other needed info.

Best,

________________________________________________________
Eugenio |\.-./| DaDaBIK developer and project admin
Re: Saving record blanks out/erases all visable row data.
March 28, 2019 11:36AM
Hello I am not able to reproduce this issue, it seems impossible to me that records are DELETED. Could you try to reproduce the behaviour in one of the online demo?

Best,

________________________________________________________
Eugenio |\.-./| DaDaBIK developer and project admin
Re: Saving record blanks out/erases all visable row data.
March 28, 2019 12:38PM
The record/row wasn't deleted, only the columns visible in the edit form were impacted.

I've moved the workstation and user to using Chrome rather than Safari and the
issue hasn't repeated.

For now I need to write it off as local issue with Safari on that workstation,
doubt if it is repeatable. Safari did have timeout issues on that machine and
was sometimes hanging on Dadabik. Since moving to a fresh install of
Chrome haven't been able to repeat the issue.
Re: Saving record blanks out/erases all visable row data.
March 29, 2019 04:43AM
Very strange, I would say it should be impossible for this to happen unless you click on "save" but let me know if it happens again.

Best,

________________________________________________________
Eugenio |\.-./| DaDaBIK developer and project admin
Re: Saving record blanks out/erases all visable row data.
April 07, 2019 06:33AM
Looking closer at the table today, I see that the problem was the data entry person deleted
the content of a field that was being used as a filter in the view they were using.

Drilling into the table today looking at the 'missing' record and a previous backup
it is clear now this is/was the problem.
Re: Saving record blanks out/erases all visable row data.
April 07, 2019 11:57PM
Hello,
so the content was not actually deleted?

Best,

________________________________________________________
Eugenio |\.-./| DaDaBIK developer and project admin
Re: Saving record blanks out/erases all visable row data.
April 08, 2019 11:27AM
That is correct the record was simply excluded from the view
once the field being filter in the view was changed and no longer
matched the condition in the view where clause.

Later auditing the table I found the row complete and un-effected except it was missing the column which was
manually blanked out - the view in question required - that specific field/column to be (not empty and not null).

I hope that makes sense, not a Dadabik issue rather an issue caused by the filtration of the view the form was
accessing.
Re: Saving record blanks out/erases all visable row data.
April 08, 2019 11:28PM
Ok, It's clear now. Thanks.

Best,

________________________________________________________
Eugenio |\.-./| DaDaBIK developer and project admin
Sorry, only registered users may post in this forum.

Click here to login