UDF in 7.0

  • Is there any way that we can make UDFs in 7.0? My client has sql 7.0, and the system is developed using 2000 with user defined functions which cannot be implemented in clients end. Any suggestions?

    Thanks

    harriet

  • I think your client is stuck with upgrading to 2000.

    Cheers,

    - Mark


    Cheers,
    - Mark

  • He does not want to get rid of 7.0.

  • In that case the client will need to get the application customised for SQL 7.0.

    Cheers,

    - Mark


    Cheers,
    - Mark

  • Has he provided a specific reason for not wanting to upgrade? There is no way to get UDF's in SQL 7 you either write the logic in the client or you right a complex case statement in the query.

  • ,

    some s/w he uses run on 7.0 and they have no plans to upgrade them.

    there goes my last hope of trying to give a call to a udf in 7.0

    Thanks to you all ...

    harriet

  • quote:


    ,

    some s/w he uses run on 7.0 and they have no plans to upgrade them.

    there goes my last hope of trying to give a call to a udf in 7.0

    Thanks to you all ...

    harriet


    Don't forget that SQL 2000 allows you to set Database compatiblity modes. Might want to check into that with regards to his software.

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply