Results 1 to 2 of 2

Thread: Update Query

  1. Mar 27th, 2001, 12:54 PM #1
    kruks
    kruks is offline

    Thread Starter
    Junior Member
    Join Date
    Jul 2000
    Location
    florida
    Posts
    18
    Hello,I am sure this is easy
    I have an update query in my vb app.now I nees to include a where clause .if the len of the field is less then 14 spaces.
    DBCommand.CommandText = " Update Table Set InternalControlNumber = '0' & InternalControlNumber "
    this is my query I am not sure of the right syntax fro the where clause
    Thank you
    Reply With Quote Reply With Quote
  2. Mar 27th, 2001, 01:03 PM #2
    sjrigby
    sjrigby is offline
    Member
    Join Date
    Oct 2000
    Location
    Bath, England
    Posts
    45
    Here's the syntax as I'm not sure your original code makes sense

    Update tablename Set x = y Where a = b
    SJRigby
    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