Calc Invoices to Pay?

Fairlight fairlite at fairlite.com
Tue Mar 4 05:58:56 PST 2008


At Tue, Mar 04, 2008 at 08:47:19AM -0500 or thereabouts, 
suspect Walter Vaughan was observed uttering:
> Fairlight wrote:
> 
> > <>This public service announcement was brought to you by Stanley Barnett:
> >
> > I need a routine that can find the correct invoices quickly by only
> > supplying the check amount. We are assuming the customer did not
> > partial pay an invoice.
> >
> >
> >I don't think that's possible to do with 100% accuracy.  
> >
> Hum... perhaps this is a place that fpSQL might be of help.
> You should be able to find things like this that would not require 
> writing code or understanding selection set development.

I think you missed a critical part.  He's not just matching individual
checque amounts, he's matching one sum against multiple cheques.  Please
show me the SQL statement that would come even remotely close--because I
don't believe it exists even in Oracle, much less fPSQL.

> ...SCO Unix free now for 9 days...long live BSD !

Grats!

mark->
-- 
Fairlight->   ||| "There's an unceasing wind that    | Fairlight Consulting
  __/\__      ||| blows through this night / There's |
 <__<>__>     ||| dust in my eyes that blinds my     | http://www.fairlite.com
    \/        ||| sight / Theres a silence that      | info at fairlite.com
              ||| speaks so much louder than words / |
              ||| Of promises broken..." --          |
              ||| Gilmour/Floyd                      |


More information about the Filepro-list mailing list