This topic is locked
[SOLVED]

 How to use SUM

11/27/2015 12:03:07 PM
ASPRunnerPro General questions
R
Ramonxxd author

I used once on another project, but with the trial version, now I bought, however the code is calculating all fields, follows the code below.

Please Help Me
My Version Is ASPRunner Enterprise 9.1 (Build 24969 x86) <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=23511&image=1&table=forumtopics' class='bbc_emoticon' alt='B)' />
This is my table <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=23511&image=2&table=forumtopics' class='bbc_emoticon' alt=':angry:' />

SELECT

ID,

[data],

titulardaconta,

nomedofalecido,

localdocorpo,

estado,

cidade,

telefone,

possuijazigo,

sepulturasera,

funeralcheckbox,

funeralpreco,

urnabox,

urnapreco,

remocaobox,

remocaopreco,

veubox,

veupreco,

locacaobox,

locacaopreco,

prepdocorpobox,

prepdocorpopreco,

jogosbox,

jogospreco,

documentacaobox,

documentacaopreco,

sepultamentobox,

sepultamentopreco,

veloriobox,

veloriopreco,

coroadefloresbox,

coroadeflorespreco,

onamentosbox,

ornamentospreco,

velasbox,

velaspreco,

embalsamentobox,

embalsamentopreco,

livropresencabox,

livropresencapreco,

agentesocialbox,

agentesocialpreco,

transterrestrebox,

transterrestrepreco,

valordacontratacao,

autorizadopor,

para

FROM autorizacaosuda


now here is my SUM to calculated

SUM (funeralpreco +

urnapreco +

remocaopreco +

veupreco +

locacaopreco +

prepdocorpopreco +

jogospreco +

documentacaopreco +

sepultamentopreco +

veloriopreco +

coroadeflorespreco +

ornamentopreco +

velaspreco +

embalsamentopreco +

livropresencapreco +

agentesocialpreco +

transterrestrepreco) AS ValorTotal


But I Try to see the results, but this message appers

acaruson 11/27/2015



I used once on another project, but with the trial version, now I bought, however the code is calculating all fields, follows the code below.

Please Help Me
My Version Is ASPRunner Enterprise 9.1 (Build 24969 x86) <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=78348&image=1&table=forumreplies' class='bbc_emoticon' alt='B)' />
This is my table <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=78348&image=2&table=forumreplies' class='bbc_emoticon' alt=':angry:' />

SELECT

ID,

[data],

titulardaconta,

nomedofalecido,

localdocorpo,

estado,

cidade,

telefone,

possuijazigo,

sepulturasera,

funeralcheckbox,

funeralpreco,

urnabox,

urnapreco,

remocaobox,

remocaopreco,

veubox,

veupreco,

locacaobox,

locacaopreco,

prepdocorpobox,

prepdocorpopreco,

jogosbox,

jogospreco,

documentacaobox,

documentacaopreco,

sepultamentobox,

sepultamentopreco,

veloriobox,

veloriopreco,

coroadefloresbox,

coroadeflorespreco,

onamentosbox,

ornamentospreco,

velasbox,

velaspreco,

embalsamentobox,

embalsamentopreco,

livropresencabox,

livropresencapreco,

agentesocialbox,

agentesocialpreco,

transterrestrebox,

transterrestrepreco,

valordacontratacao,

autorizadopor,

para

FROM autorizacaosuda


now here is my SUM to calculated

SUM (funeralpreco +

urnapreco +

remocaopreco +

veupreco +

locacaopreco +

prepdocorpopreco +

jogospreco +

documentacaopreco +

sepultamentopreco +

veloriopreco +

coroadeflorespreco +

ornamentopreco +

velaspreco +

embalsamentopreco +

livropresencapreco +

agentesocialpreco +

transterrestrepreco) AS ValorTotal


But I Try to see the results, but this message appers



Try starting with just 2 or 3 values....add them....when you have success...keep adding one until it fails. Then you've found the one that's a problem.

admin 11/28/2015

Post your exact query here that gives you this error.

R
Ramonxxd author 11/30/2015



Post your exact query here that gives you this error.


Here is the code

SELECT

ID,

[data],

titulardaconta,

nomedofalecido,

localdocorpo,

estado,

cidade,

telefone,

possuijazigo,

sepulturasera,

funeralcheckbox,

funeralpreco,

urnabox,

urnapreco,

remocaobox,

remocaopreco,

veubox,

veupreco,

locacaobox,

locacaopreco,

prepdocorpobox,

prepdocorpopreco,

