Sqlite calculating

If you need help with a project or need to know how to do something specific in VB.NET then please ask your questions in here.
Forum rules
Please LOCK your topics once you have found the solution to your question so we know you no longer require help with your query.
2 posts Page 1 of 1
Contributors
User avatar
Dummy1912
VIP - Donator
VIP - Donator
Posts: 1969
Joined: Sat Aug 21, 2010 2:17 pm

Sqlite calculating
Dummy1912
Hello,

Can someone help me out please
i can't get it to work
Code: Select all
            attributes = "mypayments.num,mypayments.mdate,mypayments.mamount,mydebtsborrow.mamount,mydebtsborrow.mamount - mypayments.mamount"

its keep the same value :(
like we have 26.731,32 we want to calculate that by 318.23 and then get the output
and then we don't know how we can use that output again to calculate it again by the next record

the first record sum shows as: 26.413,09
the mypayments.mamount records have only 318.23 as amount
and the basic of this account mydebtsborrow.mamount has 26.731,32

so when we calculate it all i need at the end of the data 19.730,26

Thank you
visit us on:


http://www.softpedia.com/get/System/Lau ... -Run.shtml
Check it out ! http://www.softpedia.com/publisher/I-A- ... 90017.html
Check it out ! http://www.softpedia.com/get/Desktop-En ... lock.shtml
User avatar
Dummy1912
VIP - Donator
VIP - Donator
Posts: 1969
Joined: Sat Aug 21, 2010 2:17 pm

Re: Sqlite calculating
Dummy1912
This is the code in sqlite itself
but i can't manage it to work what we are looking for :(
Code: Select all
SELECT mypayments.num,mypayments.mamount,mydebtsborrow.mamount,mydebtsborrow.mamount - mypayments.mamount as TOTAL FROM mypayments left JOIN mydebtsborrow ON mydebtsborrow.num = mypayments.mnum WHERE mypayments.mnum=6 ORDER BY mypayments.num DESC ;
visit us on:


http://www.softpedia.com/get/System/Lau ... -Run.shtml
Check it out ! http://www.softpedia.com/publisher/I-A- ... 90017.html
Check it out ! http://www.softpedia.com/get/Desktop-En ... lock.shtml
2 posts Page 1 of 1
Return to “Coding Help & Support”