My Visual Database — FAQ

Is MVD good for me and my needs ?

null@example.com (coeur2louve) — Mon, 10 Feb 2025 13:14:03 +0000

Hello,
Do you think that MVD is easy enough to use for me, who has no database skills, knowing that I would like an application to manage a boarding kennel, including of course clients and pets, billing, reservation planning, kennel/crate occupancy, financial reports. The existing solutions are all on the cloud and require a fairly large monthly subscription, given my hosting capacity. I haven't found any satisfactory on-promise software (I've tested a dozen or so...).
I really enjoy to learn a new skill, even if it should be easier and faster to ask for a programer.
Thank for advice .

Tree View.- Display of only child records

null@example.com (salvatorevicari85) — Thu, 04 Jul 2024 21:07:35 +0000

Hi guys,
I'm back with another question about Tree View.
How do I set the display of child records (only if present) as is done with TableGrids.
I attach a small project to give a better idea and a screen shot.
Because TV shows all the records in the table. How do I set up an automatic filter? I can't find it among the basic TV settings. Thank you

TreeView Basic Operation

null@example.com (salvatorevicari85) — Sat, 29 Jun 2024 21:16:43 +0000

I've been trying to work with TreeView for a while.
I can't get it to work.

I also tried to download other examples from the Forum but I don't understand what the trick is.
I attach the basis of my project.

Help please.
Thank's

Management of large projects

null@example.com (salvatorevicari85) — Tue, 25 Jun 2024 14:29:24 +0000

My Visual Database is great,
but with big projects I'm starting to feel tight.
I have about 150 tables and 50 forms and they will become even more, it is becoming difficult to locate both the tables and the forms.
We would need a search tool or a way to sort them.
How can I solve it?
-

Thank you

Expand the scheme

null@example.com (salvatorevicari85) — Tue, 25 Jun 2024 14:22:34 +0000

My project includes many tables.
The basic MyVisual DB Window is really small for my needs. How can I solve it?
- Is there a way to expand the window, perhaps by moving with the scroll bars?
- Or can I use another software in combination with MVD to help me do this?

Thank you

Open new page of a Page Control for New Record

null@example.com (salvatorevicari85) — Sat, 22 Jun 2024 15:23:22 +0000

Greetings,
It is possible to set a function so that when you set a button in:

NEW RECORD
SHOW RECORD
Double click on a line

Open a New Page of a Page-Control, rather than a new window?

The reason is that once a new window is opened it is impossible to move the one below it, which makes the work very inconvenient.

Thank you

Replace Excel

null@example.com (sdpc62) — Wed, 06 Sep 2023 07:19:17 +0000

Hello everyone, I would like to know if it is possible to change the Excel button to the one of our choice.
I take for example 'AbiWord' by default, how to configure it to use it instead of Excel.

How to edit the File, Options, About

null@example.com (makingthingsgo) — Tue, 07 Mar 2023 22:08:55 +0000

Is there a way to edit these windows instead of scripting their removal ?

I have used the search function and only find the ability to remove them, and it would be great to just edit them so they are in the old standard
modal window ?

Coming from very old Clarion, Filepro, and other active dev projects.

Thank you.

Newbie in My Visual Databse

null@example.com (lemodizon) — Mon, 16 May 2022 12:21:43 +0000

Hi everyone,

I'm new here in this forum.. just want to ask if there is a tutorial site, books on how to use MVD? i'm kinda curious in the script part I don't what is the function of the script part in the MVD.

I'm planning to create a simple inventory application hope i can create using MVD.

Thanks everyone.

error in saving combobox with properties set to multiselect = true

null@example.com (Amazjya) — Mon, 14 Mar 2022 11:48:57 +0000

Someone help me. I have a combobox to allow user to select several options from dropdown. In properties i have set the mutliselect property of the combobox = true. When i run app and try to save a record am recieving an error " Not permitted to use ComboBox with the property MultiSelect = True for saving record."

Problem with webgrid

null@example.com (teixeira.diogo.2002) — Fri, 07 May 2021 22:25:44 +0000

Hey guys
I have a problem with my application created in my visual database.
I already created everything and I would like to create a webgrid, but it is always giving error in the browser.
My base was created in the MYSQL Community.
Please, can someone help me, am I missing something?

How to sort

null@example.com (DriveSoft) — Mon, 15 Mar 2021 19:09:15 +0000

Unfortunately, the component TableGrid and SQLite does not support proper text sorting when characters like Č, Ä and so on are present.
To solve this problem, you need to use MySQL and disable the built-in sorting in the component.

Script

procedure Form1_GridSearch_OnChange (Sender: TObject);
begin
    // you should disable sort option for all columns
    Form1.GridSearch.Columns[0].Options := Form1.GridSearch.Columns[0].Options - coCanSort;
    Form1.GridSearch.Columns[1].Options := Form1.GridSearch.Columns[1].Options - coCanSort;
end;

procedure Form1_GridSearch_OnHeaderClick (Sender: TObject; ACol: Integer);
var
    sField: string;
    Ascending: boolean;
begin
    Ascending := True;
    if Form1.GridSearch.Tag = ACol+1 then Ascending := False;

    if (Form1.GridSearch.Columns[ACol].FieldType <> 'CALC') and (Form1.GridSearch.Columns[ACol].FieldType <> 'AUTOINC') and (Form1.GridSearch.Columns[ACol].FieldType <> 'CHECKBOX') then
    begin
        sField := '`' + Form1.GridSearch.Columns[ACol].TableName + '`.`' + Form1.GridSearch.Columns[ACol].FieldName+'`';

        if Ascending then Form1.GridSearch.dbCustomOrderBy := sField + ' ASC'
        else Form1.GridSearch.dbCustomOrderBy := sField + ' DESC';
        Form1.GridSearch.dbUpdate;
        Form1.GridSearch.Columns[ACol].Sorted := True;
    end;

    if Ascending then
    begin
        Form1.GridSearch.Tag := ACol+1;
        Form1.GridSearch.Columns[ACol].SortKind := skAscending;
    end else
    begin
        Form1.GridSearch.Tag := 0;
        Form1.GridSearch.Columns[ACol].SortKind := skDescending;
    end;
end;

Project example:

Message Dialog with timeout

null@example.com (CDB) — Sun, 21 Feb 2021 06:10:39 +0000

MessageDlgTimeOut(msg,caption,flags, milliseconds).

I think this function is missing an integer return!

As it stands, the buttons that are displayed cannot be interrogated, which makes displaying them pointless.

I have discovered that 'flags' is actually the button type constants to be displayed =.

0 = OK
1 = OK, CANCEL
2 = ABORT, RETRY, CANCEL
3 = YES, NO, CANCEL
4 = YES, NO
5 = RETRY, CANCEL
6 = CANCEL, TRY AGAIN, CONTINUE

It would also be nice to perhaps have the option of displaying no buttons, in which case the function becomes a timed dialog message box.

I'm using v6.5

Search Function

null@example.com (hexeeee) — Wed, 03 Feb 2021 09:02:10 +0000

Hello,

i have the problem, that my search function isn't working.
When i open my form to search i see all my inputs but when i search for something i see nothing, not even the row names

ONLY ComboBox can have its ForeignKey

null@example.com (Ernie) — Tue, 26 Jan 2021 09:39:40 +0000

The Properties of TexBox and ComboBox is different, why ONLY ComboBox can have a ForeignKey
I want to make TextBox link with ForeignKey and its FieldName, It's possible?