jogosbox,

jogospreco,

documentacaobox,

documentacaopreco,

sepultamentobox,

sepultamentopreco,

veloriobox,

veloriopreco,

coroadefloresbox,

coroadeflorespreco,

onamentosbox,

ornamentospreco,

velasbox,

velaspreco,

embalsamentobox,

embalsamentopreco,

livropresencabox,

livropresencapreco,

agentesocialbox,

agentesocialpreco,

transterrestrebox,

transterrestrepreco,

valordacontratacao,

autorizadopor,

para,

SUM (funeralpreco +

urnapreco +

remocaopreco +

veupreco +

locacaopreco +

prepdocorpopreco +

jogospreco +

documentacaopreco +

sepultamentopreco +

veloriopreco +

coroadeflorespreco +

ornamentopreco +

velaspreco +

embalsamentopreco +

livropresencapreco +

agentesocialpreco +

transterrestrepreco) AS ValorTotal

FROM autorizacaosuda

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=78356&image=1&table=forumreplies' class='bbc_emoticon' alt=':ph34r:' />

admin 11/30/2015

You do not need SUM there. Here it is:

SELECT

ID,

[data],

titulardaconta,

nomedofalecido,

localdocorpo,

estado,

cidade,

telefone,

possuijazigo,

sepulturasera,

funeralcheckbox,

funeralpreco,

urnabox,

urnapreco,

remocaobox,

remocaopreco,

veubox,

veupreco,

locacaobox,

locacaopreco,

prepdocorpobox,

prepdocorpopreco,

jogosbox,

jogospreco,

documentacaobox,

documentacaopreco,

sepultamentobox,

sepultamentopreco,

veloriobox,

veloriopreco,

coroadefloresbox,

coroadeflorespreco,

onamentosbox,

ornamentospreco,

velasbox,

velaspreco,

embalsamentobox,

embalsamentopreco,

livropresencabox,

livropresencapreco,

agentesocialbox,

agentesocialpreco,

transterrestrebox,

transterrestrepreco,

valordacontratacao,

autorizadopor,

para,

funeralpreco +

urnapreco +

remocaopreco +

veupreco +

locacaopreco +

prepdocorpopreco +

jogospreco +

documentacaopreco +

sepultamentopreco +

veloriopreco +

coroadeflorespreco +

ornamentopreco +

velaspreco +

embalsamentopreco +

livropresencapreco +

agentesocialpreco +

transterrestrepreco AS ValorTotal

FROM autorizacaosuda
R
Ramonxxd author 11/30/2015



You do not need SUM there. Here it is:

SELECT

ID,

[data],

titulardaconta,

nomedofalecido,

localdocorpo,

estado,

cidade,

telefone,

possuijazigo,

sepulturasera,

funeralcheckbox,

funeralpreco,

urnabox,

urnapreco,

remocaobox,

remocaopreco,

veubox,

veupreco,

locacaobox,

locacaopreco,

prepdocorpobox,

prepdocorpopreco,

jogosbox,

jogospreco,

documentacaobox,

documentacaopreco,

sepultamentobox,

sepultamentopreco,

veloriobox,

veloriopreco,

coroadefloresbox,

coroadeflorespreco,

onamentosbox,

ornamentospreco,

velasbox,

velaspreco,

embalsamentobox,

embalsamentopreco,

livropresencabox,

livropresencapreco,

agentesocialbox,

agentesocialpreco,

transterrestrebox,

transterrestrepreco,

valordacontratacao,

autorizadopor,

para,

funeralpreco +

urnapreco +

remocaopreco +

veupreco +

locacaopreco +

prepdocorpopreco +

jogospreco +

documentacaopreco +

sepultamentopreco +

veloriopreco +

coroadeflorespreco +

ornamentopreco +

velaspreco +

embalsamentopreco +

livropresencapreco +

agentesocialpreco +

transterrestrepreco AS ValorTotal

FROM autorizacaosuda



Thanks Admin and Acaruson For help It's Work <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=78359&image=1&table=forumreplies' class='bbc_emoticon' alt=':lol:' />

acaruson 11/30/2015

Just curious. Are you using ASPR to build all your queries...or do you also use a 3rd party tool, like DB Visualizer, etc.?

R
Ramonxxd author 12/2/2015



Just curious. Are you using ASPR to build all your queries...or do you also use a 3rd party tool, like DB Visualizer, etc.?



I Using ASPR to build all <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=78368&image=1&table=forumreplies' class='bbc_emoticon' alt=':lol:' />