76

(14 replies, posted in General)

sibprogsistem wrote:
procedure Form1_TableGrid1_OnClick (Sender: TObject);
begin
ShowMessage(Form1.TableGrid1.Cells[1,Form1.TableGrid1.SelectedRow]);
end;

 
TableGrid1_OnClick

Thank you so much for your support

77

(14 replies, posted in General)

k245 wrote:

Make this change in your project:

procedure Form1_TableGrid1_OnCellClick (Sender: TObject; ACol, ARow: Integer);
begin
  ShowMessage(Form1.TableGrid1.Cells(1,ARow));
end;

Thanks for the prompt response.
I really appreciate it
It works perfectly

78

(14 replies, posted in General)

Hello family, please how can I show a message of the cell of a tableGrid when that cell is clicked.
I have tried several times but to no avail.

It only works when the event is in a button, but what I want is the event should trigger on tableGrid onCellClick.
Thank you

79

(14 replies, posted in General)

Thanks so much
It worked perfectly

80

(14 replies, posted in General)

Thank you Derek.
You have really made the work so easy. Really appreciated.
Follow up question

fname ||" "|| lname ||" "|| oname

I am using the above code in a calculated field of the database but if the oname is blank, it shows empty record in the tableGrid. Please, any help?
Thank you in advance.

81

(14 replies, posted in General)

Hello Derek and mvd users,
I'm trying to do something about the above topic. Please can you take a look at the sample and help me with the note specified in the project?

I'm trying to add all members in a class from a combobox to a table in the database.
Any help will be appreciated.

82

(14 replies, posted in General)

Please, can anyone help me with a sample project on the above subject?

Details
*Register students, class, academic year and term
*Fees are created for three terms in a year
*Balance should be brought forward the next academic year
*Admin will create fees eg. For Academic year 2018/2020, term 1
Tuition fee= 20
Ict fee =2 etc
*Fees will be assigned to each class for a term in the academic year

Thank you in advanced

83

(13 replies, posted in General)

Hi Derek,
Please can you make an example of the payroll with the following features added?
1. Category of workers(eg. Director, manager etc)
Each category should have fixed amounts assigned to them. Eg. The basic salary for director is 2000.
This means if a worker is director then automatic the basic amount is assigned to him.

I mean each position should have a set of categories assigned to that position and then I can add other duties to them.
Tnx

84

(7 replies, posted in General)

Follow this post for more examples
http://myvisualdatabase.com/forum/viewtopic.php?id=4447

85

(187 replies, posted in General)

It's great to have this important updates.
Since the update below has been made
Added the ability to set the alignment for columns
I suggest if you can please add the following
1. Alignment for Column Header
2. Alignment for Column Footer
3. Column width
4. Column color
5. Column cellPadding
6. Cell Color (with condition eg. If < 0, red)
Regards

Thank you Dmitry. But I still couldn't get it to work.

DriveSoft wrote:

Just replace sqlite.dll file in your project folder and test it.

The sqlite dll for sqlite 2 gets overwritten/replaced when I run MVD.

Thank you boss
I will try it

Can MVD work with sqlite 2.8?
I have a project using sqlite 2 as the database and would like to connect MVD to that project. Is there a way to make MVD work with sqlite 2. I also know sqlite 2 is outdated but I wish to connect to it through MVD.
Thank you.

Thank you boss

(select count(*) from tbdata where items LIKE {edit1})

Please why is the above code not working in calculated Field. What is the right way.
Thank you in advance.

92

(13 replies, posted in General)

DriveSoft wrote:

Beta version 5.2
https://www.dropbox.com/s/mb8hyuevvu8x5 … a.zip?dl=0


What's new?
- Added the ability to set the alignment for columns
http://myvisualdatabase.com/forum/misc.php?action=pun_attachment&amp;item=4945&amp;download=0


- Added properties to control the visibility of buttons on the RichEdit component toolbar
- A button with action "Open in Excel" now support Open/Libre Office calc and auto mode
- WebGrid now supports PHP7
- Now you can use all functions MVD In Report Script
- Added function SaveFileFromDataBaseToStream
- Other minor improvements.


It's great to have this important updates.
Since the update below has been made
Added the ability to set the alignment for columns
I suggest if you can please add the following
1. Alignment for Column Header
2. Alignment for Column Footer
3. Column width
4. Column color
5. Column cellPadding
6. Cell Color (with condition eg. If < 0, red)
Regards

Please find attached a sample project to demonstrate the problem I'm facing with the calculated Field with aggregate 'count'.
tableGrid not listing all rows when the aggregate function COUNT is used in the calculated Field.
Any help?

Regards

Thank you Derek for your quick response.
But what I'm requesting is a feature request or an update on the tableGrid with features like

Form1.tableGrid1.dbTotalRowsFromDatabase // this will count the total rows in the table of the database not tableGrid
Form1.tableGrid1.dbAffectRows// this will count the total affected rows in the database from the select Statement embed in the tableGrid.

I have been testing MVD for practice and testing purposes and wish to make some recommendations.
This becomes very handy when one uses the limit and page offset which will not list all data from the database.
This will also reduce the number of queries sent to the database since the tableGrid would have already queried the database for that data.
Thank you.

Hello
I want to get the total rows in a table and also the total affect rows from a select Statement without coding.
I wish this can be attached to the tableGrid during the select of the Grid.
Example

Form1.tableGrid1.dbTotalRowsFromDatabase // this will count the total rows in the table of the database not tableGrid
Form1.tableGrid1.dbAffectRows// this will count the total affected rows in the database from the select Statement embed in the tableGrid.
Thank you in advance

Okay

Any response?
Regards

98

(13 replies, posted in General)

This is great.
Good to know that the columns of the tableGrid can now be aligned without script. Thus, it can now be done within MVD.
5 Stars

gonpublic2k wrote:
ekuaeshun13 wrote:
rodmontgt wrote:

Trying to run your project in MVD 5.0 but it throw an error, see the attachment please

You have to set frmDashboard as the default form.
I can see that you have changed it from being default.
Just make it default and it will work.
It worked for me

I finally got Apache to run fine and MySQL and I ran your project and it worked perfectly for me.  Now time to study it well and improve it!

@gonpublic2k
Any improvement on the POS project?
Let us know if you have been able to do a major update on the project. Share with us.
Regards

100

(5 replies, posted in General)

chanthait wrote:

how can i we convert number to word

Ex: 100 to one hundred

Follow this post for more examples
http://myvisualdatabase.com/forum/viewtopic.php?id=4480
Regards