Post reply

select query modification

  • April 15, 2009 at 7:17 am

    #978043

    Hi

    i am retriving data using myeclipse7.1 editor in this editor ISNULL(STATE, 'all') or COALESCE(STATE, 'all') these functions are not working.wat can i do.

  • April 15, 2009 at 7:39 am

    #978065

    bvinay57 (4/15/2009)

    Hi

    i am retriving data using myeclipse7.1 editor in this editor ISNULL(STATE, 'all') or COALESCE(STATE, 'all') these functions are not working.wat can i do.

    I'm very sorry bvinay, I have no knowledge at all of this package. However, if these two functions are not working, it's possible that the queries are not being passed directly to the SQL server. There are forums for myeclipse which may help you with this problem - then there is of course their own website[/url].

    Good luck!

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

  • April 16, 2009 at 5:09 am

    #978711

    hello

    You must use ISNULL(,'all') instead of using

    ISNULL('all',)

    as i have seen what u r using in your replies

Viewing 3 posts - 16 through 17 (of 17 total)

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