tsdeveloper
New member
- Local time
- Today, 19:22
- Joined
- Sep 3, 2013
- Messages
- 1
Personal goodnight sorry my english I'm Brazilian, I wonder where is wrong here.
Whenever you put this piece of code to subtract the Y.Debito - The Y.TOTALLANC Total in Total datagrid appears zeroed
'Code
querySQL1.Append ("SELECT Y.descricao, Y.Debito, Y.Debito - Y.Valor_Lanc TOTAL AS" & _
************************** "FROM (SELECT fb.FinanFP_Descricao AS description, SUM (iif (VndFinan_Credito = true, VndFinan_ValorLanc) AS Valor_Lanc, SUM (iif (fv.VndFinan_Debito = true, fv.VndFinan_ValorLanc)) AS Debit" & _
************************** "Venda_Financeiro fv FROM INNER JOIN ON Financeiro_FormaPagto fb fv.VndFinan_FormaPagto fb.FinanFP_Id =" & _
************************** "GROUP BY fb.FinanFP_Descricao) the Y")
But if I just call it Y.TOTALLANC list usually through payment
**** _querySQL1.Append ("SELECT Y.descricao, Y.Debito, Y.Valor_Lanc TOTAL AS" & _
************************** "FROM (SELECT fb.FinanFP_Descricao AS description, SUM (iif (VndFinan_Credito = true, VndFinan_ValorLanc) AS Valor_Lanc, SUM (iif (fv.VndFinan_Debito = true, fv.VndFinan_ValorLanc)) AS Debit" & _
************************** "Venda_Financeiro fv FROM INNER JOIN ON Financeiro_FormaPagto fb fv.VndFinan_FormaPagto fb.FinanFP_Id =" & _
************************** "GROUP BY fb.FinanFP_Descricao) the Y")
Can you give a hint?
Whenever you put this piece of code to subtract the Y.Debito - The Y.TOTALLANC Total in Total datagrid appears zeroed
'Code
querySQL1.Append ("SELECT Y.descricao, Y.Debito, Y.Debito - Y.Valor_Lanc TOTAL AS" & _
************************** "FROM (SELECT fb.FinanFP_Descricao AS description, SUM (iif (VndFinan_Credito = true, VndFinan_ValorLanc) AS Valor_Lanc, SUM (iif (fv.VndFinan_Debito = true, fv.VndFinan_ValorLanc)) AS Debit" & _
************************** "Venda_Financeiro fv FROM INNER JOIN ON Financeiro_FormaPagto fb fv.VndFinan_FormaPagto fb.FinanFP_Id =" & _
************************** "GROUP BY fb.FinanFP_Descricao) the Y")
But if I just call it Y.TOTALLANC list usually through payment
**** _querySQL1.Append ("SELECT Y.descricao, Y.Debito, Y.Valor_Lanc TOTAL AS" & _
************************** "FROM (SELECT fb.FinanFP_Descricao AS description, SUM (iif (VndFinan_Credito = true, VndFinan_ValorLanc) AS Valor_Lanc, SUM (iif (fv.VndFinan_Debito = true, fv.VndFinan_ValorLanc)) AS Debit" & _
************************** "Venda_Financeiro fv FROM INNER JOIN ON Financeiro_FormaPagto fb fv.VndFinan_FormaPagto fb.FinanFP_Id =" & _
************************** "GROUP BY fb.FinanFP_Descricao) the Y")
Can you give a hint?
Last edited: