Search options (Page 1 of 9)

Hello everyone!

Here's a little document I always keep handy that might be useful for anyone wanting to customize the colors of their MVD projects.
Enjoy!

JB

sparrow wrote:

Hi jrga, domebil

Sometimes you can try it this way. You don't even have to display the footer.
Just indicate the correct column number.

procedure frm_grid_zoom_TableGrid_subnotas_OnChange (Sender: TObject);
begin
  frm_grid_zoom.TableGrid_subnotas.Columns[0].Footer.FormulaKind := fkMinimum;
  frm_grid_zoom.TableGrid_subnotas.CalculateFooter;
  frm_grid_zoom.Edit_min.text := frm_grid_zoom.TableGrid_subnotas.Columns[0].Footer.Caption;
  frm_grid_zoom.TableGrid_subnotas.Columns[0].Footer.FormulaKind := fkMaximum;
  frm_grid_zoom.TableGrid_subnotas.CalculateFooter;
  frm_grid_zoom.Edit_max.text := frm_grid_zoom.TableGrid_subnotas.Columns[0].Footer.Caption;
  frm_grid_zoom.TableGrid_subnotas.Columns[0].Footer.FormulaKind := fkAverage;
  frm_grid_zoom.TableGrid_subnotas.CalculateFooter;
  frm_grid_zoom.Edit_med.text := frm_grid_zoom.TableGrid_subnotas.Columns[0].Footer.Caption;
  frm_grid_zoom.TableGrid_subnotas.Columns[0].Footer.FormulaKind := fkNone;
end;  

Hi Sparrow, thanks for providing this alternative method! I followed this approach because the table grid already had the total for the "value" column in the footer, and I wanted to display the average, minimum, and maximum values.

Hi jrga, domebil

Sometimes you can try it this way. You don't even have to display the footer.
Just indicate the correct column number.

procedure frm_grid_zoom_TableGrid_subnotas_OnChange (Sender: TObject);
begin
  frm_grid_zoom.TableGrid_subnotas.Columns[0].Footer.FormulaKind := fkMinimum;
  frm_grid_zoom.TableGrid_subnotas.CalculateFooter;
  frm_grid_zoom.Edit_min.text := frm_grid_zoom.TableGrid_subnotas.Columns[0].Footer.Caption;
  frm_grid_zoom.TableGrid_subnotas.Columns[0].Footer.FormulaKind := fkMaximum;
  frm_grid_zoom.TableGrid_subnotas.CalculateFooter;
  frm_grid_zoom.Edit_max.text := frm_grid_zoom.TableGrid_subnotas.Columns[0].Footer.Caption;
  frm_grid_zoom.TableGrid_subnotas.Columns[0].Footer.FormulaKind := fkAverage;
  frm_grid_zoom.TableGrid_subnotas.CalculateFooter;
  frm_grid_zoom.Edit_med.text := frm_grid_zoom.TableGrid_subnotas.Columns[0].Footer.Caption;
  frm_grid_zoom.TableGrid_subnotas.Columns[0].Footer.FormulaKind := fkNone;
end;  

Setting Column Width

My Visual Database has the ability to manually adjust column widths for each table view. But in some cases, you want more intelligent behavior: automatic alignment of the data width or alignment of the width when the table size is changed. Using scripts you can achieve the desired effect.

I bring to the attention of readers several scripts that will allow the user to independently select the level of automation for column alignment he needs from four available options:

Default – manual alignment
Proportional – equal width for all columns, retained when the table size is changed
According to data – the width is set so that all data is displayed entirely, without cropping
Stretch last – the last column is stretched and fills the visible area of the table

https://k245.ru/en/mvdb-en/setting-column-width.html

Como usar script para - Carregar arquivo do banco de dados para dbfile1 - Carregar arquivo do caminho para dbfile1 - Salvar arquivo de dbfile1 para banco de dados - Salvar arquivo de dbfile1 para caminho ('C:Path\')

I made some modifications to the "Family Album" project, created by K245 and which received corrections and improvements from Sparrow, listed below:

01 - Translation of the "captions" (names of forms, labels and buttons) into Portuguese through instructions included at the end of the script between BEGIN and END.

02 - In the search field on the main screen, I included:
* Search by CATEGORY by simply typing the name, after unchecking the "TAG" and "OR" checkboxes. In the previous form, the user had to select all the TAGs of a category.

* The content of the search field is cleared with 2 clicks.
03 - Inclusion of a "NO TAG" button for searching for photos without TAGs, considering that photos without TAGs do not have an associated category, which can be more easily corrected with this.

04 - Inclusion of a Backup button, which zips the "sqlite.db" database and the "image" folder, which contains the photos. Sparrow provided the script for zipping the database.

05 - In the "image editing" form, below the thumbnail and TAG field, I included a field that gives access to a folder selected by the user and another that executes a file also chosen by the user. When one of these fields is filled in, a red bar appears over the thumbnail with the title "Double Click". When clicked, the folder is opened or the file is executed. I included this option in case the user has many folders with photos. Thus, they can choose one photo from each folder. I chose to convert the photos from a folder into a single PDF file, which is opened when I double-click on the thumbnail. The use of this feature is optional.

Hi all,

ESC exit added to some forms.
The FullScreen button has been enabled.
Two thumbnails have been added to the main screen.
Thumbnail cropping behavior has been changed:
- When adding an image, the default thumbnail is the entire image.
- The ability to crop a thumbnail of any size.
- Thumbnail cropping within the image boundaries.
Other changes...