overflow error

[Guest]

I have a query that runs fine until I put >0 in the criteria. When I do that
and try to run the query I get an error "OVERFLOW". The SQL for the query is:

SELECT FullYrDeprMichele1.intAssetCost, FullYrDeprMichele1.AccumDeprec,
[intAssetCost]-[AccumDeprec] AS [Book Value],
FullYrDeprMichele1.intCostCenter, FullYrDeprMichele1.[intTag#],
FullYrDeprMichele1.ingPONumber, FullYrDeprMichele1.strLocation,
FullYrDeprMichele1.strDescription, FullYrDeprMichele1.dtmInServiceDate,
FullYrDeprMichele1.Strlife, FullYrDeprMichele1.MonthlyDeprec,
FullYrDeprMichele1.TotCurrPd
FROM FullYrDeprMichele1
WHERE (((FullYrDeprMichele1.TotCurrPd)>0));

 

[Guest]

hi,

There could be a few things wrong:

Check the datatype of the [FullYrDeprMichele1.TotCurrPd] column.
Depending on the datatype, there may need to be some quotes utilized.
check the size of your Db. Dbs approaching the 1.89GB size may generate this
error.

Hope this helps,
geebee

 

[Guest]

Thank you for your response.

The datatype is set to currency. Is that it? The thing is I use this same
database with other facilities and I have the >0 in the query and it works.
It is just all of a sudden that this is a problem for this one place.

The database isn't even close to that size, so I don't think that is the
problem.

hi,

There could be a few things wrong:

Check the datatype of the [FullYrDeprMichele1.TotCurrPd] column.
Depending on the datatype, there may need to be some quotes utilized.
check the size of your Db. Dbs approaching the 1.89GB size may generate this
error.

Hope this helps,
geebee

I have a query that runs fine until I put >0 in the criteria. When I do that
and try to run the query I get an error "OVERFLOW". The SQL for the query is:

SELECT FullYrDeprMichele1.intAssetCost, FullYrDeprMichele1.AccumDeprec,
[intAssetCost]-[AccumDeprec] AS [Book Value],
FullYrDeprMichele1.intCostCenter, FullYrDeprMichele1.[intTag#],
FullYrDeprMichele1.ingPONumber, FullYrDeprMichele1.strLocation,
FullYrDeprMichele1.strDescription, FullYrDeprMichele1.dtmInServiceDate,
FullYrDeprMichele1.Strlife, FullYrDeprMichele1.MonthlyDeprec,
FullYrDeprMichele1.TotCurrPd
FROM FullYrDeprMichele1
WHERE (((FullYrDeprMichele1.TotCurrPd)>0));

 

[Guest]

Hi,

Here is what I am thinking...
During the transition to where you are using the Db, there may have been
some data entered that does not fit the format. Check the data in that
column to make sure it's all Kosher.

Hope this helps. Also, try another number, such as 3 or something.
However, the syntax you have here of ...>0 is not the problem. This makes me
think it is something wrong with some of the data in the column.

Hope this helps.

Thank you for your response.

The datatype is set to currency. Is that it? The thing is I use this same
database with other facilities and I have the >0 in the query and it works.
It is just all of a sudden that this is a problem for this one place.

The database isn't even close to that size, so I don't think that is the
problem.

hi,

There could be a few things wrong:

Check the datatype of the [FullYrDeprMichele1.TotCurrPd] column.
Depending on the datatype, there may need to be some quotes utilized.
check the size of your Db. Dbs approaching the 1.89GB size may generate this
error.

Hope this helps,
geebee

I have a query that runs fine until I put >0 in the criteria. When I do that
and try to run the query I get an error "OVERFLOW". The SQL for the query is:

SELECT FullYrDeprMichele1.intAssetCost, FullYrDeprMichele1.AccumDeprec,
[intAssetCost]-[AccumDeprec] AS [Book Value],
FullYrDeprMichele1.intCostCenter, FullYrDeprMichele1.[intTag#],
FullYrDeprMichele1.ingPONumber, FullYrDeprMichele1.strLocation,
FullYrDeprMichele1.strDescription, FullYrDeprMichele1.dtmInServiceDate,
FullYrDeprMichele1.Strlife, FullYrDeprMichele1.MonthlyDeprec,
FullYrDeprMichele1.TotCurrPd
FROM FullYrDeprMichele1
WHERE (((FullYrDeprMichele1.TotCurrPd)>0));

 

[Guest]

Hi,

Also...
I don't see it in your query anywhere, but if the column type is truly
"Currency", then you may be dividing by Zero somewhere. or any value that is
close to zero.

Hi,

Here is what I am thinking...
During the transition to where you are using the Db, there may have been
some data entered that does not fit the format. Check the data in that
column to make sure it's all Kosher.

Hope this helps. Also, try another number, such as 3 or something.
However, the syntax you have here of ...>0 is not the problem. This makes me
think it is something wrong with some of the data in the column.

Hope this helps.

Thank you for your response.

The datatype is set to currency. Is that it? The thing is I use this same
database with other facilities and I have the >0 in the query and it works.
It is just all of a sudden that this is a problem for this one place.

The database isn't even close to that size, so I don't think that is the
problem.

hi,

There could be a few things wrong:

Check the datatype of the [FullYrDeprMichele1.TotCurrPd] column.
Depending on the datatype, there may need to be some quotes utilized.
check the size of your Db. Dbs approaching the 1.89GB size may generate this
error.

Hope this helps,
geebee



:

I have a query that runs fine until I put >0 in the criteria. When I do that
and try to run the query I get an error "OVERFLOW". The SQL for the query is:

SELECT FullYrDeprMichele1.intAssetCost, FullYrDeprMichele1.AccumDeprec,
[intAssetCost]-[AccumDeprec] AS [Book Value],
FullYrDeprMichele1.intCostCenter, FullYrDeprMichele1.[intTag#],
FullYrDeprMichele1.ingPONumber, FullYrDeprMichele1.strLocation,
FullYrDeprMichele1.strDescription, FullYrDeprMichele1.dtmInServiceDate,
FullYrDeprMichele1.Strlife, FullYrDeprMichele1.MonthlyDeprec,
FullYrDeprMichele1.TotCurrPd
FROM FullYrDeprMichele1
WHERE (((FullYrDeprMichele1.TotCurrPd)>0));

 

[Jamie Collins]

I don't see it in your query anywhere, but if the column type is truly
"Currency", then you may be dividing by Zero somewhere

Let's hope this is based on another query i.e. you've got to worry
about a data model with a *base* table named 'FullYrDeprMichele1' <g>.

Although unlikely, CURRENCY values can of course themselves overflow
e.g.

SELECT CCUR(-5E14) AS intAssetCost,
ABS(intAssetCost) AS AccumDeprec,
intAssetCost - AccumDeprec AS [Book VALUE]

Jamie.

--