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é
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 supposed to
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.
select i.SiteID, i.InvoiceID,
NULLIF(Sum(d.Charge), 0) AS Itm,
NULLIF(Sum(p.Amount), 0) AS Pmt,
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.Charge, 0)) + SUM
--- 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 that this