Subject | Re: [IBO] Multiple UPDATE statements in one TIB_DSQL? |
---|---|
Author | Daniel Rail |
Post date | 2001-07-04T14:48:27Z |
At 07/04/2001 11:39 AM, you wrote:
input parameter and return the desired integer value as the output
parameter. This way you'll only need one update statement for both cases.
Here's an example of what the update statement would look like, the stored
procedure OwnRoundingProc is your stored procedure and it returns the
desired integer value:
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)
>Hi!No it's not possible. IB_Script is the component to use.
>
>is this possible?
>If not, how can I execute a sequence of UPDATE statementsHave you thought of creating a stored procedure? You pass the value as an
>that use parameters?
>
>Thanks.
>
>Tobias
>
>P.S.: Or is there a more elegant way than this to round *down* floats to
>full integer values?
input parameter and return the desired integer value as the output
parameter. This way you'll only need one update statement for both cases.
Here's an example of what the update statement would look like, the stored
procedure OwnRoundingProc is your stored procedure and it returns the
desired integer value:
>UPDATE BETRAEGEDaniel Rail
> SET Betrag=OwnRoundingProc(Betrag)
> WHERE (TYP=:STyp) AND (DATUM=:SDatum);
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)