![]() ![]() ![]() Now, when running the application should be similar to the following image where we will be asked to enter User, Amount and select the number of months. That will avoid requesting the variables when running the application. In order to ensure that the sum of the quotas and the total to be paid are equal we apply to the last quota the difference between the Total to be paid and the sum of quotas previously inserted.Īfter finishing writing the code, if we execute it will appear the white screen requesting the assignment of values to variables used in the application.īecause our variables are for internal use and we do not expect to receive them, we must change the Variable Type to “Out”. It should be mentioned that this macro allows us to execute any SQL Statement on the Database Server, so it is very useful for executing stored procedures or even maintenance tasks.įor the last installment (month) we will give special treatment because the rounding of the division sometimes may not be exact, which would cause in the end that the Total to be paid and the sum of quotas are not equal.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |