Thank you Derek for your response.
I have realized that the 'Filter' script is now placed in a bracket in MVD 6.2
I wish Dmitry will take a look at it.
51 2020-01-06 20:19:06
Re: [SOLVED] Combobox Filter & TextHint Problem (11 replies, posted in General)
52 2020-01-06 17:48:32
Topic: [SOLVED] Combobox Filter & TextHint Problem (11 replies, posted in General)
ComboBox with Filter below not working in MVD 6.2
1=1 ORDER BY id DESC
The above code used to be the workaround to order items in the ComboBox but does not work any longer in MVD 6.2. Any workaround?
Thank you in advance
53 2020-01-03 08:15:33
Re: database online (14 replies, posted in General)
Follow
http://crud-admin-generator.com/
To create a CRUD backend for your database
You can also try this application which has a 30days trial
https://www.sqlmaestro.com/products/mys … /download/
54 2020-01-03 07:07:11
Re: database online (14 replies, posted in General)
Try this simple took to convert access to MySQL
http://www.bullzip.com/products/a2m/info.php
55 2019-10-23 15:09:23
Re: Search button stops working.... (17 replies, posted in General)
The where is referencing two tables but the from is one table
ifnull((SELECT cid_a.cid_num FROM cid_a WHERE cid_a.id=bienal.id_cid_a),'')||' '||
Try this
ifnull((SELECT cid_a.cid_num FROM cid_a, bienal WHERE cid_a.id=bienal.id_cid_a),'')||' '||
56 2019-10-19 19:00:18
Re: Select column in tablegrid search results (5 replies, posted in General)
procedure bulksms_Button1_OnClick (Sender:TObject; Cancel:Boolean);
var
Results: TDataSet;
contacts: String;
begin
SQLQuery('SELECT GROUP_CONCAT(DISTINCT contact) AS contacts '+
'FROM students '+
'WHERE '+
'id_form= "' + bulksms.ComboBox1.sqlValue + '" AND '+
'id_class= "' + bulksms.ComboBox2.sqlValue + '" AND '+
'id_course= "' + bulksms.ComboBox3.sqlValue + '"'+
';', Results);
contacts := Results.FieldByName('contacts').AsString;
ShowMessage(contacts);
end;
Let me know of any challenge
57 2019-10-19 13:24:43
Re: Select column in tablegrid search results (5 replies, posted in General)
Can you elaborate a little bit on the problem?
58 2019-10-17 12:21:56
Re: day of a week (2 replies, posted in General)
Hello,
Try this out
procedure Form1_Button1_OnClick (Sender:TObject; Cancel:Boolean);
var
dayofweek: string;
begin
dayofweek := FormatDateTime('dddd', Now);
ShowMessage(dayofweek);
end;
59 2019-09-25 13:27:51
Re: Employee sign in and sign out (4 replies, posted in General)
Hello MVD users, I need a sample project where employees will sign in when the report to work and sign out when leaving work. A form of attendance sheet
Please, follow this post
http://myvisualdatabase.com/forum/viewtopic.php?id=1437
Thanks
60 2019-09-23 11:13:16
Re: What to implement first? (187 replies, posted in General)
Please download latest beta version
https://www.dropbox.com/s/6n60thhfaszoj … a.zip?dl=0I added a new property for Form, TrayPopupMenu, example:
var PopupMenu: TPopupMenu; procedure Form1_OnShow (Sender: string; Action: string); var MyItem: TMenuItem; begin PopupMenu := TPopupMenu.Create(Form1); MyItem := TMenuItem.Create (PopupMenu); MyItem.Caption := 'Item1'; MyItem.OnClick := @MenuClick1; PopupMenu.Items.Add(MyItem); MyItem := TMenuItem.Create (PopupMenu); MyItem.Caption := 'Item2'; MyItem.OnClick := @MenuClick2; PopupMenu.Items.Add(MyItem); Form1.TrayPopupMenu := PopupMenu; Form2.TrayPopupMenu := PopupMenu; end; procedure MenuClick1 (Sender: string); begin ShowMessage('Hello from Item1'); end; procedure MenuClick2 (Sender: string); begin ShowMessage('Hello from Item2'); end;
Project with example
Thank you very much Dmitry for your quick response.
I'm going to give it a try.
Really appreciated
61 2019-09-21 09:03:29
Re: What to implement first? (187 replies, posted in General)
Please, how do I add menu to trayIcon when MinimizeToTray is enabled of a form
Thank you.
62 2019-09-12 12:21:33
Re: Possible Error (6 replies, posted in General)
Report button automatically presses button with action "Save Record" to save data from form to database, because button with action "Report" gets data from database, not from form.
In your case, you can use variables to use it in report, example:
procedure Form1_Button4_OnClick (Sender: TObject; var Cancel: boolean); begin Form1.frxReport.Clear; // DESIGN MODE Form1.frxReport.LoadFromFile(ExtractFilePath(Application.ExeName)+'Report\1.fr3'); Form1.frxReport.Variables.Clear; Form1.frxReport.Variables[' ' + 'My Category 1'] := Null; Form1.frxReport.Variables['My Variable 1'] := 10; Form1.frxReport.Variables['My Variable 2'] := ''''+'Hello'+''''; Form1.frxReport.DesignReport; // PREVIEW MODE //Form1.frxReport.LoadFromFile(ExtractFilePath(Application.ExeName)+'Report\1.fr3'); //Form1.frxReport.Variables.Clear; //Form1.frxReport.Variables[' ' + 'My Category 1'] := Null; //Form1.frxReport.Variables['My Variable 1'] := 10; //Form1.frxReport.Variables['My Variable 2'] := ''''+'Hello'+''''; //Form1.frxReport.ShowReport; end;
Thank you very much Dmitry. I will try it out
Really appreciated
63 2019-09-05 19:40:34
Re: Possible Error (6 replies, posted in General)
Please see this attachment
Please select details as follow
Make sure to select the bill in stage 2
Do not make payment
Select a statement to print in stage 4
Click on the print button.
You will realize that a new record will be added to the "STATEMENT OF COLLECTION"
Help please
64 2019-09-05 18:43:29
Re: Possible Error (6 replies, posted in General)
Hi Derek, please the project is already attached.
I have also attached an image.
65 2019-09-05 16:31:24
Topic: Possible Error (6 replies, posted in General)
Hello Dmitry, Derek and MVD lovers, please take a look at the attached and help me figure this out.
When I click on "REPORT SQL" button, a "SAVE RECORD" Button is forcly submitted.
But when the frmPayment form becomes the main form the error does not show.
Help
Thank you
66 2019-09-03 08:25:24
Re: tablegrid check box (12 replies, posted in General)
Hello.
Added. Please download latest beta version
https://www.dropbox.com/s/53bhjcbbu6jr3 … a.zip?dl=0
This is great.
Five stars to DriveSoft.
It will also be very nice if there is an option for the delete button to delete all checked in tableGrid without hard code.
I hope Dmtry will consider this.
Thank you
67 2019-08-29 07:47:45
Re: [SOLVED] TagbleGrid, Pagination, Footer and Offset (62 replies, posted in General)
Thank you @jean.brezhonek, but what I wanted was a way to get the nav control in MVD.
The control itself.
68 2019-08-29 02:53:56
Re: [SOLVED] TagbleGrid, Pagination, Footer and Offset (62 replies, posted in General)
Good day family,
Please is there a way to create the following nav menu?
Thank you.
69 2019-08-27 21:32:19
Re: [SOLVED] Changing location of MVD compiled app files (5 replies, posted in General)
It worked perfectly.
Thank you so much.
Just as I wanted.
Really appreciated
70 2019-08-27 19:37:41
Re: [SOLVED] Changing location of MVD compiled app files (5 replies, posted in General)
@ehwagner
Thank you so much.
I will try it
Really appreciated.
Will be so happy if this works.
71 2019-08-26 00:08:05
Re: [SOLVED] Changing location of MVD compiled app files (5 replies, posted in General)
Experimenting and trying to find another way of protecting apps built with MVD.
72 2019-08-25 13:21:35
Topic: [SOLVED] Changing location of MVD compiled app files (5 replies, posted in General)
Is there a way to change the location of the supporting files and folders of the compiled .exe?
Eg.
my app .exe will be in the folder
->c:/myAppFolder
Other files and folder like the "Report" and "Script" Folder, forms.xml, setting.ini and tables.ini will be located in
->documents/myAppFolder
What I want is to be able to change the location of supporting files and folder using a script in MVD.
Thanks.
73 2019-08-24 14:37:18
Re: School Fees Management System (14 replies, posted in General)
@Asifmute, what I did was to write SQL statement to retrieve the records I needed in the button using the "REPORT SQL" Action of the button.
Find attached the project.
74 2019-08-20 23:00:52
Re: School Fees Management System (14 replies, posted in General)
Hello Dmitry, Derek, sibprogsistem and mvd lovers,
I have another issue which I need your help.
The attached project can create student bills and can also assign the bills to the students. My problem now is how to generate the on print button click.
Please find attached for more details.
Thank you in advance.
I have been able to figure it out.
Thank you all
75 2019-08-20 18:56:22
Re: School Fees Management System (14 replies, posted in General)
Hello Dmitry, Derek, sibprogsistem and mvd lovers,
I have another issue which I need your help.
The attached project can create student bills and can also assign the bills to the students. My problem now is how to generate the on print button click.
Please find attached for more details.
Thank you in advance.