Re: Syntax error converting varchar 1.8 to a column of datatype int.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

why would you use float ever anywhere?

I don't get it

On Mar 7, 4:28 pm, "Sylvain Lafontaine" <sylvain aei ca (fill the
blanks, no spam please)> wrote:
Numbers like 1.2 and 2.3 are not integers but floating point numbers or
number with a decimal value.  Try replacing int with float or real:

... (CONVERT(float, [ResultValueCreatinine]) ...

instead of:

... (CONVERT(int, [ResultValueCreatinine]) ...

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

"Mitchell_Collen via AccessMonster.com" <u33726@uwe> wrote in messagenews:80d12e2583081@xxxxxx



I am sorry. What do you mean by floating calculus? The reason that I was
converting to int is because that is what it said in the error. The values
are all basically like 1.2, 2.3, 1.6 and so on. What do you suggest is
best
for these number? I know now, you don't suggest int.
Thanks, Misty

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-adp-sqlserver/200...- Hide quoted text -

- Show quoted text -

.

Relevant Pages

  • Re: Abnormal program termination
    ... foo.c:4: warning: function declaration isn't a prototype ... Your version is legal under C90 rules, but int mainis more explicit ... float ave(), average; ...
    (comp.lang.c)
  • RTF Render with Scale
    ... float fHorzSizeInches = nHorzSize / 25.4f; ... IntPtr hdc = graphics.GetHdc; ... int nHorzSize = SafeNativeMethods.GetDeviceCaps(hdc, ... PHYSICALWIDTH = 110, ...
    (microsoft.public.dotnet.languages.csharp)
  • (part1b) Han from China teaches you C
    ... int flist, mlist, slist; ... float board_size; ... static void draw_tube(float bottom_radius, float top_radius, ... glVertex3f(xmin, ymin, zmax); glVertex3f; ...
    (comp.lang.c)
  • Found a solution so far?
    ... float fHorzSizeInches = nHorzSize / 25.4f; ... IntPtr hdc = graphics.GetHdc; ... int nHorzSize = SafeNativeMethods.GetDeviceCaps(hdc, ... PHYSICALWIDTH = 110, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: RAD vs. performance
    ... work with both int and float. ... name (e.g. "+" for both int and float addition). ... Again, it's a compatibility issue. ... contend that assuming interfaces are equivalent and inferring the most ...
    (comp.lang.misc)