Search options (Page 1 of 37)

Hello teco049

MVD is knows how to create an XML file;

procedure Form1_Button4_OnClick (Sender: string; var Cancel: boolean);
var  Results: TDataSet;
begin
    SQLQuery('SELECT FirstName, LastName FROM person', Results);
    DataSetToXML(Results, 'd:\1.xml');
    Results.Free;
end;

Export via a dialog box :

procedure Form1_Button1_OnClick (Sender: string; var Cancel: boolean);
var Results: TDataSet;
     SaveDialog : TSaveDialog;
begin
     SaveDialog := TSaveDialog.Create(Form1);
     If SaveDialog.Execute then
     Begin
         SQLQuery('SELECT FirstName, LastName FROM person', Results);
         DataSetToXML(Results,(SaveDialog.FileName + '.xml'));
         Results.Free;
     end;
end;

JB

Hello milworm

What is unfortunate (and many regret it) is that MVD is no longer developed, Dmitri, its creator, has moved on to other functions (but still in the field of programming).

There would be so many functions and plug-ins to implement that would make it even more efficient (graphic effects such as searches, a more efficient Treeview, etc.).

But even in its current state (version 6.1) MVD remains a superb tool for developing the most advanced applications.

JB

Hello sparrow, hello Derek

Very interesting project that of a vertical TV, moreover it is easy to improve.(for example to create a documentation, or a collection of snippets (of MVD tips for my part I have already made one with the classic MVD TV) and so on...
It would be interesting to mix with Derek's pagecontrol.
To dig

Have a good day
JB

Hello negadi37

Using a program already made can be a solution
but if you really want to program your own application to manage any inventory, you can take inspiration from the project proposed by Dmitry:
MVD Home Page -> Database application -> Page 2 -> Equipment Inventory Database.
In fact, you will be able to customize your own application as you wish.
Do like this at first.
Otherwise I can to send you my own program, but I will rewrite it because it was written with an old version of MVD (v 2.5) and I will rewrite it with the latest version of MVD with all its new features.
Keep us informed
JB

You can study this Sparrow'project to add a picture by drag'Drop
JB

Hello Vickus, Hello sparrow,

On the form containing the grid from which you want to edit a record by double-clicking, place a button with the action "Show Record", you set Visible to False and this should solve your display problem
JB

Hello mouasomar
For your first question, MVD allows you to create an empty table
1 - Go to the Database TAbles tab and click New Database. You give it a name
2 - From the window that appears you create the different fields by choosing the type. If you choose a bad type, when running your project an error message will alert you.
On the Internet -> Delphi, find out especially about the differences between Integer, Real, Boolean and Currency
3 - RelationShip allows you to put two or more tables in relation. Interesting in queries.
4 - A Calculated Field is an extremely rich function in MVD. If you have a problem with it, ask Derek, he excels with calculated fields (and also Sparrow).
5 - Above all, do not give the names of your fields reserved words in Pascal. Instead, choose names that identify the function of the field. For names that are too long, reduce them with the _ sign
6 - Give your tables meaningful names that allow them to be easily identified
That should do it
JB

Hello Derek
Can this links give you some clues :

https://www.codeproject.com/Questions/1 … -in-delphi
and
https://supportcenter.devexpress.com/ti … rm-sorting

by adapting them to the MVD syntax?
Cordially
JB

Hello Mouasomar, Hi Derek

1 - Add a DBImage (or a TImage) on Form1
2 - Add this code after the GetDetails procedure:

procedure get_details (Sender: TObject; MouseLeft, MouseRight, MouseMiddle: boolean; Shift, Alt, Ctrl: boolean; X, Y: Integer);
begin
......
.......
Form1.DBImage1.Clear;
Form1.DBImage1.LoadFromDatabase('YourTable', 'YourPicture', Form1.GridEmployees.dbItemID);
end;

JB

Hi Sparrow
Thanks for your reply
Actually it was Form1.Treeview1 that I had to update to not frmEmployee.Treeview1.
Unfortunate mistake on my part
Regards
JB

Hello Destiny

MVD does not create an interactive PDF. It just converts a file into PDF format.
You will have to go through ADOBE Architect to achieve this (by going through the dollar box).
Or you can use Flipsnack.
JB