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
My Visual Database → Posts by thezimguy
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
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
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
Thanks so much
It worked perfectly
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.
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.
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
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
Follow this post for more examples
http://myvisualdatabase.com/forum/viewtopic.php?id=4447
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.
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.
Beta version 5.2
https://www.dropbox.com/s/mb8hyuevvu8x5 … a.zip?dl=0What's new?
- Added the ability to set the alignment for columns- 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
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
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 meI 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
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
My Visual Database → Posts by thezimguy
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi