in .net using always @
On Wed, Aug 27, 2008 at 09:59, André Knappstein, Controlling <
[EMAIL PROTECTED]> wrote:
> Hello Steve,
>
> > join InvoiceDetail d ON (d.InvoiceID = :InvoiceID)
> > join InvoicePayment p ON (p.InvoiceID = :InvoiceID)
> > where (i.InvoiceID = :InvoiceID)
>
> Are parameters s
Hello Steve,
> join InvoiceDetail d ON (d.InvoiceID = :InvoiceID)
> join InvoicePayment p ON (p.InvoiceID = :InvoiceID)
> where (i.InvoiceID = :InvoiceID)
Are parameters supposed to work that way in ADO.net??
I always use "@" for a parameter identifier instead of ":"
regards,
André
--
--- Steve Harp <[EMAIL PROTECTED]> wrote:
> HI All,
>
>
>
> I'm trying to get invoice totals to show item totals and payments. I
> have 3
> tables; Invoice, InvoiceDetail, and InvoicePayment. I first tried a
> join
> like this.
>
>
[..]
I haven't tried it in NET, but am venturing a guess
ugust 27, 2008 7:53 AM
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provider] Help with SQL
Try this
select i.SiteID, i.InvoiceID,
Sum(COALESCE(d.Charge, 0)) AS Itm,
Sum(COALESCE(p.Amount, 0)) AS Pmt,
(Sum(COALESCE(d.Ch
Try this
select i.SiteID, i.InvoiceID,
Sum(COALESCE(d.Charge, 0)) AS Itm,
Sum(COALESCE(p.Amount, 0)) AS Pmt,
(Sum(COALESCE(d.Charge, 0)) + SUM(COALESCE(p.Amount, 0))) AS Total
from Invoice i
join InvoiceDetail d ON (d.InvoiceID = :InvoiceID)
join InvoicePayment p ON (p.InvoiceI
