1

(35 replies, posted in General)

I put it here as just an idea and thank you for responding. Lazarus users are quite advanced so I have been wondering about an easier way for MVD users to enter their world. It's just an idea that maybe has no value, maybe it does. People also meet up on Zoom for this sort of thing. There are possibilities. Maybe someone has some experience in this area?

I acknowledge the report writer issue and using LazReport is some steps up from what we're used to.

It is worth monitoring
https://www.fast-report.com/en/blog/sho … t-lazarus/
regarding FastReport in Lazarus.

2

(35 replies, posted in General)

Hello everyone, I haven't developed any new applications in MVD for quite some time but I still visit this forum with interest. As abandonment of the MVD project is now in years, we all know it's risky deploying new applications and I'm slowly redeveloping mine using other systems. We can't predict when any of the add-on components will fail and allowing this risk in a deployed application is unthinkable.

If people are committed to Pascal, I'd say that the next logical step is Lazarus. I was using Lazarus years ago and it is still actively developed and released free of charge. I did some small project work back then and was very pleased with it. Take a look at the Application Gallery on their web site and one cannot help but wonder what a newbie could work towards achieving. Yes, it will take more work than we're used to but in the very least I believe I need to be transitioning to other systems in order to be confident in what I deploy.

Another excellent feature of MVD is the forum. We can ask any questions and the trail of posts remains friendly and helpful.

I'm expecting MVD users are mostly like-minded and areas of difficulty in other software would be common to most users transitioning.

I still regard MVD as the best database development software I've ever used but unresolved bugs and the growing gap between the last update and current time amounts to a growing risk.

An idea - Would it be possible for someone to setup and administer a completely separate forum where people could discuss how they can achieve equivalent features in other software such as Lazarus? For example, you want to sort columns, ask the forum. I'm thinking that there could be value in some sort of forum to assist people in transitioning until they're ready to participate in the full forum.

It's just an idea but thoughts??

3

(25 replies, posted in General)

If you're reading this Dmitry, thanks for the excellent support you've given (and several others) to make my projects possible. I'd love to see you back here but if that just isn't going to happen for whatever reason, I hope all goes well for you in your future endeavors.
David

4

(11 replies, posted in General)

Hello Drivesoft,

would it be possible for you to release a new MVD version (v6.51) purely as a bug fix release please? Can you confirm that Drivesoft has the capability to do this as it looks increasingly like the original Dmitry is no longer involved and the risk for us releasing applications to customers is significant given the number of unresolved bugs and no response to these.
Thanks and regards

5

(2 replies, posted in Script)

Hi John,
I'm wondering if a question I asked some time ago might help you.
http://myvisualdatabase.com/forum/viewtopic.php?id=2131
David

Hi Derek,
thank you for the reply with the workaround. I'm wondering if it might be permanent.
Best regards,
David

Hello Drivesoft,

There is a problem when attempting to edit a SQLite table field name by clicking on the edit symbol. I can change field name letters (eg change "a" to "b") but changing the case of a field name letter (eg "A" to "a") does not work. To overcome this I have been deleting the field and then adding it again but of course I cannot do this on a working data file as it results in loss of data. I'm using MVD 6.4 on Windows 10 64bit.

Can you advise when a version with a bug fix can be released please.

Thanks,
David

8

(0 replies, posted in General)

Hello Drivesoft,

Would there be any possibility of including an OpenStreetMap component in a future version of MVD if it is intended to continue developing this software.

Thanks,
David

9

(15 replies, posted in General)

Thanks Dmitry, yes like that. Are there other styles available too such as thermometer style or other.
I have two applications of this. I have telemetry coming into the serial port from microcontrollers or remote sites which I would like to display as gauges. Secondly I need to provide dashboard software for a database so professional gauges would be perfect. Other applications will arise of course.
Thanks for all your great work on this amazing software.
Regards, David

10

(15 replies, posted in General)

Hello Dmitry,
sorry to go on about this but do you have any time frame for adding the gauge components to the charting please.
Thanks,
David

11

(15 replies, posted in General)

Great news, thank you. Is there any estimate on when that could happen?
Thanks, David

12

(15 replies, posted in General)

Hello Dmitry,

Do you think there would be any chance of adding the gauge components to the charting in a future release please.

Thanks,
David

13

(1 replies, posted in General)

Hello,
I need to read POP3 email, ideally from a Gmail account, but Gmail POP server is on Port 995. As far as I know, MVD only reads POP server port 110. Can anybody confirm if I can read the Gmail emails on port 995 please. Also, does anybody know of a POP3 email system using port 110 that can be used at no charge that I can read with MVD?
Thanks,
David

