• Registered: 2014-08-16
  • Posts: 28

Topic: script for calculation

sir i am trying to learning yr mvdb with making little projects....
i want a help.. how to make the below attached file calculations using script?

Post's attachments

Attachment icon ex.zip 331.71 kb, 631 downloads since 2014-10-22 

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

Re: script for calculation

Please, download example project

Post's attachments

Attachment icon ex2.zip 2.61 kb, 642 downloads since 2014-10-22 

Dmitry.
  • Registered: 2014-08-16
  • Posts: 28

Re: script for calculation

sorry sir i dont want to consider - sign (negatiev).  ..?  all difference are in consider positiev value.? any change is possible ......
very very thanks in advance........

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

Re: script for calculation

fixed

Post's attachments

Attachment icon ex2.zip 2.62 kb, 677 downloads since 2014-10-22 

Dmitry.
  • Registered: 2014-08-16
  • Posts: 28

Re: script for calculation

thanks   agaaaaaaaaaaaaaaaaaain

  • Registered: 2014-08-16
  • Posts: 28

Re: script for calculation

when enter zero in text field , i  got a error msg" INVALID FLOATING POINT OPERATION' and some times errr msg " FLOATING POINT DIVISION BY ZERO''...   whats prblem sir?

Post's attachments

Attachment icon calculations.zip 333.58 kb, 656 downloads since 2014-11-02 

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

Re: script for calculation

error, because you can not divide by zero. When MaxColimn1 is Zero.
Fixed.

Post's attachments

Attachment icon calculations2.zip 5.87 kb, 673 downloads since 2014-11-03 

Dmitry.
  • Registered: 2014-08-16
  • Posts: 28

Re: script for calculation

SQLExecute ('INSERT INTO [worksheet] (picture) VALUES ("'+ form1.DBFile1.File +'")');






sir how to save a db file in a form  using script?

table name = worksheet
dataname =picture
form name= form1

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

Re: script for calculation

majuten
Unfortunately in the current version it is not possible to do using script.


You can do it using Button with Action "Save Record".

Dmitry.
  • Registered: 2014-08-16
  • Posts: 28

Re: script for calculation

sir any possibillity to change the database table name ?...  (TABLE A  rename in to  TABLE B )  I mean using Sqllite. and all the components using in different forms automaticaly Rename the New table name... any  hope?

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

Re: script for calculation

majuten
you can to rename table of database without lost data, if you rename table using tool SQLite Studio (http://sqlitestudio.pl/), then make a change in the structure of database in MVD, and answered "No" when the dialog asks to recreate the database.


Also you must manually rename table name in all components (property TableName)

Dmitry.