Results 1 to 26 of 26

Thread: Update Field In SQL Server

Threaded View

  1. Feb 25th, 2007, 02:50 PM #1
    Paytor
    Paytor is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Oct 2006
    Posts
    322

    Question Update Field In SQL Server

    Hello!

    I have a field in the database where i store the size of some images. The field's type is float. I wan't to be able to update these numbers but i get:Error converting datatype varchar to float. Why?

    This is the code i use:

    str = "UPDATE Table1 SET"
    str = str & ", Size = '" & (Text1.Text) & "' "
    str = str & " WHERE Id = " & (Text2.Text)

    Any ideas? Thank's!
    Last edited by Paytor; Feb 25th, 2007 at 03:05 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width