| Subject | Re: [firebird-support] How do I translate this piece of SqlServer stored proc code ? |
|---|---|
| Author | Helen Borrie |
| Post date | 2008-03-09T08:15:14Z |
At 05:22 PM 9/03/2008, you wrote:
All of the binary arithmetic UDFs were ported into the 2.1 server as internal functions, along with BIN_SHR and BIN_SHL, but there's still no BIN_NOT. I have asked WHY_NOT. ;-)
But you could take a look at the code for the others and write your own BIN_NOT UDF...or play about with BIN_SHR and BIN_SHL operators if you can find a UDF library that has them.
./heLen
>Hi,Not very easily. Firebird has UDFs for BIN_AND (MS$ & operator) and BIN_OR (MS$ | pipe operator) but not one for BIN_NOT (MS$ ~ tilde operator).
>
>I need to convert a bunch of stored procs from SqlServer to Firebird (I
>am using 1.5).
>
>One of the lines in a proc is the following:
>
>pA_Indicator = (piOrigIndicatoren & ~pMask ) | pA_Indicator;
>
>
>How do I translate this into Firebird.
All of the binary arithmetic UDFs were ported into the 2.1 server as internal functions, along with BIN_SHR and BIN_SHL, but there's still no BIN_NOT. I have asked WHY_NOT. ;-)
But you could take a look at the code for the others and write your own BIN_NOT UDF...or play about with BIN_SHR and BIN_SHL operators if you can find a UDF library that has them.
./heLen