Good Morning!

Of course! I should have done that first!

Here is the stub of two sp's. The both give the
same error:

Create Procedure sp_Invoice_Labor
(ServiceOrderId Integer)
Returns
(
...
)
As
Begin
SELECT ...
FROM LABORDETAIL A
JOIN CLIENTEQUIPMENT B ON
A.CLIENTEQUIPMENTID=B.CLIENTEQUIPMENTID
WHERE A.SERVICEORDERID=:SERVICEORDERID
Into ...;
Suspend;
End /* Procedure sp_Invoice_Labor */

and:

Create Procedure sp_Invoice_Parts
(ServiceOrderId Integer)
Returns
(
...
)
As
Begin
SELECT ...
FROM PARTDETAIL A
JOIN PRODUCT B ON A.PRODUCTID=B.PRODUCTID
LEFT OUTER JOIN CLIENTEQUIPMENT CE ON
CE.CLIENTEQUIPMENTID=A.CLIENTEQUIPMENTID
WHERE A.SERVICEORDERID=:SERVICEORDERID
Into ...;
Suspend;
End /* Procedure sp_Invoice_Labor */

Each of these, and others, are intended to replace
a TQuery that is extracting the same data. I am trying
to speed up a report.

There are no other sp's with the same parameter as
these will have.

Thanks...Dan'l


--- Helen Borrie <helebor@...> wrote:

> At 10:59 AM 14-10-02 +0000, you wrote:
> >Good Morning!
> >
> > Well, I am trying to create different sp's,
> each one having only
> >one parameter, using the same variable name as the
> parameter.
> >
> > However, when I changed the parameter name to
> something unique, I
> >got the same error.
> >
> > I am using FB 1 on NT 4.
> >
> > Thanks...Dan'l
>
> Well, it would reveal a lot if you showed us the
> exact CREATE PROCEDURE
> code that is causing the error.
>
> heLen
>
>

=====
____________________________________
Every day is a Great day, but
some days are GREATER than others!

__________________________________________________
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos & More
http://faith.yahoo.com