Search options (Page 1 of 35)

Hello Sparrow
But when I went online to find the correct calculation formula, I noticed some discrepancies. In addition, I did not take into account insurance costs, I only took into account interest at a constant rate. But as it suited my friend as it was, I didn't go any further.
By the way, a question: in your SQLQuery code, is it possible to intersperse values contained for example in a TEdit?
You have to explain: you initially defined a sum of €100,000 as the amount of the loan. This amount comes up frequently in your code. Is it possible to ensure that the value of this sum is replaced by the one that the user enters in the TEdit? Same thing for the value of the annual rate?
Thank you for your answers
Cordially
JB

Hi Sparrow
It's exactly what I expected.
One question: why we don't have the same value for monthly repayment:
€302.99 for me and €936.64 for you (whether with Example Script or Example SQL)
and this even if I don't use the Round?
JB

Hello Keith
You can use this link : https://k245.ru/en/mvdb-en/last-beta-2.html
JB

Hello TCoton
I have the same type of license as you and I don't get any error messages when compiling a project (version 6.6.1).
Ultimately, you uninstall MVD and reinstall it (without forgetting to clean the registry, that's where the license is).
To do this properly in a single pass, I use GEEK (free version) which does the job perfectly.
Its link: https://geekuninstaller.com/download?version=1.5.2.165
JB

Hello Atropa,
There will most likely be no new MVD releases.
Dmitri, its creator, now works in the web field.
According to the latest news I had with him by email, it is not his intention to continue developing MVD, which all users strongly and rightly regret, me first and foremost.
MVD is such a fabulous and promising tool that it is a shame that no one can add new functions to it that would be very useful to us.
But we must admit that even with the latest version (6.1.1), we can carry out superb projects with a high degree of complexity.
But that's how life goes, even if I cross my fingers and say: "Dmitri, come back to MVD again."
JB

P.S.: I would love to be wrong!

Helo Derek

All is now OK with my projetc.

Selection of dates to archive -> OK
Check the dates to archive -> OK
Archiving of the selected year (I archive year by year) -> OK
For the current year, I add in the first line the
last year's balance -> OK
and what you feared did not come true, the balance is correct -> OK

So, I deleted the TFlage field which was no longer useful to me, I didn't use it in my new version -> OK

Very satisfied, the project is fully operational.
Thank you very much again for your effective help as usual.
Besides, on the Splash screen (Author Icon), I took the liberty of mentioning your name.
Sincerely
J.B.

Hello Derek
Thank you for your answer.
From the elements communicated, I took over the Archiving part of the
banking program while simplifying it in the process.
1 - I choose an account (here Common Current Account).
2 - I click on the 'Archiver les données' menu.
3 - The 'Archivage' panel is displayed with two DTPs and 3 icons. I choose the Start dates
        and End of desired archiving period.
4 - I click on the magnifying glass and the matching lines are displayed. I check them automatically.
4Bis - Eventually I can send them to Excel in order to save this archiving on disk.
        Useful when you want to save an entire year.
5 - I click finally to purge the base of these checked lines.

Until step 4Bis everything works perfectly. I get the desired result.
The problem lies in step 5. Instead of offering me a global deletion in one shot of
all the lines selected (as in your example), the project only offers me a line by line deletion
with deletion confirmation message for each line.

However, I used (practically copied/pasted) instructions from your example.
But there, I'm drying up.
Did I miss an instruction?
Aren't TFlags applied to all the lines you want?
I admit that I don't see where the wolf is.
If you can be so kind as to take a look, I'll thank you in advance.
Sincerely
J.B.

Hello Derek, how are you ?

Thank you for your answer.
It works perfectly.
As I like with MVD (it's exhilarating) also finding my own solutions
without always asking others, I am looking for the
mine.
Here's what I'm testing:
1- Two DateTimePicker (Start Date and End Date: for example: 01/01/2023 to 31/12/2023).
2- From these two dates, selection of transactions between these two dates
(via SEARCH, dbSQL or SearchQuery).
3- Display in the MVD grid of only these selected transactions.
4- These transactions are checked
5- Display of transactions in Excel (or even save to disk).
6- Deletion of these transactions in MVD.
7- To maintain the correct balance, addition of a first line of the new grid with the new
starting balance (which will be that as of 131/12/2023).

From this pseudo code I should achieve the same result as that of your proposal.
What do you think of this approach which seems quite simple to me?
Thanks again
JB

Hello Derek
Thank for your answer
An email address where I can send my project ?
Thanks in advance

JB

Hello Derek, Hello Vladimir
Thanks for your answers.
Derek :
I was so obsessed with this error message and what it was hiding that I forgot that the TEdit in question had an activity (OnChange) and that it prevented the field from being reset.
Thanks again.
JB

Hello Vladimir

What do you mean by 'empty'?
When I click on Conversion.zip I see
all the files
Is this what you are talking about?
J.B.