hichame wrote:
+1
there's no alternative to MVD.
exactly this
3 2022-06-06 14:42:31
Re: Translate (11 replies, posted in General)
Hello,
try this
var
s: string;
begin
s := 'Your message';
Translate('This_Field_is_required', s);list of items
Open_report_designer
Your_computer_does_not_have_Excel
Entry_to_edit_is_no_selected
Unable_to_determine_the_record_ID
Please_select_record_in_grid
Report_file_not_found
Entry_to_be_deleted_is_not_selected
Are_you_sure_you_want_to_delete_the_record
The_database_file_is_not_found
Not_a_number
Are_you_sure_you_want_to_delete_the_image_from_the_database
There_is_no_file_to_save
Do_you_really_want_to_delete_the_file_from_the_database
Restart_the_program_to_apply_the_settings
This_Field_is_required
Not_permitted_to_use_ComboBox_for_saving_record
Saving_or_opening_file_from_database
Select_file_stored_in_database
Export_image_from_database
Open_image_to_save_the_database
Delete_Image
Calculated_field
Counter_field
Open_file
Save_file
Delete_file
Open_folder_with_file
Clear
Open
Component
No_data_to_add
File_not_found
Confirm
Error
Info
Yes
No4 2022-03-16 15:52:52
Re: Where is Dmitry? (14 replies, posted in General)
Wood wrote:
you misunderstand.
It will automatically renew on 2022-10-29 to 2023-10-29.
And next year it will automatically renew on 2023-10-29 to 2024-10-29.and so on... like all the years before!
yes, but if you stop paying for it then it will expire on 29/10
5 2022-03-04 16:01:00
Re: MySoft (10 replies, posted in FAQ)
Thank you sibprogsistem, those are excellent resources to study & learn from, great work!!
6 2022-03-04 10:12:08
Re: MySoft (10 replies, posted in FAQ)
Thank you for sharing sibprogsistem! Actually also very curious to see what other applications you have developed.
7 2022-03-04 10:07:21
Re: FortmatDate in fastreport (2 replies, posted in General)
hello v_pizidis, i think Derek's solution in this topic might be of help for you: http://myvisualdatabase.com/forum/viewtopic.php?id=5528
8 2022-02-16 12:01:06
Re: News (8 replies, posted in General)
It would be unfortunate, there is no substitute for MVD
9 2021-12-02 20:30:47
Re: Looking for answers to some questions (10 replies, posted in Script)
derek wrote:
Hi Joshua,
As I mentioned in my earlier post, another option that you could consider is to use a data-driven approach and hold a small table where you can specify which tabsheet you want to show on startup.
In the attachment, simply change the 'default' tabsheet setting on Form3, restart your application, and a different default now shows.
You can do similar things throughout your application (variable tool tips, variable captions etc etc).
Derek.
Very clever, as always! thx Derek
@Joshua
to fix a certain tab on startup maybe you can also try something like this with script on your main form onshow procedure:
procedure frmMain_OnShow (Sender: TObject; Action: string);
begin
frmMain.PageControl1.ActivePageIndex := 0; // tab 1
end;10 2021-06-28 13:39:28
Re: Need help with database design for recurring checklists (2 replies, posted in General)
Hello Derek! Very nice to hear you again!
As always, thank you very very much for taking the time to make this elaborate example!! This is very helpful, it is almost exactly what i wanted to achieve! As you mentioned it is structured in a way which would have not been my first idea but i think it is really clever how it all fits together and the possibities the way of doing things like this creates. Thanks again for all your help!!!
PS: love the animation! 
11 2021-06-24 18:51:59
Topic: Need help with database design for recurring checklists (2 replies, posted in General)
Hi friends,
It has been a while since i have been active here but i have been lurking the forum. I sincerely hope everyone is well.
I have been thinking about making a little mvdb utility program to help me organize my daily office work, because it would really help me bring a bit of structure, but i am having troubles understanding (or planning) what the best way would be to set up my tables. Basically i need to execute recurring tasks for different clients.
I was wondering if anyone could guide me in the right direction or give me pointers.
The situation:
As of now i am using a simple excel file at the office with a checklist for different clients. There are routine checks i need to do for different clients. Depending on the client, and the kind of checks, the timing intervals are as follows: yearly/quarterly/monthly. So these are the recurring tasks.
Basically i have a table in excel, the table titles are the checks that need to be done, the first column is the client's name, the rest of the columns in the row are the dates or yes/no booleans if the check has been done. At the end of the check interval, lets say it is the monthly checklist, i will copy the excel tab to a new tab manually and restart the different checks. It would be ok to do this manually in mvdb.
What i would like to achieve:
I have made a quick sketch in excel to give an impression of what i would like to achieve. The "tablegrid" corresponds with my current "checklist" that i am using in excel. So i am looking to build a tablegrid like below:
Where i could basically choose from a dropdown/list in the main form which checks i need to do.
For example for the year 2021 and the quarter 2, or the month 5, and so on.
However, i dont seem to be able to grasp how i need to setup my tables, i know this is wrong but am i going in the right direction with this or not? Look below:
Yes, i am not good at this.
I would need these 3 functionalities:
- setup a standard checklist which can be reused
- a standard checklist can have different timing intervals, for example yearly/quarterly/monthly > this depends on the client
- a client can have many different checklists
Many thanks for taking the time to look at this.
Kind regards,
12 2021-02-04 15:09:25
Re: Version 6.5 (30 replies, posted in General)
This is sooo good! Thank you Dmitry!!! Been waiting for this for so long 
PS: Good to hear from you again Dmitry!
13 2020-11-28 00:42:14
Re: Questions about deploying a MVD project (8 replies, posted in General)
asawyer13 wrote:
Does inno setup have a way to automatically update the mvd exe when a new version of the software is uploaded to my server?
I am trying to determine what the best installer/updater to use to distribute and update my app would be.
Thanks
Alan
Hello Alan,
i was looking for the same answer to this as well, unfortunately it isn't a 'quick' solution but if you plan it carefully it shouldn't be too much of a hassle,
- Take a look at:
http://myvisualdatabase.com/forum/viewtopic.php?id=5365
- And this one:
14 2020-11-16 10:47:18
Re: [SOLVED]Tablegrid contents to Email (5 replies, posted in General)
Hello CDB, thank you for your answer and supplying extra info.
I've experimented with your code a bit, following code will open Outlook and prepare a new email message to review and then press 'send', which is what i was trying to achieve. Now i'm looking into a way to style the body.
procedure Form1_SendEmail_OnClick (Sender: TObject; var Cancel: boolean);
const
objMailItem = 0;
var
OKToUse: boolean;
Outlook: Variant;
vMailItem: variant;
begin
// OKToUse := false;
Outlook := CreateOleObject('Outlook.Application');
vMailItem := Outlook.GetNamespace('MAPI');
vMailItem.Logon; {[color=blue]this allows an email to be sent if Outlook is not open at the time of sending[/color]}
vMailItem := Outlook.CreateItem(objMailItem);
vMailItem.Recipients.Add('someperson@someplace.something');
vMailItem.Subject := 'What a wonderful test email'; {[color=blue]this could be a text box with the string contained in it[/color]}
vMailItem.Body := 'another string or stringlist with the body text';
vMailItem.Display;
Outlook := nil; {[color=blue]free the object - this might not be necessary, some sources say it automatically frees when out of scope[/color]}
end;15 2020-11-13 12:55:05
Re: [SOLVED]Tablegrid contents to Email (5 replies, posted in General)
Thank you very much CDB for posting your solution! I've been keeping an eye on this topic, this is something i've also been trying to do since it would be extremely timesaving and helpful in my little work projects, i'm going to try it out over the weekend. Do you have any idea if it would be possible to style the body, or perhaps even open an outlook email template?
16 2020-03-18 18:23:10
Re: Problem with MVD v6.3 (3 replies, posted in General)
Hello,
I once sort of had the same issue. Can you verify your project folder tree? When i encountered this issue i was saving a new project somewhere in another MVD project folder.
17 2019-12-01 19:16:39
Re: Example Dashboard Admin Layout (2 replies, posted in Script)
Very cool! i like these interfaces!
Thank you for the example prahousefamily, much appreciated!
I also make these kind of layouts but i generally use tabcontrol and hide the edges with images or other panels.
18 2019-10-01 13:42:04
Re: MINIMALIST UI DESIGN - SKELETON EXAMPLE (10 replies, posted in General)
Very cool, thank you for the example!
19 2019-08-11 16:59:57
Re: How to pass Datetimepicker value to report?? (11 replies, posted in Reports)
Excellent solution Derek (as always!) I wanted to try calculated fields at first but i wouldn't know how to begin, how do you come up with those syntaxes!? 
@Asifmute: i would advise to follow Derek's solution, using a calculated field is (in my opinion) much easier to maintain, oversee, and plan in your application. Debugging is much faster, and doesn't (really) break any other code if you would make small adjustments here and there, if it does then a calculated field is quickly adjusted.
I also tried to make a solution based on a report sql query by concatenating (which i learned from Derek) using '||' between the fields, have a look as attached.
SELECT
STRFTIME('%d', date)
||
case strftime('%m', date) when '01' then ' January ' when '02' then ' February ' when '03' then ' March ' when '04' then ' April ' when '05' then ' May ' when '06' then ' June ' when '07' then ' July ' when '08' then ' August ' when '09' then ' September ' when '10' then ' October ' when '11' then ' November ' when '12' then ' December ' else '' end
||
STRFTIME('%Y', date)
FROM dates
WHERE dates.id = $id; 20 2019-08-10 20:24:28
Re: How to pass Datetimepicker value to report?? (11 replies, posted in Reports)
Hello Asifmute,
Attached is a quick sample.
21 2019-08-09 18:50:50
Re: How to pass Datetimepicker value to report?? (11 replies, posted in Reports)
hello,
so you want to show the name of the month?
try in your report SQL:
SELECT
case strftime('%m', DateTimerPickerField) when '01' then 'January' when '02' then 'Febuary' when '03' then 'March' when '04' then 'April' when '05' then 'May' when '06' then 'June' when '07' then 'July' when '08' then 'August' when '09' then 'September' when '10' then 'October' when '11' then 'November' when '12' then 'December' else '' end
as month
FROM table;22 2019-08-09 17:16:39
Re: [SOLVED] '''' is not a valid integer value (6 replies, posted in Script)
This is fixed by Dmitry, was a script error in the report itself!
23 2019-08-09 17:15:24
Re: How to pass Datetimepicker value to report?? (11 replies, posted in Reports)
hello,
is it a wrong date or is it incorrectly formatted? do you have a screenshot?
24 2019-08-07 18:53:16
Re: [SOLVED] '''' is not a valid integer value (6 replies, posted in Script)
DriveSoft wrote:
Without attached project I can't help you.
Hello Dmitry,
I sent you you the project via email.
25 2019-08-06 20:37:35
Re: [SOLVED] '''' is not a valid integer value (6 replies, posted in Script)
Hello,
I managed to get rid of the error by using
procedure frmAddInvoice_DateTimePicker1_OnChange (Sender: TObject);
var
amountofdays : extended;
begin
amountofdays := frmAddInvoice.Edit4.Value;
frmAddInvoice.DateTimePicker2.DateTime := frmAddInvoice.DateTimePicker1.DateTime + amountofdays;
end;However, when this error was gone, the next one comes up.
Now i am getting this error in my existing report:
Could not convert variant of type (UnicodeString) into type (Double).
When i remove the code, the report just works again, but the dates wont change when Edit is changed.