• Registered: 2015-12-24
  • Posts: 55

Topic: tablegrid auto fill & calculate

dear developers & members,
pls. help me in the project.
i need some data to be automatically filled in the table grid, but don't know how to do this.
i have attach a image for illustration.

any suggestions....

Post's attachments

Attachment icon trail.png 18.83 kb, 257 downloads since 2016-08-28 

  • Registered: 2014-02-14
  • Posts: 10,294

Re: tablegrid auto fill & calculate

I can help you only with specific question.


You can't filled table grid manually, you can only save data to database and show it in the table grid.

Dmitry.
  • Registered: 2015-12-24
  • Posts: 55

Re: tablegrid auto fill & calculate

i need the table grid to be filled automatically upon clicking the calculate button .
the data to be filled is as per the example given in the attached image.

thanks...

  • Registered: 2014-02-14
  • Posts: 10,294

Re: tablegrid auto fill & calculate

nrmuduli wrote:

i need the table grid to be filled automatically upon clicking the calculate button .
the data to be filled is as per the example given in the attached image.

thanks...

You should save data to database (using button with action "Save Record") only after that table grid can be filled with this data.

Dmitry.
  • Registered: 2015-12-24
  • Posts: 55

Re: tablegrid auto fill & calculate

Ok
As far as i understand, i need to use sql insert statement to insert calculated data in the database then show in the grid.
but how to set variable, calculate data & insert into database.

  • Registered: 2014-02-14
  • Posts: 10,294

Re: tablegrid auto fill & calculate

nrmuduli wrote:

Ok
As far as i understand, i need to use sql insert statement to insert calculated data in the database then show in the grid.
but how to set variable, calculate data & insert into database.

You don't need to use sql queries to calculate data. Please check out this example, how to do calculate data on form using script
http://myvisualdatabase.com/forum/viewtopic.php?id=1416

Dmitry.