Post reply

Help on query errors

  • December 1, 2004 at 3:10 pm

    #86098

    Hello all,

    One of my folks submitted a question to me and I'm not sure how to answer, can anyone help me?  Here's the question:

    I have a job that queries a view.   This view is created by a query.  Each time the query is called, it returns a divide by 0 error.  The query builder does not support the Set command so I can't turn off the necessary functions to run the query.   Is there any way to set this up as standard on the dbase?

    The Set commands I had advised him to use were:

    SET ANSI_WARNINGS OFF

    SET ARITHABORT OFF

    SET ARITHIGNORE ON

    but that's when I thought he'd be using a stored procedure - he isn't and query-builder doesn't recognize this command.

    Any help would be much appreciated

  • December 1, 2004 at 5:11 pm

    #532122

    Please post the query that is generating the error and details of how it is submitted - eg are you using a pass-through query in Access?

    You may be receiving the error as a result of a calculated field within the view being incorrectly structured - have you checked the columns in the view for possible divide-by-zero situations?

    Surely you do not want to ignore this error (as your use of SET instructions would imply)? I would recommend that you fix the underlying problem rather than hide it

    Phil

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • December 1, 2004 at 5:29 pm

    #532124

    Hello Phil:

    thanks for your quick response -- before i start posting queries i'll check the formulae and also the data -- this is not a dbase i'm familiar with -- i'll be back in 1/2

Viewing 3 posts - 1 through 2 (of 2 total)

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