14

(1 replies, posted in General)

Hello,
The report in my application is displayed as a pdf file and is assigned a temporary name if emailed or printed. Is there any way for me to have the software give this pdf file a meaningful name instead of the temporary name. The database records contain a auto-number field so it would suit to be able to name the pdf something like "Orderxxxxx" where xxxxx is the auto-number from the record.
Thanks in advance for any help
Regards,
David

Hello,
I am thinking about developing an application that hopefully would be used by multiple separate companies. I could have a MySQL database and the various customers all use this single database. All customer data would need to be isolated from other customers. The advantage is that I could update the software and change the database structure and all users would benefit. Alternatively, I could create a new MySQL database for each customer to be accessed only by that customer. That would be more difficult to administer to keep all of them the same.
Has anybody done this sort of thing and/or does anybody have any ideas on the best way forward?
Is there any sample project demonstrating how this could be done?
Thanks in advance,
David

Hello Dmitry,
there is no problem in my testing. I was just wondering if it is possible for any problem to arise in multiuser environment where the different users have different column layout. From your answer, it looks like this is fine to use in multiuser environment.
Thanks,
David

Hello,
I have disabled goDisableColumnMoving in a TableGrid for an application that uses SQLite in a multi-user environment. It works fine for me during testing but can it cause problems where multiple uses are accessing a single SQLite data file? I am wondering if the different users having different column orders can cause any sort of problem.
Thanks in advance,
David

18

(1 replies, posted in General)

Hello, I usually disable the default form menus with

frmMain.mniAbout.Visible := False;
frmMain.mniFile.Visible := False;
frmMain.mniReport.Visible := False;
frmMain.mniOptions.Visible := False;

If the "Options" menu is displayed, there is just one option called "Settings" and clicking on that brings up a window with two tabs, "Database Location" and "Settings". Is it possible to still have this window appear but to disable just the "Settings" tab preferably so it is not visible at all but still have the "Database Location" tab and be able to use it.
Thanks in advance, David.

19

(1 replies, posted in General)

Hello,
I have an installed application which I need to change. There is no change to the sqlite data file structure. In this situation where the data file is not changed, is it okay just to change the software and send this to the customer for them to put into the application directory. Or, do I have to have the data file when I change the program. I think it is okay just to change the software but could there be cases where this is not okay.
Thanks, David

20

(14 replies, posted in General)

Thanks Dmitry, the registry reports this Windows 10 Pro 64bit as version 6.3. Thanks for the effort you put in and maybe it is something that could be resolved at a later stage but I could use the registry method you describe. The screen resolution functions are excellent, thank you.
David

21

(14 replies, posted in General)

Hello Dmitry,
I run a test program on a Windows 10 Professional 64bit PC and it shows as version 6.2 also, the same as Windows 10 Home 64bit. The Win32BuildNumber shows 9200 for both OS's above and no text is returned for the Win32CSDVersion parameter on either of these operating systems.
I thought I was still running Windows 7 around here somewhere to test it on but it looks like I've upgraded everything to Windows 10.
I hope that helps,
David

22

(2 replies, posted in General)

Hello Dmitry,
I have only been working mainly on one project so haven't noticed it elsewhere. During the session the problem occurred, it was very easy to reproduce. I would go to edit the form and the name of the first text box I click on is the name that would remain in the lower left hand panel but the highlighted name in the top left panel would change as I clicked on any other control.
I have been unable to reproduce the problem since then.
Regards, David

23

(14 replies, posted in General)

Hello Dmitry,
thank you for the update. I am running Windows 10 Home 64bit on the machine I am using right now and the major and minor OS version shows as 6.2 which is the same as you say for Windows 8. Tomorrow I'll run it on Windows 10 Pro 64bit and Windows 7 and see what they report.
The screen resolution functions are great, thank you,
David

24

(6 replies, posted in General)

Hello Derek,
I got it sorted. It needs to be written back to front as

OpenFile('myTextParameter','myExe.exe');

There will be a good reason for this beyond my simple understanding.
Thanks again for your help.
Regards, David

25

(6 replies, posted in General)

Hello Derek,
Thanks but I tried that and many other things. The difference in my situation is that the command line isn't giving the name of a file that the external file needs to open (as in notebook opening a text file), I need to give the external program a parameter that it reads and uses that value in its program execution.
The external program is one I wrote myself to write the operating system into the SQLite data file. I can change the external program so it doesn't require the command line parameter but that would reduce some security and could add a bit of risk if the user runs it themselves without it being run from within the MVD script.
Regards, David