My Visual Database — Sqlquery calculated field summation error

Re: Sqlquery calculated field summation error

null@example.com (domebil) — Sat, 21 Aug 2021 06:09:47 +0000

see now

Re: Sqlquery calculated field summation error

null@example.com (firstpharaon) — Sat, 21 Aug 2021 02:43:43 +0000

well i done this so far
what i have in mind is in one invoice i can add many products with it's price ad quantity showing it's total,
and for one customer to show how many invoices the customer bought with the total of each invoice.
but that's seem not working in the saving way for the tables or what am i doing wrong , how to make the grid to show only new items of products for new invoice and not all the records of the table

Re: Sqlquery calculated field summation error

null@example.com (sparrow) — Sat, 14 Aug 2021 22:09:30 +0000

Hi,
Now your queries are referring to a table "invoices" that you do not have .
Let's try to do this.
You will make your program to the maximum.
Now you have everything separately in the program.
Invoice form in its infancy).
Complete the invoice form without the total quantity and amount, but with all the fields that are required. Which order, which client, which products, quantity, how they are displayed ... perhaps you will understand how to calculate the cost by quantity.
If not, then let's talk.

Re: Sqlquery calculated field summation error

null@example.com (firstpharaon) — Fri, 13 Aug 2021 17:26:27 +0000

derek wrote:

It's difficult to offer any help without seeing your project (your link won't work for many of us based in Europe as zippyshare is blocked).
Delete the .exe file from your application and upload the remaining files as a .zip file.
Then explain as fully as possible exactly what you are trying to do.
Derek.

i'm not sure exactly what i'm doing wrong
i'm making an invoice application, to track customers purchases, payments and debets
i made products table, customer table and invoice detail table
so what i want is
when i create new invoice to select products and it's prices multiplication in it's quantities, for one invoice contain many products and to be linked to customer name and date.

i'm still working on it but the issue is when i try to make new invoice the DGV (data grid view) shows all the previous records while i want to make new invoice without old records

Re: Sqlquery calculated field summation error

null@example.com (sparrow) — Tue, 10 Aug 2021 13:15:38 +0000

Hi firstpharaon,
Look at this
Changed calculated field invoice.total and some changes in the settings of the table where there was an error.

Re: Sqlquery calculated field summation error

null@example.com (derek) — Mon, 09 Aug 2021 15:53:55 +0000

It's difficult to offer any help without seeing your project (your link won't work for many of us based in Europe as zippyshare is blocked).
Delete the .exe file from your application and upload the remaining files as a .zip file.
Then explain as fully as possible exactly what you are trying to do.
Derek.

Re: Sqlquery calculated field summation error

null@example.com (firstpharaon) — Mon, 09 Aug 2021 11:47:23 +0000

How can that be done, since invoice total value includes many products values * it's prices
I don't have one field to be linked to

Re: Sqlquery calculated field summation error

null@example.com (sparrow) — Tue, 03 Aug 2021 08:08:31 +0000

Hi. The error is that you are calling a calculated field from a calculated field. Rewrite the query or create a new one by calculating internally without calling the calculated field.

Re: Sqlquery calculated field summation error

null@example.com (firstpharaon) — Tue, 27 Jul 2021 16:02:37 +0000

i had to upload my project to zippyshare cause of The selected file was too large to upload
and uploaded file with it's link cause no links are allowed
the issue is in table dept

Re: Sqlquery calculated field summation error

null@example.com (tcoton) — Tue, 27 Jul 2021 15:39:17 +0000

According to the screenshot, there are too many wrong statements. If you want to write a sub-select, the second select statement should be in parenthesis and the "AS column_names" must be right behind the column name you select. Without your project or database description, it is a bit difficult to give you the right answer.

Sqlquery calculated field summation error

null@example.com (firstpharaon) — Tue, 27 Jul 2021 12:08:39 +0000

i have invoice table with calculated field that calculate amount multiple price to give total value and that for each customer
with this query "(select productP from products where invoices.id_products = products.id) * invoices.quantity "

i mad new table called dept where i want to show how much total invoice had one customer bought , but i get error with query
"select total from invoices where dept.id_invoices = invoices.id"

also made column settings formula = sum in tablegrid

i upload the error message