Re: Force SQL result fields to integer?

#1

"Larry DiGiovanni" <larryd (AT) digicoinc (DOT) com> wrote

Quote:

Karl Perry wrote:

Looks like I'll have to use CAST(). You're right, it should
return an Int, but it's returning an integer.

What are you looking at? An Int and an integer are the same thing, aren't
they?

Sorry - I mistyped. I meant to type "numeric" above but typed "integer"
instead.

I queried the same table several times using different date criteria:

SELECT ClientID, count(access) AS JuneTots (MayTots, etc.) FROM MyTable
WHERE EntryDate >= "06/01/2003" AND EntryDate <= "06/30/2003"

Then I queried for May, then for April, etc.

Sometimes the resulting column in the answer table was an integer, other
times it was a numeric.

When I later tried to combine things back together, I had problems and ended
up having to manually restructure all of the columns to the same type. It
was quite a hassle.

Karl

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Force SQL result fields to integer?

comp.databases.paradox comp.databases.paradox

Re: Force SQL result fields to integer? - 07-04-2003 , 01:29 PM