Re: SQL Query - precision error

Tech-Archive recommends: Fix windows errors by optimizing your registry

The database is a runny under SQL 2000. We cannot change the precision as
itis software set.

That said, why would I get a precision error when querying that database
from a Front Page query?

If I run the query in Query Analyzer without the Front Page Search variable,
it works fine.



"Kevin Spencer" wrote:

> Hi Art,
>
> Precision refers to the precision (number of digits, both to the right and
> left of the decimal point) in a floating point number. According to your
> field definition, the precision is 10, which means that you can store a
> decimal number with a maximum of 10 digits in it. The second number is
> scale, which is the number of digits allowed to the right of the decimal
> point of the number, which you've defined as 0 (IOW, you can store an
> integer with a maximum of 10 digits). I can't tell you much more, as you
> mentioned a "SQL table." SQL is a query language, and SQL Server is a
> database. Since a lot of non-database-professionals use the terms
> interchangeably, I don't know what kind of database you're using.
>
> --
> HTH,
>
> Kevin Spencer
> Microsoft MVP
> ..Net Developer
> Sometimes you eat the elephant.
> Sometimes the elephant eats you.
>
> "Art" <Art@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:97BDEFB4-A914-42A4-826A-85F2A115C7B0@xxxxxxxxxxxxxxxx
> >I am using a very basic query in Front Page 2002 against a SQL table
> >
> > SELECT * FROM tablename WHERE (f_docnumber = ::f_docnumber::)
> >
> > and f_docnumber is a search form field.
> >
> > When I run I get
> >
> > Description: The precision is invalid.
> > Number: -2147467259 (0x80004005)
> >
> > The field is defined in the table as numberic 9(10,0)
> >
> > Any ideas?
> >
> >
> > Thanks
> >
>
>
>
.

Relevant Pages

  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: complex filter and calculations in access
    ... switch to SQL view. ... query by switching to datasheet view, ... of your database using the from address in this post. ... pre-op infections yes/no ...
    (microsoft.public.access.queries)
  • Re: A little more meat this week
    ... implementation with a query processor capable of returning a result set ... then we can call it a result bag (SQL ... I'm looking at the data model and not database tools at this ... for a s/w developer and a s/w developer simplifies for the end user). ...
    (comp.databases.pick)
  • Re: complex filter and calculations in access
    ... when using a subquery on the same table as the main query, ... switch to SQL view. ... of your database using the from address in this post. ...
    (microsoft.public.access.queries)
  • Re: A little more meat this week
    ... said data includes lists." ... implementation with a query processor capable of returning a result set ... then we can call it a result bag (SQL ... I'm looking at the data model and not database tools at this ...
    (comp.databases.pick)