Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Aug 2002
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts

    better solution ? (Access 2000)

    In my code i am setting to null about 12 fields.For example
    sqlString = " Update House SET Street = 0, alley = 0, secondstreet = 0, broker = 0" etc etc.
    can i shorten my code by writing all the fields in brackets and then place the 0 after that?
    For example "(Update Hose,Street,etc)= 0
    I couldnt do it

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: better solution ? (Access 2000)

    No, that is not possible. There would be an alternative if you want to set ALL fields in the House table to 0, but if you want to set some but not all fields to 0, you must list them individually.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: better solution ? (Access 2000)

    You say you're setting them to null, but you are actually setting them to zero. There is a big difference there, so be careful not to confuse the two conditions.
    Charlotte

Posting Permissions

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