Re: ODBC and select count
From: Muhammad Ismail Thahim <ismail_at_super.net.pk>
Date: Wed, 30 Jun 1999 08:10:21 +0500
Message-ID: <37798A9C.E9267FF8_at_super.net.pk>
Date: Wed, 30 Jun 1999 08:10:21 +0500
Message-ID: <37798A9C.E9267FF8_at_super.net.pk>
first define a variable length 1
then select count (*) into variable
this will solve ur problem
ismail
support email wrote:
> On 19 Jun 1999 16:34:00 +0200, cweiss_at_miami.ruhr.de (Christian Weiss)
> wrote:
>
> >Hi,
> >
> >I've a problem with ODBC included in Oracle v7.4.3 running on Windows-PCs.
> >
> >The SQL-Statement 'select count(*) from something' returns the number plus
> >a point, eg. 7.
> >
> >'IF xyz = 7' fails, because xyz = 7.
> >
> >Is there a way to set this up?
> >
> >Thanks,
> >
> >Christian Weiss
>
> Sounds like it is getting bound as a floating point number by the
> calling application.
Received on Wed Jun 30 1999 - 05:10:21 CEST