51

(11 replies, posted in General)

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.

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

(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

(14 replies, posted in General)

Try this simple took to convert access to MySQL
http://www.bullzip.com/products/a2m/info.php

55

(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

(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

(5 replies, posted in General)

Can you elaborate a little bit on the problem?

58

(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

(4 replies, posted in General)

humblelion wrote:

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

(187 replies, posted in General)

DriveSoft wrote:

Please download latest beta version
https://www.dropbox.com/s/6n60thhfaszoj … a.zip?dl=0


I 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

(187 replies, posted in General)

Please, how do I add menu to trayIcon when MinimizeToTray is enabled of a form
Thank you.

62

(6 replies, posted in General)

DriveSoft wrote:

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

(6 replies, posted in General)

Please see this attachment
Please select details as follow
https://i.postimg.cc/Y9Vbqzwp/fee-Man-Error1.png

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
https://i.postimg.cc/tJxD1nXF/fee-Man-Error2.png

64

(6 replies, posted in General)

Hi Derek, please the project is already attached.
I have also attached an image.

65

(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
https://i.postimg.cc/90WKjMmV/fee-Man-Error.png

66

(12 replies, posted in General)

DriveSoft wrote:

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

Thank you @jean.brezhonek, but what I wanted was a way to get the nav control in MVD.
The control itself.

Good day family,
Please is there a way to create the following nav menu?
Thank you.

It worked perfectly.
Thank you so much.
Just as I wanted.
Really appreciated

@ehwagner
Thank you so much.
I will try it
Really appreciated.
Will be so happy if this works.

Experimenting and trying to find another way of protecting apps built with MVD.

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

(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

(14 replies, posted in General)

thezimguy wrote:

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

(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.