Some issues with my very first project

Hi MarkoS, Sibprogsistem,
1.
Deleting files from the 'storage' and 'gallery' folders when changing either a photo or a file was not working because you have not created the 'onafterclick' event between the Form2.Button1 object and the procedure in the script (see screenshot1 in the attachment).  You cannot simply copy and paste code from other projects into your script without also creating these associated 'events'.
2.
Form2.show will display empty fields the first time you start your program and click 'Add'.  But after that, it will always be holding the values from the record you last displayed.  In your script, you should be using 'form2.newrecord' and not 'form2.show (see screenshot2 in the attachment).
3.
If you want the date to default to the current date, you need to select both the 'default checked' and 'checked' properties for the 'datetimepicker1' object (see screenshot3).  If you looked at the raw data, you would see that the date was being saved as 'null' (see screenshot4) which was why nothing was showing in the relevant tablegrids or in the reports.
.
Please have a look at the attached project which contains fixes for all of the above issues.
Regards,
Derek.

Hi MarkoS,
Yes - if you don't want to limit the number of records, you can
1.  delete the procedure form1_button1_onclick in the script
2.  delete the 'onclick' event associated with form1.button1
3.  change the action associated with form1.button1 from 'no action' to 'new record'
But you need to keep the 'onafterclick' event associated with form2.button1 - this is the event (and 'procedure form2_button1_onafterclick' in the script) that deletes files from the 'gallery' and 'storage' folders when you change an existing picture or an existing document.
Derek.

Hi, Derek,
I tried and it seems to be OK for now.
Just one thing regarding the attachments.
When I click to Open folder with file then opens the whole PC (This PC) instead just the storage folder . I checked out, attachment is really in storage and I can open and delete it  clicking to Open file or Clear.
Is there anything that can be done about it?

Thanks Derek for your effort. It is really very valuable for me.
Please, see an attached mp4.
The issue could be with two textboxes in Form1, that are either empty (if save button in form2 is clicked) or the same (if the cancel button is clicked). Even when any other row is highligted for deleting they remain the same and it is a question what picture or file will be deleted.

Hi, Derek,
I have tried many times to attach files and "Open file" as well as "Open folder with file" in both ways.
Your way with the added buttons "Open storage" and "Open file" works without error, but keeping both options is a bit confusing.
It seems to me, I found a reason for the strange behaviour of "Open folder with file" in DBFile.
For some reason, the name of the attachment must not contain "," (comma).
I don't know if it's a bug in MVD, that can be corrected somehow (or bypassed) or is something specific in my PC or I am doing something wrong?
Any advice?

Thanks, Derek,
I also thought in a similar way, to cover the right part of DBFile1 with the Panel, but the "delete file" is still missing. Can a delete button be added?
Or prevent the user somehow to add the file with comma.
The best solution would be to completely remove DBFile and add a new table  and the script with the ability to add file (perhaps multiple files); replace, view, and delete files, but I'm quite sure I'll be unable to do that.
Hopefully, I am not so tedious and too demanding.
Any help is really appreciated.

Thanks for your great support, Derek.

Hi MarkoS,
This is because the script checks on the number of rows displayed in form1.tablegrid1 rather than the number of rows held in the table 'example' .
To fix this, just change the form1_button1_onclick procedure to count the number of rows in the table 'example' instead.
But now when the 'search' (filter) is active and the tablegrid is displaying a sub-set of the records, it could be confusing to the user to be warned that the maximum number of records has been reached when the user can only see less than the maximum in form1.tablegrid1.  So it might be helpful to display a counter below form1.tablegrid1.  For example, enter 5 in the 'slots' or 'poles' criteria, then enter 55 and then 555 and you will see the counter changing.
Please see attached.
Derek.

Hi MarkoS,
Please find attached your project.
It now has
1) a 'delete' button on Form 2 that deletes the record (and any associated image and file in the 'storage' and 'gallery' folders) and then returns you to Form1.
2) 'next' and 'previous' buttons on Form2 that scroll through the records shown in Form1.tablegrid1.
The search button on Form1 doesn't show because I'd made it invisible when I was doing some testing.  There is the option in MVD to (optionally) hide the search button and set your search fields (in your example 'slots' and 'poles') to search incrementally - in other words, the user doesn't have to click on the search button - the rows in the tablegrid automatically refresh as the user types into either of the search fields (see screenshot1 in the attachment).  If you prefer to see the 'search' button, just make it 'visible' again and remove Button4 as the 'increm.search' property for the 'slots' and 'poles' search fields.
Derek.